Register for your free account! | Forgot your password?

Go Back   elitepvpers > World of Warcraft > WoW Private Server > WoW PServer Hosting
You last visited: Today at 02:15

  • Please register to post and access all features, it's quick, easy and FREE!

 

[TrinityCore] "Level_reward" | SQL zum Download

Reply
 
Old   #1
 
elite*gold: 2693
Join Date: Jul 2010
Posts: 6,449
Received Thanks: 1,224
[TrinityCore] "Level_reward" | SQL zum Download

Hallo Community,

Ich stelle Euch von meinem 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, [email protected]en, [email protected], 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, [email protected][email protected], [email protected][email protected], 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, [email protected][email protected][email protected], [email protected][email protected][email protected], 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, [email protected][email protected][email protected][email protected], [email protected][email protected][email protected][email protected], 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, [email protected][email protected][email protected][email protected][email protected], [email protected][email protected][email protected][email protected][email protected], 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, [email protected][email protected][email protected][email protected][email protected][email protected], [email protected][email protected][email protected][email protected][email protected][email protected], 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, [email protected][email protected][email protected][email protected][email protected][email protected][email protected], [email protected][email protected][email protected][email protected][email protected][email protected][email protected], 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




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!



°"Crazy"° is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 02:15.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.