|Jobs/Query| Algumas Querys

Editado e corrigido

Query DB MuOnline:

-------------------------------
Zen Negativo Fix:

UPDATE Character
SET Money='2000000000'
WHERE Money<-1

-------------------------------
Personal ID Code "Desactivar" Marque:

UPDATE MEMB_INFO
SET sno__numb=('')
WHERE sno__numb>1

-------------------------------
PJ comienza con ('10000000') de zen o otro valor:

UPDATE Character
SET Money=('10000000')
WHERE Money<1

-------------------------------
Auto Stats Fix:

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

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

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

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

-------------------------------
Areglar puntos para Dark Lord:

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

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

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

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

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

-------------------------------
Auto quitar PK:

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

-------------------------------
Starting stats edditing:

UPDATE Character
SET Strength='how mutch starting strenght you wanth'
WHERE Strenght<18

UPDATE Character
SET Dexterity='how mutch starting dexterity you wanth'
WHERE Dexterity<16

UPDATE Character
SET Vitality='how much starting vitality you wanth'
WHERE Vitality<16

UPDATE Character
SET Energy='how much starting energy you wanth'
WHERE Energy<16

-------------------------------
For versions that have Dark Lord:

UPDATE Character
SET Strength='how mutch starting strenght you wanth'
WHERE Strength<18

UPDATE Character
SET Dexterity='how mutch starting dexterity you wanth'
WHERE Dexterity<16

UPDATE Character
SET Vitality='how much starting vitality you wanth'
WHERE Vitality<16

UPDATE Character
SET Energy='how much starting energy you wanth'
WHERE Energy<16

UPDATE Character
SET Leadership='how much starting command you wanth'
WHERE Leadership<15

-------------------------------
Para quitar a los usuarios que se quedan conectados al servidor mientras esta apagado, esto aparece en la web, fix:

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

-------------------------------
Para transportar a todos los PJ desde "Excile" a Lorencia, bar:

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

-------------------------------
Quitar el bug de guild en la web de puntos negativos como -99 fix:

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

-------------------------------
Para borrar todos los resets:

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

-------------------------------
Para borrar todos los vaul:

UPDATE warehouse
SET Items=('')

-------------------------------
Para borrar todos los inventarios:

UPDATE Character
SET Inventory=('')

-------------------------------
Para borrar todos los PJ:

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

-------------------------------
Para Borrar todos los GMs:

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

-------------------------------
Para borrar todos los puntos:

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

-------------------------------
Auto Reset:

UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349

------------------------------------------------------------------

Otros Codigos:-------------------------------
summoner fix para season 3 y season 4:

USE [MuOnline]
INSERT IGNORE INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint)
VALUES (80,21,21,18,23,70,70,40,40,0,182,128,3,0,1,0)

-------------------------------
Agregar zen al vault de GM:

Update Character
Set Money=2000000000
Where CtlCode=8

-------------------------------
Proteger contra la falsificaciÃ³n de GM:
En primer lugar crear una columna llamada "Is_Valid_GM" y dejar 0 como valor predeterminado
al crear un nuevo GM debe cambiar manualmente este valor en 1

UPDATE Character
SET CtlCode=('1')
WHERE CtlCode=('8') and Is_Valid_GM=('0')

-------------------------------
Bloquear todas las acc :

Update MEMB_INFO
Set bloc_code=1

-------------------------------
Desbloquear todas las acc:

Update MEMB_INFO
Set bloc_code=0

-------------------------------
Auto Quest:

Update character
set class = ('1') , clevel = ('151') , leveluppoint = ('20')
where clevel = ('150')
and class = ('2')

Update character
set class = ('17') , clevel = ('151') , leveluppoint = ('20')
where clevel = ('150')
and class = ('16')

update character
set class = ('32') , clevel = ('151') , leveluppoint = ('20')
where clevel = ('150')
and class = ('33')

-------------------------------
MD5 Script:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XP_MD5_EncodeKeyVal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[XP_MD5_EncodeKeyVal]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

exec sp_addextendedproc N'XP_MD5_EncodeKeyVal', N'WZ_MD5_MOD.dll'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

-------------------------------
fix para la summoner si utilizas EdataServer:

exec WZ_CreateCharacter_GetVersion

INSERT IGNORE INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership) VALUES (1,0,18,18,15, 30, 60,60,60,60, 0,182,128, 3, 0, 0)
INSERT IGNORE INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership) VALUES (1,16,28,20,25, 10, ********20,20, 0,182,128, 3, 0, 0)
INSERT IGNORE INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership) VALUES (1,***22,25,20, 15, 80,80,30,30, 0,182,128, 3, 0, 0)
INSERT IGNORE INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership) VALUES (1,48,26,26,26, 26, ********60,60, 0,182,128, 3, 0, 0)
INSERT IGNORE INTO DefaultClassType (Level, Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, LevelUpPoint,Leadership) VALUES (1,64,26,20,20, 15, 90.000000,90.000000,40,40, 0,182,128, 3, 0, 25)
INSERT IGNORE INTO DefaultClassType (Class, Strength, Dexterity, Vitality, Energy, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, DbVersion, Leadership, [Level], LevelUpPoint) VALUES (80,21,21,18,23,70,70,40,40,0,182,128,3,0,1,0)