Hallo CP,
Wie weet waar ik een gratis -Nederlandstalig- ticket (helpdesk) systeem kan krijgen? Het liefst zonder scripting, maar gewoon downloadbaar
Mvg,
Crime2Go
Hallo CP,
Wie weet waar ik een gratis -Nederlandstalig- ticket (helpdesk) systeem kan krijgen? Het liefst zonder scripting, maar gewoon downloadbaar
Mvg,
Crime2Go
Wat voor wil je? Een soort chat? Of gewoon dat mensen posten en dat je later antwoord?
Citaat van iSilverStarWat voor wil je? Een soort chat? Of gewoon dat mensen posten en dat je later antwoord?
Dat mensen posten en dat ik later antwoord...
Ik heb er wel een voor je. Maar heb geen zin om em nu te zoeken. Ik post hem morgen hier op cp
Citaat van iSilverStarIk heb er wel een voor je. Maar heb geen zin om em nu te zoeken. Ik post hem morgen hier op cp
Oké. Hartstikke bedankt!
Volgensmij is Livesupport een gratis helpdesk systeem. Zo kunnen leden een ticket maken en door diegene die staan ingeschreven in de database bij Livesupport kunnen zij het afhandelen.
Mitch
Ticket.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:
--
-- 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
@ Thymen:
Erg mooi, maar ik zoek software, met een simpele insluitcode die ik op mijn website kan plaatsen. Geen hele PHP scripts...
[offtopic]BTW: Gefeliciteerd met je eerste post :cheer:[/offtopic]
Nieuwe reactie samengevoegd met originele reactie op 17.09.11 21:22:23:
BuMp!
Heb je nog geen account? Registreer je nu en word deel van onze community!