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