Posts by thymen

thymen · 17 Mei 2012

http://img36.imageshack.us/img36/7590/zu552sat.jpg
de ballen

thymen · 12 September 2011

Ticket.php:

PHP

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

Toon Meer

db:

PHP

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

Toon Meer

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

193 Nieuwe domeinnamen April 2025

228 Nieuwe domeinnamen Maart 2025

285 Nieuwe domeinnamen Februari 2025

Posts by thymen

Plaatjes makers gezocht

Ticket systeem

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2