Dealing with Player Petitions

[predominant]

I have currently 72 petitions since StudentQuest went live.

To all you fellow EQ server hosts out there, what sort of petitions have you received, and how have you dealt with them? From what I can see, most of these are server code issues, not database issues.

Cheers.

predom

[Merth]

I see the exact opposite. Very rarely do I get a petition about server code. Most of the time, they are "can i be a gm plz", "the giants in kael are too short", "can i be a gm plzzzzz", "how do i get aa?", "can i be a gm plzzzzzzzzzz", etc.

I stopped looking at petitions after going through several hundred and realizing they just don't help.

[predominant]

I've made StudentQuests petitions publically available.
You can see them at http://studentquest.newcastle.edu.au/petitions.php

See, thats the kinda stuff I am getting

[kanechart]

Originally Posted by predominant

I've made StudentQuests petitions publically available.
You can see them at http://studentquest.newcastle.edu.au/petitions.php

See, thats the kinda stuff I am getting

Thats great ideas Tat help other servers aswell.. Are you sharing any scripts? If not no big deal but I like to use them if you are..
Thanks

Kane

Most of the petitions seem to be DB issues not coding issues, and a lot of stuff not working is why DR2 isnt the finished product :lol:

[predominant]

Originally Posted by kanechart

Thats great ideas Tat help other servers aswell.. Are you sharing any scripts? If not no big deal but I like to use them if you are..

What were you interested in?

[kanechart]

Originally Posted by predominant

What were you interested in?

Not sure 100% how your script works if it takes all patitions live off toyr sql database or if you sorta render it into a db like ever 15 min but I like if my patitions were displayed live like that.. Also any other scripts your willing share would help me and others.. If not no problem

[predominant]

    <table width="100%" cellspacing="0" cellpadding="5" border="0" align="center">
	  <tr>
	    <td class="bodylineblue">
                <?
                  $query = "";
                  $query = $query . "SELECT charname, petitiontext, senttime, charlevel ";
                  $query = $query . "FROM petitions ";
                  $query = $query . "ORDER BY senttime DESC ";

                  $link = mysql_connect("myDBhost", "myDBuser", "myDBpass")
                          or die("Connection Failed.");
                  mysql_select_db("eq")
                          or die("Database Unavailable.");
                  $result = mysql_query($query)
                          or die("Query failed.");

                  while ($row = mysql_fetch_object($result))
                  {
                    $senttime = getdate($row->senttime);
                    ?>
                    <table border="1" cellspacing="0" cellpadding="0" width="80%" align="center">
                      <tr>
                        <td><b>
                          <?= $senttime['mday'] ?> <?= $senttime['month'] 
?><?= $senttime['year'] ?> : </b><?= $senttime['hours'] ?>:<?= 
(strlen($senttime['minutes']) == 1 ? "0" . $senttime['minutes'] : 
$senttime['minutes']) ?>
                        </td>
                      </tr>
                      <tr>
                        <td>
                          From: <b><?= $row->charname ?></b> (lvl <?= $row->charlevel ?>)
                        </td>
                      </tr>
                      <tr>
                        <td>
                          <?= $row->petitiontext ?>
                        </td>
                      </tr>
                    </table>
                    <br/>
                    <?
                  }
                  mysql_free_result($result);

                ?>
		</td>
	  </tr>
	</table>

I am no master PHP programmer. This is my code for the petitions display at http://studentquest.newcastle.edu.au. If you find it interesting, sure, copy it - Just put a "Hacked together my Predominant" HTML comment in there