Berichten van thymen
-
-
Ticket.php:
PHP
Meer tonen<?php include("config.php"); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <link rel="stylesheet" type="text/css" href="style.css"> <style type="text/css"> body { font-family: Tahoma; font-size: 12px; color: black; background-color: #e6e6e6; scrollbar-face-color: #404040; scrollbar-shadow-color: #202020; scrollbar-highlight-color: #808080; scrollbar-3dlight-color: #808080; scrollbar-darkshadow-color: #202020; scrollbar-track-color: #C0C0C0; scrollbar-arrow-color: #C0C0C0; } a:link { color: #000000; font-family: Tahoma; font-size: 12px; text-decoration: none; } a:visited { color: #000000; font-family: Tahoma; font-size: 12px; text-decoration: none; } a:active { color: #000000; font-family: Tahoma; font-size: 12px; text-decoration: none; } a:hover { color: #006688; font-family: Tahoma; font-size: 12px; text-decoration: none; } textarea { border: 1px solid #000000; background: #e6e6e6; font-size: 13px; font-family: Tahoma; color: black;} input { border: 1px solid #000000; background: #e6e6e6; font-size: 13px; font-family: Tahoma; color: black;} input.normalRadio { border: 1px solid #000000; background: #000000; font-family: Tahoma; color: black;} select { border: 1px solid #000000; background: #999999; font-size: 11px; font-family: Tahoma; color: black;} table { color: #000000; font-family: Tahoma; font-size: 12px; border-color: #000000; } table.main { background: #0C0C0C; color: #000000; font-family: Tahoma; font-size: 12px; border-color: #000000;} table.click { background: #4E6F81; color: #000000; font-family: Tahoma; font-size: 12px; border: 1px solid #000000; } td.subTitle { background: url('images/subtitle.jpg'); #D0D0D0; color: #000000; background-image: url(http://www.al-pacino.nl/images/tabelheader.gif); font-family: verdana; font-size: 11px; font-weight: bold; letter-spacing: 5px; padding: 1px; text-align: center; border: 1px solid black } td.mainTxt { border: 1px solid #000000; background: #A8A8A8; font-family: verdana; font-size: 12px; padding-left: 5px; } table.menu { border: 1px solid #000000; color: #FFFFFF; font-family: Tahoma; font-size: 12px; } td.menuTitle { background: url('images/menu.jpg'); color: #FFFFFF; font-family: Tahoma; font-size: 12px; font-weight: bold; letter-spacing: 5px; padding: 1px } td.menuLink { background: #A8A8A8; color: #000000; font-family: Tahoma; font-size: 12px; } a.menu:link { color: #D4D4D4; font-family: Tahoma; font-size: 11px; text-decoration: none; cursor: default; width: 120; } a.menu:visited { color: #D4D4D4; font-family: Tahoma; font-size: 11px; text-decoration: none; cursor: default; width: 120; } a.menu:active { color: #D4D4D4; font-family: Tahoma; font-size: 11px; text-decoration: none; cursor: default; width: 120; } a.menu:hover { color: #D4D4D4; font-family: Tahoma; font-size: 11px; text-decoration: none; cursor: default; width: 120; } body { scrollbar-base-color: #e6e6e6; scrollbar-face-color: #404040; scrollbar-shadow-color: #202020; scrollbar-highlight-color: #808080; scrollbar-3dlight-color: #808080; scrollbar-darkshadow-color: #202020; scrollbar-track-color: #C0C0C0; scrollbar-arrow-color: #C0C0C0; } </style> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <? $select = mysql_query("SELECT * FROM `helpdesk` WHERE `behandelt`='Ja'"); $behandelt = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk` WHERE `behandelt`='Nee'"); $onbehandelt = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk`"); $totaal = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk` WHERE `login`='{$data->login}'"); $jouw = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk` WHERE `operator`='Morellow'"); $mod1 = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk` WHERE `operator`='Jelee'"); $mod2 = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk` WHERE `operator`='Revengerman'"); $mod3 = mysql_num_rows($select); $select = mysql_query("SELECT * FROM `helpdesk` WHERE `operator`='Merlin'"); $mod4 = mysql_num_rows($select); ?> <table align=center width=630> <TBODY> <TR> <TD vAlign=top width="50%"> <TABLE width="95%" align=center> <TBODY> <TR> <TD class=subTitle colSpan=2><b>Helpdesk Statistieken</b></TD></TR> <TR> <TD class=mainTxt><font color="#000000">Vragen Behandelt:</font></TD> <? echo "<TD class=mainTxt><font color='#000000'>$behandelt</font></TD></TR>"; ?> <TR> <TD class=mainTxt><font color="#000000">Vragen Onbehandelt:</font></TD> <? echo "<TD class=mainTxt><font color='#000000'>$onbehandelt</font></TD></TR>"; ?> <TR> <TD class=mainTxt><font color="#000000">Vragen Totaal:</font></TD> <? echo "<TD class=mainTxt><font color='#000000'>$totaal</font></TD></TR>"; ?> <TR> <TD></TD></TR> <TR> <TD class=subTitle><B><U>Help Desk Operator</U></B></TD> <TD class=subTitle><B><U>Vragen </U></B><u><b>Behandeld</b></u></TD></TR> <TR> <TD class=mainTxt> <a href="/user.php?x=Morellow"> <font color="#000000">Morellow</font></a></TD> <? echo "<TD class=mainTxt><font color='#000000'>$mod1</font></TD></TR>"; ?> <TR> <TD class=mainTxt> <a href="/user.php?x=jelee"> <font color="#000000">jelee</font></a></TD> <? echo "<TD class=mainTxt><font color='#000000'>$mod2</font></TD></TR>"; ?> <TR> <TD class=mainTxt> <a href="/user.php?x=revengerman"> <font color="#000000">Revengerman</font></a></TD> <? echo "<TD class=mainTxt><font color='#000000'>$mod3</font></TD></TR>"; ?> <TR> <TD class=mainTxt> <a href="/user.php?x=Merlin"> <font color="#000000">Merlin</font></a></TD> <? echo "<TD class=mainTxt><font color='#000000'>$mod4</font></TD></TR>"; ?> <TD vAlign=top width="50%"> <TABLE width="90%" align=center> <TBODY> <TR> <TD class=subTitle><b>Opties</b></TD></TR> <TR> <TD class=mainTxt align=middle><a href="tickets.php?vraag=nieuw"><font color="#000000">Stel een nieuwe vraag</font></a></TD></TR> <TR> <TD class=mainTxt align=middle> <a href="tickets.php?vraag=openvraag"> <font color="#000000">Bekijk vragen</font></a></TD></TR> <? if($data->level >= 50 OR $data->login == "Merlin"){ print <<<ENDHTML <TR> <TD class=mainTxt align=middle> <a href="tickets.php?vraag=bvraag"> <font color="#000000">Beantwoord vragen</font></a></TD></TR></TABLE></TD></TR> ENDHTML; } ?> <? if ($_GET['vraag'] == "nieuw") { print <<<ENDHTML <br> <table align=center width=400> <tr><td class=subTitle><b>Stel een nieuwe vraag</b></td></tr> <tr><td class="mainTxt"> <form method=post> <table width="100%" border="0"> <tr> Vermeld duidelijk in je ticket wat je probleem of vraag is.<br> Tickets zonder of geen goede inhoud worden direct verwijderd.<br> Misbruik wordt zwaar bestrafd. </tr> <br> <tr> <td width="34%">Naam:</td> <td width="66%">{$data->login}<input type="hidden" name="naam" value="{$data->login}"></td> </tr> <tr> <td>Onderwerp:<br /></td> <td><input type="text" name="Onderwerp" size="23" maxlength=30></td> </tr> <tr> <td>Categorie:<br /></td> <td><select name="categorie"> <option value="kies" selected>Kies Categorie</option> <option value="Idee">Idee</option> <option value="Klacht">Klacht</option> <option value="Vraag over Spel">Vraag over Spel</option> <option value="Fouten/Bugs">Fouten/Bugs</option> <option value="Cheater Melden">Cheater Melden</option> </select></td> </tr> </table> <br /> <textarea cols=44 rows=6 name="bericht" size=24 wrap="VIRTUAL"></textarea> <br> <input type="submit" name="submit" value="Verstuur"> </td></tr></table><table></center> </form> ENDHTML; } if(isset($_POST['submit'])){ if($_POST["Onderwerp"] == ""){ echo"<font color=red>Je moet wel een Onderwerp opgeven van je bericht!"; die(); } if($_POST["categorie"] == "kies"){ echo"<font color=red>Je moet wel een Categorie selecteren waar je dit bericht in wilt posten!"; die(); } if($_POST["bericht"] == "Hier je bericht......."){ echo"<font color=red>Je moet wel een bericht opgeven om te posten!"; die(); } if($_POST["bericht"] == ""){ echo"<font color=red>Je moet wel een bericht opgeven om te posten!"; die(); } $vraag = $_POST["bericht"]; $Onderwerp = $_POST["Onderwerp"]; $categorie = $_POST["categorie"]; $insert2 = "INSERT INTO `helpdesk` ( `id`,`login`,`Categorie`,`Onderwerp`,`vraag`) VALUES ('','$data->login','$categorie','$Onderwerp','$vraag')"; $insert_now = mysql_query($insert2) or die("FOUT2 : " . mysql_error()); echo "Je hebt een bericht gepost op de Helpdesk Lijst. Iemand van de Helpdesk Operators zal hem zo snel mogelijk behandelen en hierover krijgt u natuurlijk bericht!"; } ?> <? if ($_GET['vraag'] == "eigenvraag") { print <<<ENDHTML <br> <table align=center width=500> <tr><td class=subTitle colspan=6><b>De door jou gestelde vragen</b></td></tr> <tr><td class="mainTxt"> <tr><td class=subTitle width=5%><b><u>Nr.</u></b></td><td width=20% class=subTitle><b><u>Categorie</u></b></td><td width=20% class=subTitle><b><u>Onderwerp</u></b></td><td width=20% class=subTitle><b><u>Naam</b></u></td><td width=20% class=subTitle><b><u>Operator</b></u></td><td width=5% class=subTitle><b><u>Status</b></u></td></tr> ENDHTML; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `login`='{$data->login}' ORDER BY id DESC LIMIT 0,10"); $count =0; while($jouw = mysql_fetch_object($select)) { if ($jouw->behandelt == "Nee") { $welofniet = "<img src='images/nietbehandelt.jpg' alt='Niet Behandelt'>"; } elseif ($jouw->behandelt == "Ja") { $welofniet = "<img src='images/welbehandelt.jpg' alt='Behandelt'>"; } $count++; echo "<tr><td class=mainTxt width=5% align=center>$count.</td><td width=20% class=mainTxt align=center>$jouw->categorie</td><td width=20% class=mainTxt align=center><a href='tickets.php?x=$jouw->onderwerp'>$jouw->onderwerp</a></td><td width=20% class=mainTxt align=center><a href='user.php?x=$jouw->login'>$jouw->login</a></td><td width=20% class=mainTxt align=center><a href='user.php?x=$jouw->operator'>$jouw->operator</a></td><td width=5% class=mainTxt align=center>$welofniet</td></tr>"; } print <<<ENDHTML </td></tr></table> ENDHTML; } ?> <? if ($_GET['vraag'] == "openvraag") { print <<<ENDHTML <br> <table align=center width=500> <tr><td class=subTitle colspan=5><b>De behandelde vragen</b></td></tr> <tr><td class="mainTxt"> <tr><td class=subTitle width=10%><b><u>Nr.</u></b></td><td width=20% class=subTitle><b><u>Categorie</u></b></td><td width=20% class=subTitle><b><u>Onderwerp</u></b></td><td width=20% class=subTitle><b><u>Naam</b></u></td><td width=5% class=subTitle><b><u>Status</b></u></td></tr> ENDHTML; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `behandelt`='ja' ORDER BY id DESC LIMIT 0,50"); $count =0; while($onbehandelt = mysql_fetch_object($select)) { $count++; echo "<tr><td class=mainTxt width=5% align=center>$count.</td><td width=20% class=mainTxt align=center>$onbehandelt->categorie</td><td width=20% class=mainTxt align=center><a href='tickets.php?avraag=$onbehandelt->id'><b>$onbehandelt->onderwerp</b></a></td><td width=20% class=mainTxt align=center><a href='user.php?x=$onbehandelt->login'>$onbehandelt->login</a></td><td width=5% class=mainTxt align=center><img src='images/welbehandelt.jpg' alt='Behandelt'></td></tr>"; } print <<<ENDHTML </td></tr></table> ENDHTML; } ?> <? if ($_GET['vraag'] == "openvraag") { print <<<ENDHTML <br> <table align=center width=500> <tr><td class=subTitle colspan=5><b>De onbehandelde vragen</b></td></tr> <tr><td class="mainTxt"> <tr><td class=subTitle width=10%><b><u>Nr.</u></b></td><td width=20% class=subTitle><b><u>Categorie</u></b></td><td width=20% class=subTitle><b><u>Onderwerp</u></b></td><td width=20% class=subTitle><b><u>Naam</b></u></td><td width=5% class=subTitle><b><u>Status</b></u></td></tr> ENDHTML; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `behandelt`='nee' ORDER BY id DESC LIMIT 0,100"); $count =0; while($onbehandelt = mysql_fetch_object($select)) { $onbehandelt->categorie = ereg_replace("\r", "<BR>", $onbehandelt->categorie); $count++; echo "<tr><td class=mainTxt width=5% align=center>$count.</td><td width=20% class=mainTxt align=center>$onbehandelt->categorie</td><td width=20% class=mainTxt align=center><a href='tickets.php?avraag=$onbehandelt->id'><b>$onbehandelt->onderwerp</b></a></td><td width=20% class=mainTxt align=center><a href='user.php?x=$onbehandelt->login'>$onbehandelt->login</a></td><td width=5% class=mainTxt align=center><img src='images/nietbehandelt.jpg' alt='Niet Behandelt'></td></tr>"; } print <<<ENDHTML </td></tr></table> ENDHTML; } ?> <? if ($_GET['x'] != "") { if (! ($data->level >= 50 OR $data->login == "Merlin")){ exit; } $id1 = $_GET['x']; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `id`='$id1'"); $get = mysql_fetch_object($select); print <<<ENDHTML <br> <form method="post" action="?xx=$id1"> <tr><td class=subTitle colspan=5><b>Behandel vraag</b></td></tr> <tr><td class=subTitle colspan=5><b>Vraag</b></td></tr> <tr><td class="mainTxt" colspan=5>$get->vraag</td></tr> <tr><td class=subTitle colspan=5><b>Antwoord</b></td></tr> <tr><td class="mainTxt"> <textarea name="antwoord" cols="50" rows="8"></textarea></td></tr> <tr><td><input type="submit" value="Beantwoord!"></td></tr></form> ENDHTML; } ?> <? if ($_GET['xx'] != "") { if (! ($data->level >= 50 OR $data->login == "Merlin")){ exit; } $id1 = $_GET['xx']; $antwoord = $_POST['antwoord']; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `id`='$id1'"); $select2 = mysql_query("SELECT login FROM `helpdesk` WHERE `id`='$id1'"); $get = mysql_fetch_object($select2); mysql_query("UPDATE `helpdesk` SET `antwoord`='$antwoord',`operator`='$data->login',`behandelt`='Ja' WHERE `id`='$id1'"); mysql_query("INSERT INTO `messages`(`time`,`IP`,`forwardedFor`,`from`,`to`,`subject`,`message`) values(NOW(),'{$_SERVER['REMOTE_ADDR']}','$forwardedFor','Notificatie','$get->login','Ticket','Je ticket is beantwoord, Ga naar ticketsysteem om het antwoord te bekijken.')"); print <<<ENDHTML Je hebt deze ticket beantwoord. ENDHTML; } ?> <? if ($_GET['avraag'] != "") { $id1 = $_GET['avraag']; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `id`='$id1'"); $get = mysql_fetch_object($select); $get->vraag = ereg_replace("\r", "<BR>", $get->vraag); $get->antwoord = ereg_replace("\r", "<BR>", $get->antwoord); echo "<table align=center width=500><tr><td class=subTitle>Vraag</td></tr> <tr><td class=mainTxt>$get->vraag</td></tr> <tr><td class=subTitle>Antwoord</td></tr> <tr><td class=mainTxt>$get->antwoord</td></tr></table>"; } ?> <? if ($_GET['vraag'] == "bvraag") { if (! ($data->level >= 50 OR $data->login == "Merlin")){ exit; } print <<<ENDHTML <br> <table align=center width=500> <tr><td class=subTitle colspan=5><b>Behandel vragen</b></td></tr> <tr><td class="mainTxt"> <tr><td class=subTitle width=10%><b><u>Nr.</u></b></td><td width=20% class=subTitle><b><u>Categorie</u></b></td><td width=20% class=subTitle><b><u>Onderwerp</u></b></td><td width=20% class=subTitle><b><u>Naam</b></u></td><td width=5% class=subTitle><b><u>Behandel</b></u></td><td width=5% class=subTitle><b><u>Status</b></u></td></tr> ENDHTML; $select = mysql_query("SELECT * FROM `helpdesk` WHERE `behandelt`='Nee' ORDER BY id DESC LIMIT 0,100"); $count =0; while($onbehandelt = mysql_fetch_object($select)) { $count++; echo "<tr><td class=mainTxt width=5% align=center>$count.</td><td width=20% class=mainTxt align=center>$onbehandelt->categorie</td><td width=20% class=mainTxt align=center><a href='tickets.php?avraag=$onbehandelt->id'><b>$onbehandelt->onderwerp<b></a></td><td width=20% class=mainTxt align=center><a href='user.php?x=$onbehandelt->login'>$onbehandelt->login</a></td><td width=20% class=mainTxt align=center><a href='?x=$onbehandelt->id'>Behandel</a></td><td width=5% class=mainTxt align=center><img src='images/welbehandelt.jpg' alt='Behandelt'></td></tr>"; } print <<<ENDHTML </td></tr></table> ENDHTML; } ?> <? if ($_GET['vraag'] == "allevraag") { print <<<ENDHTML <br> <table align=center width=500> <tr><td class=subTitle colspan=6><b>Alle vragen</b></td></tr> <tr><td class="mainTxt"> <tr><td class=subTitle width=5%><b><u>Nr.</u></b></td><td width=20% class=subTitle><b><u>Categorie</u></b></td><td width=20% class=subTitle><b><u>Onderwerp</u></b></td><td width=20% class=subTitle><b><u>Naam</b></u></td><td width=20% class=subTitle><b><u>Operator</b></u></td><td width=5% class=subTitle><b><u>Status</b></u></td></tr> ENDHTML; $select = mysql_query("SELECT * FROM `helpdesk` ORDER BY id DESC LIMIT 0,100"); $count =0; while($alle = mysql_fetch_object($select)) { if ($alle->behandelt == "Nee") { $welofniet = "<img src='images/nietbehandelt.jpg' alt='Niet Behandelt'>"; } elseif ($alle->behandelt == "Ja") { $welofniet = "<img src='images/welbehandelt.jpg' alt='Behandelt'>"; } if ($alle->operator == "") { $operator = "<font color=red>Geen</font>"; } elseif ($alle->operator != "") { $operator = "<font color=green><a href='user.php?x=$alle->operator'>$alle->operator</a></font>"; } $count++; echo "<tr><td class=mainTxt width=5% align=center>$count.</td><td width=20% class=mainTxt align=center>$alle->categorie</td><td width=20% class=mainTxt align=center><a href='tickets.php?avraag=$alle->id'><b>$alle->onderwerp</b></a></td><td width=20% class=mainTxt align=center><a href='user.php?x=$alle->login'>$alle->login</a></td><td width=20% class=mainTxt align=center>$operator</td></td><td width=5% class=mainTxt align=center>$welofniet</td></tr>"; } print <<<ENDHTML </td></tr></table> ENDHTML; } ?> </body> </html>db:
PHP
Meer tonen-- -- Tabel structuur voor tabel `helpdesk` -- CREATE TABLE `helpdesk` ( `id` int(11) NOT NULL auto_increment, `login` varchar(25) NOT NULL default '', `operator` varchar(25) NOT NULL default '', `categorie` varchar(50) NOT NULL default '', `onderwerp` varchar(30) NOT NULL default '', `vraag` text NOT NULL, `antwoord` text NOT NULL, `behandelt` varchar(20) NOT NULL default 'Nee', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Gegevens worden uitgevoerd voor tabel `helpdesk` --
