AreePiola~ Novato
Mensajes : 20
Fecha de inscripción : 13/09/2011
Edad : 28
| Tema: [Aporte] Algunos Scrip y Trabajos Para SQL Lun Sep 26, 2011 10:33 pm | |
| Vamos a Inicio ---> Todos Los Programas -----> Microsoft sql Server -----> Analizador De Consultas. Seleccionamos la db de mu Online. y empezamos a poner los scrips.Una ves puesto Apretar F5 y guardar los cambio en cualquier lugar.1)DrkWizard/SoulMaster Code - Citación :
- 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 <> 2)DarkKnight/BladeKnight Code: - Citación :
- 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 <> 3)Elf/MuseElf Code: - Citación :
- 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 <> 4)MG Code: - Citación :
- 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 <> DarkLord (99+ Versions) - Citación :
- 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 <> ----------------- AUTODESBUG DE ZEN -----------------( DESBUGEA A QUIENES TIENEN EL ZEN NEGATIVO ) - Citación :
- UPDATE Character
SET Money= ('600000000') WHERE Money > 900000000 Or Money <> ------------------- AUTODESBUG DE STATS ------------------- - Citación :
- UPDATE Character
SET dexterity= ('30000') WHERE dexterity<0 - Citación :
- UPDATE Character
SET energy= ('30000') WHERE energy<0 - Citación :
- UPDATE Character
SET strength= ('30000') WHERE strength<0 - Citación :
- 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
- Citación :
- UPDATE Character
SET Strength='30000' WHERE Strength<1 - Citación :
- UPDATE Character
SET Dexterity='30000' WHERE Dexterity<1 - Citación :
- UPDATE Character
SET Vitality='30000' WHERE Vitality<1 - Citación :
- UPDATE Character
SET Energy='30000' WHERE Energy<1 - Citación :
- UPDATE Character
SET Leadership='30000' WHERE Leadership<1 ------------------- AUTO BORRADO DE PK -------------------
- Citación :
- UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0') Where PkLevel>2 -------------------------------------- Dar dinero a PJs que empiezan desde 0 -------------------------------------- - Citación :
- 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 ) - Citación :
- UPDATE Character
SET Strength='10000' WHERE Strenght<18 - Citación :
- UPDATE Character
SET Dexterity='10000' WHERE Dexterity<16 - Citación :
- UPDATE Character
SET Vitality='10000' WHERE Vitality<16 - Citación :
- UPDATE Character
SET Energy='10000' WHERE Energy<16 Agregado para el DarkLord - Citación :
- UPDATE Character
SET Strength='10000' WHERE Strenght<18 - Citación :
- UPDATE Character
SET Dexterity='10000' WHERE Dexterity<16 - Citación :
- UPDATE Character
SET Vitality='10000' WHERE Vitality<16 - Citación :
- UPDATE Character
SET Energy='10000' WHERE Energy<16 - Citación :
- UPDATE Character
SET Leadership='10000' WHERE Leadership<15 -------------------------------------------------------------------------- Corrigue el bug para verificar correctamente los conectados en nuestra web --------------------------------------------------------------------------
- Citación :
- UPDATE MEMB_STAT
SET Connect_Stat='0' WHERE Connect_Stat>0 --------------------------------------------------------------- Transporta automaticamente de " Place Of The Exile " a Lorencia ---------------------------------------------------------------
- Citación :
- UPDATE Character
SET MapNumber=('0'), MapPosX=('125'), MapPosY=('125') WHERE MapNumber=('5') --------------------------------------------------------------- Corrigue automaticamente el bug de las Guild con Score negativo --------------------------------------------------------------- - Citación :
- 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. - Citación :
- UPDATE Character
SET Resets=('0') WHERE Resets>0 ----------------------------------------------- Sentencia para borrar todos los items del baul ----------------------------------------------- - Citación :
- UPDATE warehouse
SET Items=('') ---------------------------------------------------- Sentencia para borrar todos los items del inventario ---------------------------------------------------- - Citación :
- UPDATE Character
SET Inventory=('') -------------------------------------------- Sentencia para debanear de forma automatica -------------------------------------------- - Citación :
- UPDATE Character
SET CtlCode=('0') WHERE CtlCode=('1') -------------------------------------- Sentencia para borrar a todos los gms -------------------------------------- - Citación :
- UPDATE Character
SET CtlCode=('0') WHERE CtlCode=('8') --------------------------------------------------- Sentencia para borrar todos los puntos para agregar --------------------------------------------------- - Citación :
- UPDATE Character
SET LevelUpPoints=('0') WHERE LevelUpPoints>0 ---------------------------------------------------
Editar Noticias de Guild: ---------------------------------------------------
- Citación :
- UPDATE Guild SET G_Notice='' WHERE G_Name=''
Mover a los que estan trabados en Place Of Exile: - Citación :
- UPDATE Character SET MapNumber=0, MapPosX=140, MapPosY=140, MapDir=1 WHERE MapNumber='5'
Bajar los puntos de stats de los que tienen mas de 65k:
- Citación :
- UPDATE Character SET LevelUpPoint=100 WHERE LevelUpPoint>65000
Cambiar lvl de un Pj: - Citación :
- UPDATE Character SET cLevel='' WHERE Name=''
Desconectar a los "Conectados" en la pagina:[b] - Citación :
- UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat='1'
Espero Que les Sea Util, Saludos, |
|