NPC and loot editor - update2

[MNWatchdog]

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]

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:

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:

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`)
)

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.