Sql Query + Enforced.

[dukzin]

Hello.
I'm Making A Enforced Server.
So I Have Som Problems.

#Query Done.
Thanks CYBERM.

#Enforced.
Hello If Player 1 Kills Player 2. He Get Levels.
But If Player 2 Come After Player 1 Killed Him.
And Kill Player 1 He Doesn't Get Exp.

¹. Already in 'hardcore' on pvp mode.
². Experience from players is 150.

As i said, I'ts mysql.

Would Be Thankful.

 

[dukzin]

bump+

Query to take everbody Promoted?

WHAT's WRONG:
UPDATE `players` SET `posx` = 1063 WHERE `account_id` = "9"
UPDATE `players` SET `posy` = 607 WHERE `account_id` = "9"
UPDATE `players` SET `posz` = 7 WHERE `account_id` = "9"

 

[hodleo]

I'ts 7 Accounts. How Can I Set All Team Outfit, Temple Only By Account?
Something As: If Account 1 Set Outfit 1 and Temple 1

UPDATE `players` SET `town_id` = 1, `looktype` = 10, `lookhead` = 10, `looklegs` = 10, `looktype` = 30, `lookaddons` = 0 WHERE `account_id` = 1;

And, Why can i make to dont save de chars? (MYSQL)

UPDATE `players` SET `save` = 0 WHERE `account_id` = 1;

Query to take everbody Promoted?

UPDATE `players` SET `promotion` = 1 WHERE `account_id` = 1;

WHAT's WRONG:
UPDATE `players` SET `posx` = 1063 WHERE `account_id` = "9"
UPDATE `players` SET `posy` = 607 WHERE `account_id` = "9"
UPDATE `players` SET `posz` = 7 WHERE `account_id` = "9"

UPDATE `players` SET `posx` = 1063, `posy` = 607, `posz` = 7 WHERE `account_id` = 9;

 

[Prest]

Impressive, nice job CyberM

 

[dukzin]

Thanks,
Query's Done.

I NEED THE ENFORCED CONFIG.

new problem
http://otland.net/f132/compile-problem-110606/