sql script

[JaneX]

Hi

To all good hearted people there i would like to request a script that will add credits(from MEMB_CREDITS table) when cLevel(from Character table) = 0?

i tried to do it myself but im very confused with the usage of each sql clauses. i have a little background with programming logic but can't afford this one =c T_T

thanks in advance =c

[MentaL]

[JaneX]

BUmP!

P.S i made some script and it works although it still add credits to accounts with LVl1 character and > 1 resets. and i set it to reoccuring schedule (3mins) and it keeps adding credits =c. please help

i want it to only works when one character of that account reseted and add credits =c i dont know complex scripting sorry =c i can only do the simple ones xD

UPDATE MEMB_CREDITS
SET Credits = Credits + 400
From Character
WHERE cLevel = 0

=c