Reply to thread

Message

<blockquote data-quote="JoshuaS" data-source="post: 435271" data-attributes="member: 41738">Hi DB.I'm currently working on a cms with arcturus and i have a problem with my checktheban.php.I use this:[SPOILER=&quot;checktheban.php&quot;][PHP]&lt;?php$userID = (isset($_SESSION['user']['id'])) ? $_SESSION['user']['id'] : 0;$ip = (isset($_SERVER[&quot;HTTP_CF_CONNECTING_IP&quot;]) &amp;&amp; !empty($_SERVER[&quot;HTTP_CF_CONNECTING_IP&quot;])) ? $_SERVER[&quot;HTTP_CF_CONNECTING_IP&quot;] : $_SERVER[&quot;REMOTE_ADDR&quot;];$getBan = mysql_query(&quot;SELECT * FROM bans WHERE user_id = '{$userID}' OR ip = '{$ip}' ORDER BY ban_expire DESC LIMIT 1&quot;);while($ban = mysql_fetch_array($getBan)){&nbsp; &nbsp; if($ban['ban_expire'] &gt;= time())&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; if($ban['type'] == 'account') die(header('Location: /banned'));&nbsp; &nbsp; &nbsp; &nbsp; die(header('Location: /ipbanned'));&nbsp; &nbsp; }}?&gt;[/PHP][/SPOILER] and this[SPOILER=&quot;class.users&quot;][PHP]final public function isBanned($value)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $engine;&nbsp; &nbsp; &nbsp; &nbsp; if($engine-&gt;num_rows(&quot;SELECT * FROM bans WHERE value = '&quot; . $value . &quot;' LIMIT 1&quot;) &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; final public function getReason($value)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $engine;&nbsp; &nbsp; &nbsp; &nbsp; return $engine-&gt;result(&quot;SELECT ban_reason FROM bans WHERE value = '&quot; . $value . &quot;' LIMIT 1&quot;);&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; final public function hasClones($ip)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $engine;&nbsp; &nbsp; &nbsp; &nbsp; if($engine-&gt;num_rows(&quot;SELECT * FROM users WHERE ip_register = '&quot; . $_SERVER['REMOTE_ADDR'] . &quot;'&quot;) == 2)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; }&nbsp; &nbsp; [/PHP][/SPOILER]The problem that i have is, that even when i ban someone, its not only the account, but it seems to be the whole ip. I'm using arcturus. I hope someone can help. Thx</blockquote>

[QUOTE="JoshuaS, post: 435271, member: 41738"] Hi DB. I'm currently working on a cms with arcturus and i have a problem with my checktheban.php. I use this:[SPOILER="checktheban.php"][PHP] <?php $userID = (isset($_SESSION['user']['id'])) ? $_SESSION['user']['id'] : 0; $ip = (isset($_SERVER["HTTP_CF_CONNECTING_IP"]) && !empty($_SERVER["HTTP_CF_CONNECTING_IP"])) ? $_SERVER["HTTP_CF_CONNECTING_IP"] : $_SERVER["REMOTE_ADDR"]; $getBan = mysql_query("SELECT * FROM bans WHERE user_id = '{$userID}' OR ip = '{$ip}' ORDER BY ban_expire DESC LIMIT 1"); while($ban = mysql_fetch_array($getBan)) { if($ban['ban_expire'] >= time()) { if($ban['type'] == 'account') die(header('Location: /banned')); die(header('Location: /ipbanned')); } } ?> [/PHP][/SPOILER] and this[SPOILER="class.users"] [PHP]final public function isBanned($value) { global $engine; if($engine->num_rows("SELECT * FROM bans WHERE value = '" . $value . "' LIMIT 1") > 0) { return true; } return false; } final public function getReason($value) { global $engine; return $engine->result("SELECT ban_reason FROM bans WHERE value = '" . $value . "' LIMIT 1"); } final public function hasClones($ip) { global $engine; if($engine->num_rows("SELECT * FROM users WHERE ip_register = '" . $_SERVER['REMOTE_ADDR'] . "'") == 2) { return true; } return false; } [/PHP] [/SPOILER] The problem that i have is, that even when i ban someone, its not only the account, but it seems to be the whole ip. I'm using arcturus. I hope someone can help. Thx [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members