BcStorm, dbchecker

Thewicard · May 27, 2013

Just a small php for flaws in your database, More will be added if asked for.
Save it as whatever.php, configure it, and enter it through through a browser.

Code:

<?php
//Configuration
mysql_connect("localhost","root","password"); //Mysql details
mysql_select_db('dbname'); //Database
$password = "pass"; //Your password

//Checks your selection
if (isset($_POST["sjekk"]))
{
$passord = preg_replace('/[^A-Åa-z0-9-b ., c<> d?!]/', '', $_POST['passord']);
if ($passord == $password)
{ $sjekk = preg_replace('/[^0-9]/', '', $_POST['sjekk']); }
else
{ echo "Wrong password.<br><br>"; }
}
if ($sjekk == '')
{
echo '<b>DBChecker v1.10</b><br><br>';
?>
<form method="post">
<input type="radio" name="sjekk" value="1"></input>
User items <font style="color:red;"><b>Heavy</b></font><br>
<input type="radio" name="sjekk" value="2"></input>
Furniture <font style="color:orange;"><b>Average</b></font><br>
<input type="radio" name="sjekk" value="3"></input>
Users <font style="color:orange;"><b>Average</b></font><br>
<br>Password:<br><input type="password" name="passord"></input><br><br>
<input type="submit" value="Check" class="submit">
</form>
<?php
}
//Checks user items
if ($sjekk == '1')
{
// Checks "items" table
$errors = 0;
$getitems = mysql_query("SELECT DISTINCT base_id FROM items") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM items_base WHERE item_id = "'.$res['base_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> base item ".$res['base_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'items': $errors<br><br>";

//Checks "items_users" table (Heavy)
$errors = 0;
$getitems = mysql_query("SELECT * FROM items_users") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM items WHERE item_id = "'.$res['item_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> item ".$res['item_id']." does not exist!<br>";
}
$getbase = mysql_query('SELECT * FROM items WHERE id = "'.$res['item_id'].'" AND placedBy != "'.$res['user_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> item ".$res['item_id']." does not have correct owner!<br>";
}
}
echo "<br>Total errors in table 'items_users': $errors<br><br>";

//Checks "items_moodlight" table
$errors = 0;
$getitems = mysql_query("SELECT * FROM items_moodlight") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM items WHERE item_id = "'.$res['item_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> item ".$res['item_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'items_moodlight': $errors<br><br>";

//Checks "items_rooms" table (Heavy)
$errors = 0;
$getitems = mysql_query("SELECT * FROM items_rooms") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM items WHERE item_id = "'.$res['item_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> item ".$res['item_id']." does not exist!<br>";
}
$getbase = mysql_query('SELECT * FROM rooms WHERE id = "'.$res['room_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> room ".$res['room_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'items_rooms': $errors<br><br>";

//Checks items_rooms_songs table
$errors = 0;
$getitems = mysql_query("SELECT * FROM items_rooms_songs") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM rooms WHERE id = "'.$res['roomid'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> room ".$res['roomid']." does not exist!<br>";
}
$getbase = mysql_query('SELECT * FROM items_base WHERE item_id = "'.$res['baseitem'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> base item ".$res['baseitem']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'items_rooms_songs': $errors<br><br>";
}
//Checks furniture
if ($sjekk == '2')
{
//Checks table items_base_gifts
$errors = 0;
$getitems = mysql_query("SELECT * FROM items_base_gifts") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM items_base WHERE item_id = "'.$res['baseid'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> base id ".$res['baseid']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'items_base_gifts': $errors<br><br>";

//Checks table catalog_items_copy
$errors = 0;
$getitems = mysql_query("SELECT * FROM catalog_items_copy") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM items_base WHERE item_id = "'.$res['item_ids'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> base id ".$res['item_ids']." does not exist!<br>";
}
$getbase = mysql_query('SELECT * FROM catalog_pages WHERE id = "'.$res['page_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> catalog page ".$res['page_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'catalog_items_copy': $errors<br><br>";
}
//Checks users
if ($sjekk == '3')
{
//Checks table user_badges
$errors = 0;
$getitems = mysql_query("SELECT DISTINCT user_id FROM user_badges") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['user_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['user_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_badges': $errors<br><br>";
//Checks table user_achievement
$errors = 0;
$getitems = mysql_query("SELECT DISTINCT userid FROM user_achievement") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['userid'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['userid']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_achievement': $errors<br><br>";
//Checks table user_groups
$errors = 0;
$getitems = mysql_query("SELECT * FROM user_groups") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['UserId'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['UserId']." does not exist!<br>";
}
$getbase = mysql_query('SELECT * FROM groups WHERE Id = "'.$res['GroupId'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> group ".$res['GroupId']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_groups': $errors<br><br>";
//Checks table user_online
$errors = 0;
$getitems = mysql_query("SELECT * FROM user_online") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['userid'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['userid']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_online': $errors<br><br>";
//Checks table user_pets
$errors = 0;
$getitems = mysql_query("SELECT * FROM user_pets") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['user_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['user_id']." does not exist!<br>";
}
$getbase = mysql_query('SELECT * FROM rooms WHERE id = "'.$res['room_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0' AND $res['room_id'] != '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> room ".$res['room_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_pets': $errors<br><br>";
//Checks table user_tags
$errors = 0;
$getitems = mysql_query("SELECT DISTINCT user_id FROM user_tags") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['user_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['user_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_tags': $errors<br><br>";
//Checks table user_volume
$errors = 0;
$getitems = mysql_query("SELECT DISTINCT userid FROM user_volume") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['userid'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['userid']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_volume': $errors<br><br>";
//Checks table user_wardrobe
$errors = 0;
$getitems = mysql_query("SELECT DISTINCT user_id FROM user_wardrobe") or die(mysql_error());
while($res = mysql_fetch_array($getitems)){																												
$getbase = mysql_query('SELECT * FROM users WHERE id = "'.$res['user_id'].'"');
$base_num = mysql_num_rows($getbase);
if ($base_num == '0')
{
$errors = $errors + 1;
echo "<b>Error!</b> user ".$res['user_id']." does not exist!<br>";
}
}
echo "<br>Total errors in table 'user_wardrobe': $errors<br><br>";
}
?>

Thewicard - BcStorm, dbchecker - RaGEZONE Forums

PRIZM · May 27, 2013

Nice one, thank you.

James MGN · May 27, 2013

Would this work with phoenix? Sorry for sounding noobish.

Spheral · May 27, 2013

Seems interesting.

FullmetalPride · May 27, 2013

VERY helpful!

dominic · May 27, 2013

PRIZM said:
Nice one, thank you.

Read the release rules, Prizm. "You may not write "nice release, etc"" :3
What does this do better? Can't be arsed to read code atm ^^

iOmvuZ · May 27, 2013

Nice, could you convert it to Phoenix? Please.

Thewicard · May 27, 2013

Update: Now checks user tables.

FullmetalPride · May 27, 2013

Thewicard said:
Update: Now checks user tables.

Ooo show us a screencap of this. What kinds of errors does it check for?

Thewicard · May 27, 2013

FullmetalPride said:
Ooo show us a screencap of this. What kinds of errors does it check for?

Example outcome, when checking users.

Code:

Error! user 1 does not exist!
Error! user 3 does not exist!
Error! user 17 does not exist!
Error! user 19 does not exist!
Error! user 20 does not exist!
Error! user 21 does not exist!
Error! user 22 does not exist!
Error! user 23 does not exist!
Error! user 24 does not exist!
Error! user 25 does not exist!
Error! user 26 does not exist!
Error! user 27 does not exist!
Error! user 29 does not exist!
Error! user 30 does not exist!
Error! user 31 does not exist!
Error! user 32 does not exist!
Error! user 33 does not exist!
Error! user 34 does not exist!
Error! user 35 does not exist!
Error! user 36 does not exist!
Error! user 37 does not exist!
Error! user 38 does not exist!
Error! user 39 does not exist!
Error! user 40 does not exist!
Error! user 41 does not exist!
Error! user 42 does not exist!
Error! user 43 does not exist!
Error! user 44 does not exist!
Error! user 45 does not exist!
Error! user 46 does not exist!
Error! user 47 does not exist!
Error! user 48 does not exist!
Error! user 50 does not exist!
Error! user 51 does not exist!
Error! user 52 does not exist!
Error! user 53 does not exist!
Error! user 54 does not exist!
Error! user 56 does not exist!
Error! user 57 does not exist!
Error! user 58 does not exist!
Error! user 59 does not exist!
Error! user 60 does not exist!
Error! user 61 does not exist!
Error! user 62 does not exist!
Error! user 63 does not exist!
Error! user 64 does not exist!
Error! user 65 does not exist!
Error! user 66 does not exist!
Error! user 67 does not exist!
Error! user 68 does not exist!
Error! user 69 does not exist!
Error! user 70 does not exist!
Error! user 71 does not exist!
Error! user 72 does not exist!
Error! user 73 does not exist!
Error! user 74 does not exist!
Error! user 76 does not exist!
Error! user 77 does not exist!
Error! user 79 does not exist!
Error! user 80 does not exist!
Error! user 81 does not exist!
Error! user 82 does not exist!
Error! user 83 does not exist!
Error! user 84 does not exist!
Error! user 85 does not exist!
Error! user 86 does not exist!
Error! user 89 does not exist!
Error! user 90 does not exist!
Error! user 91 does not exist!
Error! user 92 does not exist!
Error! user 95 does not exist!
Error! user 98 does not exist!
Error! user 99 does not exist!
Error! user 100 does not exist!
Error! user 101 does not exist!
Error! user 102 does not exist!
Error! user 103 does not exist!
Error! user 104 does not exist!
Error! user 106 does not exist!
Error! user 107 does not exist!
Error! user 108 does not exist!
Error! user 109 does not exist!
Error! user 110 does not exist!
Error! user 111 does not exist!
Error! user 112 does not exist!
Error! user 113 does not exist!
Error! user 114 does not exist!
Error! user 115 does not exist!
Error! user 116 does not exist!
Error! user 117 does not exist!
Error! user 118 does not exist!
Error! user 120 does not exist!
Error! user 121 does not exist!
Error! user 122 does not exist!
Error! user 123 does not exist!
Error! user 124 does not exist!
Error! user 127 does not exist!
Error! user 128 does not exist!
Error! user 130 does not exist!
Error! user 131 does not exist!
Error! user 132 does not exist!
Error! user 133 does not exist!
Error! user 134 does not exist!
Error! user 135 does not exist!
Error! user 136 does not exist!
Error! user 138 does not exist!
Error! user 139 does not exist!
Error! user 140 does not exist!
Error! user 141 does not exist!
Error! user 142 does not exist!
Error! user 143 does not exist!
Error! user 144 does not exist!
Error! user 145 does not exist!
Error! user 147 does not exist!
Error! user 148 does not exist!
Error! user 150 does not exist!
Error! user 151 does not exist!
Error! user 152 does not exist!
Error! user 153 does not exist!
Error! user 154 does not exist!
Error! user 155 does not exist!
Error! user 157 does not exist!
Error! user 158 does not exist!
Error! user 161 does not exist!
Error! user 162 does not exist!
Error! user 163 does not exist!
Error! user 164 does not exist!
Error! user 166 does not exist!
Error! user 167 does not exist!
Error! user 168 does not exist!
Error! user 172 does not exist!
Error! user 173 does not exist!
Error! user 174 does not exist!
Error! user 175 does not exist!
Error! user 176 does not exist!
Error! user 181 does not exist!
Error! user 188 does not exist!
Error! user 406 does not exist!

Total errors in table 'user_badges': 138

Error! user 1 does not exist!
Error! user 2 does not exist!
Error! user 3 does not exist!
Error! user 17 does not exist!
Error! user 19 does not exist!
Error! user 20 does not exist!
Error! user 21 does not exist!
Error! user 22 does not exist!
Error! user 23 does not exist!
Error! user 24 does not exist!
Error! user 25 does not exist!
Error! user 26 does not exist!
Error! user 27 does not exist!
Error! user 29 does not exist!
Error! user 30 does not exist!
Error! user 31 does not exist!
Error! user 32 does not exist!
Error! user 33 does not exist!
Error! user 34 does not exist!
Error! user 35 does not exist!
Error! user 36 does not exist!
Error! user 37 does not exist!
Error! user 38 does not exist!
Error! user 39 does not exist!
Error! user 40 does not exist!
Error! user 41 does not exist!
Error! user 42 does not exist!
Error! user 43 does not exist!
Error! user 44 does not exist!
Error! user 45 does not exist!
Error! user 46 does not exist!
Error! user 47 does not exist!
Error! user 48 does not exist!
Error! user 50 does not exist!
Error! user 51 does not exist!
Error! user 52 does not exist!
Error! user 53 does not exist!
Error! user 54 does not exist!
Error! user 56 does not exist!
Error! user 57 does not exist!
Error! user 58 does not exist!
Error! user 59 does not exist!
Error! user 60 does not exist!
Error! user 61 does not exist!
Error! user 62 does not exist!
Error! user 63 does not exist!
Error! user 64 does not exist!
Error! user 65 does not exist!
Error! user 66 does not exist!
Error! user 67 does not exist!
Error! user 68 does not exist!
Error! user 69 does not exist!
Error! user 70 does not exist!
Error! user 71 does not exist!
Error! user 72 does not exist!
Error! user 73 does not exist!
Error! user 74 does not exist!
Error! user 76 does not exist!
Error! user 77 does not exist!
Error! user 79 does not exist!
Error! user 80 does not exist!
Error! user 81 does not exist!
Error! user 82 does not exist!
Error! user 83 does not exist!
Error! user 84 does not exist!
Error! user 85 does not exist!
Error! user 86 does not exist!
Error! user 89 does not exist!
Error! user 90 does not exist!
Error! user 91 does not exist!
Error! user 92 does not exist!
Error! user 95 does not exist!
Error! user 98 does not exist!
Error! user 99 does not exist!
Error! user 100 does not exist!
Error! user 101 does not exist!
Error! user 102 does not exist!
Error! user 103 does not exist!
Error! user 104 does not exist!
Error! user 106 does not exist!
Error! user 107 does not exist!
Error! user 108 does not exist!
Error! user 109 does not exist!
Error! user 110 does not exist!
Error! user 111 does not exist!
Error! user 112 does not exist!
Error! user 113 does not exist!
Error! user 114 does not exist!
Error! user 115 does not exist!
Error! user 116 does not exist!
Error! user 117 does not exist!
Error! user 118 does not exist!
Error! user 120 does not exist!
Error! user 121 does not exist!
Error! user 122 does not exist!
Error! user 123 does not exist!
Error! user 124 does not exist!
Error! user 127 does not exist!
Error! user 128 does not exist!
Error! user 130 does not exist!
Error! user 131 does not exist!
Error! user 132 does not exist!
Error! user 133 does not exist!
Error! user 134 does not exist!
Error! user 135 does not exist!
Error! user 136 does not exist!
Error! user 138 does not exist!
Error! user 139 does not exist!
Error! user 140 does not exist!
Error! user 141 does not exist!
Error! user 142 does not exist!
Error! user 143 does not exist!
Error! user 144 does not exist!
Error! user 145 does not exist!
Error! user 147 does not exist!
Error! user 148 does not exist!
Error! user 150 does not exist!
Error! user 151 does not exist!
Error! user 152 does not exist!
Error! user 153 does not exist!
Error! user 154 does not exist!
Error! user 155 does not exist!
Error! user 157 does not exist!
Error! user 158 does not exist!
Error! user 161 does not exist!
Error! user 162 does not exist!
Error! user 163 does not exist!
Error! user 164 does not exist!
Error! user 166 does not exist!
Error! user 167 does not exist!
Error! user 168 does not exist!
Error! user 172 does not exist!
Error! user 173 does not exist!
Error! user 174 does not exist!
Error! user 175 does not exist!
Error! user 176 does not exist!
Error! user 181 does not exist!
Error! user 188 does not exist!
Error! user 406 does not exist!

Total errors in table 'user_achievement': 139


Total errors in table 'user_groups': 0


Total errors in table 'user_online': 0

Error! user 1 does not exist!
Error! user 2 does not exist!
Error! room 59 does not exist!
Error! user 1 does not exist!
Error! user 3 does not exist!
Error! room 71 does not exist!
Error! user 3 does not exist!
Error! user 17 does not exist!
Error! room 72 does not exist!
Error! user 17 does not exist!
Error! user 21 does not exist!
Error! user 21 does not exist!
Error! user 24 does not exist!
Error! user 30 does not exist!
Error! user 38 does not exist!
Error! user 30 does not exist!
Error! user 30 does not exist!
Error! user 30 does not exist!
Error! user 41 does not exist!
Error! user 37 does not exist!
Error! room 93 does not exist!
Error! user 30 does not exist!
Error! user 37 does not exist!
Error! user 41 does not exist!
Error! user 65 does not exist!
Error! user 70 does not exist!
Error! room 119 does not exist!
Error! user 41 does not exist!
Error! user 41 does not exist!
Error! user 41 does not exist!
Error! user 71 does not exist!
Error! room 121 does not exist!
Error! user 72 does not exist!
Error! room 122 does not exist!
Error! user 45 does not exist!
Error! user 80 does not exist!
Error! room 132 does not exist!
Error! user 84 does not exist!
Error! room 136 does not exist!
Error! user 112 does not exist!
Error! room 153 does not exist!
Error! user 122 does not exist!
Error! user 138 does not exist!
Error! user 144 does not exist!
Error! room 168 does not exist!
Error! user 150 does not exist!
Error! room 171 does not exist!
Error! user 173 does not exist!
Error! room 188 does not exist!
Error! user 188 does not exist!
Error! user 188 does not exist!
Error! room 192 does not exist!
Error! user 188 does not exist!
Error! user 188 does not exist!
Error! user 188 does not exist!
Error! room 200 does not exist!
Error! room 453 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 522 does not exist!
Error! room 824 does not exist!
Error! room 983 does not exist!
Error! room 983 does not exist!
Error! room 1016 does not exist!
Error! room 1016 does not exist!
Error! room 1057 does not exist!
Error! room 1057 does not exist!
Error! room 1221 does not exist!

Total errors in table 'user_pets': 75


Total errors in table 'user_tags': 0

Error! user 30 does not exist!
Error! user 41 does not exist!
Error! user 59 does not exist!
Error! user 70 does not exist!
Error! user 90 does not exist!
Error! user 122 does not exist!
Error! user 188 does not exist!

Total errors in table 'user_volume': 7

Error! user 29 does not exist!
Error! user 30 does not exist!
Error! user 64 does not exist!
Error! user 142 does not exist!
Error! user 188 does not exist!

Total errors in table 'user_wardrobe': 5

And when checking furniture.

Code:

Error! base id 3090 does not exist!
Error! base id 3091 does not exist!

Total errors in table 'items_base_gifts': 2

Error! catalog page 9999 does not exist!
Error! catalog page 615 does not exist!
Error! catalog page 7 does not exist!
Error! catalog page 7 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 63 does not exist!
Error! catalog page 661053 does not exist!
Error! catalog page 7 does not exist!
Error! catalog page 20 does not exist!
Error! catalog page 85 does not exist!
Error! catalog page 85 does not exist!
Error! catalog page 85 does not exist!
Error! catalog page 85 does not exist!
Error! catalog page 85 does not exist!
Error! catalog page 85 does not exist!
Error! catalog page 16 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 101232 does not exist!
Error! catalog page 101232 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!
Error! catalog page 9999 does not exist!

Total errors in table 'catalog_items_copy': 48

And when checking User items. (which takes lots of time)

Code:

Error! base item 2794 does not exist!
Error! base item 2801 does not exist!

Total errors in table 'items': 2

Error! item 99270 does not exist!
Error! item 99271 does not exist!
Error! item 99272 does not exist!
Error! item 102358 does not exist!
Error! item 186789 does not exist!
Error! item 186808 does not exist!

Total errors in table 'items_users': 6


Total errors in table 'items_moodlight': 0

Error! item 88965 does not exist!

Total errors in table 'items_rooms': 1

Error! room 618 does not exist!
Error! room 742 does not exist!
Error! room 742 does not exist!
Error! room 1111 does not exist!
Error! room 1111 does not exist!
Error! room 1067 does not exist!

Total errors in table 'items_rooms_songs': 6

Imagician · May 27, 2013

Why u dont make a converter script from phoenix to butterfly or bcstorm?

xMiraclesz · May 28, 2013

Nice one, thanks!

Xversion · May 30, 2013

Might use this on my CMS, Cheers.

Mithex · May 31, 2013

You should make v1.2 fix the db automatically.

BcStorm, dbchecker

Thewicard

Newbie Spellweaver

PRIZM

Zephyr Studios

James MGN

Skilled Illusionist

Spheral

Eye Eye Capt'n

FullmetalPride

Ask me about Daoism

dominic

j’aime ma famille

iOmvuZ

Newbie Spellweaver

Thewicard

Newbie Spellweaver

FullmetalPride

Ask me about Daoism

Thewicard

Newbie Spellweaver

Imagician

Socius Decennalis

xMiraclesz

Junior Spellweaver

Xversion

Junior Spellweaver

Mithex

Thanks for the memories!

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners