Okay, so does anyone else have this problem at the moment? The tabs/buttons and such in the client? messy text? Anyway to fix that at all?
Also the fix was successful, just missing two super trophies and the public/staff trophies section is messed up a tad.
Anyone willing to provide those fixes?
<?php
$db_host = "localhost"; //Host database
$db_user = "root"; //Nome utente database
$db_pass = "password"; //Password database
$db_database = "database"; //Nome database
$connect = mysql_connect($db_host, $db_user, $db_pass) or die("Could not connect to server, error: ".mysql_error());
$db = mysql_select_db($db_database, $connect) or die("Could not connect to database, error: ".mysql_error());
$sql = mysql_query("select * from ecotron_rewards");
while($sql2 = mysql_fetch_array($sql))
{
$sql4 = $sql2['item_id'];
$cerca = mysql_query("select * from furniture where id = ".$sql4);
$sql3 = mysql_fetch_array($cerca);
$sprite = $sql3['sprite_id'];
$id = $sql2['id'];
$update = mysql_query("update ecotron_rewards set display_id = ".$sprite." where id = ".$id);
if ($update==FALSE) echo("Error item ".$sql4."<br/><br/>");
else echo("Item ".$sql4." Updated<br/><br/>");
}
?>
