Go Back   EQEmulator Home > EQEmulator Forums > Development > KayotRO

KayotRO This is the forum for Kayot's Editor.

Closed Thread
 
Thread Tools Display Modes
  #16  
Old 01-19-2007, 03:48 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default Updating to R001

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

Last edited by Kayot; 01-19-2007 at 11:54 AM..
  #17  
Old 01-19-2007, 07:34 PM
Jibbatwinkers
Sarnak
 
Join Date: May 2006
Location: Cincinnati
Posts: 73
Default

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!
__________________
Lead GM ~ Zeb
Zeb Server
ZebServer.com
  #18  
Old 01-20-2007, 04:36 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

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
  #19  
Old 01-20-2007, 05:45 AM
JrFaust
Sarnak
 
Join Date: Aug 2005
Location: Overthere
Posts: 82
Default

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.
  #20  
Old 01-20-2007, 09:22 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

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

Code:
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:
Code:
ALTER TABLE `peq`.`account` ADD COLUMN `rulesflag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `rulesflag`, ENGINE = MyISAM;
I think that works ^-^.
  #21  
Old 01-20-2007, 07:14 PM
JrFaust
Sarnak
 
Join Date: Aug 2005
Location: Overthere
Posts: 82
Default

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.
Code:
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

Last edited by JrFaust; 01-21-2007 at 03:25 AM..
  #22  
Old 01-21-2007, 08:41 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default Truth about Databases

^-^ 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.

Last edited by Kayot; 01-21-2007 at 04:43 PM..
  #23  
Old 01-21-2007, 08:53 AM
mattmeck
Guest
 
Posts: n/a
Default

Kayot, check your PM's.
  #24  
Old 01-21-2007, 01:41 PM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

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.
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:33 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3