|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::GeorgeS's Tools A forum just for GeorgeS's tools |
10-29-2008, 07:09 PM
|
Demi-God
|
|
Join Date: May 2007
Posts: 1,032
|
|
Geroge, sudden of nothing I am getting "isbot now requred" error when trying to run NPC-loot editor
But my db has been updated a WHILE ago and allready has isbot, botinventory and botleader things.
Whats more important - I have allready this version before (of October 3rd)wihout any errors, so I am not sure where they coming from
I have donwloaded Oct 28 version and still geting same error
|
10-29-2008, 09:06 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Did you run the register_ocx.bat again? You probably installed something else that broke your previous version's registration or something.
|
10-29-2008, 09:58 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Actually someone else had the same error. I think it's the query which checks for isbot field thay breaks the program on some computers. I have to dig further and find another way of running the query. Just give me a day to think it out..
/edit/
NPC and Loot Editor
08.21.13 - Changed the query that game players error that mentioned 'isbot' field is missing, despite having it in the table
Please download this version and see if it still gives that error.
GeorgeS
Last edited by GeorgeS; 10-30-2008 at 06:15 AM..
|
11-23-2008, 06:18 AM
|
Discordant
|
|
Join Date: Jun 2005
Posts: 286
|
|
Hey George,
I downloaded the latest version and I'm still getting that error.
I updated my DB with the 2 tables and isbot column. All of your other editors that come with it work properly. Anyone else getting this?
__________________
-Croup (the rogue)
Creator of Pandemic (PvP-Racewars)
|
11-23-2008, 12:16 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
I'll remove the check - for some reason it does not work on all computers.
I think almost everyone uses bots now, so I'll use that as the default schema.
Look for an updated version later
*edit
Updated the program and it should no longer crash/give error there.
GeorgeS
Last edited by GeorgeS; 11-23-2008 at 08:29 PM..
|
11-24-2008, 02:39 AM
|
Discordant
|
|
Join Date: Jun 2005
Posts: 286
|
|
Thanks, that worked. Great job on the additions btw. Going to try out the npc editor now!
__________________
-Croup (the rogue)
Creator of Pandemic (PvP-Racewars)
|
12-23-2008, 01:48 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
GeorgeS,
One of the latest changes from KLS removed the timeleft field in the spawn2 table. This causes the spawn editor to break when it tries to load because it can't find that field anymore. KLS moved spawn timers to their own table now. Here is the required SQL for what she changed.
Required SQL:
Code:
DROP TABLE IF EXISTS `respawn_times`;
CREATE TABLE `respawn_times` (
`id` int(11) NOT NULL default '0',
`start` int(11) NOT NULL default '0',
`duration` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `spawn2` DROP `timeleft`;
So, the tool needs to be updated to work with this new system. For anyone else seeing this problem, you should be able to add the timeleft field back to the spawn2 table for now until the tool is updated. That should at least let the tool work, but that field of the tool will be useless.
|
|
|
|
12-23-2008, 03:19 PM
|
|
Fire Beetle
|
|
Join Date: Oct 2002
Location: Northern Michigan
Posts: 28
|
|
yeah im having trouble with it, i click on a mob and go to create lootdrop and it says please select a mob, i go to create loottable and it crashes, i can edit mobs easily but the loot table part isnt working, i gotta do loot straight in the db for now /cry
__________________
Paradigm(Custom/Legit) Server, Coming Soon!
|
12-23-2008, 09:00 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Thanks for the tip - I'll have a fix wed. asap
GeorgeS
|
12-24-2008, 12:04 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
As promised,
NPC and Loot Editor
08.21.15 - Removed 'timeleft' field from spawn2 as required by the emu source. Errors are likely if you have not updated your database schema
Derekj54 - not sure about the error. No one else has this as a reported issue.
The loot code is same since several years ago.
Hope it fixes things.
GeorgeS
|
12-25-2008, 07:24 AM
|
|
Fire Beetle
|
|
Join Date: Oct 2002
Location: Northern Michigan
Posts: 28
|
|
its still doing it, i get a error: 94, invalid use of null. it happens when i try to create a table or if i use the repair loot tables option.
__________________
Paradigm(Custom/Legit) Server, Coming Soon!
|
12-26-2008, 05:41 AM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Your error has to do with a null being in a table where it should not exist. You have to find this problem with a table editor. My program works fine.
GeorgeS
|
02-25-2009, 11:29 AM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Roambox editing is here!
Modified the spawngroup editor in the npc&loot program so that roambox data are visible and editable. If you have features you want in then let me know.
NPC and Loot Editor
08.21.18 - roamboxes supported
GeorgeS
|
06-29-2009, 01:36 PM
|
Dragon
|
|
Join Date: Dec 2007
Posts: 658
|
|
I keep getting Run time error 9 subscript out of range. when I try to create an NPC
|
06-29-2009, 10:49 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,475
|
|
Can you go thru exactly what type of npc and what class/race etc.. that gave that error?
-edit
I found the problem - some newer schemas use >64 fields in the npc_types table and the array would crash it.
Fixed in the newest version
Thanks
GeorgeS
Last edited by GeorgeS; 06-30-2009 at 06:57 AM..
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:14 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|