<?php
/* Listado con las IPs */
$ban_ip_list = array('68.180.206.184', '64.233.167.99', '207.46.232.182');
 
/* Listado con el rango de IP. Use the '*' as the range selector */
$ban_ip_range = array('69.*.83.197');
 
/* Ip Visitante */
$user_ip = $_SERVER['REMOTE_ADDR'];
 
/* Mensaje que verá si está baneado */
$msg = 'You do not have permission to access this page.';
 
/* Message to output if the IP is in the ban list */
 
    if(in_array($user_ip, $ban_ip_list))
	{
	  exit($msg);
	}
 
/* Check if the Visitor's IP is in our range's list */
 
if(!empty($ban_ip_range))
{
foreach($ban_ip_range as $range)
{
	$range = str_replace('*','(.*)', $range);
 
    if(preg_match('/'.$range.'/', $user_ip))
	{
	  exit($msg);
	}
}
}
?>

<?
$banned[0]="x.x.x.x";
if (in_array($_SERVER['REMOTE_ADDR'],$banned))
{
header("HTTP/1.1 403 Forbidden");
exit;
}
?>

<?php
$ipArray = file('ip.txt');
foreach ($ipArray as $ipTest) {
  if (substr_count($_SERVER['REMOTE_ADDR'],trim($ipTest)) != "0") { 
    header('location: /banned.htm');  // the banned display page
    die();
  }
}
?> 

<?
$targetAddr = "123.123..*..*";  //yes is two dots
 
//this code will match any class of 123.123.x.x,
//you can also do "123.123.123..*" to do anything that is 123.123.123.x
 
if (ereg($targetAddr, $_SERVER['REMOTE_ADDR'])) {
    //remote address match, do something or don't do anything
} else {
   //do whatever you want to address that doesn't match
}
?>

<?php
 
$ip = $_SERVER['REMOTE_ADDR'];
$ips_baneadas = array('10.0.0.1',’192.0.0.1’);
$contador = count($ips_baneadas);
 
 
for ($i=0; $i<$contador; $i++) {
if($ip == $ips_baneadas[$i]) { die("Tu Ip no esta permitida . $ip" ; } }
 
 
 ?> 

<?php
$count_blocks = 0;
$ip_lines = file("includes/ban.txt");
$count = count($ip_lines);
foreach($ip_lines as $single_line){
 $ip = explode("#", $single_line);
 if($ip[1] == $_SERVER['REMOTE_ADDR']){
      die("Ip baneada.");
 }
}
 ?> 

<?php
$banned_ip = array();
$banned_ip[] = '111.111.111.111';
$banned_ip[] = '111.111.111.112';
$banned_ip[] = '111.111.111.113';
$banned_ip[] = '111.111.111.114';
 
foreach($banned_ip as $banned) {
$ip = $_SERVER['REMOTE_ADDR'];
if($ip == $banned){
echo "You have been banned!";
exit();
}
}
// rest of PHP Script here!
 ?> 

<?php
function ban($range = array(), $ip = '')
{
        $ip = longip(trim($ip));
        if($ip == FALSE)
        {
                return FALSE;
        }
        if(empty($ip))
        {
                return FALSE;
        }
        foreach($range AS $key => $val)
        {
                $temp = explode('-', $val);
                if(empty($temp[0]))
                {
                        return FALSE;
                }
                else
                {
                        $start_ip = longip(trim($temp[0]));
                        if($start_ip == FALSE)
                        {
                                return FALSE;
                        }
                }
                if(empty($temp[1]))
                {
                        if($ip == $start_ip)
                        {
                                return TRUE;
                        }
                }
                else
                {
                        $stop_ip = longip(trim($temp[1]));
                        if($stop_ip == FALSE)
                        {
                                return FALSE;
                        }
                }
                if($start_ip <= $ip && $ip <= $stop_ip)
                {
                        return TRUE;
                }
        }
        return FALSE;
}
function longip($ip)
{
        if(empty($ip))
        {
                return FALSE;
        }
        $block = explode('.', $ip);
        if(count($block) != 4)
        {
                return FALSE;
        }
        $i = 3;
        $block_ip = 0;
        foreach($block as $k => $v)
        {
                $v = filter_var($v, FILTER_VALIDATE_INT);
                if($v < 0)
                {
                        $v = 0;
                }
                if($v > 255)
                {
                        $v = 255;
                }
                $block_ip += pow(256, $i)*$v;
                $i--;
        }
        return $block_ip;
}
 
//usage
$block_range = array(   '192.168.1.0 - 192.168.2.255',
                        '192.168.4.0 - 192.168.4.255',
                        '192.168.6.1'
                );
 
$ip = '192.168.3.255';
 
if(ban($block_range, '192.168.6.1'))
{
        echo "BAN\n";
}
else
{
        echo "UNBAN\n";
}
 
 ?> 

UPDATE smf_topics
SET numViews numViews = + 1
DONDE = ID_TOPIC # # #
LIMIT 1;

/etc/my.cnf

SELECT table_schema, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE engine = 'innodb';

ALTER TABLE tblname
ENGINE=InnoDB;

SELECT CONCAT('ALTER TABLE ',table_schema,'.',TABLE_NAME,' engine=MyISAM;')
FROM information_schema.TABLES
WHERE engine = 'InnoDB';

SELECT CONCAT('ALTER TABLE ',table_schema,'.',TABLE_NAME,' engine=InnoDB;')
FROM information_schema.TABLES
WHERE engine = 'MyISAM';

SELECT CONCAT(ROUND(KBS/POWER(1024,
IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.4999),
SUBSTR(' KMG',IF(PowerOf1024<0,0,
IF(PowerOf1024>3,0,PowerOf1024))+1,1))
recommended_key_buffer_size FROM
(SELECT LEAST(POWER(2,32),KBS1) KBS
FROM (SELECT SUM(index_length) KBS1
FROM information_schema.TABLES
WHERE engine='MyISAM' AND
table_schema NOT IN ('information_schema','mysql')) AA ) A,
(SELECT 2 PowerOf1024) B;
 

find /var/lib/mysql -name '*.MYI'|xargs du -shc

SELECT CONCAT(ROUND(KBS/POWER(1024,
IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.49999),
SUBSTR(' KMG',IF(PowerOf1024<0,0,
IF(PowerOf1024>3,0,PowerOf1024))+1,1)) recommended_innodb_buffer_pool_size
FROM (SELECT SUM(data_length+index_length) KBS FROM information_schema.TABLES
WHERE engine='InnoDB') A,
(SELECT 2 PowerOf1024) B;
 

SELECT SUM(data_length+index_length)/POWER(1024,1) IBPSize_KB
FROM information_schema.TABLES WHERE engine='InnoDB';

SELECT SUM(data_length+index_length)/POWER(1024,2) IBPSize_MB
FROM information_schema.TABLES WHERE engine='InnoDB';

SELECT SUM(data_length+index_length)/POWER(1024,3) IBPSize_GB
FROM information_schema.TABLES WHERE engine='InnoDB';

[youtube=425,350]http://youtu.be/ZcUsR9DSSOk[/youtube]

[youtube=425,350]http://www.youtube.com/watch?v=ZcUsR9DSSOk[/youtube]

$pattern = \'/http:\/\/.+v=(.+)(&.+)*/i\';

$pattern = \'(http(?:s?)://(?:www\.)?youtu(?:be\.com/watch\?v=|\.be/)(\w*)(&(amp;)?[\w\?=]*)?)\';

<object type="application/x-shockwave-flash" width="$2" height="$3" data="http://www.youtube.com/v/$1&ap=%2526fmt%3D18" allowScriptAccess="never"><param name="movie" value="http://www.youtube.com/v/$1&ap=%2526fmt%3D18"></param><param name="wmode" value="transparent"></param></object>

<iframe width="'.$2.'" height="'.$3.'" src="http://www.youtube.com/embed/'.$1.'" frameborder="0"></iframe>

<?php
$iphone = strpos($_SERVER['HTTP_USER_AGENT'],"iPhone");
$android = strpos($_SERVER['HTTP_USER_AGENT'],"Android");
$palmpre = strpos($_SERVER['HTTP_USER_AGENT'],"webOS");
$berry = strpos($_SERVER['HTTP_USER_AGENT'],"BlackBerry");
$ipod = strpos($_SERVER['HTTP_USER_AGENT'],"iPod");
 
if ($iphone || $android || $palmpre || $ipod || $berry == true)
{
header('Location: http://mobile.site.com/');
//OR
echo "<script>window.location='http://mobile.site.com'</script>";
}
?>

$phones = array('iPhone', 'Android', 'BlackBerry');
 
if ( preg_match('/('.implode('|', $phones).')/i', $_SERVER['HTTP_USER_AGENT']) ){
redirect
}
 

$mobile = 'http://mobile.mysite.com/';
 
if ((strstr($_SERVER['HTTP_USER_AGENT'], 'iPhone')) && empty($_COOKIE["mobilesitez"]) && $_SERVER['REQUEST_URI']=="/") {
header("Location: " . $mobile);
}
 
Code added to mobile page:
 
function set_cookie () {
document.cookie = 'mobilesitez=mobilesitez; domain=.mysite.com;';
window.location = 'http://www.mysite.com/'
}
 

<?php
if(strstr($_SERVER['HTTP_USER_AGENT'],'iPhone') || strstr($_SERVER['HTTP_USER_AGENT'],'iPod'))
 {
  header('Location: http://yoursite.com/iphone');
  exit();
}
?>

if( preg_match('/(up.browser|up.link|mmp|symbian|smartphone|midp|wap|webos|galaxy|phone|pocket|psp|treo|android|mobile|240x320|400X240|nitro|nokia|portalmmm|proxinet|blackberry|palm||series40|series60|s60|sonyericsson|e10i|samsung|nexus|htc|desire|ipod|itunes|vodafone|wap-|wapi|wapa|wapp|series40|series60|s60|sonyericsson)/i', $user_agent) ){
	//do something here for all mobile phones
}

$mobile_agents = '!(tablet|pad|mobile|phone|symbian|android|ipod|ios|blackberry|webos)!i';
if(preg_match($mobile_agents, $_SERVER['HTTP_USER_AGENT']))
{
    // Mobile!
}

$mobile = false;
if(isset($_SERVER['HTTP_USER_AGENT']))
{
    $mobile_agents = '!(tablet|pad|mobile|phone|symbian|android|ipod|ios|blackberry|webos)!i';
    if(preg_match($mobile_agents, $_SERVER['HTTP_USER_AGENT']))
    {
        $mobile = true;
    }
}

function ip_is_private($ip)
{
        $pri_addrs = array(
                          '10.0.0.0|10.255.255.255',
                          '172.16.0.0|172.31.255.255',
                          '192.168.0.0|192.168.255.255',
                          '169.254.0.0|169.254.255.255',
                          '127.0.0.0|127.255.255.255'
                         );
 
        $long_ip = ip2long($ip);
        if($long_ip != -1) {
 
            foreach($pri_addrs AS $pri_addr)
            {
                list($start, $end) = explode('|', $pri_addr);
 
                 // IF IS PRIVATE
                 if($long_ip >= ip2long($start) && $long_ip <= ip2long($end))
                 return (TRUE);
            }
    }
 
return (FALSE);
}

if ( ip_is_private ( $ip_address1 ) )
{
    printf ( "%s is from a private address range\n", $ip_address1 );
}

<?php
 function is_private_ip($ip)
{
     return !filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_NO_PRIV_RANGE);
}
?>

if(filter_var($ip, FILTER_FLAG_NO_PRIV_RANGE)) {
  // it's valid
}

if(filter_var($ip, FILTER_FLAG_NO_PRIV_RANGE | FILTER_FLAG_NO_RES_RANGE)) {
  // it's valid
}