1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
|
//Überschrift und Text
$subject = "Herzlichen Glückwunsch zum Gebutrstag";
$body = "Wir wollten dir zum Geburtstag ein kleines Präsent überreichen und hoffen,$Bdass es dir bei uns gefällt!!$B$BWir wünschen dir alles Gute und freuen uns auf weitere geminsame Spielstunden mit Dir!";
//Mail INSERT //10 Gold -- Geschenk
$mail_insert="INSERT INTO corelith_characters.mail SET
id = '$id_plus1',
messageType = '0',
stationery = '61',
mailTemplateId = '0',
sender = '69',
receiver = '$reciver',
subject = '$subject',
body = '$body',
has_items = '1',
expire_time = '$timestamp_delete',
deliver_time = '$timestamp_deliver',
money = '100000',
cod = '0',
checked = '$checked' ";
$send_in = mysqli_query($db_chars, $mail_insert);
$do_utf8="UPDATE `corelith_characters.mail` SET
`subject` = REPLACE(`subject`,"ß", "ß"),
`subject` = REPLACE(`subject`, "ä", "ä"),
`subject` = REPLACE(`subject`, "ü", "ü"),
`subject` = REPLACE(`subject`, "ö", "ö"),
`subject` = REPLACE(`subject`, "Ä", "Ä"),
`subject` = REPLACE(`subject`, "Ãœ", "Ü"),
`subject` = REPLACE(`subject`, "Ö", "Ö"),
`subject` = REPLACE(`subject`, "€", "€"),
`body` = REPLACE(`body`,"ß", "ß"),
`body` = REPLACE(`body`, "ä", "ä"),
`body` = REPLACE(`body`, "ü", "ü"),
`body` = REPLACE(`body`, "ö", "ö"),
`body` = REPLACE(`body`, "Ä", "Ä"),
`body` = REPLACE(`body`, "Ãœ", "Ü"),
`body` = REPLACE(`body`, "Ö", "Ö"),
`body` = REPLACE(`body`, "€", "€")
WHERE id LIKE '$id_plus1'";
$utf8_in = mysqli_query($db_chars, $do_utf8); |