A little problem with EQ Items Database Editor

[WillowyLady]

Ok sussed this one it out. Too much booze last night:(

Problem was with me and db.ini *looks around sheepishly*:rolleyes:


db.ini WAS:-

=======================
host=127.0.0.1
user=?
password=?
database=c:\peq_db
everquest_folder=e:\EverQuest
=======================

Should have been:-

=======================
host=127.0.0.1
user=root
password="one used in setting up MySql Server Instance Config"
database=peq "localhost\peq"
everquest_folder=e:\EverQuest
========================

Thanks for a great app!

[GeorgeS]

Your registrations of the ocx's were fine, so the problem is with your db.ini

..an example of a db.ini..

host=127.0.0.1
user=george
password=mypass
database=PEQ <<----this must be the SCHEMA name, not the path
everquest_folder=e:\EverQuest
Your database name must be the schema of your database when it was made. If it was with Cavedudes installer, then likely it's just PEQ.


GeorgeS

[WillowyLady]

I have encounter a little problem, when attempting to run C:\eqitems\eqitems.exe, the following message pops up:-

MYSQL Connection FAILED!- Check db.ini and did you install my OBDC drivers?

ocx_register.bat looks like this:~

==================================================
regsvr32 DXAnimatedGIF.ocx
regsvr32 a.ocx
regsvr32 msdxm.ocx
regsvr32 MSCOMCTL.OCX
regsvr32 MSINET.OCX
regsvr32 MSDATGRD.OCX
==================================================

when run outputs:-

==================================================
c:\eqitems\resources>register_ocx.bat

c:\eqitems\resources>regsvr32 DXAnimatedGIF.ocx

c:\eqitems\resources>regsvr32 a.ocx

c:\eqitems\resources>regsvr32 msdxm.ocx

c:\eqitems\resources>regsvr32 MSCOMCTL.OCX

c:\eqitems\resources>regsvr32 MSINET.OCX

c:\eqitems\resources>regsvr32 MSDATGRD.OCX
==================================================

Each had a sucessful popup.

So on the surface of thing, the OBDC aspect appears to be OK.

Now, looking at DB.ini.

==================================================
host=127.0.0.1
user=?
password=?
database=c:\peq_db
everquest_folder=e:\EverQuest
==================================================


This is the bit that has thrown me a little and could possibly the be the cause of the error.

I am unsure of what to put in certain fields. Does the user / pass relate to something else that is installed, or can I bung in anything?

I am uncertain if the path to db is correct. In my lashup c:\peq_db is the folder that contains:-

==================================================
16/12/2008 16:53 <DIR> .
16/12/2008 16:53 <DIR> ..
12/02/2008 14:17 1,861 aa_timers.sql
12/02/2008 14:17 2,272 account.sql
21/04/2008 19:07 387 Banned_IPs.sql
12/02/2008 14:17 1,755 botinventory.sql
12/02/2008 14:17 1,722 botleader.sql
12/02/2008 14:17 1,763 botsowners.sql
29/03/2008 19:17 98 bot_npcs.bat
16/03/2008 20:40 98 bot_npcs.sh
22/11/2008 04:59 319 buyer.sql
22/11/2008 04:59 1,373 character_.sql
01/10/2008 04:44 726 character_activities.sql
12/02/2008 14:17 2,372 character_backup.sql
01/10/2008 04:44 569 character_enabledtasks.sql
01/10/2008 04:44 641 character_tasks.sql
22/11/2008 04:59 24,758 commands.sql
01/10/2008 04:44 664 completed_tasks.sql
22/11/2008 04:59 1,679 drop_player.sql
25/11/2008 23:38 1,989 drop_system.sql
12/02/2008 14:17 2,078 eventlog.sql
12/02/2008 14:17 1,835 faction_values.sql
16/08/2008 20:07 405 group_id.sql
12/08/2008 21:30 373 group_leaders.sql
12/02/2008 14:17 1,989 guilds.sql
12/02/2008 14:17 2,091 guild_members.sql
12/02/2008 14:17 2,286 guild_ranks.sql
12/02/2008 14:17 1,856 guild_relations.sql
02/06/2008 02:50 537 hackers.sql
12/02/2008 14:17 2,239 inventory.sql
01/10/2008 04:44 486 keyring.sql
12/02/2008 14:17 1,779 launcher.sql
12/02/2008 14:17 1,825 launcher_zones.sql
22/11/2008 04:59 1,114 load_player.sql
07/10/2008 19:25 570 merchantlist_temp.sql
12/02/2008 14:17 1,701 name_filter.sql
12/02/2008 14:17 2,259 object_contents.sql
25/11/2008 23:01 91,810,002 peqdb_1129Rev233.sql
16/12/2008 16:44 13,520,326 peqdb_1129Rev233.sql.gz
12/02/2008 14:17 2,374 petitions.sql
12/02/2008 14:17 2,273 player_corpses.sql
12/02/2008 14:17 2,258 player_corpses_backup.sql
12/02/2008 14:17 2,100 quest_globals.sql
01/10/2008 04:44 555 raid_details.sql
01/10/2008 04:44 761 raid_members.sql
12/03/2008 16:04 467 rule_sets.sql
25/11/2008 23:38 11,371 rule_values.sql
12/02/2008 14:17 2,137 sharedbank.sql
12/02/2008 14:17 1,878 timers.sql
14/11/2008 21:10 424 trader.sql
22/11/2008 04:59 325 trader_audit.sql
16/12/2008 16:44 <DIR> updates
01/10/2008 04:44 3,086 variables.sql
12/02/2008 14:17 1,746 zone_flags.sql
51 File(s) 105,432,552 bytes
3 Dir(s) 4,059,373,568 bytes free
==================================================

In the meantime...I'll poke around a bit. Might get lucky!

I am most likely overlooking the blindly obvious, if some kindly soul could provide a little pointer in the correct direction, it would be very welcome.

Many thanks.