[Help] Grand Reset + Credits

Here where I'm at:

Code:

---

UPDATE Character
SET GrandRes=+1,Resets='0',Strength='250',Dexterity='250',Vitality='250',Energy='250'
FROM Character inner join MEMB_CREDITS on Character.AccountID=MEMB_CREDITS.memb___id
Set MEMB_CREDITS.credits = +1000
WHERE Name='Gyvastis',Resets='100'

---

Tell me what I did wrong, please.

Anyone?

Code:

---

UPDATE dbo.Character
SET GrandRes=GrandRes+1,Resets='0',Strength='250',Dexterity='250',Vitality='250',Energy='250'
WHERE Name=('Gyvastis') and (Resets='100')
UPDATE dbo.MEMB_CREDITS
FROM MEMB_CREDITS join Character on MEMB_CREDITS.memb___id=Character.AccountID
Set credits = credits+1000

---

exactly what u doing whit this can explain whit letter

Huh?

give the errors what you get from QA

PHP Code:

---

USE MuOnline
 
--VAR DECLARATION
DECLARE @AName VarChar(10)
--VAR INITIALIZATION
SET AName = 'Gyvastis'
 
UPDATE Character
SET GrandRes = GrandRes + 1, Resets='0', Strength='250', Dexterity='250', Vitality='250', Energy='250', Leadership = '250' WHERE (Name=@AName) AND Resets = '100' 
 
UPDATE MEMB_CREDITS SET Credits = Credits + 1000 MEMB___ID = (SELECT AccountID FROM Character WHERE (Name=@AName)) 


---

Try this.

but how to create that this script always would be chelng charater table and do this function when someone reach 100 resets? This now works only when you write it tu query. If you want to do grand reset for someone next time you have to write this script again and so on.