Solar Pack

[Trle94]

First of all hey every one didnt saw you long time
Questions:
Why did you named this "PACK"??
-Well because there are few Sql(Structured Query Language) files..
What is in that rar file???
-2 Main Folders( Mangos, Arcemu) and 2 text files( TODO and List of NPC IDs )
Mangos folder contains Vendors( Inside is all in one,all in one npcs and all in one vendors )
Arcemu folder conatins Solar Leveling road ( Only mobs + spawn ), Trainers ( only class trainers ) and Vendors ( Same as Mangos )
How much you needed to make it??
- 24h i think :P
When will be next update??
-I will try my best to every day upgrade at least one main folder ( Arcemu or Mangos)
Can i see here list of vendors,leveling mobs and trainers??
- Yes you can..
Here:

88000-Leveling 1-5 mob
88001-Leveling 5-10 mob
88002-Leveling 10-15 mob
88003-Leveling 15-20 mob
88004-Leveling 20-25 mob
88005-Leveling 25-30 mob
88006-Leveling 30-35 mob
88007-Leveling 35-40 mob
88008-Leveling 40-45 mob
88009-Leveling 45-50 mob
88010-Leveling 50-55 mob
88011-Leveling 55-60 mob
88012-Leveling 60-65 mob
88013-Leveling 65-70 mob
88014-Leveling 70-75 mob
88015-Leveling 75-80 mob
88016-Leveling 80-85 mob
88017-Leveling 85-90 mob
88018-Leveling 90-95 mob
88019-Leveling 95-100 mob
88020-Leveling 100-105 mob
88021-Leveling 105-110 mob
88022-Leveling 110-115 mob
88023-Leveling 115-120 mob
88024-Leveling 120-125 mob
88025-Leveling 125-130 mob
88026-Leveling 130-135 mob
88027-Leveling 135-140 mob
88028-Leveling 140-145 mob
88029-Leveling 145-150 mob
88030-Leveling 150-155 mob
88031-Leveling 155-160 mob
88032-Leveling 160-165 mob
88033-Leveling 165-170 mob
88034-Leveling 170-175 mob
88035-Leveling 175-180 mob
88036-Leveling 180-185 mob
88037-Leveling 185-190 mob
88038-Leveling 190-195 mob
88039-Leveling 195-200 mob
88040-Leveling 200-205 mob
88041-Leveling 205-210 mob
88042-Leveling 210-215 mob
88043-Leveling 215-220 mob
88044-Leveling 220-225 mob
88045-Leveling 225-230 mob
88046-Leveling 230-235 mob
88047-Leveling 235-240 mob
88048-Leveling 240-245 mob
88049-Leveling 245-250 mob
88050-Leveling 250-255 mob
88051-Leveling 255-260 mob
88052-Leveling 260-265 mob
88053-Leveling 265-270 mob
88054-Leveling 270-275 mob
88055-Leveling 275-280 mob
88056-Leveling 280-285 mob
88057-Leveling 285-290 mob
88058-Leveling 290-295 mob
88059-Leveling 295-300 mob
88060-Warrior Trainer
88061-Mage Trainer
88062-Shaman Trainer
88063-Warlock Trainer
88064-Priest Trainer
88065-Hunter Trainer
88066-Paladin Trainer
88067-Druid Trainer
88068-Rogue Trainer
88069-Deathking Trainer
88070-Cloaks
88071-Off-Hand Frills
88072-Shields
88073-Amulets
88074-Rings
88075-Trinkets
88076-Idols
88077-Librams
88078-Totems
88079-Sigils
88080-Bags
88081-Bags (Other)
88082-Bandages
88083-Elixirs (Battle)
88084-Elixirs (Guardian)
88085-Flasks
88086-Enhancements (Permanent)
88087-Scrolls
88088-Potions
88089-Alcohol
88090-Meta Gems Vendor
88091-Orange Gems Vendor
88092-Green Gems Vendor
88093-Purple Gems Vendor
88094-Yellow Gems Vendor
88095-Blue Gems Vendor
88096-Red Gems Vendor
88097-Reagents Vendor
88098-Currency
88099-Ammo Pouch Vendor
88100-Quiver Vendor
88101-Death Knight Tier  Vendor
88102-Mage Tier  Vendor
88103-Druid Tier  Vendor
88104-Paladin Tier  Vendor
88105-Priest Tier  Vendor
88106-Shaman Tier  Vendor
88107-Hunter Tier  Vendor
88108-Warrior Tier  Vendor
88109-Warlock Tier  Vendor
88110-Rogue Tier  Vendor
88111-Death Knight Tier  Vendor
88112-Druid Tier  Vendor
88113-Hunter Tier  Vendor
88114-Mage Tier  Vendor
88115-Paladin Tier  Vendor
88116-Priest Tier  Vendor
88117-Rogue Tier  Vendor
88118-Shaman Tier  Vendor
88119-Warlock Tier  Vendor
88120-Warrior Tier  Vendor
88121-Weapons (Ranged)
88122-Weapons (TwoHand)
88123-Weapons (OneHand  MainHand  OffHand)
88124-Glyphs (Death Knight)
88125-Glyphs (Druid)
88126-Glyphs (Hunter)
88127-Glyphs (Mage)
88128-Glyphs (Paladin)
88129-Glyphs (Priest)
88130-Glyphs (Rogue)
88131-Glyphs (Shaman)
88132-Glyphs (Warlock)
88133-Glyphs (Warrior)
88134-Chest Armor (Cloth)
88135-Feet Armor (Cloth)
88136-Hands Armor (Cloth)
88137-Head Armor (Cloth)
88138-Legs Armor (Cloth)
88139-Shoulder Armor (Cloth)
88140-Waist Armor (Cloth)
88141-Wrist Armor (Cloth)
88142-Chest Armor (Leather)
88143-Feet Armor (Leather)
88144-Hands Armor (Leather)
88145-Head Armor (Leather)
88146-Legs Armor (Leather)
88147-Shoulder Armor (Leather)
88148-Waist Armor (Leather)
88149-Wrist Armor (Leather)
88150-Chest Armor (Mail)
88151-Feet Armor (Mail)
88152-Hands Armor (Mail)
88153-Head Armor (Mail)
88154-Legs Armor (Mail)
88155-Shoulder Armor (Mail)
88156-Waist Armor (Mail)
88157-Wrist Armor (Mail)
88158-Chest Armor (Plate)
88159-Feet Armor (Plate)
88160-Hands Armor (Plate)
88161-Head Armor (Plate)
88162-Legs Armor (Plate)
88163-Shoulder Armor (Plate)
88164-Waist Armor (Plate)
88165-Wrist Armor (Plate)
88166-Cloth Vendor (Trade Goods)
88167-Devices Vendor (Trade Goods)
88168-Elemental Vendor (Trade Goods)
88169-Enchanting Vendor (Trade Goods)
88170-Explosives Vendor (Trade Goods)
88171-Herbs Vendor (Trade Goods)
88172-Jewelcrafting Vendor (Trade Goods)
88173-Leather Vendor (Trade Goods)
88174-Metal and Stone Vendor (Trade Goods)
88175-Meat Vendor (Trade Goods)
88176-Alchemy Recipes (Common)
88177-Alchemy Recipes (Uncommon)
88178-Alchemy Recipes (Rare)
88179-Blacksmithing Recipes (Common)
88180-Blacksmithing Recipes (Uncommon)
88181-Blacksmithing Recipes (Rare)
88182-Blacksmithing Recipes (Epic)
88183-Cooking Recipes (Common)
88184-Cooking Recipes (Uncommon, Rare, Epic)
88185-Enchanting Recipes (Common)
88186-Enchanting Recipes (Uncommon)
88187-Enchanting Recipes (Rare, Epic)
88188-Engineering Recipes (Common)
88189-Engineering Recipes (Uncommon)
88190-Engineering Recipes (Rare, Epic)
88191-Jewelcrafting Recipes (Common)
88192-Jewelcrafting Recipes (Uncommon)
88193-Jewelcrafting Recipes (Rare)
88194-Jewelcrafting Recipes (Rare)(2)
88195-Jewelcrafting Recipes (Epic)
88196-Leatherworking Recipes (Common)
88197-Leatherworking Recipes (Uncommon)
88198-Leatherworking Recipes (Rare)
88199-Leatherworking Recipes (Epic)
88200-Tailoring Recipes (Common)
88201-Tailoring Recipes (Uncommon)
88202-Tailoring Recipes (Rare)
88203-Tailoring Recipes (Epic)
88204-Mounts Vendor (Ground)
88205-Mounts Vendor (Flying)

What about pictures??
- Here are and pictures:
Leveling mobs:

http://img136.imageshack.us/img136/8717/wow6.jpg
http://img18.imageshack.us/img18/9192/wow4.jpg
http://img7.imageshack.us/img7/2910/wow5u.jpg

Trainers:

http://i734.photobucket.com/albums/ww350/onlykl/10234.jpg
http://i734.photobucket.com/albums/ww350/onlykl/28821.jpg

Vendors:

http://static.wowhead.com/uploads/screenshots/normal/108163.jpg

Why did you added pictures in "CODE" ??
-Because pictures are big and in this post will be big lag for those that have low internet connection..
How can i add this files to my db??
- Answer is here:

http://www.mmowned.com/forums/world-of-warcraft/emulator-servers/guides-tutorials/58820-guide-how-excute-sql-files-your-database.html

Can i use it on 3.3.3a repack??
-Yeah you can..
Can i repost somewhere?
- Yeah you can just give me credits...
Thats it folks i think
Ohh, sorry the most important thing... :P
Download:
Solar Pack.rar
Credits:
Onlykl aka Trle94
Followup for Guide -How To Excute SQL FILES In To Your Database

[BooMDeyada]

Very nice mate, welcome back! :]

[Trle94]

Thank you ))

[alj03]

Awesome. Updated to 3.3.5? :P

[Trle94]

Hmm idk maybe... some one need to give me first structure of sql what is changed for 3.3.5a

[Hyldran0]

i really like the Theard! It's really great and Really easy to understand!
I do also like the Releases you made and i'm really think you should keep it up!

I wont use it but if there is an update to 3.3.5 i would love to use it!

+rep x2

[Trle94]

Well i do not really know how 3.3.5 db structure looks like so if some one give it to me i will fix it And ofc i will give credits

[alj03]

I used it on my 3.3.5 realm and worked normally.

[Trle94]

So it works for 3.3.5a? :P

[Baltazarz]

Well, Arcemu says something of a non-existant "death_state" table in creature_proto. While looking thru updates i found this:

-- Moving death_state into creature_spawns table
ALTER TABLE `creature_spawns` ADD `death_state` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `standstate`;
ALTER TABLE `creature_staticspawns` ADD `death_state` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `standstate`;
UPDATE creature_spawns cs INNER JOIN creature_proto cp ON cs.Entry = cp.Entry SET cs.death_state = cp.death_state;
ALTER TABLE `creature_proto` DROP `death_state`;

-------edit-------
Here's the structure:

-- ----------------------------
-- Table structure for mycreature_proto
-- ----------------------------
DROP TABLE IF EXISTS `creature_proto`;
CREATE TABLE `creature_proto` (
`entry` int(30) unsigned NOT NULL DEFAULT '0',
`minlevel` int(30) unsigned NOT NULL,
`maxlevel` int(30) unsigned NOT NULL,
`faction` int(30) unsigned NOT NULL DEFAULT '0',
`minhealth` int(30) unsigned NOT NULL,
`maxhealth` int(30) unsigned NOT NULL,
`mana` int(30) unsigned NOT NULL DEFAULT '0',
`scale` float NOT NULL DEFAULT '0',
`npcflags` int(30) unsigned NOT NULL DEFAULT '0',
`attacktime` int(30) unsigned NOT NULL DEFAULT '0',
`attacktype` int(4) NOT NULL DEFAULT '0',
`mindamage` float NOT NULL DEFAULT '0',
`maxdamage` float NOT NULL DEFAULT '0',
`can_ranged` int(11) unsigned NOT NULL DEFAULT '0',
`rangedattacktime` int(30) unsigned NOT NULL DEFAULT '0',
`rangedmindamage` float unsigned NOT NULL DEFAULT '0',
`rangedmaxdamage` float unsigned NOT NULL DEFAULT '0',
`respawntime` int(30) unsigned NOT NULL DEFAULT '0',
`armor` int(30) unsigned NOT NULL DEFAULT '0',
`resistance1` int(30) unsigned NOT NULL DEFAULT '0',
`resistance2` int(30) unsigned NOT NULL DEFAULT '0',
`resistance3` int(30) unsigned NOT NULL DEFAULT '0',
`resistance4` int(30) unsigned NOT NULL DEFAULT '0',
`resistance5` int(30) unsigned NOT NULL DEFAULT '0',
`resistance6` int(30) unsigned NOT NULL DEFAULT '0',
`combat_reach` float NOT NULL DEFAULT '1',
`bounding_radius` float NOT NULL DEFAULT '1',
`auras` longtext NOT NULL,
`boss` int(11) unsigned NOT NULL DEFAULT '0',
`money` int(30) NOT NULL DEFAULT '0',
`invisibility_type` int(30) unsigned NOT NULL DEFAULT '0',
`walk_speed` float NOT NULL DEFAULT '2.5',
`run_speed` float NOT NULL DEFAULT '8',
`fly_speed` float NOT NULL DEFAULT '14',
`extra_a9_flags` int(30) NOT NULL DEFAULT '0',
`spell1` int(30) NOT NULL DEFAULT '0',
`spell2` int(30) NOT NULL DEFAULT '0',
`spell3` int(30) NOT NULL DEFAULT '0',
`spell4` int(30) NOT NULL DEFAULT '0',
`spell_flags` int(30) NOT NULL DEFAULT '0',
`modImmunities` int(30) unsigned NOT NULL DEFAULT '0',
`isTrainingDummy` int(10) unsigned NOT NULL DEFAULT '0',
`guardtype` int(10) unsigned NOT NULL DEFAULT '0',
`summonguard` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

[Baltazarz]

Really sorry for the repost, but I was wondering, when are you going to update?

[Nobel]

Very nice =)

[Trle94]

Im gonna update it when i finish with some script that im working on Thanks Nobel

[restlesspyro]

ArcEmu update is pretty easy :P

Filebeam - Beam up that File Scottie!

[Octagonmodz]

Nice post ! Does this work for trinity?