Thread: [SQL] (Project Anthrax) How to make your own leveling road

Hello again MMoTop,

I am here this time to teach you how how to make your own leveling road with creatures. A leveling road is a road filled with monsters level 1-255 or which ever level your server ranges too.

Any how what you want to do is:

First: Copy this sql query that I have generously written out for you into notepad, next go to save as and type level 1-5.sql. Make sure the filename is .sql then change the save as type to all files.

Second: Now that the file is made you can edit it, edit the following the entry id to a unique number that is not already used in you world database you will need to do this for every creature. Then the monsters name. Now most important change the minlevel, maxlevel and creature stats then save!

Third: Now that you are done open your Navicat or Mysql Client, expand the world database and execute your creature into the world database.

Fourth: Go in game and spawn your creature using the command .npc spawn yourentryid then leave a space and put 1 to save the pos gps!

Code:

How save your Leveling road location: While in game enter in the command .recall add yourareaname 1

To go back to it: Enter .recall port yourareaname 

Code:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('91234', "THE NEWB BEAST", "Project Anthrax", '', '0', '7', '0', '0', '0', '0', '	1056', '0', '0', '0', '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`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `summonguard`) 
values ('91234', '1', '5', '7', '50', '90', '50', '1', '0', '1000', '0', '10', '30', '0', '0', '0', '0', '30000', '0', '0', '0', '0', '0', '0', '0', '0', '0', "0", '0', '1000000', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '0');

Code:

This guide and script was created by Rappelz for patch 3.3.5a+

Thank's

thx

Thank you for sharing this, this will be VERY helpful to some.