Reply to thread

Message

<blockquote data-quote="vaulient2" data-source="post: 214205" data-attributes="member: 29433">[code]&lt;?PHP&nbsp;$p1 = 5;&nbsp;$pages = mysql_query(&quot;SELECT COUNT(id) FROM cms_comments&quot;);$p2 = ceil(mysql_result($pages, 0) / $p1);&nbsp;$page = (isset($_GET['page'])) ? (int)$_GET['page'] :&nbsp; 1;$start = ($page - 1) * $p1;&nbsp;&nbsp;$uids = $_SESSION['user']['id'];$id = preg_replace('/\D/', '', $_GET['id']);&nbsp;function getPost($uid) {$sql = &quot;SELECT * FROM cms_comments WHERE author = '$uid' LIMIT $start, $p1&quot;;$query = mysql_query($sql) or die(mysql_error());$nummy = mysql_query(&quot;SELECT * FROM cms_comments&quot;);$numrows = mysql_num_rows($nummy);if(mysql_num_rows($query) &gt; 0 &amp;&amp; $_SESSION['user']['rank'] &lt; 0) {return true;}else { return false; }}if(getPost($uids) == true) { echo 'You may only post once!'; }function post($data, $story, $uid) {$clean = htmlentities(mysql_real_escape_string($data));$sql = &quot;INSERT INTO cms_comments (story, comment, date, author) VALUES ('$story', '$clean', '&quot;. time() .&quot;', '$uid')&quot;;$query = mysql_query($sql) or die(mysql_error());}$posts = getPost($uids);if(isset($_POST['comment']) &amp;&amp; strlen($_POST['comment']) &gt; 0 &amp;&amp; strlen($_POST['comment']) &lt; 500 &amp;&amp; $posts == false) {post($_POST['comment'], $id, $uids);echo '&lt;head&gt;&lt;meta http-equiv=&quot;refresh&quot; content=&quot;0&quot;&gt;&lt;/head&gt;';}&nbsp;&nbsp;&nbsp;&nbsp;$sql = &quot;SELECT * FROM cms_comments WHERE story = '{$id}' ORDER BY id DESC&quot;;$query = mysql_query($sql) or die(mysql_error());&nbsp;while($ua = mysql_fetch_array($query)) {$uiq = mysql_query(&quot;SELECT * FROM users WHERE id = &quot;. $ua['author']) or die(mysql_error());$ui = mysql_fetch_array($uiq) or die(mysql_error());&nbsp;if($ui['rank'] &gt;= 10) { $username = '&lt;span style=&quot;font-family:Arial,Helvetica,sans-serif; color: #7D0A79;text-shadow: 0px 0px 5px #343434;background:url(/app/tpl/skins/Custom-Habbo/images/glitter.gif);&quot;&gt;'. $ui['username'] .'&lt;/span&gt;';}else { $username = '&lt;span style=&quot;font-family:Arial,Helvetica,sans-serif;&quot;&gt;'. $ui['username'] .'&lt;/span&gt;'; }&nbsp;if($ui['rank'] &gt;= 6) { $username = '&lt;span style=&quot;font-family:Arial,Helvetica,sans-serif; color: #7D0A79;text-shadow: 0px 0px 5px #343434;background:url(/app/tpl/skins/Custom-Habbo/images/glitter.gif);&quot;&gt;'. $ui['username'] .'&lt;/span&gt;';}else { $username = '&lt;span style=&quot;font-family:Arial,Helvetica,sans-serif;&quot;&gt;'. $ui['username'] .'&lt;/span&gt;'; }}echo &quot;Pages: &quot;;if($p2 &gt;= 1 &amp;&amp; $page &lt;= $p2){for($x=1; $x&lt;=$p2; $x++) {&nbsp;echo ($x == $page) ? '&lt;strong&gt;&lt;a href=&quot;?page='.$x.'&quot;&gt;'.$x.'&lt;/a&gt;&lt;/strong&gt; ' : '&lt;a href=&quot;?page='.$x.'&quot;&gt;'.$x.'&lt;/a&gt; ';}}&nbsp;?&gt;[/code]Well I've been working on this fo sometime now , and I'm stuck with a syntax error. I can't find it anywhere , could any of you help me out?</blockquote>

[QUOTE="vaulient2, post: 214205, member: 29433"] [code]<?PHP $p1 = 5; $pages = mysql_query("SELECT COUNT(id) FROM cms_comments"); $p2 = ceil(mysql_result($pages, 0) / $p1); $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1; $start = ($page - 1) * $p1; $uids = $_SESSION['user']['id']; $id = preg_replace('/\D/', '', $_GET['id']); function getPost($uid) { $sql = "SELECT * FROM cms_comments WHERE author = '$uid' LIMIT $start, $p1"; $query = mysql_query($sql) or die(mysql_error()); $nummy = mysql_query("SELECT * FROM cms_comments"); $numrows = mysql_num_rows($nummy); if(mysql_num_rows($query) > 0 && $_SESSION['user']['rank'] < 0) { return true; } else { return false; } } if(getPost($uids) == true) { echo 'You may only post once!'; } function post($data, $story, $uid) { $clean = htmlentities(mysql_real_escape_string($data)); $sql = "INSERT INTO cms_comments (story, comment, date, author) VALUES ('$story', '$clean', '". time() ."', '$uid')"; $query = mysql_query($sql) or die(mysql_error()); } $posts = getPost($uids); if(isset($_POST['comment']) && strlen($_POST['comment']) > 0 && strlen($_POST['comment']) < 500 && $posts == false) { post($_POST['comment'], $id, $uids); echo '<head><meta http-equiv="refresh" content="0"></head>'; } $sql = "SELECT * FROM cms_comments WHERE story = '{$id}' ORDER BY id DESC"; $query = mysql_query($sql) or die(mysql_error()); while($ua = mysql_fetch_array($query)) { $uiq = mysql_query("SELECT * FROM users WHERE id = ". $ua['author']) or die(mysql_error()); $ui = mysql_fetch_array($uiq) or die(mysql_error()); if($ui['rank'] >= 10) { $username = ''. $ui['username'] .'';} else { $username = ''. $ui['username'] .''; } if($ui['rank'] >= 6) { $username = ''. $ui['username'] .'';} else { $username = ''. $ui['username'] .''; } } echo "Pages: "; if($p2 >= 1 && $page <= $p2){ for($x=1; $x<=$p2; $x++) { echo ($x == $page) ? '<a href="?page='.$x.'">'.$x.'</a> ' : '<a href="?page='.$x.'">'.$x.'</a> '; } } ?>[/code] Well I've been working on this fo sometime now , and I'm stuck with a syntax error. I can't find it anywhere , could any of you help me out? [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members