Sentencias SQL Server 2000

Tema en 'Servidores de Mu Online' iniciado por MPunK, 31 Jul 2009.

  1. MPunK

    MPunK
    Expand Collapse
    ~Gambetero+
    Super Moderador

    Mensajes:
    650
    Me Gusta recibidos:
    23
    Espero que les sirva estas sentencias SQL Echas y Analizadas por Mi en el

    SQL Siguientes Sentencias :



    ---------------------
    AUTORESET EN SQL 2000
    ---------------------

    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 EN SQL 2000
    ---------------------


    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
    -----------------


    ( DESBUGEA A QUIENES TIENEN EL ZEN NEGATIVO )

    UPDATE Character
    SET Money= ('600000000')
    WHERE Money > 900000000 Or Money < 0 ;

    -------------------
    AUTODESBUG DE STATS
    -------------------


    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

    EN ESTE CASO AQUELLOS QUE SE PASAN DE 32767 SUS STATS REGRESARAN DE FORMA
    AUTOMATICA A 30.000 ( PUEDEN MODIFICARLO A SU GUSTO SOLO DEBEN CAMBIAR "30.000" POR
    EL STATS QUE QUIERAN )


    Agregado para el pj DARKLORD


    UPDATE Character
    SET Strength='30000'
    WHERE Strength<1

    UPDATE Character
    SET Dexterity='30000'
    WHERE Dexterity<1

    UPDATE Character
    SET Vitality='30000'
    WHERE Vitality<1

    UPDATE Character
    SET Energy='30000'
    WHERE Energy<1

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

    -------------------
    AUTO BORRADO DE PK
    -------------------


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

    --------------------------------------
    Dar dinero a PJs que empiezan desde 0
    --------------------------------------


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

    --------------------------------------
    Dar puntos a los pjs al empezar
    --------------------------------------


    Este codigo sirve para que los pjs empiezen con 10.000 de todo ( pueden modicar la variable 10.000 por la que ustedes quieran )


    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 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

    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<-1

    --------------------------------------------------
    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 LevelUpPoints=('0')
    WHERE LevelUpPoints>0
     
  2. Don

    DonKan
    Expand Collapse
    Teniente Coronel
    Usuario destacado

    Mensajes:
    1.844
    Me Gusta recibidos:
    0
    Muii BuenazZ zenTenCiiaz MPunk :aplauso:

    [MARCO=CoDe]
    ---------------------------------------------------------------
    Corrigue automaticamente el bug de las Guild con Score negativo
    ---------------------------------------------------------------


    UPDATE Guild
    SET G_Score=('0')
    WHERE G_Score<-1
    [/MARCO]

    EzTe KoDe era el k me ezTaBa volvienDo lokoO :pensando:

    noO lo enkonTraba :negar:

    TraTe de acer una ZenTencia para ezTe miizmoO BUG ioO mizmoO :si:

    PeroO en vez de kitar los (-) loOz ponia posiTiVoOz :risa:


    Atte. ●€vilJairO● :mad:
     
  3. MPunK

    MPunK
    Expand Collapse
    ~Gambetero+
    Super Moderador

    Mensajes:
    650
    Me Gusta recibidos:
    23
    Muchas Gracias Jairo

    :p Lo Ponias positivo Bueno ahi esta .- Tal y como esta escrito asi va

    :adios:
     
  4. fle

    flecxx16
    Expand Collapse
    Invitado

    jario no se si conoces a eduerdo el colombiana! el es mi amigo!!! necesito el SQL para hacer un server de mu!!! urgente me puedes ayudar!!!
     

Compartir esta página