[SOLVED] Need Sql Query

[Come2WoW]

hi all , i need a sql query for myrtb up items stats (my english typ is very very bad )
for example, the all stat_typ10 Be 7 with their own stat_value10

More details (for bad english ) ===> for example, the

we haw 700 pcs stat_typ1 = 7 With his characteristic (stat_value1 = xxx) how send all 700 pcs stat_typ10 = 7 With his characteristic (stat_value10 = xxx)

- - - Updated - - -

Language very good month to go class

 

[AlexeWarr]

Please explain much detailed, I didnt really understood what you mean srry

 

[Epicblood]

I think this is what you want:

UPDATE 'TableName' SET stat_typ10 = 7 WHERE stat_value10 = xxx;

 

[Come2WoW]

More details : D)
It's got the look

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,7, 350, 32, 150, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,32, 150, 7, 450, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

chang :

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,0, 0, 32, 150, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 7, 350);

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,32, 150, 0, 0, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 7, 450);

Could?

 

[Epicblood]

So where ever stat_typeXX = 7 you want to take that stat and value and put it in stat_type10 && stat_value10 ?

 

[Come2WoW]

yes. the ?

 

[Hyperion]

More details : D)
It's got the look



chang :



Could?

Why even run a query in the first place? Just go in the DB and edit the field.
Could have been done long ago

 

[Come2WoW]

sorry but edite is hard I need a easy work

 

[Come2WoW]

Who does not?
pleas help It is very important.

 

[Come2WoW]

sorry for spam , admin delete my Addition .

but this sql query is Very Important for me.

 

[Tommy]

Use http://translate.google.com/ and maybe we can understand what you really want. I can hardly tell what you actually need.

 

[Come2WoW]

ok see this :

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,7, 350, 32, 150, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,32, 150, 7, 450, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

After the change with sql querysee Changes in Red Zsmt)

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,0, 0, 32, 150, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 7, 350);

INSERT INTO `item_template` ( `StatsCount`,`stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`) VALUES ( 10,32, 150, 0, 0, 36, 70, 4, 250, 35, 140, 0, 0, 0, 0, 0, 0, 0, 0, 7, 450);

 

[Tommy]

What about the changes?

 

[Come2WoW]

ok see this





After the change with sql query



I'm going to do it change all item_templat for a fun server (with this query sql : UPDATE item_template SET `stat_value10` = `stat_value10` * 20 ; )

but Dun change all stats becus Broken into items Like : The haste 5000

 

[Tommy]

So you want to update almost every item's stat columns in the database? I see.

I know there are ways to do this in SQL, but I don't know the correct syntax.

 

[Come2WoW]

omg i dead for writ this Words at Dictionary

ok, If the you make this and i I'll wait (ask your friend becus my englis... )

 

[Tommy]

omg i dead for writ this Words at Dictionary

ok, If the you make this and i I'll wait (ask your friend becus my englis... )

Doubt that I can make this.

I only know so much SQL.

 

[Come2WoW]

I have faith in you .
you are very Professional. :*
It is possible to do this?(No joke )
tommy my yahoo masenger is Hamediwow@yahoo.com add me for this (delete my posts It was ridiculous for froum is bad)
Thank you for everything

 

[Epicblood]

I have no idea how to do this either, sorry

 

[Hyperion]

Bro

Please provide the entry id's of which rows you would like to update in item_template