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: