• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[PHP] Player Deaths database converter

Lancerz

New Member
Joined
Jan 22, 2008
Messages
17
Reaction score
0
PHP:
 Player Deaths table converter[/b]

[PHP]
<?
mysql_connect("localhost", "root", "");
mysql_select_db("theforgottenserver");

mysql_query("CREATE TABLE `player_deaths_backup` (
  `player_id` int(11) NOT NULL,
  `time` bigint(20) NOT NULL default '0',
  `level` int(1) NOT NULL default '1',
  `killed_by` varchar(255) NOT NULL,
  `is_player` tinyint(1) NOT NULL default '1'
  )  ENGINE = InnoDB;") or die(mysql_error());
  
mysql_query("INSERT INTO `player_deaths_backup`
SELECT *
FROM `player_deaths`;") or die(mysql_error());

mysql_query("CREATE TABLE `player_deaths2` (
  `player_id` int(11) NOT NULL,
  `time` bigint(20) NOT NULL default '0',
  `level` int(1) NOT NULL default '1',
  `killed_by` varchar(255) NOT NULL
  )  ENGINE = InnoDB;") or die(mysql_error());
  
$query = mysql_query("SELECT * FROM player_deaths");

while($fetch = mysql_fetch_array($query)){

$name = $fetch['killed_by'];

$existe = mysql_query("SELECT * FROM `players` where `name` = '".$name."' LIMIT 1");
$array = mysql_fetch_array($existe);

if(mysql_num_rows($existe) > 0){

mysql_query("INSERT INTO `player_deaths2` (player_id,time,level,killed_by) values ('".$fetch['player_id']."','".$fetch['time']."','".$fetch['level']."', '".$array['id']."')") or die(mysql_error());

}else {
mysql_query("INSERT INTO `player_deaths2` (player_id,time,level,killed_by) values ('".$fetch['player_id']."','".$fetch['time']."','".$fetch['level']."', '".$fetch['killed_by']."')") or die(mysql_error());

}

}

@mysql_query("DROP TABLE `player_deaths`;");
@mysql_query("RENAME TABLE `player_deaths2` TO `player_deaths`;");

echo 'Player Deaths Updated.';
?>

Description: It converts table player_deaths from 0.2 to trunk 0.3
 
Last edited:
Back
Top