Arcemu 3.3.5a Teleporter

Go down

Arcemu 3.3.5a Teleporter

Post by Jastuz on Tue Feb 14, 2012 12:04 pm

Core: Arcemu Trunk version 4.0/

Client: 3.3.5a

Error: I ran the SQL no errors. I used Navicat to execute. I do get errors when the server is running and I use the NPC
[00:57][Arcemu]Sql query failed due to [Out of range value for column 'map' at row 1], Query: [INSER
T INTO creature_spawns VALUES(200016,654321,4294967295,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,1)]
[00:57][Arcemu]Sql query failed due to [Out of range value for column 'map' at row 1], Query: [INSER
T INTO creature_spawns VALUES(200028,654320,4294967295,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,1)]


Problem: In game when you right click the NPC no gossip menus come up to be able to choose where to go.

Changes you have done: None

Code:

Pictures:

says i cant post photos



Last edited by Jastuz on Tue Feb 14, 2012 1:06 pm; edited 1 time in total (Reason for editing : Added error codes while server is running.)

Jastuz

Viestien lukumäärä : 1
Join date : 2012-02-14

Back to top Go down

Re: Arcemu 3.3.5a Teleporter

Post by Rochet2 on Wed Feb 15, 2012 5:45 am

I am not sure what is the problem here.

The SQL errors you are getting in the world console are likely from an invalid DB installation. The spawn tables are incorrectly set up, so their structure likely does not match the core's version.

I tested on latest arcemu (clean) with WhyDB and just downloaded the Lua file and executed the SQL to DB.
Got an error since the engine is ALE instead of LHA these days, so I need to get that fixed.

Otherwise seems to work good.


I am not sure what version your arcemu core is.
If it is somewhat recent, the teleporter and gossip system should work fine, possibly after a slight fine tuning.
By fine tuning I mean removing or altering the core check at the start of the script.

I will be fixing that one soon, but not sure what is causing your problem if you get the "loaded succesfully" message on reloading lua engine.

PS. The script does not execute any INSERT INTO SQL statements to your database.
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum