[HELP] SQL Query - SQL Console Comman - UPDATE sql query - NEED HELP !

[TouchOfFlames]

Anyone know how to update database:

 

all patk from npc table x2 where type = L2Monster

 

pls for help whit it.

[TouchOfFlames]

No one dosn`t know how to change multiple records in SQL ???

[Frank]

Explain us what you want to do and then we may find a solution to your problem.

[TouchOfFlames]

This is SQL Query for  update droplist:

 

UPDATE `droplist` SET `chance` = 1000 WHERE `chance` < 100

 

So,what is a Query to update npc pAtk x2 ???

 

UPDATE `npc` SET `patk` * 2 WHERE `type` = L2Monster

 

This update query is wrong,how to make all mobs (L2Monster) stronger ?

patk x2 , pdef x2 , hp x2 ???

[TouchOfFlames]

So,no one knows ???

[WizZy™]

UPDATE `npc` SET `pAtk` = 1000 WHERE `pAtk` < 500 this wont work out ,but just a sample.. You can't do it with SQL code ,but u can increase one by one by this method : UPDATE `npc` SET `pAtk` = 1000 WHERE `pAtk` < 500 then it will make all mobs that have 500 p atk or less to 1000 (doubled) and then

UPDATE `npc` SET `pAtk` = 2000 WHERE `pAtk` < 1001 but this wont work out.So u need to make it manually.

[TouchOfFlames]

Yes,but all mobs will be patk 1000 even RaidBoss.

I saw a proper UPDATE query whit all functions. + - / x

That was in L2Dot timeline , in extras.

Now imagin 1000 L2Monsters to update manually theirs pAtk x2.lol

Its can take a all day long.