Where Can I Find a 0.6.2/3 Database?

mikenune · #1 12-21-2005, 11:21 PM

The title pretty much says it all. I'm looking for a database that's compatible with EQEMu 0.6.2/3. ProjectEQ has a 0.5.8 compatible DB, but that's the latest version I can find!

Is there a newer version or had the schema remained unchanged since that version?

I've just recently gotten back into the EMU scene and am looking for a working copy that has everything except tables/data for things like the PEQ Editor, but there are so many different files that can be found all over this board that I don't know what to use and what not to. I've tried using the 0.5.8 DB from ProjectEQ and running various "updates" as well as looking at all those different files available from the CVS (and from http://www.projecteq.net/sql/), but I keep running into problems. Am I doing something wrong or do I just not have the right DB files to source in?

P.S.
I'm using MySQL 5.0.16, PHP 5.1.1, Apache 2.0.47, and Perl 5.8.4 all on a Windows XP box (fully updated). I'm using PHPMyAdmin 2.7.0-pl1 so I know that MySQL is running properly and that I have the right username/password setup (since I can login and view the databases through both the PHPMyAdmin and MySQL Command Line interfaces).

mrea · #2 12-21-2005, 11:29 PM

http://www.projecteq.net/getfiles.php

Choose Velious Release Candidate 1

HurtinuDaily · #3 12-22-2005, 04:58 AM

do you need to update that database after you download it, I am sure you do. check out one of my recent possts its in there.

Edit: for 6.3 not 6.2

rojadruid · #4 12-22-2005, 05:56 AM

Quote:

Originally Posted by mikenune

P.S.
I'm using MySQL 5.0.16, PHP 5.1.1, Apache 2.0.47, and Perl 5.8.4 all on a Windows XP box (fully updated). I'm using PHPMyAdmin 2.7.0-pl1 so I know that MySQL is running properly and that I have the right username/password setup (since I can login and view the databases through both the PHPMyAdmin and MySQL Command Line interfaces).

Your version of MySQL could be too high you might want to try running 4.0.23~.

mikenune · #5 12-22-2005, 08:30 AM

I'm pretty sure that the problem is actually a DB schema issue because the "New, Improved PEQ Database Editor" Web interface would call up information OK (it took forever to load pages though!) and the "DRP: Database Editor" would be able to log into the DB and call up a list of NPCs.

I was just having issues with the DRP editor hanging whenever I tried to pull up specifics on something (as well as a couple other annoying issues). So, I decided to just reload everything and make sure I wasn't using any weird/old SQL dumps.

And then, of course, I couldn't find a good (complete) DB that was up-to-date. But only AFTER I'd already dropped mine! :(

Anyway, I'm trying the Velious PEQ DB right now so we'll see if that helps.

Belfedia · #6 12-22-2005, 08:58 AM

Use Peq Velious RC1
And make the correct repair :

Code:

EQEMu Changelog (Started on Sept 24, 2003 15:50)
-------------------------------------------------------

==12/09/2005
FatherNitwit: Fixed the issue where maxed out factions cannot be raised/lowered
FatherNitwit: Changed faction hits to properly ignore illusions.
FatherNitwit: Fixed an issue with converted chars and corrupt AAs. (not fully resolved)
FatherNitwit: Fixed the issue with mobs not pathing after respawning.

==12/01/2005
FatherNitwit: added USE_RACE_CLASS_XP_MODS (disabled by default) to features.h
FatherNitwit: These fields are not used:
ALTER TABLE zone_points DROP keep_x;
ALTER TABLE zone_points DROP keep_x;

==11/24/2005
FatherNitwit: just some SQL updates you should run to make the recent aggro changes less annoying.
UPDATE npc_types SET _INT=80 WHERE _INT=75;
UPDATE npc_types SET _INT=60 WHERE _INT=80 AND ( bodytype=3 OR bodytype=8);
ALTER TABLE npc_types CHANGE _INT _INT mediumint(8) unsigned NOT NULL default '80';

==11/17/2005
FatherNitwit: Fixed a crash in the map code
FatherNitwit: Tweaked mob usage of d_meele_texture*

==11/11/2005
FatherNitwit: Changed most double prescision operations to single prescision.

==11/10/2005
FatherNitwit: Fixed waypoint ID limit (was 65535).
FatherNitwit: Implemented the #wpinfo command

==11/05/2005
FatherNitwit: Fixed the broken server side filters (reworked entirely).
FatherNitwit: Refactored damage code to be more consistent between PCs and NPCs.
FatherNitwit: Changed spell damage mechanism slightly to better utilize runes.
FatherNitwit: Tweaked a bit of illusion code to be more versitile.

==11/03/2005
FatherNitwit: Fixed AA storage in the player profile.

==10/28/2005
FatherNitwit: Fixed a lot of GCC 4.0 and 64 bit problems. Should build under both better now.

==10/24/2005
FatherNitwit: Fixed mob int loading.

==10/23/2005
FatherNitwit: Fixed Client->NPC->Client riposte.

==09/28/2005
FatherNitwit: added quest::attacknpc and quest::attacknpctype
FatherNitwit: Cleaned up usage of Appearance in the code
FatherNitwit: Fixed faction ally checking for npc->npc faction
FatherNitwit: Removed some stupid rules reguarding npc aggro
FatherNitwit: Fixed some faction issues with aggro, guards should work reliably now.

==09/25/2005
FatherNitwit: Fixed incorrect usage of EXPMod variable.

==09/24/2005
FatherNitwit: Hopefully fixed bard instruments.
FatherNitwit: Fixed crash when loading DoD+ spells_us.txt file
FatherNitwit: Rewrote a ton of the perl parser internals to suck less.
FatherNitwit: Reworked a bit of netcode to minimize chances of #opcode crashing.
FatherNitwit: Actually loaded luclin attributes from DB.
FatherNitwit: Added npc stats to npc_types and use them.
ALTER TABLE npc_types ADD STR MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD STA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD DEX MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD AGI MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD _INT MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD WIS MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD CHA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
	
==09/23/2005
FatherNitwit: Inverted XY coordinates on in zone objects and ground spawns.
FatherNitwit: Maybe fixed quests setting a waypoint in EVENT_WAYPOINT
ALTER TABLE ground_spawns ADD temp_x float NOT NULL;
UPDATE ground_spawns SET temp_x=min_x;
UPDATE ground_spawns SET min_x=min_y;
UPDATE ground_spawns SET min_y=temp_x;
UPDATE ground_spawns SET temp_x=max_x;
UPDATE ground_spawns SET max_x=max_y;
UPDATE ground_spawns SET max_y=temp_x;
ALTER TABLE ground_spawns DROP temp_x;
ALTER TABLE object ADD temp_x float NOT NULL;
UPDATE object SET temp_x=xpos;
UPDATE object SET xpos=ypos;
UPDATE object SET ypos=temp_x;
ALTER TABLE object DROP temp_x;


==09/22/2005
FatherNitwit: Reworked quest signaling implementation to be less dumb. Also exported SignalNPC to perl.
FatherNitwit: Implemented a missing bard AE DOT spell type.

==09/21/2005
FatherNitwit: Fixing a few issues with windows compiles and corpses.

==09/19/2005
FatherNitwit: Added missing packet for player death to create a corpse.

==09/16/2005
FatherNitwit: Fixed loot error case client hang, reported by Yablargo

==09/15/2005
FatherNitwit: Fixed coin trading bug reported by Windcatcher

==09/12/2005
FatherNitwit: Fixed adventure merchants

==09/11/2005
FatherNitwit: Made temp merchant lists clear on world boot.
FatherNitwit: Fixed some shared memory issues on windows.
FatherNitwit: exported some more mob methods to perl.

==08/26/2005
Doodman: Found most of the missing guild opcodes, except the manage ones.
Doodman: Moved guildlist to shared mem (ick) since zone now sends it too.
Doodman: Need to implement a way to recover the functionality of dynamicly
	  adding/removing guilds with the shared mem solution

==08/23/2005
FatherNitwit: Added range check for all combat abilities (reported by LoOsEr)

==08/21/2005
FatherNitwit: Fixed gaining AA exp (buying still broken)
FatherNitwit: Fixed weapon procs
FatherNitwit: Added looting messages (links to come later)
FatherNitwit: Fixed instant spells acting like DoTs

--- Version Changed to 0.6.2DR1 ---

This is not magic, this is the 2005 changelog.txt.
You can find it in last CVS. You can't acces CVS ?
Here a snapshot: http://eqfroggy.ath.cx/download/EQEmuCVS-12-09-2005.rar

You can't find a complete DB for eqemu, make it, is hard, and i know only 2 crew who working on that (Black rogue product & Peq).

mikenune · #7 12-22-2005, 09:07 AM

OK, when I try to source the Velious PEQ DB (clean dump, no other files sourced), it works fine until it tries to make the "spawn2" table, where it gives me the following error:

The reason it says the error is at line 13 is because I cut the load_system.sql dump into 2 files with the second file starting at the creation of the "spawn2" table (so I could make sure everything else sourced fine).

Code:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition mediumint(8) unsigned NOT NULL default '0',
  cond_value mediumint(9)' at line 13

Here's the beginning of the file I'm trying to source in (load_system.b.sql):

Code:

-- MySQL dump 9.11
--
-- Host: 127.0.0.1    Database: peq_velious
-- ------------------------------------------------------
-- Server version	4.0.22

--
-- Table structure for table `spawn2`
--

CREATE TABLE spawn2 (
  id int(11) NOT NULL auto_increment,
  spawngroupID int(11) NOT NULL default '0',
  zone varchar(16) NOT NULL default '',
  x float(14,6) NOT NULL default '0.000000',
  y float(14,6) NOT NULL default '0.000000',
  z float(14,6) NOT NULL default '0.000000',
  heading float(14,6) NOT NULL default '0.000000',
  respawntime int(11) NOT NULL default '0',
  variance smallint(4) NOT NULL default '0',
  pathgrid int(10) NOT NULL default '0',
  timeleft bigint(16) NOT NULL default '0',
  condition mediumint(8) unsigned NOT NULL default '0',
  cond_value mediumint(9) NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY ZoneGroup (zone,spawngroupID)
) TYPE=MyISAM;

an exact copy of what I typed into the MySQL Command Line:

Code:

CREATE DATABASE eq;
USE eq
SOURCE load_empty_users.sql;
SOURCE load_system.a.sql;
SOURCE load_system.b.sql;

The load_empty_users.sql file works perfectly.

The load_system.a.sql is the first half of the original load_system.sql file and covers tables "aa_actions" through "pets". This file sources without error.

The load_system.b.sql is the second half (and is only a 10MB file whereas the other one is 87MB - so I know it's not some weird file size issue) and covers "spawn2" through "zoneserver_auth". It, of course, gives the above error and is completely unable to dump the "spawn2" table. When I remove all the "spawn2" entries from the file, all the other tables in here source correctly.

Could it be a problem with "condition" being a keyword in MySQL 5?

Belfedia · #8 12-22-2005, 09:16 AM

Are you sure your DB EQ is empty when you source ?
Before CREATE DATABASE EQ;
just drop it with a DROP DATABASE EQ;

And for help on PEQ database, don't forget to go on http://www.projecteq.net
you have many forum with support answer about database

mikenune · #9 12-22-2005, 09:23 AM

Whelp, sojadruid, it looks like you were right and I was wrong! It is, in fact, a "problem" with MySQL 5 :(

Apparently, "contition" is a reserved word because when I change the spelling (by adding the letter "a" to the end), it sources just fine.

Guess it's back to MySQL 4 for me.

P.S.
Thanks for those updates to the DB schema Belfedia!

**fathernitwit** · #10 12-22-2005, 05:23 PM

mysql higher than 4.0 has not been supported in a long time. Eqemu hates it.

Also, there is always information about how to get PEQ databases up to the current CVS code on PEQ's forums...
http://www.projecteq.net/phpBB2/viewtopic.php?t=308

johane · #11 12-23-2005, 03:50 AM

Quote:

Originally Posted by fathernitwit

mysql higher than 4.0 has not been supported in a long time. Eqemu hates it.

Also, there is always information about how to get PEQ databases up to the current CVS code on PEQ's forums...
http://www.projecteq.net/phpBB2/viewtopic.php?t=308

I seem to vaguely recall there's an option for my.ini that disables some keyword changes for MySQL 5 yet still allows sub-selects. It might only apply to Innobase tables though. I know there's an option that changes the case-sensitivity back to 3.29 and earlier type behaviour.

mikenune · #12 12-23-2005, 06:10 PM

Well, not that many of you guys really NEED to know this, but I "downgraded" my version of MySQL from 5.whatever to 4.1 and everything works fine!

Now all I need is an EQEMu build that supports live and I'll be ready to go! (note: This is said jokingly! With me playing WoW as much as I do, more gaming is not something I really need)

Belfedia · #13 12-24-2005, 11:06 PM

Cool

If that work we are happy