NPC and loot editor - update2

**GeorgeS** · #1 09-07-2008, 01:32 PM

Ok, got around to adding the copy code as requested.
The copy tool has been ravamped. Final version has been updated as per request in the last build.

GeorgeS

**trevius** · #2 09-07-2008, 05:01 PM

GeorgeS, you are a machine!

Just when I think the tools are pretty much complete, you add in stuff to make them even better than I could have expected!

The new weapon model viewer feature is awesome. Though, if possible, it might be nice if you could click on an image to view the larger version of the image. Also, a previous page button might be handy to go back a page. The newest version of the model viewer is really nice for quick references though and definitely an improvement over the previous model viewer

If I could ever get into the gaming industry, I would definitely recommend you for tool designs lol. If you can do this in your free time, I can't even imagine what you could do if you were paid full time to do it

**GeorgeS** · #3 09-08-2008, 01:45 AM

Thanks for the great review. I had considered going into the gaming industry, but I have a great career now, and programing is a hobby. I have improved my vb programing skills significantly over the last years, and still make the occasional game here and there. RPG gaming is my cup of tea, and for those interested, here's an interview I did for RPGdot a while back..

http://ultima.rpgdot.com/index.php?h...n=10053&ID=903

GeorgeS

**trevius** · #4 09-09-2008, 08:11 AM

Nice interview

BTW, I just noticed that if you scroll all of the way to the right with the current version of the editor, it looks like some of the fields aren't lined up properly. The accuracy and attack rating fields aren't even populating at all. My guess is when you added the new Primary and Secondary model fields, it caused the others to miss-align at some point.

**GeorgeS** · #5 09-11-2008, 10:13 AM

Quote:

Originally Posted by trevius

Nice interview

BTW, I just noticed that if you scroll all of the way to the right with the current version of the editor, it looks like some of the fields aren't lined up properly. The accuracy and attack rating fields aren't even populating at all. My guess is when you added the new Primary and Secondary model fields, it caused the others to miss-align at some point.

Make sure you're using the latest version. I fixed that bug a few minutes after seeing that myself.
Thanks
GeorgeS

**GeorgeS** · #6 09-11-2008, 09:51 PM

Jibbatwinkers

This kind of errors appear for more than one reason.
One of the reasons - if you have a table with fields that are "NOT NULL" but field has null values in it. (Other reason is a date/time field with all "0's".)

You mentioned it happens when you click on a column/field that = loottable_id, and crashes when there's no loottable_id there?

Then that must be a Null where it should'nt. I would check the table first.

GeorgeS

**trevius** · #7 09-12-2008, 03:26 AM

I know with version 1129 of the emu, I had problems caused by the blocked spells table. For some reason I had null entries in it and it was working until I updated to 1129. After that, the zone it was being used in wouldn't even boot up. So, that might be one issue.

Another idea for any problems with GeorgeS tools is to make sure to run the register_ocx.bat after every update. Sometimes you need them and sometimes you don't, but it never hurts to run it anyway

Oh, and just finally noticed that it looks like GeorgeS signed up for dyndns

No wonder I couldn't get to your old site :P

MNWatchdog · #8 09-09-2008, 08:30 AM

Quote:

Originally Posted by GeorgeS

Thanks for the great review. I had considered going into the gaming industry, but I have a great career now, and programing is a hobby. I have improved my vb programing skills significantly over the last years, and still make the occasional game here and there. RPG gaming is my cup of tea, and for those interested, here's an interview I did for RPGdot a while back..

http://ultima.rpgdot.com/index.php?h...n=10053&ID=903

GeorgeS

When I tried checking out your interview I got this web page: http://safebrowsing.clients.google.c...n=10053&ID=903

Jibbatwinkers · #9 09-10-2008, 06:15 PM

Ive run into a problem with the NPC/Loot Editor but I think it as to do with MySQL more than anything.

All of the other tools run great, the NPC/Loot Editor will launch fine, I can search through zones and even click and edit NPCs but if I click any NPC with a loot table ID it gives me this message:

Code:

Run-time error '-2147467259 (80004005)':

Data provider or other service returned an E_FAIL status.

The problem started yesterday after I updated to 1129 and put in these two queries:

Code:

CREATE TABLE `blocked_spells` (
  `id` int(11) NOT NULL auto_increment,
  `spellid` mediumint(8) unsigned NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  `zoneid` int(4) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `x_diff` float NOT NULL default '0',
  `y_diff` float NOT NULL default '0',
  `z_diff` float NOT NULL default '0',
  `message` varchar(255) NOT NULL default 'You cannot cast that spell here',
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
)

Code:

Required SQL (Your groups will break completely without this):
CREATE TABLE `group_id` (
  `groupid` int(4) NOT NULL,
  `charid` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`groupid`, `charid`)
)

I removed the two tables and still have the same error. I googled the error and found some references to bad date fields but as far as I know dates are not stored in anything related to NPCs. I repaired my entire database and I also updated ODBC drivers.

Thanks for all your help, hopefully I provided enough information to get the editor up and running for me again. I'll keep looking for an answer and post if I find anything.