DR3 bugs

[wize_one]

seems the #summon command not working now..
ie not able to target NPC #summon #spawnfix


#listpetition and #delpetition not working

shared band money slot not working(havent tried items yet)


the zone_id=0 error still causing client hangs.

perl questing not working(at least in the precompiled version)

[Shawn319]

#summon was taken out because it is useless. use /summon

/summon works better and has more functionality.

[wize_one]

after typeing /summon am getting
That is not a valid command. Please use /help

[kathgar]

You have to be #gm on, if you want perl compile it yourself. /summon, shared bank doesn't work (NOT IMPLEMENTED), #listpetition and #delpetition work

[wize_one]

#listpetition brings up

ID : Character Name , Account Name

no other info

#delpetition does delete is from DB..but if user tried to petition again it tells them they already have a petition in and to use /deletepetition



/summon does work now that #gm on done..

[Swampdog]

Just tested this on the server I'm building. I created my petitions table by exporting structure only from my test database where I sourced the dr2 download. (I am using dr3 compiled code)..

I created a petition and then executed #listpetitions and I get ID: Character Name, Account Name with no petition information. I pulled up the table in mySQL and it showed my petition. I created another petition by adding a record in my SQL admin tool and once it was committed to the database, I did #listpetition again and it showed the new petition. At first I thought it might be because the petid was 0, so I edited it to 2 and then the record I added earlier didn't show up in the list. It seems that it is always dropping the first record in the petition table.

Not really a coder or a db person but from analyzing the result, thats at least a place to look whenever one of the project guru's has a chance to peek.

[m0oni9]

Try these out. Should be in command.cpp at about lines 2938 and 1411 in command.cpp, respectively.

void command_listpetition (Client *c, const Seperator *sep)
{
char errbuf[MYSQL_ERRMSG_SIZE];
char *query;
MYSQL_RES *result;
MYSQL_ROW row;
unsigned int count = 0;

query = new char[256];

if (database.RunQuery (
query,
MakeAnyLenString(&query, "SELECT petid, charname,accountname FROM petitions ORDER BY petid"),
errbuf,
&result) == false)
{
safe_delete_array (query);
c->Message (13, "Error executing query.");
return;
}

safe_delete_array (query);

LogFile->write (EQEMuLog::Normal,
"Petition list requested by %s", c->GetName());

while ((row = mysql_fetch_row (result)) != NULL)
{
if (count++ == 0)
c->Message (13," ID: Character Name, Account Name");

c->Message (15, " %s: %s, %s", row[0], row[1], row[2]);
}

if (count == 0)
c->Message (15, "No petitions found.");

mysql_free_result (result);
}


void command_delpetition (Client *c, const Seperator *sep)
{
if (sep->arg[1][0] == 0 || strcasecmp (sep->arg[1], "*") == 0)
{
c->Message (0, "Usage: #delpetition (petition number).");
c->Message (0, "Type #listpetition for a list.");
return;
}

if (petition_list.DeletePetition (atoi (sep->argplus[1])) == -1)
c->Message (13, "Error deleting petition %i.", atoi (sep->argplus[1]));
else
c->Message (13, "Deleted petition %i.", atoi(sep->argplus[1]));
}

edit: Added new delete petition function and modified list petitions.