KayotRO MySQL EQEmu Database Editor

[Kayot]

At 3:00pm-ish Eastern Time (US) I'll being putting my current snapshot up. Let me just say this. This has been a week from hell at school. Every prof. has assigned me a ton of home work every fraking day. ^-^ So i got jinxed when I said I'd pull off a miracle.

That aside, what

[Jibbatwinkers]

I'm looking forward to this tool when you get all the kinks worked out. I have tools that were made 4 years ago and some that are quite new, it would be nice to get something like this that was all-in-one or at least most of the things I need.

The Zebuxoruk server (me) will keep and eye on this for sure, keep up the good work!

[Kayot]

I'm thinking about moving this program to my board completly. It's nice having it here, but I lack the ability to edit my first post making any sort of updates here impossible.

Also, I'm going to release my program in three pieces from now on. Why? because only the main exe changes. Most of the archive is static data. The exe is ~400K when rar'ed. The whole thing is ~1.7 MB. I can trim updates to just the exe and save time.

Updates, I repainted the program with vs.net 2005. It's much better than it was on friday.

Links:

My forum
KayotRO - EQemu SQL Editor Section

Main Exe
KayotRO EQemu Editor
Dll's <Will never change>
Required DLL Files
Main Graphics
Graphic Files

[JrFaust]

I get this error message when I click in ID Number area under the Account Editor.

Failed to populate database list: #42522Unknown column 'rulesflag' in 'field list'

Just an FYI.

[Kayot]

What is your table structure? I'm using this one:

DROP TABLE IF EXISTS `peq`.`account`;
CREATE TABLE  `peq`.`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=4 DEFAULT CHARSET=latin1;

You might lack the rulesflag value. If so you should add it as some databases require it. If for no other reason simply to run this program. Once I get all the editors basically working I plan to add in checkers for all the tables so the program will 'morph' to the database a little better.

If you don't know the SQL command to add that column:

ALTER TABLE `peq`.`account` ADD COLUMN `rulesflag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `rulesflag`, ENGINE = MyISAM;

I think that works ^-^.

[JrFaust]

I'm using Angelox's DB and I don't know if he has that in his DB.
But I'll try to add that in and see, thanks.

I'm on MySQL 5.x so I had to edit the command to.

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

And now I don't get that error.

Thanks for the info.
Rob

[Kayot]

^-^ My database is a twisted hybrid of PEQ and Angelox so expect strange anomaly's.

Note: I've converted the whole program to vb.net 2005. It now runs faster and takes up less space. However it also requires .net 2.0.

A sort of update, I plan to break the item editor into separate windows to help solve the horribly slow redraw rate.

Kayot, check your PM's.

[Kayot]

Due to the main streaming of this program I am locking this topic as it was a sort of category all by it's self. Feel free to add topics with questions. As I answer them I'll add them to a F.A.Q. Topic.