Hello just asking... how to make 2 simple queries on a rathena database.
Query 1:
How a sql query on a rAthena database, would be... to remove all the lines into the 'guild_member' table but not the lines that has char guild master that are into the 'guild' table.
the 'char_id' column is common on both tables.
Query 2:
To do a query to set the 'guild_id' column inside the 'char' table to the value = '0' to all the lines but, not the lines that has char guild master into the 'guild' table
Again, the 'char_id' column is common on bot 'char' and 'guild' table on this one.
Why I'm doing this? I'm reducing the max_guild_size of one server, and I need to clean the guild members, so all the guilds will have only 1 member (guild master).
Question
Olrox
Hello just asking... how to make 2 simple queries on a rathena database.
Query 1:
Query 2:
Why I'm doing this? I'm reducing the max_guild_size of one server, and I need to clean the guild members, so all the guilds will have only 1 member (guild master).
Thanks in advance
Edited by Olrox2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.