V 0.0.10 ^-^

[Kayot]

mamba666 - Have you tried updating your DB's to the PEQ CVS? Cave dudes DB is old, and by old I mean it's missing sevearal thousand entrys.

I checked the scheme of the newest PEQ database and rulesflag is in there.

CREATE TABLE account (
  id int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  charname varchar(64) NOT NULL default '',
  sharedplat int(11) NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `status` int(5) NOT NULL default '0',
  lsaccount_id int(11) unsigned default NULL,
  gmspeed tinyint(3) unsigned NOT NULL default '0',
  revoked tinyint(3) unsigned NOT NULL default '0',
  minilogin_ip varchar(32) NOT NULL default '',
  hideme tinyint(4) NOT NULL default '0',
  rulesflag tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY lsaccount_id (lsaccount_id)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

Also, mwmdragon, are you using Mysql 4.0? That error is about the input of the mysql command being messed up because the connector libabry is for 4.1+

[mamba666]

I downloaded the latest CVS of PEQ and was unable to source it. I kept getting errors.

I then made a backup of the peq I have and update it with the cvs source. This didn't work because of the duplicate entries and the tables weren't quite the same.

I know this isn't your problem and I will figure it out. I just wanted to let you know that I was trying a new database. Once I get it going I'll try your editor on it.

[techguy84]

The error with sourceing the CVS is that you have to navigate your command prompt to the directory where the files are located before running mysql. If you just run mysql, it will look for the files in your bin directory of mysql.

For example, if you downloaded the CVS to c:\peq_db you would then need to cd\peq_db in your command prompt to go into that folder first.

[cavedude]

You can't update the PEQ database, you have to wipe the system tables and then resource them. Using CVS, source drop_system.sql and source load_system.sql will do that for you.

Yeah, my db is way out of date. Most of the data it contained I have merged into PEQ anyway so it's near 100% obsolete.

[mamba666]

I tried starting form a clean fersh database and still didn't work.

This thread really isn't for installing dtabase so I'm gonna stop posting about updating my database here. I'll go to the PEQ forums or the server setup forums.

I'm happy with what I have right now and will address upgrading my database later.

For now I can still use most of the functions of the KayotRo tools. I also can access through an Access front end as well as Navicat MySQL. I'll have trouble with the (Blob) stuff, until I can get the latest database up and running.

Thanks for the help guys. I have a lot of ideas and things to try.

[mamba666]

OK Update.I now have 98% or so fuctionality. I ahd to make a few updates to the databse that I have.

These updates are stated on the PEQ forums. Here are specifically the 2 I had to update.

ALTER TABLE `account` ADD `rulesflag` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

-- This allowed me to edit the accounts

ALTER TABLE `zone` ADD `cancombat` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

-- this allowed me to edit the zones

If I was able to source in the CVS database this would have been fixed I am sure.

The forum reference is http://www.projecteq.net/phpBB2/viewtopic.php?t=1679

I am pretty happy now and hope that htis may help someone else.

This should fix the database for using this editor if you installed the EQEMUServerpack3.6 or even 3.52 mostlikely.