[Release] Send uppgraded items at create of character

Those functions will send to all created characters (by letter) equipement at max level of uppgrade (+24) with options on them - random effects, cloak, accessory and weapons also included.

Some items are missing, so add them yourself.

1 Step - Do a backup of TCreateChar if you would revert it.

2 Step - duplicate twice the function TMagicItemGive, rename them with TMagicItemGive2 and TMagicItemGive3.

3 Step - Replace the following functions with this code.
TMagicItemGive2 sends uppgraded eq (+24), TMagicItemGive3 sends non-uppgraded eq

Note: If you didn't got the new effects please change on TMagicItemGive2: "SET @Upper = 9" to SET @Upper = 5

TCreateChar (Before -- RETURN @@ERROR)



TMagicItemGive2

TMagicItemGive3
made by pedo(jibi1996) and leandro(kingarthurr)

And the credits? ^^

#Edit: Thanks :P

Quote:

Originally Posted by kingarturr And the credits? ^^ #Edit: Thanks :P

you're welcome

Quote:

ions will send to all created characters (by letter) equipement at max level of uppgrade (+24) with options on them - random effects, cloak, accessory and weapons also included.

lol this script is similar at mine but you included cloak and accessory lol, good for the commitment but at least you could chenge the name of variables xD

Sicarium I have give you the idea ;) You just did different.

Quote:

Originally Posted by jibi1996 Those functions will send to all created characters (by letter) equipement at max level of uppgrade (+24) with options on them - random effects, cloak, accessory and weapons also included. Some items are missing, so add them yourself. 1 Step - Do a backup of TCreateChar if you would revert it. 2 Step - duplicate twice the function TMagicItemGive, rename them with TMagicItemGive2 and TMagicItemGive3. 3 Step - Replace the following functions with this code. TMagicItemGive2 sends uppgraded eq (+24), TMagicItemGive3 sends non-uppgraded eq Note: If you didn't got the new effects please change on TMagicItemGive2: "SET @Upper = 9" to SET @Upper = 5 TCreateChar (Before -- RETURN @@ERROR) Code: -- Send Archer Items -- SELECT @bClass = bClass FROM TCHARTABLE WHERE dwUserID=@dwUserID IF (@bClass = 2) BEGIN SET @bLevel = 24 SET @szTitle = 'ZIEGEN4S - Start Equipements' SET @szMessage = 'Make sure you bought bags before take your equipement!' EXEC TMagicItemGive2 @szName, 26605, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26606, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26607, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26608, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26609, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26705, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26706, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26707, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26708, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26709, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26905, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26906, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26907, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26908, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26909, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27157, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27158, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27159, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27160, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27161, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11946, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11947, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11948, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11949, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11950, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26805, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26806, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26807, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26808, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26809, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11951, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11952, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11953, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11954, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11955, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 7001, @szTitle, @szMessage, 12, 4, 87, 4, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23005, @szTitle, @szMessage, 11, 54, 13, 13, 55, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23105, @szTitle, @szMessage, 11, 54, 13, 13, 55, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11925, @szTitle, @szMessage, 11, 54, 13, 13, 55, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27136, @szTitle, @szMessage, 11, 54, 13, 13, 55, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11919, @szTitle, @szMessage, 11, 38, 13, 13, 54, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11926, @szTitle, @szMessage, 11, 11, 13, 13, 54, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22005, @szTitle, @szMessage, 11, 38, 13, 13, 54, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22105, @szTitle, @szMessage, 11, 38, 13, 13, 54, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 2, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 2, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1592, @szTitle, @szMessage, 2, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 2, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 2, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 END -- Send Wizz Items -- IF (@bClass = 3) BEGIN EXEC TMagicItemGive2 @szName, 26005, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26006, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26007, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26008, @szTitle, @szMessage, 12, 5, 87, 5, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26009, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26205, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26206, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26207, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26208, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26209, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26105, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26106, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26107, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26108, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26109, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26305, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26306, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26307, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26308, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26309, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11931, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11932, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11933, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11934, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11935, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11936, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11937, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11938, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11939, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11940, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27142, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27143, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27144, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27145, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27146, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27147, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27148, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27149, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27150, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27151, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 7001, @szTitle, @szMessage, 12, 4, 87, 4, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23905, @szTitle, @szMessage, 20, 19, 21, 30, 56, 17, 86, 79, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23805, @szTitle, @szMessage, 20, 19, 21, 30, 56, 17, 86, 79, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1591, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 END --Send Warrior Items -- IF (@bClass = 0) BEGIN EXEC TMagicItemGive2 @szName, 27005, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27006, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27007, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27008, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27009, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26805, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26806, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26807, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26808, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26809, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26905, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26906, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26907, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26908, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26909, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27105, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27106, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27107, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27108, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27109, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11951, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11952, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11953, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11954, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11955, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11956, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11957, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11958, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11959, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11960, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 7001, @szTitle, @szMessage, 12, 4, 87, 4, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23005, @szTitle, @szMessage, 11, 54, 13, 13, 55, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23105, @szTitle, @szMessage, 11, 54, 13, 13, 55, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11919, @szTitle, @szMessage, 11, 38, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22105, @szTitle, @szMessage, 11, 38, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22205, @szTitle, @szMessage, 11, 38, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22405, @szTitle, @szMessage, 11, 54, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22505, @szTitle, @szMessage, 11, 54, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11927, @szTitle, @szMessage, 12, 15, 34, 22, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23505, @szTitle, @szMessage, 12, 15, 34, 22, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1591, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 END --Send Assassin Items -- IF (@bClass = 1) BEGIN EXEC TMagicItemGive2 @szName, 26605, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26606, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26607, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26608, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26609, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26705, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26706, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26707, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26708, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26709, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27157, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27158, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27159, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27160, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27161, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11946, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11947, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11948, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11949, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11950, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26405, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26406, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26407, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26408, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26409, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26505, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26506, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26507, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26508, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26509, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27152, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27153, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27154, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27155, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27156, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11941, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11942, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11943, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11944, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11945, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 7001, @szTitle, @szMessage, 12, 4, 87, 4, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23005, @szTitle, @szMessage, 11, 54, 13, 13, 55, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23105, @szTitle, @szMessage, 11, 54, 13, 13, 55, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11919, @szTitle, @szMessage, 11, 38, 13, 13, 54, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11926, @szTitle, @szMessage, 11, 11, 13, 13, 54, 17, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22605, @szTitle, @szMessage, 11, 54, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 22705, @szTitle, @szMessage, 11, 54, 13, 13, 54, 18, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1591, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 1, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 END --Send Summoner Items -- IF (@bClass = 5) BEGIN EXEC TMagicItemGive2 @szName, 26605, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26606, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26607, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26608, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26609, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26705, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26706, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26707, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26708, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26709, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27157, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27158, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27159, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27160, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27161, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11946, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11947, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11948, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11949, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11950, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26405, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26406, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26407, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26408, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26409, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26505, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26506, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26507, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26508, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26509, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27152, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27153, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27154, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27155, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27156, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11941, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11942, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11943, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11944, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11945, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 7001, @szTitle, @szMessage, 12, 4, 87, 4, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23905, @szTitle, @szMessage, 20, 19, 21, 30, 56, 17, 86, 79, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23805, @szTitle, @szMessage, 20, 19, 21, 30, 56, 17, 86, 79, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1591, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 END --Send Priest Items -- IF (@bClass = 4) BEGIN EXEC TMagicItemGive2 @szName, 26005, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26006, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26007, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26008, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26009, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26205, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26206, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26207, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26208, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26209, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26105, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26106, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26107, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26108, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26109, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26305, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26306, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26307, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26308, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 26309, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11931, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11932, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11933, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11934, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11935, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11936, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11937, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11938, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11939, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 11940, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27142, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27143, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27144, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27145, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27146, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27147, @szTitle, @szMessage, 12, 7, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27148, @szTitle, @szMessage, 12, 10, 87, 10, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27149, @szTitle, @szMessage, 12, 7, 87, 7, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27150, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 27151, @szTitle, @szMessage, 12, 5, 87, 6, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 7001, @szTitle, @szMessage, 12, 4, 87, 4, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23905, @szTitle, @szMessage, 20, 19, 21, 22, 56, 17, 86, 79, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23805, @szTitle, @szMessage, 20, 19, 21, 22, 56, 17, 86, 79, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23705, @szTitle, @szMessage, 20, 19, 21, 22, 56, 17, 86, 65, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 23605, @szTitle, @szMessage, 20, 19, 21, 22, 56, 17, 86, 65, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 24005, @szTitle, @szMessage, 87, 15, 34, 22, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 24105, @szTitle, @szMessage, 87, 15, 34, 22, 0, 0, 0, 0, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 5, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 5, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1591, @szTitle, @szMessage, 5, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 5, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 5, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 4, 11, 3, 1, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7210, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive2 @szName, 1591, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 EXEC TMagicItemGive3 @szName, 7310, @szTitle, @szMessage, 4, 11, 3, 11, 50, 130, 51, 150, 0, 0, 0, 0 END TMagicItemGive2 Code: ALTER PROCEDURE [dbo].[TMagicItemGive2] @szRecver VARCHAR(50), @wItemID SMALLINT, @szTitle VARCHAR(256), @szMessage VARCHAR(2048), @bMagic1 TINYINT = 0, @wValue1 SMALLINT = 0, @bMagic2 TINYINT = 0, @wValue2 SMALLINT = 0, @bMagic3 TINYINT = 0, @wValue3 SMALLINT = 0, @bMagic4 TINYINT = 0, @wValue4 SMALLINT = 0, @bMagic5 TINYINT = 0, @wValue5 SMALLINT = 0, @bMagic6 TINYINT = 0, @wValue6 SMALLINT = 0 AS DECLARE @dwCharID INT DECLARE @bLenTitle BINARY(4) DECLARE @bLenMessage BINARY(4) DECLARE @szT VARCHAR(8) DECLARE @szM VARCHAR(8) DECLARE @szSender VARCHAR(50) SET @szSender ='Ziegen4S' SET @szMessage ='Weapons' SELECT @dwCharID=dwCharID FROM TCHARTABLE WHERE szName=@szRecver AND bDelete = 0 IF @@ROWCOUNT = 0 BEGIN PRINT 'FAIL' RETURN 1 END SET @bLenTitle = DATALENGTH(@szTitle) SET @bLenMessage = DATALENGTH(@szMessage) SET @szT = RIGHT(master.dbo.fn_sqlvarbasetostr(@bLenTitle), 8) SET @szTitle = @szT + @szTitle SET @szM = RIGHT(master.dbo.fn_sqlvarbasetostr(@bLenMessage), 8) SET @szMessage = @szM + @szMessage DECLARE @bRvType TINYINT DECLARE @fRevision FLOAT DECLARE @wMaxValue SMALLINT DECLARE @wRetValue1 SMALLINT DECLARE @wRetValue2 SMALLINT DECLARE @wRetValue3 SMALLINT DECLARE @wRetValue4 SMALLINT DECLARE @wRetValue5 SMALLINT DECLARE @wRetValue6 SMALLINT -- Magic1 IF(@bMagic1 = 0 ) SET @wRetValue1 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic1 IF @wValue1 > @wMaxValue SET @wValue1 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue1 = @wValue1 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic2 IF(@bMagic2 = 0 ) SET @wRetValue2 = 0 ELSE BEGIN SELECT @bRvType = bRvType , @wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic2 IF @wValue2 > @wMaxValue SET @wValue2 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue2 = @wValue2 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic3 IF(@bMagic3 = 0 ) SET @wRetValue3 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic3 IF @wValue3 > @wMaxValue SET @wValue3 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue3 = @wValue3 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic4 IF(@bMagic4 = 0 ) SET @wRetValue4 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic4 IF @wValue4 > @wMaxValue SET @wValue4 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue4 = @wValue4 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic5 IF(@bMagic5 = 0 ) SET @wRetValue5 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic5 IF @wValue5 > @wMaxValue SET @wValue5 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue5 = @wValue5 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic6 IF(@bMagic6 = 0 ) SET @wRetValue6 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic6 IF @wValue6 > @wMaxValue SET @wValue6 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue6 = @wValue6 * 100.0 / @wMaxValue/@fRevision + 1.0 END DECLARE @dwDuraMax INT SET @dwDuraMax = 0 SELECT @dwDuraMax = dwDuraMax FROM TITEMCHART WHERE wItemID = @wItemID --Random Effects Function Started Brah brahh -- ---- Create the variables for the random number generation and Item Grade LEVEL DECLARE @bLevel TINYINT; DECLARE @Random INT; DECLARE @Upper INT; DECLARE @Lower INT SET @bLevel = 24 ---- This will create a random number between 1 and 9 (effects) SET @Lower = 1 ---- The lowest random number SET @Upper = 9 ---- The highest random number SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0) SELECT @Random INSERT INTO TRESERVEDPOST( dwRecverID, szSender, szTitle, szMessage, bSend, wItemID, bLevel, bCount, bGLevel, dwDuraMax, dwDuraCur, bGradeEffect, bRefineCur, dEndTime, bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6, wValue1, wValue2, wValue3, wValue4, wValue5, wValue6, dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6) VALUES( @dwCharID, @szSender, @szTitle, @szMessage, 0, @wItemID, @bLevel, 1, 0, @dwDuraMax, @dwDuraMax, @Random, 0, 0, @bMagic1,@bMagic2,@bMagic3,@bMagic4,@bMagic5,@bMagic6, @wRetValue1,@wRetValue2,@wRetValue3,@wRetValue4,@wRetValue5,@wRetValue6, 0,0,0,0,0,0) RETURN 0 TMagicItemGive3 Code: ALTER PROCEDURE [dbo].[TMagicItemGive3] @szRecver VARCHAR(50), @wItemID SMALLINT, @szTitle VARCHAR(256), @szMessage VARCHAR(2048), @bMagic1 TINYINT = 0, @wValue1 SMALLINT = 0, @bMagic2 TINYINT = 0, @wValue2 SMALLINT = 0, @bMagic3 TINYINT = 0, @wValue3 SMALLINT = 0, @bMagic4 TINYINT = 0, @wValue4 SMALLINT = 0, @bMagic5 TINYINT = 0, @wValue5 SMALLINT = 0, @bMagic6 TINYINT = 0, @wValue6 SMALLINT = 0 AS DECLARE @dwCharID INT DECLARE @bLenTitle BINARY(4) DECLARE @bLenMessage BINARY(4) DECLARE @szT VARCHAR(8) DECLARE @szM VARCHAR(8) DECLARE @szSender VARCHAR(50) SET @szSender ='Ziegen4S' SET @szMessage ='Accessory' SELECT @dwCharID=dwCharID FROM TCHARTABLE WHERE szName=@szRecver AND bDelete = 0 IF @@ROWCOUNT = 0 BEGIN PRINT 'FAIL' RETURN 1 END SET @bLenTitle = DATALENGTH(@szTitle) SET @bLenMessage = DATALENGTH(@szMessage) SET @szT = RIGHT(master.dbo.fn_sqlvarbasetostr(@bLenTitle), 8) SET @szTitle = @szT + @szTitle SET @szM = RIGHT(master.dbo.fn_sqlvarbasetostr(@bLenMessage), 8) SET @szMessage = @szM + @szMessage DECLARE @bRvType TINYINT DECLARE @fRevision FLOAT DECLARE @wMaxValue SMALLINT DECLARE @wRetValue1 SMALLINT DECLARE @wRetValue2 SMALLINT DECLARE @wRetValue3 SMALLINT DECLARE @wRetValue4 SMALLINT DECLARE @wRetValue5 SMALLINT DECLARE @wRetValue6 SMALLINT -- Magic1 IF(@bMagic1 = 0 ) SET @wRetValue1 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic1 IF @wValue1 > @wMaxValue SET @wValue1 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue1 = @wValue1 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic2 IF(@bMagic2 = 0 ) SET @wRetValue2 = 0 ELSE BEGIN SELECT @bRvType = bRvType , @wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic2 IF @wValue2 > @wMaxValue SET @wValue2 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue2 = @wValue2 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic3 IF(@bMagic3 = 0 ) SET @wRetValue3 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic3 IF @wValue3 > @wMaxValue SET @wValue3 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue3 = @wValue3 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic4 IF(@bMagic4 = 0 ) SET @wRetValue4 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic4 IF @wValue4 > @wMaxValue SET @wValue4 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue4 = @wValue4 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic5 IF(@bMagic5 = 0 ) SET @wRetValue5 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic5 IF @wValue5 > @wMaxValue SET @wValue5 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue5 = @wValue5 * 100.0 / @wMaxValue/@fRevision + 1.0 END -- Magic6 IF(@bMagic6 = 0 ) SET @wRetValue6 = 0 ELSE BEGIN SELECT @bRvType = bRvType,@wMaxValue = wMaxValue FROM TITEMMAGICCHART WHERE bMagic = @bMagic6 IF @wValue6 > @wMaxValue SET @wValue6 = @wMaxValue SELECT @fRevision = CASE WHEN @bRvType = 1 THEN fRevision WHEN @bRvType = 2 THEN fMRevision WHEN @bRvType = 3 THEN fAtRate WHEN @bRvType = 4 THEN fMAtRate ELSE 1.0 END FROM TITEMCHART WHERE wItemID = @wItemID SET @wRetValue6 = @wValue6 * 100.0 / @wMaxValue/@fRevision + 1.0 END DECLARE @dwDuraMax INT SET @dwDuraMax = 0 SELECT @dwDuraMax = dwDuraMax FROM TITEMCHART WHERE wItemID = @wItemID --Random Effects Function Started Brah brahh -- ---- Create the variables for the random number generation and Item Grade LEVEL DECLARE @bLevel TINYINT; DECLARE @Random INT; DECLARE @Upper INT; DECLARE @Lower INT SET @bLevel = 0 ---- This will create a random number between 1 and 9 (effects) SET @Lower = 1 ---- The lowest random number SET @Upper = 9 ---- The highest random number SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0) SELECT @Random INSERT INTO TRESERVEDPOST( dwRecverID, szSender, szTitle, szMessage, bSend, wItemID, bLevel, bCount, bGLevel, dwDuraMax, dwDuraCur, bGradeEffect, bRefineCur, dEndTime, bMagic1, bMagic2, bMagic3, bMagic4, bMagic5, bMagic6, wValue1, wValue2, wValue3, wValue4, wValue5, wValue6, dwTime1, dwTime2, dwTime3, dwTime4, dwTime5, dwTime6) VALUES( @dwCharID, @szSender, @szTitle, @szMessage, 0, @wItemID, @bLevel, 1, 0, @dwDuraMax, @dwDuraMax, @Random, 0, 0, @bMagic1,@bMagic2,@bMagic3,@bMagic4,@bMagic5,@bMagic6, @wRetValue1,@wRetValue2,@wRetValue3,@wRetValue4,@wRetValue5,@wRetValue6, 0,0,0,0,0,0) RETURN 0 made by pedo(jibi1996) and leandro(kingarthurr)

What's weird is that you waited until the code is removed to put your but yours is almost the same as that of A then sicarium

Everything I do not like this since it is removing public function more thread is created to replace it's function and putting good by me while sicarium had created before anyways a small CloseRequest to copy? would be placed.

Quote:

Originally Posted by kingarturr And the credits? ^^ #Edit: Thanks :P

Your name is leandro??
Alejandro, alejandro.....is just a troll.
[Only registered and activated users can see links. Click Here To Register...]

Elitetuerie I won't discuss with you, this function I made much much times before Sicarium.
His function is totally different from mine, his function only changes the lvl 1 eq that you get when you create a character, so stop saying things that doesn't fit here.

Elitetuerie, there's things in the world that is not your or of your team, i make it with pedo, and he released it, much time after created. what you want? he releases while is another post with same function of our code? i think, no

So shut up, nothin' is copied here. we created it before ziegen4s open.

I'm making new things for 4story, so its don't release, never;

i'm sorry to be against you again, but you deserve ;)

Quote:

Originally Posted by OnePippa Your name is leandro?? Alejandro, alejandro.....is just a troll. [Only registered and activated users can see links. Click Here To Register...]

Leandro at brazil is normal, so, its my name at skype.

i'll consider your post as spam ;)