Y esto como se ejecuta?

[gnzsoloyo]

Iniciado por Jose789

Código PHP:

<?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`));  
 
?>
 

Esto no es un script de PHP, ni tampoco de MySQL. Es un híbrido que no sirve para nada.
¿Te queda claro que no puedes poner sentencias SQL puras en un script de PHP?
No se trata del mismo lenguaje, y PHP no interpreta SQL, como MySQL no interpreta PHP. Son universos distintos.
PHP envía sentencias de SQL al DBMS por medio de librerías específicas de acceso a BBDD, no las ejecuta por si mismo...

No te borro el script, solamente para que en el foro de pHP puedan darte lecciones sobre el uso de sentencias SQL desde PHP (interaccion de un lenguaje con la base de datos), y no tengas que volver a postear todo.
Pero, por favor, lee las normas del foro de Bases de Datos: No se permite postear código de programación en los foros de BBDD o sus suforos.
¿Te queda claro?

Movido a Foro de PHP