[REQ]With nation web!

[camplesg]

can any1 help me with nation web, so i can let other player choose nation by using my website, so they dont have to do quest plz. THX

[MentaL]

[chumpywumpy]

All you need is a simple SQL "update" query to update their nation to 1 or 2. WHat help is it that you need as you don't actually say.

[mirceagab]

i understand the logic but beeing a noob i don't know how to put it in practic.
So the update would probably go in a trigger activated by the site right?
How do i do that

[[hidden]]

here you go. a simple query that will work even if you have millions of characters ^^

use gamedb;
update cabal_character_table
set nation = 1
where characteridx like '%1' or characteridx like '%3' or characteridx like '%5' or characteridx like '%7' or characteridx like '%9'


use gamedb;
update cabal_character_table
set nation = 2
where characteridx like '%0' or characteridx like '%2' or characteridx like '%4' or characteridx like '%6' or characteridx like '%8'