script de reset

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint =
LevelUpPoint + 100, Money = Money - 5000000, MapNumber = 0, MapPosX =
130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT
ON Character.AccountID = MEMB_STAT.memb___id
WHERE (clevel >=
300) AND (Money >= 5000000) AND (Resets<=5) AND (Resets>=0) AND
(ConnectStat = 0) AND (CtlCode <> [Tienes que estar registrado y conectado para ver esa imagen] AND (CtlCode <> 32);

*pone a lvl 1
*exp a 0
*regala
100 puntos adicionales
*cuesta 5 millones de zen
*los pone en el
map lorencia
*suma reset en 1
*debe ser lvl 300
*dinero mayor a
5 millones
*rango de reset de 0 a 5
*debe estar desconectado
*no
debe ser GM


Código:
UPDATE Character
SET clevel = 1,
Experience = 0, LevelUpPoint = LevelUpPoint + 100, Money = Money -
5000000, MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM
Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
WHERE
(clevel >= 330) AND (Money >= 5000000) AND (Resets<=10) AND
(Resets>=6) AND (ConnectStat = 0) AND (CtlCode <> [Tienes que estar registrado y conectado para ver esa imagen] AND (CtlCode <> 32);

*pone a lvl 1
*exp a 0
*regala
100 puntos adicionales
*cuesta 5 millones de zen
*los pone en el
map lorencia
*suma reset en 1
*debe ser lvl 330
*dinero mayor a
5 millones
*rango de reset de 6 a 10
*debe estar desconectado
*no
debe ser GM


Código:
UPDATE Character
SET clevel = 1,
Experience = 0, LevelUpPoint = LevelUpPoint + 100, Money = Money -
5000000, MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM
Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
WHERE
(clevel >= 370) AND (Money >= 5000000) AND (Resets<=20) AND
(Resets>=11) AND (ConnectStat = 0) AND (CtlCode <> [Tienes que estar registrado y conectado para ver esa imagen] AND (CtlCode <> 32);

*pone a lvl 1
*exp a 0
*regala
100 puntos adicionales
*cuesta 5 millones de zen
*los pone en el
map lorencia
*suma reset en 1
*debe ser lvl 370
*dinero mayor a
5 millones
*rango de reset de 11 a 20
*debe estar desconectado
*no
debe ser GM


Código:
UPDATE Character
SET clevel = 1,
Experience = 0, LevelUpPoint = LevelUpPoint + 100, Money = Money -
5000000, MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM
Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
WHERE
(clevel >= 400) AND (Money >= 5000000) AND (Resets>=21) AND
(Resets<=99) AND (ConnectStat = 0) AND (CtlCode <> [Tienes que estar registrado y conectado para ver esa imagen] AND (CtlCode <> 32);

*pone a lvl 1
*exp a 0
*regala
100 puntos adicionales
*cuesta 5 millones de zen
*los pone en el
map lorencia
*suma reset en 1
*debe ser lvl 400
*dinero mayor a
5 millones
*rango de reset de 21 a 99
*debe estar desconectado
*no
debe ser GM