[HELP] MSSQL script for char reset 1 reset= 20 mil, 2 reset= 40 mil and etc

Results 1 to 2 of 2
  1. #1
    Apprentice l337r00t is offline
    MemberRank
    Sep 2007 Join Date
    19Posts

    [HELP] MSSQL script for char reset 1 reset= 20 mil, 2 reset= 40 mil and etc

    Hey friends,

    Can someone give me mssql script for reset char like this:
    First reset=20 mil
    Second Reset=40 mil
    and ...etc

    till 60 reset after that to be all 1 billion= 1.000.000.000

    :)


  2. #2
    Member NooK is offline
    MemberRank
    Jun 2006 Join Date
    RumaniaLocation
    55Posts

    Re: [HELP] MSSQL script for char reset 1 reset= 20 mil, 2 reset= 40 mil and etc

    Shore here you go...

    UPDATE Character
    SET inventory = null ,
    clevel=1 ,
    Experience = '0' ,
    Resets = Resets+1 ,
    Strength= '26',
    Dexterity= '26' ,
    Vitality= '26',
    Energy= '26',
    MapNumber= '0',
    MapPosX= '125',
    MapPosY= '125',
    Money = Money - (20000000 + 4000000 * Resets)
    WHERE cLevel='350'
    AND Money>=20000000 + 4000000 * Resets
    *Resets you must creat in MuOnline db, Character table Resets row.



Advertisement