Posts by thymen

thymen

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

thymen

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

ICTscripters

Dé plek voor IT

Dé plek voor IT

Ictscripters Chat

Het Grote Vibe Code Topic

PWYL source gezocht

Help testers nodig voor android app Urgent

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Afspraken systeem met planbeperking

Developer Gezocht

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

370 Nieuwe Domeinnamen April 2026

Snel een website nodig?

Sicarras.com - Moderne Mafia Text-Based RPG

Posts by thymen

Plaatjes makers gezocht

Ticket systeem

Google Cloud is in de problemen (en AWS weet het)

Nebius kondigt bouw aan van een van Europa's grootste datacenters

Samsung zal miljoenen verdienen aan Apple iPhone Fold dankzij zijn 12GB RAM

Functioneel ontwerp

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

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