Datenbankverbindung:
<?php
$dbHost = "123.456.789.0"; // IP
$dbUser = "xxx"; //User
$dbPass = "xxx"; //Passwort
$dbName = "xxx"; //Datenbank
$sqldb_dr3am3r = mysql_connect($dbHost, $dbUser, $dbPass);
mysql_select_db($dbName, $sqldb_dr3am3r);
?>
User Online:
- Benötigt:
. Datenbankverbindung
<?php
function user_zahl() {
$select = mysql_query("SELECT COUNT(*) as Anzahl FROM `char` WHERE `online` = '1'");
$user_on = mysql_fetch_assoc($select);
echo $user_on['Anzahl'];
}
?>
Server Status:
<?php
function status($ip, $port) {
$status = @fsockopen($ip, $port, $errno, $errstr, 1);
if($status){
echo'ON';
}else{
echo 'OFF';
}
}
?>
item_db konvertieren: SQL > Text
- Benötigt
. Datenbankverbindung
$query = mysql_query("SELECT * FROM item_db");
$temp_str = "";
while($fetch = mysql_fetch_array($query)){
echo $fetch['id'].",".
$fetch['name_english'].",".
$fetch['name_japanese'].",".
$fetch['type'].",".
$fetch['price_buy'].",".
$fetch['weight'].",".
$fetch['attack'].",".
$fetch['defence'].",".
$fetch['range'].",".
$fetch['slots'].",".
$fetch['equip_jobs'].",".
$fetch['equip_upper'].",".
$fetch['equip_locations'].",".
$fetch['weapon_level'].",".
$fetch['equip_level'].",".
$fetch['refineable'].",".
$fetch['view'].",".
$fetch['script'].",".
$fetch['equip_script'].",".
$fetch['unequip_script']."<br/>";
}
?>
Weitere Codes folgen dann noch...
- Codes verändern/verbessern ist erwünscht.