Auto Reset Using Sql

Quote:

---

Originally Posted by Z_Gamer

good guide can some one make me one when u reset lvl 1000 and u get to keep ur stats and u dont have to pay money

---

ye i want scrp like that

Very Nice guide

Hi guys i need a sql script to change the values in Resets field from <null> to 0, the reset script is not working ok with <null>'s :))

THX



http://muslayer.anf.ro

i made this script and it` works :) but i user frog mu web page and i woant to load there the resets` count to .. how can i do that ?

ex:
CharName Level
Killeros 350(1)
afther auto reset
ex:
CharName Level
Killeros 1(2)

or as frog mu has to put down the count .. i mean tu update the count of the resets in frog mu ..

Can anyone tell me how to make jobs with sql 2005?

ive looked everywhere here,google,microsoft LOL help

Quote:

---

Originally Posted by benykc

auto reset is ok for me but i got this bug. when lvl 350, i happens to leave my character in game for one whole night. the next day i realised i have extra 30 resets!!

my friend had 200 resets but he train till lvl 350 & leave it in game afk for 1 week, he now got 400+ resets!!

if someone know the solutions, please advise. tks.

this is my formula :

PDATE Character
SET clevel=('1'),Experience=('0'),Strength=('25'),Dexterity=('25'),Vitality=('25'),Energy=('25'),MapNumber=('0'),MapPosX=('125'),MapPosY=('125'),PkLevel=('3'),Resets=Resets+('1'),LevelUpPoint=('150')*resets
WHERE clevel>('349')

---

Same thing hapend to me - look at my site -> Forums -> Main :

I wrote there the SQL that need to be submitted...:king:

no pics...

Hey guys I was following step by step the GUIDE No errors nothing then I go In game and give it a test. I made One SM 350 level logout w8 for 2 minutes and Login the SM was 1st level Login with him and what No Points Given every thing in the inventory was there... Just from 350 to 1 level and nothing ...
Снимки - 1M - DataBG
Снимки - 2V - DataBG
Снимки - 3N - DataBG
Снимки - 4H - DataBG

Where is my mistake !?
and one more thing I want to make it like 1st Res Needs 20 000 000 (20 mil zen) and gives 350 points (stats, inventory, skills CLEAR!) 2nd Res 40 000 000 (40 mil. zen) 700 points :) Pls help :D I'm going crazy 5 days I'm working on that I fixed Monstersetbase gate monster .... and other shits but I'm nothing with that Sql Server Thing :D Ooo and web BANK for zen :) That players could put zen In the bank and then Requared zen could be taken from virtual bank :) tnx if some one could help me and sorry for bad english I'm learning it from 5 days :D tnx to MuServer I can speak a lil :)

Wow... cool 1 dim queries guys... very retro and all.. Good guide, but save some op-time and res by tossing some conditionals and reducing the size of the queries, than it will take some of the load off your sys.

i couldn't find script that i needed so i will write what i need and if someone is able to do this i ask him to help me...
so i need next..
first reset lvl from 350 and next resets from 400 lvl, i need dk to get 400 point per reset, dw to get 500 point, mg and dl to get 700 point, and elf to get 800 point per reset, and this till 50 reset, then after 50 reset dk dk to get 200 point dw to get 250, mg and dl to get 350, and elf to get 400. if anybody can do this please help me.

Ok so you want to get them 400,500,700,800 leveluppoints up to 50 resets and then on 200,250,350,400, right?