mysql_query and item_proto

[Chikyou]

Hi !
I was making a quest with mysql_query, to conect to refine_vnum in item_proto.

quest melhorar begin
 state start begin
  when 20091.take with item.vnum() == 169 begin
   local a = select("Sírius", "Barão", "Sair")
   if a == 1 then
    mysql_query("UPDATE player.item_proto SET refine_item='270' WHERE vnum='169'")
   elseif a == 2 then
    mysql_query("UPDATE player.item_proto SET refine_item='260' WHERE vnum='169'")
   end
  end
 end
end

Here is the quest.
But, to save the changes, i have to do /reload p ingame, and, i want that it save the changes without /reload p.
I don't know if it's possible to do it. But, maybe i receive an answer for it.

Sorry for my bad english.
Thank you.

Best Regrards.

[Chikyou]

bump

[©by Noa]

refine_item doesn't exist
I think you mean refined_vnum

[Chikyou]

Originally Posted by ©by Noa

refine_item doesn't exist
I think you mean refined_vnum

Yes i know, i just didn't remember the correct name xD

Btw, you know how i should do that? Or anyone else?

[©by Noa]

I dont know what you mean or what you like do.
Change refined_vnum some item with other one or refine it 100%?

[Chikyou]

I want to make 2 refines in one weapon.

Exemple:

Battle Sword (169) -> Sirius sword (279) or Baron sword (269).

Exemple with quest:

quest test begin
state start begin
when 20091.take with item.vnum() == 169 begin
say("What weapon you want?")
local a = select ("Sirius", "Baron")

I don't know if you understand me, but it's something like that.

[©by Noa]

PHP Code:

when 20091.take with item.vnum() == 169 begin
say("What weapon you want?")
local a = select ("Sirius", "Baron")
if a==1 then pc.give_item2(279) 
elseif a==2 then pc.give_item2(269) 
end
end 


[Chikyou]

For example the weapon has placed bonus and the player wants to turn it into another weapon, with the way you said the new weapon would have no bonus, you know?
And I wanted that the new weapon had the bonus that had previous weapon.

Sorry for bad englisht ( Translator english <.< )

[Chikyou]

bump

[Chikyou]

bump

[Mashkin]

Updating prototype information (item_proto, mob_proto etc.) in the game core requires the reload p command.
I'm not sure whether GM commands can be called from quests. There is the method cmdchat(), but I guess it only works for sending signals to the client.

There is no explicit reload() method in the quest scope, though.

[.Remix]

It's not possible to save it without reload or shutdown.
But you shouldnt use reload, because it could crash some tables.