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);

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

$dbi = new mysqli($sqlhost, $sqluser, $sqlpassword, $sqldb, $phpversion);

$stmt = $dbi->prepare("SELECT id , name , message , time  FROM `bb".$n."_hm_guestbook` ORDER BY time DESC ");
$stmt->execute();
$stmt->bind_result($id_mess ,$name1 , $mess ,$time );
$stmt->fetch();
                    while($stmt->fetch()) {
$id_mess = ($id_mess + 1);
        $stmt->store_result($name1 , $mess , $time);      // Liefert das Ergebnis zum Browser
		$stamp = date("d-m-Y \u\m H:i:s", $time);
		eval("\$hm_ownbox_guestbook_bit = "".$tpl->get("hm_ownbox_guestbook_bit")."";"); 
					}

1:

$stmt->execute()

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:
45:
46:
47:

//###############################################################################
//##########################HM_Gästebuch by Hangasilly###########################
//###############################################################################

//##################################ALLGEMEINES##################################
//User-ID
$user_id = $wbbuserdata['userid'];
//UserName oder Name eingeben
if($user_id != 0){
	$gb_name = $wbbuserdata['username'];
}
if($user_id == 0){
if (isset($_GET["gb_name"])) {
    $gb_name = $_GET["gb_name"];
}
}
//Nachricht
if (isset($_GET["gb_message"])) {
    $gb_message = $_GET["gb_message"];
}

//##################################EINTRAG##################################
if(isset($_POST['action']) == "gb") {
		$message = $gb_message;
		$username = $gb_name;
		$zeit = time();
//Insert
		$new_gb = "INSERT INTO `bb".$n."_hm_guestbook` VALUES ('', '$username','$message','$zeit')";
		$new_gb_in = mysql_query($new_gb);
}	

//##################################OUTPUT##################################
//Einträge auslesen
$anzg = "SELECT * FROM `bb".$n."_hm_guestbook` ";
$anz = mysql_query($anzg);
	while($ds = mysql_fetch_assoc($anz)){
		$name1 = $ds[name];
		$mess = $ds[message];
		$time = $ds[time];
		$stamp = date("d-m-Y \u\m H:i:s", $time);

	eval("\$hm_ownbox_guestbook_bit = "".$tpl->get("hm_ownbox_guestbook_bit")."";"); 
}
eval("\$tpl->output("".$tpl->get("hm_ownbox_guestbook")."");");
//###############################################################################
//##########################HM_Gästebuch by Hangasilly###########################
//####################################ENDE#######################################

1:

!preg_match

1:
2:

$curl und $_GET

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:

<?php
$filename="shop2_data_out.php";

//Datenbank
$db = mysqli_connect("localhost", "user", "pw", "DATABASExxx");


//Datei öffnen und prüfen
$txt= fopen("chars.txt", "w");
if( !$txt )
{
  die("Datei zum exportieren konnte nicht geöffnet werden");
}

//Name und guID des Acc
$Name_guID_out = "SELECT `guid`, `name` FROM DATABASExxx.characters WHERE `account` LIKE '17' "; 

$Name_u_guID = mysql_query($$Name_guID_out);
while($row=mysql_fetch_row($Name_u_guID))
{
  $txtLine = implode( '<br />' , $row );
 

//Neue Zeile anhängen
  fputs( $txt, "$txtLine\n" );
}

//Datei schliessen und speichern
fclose( $txt );
?>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

 
SELECT * INTO OUTFILE 'data.txt'
  FIELDS TERMINATED BY ','
  FROM table2;


Und


LOAD DATA INFILE 'data.txt' INTO TABLE table2
  FIELDS TERMINATED BY ',';