jia_jacky
06-18-2017, 11:13 PM
I met some issue when I setup EQEmulator. Could anyone help me?
1. There were some errors during sourcing load_bots.sql. I reviewed the scripts and found a line:
INSERT INTO `commands` VALUES ('bot', '0');
but there was no table named commands in database (source by "peqbeta.sql" downloaded on 17 june).
2.about character_ table
There were some lines about a "character_", but it was exist in database.
such as
DROP FUNCTION IF EXISTS `GetMobType` $$
CREATE FUNCTION `GetMobType` (mobname VARCHAR(64)) RETURNS CHAR(1)
BEGIN
DECLARE Result CHAR(1);
SET Result = NULL;
IF (select count(*) from character_ where name = mobname) > 0 THEN
SET Result = 'C';
ELSEIF (select count(*) from bots where Name = mobname) > 0 THEN
SET Result = 'B';
END IF;
RETURN Result;
END $$
3. The EQEmulator ran, but quests did not. I can not start any quest, and NPC can not reply my 'Hail'. I had tried to update exe files, quests files, plugins by "eqemu_server.pl", but it still did not worked.
1. There were some errors during sourcing load_bots.sql. I reviewed the scripts and found a line:
INSERT INTO `commands` VALUES ('bot', '0');
but there was no table named commands in database (source by "peqbeta.sql" downloaded on 17 june).
2.about character_ table
There were some lines about a "character_", but it was exist in database.
such as
DROP FUNCTION IF EXISTS `GetMobType` $$
CREATE FUNCTION `GetMobType` (mobname VARCHAR(64)) RETURNS CHAR(1)
BEGIN
DECLARE Result CHAR(1);
SET Result = NULL;
IF (select count(*) from character_ where name = mobname) > 0 THEN
SET Result = 'C';
ELSEIF (select count(*) from bots where Name = mobname) > 0 THEN
SET Result = 'B';
END IF;
RETURN Result;
END $$
3. The EQEmulator ran, but quests did not. I can not start any quest, and NPC can not reply my 'Hail'. I had tried to update exe files, quests files, plugins by "eqemu_server.pl", but it still did not worked.