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.