ArcEmu: Delete Double Spawns, Clean Database, And More. - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Delete Double Spawns, Clean Database, And More.

#1 User is offline   Marforius 

  • Permanantly on leave
  • PipPipPipPip
  • Group: Members
  • Posts: 597
  • Joined: 07-August 08
  • IRC:Marforius
  • Gender:Male
  • Location:Rome
  • Interests:ArcEmulatorius
  • Server OS:Linux

Posted 17 March 2010 - 09:40 PM

DELETE FROM `characters` WHERE `acct` NOT IN (SELECT `acct` FROM `accounts`);
DELETE FROM `playeritems` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `mailbox` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `playercooldowns` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `playerpets` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `playerpetspells` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `playersummons` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `playersummonspells` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `questlog` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `social_friends` WHERE `character_guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `social_ignores` WHERE `character_guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `gm_tickets` WHERE `playerGuid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `corpses` WHERE `guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `character_achievement` WHERE `guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `character_achievement_progress` WHERE `guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `arenateams` WHERE `leader` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `auctions` WHERE `owner` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `charters` WHERE `leaderGuid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `guilds` WHERE `leaderGuid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `guild_bankitems` WHERE `guildId` NOT IN (SELECT `guildId` FROM `guilds`);
DELETE FROM `guild_banklogs` WHERE `guildid` NOT IN (SELECT `guildId` FROM `guilds`);
DELETE FROM `guild_banktabs` WHERE `guildId` NOT IN (SELECT `guildId` FROM `guilds`);
DELETE FROM `guild_data` WHERE `guildid` NOT IN (SELECT `guildId` FROM `guilds`);
DELETE FROM `guild_logs` WHERE `guildid` NOT IN (SELECT `guildId` FROM `guilds`);
DELETE FROM `guild_ranks` WHERE `guildId` NOT IN (SELECT `guildId` FROM `guilds`);
DELETE FROM `playeritems` WHERE `entry` NOT IN (SELECT `entry` FROM `items`);
DELETE FROM `creature_names` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_proto`);
DELETE FROM `creature_proto` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_names`);
DELETE FROM `vendors` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_names`);
DELETE FROM `vendors` WHERE `item` NOT IN (SELECT `entry` FROM `items`);
DELETE FROM `tutorials` WHERE `playerId` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `gameobject_spawns` WHERE `entry` NOT IN (SELECT `entry` FROM `gameobject_names`);
DELETE FROM `creature_spawns` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_names`);
DELETE FROM `creature_waypoints` WHERE `spawnid` NOT IN (SELECT `id` FROM `creature_spawns`);
DELETE FROM `gameobject_spawns` WHERE `entry` NOT IN (SELECT `entry` FROM `gameobject_names`);
DELETE FROM `creature_waypoints` WHERE `spawnid` NOT IN (SELECT `id` FROM `creature_spawns`);
DELETE FROM `creature_spawns` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_names`);
DELETE FROM `loot_creatures` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);
DELETE FROM `loot_gameobjects` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);
DELETE FROM `npc_gossip_textid` WHERE `creatureid` NOT IN (SELECT `entry` FROM `creature_names`);
DELETE FROM `npc_monstersay` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_names`);
DELETE FROM `items` WHERE `displayid` = 0;
DELETE FROM `creature_spawns` WHERE `entry` = 29238;
DELETE FROM `gameobject_spawns` WHERE `entry` = 187235;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178433;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178558;
DELETE FROM `gameobject_spawns` WHERE `entry` = 190006;
DELETE FROM `gameobject_spawns` WHERE `entry` = 17851;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180796;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178667;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178746;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178429;
DELETE FROM `gameobject_spawns` WHERE `entry` = 190003;
DELETE FROM `gameobject_spawns` WHERE `entry` = 187567;
DELETE FROM `gameobject_spawns` WHERE `entry` = 179968;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180353;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180471;
DELETE FROM `gameobject_spawns` WHERE `entry` = 186075;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180472;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180427;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180426;
DELETE FROM `gameobject_spawns` WHERE `entry` = 180406;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178430;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178432;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178438;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178554;
DELETE FROM `gameobject_spawns` WHERE `entry` = 178671;
DELETE FROM `gameobject_spawns` WHERE `entry` = 190005;
update vendors set amount = 1 where amount = -1;
update vendors set amount = 1 where amount = 0;
update creature_proto set faction = 35 where faction = 1741;
update creature_proto set faction = 35 where faction = 1604;
update creature_proto set faction = 35 where faction = 1603;
update creature_proto set faction = 35 where faction = 1734;
update creature_proto set faction = 35 where faction = 1641;
update creature_proto set faction = 35 where faction = 1602;

CREATE TABLE creature_spawns1 as
SELECT * FROM creature_spawns WHERE 1 GROUP BY position_x,position_y;

CREATE TABLE creature_spawns2 as
SELECT * FROM creature_spawns1 WHERE 1 GROUP BY id;

CREATE TABLE gameobject_spawns1 as
SELECT * FROM gameobject_spawns WHERE 1 GROUP BY position_x,position_y,position_z;

CREATE TABLE gameobject_spawns2 as
SELECT * FROM gameobject_spawns1 WHERE 1 GROUP BY id;

CREATE TABLE creature_proto1 as
SELECT * FROM creature_proto WHERE 1 GROUP BY entry;

DROP TABLE IF EXISTS creature_spawns,creature_spawns1,gameobject_spawns,gameobject_spawns1,creature_proto;

RENAME TABLE gameobject_spawns2 TO gameobject_spawns;
RENAME TABLE creature_spawns2 TO creature_spawns;
RENAME TABLE creature_proto1 TO creature_proto;



Updated 6/25/2010
Consolidated. Remember to set what type of database the checked tables is.
0

#2 User is offline   Marforius 

  • Permanantly on leave
  • PipPipPipPip
  • Group: Members
  • Posts: 597
  • Joined: 07-August 08
  • IRC:Marforius
  • Gender:Male
  • Location:Rome
  • Interests:ArcEmulatorius
  • Server OS:Linux

Posted 11 September 2010 - 02:38 PM

Updating this, and the post is old
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users