Server Prog question

[xxarthurxx]

Hey all i just got my server up and running... and i noticed as i was out farming bosses that everthing i killed would drop the same loot table... not every mob dropping the same thing... but rather that each mob would drop the same item or items every time... they seem to love to drop gems... usually 1-4 diamonds dropping per corpse... and most of the bosses dropped nothing at all was wondering is there some sort of item ramdomizer i need to add or something? any help would be nice

-Tinimus

[sesmar]

Loot table are controlled by the Database and you can edit these yourself. There are a few different tools to edit them, one of them being my Database editor. You can check out my DB editor at:

http://eqemu.sesmar.net/DB_Editor/DR...ta_0.5.0.0.rar

you can read more about it here:

http://eqemu.sesmar.net/index.php?op...id=5&Itemid=38

and here:

http://eqemulator.net/forums/showthread.php?t=19839

[xxarthurxx]

is there anywhere i could get an already made database with all the loot tables for mobs intact? or will i have to go into the editor and add in all the loot that every mob should drop?

[xxarthurxx]

-edit... ok i got all the databases from project eq.... now all i need to figure out is how to upload them... fooling with it now any help or guides would be much appreciated

[xxarthurxx]

found out how to imput the source threw sql... my new error is now it seems when i follow the directions listeb by project eq to...

drop_system.sql - Drops all PEQ released tables so the DB can be loaded successfully.
drop_users.sql - Drops all user-specific (non PEQ) tables. Not normally used.
load_empty_users.sql - Loads new empty tables for all user-specific data. Only used on fresh installs.
load_system.sql - Loads the PEQ database. This is the meat of the release.

all goes well then i load up my database and i get a new error... a "buttload" as it puts it... also telling me to make sure i sourced: utils/item-0.6.0-DR2-0.6.1-DR1-convert.sql

error: EMuShareMem: DLLLoadItems: !cbDBLoadItems

please help :/

[Angelox]

Originally Posted by xxarthurxx

found out how to imput the source threw sql... my new error is now it seems when i follow the directions listeb by project eq to...

drop_system.sql - Drops all PEQ released tables so the DB can be loaded successfully.
drop_users.sql - Drops all user-specific (non PEQ) tables. Not normally used.
load_empty_users.sql - Loads new empty tables for all user-specific data. Only used on fresh installs.
load_system.sql - Loads the PEQ database. This is the meat of the release.

all goes well then i load up my database and i get a new error... a "buttload" as it puts it... also telling me to make sure i sourced: utils/item-0.6.0-DR2-0.6.1-DR1-convert.sql

error: EMuShareMem: DLLLoadItems: !cbDBLoadItems

please help :/

Did you miss this?

http://www.eqemulator.net/wiki/wikka...indowsServer70

If you follow the instructions in the above link, step by step - you'll have none of the problems you're having now.

[xxarthurxx]

yes ive ran threw that a million times... if i wanted the base server without the updates from project eq (like the items on bosses from base eq - luclin for example) then i would not have this problem nor be putting so much time into trying to make it work

basically what i need is a walkthrough on others who have applied the peq updates to the current server database has it working... please~!

[Angelox]

Originally Posted by xxarthurxx

yes ive ran threw that a million times... if i wanted the base server without the updates from project eq (like the items on bosses from base eq - luclin for example) then i would not have this problem nor be putting so much time into trying to make it work

basically what i need is a walkthrough on others who have applied the peq updates to the current server database has it working... please~!

My understanding is, the PEQ and EQ databases supplied with what you install here; http://www.eqemulator.net/wiki/wikka...indowsServer70 , are the newest ones available. Other than that, you have to build on what ever database you choose. I think what everyone is doing, is just that. They either choose EQ or PEQ, then start from there. If you want more, then you have to do what the rest of us are doing - that is, download some editors posted here, and start adding/fixing loots, spawns, npc's etc.
I suspect you are not getting more help on this, because the people here are tired of telling us to study the Wiki/Faqs, over and over again.

[rojadruid]

okay after loading a fresh peq database you will still need to run the change log sql quiries<sp?>. that will get your database up to the lastest binaries<sp?>.

[xxarthurxx]

alright i seem to have everything on the server set but the items now... i have the full item database but its in txt format... is there anyone out there that has a sql format for it so i can upload it threw sql via the command prompt? ive tried sourcing the txt file and even changing it to a sql file and it still doesnt work...

my server loads up find now... i can log into the character creat screen... create a character once thats done it crashes... :(

[EliteSting]

Post what the logs say if you could , would be alot easier to see what exactly is going wrong , and what could possibly fix it. =)

[xxarthurxx]

could anyone post a step by step walkthrough on how to get the most up to date database loaded up source in ect... my bestest thing that i want uploaded is the loot tables for each mob/boss... please any help is apperciated

[Thristam]

goto http://www.projecteq.net/sql/

There you will find the latest db schema changes and also some of the basic info you need.

also, the file item-0.6.0-DR2-0.6.1-DR1-convert.sql is in the "source" version of eqemu. download it and you'll find it in there in the /utils directory.

[xxarthurxx]

at this point im just about ready to pull my hair out

as of now im willing to pay $10 threw paypal to anoyone that can get me a sql file with the most updated server info... fresh and clean and a step by step way of uploading it into a new server... using sql threw the comman prompt

the things i want are, the most up to date info from what is released atm which is all the loot tables for bosses from base eq - luclin (how ever many project eq has finished so far)

[xxarthurxx]

nm i got it working