Originally Posted by chey42
1. create a new column in ur tables
2. Name it reset
3. Change the type of the column to navchar
4. Change the default to 1
5. Save it
Then at ur SQL server agent
1. Create a new job
2. Add this commands to it
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=0
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=1
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=16
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=33
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('26') , Dexterity= ('26') , Vitality= ('26') , Energy= ('26')
WHERE clevel>349 and Class=48
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=17
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=32
This will reset all class to their default value and give 500 pts per reset .... Jus change the 500 to watever nos u like .... Hope this helps ....