[TrinityCore] "Level_reward" | SQL zum Download

07/12/2013 12:27 °"Crazy"°#1
Hallo Community,

Ich stelle Euch von meinem [Only registered and activated users can see links. Click Here To Register...] erstellte SQL von einem aufgelösten Projekt frei zur Verfügung.
Diese SQL kam auf einem Highrateserver zum Einsatz.


Was machst die SQL?

Bei dem Level 10, Level 20 ... - Erfolg bekommt der Spieler eine Kiste zugeschickt. Der Inhalt ist auf dem Levelbereich abgestimmt worden. Pets und Mounts sind auch dabei, aber nur auf geringe Chance eingestellt.


Download unten!


Code:
SET @CreatureID := '';
SET @SenderName := '';

SET @itemID := '';
SET @Beutelname_10 := '';
SET @Beutelname_20 := '';
SET @Beutelname_30 := '';
SET @Beutelname_40 := '';
SET @Beutelname_50 := '';
SET @Beutelname_60 := '';
SET @Beutelname_70 := '';
SET @Beutelname_80 := '';

SET @moneten := ''; -- Angbe in Kupfer! 1000 Kupfer = 1 Gold

-- Mailsettings

SET @lvl_10_mail := '';
SET @lvl_20_mail := '';
SET @lvl_30_mail := '';
SET @lvl_40_mail := '';
SET @lvl_50_mail := '';
SET @lvl_60_mail := '';
SET @lvl_70_mail := '';
SET @lvl_80_mail := '';

SET @lvl_10_mail_text := '';
SET @lvl_20_mail_text := '';
SET @lvl_30_mail_text := '';
SET @lvl_40_mail_text := '';
SET @lvl_50_mail_text := '';
SET @lvl_60_mail_text := '';
SET @lvl_70_mail_text := '';
SET @lvl_80_mail_text := '';

-- DELETE


-- Sendercreature for reward
REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`)
VALUES (@CreatureID, 0, 0, 0, 0, 0, 10071, 0, 0, 0, @SenderName, '');

-- Achievement requirements
REPLACE INTO `achievement_reward` (`entry`, `title_A`, `title_H`, `item`, `sender`, `subject`, `text`)
VALUES ('6', '0', '0', @itemID, @CreatureID, @lvl_10_mail, @lvl_10_mail_text),
('7', '0', '0', @itemID+1, @CreatureID, @lvl_20_mail, @lvl_20_mail_text),
('8', '0', '0', @itemID+2, @CreatureID, @lvl_30_mail, @lvl_30_mail_text),
('9', '0', '0', @itemID+3, @CreatureID, @lvl_40_mail, @lvl_40_mail_text),
('10', '0', '0', @itemID+4, @CreatureID, @lvl_50_mail, @lvl_50_mail_text),
('11', '0', '0', @itemID+5, @CreatureID, @lvl_60_mail, @lvl_60_mail_text),
('12', '0', '0', @itemID+6, @CreatureID, @lvl_70_mail, @lvl_70_mail_text),
('13', '0', '0', @itemID+7, @CreatureID, @lvl_80_mail, @lvl_80_mail_text);

-- Template for Bags
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES 
(@itemID, 15, 0, -1, @Beutelname_10, 21202, 4, 4, 0, 1, 50, 12, 0, 32767, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000, 90000, 12340),
(@itemID+1, 15, 0, -1, @Beutelname_20, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten, 90000+@moneten, 12340),
(@itemID+2, 15, 0, -1, @Beutelname_30, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten+@moneten, 90000+@moneten+@moneten, 12340),
(@itemID+3, 15, 0, -1, @Beutelname_40, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten+@moneten+@moneten, 90000+@moneten+@moneten+@moneten, 12340),
(@itemID+4, 15, 0, -1, @Beutelname_50, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten+@moneten+@moneten+@moneten, 90000+@moneten+@moneten+@moneten+@moneten, 12340),
(@itemID+5, 15, 0, -1, @Beutelname_60, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten+@moneten+@moneten+@moneten+@moneten, 90000+@moneten+@moneten+@moneten+@moneten+@moneten, 12340),
(@itemID+6, 15, 0, -1, @Beutelname_70, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten+@moneten+@moneten+@moneten+@moneten+@moneten, 90000+@moneten+@moneten+@moneten+@moneten+@moneten+@moneten, 12340),
(@itemID+7, 15, 0, -1, @Beutelname_80, 21202, 1, 4, 0, 1, 0, 0, 0, -1, -1, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 50000+@moneten+@moneten+@moneten+@moneten+@moneten+@moneten+@moneten, 90000+@moneten+@moneten+@moneten+@moneten+@moneten+@moneten+@moneten, 12340);

-- Loottemplate for Bags

INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
(@itemID, 46778, 100, 1, 0, 5, 20),
(@itemID, 21841, 30, 1, 0, 0, 1),
(@itemID, 2456, 100, 1, 0, 10, 20),
(@itemID, 49283, 1, 1, 0, 0, 1),
(@itemID, 36911, 10, 1, 0, 0, 1),

(@itemID+1, 38577, 100, 1, 0, 5, 20),
(@itemID+1, 21841, 30, 1, 0, 0, 1),
(@itemID+1, 45621, 100, 1, 0, 3, 20),
(@itemID+1, 49283, 1, 1, 0, 0, 1),
(@itemID+1, 36911, 10, 1, 0, 0, 1),

(@itemID+2, 38233, 100, 1, 0, 5, 20),
(@itemID+2, 8951, 100, 1, 0, 5, 14),
(@itemID+2, 3826, 100, 1, 0, 2, 18),
(@itemID+2, 49283, 1, 1, 0, 1, 1),
(@itemID+2, 49663, 10, 1, 0, 1, 1),

(@itemID+3, 46778, 100, 1, 0, 5, 20),
(@itemID+3, 9088, 100, 1, 0, 2, 7),
(@itemID+3, 9224, 100, 1, 0, 0, 20),
(@itemID+3, 49283, 1, 1, 0, 0, 1),
(@itemID+3, 49663, 10, 1, 0, 0, 1),

(@itemID+4, 38577, 100, 1, 0, 5, 20),
(@itemID+4, 22823, 100, 1, 0, 1, 8),
(@itemID+4, 32062, 100, 1, 0, 2, 9),
(@itemID+4, 49284, 1, 1, 0, 0, 1),
(@itemID+4, 49693, 10, 1, 0, 0, 1),

(@itemID+5, 38233, 100, 1, 0, 5, 20),
(@itemID+5, 32063, 100, 1, 0, 1, 13),
(@itemID+5, 22830, 100, 1, 0, 1, 6),
(@itemID+5, 49284, 1, 1, 0, 0, 1),
(@itemID+5, 49693, 10, 1, 0, 0, 1),

(@itemID+6, 46778, 100, 1, 0, 5, 20),
(@itemID+6, 13510, 100, 1, 0, 0, 3),
(@itemID+6, 13513, 100, 1, 0, 0, 2),
(@itemID+6, 49284, 1, 1, 0, 0, 1),
(@itemID+6, 49662, 10, 1, 0, 0, 1),

(@itemID+7, 38577, 100, 1, 0, 5, 20),
(@itemID+7, 40076, 100, 1, 0, 5, 10),
(@itemID+7, 22851, 100, 1, 0, 0, 3),
(@itemID+7, 49284, 1, 1, 0, 0, 1),
(@itemID+7, 49662, 10, 1, 0, 0, 1),

(@itemID+8, 38233, 100, 1, 0, 5, 20),
(@itemID+8, 46379, 100, 1, 0, 0, 1),
(@itemID+8, 46378, 100, 1, 0, 0, 1),
(@itemID+8, 46377, 100, 1, 0, 0, 1),
(@itemID+8, 46376, 100, 1, 0, 0, 1),
(@itemID+8, 49284, 1, 1, 0, 0, 1),
(@itemID+8, 56806, 10, 1, 0, 0, 1);
Folgendes muss rein:

SET @Beutelname_10 := ''; - Name des Beutels
SET @lvl_10_mail := ''; - Brieftitel
SET @lvl_10_mail_text := ''; - Brieftext


[Only registered and activated users can see links. Click Here To Register...]

Viel Spaß damit.
Solltet Ihr Anregungen haben, was ich als nächstes machen soll, schreibt mir einfach eine PN.


Bitte beachtet, dass ich der Ersteller bin und gebt, wenn Ihr das Script weiter verbreitet, immer diese Quelle an bzw. verlinkt mein Profil von e*pvp.
Ausnahmen nur schriftlich via PN - System!