View Single Post
  #5  
Old 10-24-2008, 04:16 PM
spoon
Sarnak
 
Join Date: Aug 2007
Posts: 34
Default

If you only want to remove them from the loot tables use:

to see what there are:
Code:
SELECT
	`items`.`id`
FROM
	`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reclevel` > 60;
Code:
SELECT
	`items`.`id`
FROM
	`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reqlevel` > 60;
to delete:

Code:
DELETE
	`lootdrop_entries`
FROM
		`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reclevel` > 60;
and

Code:
DELETE
	`lootdrop_entries`
FROM
		`lootdrop_entries`
	LEFT JOIN
		`items`
	ON `lootdrop_entries`.`item_id` = `items`.`id`
WHERE
	`items`.`reqlevel` > 60;
Reply With Quote