Thread: [SQL] Welcome NPC w/ Other Stuff

This is not made by me or mmopro.org team !!!

Credits: Saperior

I just made these sqls. This is basicly made for people who are too lazy to make this them selfs . It is best used on instant 80 fun realms too.

Download link will be at the bottom. Just need to show you guys what to change.

In the Welcome NPC sql:
(Change the text in red)

Code:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('50005', "Welcome Turtle", "Welcome to <Realm Name>", '', '0', '10', '0', '2', '0', '0', '16259', '0', '0', '0', '1', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('50005', '80', '80', '35', '83', '97', '5', '5', '1', '1000', '0', '3123', '123213', '0', '0', '0', '0', '0', '10000000000', '12312', '123123', '12321312', '123123', '123123', '1323123', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

The Guide Book:
(Change in red) (Oh and do NOT get rid of the $B4 stuff. Only the stuff in the "<>"

Code:

INSERT INTO items (entry, class, subclass, name1, name2, name3, name4, displayid, quality, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, description, page_id, page_language, page_material)
VALUES (858585, 15, 0, "Guide & Rules to <Realm Name> ", "Guide & Rules to <Realm Name> ", "Guide & Rules to <Realm Name> ", "Guide & Rules to <Realm Name>  ", 7139, 5, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 50000, 0, 1);

INSERT INTO itempages (entry, text, next_page) VALUES
('50000', 'Once you have recieved this book you should now be level 80 and have 5000g in your inventory. A good thing to do now is prolly to go sell those tokens. Once your done with that talk to the teleporter click on <Mall er W/e>. You will then buy the right gear you want for your class.. Learn all your spells... Put in your talents and your good to go.$B$BAny more questions just look on the FAQ page of our website or if its not there post on the forums!$B$BWebsite: <Website url> ', '2'), 
('2', '-___---__--Rules--__---___-$B$B1. <Rule #1>$B2. <Rule #2>$B3. <Rule #3>$B4. <Rule #4>$B5. <Rule #5>', '0');

The Quest:
(Change in Red)

Code:

INSERT INTO `quests` (`entry`, `ZoneId`, `sort`, `MinLevel`, `questlevel`, `Type`, `RequiredRaces`, `RequiredClass`, `srcItem`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `CompletionText`, `IncompleteText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqKillMobOrGOId1`, `ReqKillMobOrGOId2`, `ReqKillMobOrGOId3`, `ReqKillMobOrGOId4`, `ReqKillMobOrGOCount1`, `ReqKillMobOrGOCount2`, `ReqKillMobOrGOCount3`, `ReqKillMobOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewMoney`, `RewXP`, `RewardMoneyAtMaxLevel`, `RequiredQuest1`, `RequiredQuest2`, `RequiredQuest3`, `RequiredQuest4`, `IsRepeatable`, `bonushonor`, `rewardtalents`, `suggestedplayers`, `RequiredTradeskill`, `RequiredTradeskillValue`, `RequiredRepFaction`, `RequiredRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepFaction6`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewRepValue6`, `rewardtitleid`, `CastSpell`, `RewRepLimit`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `RequiredOneOfQuest`, `RemoveQuests`) 
VALUES ('99999', '0', '344', '1', '1', '83', '0', '0', '0', '0', 'Welcome to <Realm Name>', 'Welcome to <Realm Name>! We hope you have a nice stay with us. Don\'t forget to vote for us on our website! Oh almost forgot.. Talk to me again and ill give you a welcome gift from the <Server Name> staff!', 'Talk to me again, homie!', 'Here you go! Enjoy that now. Have a great time playing on <Server Name>', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '878787', '858585', '0', '0', '5', '1', '0', '0', '0', '10000000000000000000000000000000000000000000000000', '0', '0', '0', '0', '0', '0', '0', '0', '1000000000000000000000000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '77', '0', '0', '', '', '', '', '', '', '');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) 
VALUES ('50005', '99999');
INSERT INTO `creature_quest_starter` (`id`, `quest`) 
VALUES ('50005', '99999');

And that should cover it. Enjoy and heres the download

DOWNLOAD HERE: [Only registered and activated users can see links. ]

just wat i have been looking for thnx for share =D

Thanks for the share.

:P nice share

Thanks for it :)