EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Bugs (https://www.eqemulator.org/forums/forumdisplay.php?f=622)

- - DR3 bugs (https://www.eqemulator.org/forums/showthread.php?t=11553)

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)

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

/summon works better and has more functionality.

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

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

#listpetition brings up

Quote:

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..

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.

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

Code:

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

}

Code:

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.