[REQ]With nation web!

Results 1 to 4 of 4
  1. #1
    Apprentice camplesg is offline
    MemberRank
    Dec 2006 Join Date
    20Posts

    [REQ]With nation web!

    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


  2. #2
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: [REQ]With nation web!

    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.

  3. #3
    The Elder | Voinic mirceagab is offline
    MemberRank
    Aug 2008 Join Date
    Cluj-Napoca, RoLocation
    221Posts

    Re: [REQ]With nation web!

    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

  4. #4
    Akaruz - The Legend [hidden] is offline
    MemberRank
    Jun 2006 Join Date
    ClassifiedLocation
    1,120Posts

    Re: [REQ]With nation web!

    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'



Advertisement