API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 29th, 2017
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.45 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. if($user_rank > 3){
  4.  
  5. if($hkzone !== true){ header("Location: index.php?throwBack=true"); exit; }
  6. if(!isset($_SESSION['acp'])){ header("Location: index?p=login"); exit; }
  7.  
  8. $pagename = "Support - Übersicht";
  9. $pageid = "support";
  10.  
  11. $posts = mysql_evaluate("SELECT COUNT(*) FROM cms_support");
  12. $pages = ceil(($posts + 0) / 50);
  13.  
  14. if(isset($page)){
  15. if($page > $pages || $page < 1){
  16. $page = 1;
  17. }
  18. } else {
  19. $page = 1;
  20. }
  21.  
  22. if(isset($_POST['site'])){
  23. header("location: ".$adminpath."/index/p/support&page=".FilterText($_POST['page'])."");
  24. }
  25.  
  26. if(isset($do)){
  27. if($do == "delete" && is_numeric($key)){
  28. $check = mysql_query("SELECT id FROM cms_support WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
  29.  
  30. if(mysql_num_rows($check) > 0){
  31. mysql_query("DELETE FROM cms_support WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
  32. mysql_query("INSERT INTO stafflogs (action,message,note,userid,targetid,timestamp) VALUES ('Housekeeping','Ticket gelöscht','support.php','".$my_id."','','".$date_full."')") or die(mysql_error());
  33. $msg = "<div class='rounded rounded-green'><center>Ticket wurde erfolgreich gelöscht. <img src=\"./images/check.gif\"></center></div>";
  34. } else {
  35. $msg = "<div class='rounded rounded-red'><center>Fehler - Ticket konnten nicht gelöscht werden. <img src=\"./images/del.gif\"></center></div>";
  36. }
  37.  
  38. $editor_mode = false;
  39.  
  40. } elseif($do == "edit" && is_numeric($key)){
  41. $check = mysql_query("SELECT * FROM cms_support WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
  42.  
  43. if(mysql_num_rows($check) > 0){
  44. $support = mysql_fetch_assoc($check);
  45.  
  46. if($support['pickup'] == "0"){
  47. mysql_query("UPDATE cms_support SET id_picker = '".$my_id."', pickup = '1' WHERE id = '".$key."'");
  48. header("location: #");
  49. }
  50.  
  51. $editor_mode = true;
  52. } else {
  53. $msg = "<div class='rounded rounded-red'><center>Fehler - Ticket konnten nicht gefunden werden. <img src=\"./images/del.gif\"></center></div>";
  54. }
  55.  
  56. } elseif($do == "save" && is_numeric($key) && isset($_POST['alert'])){
  57. $check = mysql_query("SELECT id,id_user FROM cms_support WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
  58.  
  59. if(mysql_num_rows($check) > 0){
  60. $support = mysql_fetch_assoc($check);
  61. mysql_query("INSERT INTO cms_alerts (userid,alert) VALUES ('".$support['id_user']."','Antwort auf dein Support-Ticket ~ <b>".$key."</b>:<br><br>".$_POST['alert']."')") or die(mysql_error());
  62. mysql_query("UPDATE cms_support SET pickup = '2' WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
  63. mysql_query("INSERT INTO stafflogs (action,message,note,userid,targetid,timestamp) VALUES ('Housekeeping','Ticket Bearbeitet','support.php','".$my_id."','".$support['id_user']."','".$date_full."')") or die(mysql_error());
  64. $msg = "<div class='rounded rounded-green'><center>Ticket wurde erfolgreich bearbeitet. <img src=\"./images/check.gif\"></center></div>";
  65. $editor_mode = false;
  66. } else {
  67. $msg = "<div class='rounded rounded-red'><center>Fehler - Das Ticket existiert nichtmehr! <img src=\"./images/check.gif\"></center></div>";
  68. }
  69.  
  70. }
  71.  
  72. } else {
  73. $editor_mode = false;
  74. }
  75.  
  76. @include('subheader.php');
  77.  
  78. if(isset($msg)){ ?><p><strong><?php echo $msg; ?></strong></p><?php } ?>
  79.  
  80. <?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
  81. <?php if(isset($editor_mode) && $editor_mode !== true){ ?>
  82. <?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
  83.  
  84. <form action='<?php echo $adminpath; ?>/index/p/support&do=save' method='post' name='theAdminForm' id='theAdminForm'>
  85.  
  86. <div class='tableborder'>
  87. <div class='tableheaderalt'><center><?php echo mysql_evaluate("SELECT COUNT(*) FROM cms_support"); ?> Hilferufe // Davon <?php echo mysql_evaluate("SELECT COUNT(*) FROM cms_support WHERE pickup != '2'"); ?> Unbearbeitet //
  88.  
  89. <select name="page">
  90. <?php for ($i = 1; $i <= $pages; $i++){ ?>
  91. <option value="<?php echo $i; ?>"<?php if($i == $page){ echo' selected="selected"'; } ?>><?php echo $i; ?></option>
  92. <?php } ?>
  93. </select>
  94.  
  95. <input type="submit" name="site" value="Weiter »">
  96. </div>
  97.  
  98. <table cellpadding='4' cellspacing='0' width='100%'>
  99. <tr>
  100. <td class='tablesubheader' width='1%' align='center'>ID</td>
  101. <td class='tablesubheader' width='20%'>Status</td>
  102. <td class='tablesubheader' width='10%'><?php echo $sitename; ?></td>
  103. <td class='tablesubheader' width='40%'>Kategorie</td>
  104. <td class='tablesubheader' width='15%'>Datum</td>
  105. <td class='tablesubheader' width='1%'>Bearbeitung</td>
  106. </tr>
  107.  
  108. <?php
  109.  
  110. $query_min = ($page * 50) - 50;
  111.  
  112. if($query_min < 0){
  113. $query_min = 0;
  114. }
  115.  
  116. $get_tickets = mysql_query("SELECT * FROM cms_support ORDER BY id DESC LIMIT ".$query_min.", 50") or die(mysql_error());
  117. while($row = mysql_fetch_assoc($get_tickets)){
  118.  
  119. $user = mysql_fetch_assoc($user = mysql_query("SELECT username FROM users WHERE id = '".$row['id_user']."'"));
  120.  
  121. if($row['pickup'] == "0"){
  122. $status = "<font color='red'>Unbearbeitet!</font>";
  123. } elseif($row['pickup'] == "1"){
  124. $picker = mysql_fetch_assoc($get_picker = mysql_query("SELECT username FROM users WHERE id = '".$row['id_picker']."'"));
  125. $status = "<font color='orange'>Bearbeitung von <b>".$picker['username']."</b>!</font>";
  126. } else {
  127. $status = "<font color='green'>Bearbeitet!</font>";
  128. }
  129.  
  130. ?>
  131.  
  132. <tr>
  133. <td class='tablerow1' align='center'><?php echo $row['id']; ?></td>
  134. <td class='tablerow2'><?php echo $status; ?></td>
  135. <td class='tablerow1' align='center'><?php echo $user['username']; ?></td>
  136. <td class='tablerow2'><?php echo $row['category']; ?></td>
  137. <td class='tablerow2'><?php echo date('d.m.Y - H:i:s', $row['timestamp']); ?> Uhr</td>
  138. <td class='tablerow2' align='center'><a href='<?php echo $adminpath; ?>/index/p/support&do=edit&key=<?php echo $row['id']; ?>'><img src='./images/<?php if($row['pickup'] == "0"){ echo"check"; } else { echo"edit"; } ?>.gif'></a> <a href='<?php echo $adminpath; ?>/index/p/support&do=delete&key=<?php echo $row['id']; ?>'><img src='./images/del.gif' alt='Delete'></a></td>
  139. </tr>
  140.  
  141. <?php } ?>
  142. </table>
  143.  
  144. <?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
  145. <?php } elseif(isset($do) && $do == "edit" && is_numeric($key)) { ?>
  146. <?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
  147.  
  148. <form action='<?php echo $adminpath; ?>/index/p/support&do=save&key=<?php echo $key; ?>' method='post' name='theAdminForm' id='theAdminForm'>
  149. <div class='tableborder'>
  150. <div class='tableheaderalt'><center>Ticket ID: <?php echo $key; ?>!</center> <div style="float: right; margin-top: -22px; margin-right: 5px;"><input onclick="javascript:history.go(-1);" value='Zurück' class='cancelbutton' accesskey='s'> <input type='submit' name='submit' value='Ticket Speichern' class='savebutton' accesskey='s'></div></div>
  151.  
  152. <table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'>
  153.  
  154. <tr>
  155. <td class='tablerow1' width='40%' valign='middle'><b>User</b><div class='graytext'>Von wem das Ticket erstellt worden ist</div></td>
  156. <td class='tablerow2' width='60%' valign='middle'><input type='text' name='id_user' disabled='disabled' value="<?php $user = mysql_fetch_assoc($user = mysql_query("SELECT username FROM users WHERE id = '".$support['id_user']."'")); echo $user['username']; ?>" size='30' class='textinput'></td>
  157. </tr>
  158.  
  159. <tr>
  160. <td class='tablerow1' width='40%' valign='middle'><b>Supporter/in</b><div class='graytext'>Staff, der das Ticket bearbeitet (hat)</div></td>
  161. <td class='tablerow2' width='60%' valign='middle'><input type='text' name='id_picker' disabled='disabled' value="<?php $user = mysql_fetch_assoc($user = mysql_query("SELECT username FROM users WHERE id = '".$support['id_picker']."'")); echo $user['username']; ?>" size='30' class='textinput'></td>
  162. </tr>
  163.  
  164. <tr>
  165. <td class='tablerow1' width='40%' valign='middle'><b>Kategorie</b><div class='graytext'>Art des Tickets</div></td>
  166. <td class='tablerow2' width='60%' valign='middle'><input type='text' name='category' value="<?php echo $support['category']; ?>" size='30' class='textinput'></td>
  167. </tr>
  168.  
  169. <tr>
  170. <td class='tablerow1' width='40%' valign='middle'><b>Beschreibung</b><div class='graytext'>Problem/Idee des Users</div></td>
  171. <td class='tablerow2' width='60%' valign='middle'><textarea id="content" name="comment" style="width:80%"><?php echo $support['comment']; ?></textarea>
  172. </td>
  173. </tr>
  174.  
  175. <tr>
  176. <td class='tablerow1' width='40%' valign='middle'></td>
  177. <td class='tablerow2' width='60%' valign='middle'></td>
  178. </tr>
  179.  
  180. <tr>
  181. <td class='tablerow1' width='40%' valign='middle'><b>Antwort</b><div class='graytext'>Antwort auf das Ticket (ID-<b><?php echo $key; ?></b>)<br /><font color="green">HTML is erlaubt.</font></div></td>
  182. <td class='tablerow2' width='60%' valign='middle'><textarea id="content" name="alert" style="width:80%"></textarea>
  183.  
  184.  
  185. <?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
  186. <?php } ?>
  187. <?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
  188.  
  189. </div>
  190. </table></div>
  191.  
  192. <?php require_once('footer.php'); } else { require_once('error.php'); exit; } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!