![[Release] Send uppgraded items at create of character](https://www.elitepvpers.com/forum/iconimages/4story/release-send-uppgraded-items-create-character_ltr.gif){kind=small}
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
You just did different.
