Centre de Téléchargement
Télécharger ( Interne )
Bonjour,
Voici une quête qui permet de créer un item avec vos bonus au choix:
La quête:
quest creer_item begin
state start begin
when IDITEM.use with pc . is_gm ( ) begin
say_title("Créer item bonus:")
say("")
--- l
say("Bonjour vous pouvez créer votre item.")
say("avec des bonus spécial.")
say("")
say("Bonne création !")
say("")
say("")
local s = select("Oui", "Non")
if s==2 then
return
else
say("ID du compte:")
local id = tonumber(input())
say("ID de l'item:")
local item = tonumber(input())
mysql_query("INSERT INTO player.item (owner_id, window, pos, count, vnum) VALUES ('".. id .."', 'MALL', '34', '1', '".. item .."')");
say("ID pierre 1 préférence mettre 1:")
local p1 = tonumber(input())
mysql_query("UPDATE player.item SET socket0='".. p1 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID pierre 2 préférence mettre 1:")
local p2 = tonumber(input())
mysql_query("UPDATE player.item SET socket1='".. p2 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID pierre 3 préférence mettre 1:")
local p3 = tonumber(input())
mysql_query("UPDATE player.item SET socket2='".. p3 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 1:")
local b1 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype0='".. b1 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 1:")
local vb1 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue0='".. vb1 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 2:")
local b2 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype1='".. b2 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 2:")
local vb2 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue1='".. vb2 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 3:")
local b3 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype2='".. b3 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 3:")
local vb3 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue2='".. vb3 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 4:")
local b4 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype3='".. b4 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 4:")
local vb4 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue3='".. vb4 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 5:")
local b5 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype4='".. b5 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 5:")
local vb5 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue4='".. vb5 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 6:")
local b6 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype5='".. b6 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 6:")
local vb6 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue5='".. vb6 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("ID Bonus 7:")
local b7 = tonumber(input())
mysql_query("UPDATE player.item SET attrtype6='".. b7 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
say("Valeur bonus 7:")
local vb7 = tonumber(input())
mysql_query("UPDATE player.item SET attrvalue6='".. vb7 .."' WHERE (owner_id='".. id .."' and window='MALL' and pos=34 and count=1)");
end
say_title("Créer item bonus:")
say("")
--- l
say("Votre item à etait creer !")
say("Aller voir dans votre inventaire Item-Shop du compte.")
say("")
syschat("Regarde Inventaire Item-Shop de player.")
end
end
end
mysql_query (questlib.lua):
Si vous ne savez pas implanter une quête, suivez ce tutoriel : ici
Bonne journée.
Tore,
