Please Script SQL for login of member guilds and delete you guilds

[Helly]

hiii~ im here to ask you for an script i mean let me expose my problem, we make a clean of guilds from sql table, that make us a problem, yep, cause we forget the little thing of guild id in the character sql... so now.. we are taking a trouble couse that make the server crash some times, because the players have a wrong guild id! i mean they have the old guild id! then talking with my boyfriend we thing that an sql script can fix it, im mean we don't have so much knowledge of sql scripting, but we really need it, what i need is an npc that when log in clean the guild id teable and make a variable for the next login that makes that is the character get te clean do not clean it again every log in, cand you make it for uss?! of course we will pay your work! Please tell me if you can make it for me ass soon as possible!!(sorry for my english)

[Brian]

Here is the proper way to delete all guilds:

1. stop all 3 servers (login, char, map)
   
2. connect to your MySQL server and execute these queries
   This will delete all guilds, reset all castles to no owner (and 0 economy & defense), and empty all guild storages!
   

   TRUNCATE TABLE `guild`;
   TRUNCATE TABLE `guild_alliance`;
   TRUNCATE TABLE `guild_castle`;
   TRUNCATE TABLE `guild_expulsion`;
   TRUNCATE TABLE `guild_member`;
   TRUNCATE TABLE `guild_position`;
   TRUNCATE TABLE `guild_skill`;
   TRUNCATE TABLE `guild_storage`;
   
   UPDATE `char` SET `guild_id`=0;