Some Useful query

[Dr.Abdelfattah]

Hello,

Let's Start
Some useful queries which could help u in edit the tables or databases data more fast and easier ,

PHP Code:

UPDATE dbo._RefObjChar SET DefaultSkill_1=33266 WHERE CodeName128 LIKE '%P2SKILL_INNATE_ASS%' 


this will update=edit at _RefObjChar table, the DefaultSkill_1 column to value 33266 WHERE=which CodeName123 this column LIKE=much the '%P2SKILL_INNATE_ASS%'=the column data which u need to edit DefaultSkill_1 at it's row
well %=accept any more work before P@SKILL and the one at last %=accept any more work after _ASS
So this query can edit many rows at column DefaultSkill_1 with the value 33266 which got rows name only %P2SKILL_INNATE_ASS% at column CodeName123

PHP Code:

UPDATE dbo._RefObjChar
SET DefaultSkill_1 = 1
WHERE ID BETWEEN 18718 AND 18780 


well UPDATE=edit , SET=change with the current value , DefaultSkill_1 the column name = 1 , 1 is the value , WHERE ID BETWEEN , ID=a column name , 18718 AND 18780=the rows at ID column From 18718 tell ~ 18780

PHP Code:

select * from _RefSkill where Basic_Group like '%SKILL_OP_HARMONY_A%' 


Oky select=showing , _RefSkill the table name , where=at Basic_Group is a column , like=equal , '%SKILL_OP_HARMONY_A%' this the value rows which the query will look and will view , anyway the result can't view over 100 result(row)
if u need a right value if u post the complete data(name) so remove % , so it will be like 'SKILL_OP_HARMONY_A'

PHP Code:

UPDATE _Char
SET CurLevel = '110',
MaxLevel = '110'
WHERE CurLevel > 139 


UPDATE=edit
SET=change
CurLevel is a column , '110' 110 is the value which the data going to change to
MaxLevel is a column , '110' 110 is the value which the data going to change to Too
WHERE=at CurLevel > 139 , CurLevel is the column which contain the value which equal 139 and if it's equal 139 so any row got Curlevel column = 139 will apply the changes at CurLevel Column and MaxLevel Column to let the data value to 110 .

Don't forget to check that u choose the right database
At Last use ur mine to change on those queries to change on them or to make them with new functions and to help u in what u need to edit .

[Iillminetor]

Thnx Dr.AbdelFattah
Yb2a kalmny 3shan 3ayzk.

[PortalDark]

Originally Posted by Dr.Abdelfattah

PHP Code:

UPDATE _Char
SET CurLevel = '110',
   MaxLevel = '110'
WHERE CurLevel > 139 


i could say that the MaxLevel could be just set 110 to all(in the case you want to set 110 as max lvl

PHP Code:

UPDATE _Char
SET CurLevel = '110',
   MaxLevel = '110'
WHERE CurLevel > 110 


Originally Posted by Dr.Abdelfattah

PHP Code:

select * from _RefSkill where Basic_Group like '%SKILL_OP_HARMONY_A%' 


that one can be very useful
but i dont think someone will need harmony skills
i could say that they put the name of the mastery on it

PHP Code:

select * from _RefSkill 
where Basic_Group like '%fire%' and Basic_Group like '%_CH_%'
OR Basic_Group like '%_EU_%' 


that will show you all skills for euro and chinese with fire as class
possible classes are

sword= blade/sword
spear=Glaive/Spear
Bow= Duh

cold=ice
fire= Fire(Eu/CH)
lightning
water=Force

Cleric
Bard
Warlock
Wizard
Rog= Rogue skills
Warrior=Warrio SkillsSkills

[Keyeight]

Will good work guys

[!x_~!]

good work dude .. deserve my thanks

[Dr.Abdelfattah]

Originally Posted by Iillminetor

Thnx Dr.AbdelFattah
Yb2a kalmny 3shan 3ayzk.

y.w , 7ft7 now

Originally Posted by PortalDark

i could say that the MaxLevel could be just set 110 to all(in the case you want to set 110 as max lvl

PHP Code:

UPDATE _Char
SET CurLevel = '110',
   MaxLevel = '110'
WHERE CurLevel > 110 


that one can be very useful
but i dont think someone will need harmony skills
i could say that they put the name of the mastery on it

PHP Code:

select * from _RefSkill 
where Basic_Group like '%fire%' and Basic_Group like '%_CH_%'
OR Basic_Group like '%_EU_%' 


that will show you all skills for euro and chinese with fire as class
possible classes are

sword= blade/sword
spear=Glaive/Spear
Bow= Duh

cold=ice
fire= Fire(Eu/CH)
lightning
water=Force

Cleric
Bard
Warlock
Wizard
Rog= Rogue skills
Warrior=Warrio SkillsSkills

almost i was post those queries with any example , just to let the people think to make a new query that will help him

Originally Posted by mats0o0o0

Will good work guys

ty

Originally Posted by !x_~!

good work dude .. deserve my thanks

ty , and welcome