<?php
include('./kernel/config.php');
#Deletes achievements from non-existant users
DELETE FROM user_achievements WHERE
user_achievements.user_id NOT IN
(SELECT id FROM users where users.id =user_achievements.user_id);
#Deletes effects from non-existant users
DELETE FROM user_effects WHERE
user_effects.user_id NOT IN
(SELECT id FROM users where users.id =user_effects.user_id);
#Deletes badges from non-existant users
DELETE FROM user_badges WHERE
user_badges.user_id NOT IN
(SELECT id FROM users where users.id =user_badges.user_id);
#Deletes favorites from non-existant users
DELETE FROM user_favorites WHERE
user_favorites.user_id NOT IN
(SELECT id FROM users where users.id = user_favorites.user_id);
#Deletes favorites from non-existant rooms
DELETE FROM user_favorites WHERE
user_favorites.room_id NOT IN
(SELECT id FROM rooms where rooms.id = user_favorites.room_id);
#Deletes info from non-existant users
DELETE FROM user_info WHERE
user_info.user_id NOT IN
(SELECT id FROM users where users.id = user_info.user_id);
#Deletes pets from non-existant users
DELETE FROM user_pets WHERE
user_pets.user_id NOT IN
(SELECT id FROM users where users.id = user_pets.user_id);
#Deletes pets from non-existant rooms
DELETE FROM user_pets WHERE
user_pets.room_id NOT IN
(SELECT id FROM rooms where rooms.id = user_pets.room_id);
#Deletes non-existant presents
DELETE FROM user_presents WHERE
user_presents.item_id NOT IN
(SELECT id FROM items where items.id = user_presents.item_id);
#Deletes quests from non-existant users
DELETE FROM user_quests WHERE
user_quests.user_id NOT IN
(SELECT id FROM users where users.id = user_quests.user_id);
#Deletes roomvisits from non-existant users
DELETE FROM user_roomvisits WHERE
user_roomvisits.user_id NOT IN
(SELECT id FROM users where users.id = user_roomvisits.user_id);
#Deletes roomvisits from non-existant rooms
DELETE FROM user_roomvisits WHERE
user_roomvisits.room_id NOT IN
(SELECT id FROM rooms where rooms.id = user_roomvisits.room_id);
#Deletes stats from non-existant users
DELETE FROM user_stats WHERE
user_stats.id NOT IN
(SELECT id FROM users where users.id = user_stats.id);
#Deletes subscriptions from non-existant users
DELETE FROM user_subscriptions WHERE
user_subscriptions.user_id NOT IN
(SELECT id FROM users where users.id = user_subscriptions.user_id);
#Deletes tags from non-existant users
DELETE FROM user_tags WHERE
user_tags.user_id NOT IN
(SELECT id FROM users where users.id = user_tags.user_id);
#Deletes wardrobe from non-existant users
DELETE FROM user_wardrobe WHERE
user_wardrobe.user_id NOT IN
(SELECT id FROM users where users.id = user_wardrobe.user_id);
#Deletes non-existant wired_items
DELETE FROM wired_items WHERE
wired_items.item_id NOT IN
(SELECT id FROM items where items.id = wired_items.item_id);
#Deletes non-existant teleports(1)
DELETE FROM tele_links WHERE
tele_links.tele_one_id NOT IN
(SELECT id FROM items where items.id = tele_links.tele_one_id);
#Deletes non-existant teleports(2)
DELETE FROM tele_links WHERE
tele_links.tele_two_id NOT IN
(SELECT id FROM items where items.id = tele_links.tele_two_id);
#Deletes bans from non-existant users
DELETE FROM bans WHERE
(bans.bantype = 'user' AND
bans.`value` NOT IN
(SELECT username FROM users where users.username = bans.`value`));
#Deletes chatlogs from non-existant users
DELETE FROM chatlogs WHERE
chatlogs.user_id NOT IN
(SELECT id FROM users where users.id = chatlogs.user_id);
#Deletes chatlogs from non-existant rooms
DELETE FROM chatlogs WHERE
chatlogs.room_id NOT IN
(SELECT id FROM rooms where rooms.id = chatlogs.room_id);
#Deletes rights from non-existant users
DELETE FROM room_rights WHERE
room_rights.user_id NOT IN
(SELECT id FROM users where users.id = room_rights.user_id);
#Deletes rights from non-existant rooms
DELETE FROM room_rights WHERE
room_rights.room_id NOT IN
(SELECT id FROM rooms where rooms.id = room_rights.room_id);
#Deletes bots from non-existant rooms
DELETE FROM bots WHERE
bots.room_id NOT IN
(SELECT id FROM rooms where rooms.id = bots.room_id);
#Deletes responses from non-existant bots
DELETE FROM bots_responses WHERE
bots_responses.bot_id NOT IN
(SELECT id FROM bots where bots.id = bots_responses.bot_id);
#Deletes speech from non-existant bots
DELETE FROM bots_speech WHERE
bots_speech.bot_id NOT IN
(SELECT id FROM bots where bots.id = bots_speech.bot_id);
#Deletes non-existant moodlights
DELETE FROM room_items_moodlight WHERE
room_items_moodlight.item_id NOT IN
(SELECT id FROM items where items.id = room_items_moodlight.item_id);
#Deletes messenger_friendships from non-existant users
DELETE FROM messenger_friendships WHERE
user_one_id NOT IN
(SELECT id FROM users where users.id =user_one_id);
DELETE FROM messenger_friendships WHERE
user_two_id NOT IN
(SELECT id FROM users where users.id =user_two_id);
#Deletes user_ignores from non-existant users
DELETE FROM user_ignores WHERE
user_id NOT IN
(SELECT id FROM users where users.id =user_id);
DELETE FROM user_ignores WHERE
ignore_id NOT IN
(SELECT id FROM users where users.id =ignore_id);
#Deletes items from non-existant rooms
DELETE FROM items WHERE
(items.room_id >= 0 AND
items.room_id NOT IN
(SELECT id FROM rooms where rooms.id = items.room_id));
#Deletes items from non-existant users
DELETE FROM items WHERE
items.user_id NOT IN
(SELECT id FROM users where users.id =items.user_id);
#Deletes rooms from non-existant users
DELETE FROM rooms WHERE
(rooms.roomtype = 'private' AND
rooms.`owner` NOT IN
(SELECT username FROM users where users.username = rooms.`owner`));
?>