[Help] Alliance

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Mage
Posts: 277
Joined: Fri Apr 17, 2009 2:29 pm

[Help] Alliance

Post by Mage »

Hi,

How can i delete all alliance in the server? thx
Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
Mage
Posts: 277
Joined: Fri Apr 17, 2009 2:29 pm

Re: [Help] Alliance

Post by Mage »

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.
Mage
Posts: 277
Joined: Fri Apr 17, 2009 2:29 pm

Re: [Help] Alliance

Post by Mage »

Up :)
Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
User avatar
janiii
L2j Veteran
L2j Veteran
Posts: 4269
Joined: Wed May 28, 2008 3:15 pm
Location: Slovakia

Re: [Help] Alliance

Post by janiii »

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!
Post Reply