The Result Of Doing This: (85% Fully Spawned DB W/ Recent Items and Loot Drops For 85% Of All Mobs)
Files You Will Need: (extract all of these to your c:\mysql\bin directory)
MW055-Alpha1-DB -
http://mwnpcmovdb.myftp.org/MW055_alpha1.zip
MW055-Alpha2-DB -
http://mwnpcmovdb.myftp.org/MW055_alpha_02.zip
Loot Updates -
http://home.gravyisgood.com/eqemu_do...pha2_addon.rar
Items Database -
http://emu.fliphost.net/files/itemdb.zip
Doors Update -- (RIGHT CLICK AND SAVE TARGET AS DOORSUPDATE.SQL)
http://cvs.sourceforge.net/viewcvs.p...mp;rev=1.1.1.1
Once all of the files are extracted and or copied to C:\MYSQL\BIN
(This Step Is Only Needed If You Don't Already Have MYSQL Admin Access)
1. Start>Run>Cmd
cd\mysql\bin
mysql -u root mysql
grant all privileges on *.* to username@localhost identified by 'password' with grant option;
quit
(Change "username" and "password" to what you used when you first installed mysql/winmysql) - (You can also change "localhost" to something like 192.168.1.101 or something similar if your using a linksys router you can use your internal network ip as well)
2. Start>Run>Cmd
mysql
create database eq;
quit
mysql -f eq<mw055_alpha1.sql (wait for it to finish)
mysql -f eq<mw055_alpha_02.sql (wait some more - will see errors but it will fly by fast without beeps and takes hours less time)
mysql -f eq<doorsupdate.sql
mysql
use eq;
delete from items;
quit
mysql -f eq<dumpeditems.sql;
mysql
use eq;
delete from loottable;
delete from loottable_entries;
delete from lootdrop;
delete from lootdrop_entries;
quit
mysql -f eq<v0.2 - loot_update.sql (wait for it to finish)
[warning this next step takes a ton of time, no matter what you do, so do it before u go to bed lol] (Doing This Update Took 4hrs On My Intel 850mhz Gateway Laptop - Estimated)
mysql -f eq<v0.2 - npc_types_update.sql (takes forever but worth it)
All done.... if u dont ever want to do this again.... do this...
mysqldump eq>mybackup.sql
then if u ever mess your db up.... do this...
mysql
drop database eq;
create database eq;
quit
mysql -f eq<mybackup.sql
All Done... Hope This Helps Some Of You -)