Promotion for all players

[cooper64]

Is there an sql quary that I can execute to make this happen?
Thanks

 

[Ldrozd]

EDIT:
#down
right, Zonet

 

[Zonet]

UPDATE players SET promotion = 1;

 

[cooper64]

Thank you sir

 

[cooper64]

Ok that changed all the current players to promoted, but how can I make new players promoted with out entering the quarry everytime someone new joins?

 

[Norix]

Go to accountmanagement.php and search for this:

$player->setVocation($char_to_copy->getVocation());

and add the following under:

				    $player->setPromotion($char_to_copy->getPromotion());

Your's Norix

 

[cooper64]

Im sorry, how do I get to accountmanagement.php?

 

[Norix]

It's a file in the htdocs folder. Just open it with Notepad or sth..

 

[cooper64]

Ok great , thanks. I found another way also I think. I browsed the structure in phpmyadmin, and went to promotion and changed the default to 1 instead of 0- Do you think this will create any problems?

 

[Norix]

This won't create any problems but i don't know if it works without adding my line in accountmanagement.php, just try and if not, add the line

 

[Zonet]

He could simply do it in config.php or in creaturescript/scripts/login.lua under function onLogin(cid) add

if(getPlayerPromotionLevel(cid) ~= 1) then
	doPlayerSetPromotionLevel(cid, 1)
end