ProfStof

Thanks for the effort but it doesn't work, see that when a player login he'll be teleported to village after the loop_timer and so and so .... non stop

Hello ! I want to know how to interdict the use of an item on a map, type the scroll back on a map. Thank you and sorry for my bad english

The quest takes up to 6 variables, if you affect another one it will not be taken, so the item will not be completed, therefore I used yhe UPDATE to guarantee the result

Hello there, Many players want to have perfect items or staff members try to create, but it takes a search on the table player.item then change and a reboot, or a wait of 10 minutes for the object is created. It's long, it's slow and it takes time !!! Today I share a quest of my own creation, which lets you create an item with the stones and the bonus in your account or on another player's account is that it is connected or not, without a reboot or wait a dozen of minutes. First we must change the type of the columns in the table player.item to varchar except the column window do not change its type. To do this, you must open the table player.item then on your keyboard press Ctrl + D and change the types. 1- The quest: ------------------------------------------------------------------ -- Quest: Perfect Item -- -- By: Prof-Stof -- -- Skype: XProfStof -- -- This quest is created by Prof-Stof on his server Fechkel MT2 -- -- Thank you not to delete this comment -- ------------------------------------------------------------------ quest perfetc_item begin state start begin when 40002.use with pc . is_gm ( ) begin say_title("Perfect item:") say("") --- l say("Here you can create items with bonuses and") say("stones of your choice.") say("") say("Do not abuse !") say("A bug is anticipated in case of abuse of Use") say("") local s = select("Start manufacturing", "Close") if s==2 then return else say("Enter the player's ID:") local id = tonumber(input()) say("Enter the item's ID:") local item = tonumber(input()) mysql_query("INSERT INTO player.item (owner_id, window, pos, count, vnum) VALUES ('".. id .."', 'MALL', '34', '1', '".. item .."')"); say("Enter the 1st stone ID:") 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("Enter the 2nd stone ID:") 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("Enter the 3rd stone ID:") 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("Enter the 1st bonus ID:") 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("Enter the 1st bonus value:") 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("Enter the 2nd bonus ID:") 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("Enter the 2nd bonus value:") 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("Enter the 3rd bonus ID:") 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("Enter the 3rd bonus value:") 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("Enter the 4th bonus ID:") 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("Enter the 4th bonus value:") 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("Enter the 5th bonus ID:") 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("Enter the 5th bonus value:") 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("Enter the 6th bonus ID:") 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("Enter the 6th bonus value:") 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("Enter the 7th bonus ID:") 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("Enter the 7th bonus value:") 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("Perfect item:") say("") --- l say("Your item has been successfully created !") say("Check the Item-Shop inventory.") say("") say("") syschat("Check the Item-Shop inventory.") end end end 2- Bonus list: 1 PV max 2 Max MP 3 VIT 4 INT 5 STR 6 DEX 7 Attack Speed 8 Movement Speed 9 Magic speed 10 HP Recovery 11 Regeneration MP 12 Chance of empoisoner 13 Chance cause dizziness 14 Chance to slow 15 Chance to critically attack 16 Chance of piercing hits 17 Bonus against half-humans 18 Bonus against animals 19 Bonus against the Orcs 20 Bonus against mystics 21 Bonus against the Undead 22 Bonus against Evil 23 Damage absorbed by PV 24 Damage absorbed by MP 25 Chance to make enemies MP 26 Chance to recover when you touch MP 27 Chance to block a blow to the body-to-body 28 Chance to avoid the arrows 29 Défensse sword 30 Défensse sword with 2 hands 31 Défensse dagger 32 Défensse gong 33 Défensse the range 34 Resistance to arrows 35 Fire 36 lightfastness 37 Magic Resistance 38 Wind resistance 39 Chance to deflect an attack in melee 40 Chance to divert a curse 41 Resistance against poison 42 Chance to restore PM 43 Chance to get a bonus EXP 44 Chance to drop double YANG 45 Chance to drop double object 46 Increase in the potion 47 Chance to renovate PV 48 Immunizes against stunning 49 Immunizes against slowing 50 Immunizes against falls 52 Scope of Bow 53 Attack Value 54 Defense 55 Value magic attack 56 Magical Defense 58 Max Stamina 59 Bonus against Warriors 60 Bonus against the Ninja 61 Bonus against the Sura 62 Bonus against Shamans 63 Bonus against monsters 64 Attack Value (%) 65 Defence (%) 66 EXP (%) 67 Chance Drop Item 68 Chance Drop for Yang 69% max HP 70% max PM 71 Damage skill 72 Average Damage 73 Resistance against the damage of competence 74 Resistance against the average damage 76 Bonus EXP CyberCafé 77 iCafe Chance to find Yangs 78 Chance to parry an attack Warrior 79 Chance to parry an attack Ninja 80 Chance to parry an attack Sura 81 Chance to parry an attack Shaman My apologies for language mistakes