Hi,
How can i delete all alliance in the server? thx
[Help] Alliance
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 277
- Joined: Fri Apr 17, 2009 2:29 pm
[Help] Alliance
Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
-
- Posts: 277
- Joined: Fri Apr 17, 2009 2:29 pm
Re: [Help] Alliance
Maybe with this?
Code: Select all
UPDATE clan_data SET ally_id = 0;UPDATE clan_data SET ally_name = NULL;UPDATE clan_data SET ally_crest_id = 0;
Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
-
- Posts: 277
- Joined: Fri Apr 17, 2009 2:29 pm
Re: [Help] Alliance
Up 

Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
- janiii
- L2j Veteran
- Posts: 4269
- Joined: Wed May 28, 2008 3:15 pm
- Location: Slovakia
Re: [Help] Alliance
yes, the query wou wrote is fine. i thought somebody answered you, didnt notice it was you 

Code: Select all
UPDATE clan_data SET ally_id = 0, ally_name = NULL, ally_crest_id = 0, ally_penalty_expiry_time = 0, ally_penalty_type = 0;
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!