what to write?
quest dr_gutschein begin
state start begin
when 30093.use or 80015.use or 80016.use begin
local p = 100
if item.get_vnum() == 80015 then
p = 500
elseif item.get_vnum() == 80016 then
p = 1000
end
local accountid = mysql_query("SELECT * FROM player.player WHERE name='"..pc.get_name().."'","root","franzi","playe r","192.168.13.100")
local coins = mysql_query("SELECT * FROM account.account WHERE id='"..accountid.account_id[1].."'","root","franzi","account","192.168.13.100" )
say_title("Drachenmünzen Gutschein")
say("Hallo "..pc.get_name()..".")
say("Möchtest du diesen Gutschein")
say("im Wert von 100 Drachenmünzen einlösen?")
if select ("Ja","Nein") == 2 then return end
local updatecoins = mysql_query("UPDATE account.account SET coins='"..coins.coins[1]+p.."' WHERE id='"..accountid.account_id[1].."'","root","franzi","account","192.168.13.100" )
chat("Deine Drachenmünzen wurden dir erfolgreich gutgeschrieben.")
end
end
end