Help about my plans

[Dvrstle]

Here's my plan:

Make those +12 to +20 Glorious Weapons reduced to +11 glorious weapons only.

for every 1 refine that was reduced, they will get 25pods.

Please help me =)

[Euphy]

*downrefitem <equipment slot>;

This command will downgrade an item by - 1 in the specified equipment slot of the

invoking character. So the item will not be destroyed unlike in the failedrefitem script command.

This will also display a 'refine failure' effect on the character and put appropriate

messages into their chat window.

The official scripts seems to use the 'downrefitem' command as a function

instead: 'downrefitem(<number>)' but it returns nothing on the stack. This is

since jAthena, so probably nobody knows for sure why is it so.

[Dvrstle]

im sorry but its not what i need =)

i need to do it in my phpmyadmin =) how?

[Limestone]

i think in inventory in your sql. find the ID's of Glorious items.

[Spre]

inventory database.

UPDATE `yourDBNAME`.`inventory` SET `refine` = '11' WHERE `inventory`.`id` =ID;

each and every ID.

that is the sql squery for that

or you can load phpmyadmin go to inventory and use

SELECT *

FROM `inventory`

LIMIT 0 , 5000

for example, The select every item you see with a refine of 12+ and set ALL to 11 using phpmyadmin, you can do that with it.

[GmOcean]

If you use Spre's method, make sure you do a check for the item id, becuase `id` in inventory = # of item dropped since first time. Example i get an apple, its now id 1, you get an apple its now id 2.

so search for `nameid`