Support:Database Cleanup: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann No edit summary |
imported>Hendrik Brummermann No edit summary |
||
| Line 34: | Line 34: | ||
=== Cleanup Script === |
=== Cleanup Script === |
||
<source lang="sql> |
<source lang="sql"> |
||
INSERT INTO del2 SELECT charname FROM del WHERE items='0 leather_armor, 0 club'; |
INSERT INTO del2 SELECT charname FROM del WHERE items='0 leather_armor, 0 club'; |
||
INSERT INTO del2 SELECT charname FROM del WHERE items='0 club, 0 leather_armor'; |
INSERT INTO del2 SELECT charname FROM del WHERE items='0 club, 0 leather_armor'; |
||
INSERT INTO del2 SELECT charname FROM del WHERE items='0 leather armor, 0 club'; |
|||
INSERT INTO del2 SELECT charname FROM del WHERE items='0 club, 0 leather armor'; |
|||
| Line 43: | Line 45: | ||
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_02_19 WHERE charname=source); |
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_02_19 WHERE charname=source); |
||
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_08_17 WHERE charname=source); |
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_08_17 WHERE charname=source); |
||
DELETE FROM del2 WHERE EXISTS (SELECT null FROM itemlog WHERE charname = source); |
|||
</source> |
</source> |
||