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