Sentencias SQL Server 2000

Estan son algunas sentencias SQL que podemos aplicar a nuestro servidor mediante un simple Job en SQL.
Veamos de cuales se tratan:
-------------------------------------------------------------------------------------
Autoreset [Nivel 1000]
-------------------------------------------------------------------------------------

Autoreset para level 1000 , pueden modificar por el level de su server cambiando la linea CLEVEL>= 1000 por el reset de su server ( 400 , 350 ETC)

No borra stats,quest,inventario ni baul

Programado para reset level 1000

Contador de reset incluido

Verifica que el pj esta offline (Evita bugs en el contador)>

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (0 * (Resets + 1)), Money = Money - (0 * (Resets + 1)), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 1000) AND (Money >= (0 * (Resets + 1))) AND (ConnectStat = 0);

-------------------------------------------------------------------------------------
Autoreset [Nivel 350]
-------------------------------------------------------------------------------------

AutoReset Lvl=350

Agrega 350 por reset

Tiene un costo de 50millones por reset

Limitado a 50 resets

Borra stats

Autowuapeo a lorecia/Noria depende el pj

Borra los skill de los pjs

Borra el inventario de los pjs

Borra el pk de los pjs

1)DarkWizard/SoulMaster Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

2)DarkKnight/BladeKnight Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

3)Elf/MuseElf Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

4)MG Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

DarkLord (99+ Versions)

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

-------------------------------------------------------------------------------------
Autodesbug de ZEN [Zen negativo]
-------------------------------------------------------------------------------------

UPDATE Character
SET Money= ('600000000')
WHERE Money < 900000000 or 0

-------------------------------------------------------------------------------------
Autodesbug de stats de forma automática
-------------------------------------------------------------------------------------
En este caso, si tu personaje supera el máximo de stats de 32767, deberá salir del juego y luego al entrar los stats del personaje volverá a 30000 (Si desean pueden modificar el 30000 por el valor que quieran que el personaje regrese)

UPDATE Character
SET dexterity= ('30000')
WHERE dexterity<0

UPDATE Character
SET energy= ('30000')
WHERE energy<0

UPDATE Character
SET strength= ('30000')
WHERE strength<0

UPDATE Character
SET Vitality= ('30000')
WHERE Vitality<0

Agregado para el pj DARKLORD

UPDATE Character
SET Leadership='30000'
WHERE Leadership<0

-------------------------------------------------------------------------------------
Borrado de PK automático
-------------------------------------------------------------------------------------

UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2

-------------------------------------------------------------------------------------------
Dar dinero a personajes que recien comienzan
-------------------------------------------------------------------------------------------
Dar puntos a los personajes al empezar
Este código sirve para que los personajes empiezen con 20000000 de zen (Pueden modicar la variable 20000000 por la que ustedes quieran )

UPDATE Character
Set Money=('20000000')
WHERE Money<1

------------------------------------------------------------------------------------------
Dar stats a personajes que recien comienzan
------------------------------------------------------------------------------------------

UPDATE Character
SET Strength='10000'
WHERE Strenght<18

UPDATE Character
SET Dexterity='10000'
WHERE Dexterity<16

UPDATE Character
SET Vitality='10000'
WHERE Vitality<16

UPDATE Character
SET Energy='10000'
WHERE Energy<16

Agregado para el DarkLord

UPDATE Character
SET Leadership='10000'
WHERE Leadership<15

----------------------------------------------------------------------------------------------------------------
Corrigue el bug para verificar correctamente los conectados en nuestra web
----------------------------------------------------------------------------------------------------------------

UPDATE MEMB_STAT
SET Connect_Stat='0'
WHERE Connect_Stat>0

-----------------------------------------------------------------------------------------------------------------------
Transporta automaticamente de " Place Of The Exile " a Lorencia
-----------------------------------------------------------------------------------------------------------------------

UPDATE Character
SET MapNumber=('0'), MapPosX=('125'), MapPosY=('125')
WHERE MapNumber=('5')

-----------------------------------------------------------------------------------------------------------------------
Corrigue automaticamente el bug de las Guild con Score negativo
-----------------------------------------------------------------------------------------------------------------------

UPDATE Guild
SET G_Score=('0')
WHERE G_Score<0

-------------------------------------------------------------------------------------
Sentencia para borrar los resets de todos los pjs
------------------------------------------------------------------------------------- Esta sentencia es ideal si queremos resetiar nuestro server y solo queremos borrar los resets de todos los pjs.

UPDATE Character
SET Resets=('0')
WHERE Resets>0

----------------------------------------------------------------------------------
Sentencia para borrar todos los items del baul
----------------------------------------------------------------------------------

UPDATE warehouse
SET Items=('')

---------------------------------------------------------------------------------------
Sentencia para borrar todos los items del inventario
---------------------------------------------------------------------------------------

UPDATE Character
SET Inventory=('')

-------------------------------------------------------------------------------
Sentencia para debanear de forma automatica
-------------------------------------------------------------------------------

UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')

--------------------------------------------------------------------------------------
Sentencia para borrar a todos los gms
--------------------------------------------------------------------------------------

UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('8')

--------------------------------------------------------------------------------------
Sentencia para borrar todos los puntos para agregar
--------------------------------------------------------------------------------------

UPDATE Character
SET LevelUpPoint=('0')
WHERE LevelUpPoint>0

Si tenemos un error con esta setencias cambiamos por esta

UPDATE Character
SET LevelUpPoints=('0')
WHERE LevelUpPoints>0

Si necesitas alguna sentencia podes solicitarla agregando como comentario en esta misma entrada describiendo el proceso.
Sentencias_SQL.txt [12 KB]

Espero que les sirva, será hasta el próximo tutorial by asd*

Etiquetas: muonline , sentencias sql , sql server 2000 , tutorial