Some Useful query

12/29/2011 02:23 Dr.Abdelfattah#1

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 .

12/29/2011 03:26 Iillminetor#2

Thnx Dr.AbdelFattah
Yb2a kalmny 3shan 3ayzk.

12/29/2011 03:51 PortalDark#3

Quote:

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

Quote:

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

Code:

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

12/29/2011 04:26 Keyeight#4

Will good work guys :)

12/29/2011 08:35 !x_~!#5

good work dude .. :) deserve my thanks

12/30/2011 16:29 Dr.Abdelfattah#6

Quote:

Originally Posted by Iillminetor

Thnx Dr.AbdelFattah
Yb2a kalmny 3shan 3ayzk.

y.w , 7ft7 now :)

Quote:
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
Code:
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 :)

Quote:

Originally Posted by mats0o0o0

Will good work guys [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by !x_~!

good work dude .. [Only registered and activated users can see links. Click Here To Register...] deserve my thanks

ty , and welcome :)