Query's [USEFULL]

[HellFire]

1. Select sSid + strName from K_MONSTER

SELECT sSid,strName FROM K_MONSTER WHERE strName Like '%xx%'

2. SELECT Num + strName from ITEM

SELECT Num,strName FROM ITEM WHERE strName like '%xx%'

3. Rename Query

UPDATE K_NPC SET strName='xx' WHERE strName='Guard'

4. UPDATE NP_SYMBOLS & KNIGHTS_RANKINGS.

exec knights_rank
exec np_icon
exec imbacodermyst
exec UPDATE_USER_PERSONAL_RANK

thats all, post more here so ill add them

 

[Maltuz]

Nice thx

 

[rootbeeer]

thx

 

[zakster]

Nice TUT thanks for the help.

 

[Chadlust]

thanx a lot

 

[flegy33]

thx for share

 

[_suleyman_]

xD u need post ?

 

[MILF]

1. Select sSid + strName from K_MONSTER

SELECT sSid,strName FROM K_MONSTER WHERE strName Like '%xx%'

2. SELECT Num + strName from ITEM

SELECT Num,strName FROM ITEM WHERE strName like '%xx%'

3. Rename Query

UPDATE K_NPC SET strName='xx' WHERE strName='Guard'

4. UPDATE NP_SYMBOLS & KNIGHTS_RANKINGS.

exec knights_rank
exec np_icon
exec imbacodermyst
exec UPDATE_USER_PERSONAL_RANK

thats all, post more here so ill add them

been looking for Name change query for awhile just cant find it, mind posting me? thanks in advance.