last update: Mon, 05 Sep 2011 17:17:04 +0000
  1. <?
  2. require_once('add_smarty.php');
  3. require_once("session.php");
  4. require_once('mysql_cfg.php');
  7. require_once('code_css.php');
  8. require_once('filterhtml.php');
  11. //main template
  12. $smarty->assign('main_template', 'html.tpl');
  13. //title
  14. $smarty->assign('title', 'Html-peqpaste');
  16. //set default = nothing
  17. $smarty->assign('html_code', false);
  18. $smarty->assign('id', false);
  22. function escape_string($s)
  23. {
  24. //$result = $s;
  25. //$result = str_replace('\\', '\\\\', $result);
  26. //$result = str_replace('"', '###anfuehrunszeichen###', $result);
  27. //return $result;
  28. return mysql_real_escape_string($s);
  29. }
  31. function unescape_string($s)
  32. {
  33. $result = $s;
  34. $result = str_replace('\"', '"', $result);
  35. $result = str_replace('\\\'', "'", $result);
  36. return $result;
  37. }
  41. if (isset($_POST['html']))
  42. {
  43. $query = 'SELECT `id` as x FROM `mapping_nopaste_html` ORDER BY `id` DESC;';
  44. $count = mysql_fetch_array(mysql_query($query, $mysqlconnection));
  46. $id = $count['x'] + 1;
  47. //$html = "<pre>".htmlspecialchars($_POST['html'])."</pre>";
  53. $query = 'INSERT INTO
  54. `mapping_nopaste_html` (`id`, `html`, `datum` )
  55. VALUES ("'.$id.'", "'.escape_string($_POST['html']).'", NOW())
  56. ';
  58. $temp = mysql_query($query, $mysqlconnection);
  59. echo mysql_error();
  60. if (mysql_error())
  61. {
  62. echo "<pre>$query</pre><br />";
  63. }
  65. $smarty->assign('id', $id);
  68. $smarty->assign('html_code', FilterHTML(unescape_string($_POST['html'])));
  71. }
  72. elseif (isset($_GET['id']))
  73. {
  74. $id = $_GET['id'];
  75. $smarty->assign('title', 'Html-peqpaste #'.$id);
  78. $query = 'SELECT * FROM `mapping_nopaste_html` WHERE `id` LIKE "'.$id.'";';
  79. //echo "$query<br>";
  80. $data = mysql_query($query, $mysqlconnection);
  81. echo mysql_error();
  82. $row = mysql_fetch_array($data);
  84. if (isset($_GET['interface']))
  85. {
  86. $smarty->assign('id', $id);
  87. $smarty->assign('html_code', FilterHTML(unescape_string($row['html'])));
  88. }
  89. else
  90. {
  91. echo unescape_string(FilterHTML($row['html']));
  92. unset($smarty);
  93. }
  98. }
  101. if (isset($smarty))
  102. {
  103. $smarty->assign("compileTime",sprintf("%.4f",(microtime(true) - $sript_start_time))); $smarty->display('site.tpl');
  104. }
  105. ?>

goto line:
Compare with:
text copy window edit this code post new code