last update: Mon, 05 Sep 2011 17:16:55 +0000
  1. <?
  2. /*
  3. CREATE TABLE `languages` (
  4. `id` INT NOT NULL ,
  5. `name` VARCHAR( 200 ) NOT NULL ,
  6. `owner` INT DEFAULT '0' NOT NULL ,
  7. `data` LONGTEXT NOT NULL
  8. ) TYPE = innodb;
  10. CREATE TABLE `styles` (
  11. `id` INT NOT NULL ,
  12. `name` VARCHAR( 200 ) NOT NULL ,
  13. `owner` INT NOT NULL ,
  14. `data` LONGTEXT NOT NULL ,
  15. `hidden` BOOL DEFAULT '1' NOT NULL ,
  16. `public` BOOL DEFAULT '0' NOT NULL ,
  17. PRIMARY KEY ( `id` )
  18. ) TYPE = innodb;
  20. */
  22. require_once('common.php');
  25. require_once('code_css.php');
  26. require_once('codetitles.php');
  29. //main template
  30. $smarty->assign('main_template', 'drawgraph.tpl');
  31. //title
  32. $pageTitle = "Online Graph Tool";
  34. //set default = nothing
  35. $smarty->assign('text', false);
  36. $smarty->assign('id', false);
  38. $additional_headers = array();
  41. function escape_string($s)
  42. {
  44. return str_replace('"', '\"', $s);
  45. }
  47. function unescape_string($s)
  48. {
  49. //return $s;
  50. return stripslashes($s);
  51. //return str_replace('\"', '"', $s);
  52. }
  59. if (isset($_POST['text']))
  60. {
  63. $text = unescape_string($_POST['text']);
  64. $engine = $_POST['engine'];
  65. $rankdir = $_POST['rankdir'];
  67. if (!in_array($engine, array("dot", "neato", "fdp", "twopi", "circo"))) {
  68. die('Hack Versuch? Diese Anfrage wurde geloggt.');
  69. }
  70. if (!in_array($rankdir, array("LR", "RL", "TB", "BT"))) {
  71. die('Hack Versuch? Diese Anfrage wurde geloggt.');
  72. }
  76. //todo
  77. // ranksep=0.5, nodesep=0.1,
  78. $options = '
  79. graph [overlap=false, start=1, splines=true]
  80. edge [len=1.5, weight=2.0]';
  81. if ($engine == "dot") {
  82. $options.= 'rankdir = '.$rankdir.';';
  83. }
  87. $text = mysql_real_escape_string($text);
  88. $options = mysql_real_escape_string($options);
  89. $engine = mysql_real_escape_string($engine);
  91. $query = 'INSERT INTO `graph` (
  92. `time` ,
  93. `userid` ,
  94. `text` ,
  95. `options`,
  96. `engine`
  97. )
  98. VALUES (NOW(), "'.session_get_userid_secure().'", "'.$text.'", "'.$options.'", "'.$engine.'" )';
  99. $temp = mysql_query($query, $mysqlconnection);
  100. echo mysql_error();
  101. $id = mysql_insert_id();
  102. /*
  103. $smarty->assign('output', $output);
  104. $smarty->assign('jass_code', strip_markup($code));
  105. */
  106. $additional_headers[] ='<script>document.location="drawgraph.php?id='.$id.'";</script>';
  107. $smarty->assign('id', $id);
  111. }
  112. elseif (isset($_GET['id']))
  113. {
  115. $id = intval($_GET['id']);
  116. ;
  121. $query = 'SELECT * FROM `graph` WHERE `id` LIKE "'.$id.'";';
  123. $data = mysql_query($query, $mysqlconnection);
  124. echo mysql_error();
  125. $row = mysql_fetch_array($data);
  126. $text = $row['text'];
  129. $smarty->assign('id', $id);
  130. $smarty->assign('text', $text);
  133. }
  134. else
  135. {
  138. }
  139. $additional_headers[] = '<script language="Javascript" type="text/javascript" src="./jquery/jquery.js"></script>';
  140. $additional_headers[] = '<script language="Javascript" type="text/javascript" src="./jquery/jquery.textarea.js"></script>';
  141. $additional_headers[] =
  142. '<script language="Javascript" type="text/javascript">
  143. jQuery(document).ready(function () {
  144. $("textarea").tabby();
  145. });
  146. </script>';
  149. finish($smarty, 'drawgraph.tpl', $additional_headers);
  150. ?>

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