King Php

When I install Version 4.1.2, the following errors come out:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/cpgtxos/public_html/forums.glassesadvisor.com/includes/class_core.php on line 414

Warning: Cannot modify header information – headers already sent by (output started at /home/cpgtxos/public_html/forums.glassesadvisor.com/includes/class_core.php:414) in /home/cpgtxos/public_html/forums.glassesadvisor.com/install/includes/class_upgrade_ajax.php on line 731 Continue reading “Vbulletin Version 4.1.2 Installation Errors”

MySQL binaries should be under your XAMPP folder. Look for a /bin folder, and you’ll find the mysql.exe client around. Let’s assume it is in e:\xampp\mysql\bin, then you should fireup a command prompt in this folder.

First, go to e:\xampp, and run xampp_start. If you do not run xampp_start first, the error message “Can’t connect to Mysql server on ‘localhost’” will occur when you go to step 2.

Afer you run the commend prompt of DOS, then enter:

cd d:\xampp\mysql\bin
mysql.exe -u root –password

Enter password:
and enter root password

mysql>

After log into your mysql server, and start typing your commands.
Type “quit”  or “exit” to exit mysql
Continue reading “How to Access MySQL Command Line in XAMPP?”

If you want to have very strong password to protect your account, here is the code for :

<code>
<?php
 
function generatePassword($length=9, $strength=0) {
    $vowels = ‘aeuy’;
    $consonants = ‘bdghjmnpqrstvz’;
    if ($strength & 1) {
        $consonants .= ‘BDGHJLMNPQRSTVWXZ’;
    }
    if ($strength & 2) {
        $vowels .= “AEUY”;
    }
    if ($strength & 4) {
        $consonants .= ’23456789′;
    }
    if ($strength & {
        $consonants .= ‘@#$%’;
    }
 
    $password = ”;
    $alt = time() % 2;
    for ($i = 0; $i < $length; $i++) {
        if ($alt == 1) {
            $password .= $consonants[(rand() % strlen($consonants))];
            $alt = 0;
        } else {
            $password .= $vowels[(rand() % strlen($vowels))];
            $alt = 1;
        }
    }
    return $password;
}
 
?>
</code>

Sometimes we want to change vbulleting forum domain name, here are some tips on how to do:

1. Before you change your old domain name to your new domain name, login into you cpanel, go to vBulletin Options, Choose Site Name / URL / Contact Details, and change your Forum URL to your new forum url, that is to say, your new domains.

2. Copy all file under your old web host to your new web host.

 3. Back up your old database and import to your new forum database. Continue reading “How to chang Vbulleting Domain Name?”

Sometimes, you might want to get the current page URL that is shown in the browser URL window. For example if you want to let your visitors submit a blog post to Digg you need to get that same exact URL. There are plenty of other reasons as well. Here is how you can do that. Continue reading “How to Get the Current Page URL”

First build a database table:

CREATE TABLE `su_lockip` (
  `id` int(4) NOT NULL auto_increment,
  `lockip` varchar(1024) default NULL,
  PRIMARY KEY  (`id`)
) 

Second, design a page so that you can add the ip you want to ban, every ip is devided by |,  I only write the mail part:
 

$UlockIp=$_POST['z']?$_POST['z']:”;
 if(empty($UlockIp)){
  exit(“<script>alert(‘Sorry, the message your input is wrong!’);history.back();</script>”);
 }
 $sql=”update su_lockip set lockip=’$UlockIp’”;
 if(mysql_query($sql)){
  exit(“<script>alert(‘Locked succesfully!’);history.back();</script>”);
 }else{
  exit(“<script>alert(‘Sorry, the message your input is wrong!’);history.back();</script>”);
 } 

Last, check the ip is in the database or not, if in the database, then show killed.

function lock_user_ip(){
 $Usql =mysql_query(“select * from su_lockip”);
 $Urs =mysql_fetch_array($Usql);
 $UlockIp=$Urs['lockip'];
 $ClockIp=$this->get_real_ip();
 $Iplist =explode(‘|’,$UlockIp);
 if(in_array($ClockIp,$Iplist)){
  exit(‘sorry system lock your IP’);
 }
 }
 
 function get_real_ip(){
   $ip=false;
   if(!empty($_SERVER["HTTP_CLIENT_IP"])){
    $ip = $_SERVER["HTTP_CLIENT_IP"];
   }
   if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
    $ips = explode (“, “, $_SERVER['HTTP_X_FORWARDED_FOR']);
    if ($ip) { array_unshift($ips, $ip); $ip = FALSE; }
    for ($i = 0; $i < count($ips); $i++) {
     if (!eregi (“^(10|172\.16|192\.168)\.”, $ips[$i])) {
      $ip = $ips[$i];
      break;
     }
    }
   }
   return ($ip ? $ip : $_SERVER['REMOTE_ADDR']);
 } 

The problem: we have an array of items in PHP and we want to find out if a specific item is in the array. In code we can define the array as:
Continue reading “Finding Items in an Array or not with PHP”

$dirname=”E:/zhanzhongjie/chengbiao-com/chengbiao-com”;
$dir_handle=opendir($dirname);
while($file=readdir($dir_handle)) Continue reading “How to show all files in a document?”

To be able to use php code on a page with an extension other than .php, you need a server which supports .htaccess files.
To add an extension to be parsed for php, create or edit a file called .htaccess (with the dot first) containing the following line: Continue reading “How to insert PHP code into HTML?”

Description
int fwrite ( resource $handle , string $string [, int $length ] )
fwrite() writes the contents of string to the file stream pointed to by handle . Continue reading “fwrite() example”