Usage:

Edit your commmon.php find the function isInSpamList

And replace the whole function with this code (there’s more than 1 function be aware)

////////////////////////////////////////////////////////////
function get_tag($tag,$xml){
	preg_match_all('/<'.$tag.'>(.*)<\/'.$tag.'>$/imU',$xml,$match);
	return $match[1];
}
 
function valid_ip($ip){
	return ( ! preg_match( "/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/", $ip)) ? FALSE : TRUE;
}
 
function geoIP($stringIp=-1){
 
    if (!valid_ip($stringIp)) $stringIp = $_SERVER['REMOTE_ADDR'];
 
    if ($_COOKIE['geoip']){
        $geoip=unserialize($_COOKIE['geoip']);        
        if ($geoip['ip']==$stringIp) return $geoip;//only return if IP is the same if not continue
	}
 
	$url='http://api.hostip.info/?ip='.$stringIp;// Making an API call to Hostip:
	$xml = file_get_contents($url);//echo $url;
 
	$city = get_tag('gml:name',$xml);
	$city = strtolower ($city[1]);
 
	$countryName = get_tag('countryName',$xml);
	$countryName = strtolower ($countryName[0]);
 
	$countryAbbrev = get_tag('countryAbbrev',$xml);
	$countryAbbrev = strtolower ($countryAbbrev[0]);
 
	$geoip['ip']=$stringIp;
	$geoip['city']=$city;
	$geoip['country']=$countryName;
	$geoip['countryAb']=$countryAbbrev;
 
	setcookie('geoip',serialize($geoip), time()+60*60*24*15);// Setting a cookie with the data, which is set to expire in half month:
	return $geoip;
}
 
function isInSpamList($ip){//return is was taged as spam (in /manage is where we tag)
	global $ocdb;
	$res=$ocdb->getValue("SELECT idPost FROM ".TABLE_PREFIX."posts p where isAvailable=2  and ip='$ip' LIMIT 1","none");
	if ($res==false){
	    $geoip=geoIP();
	    if ($geoip['country']=='india' || $geoip['country']=='(unknown country?)')  return true;//ohohoho SPAMMER! from india
	    else return false;//nothing found
	}
	else  return true;//ohohoho SPAMMER!
 
}

This will make everything a bit slower but works fine to me.

Thinking about to add it in newer versions….with config in the admin of course.

Edit the files:

/content/item-new.php
/content/item-manage.php

Search for:

$query="SELECT idCategory,name,(select name from ".TABLE_PREFIX."categories where idCategory=C.idCategoryParent) FROM ".TABLE_PREFIX."categories C order by idCategoryParent, `order`";

Replace in both files for:

$query="SELECT idCategory,name,(select name from ".TABLE_PREFIX."categories where idCategory=C.idCategoryParent) 
	FROM ".TABLE_PREFIX."categories C where C.idCategoryParent!=0 order by idCategoryParent, `order`";

Uses size + 64bit chksum of the first and last 64k (even if they overlap because the file is smaller than 128k)

Usage:

echo OpenSubtitlesHash("/home/chema/Desktop/Monty Pythons Life of Brian.avi");

Code:

function OpenSubtitlesHash($file)
{
    $handle = fopen($file, "rb");
    $fsize = filesize($file);
 
    $hash = array(3 => 0, 
                  2 => 0, 
                  1 => ($fsize >> 16) & 0xFFFF, 
                  0 => $fsize & 0xFFFF);
 
    for ($i = 0; $i < 8192; $i++)
    {
        $tmp = ReadUINT64($handle);
        $hash = AddUINT64($hash, $tmp);
    }
 
    $offset = $fsize - 65536;
    fseek($handle, $offset > 0 ? $offset : 0, SEEK_SET);
 
    for ($i = 0; $i < 8192; $i++)
    {
        $tmp = ReadUINT64($handle);
        $hash = AddUINT64($hash, $tmp);         
    }
 
    fclose($handle);
        return UINT64FormatHex($hash);
}
 
function ReadUINT64($handle)
{
    $u = unpack("va/vb/vc/vd", fread($handle, 8));
    return array(0 => $u["a"], 1 => $u["b"], 2 => $u["c"], 3 => $u["d"]);
}
 
function AddUINT64($a, $b)
{
    $o = array(0 => 0, 1 => 0, 2 => 0, 3 => 0);
 
    $carry = 0;
    for ($i = 0; $i < 4; $i++) 
    {
        if (($a[$i] + $b[$i] + $carry) > 0xffff ) 
        {
            $o[$i] += ($a[$i] + $b[$i] + $carry) & 0xffff;
            $carry = 1;
        }
        else 
        {
            $o[$i] += ($a[$i] + $b[$i] + $carry);
            $carry = 0;
        }
    }
 
    return $o;   
}
 
function UINT64FormatHex($n)
{   
    return sprintf("%04x%04x%04x%04x", $n[3], $n[2], $n[1], $n[0]);
}

source

We just found an important issue in the software that can be dangerous if somebody finds out how to take advantage of it.

Also I added all the language files (because of that the download file now is bigger) and there’s a temporary fix for an issue related with the dates in case you want to change the dates format.

Please download ASAP the latest version of the software 1.7.0.2

DOWNLOAD Open Classifieds 1.7.0.2

How to upgrade from 1.7.0.x to 1.7.0.2:

• Make backups for everything (DB and files)
• Donwnload the latest version 1.7.0.2
• Unpack
• Copy files *.php files from folder /includes/ exception of  config.php
• Replace new files with old ones, be aware don’t replace config.php
• Finally replace folder /admin/ with the latest downloaded files
• Test your system everything should be fine

How to do a new install:

• Download
• Unpack
• Run the installation in http://yourdomain.com/install/
• Follow the steps
• Working!

Please anything, any problem we are in the forum for you.

Regards

This project is Ocaku, that was presented to the jury of the master 1 week a go. I’ve got an score of 9 over 10 possible points, not bad at all :D

Now I need to promote my work and I will love any kind of help spreading it ;)

What is Ocaku?

Ocaku.com is the finest community for classifieds sites all over the world.

With the union of all this pages we have a great multi lingual search engine that allows us to search everywhere in the world.

Ocaku is free of charge to use and will try to survive using advertisements, do not hesitate to contact us to advertise in our pages.

API for usage of Ocaku in your site.

Presentation (spanish sorry):

We have many downloads, load of work to do, support to offer to you and others and that’s not possible since we don’t get any benefit from the software.

I started this just as an small script and I decided to release it under GPL, I never expected to grow this much.

The problem is that I’m spending many hours in this project and I can’t. I need money to make a living like anyone else. Donations and services are not enough, currently we work on this 3 persons, being me the one who spends the most time in this.

So I don’t want to have 2 different software (1 GPL and other with extra stuff private), I really believe in Open Source and I think that from the services should be enough, but is not.

For me the solution seems to be offering a professional edition that’s not more than few services wrapped in a better price.

Open Classifieds Professional Edition

• Software installation
• 1 year Premium support (direct support from email)
• read more

Promotion 40€

This is the last chance to make Open Classifieds work as a business, if doesn’t succeed I will need to stop working as I am doing right now. Is sad but is just like this, I will stop the support and the development for next releases and I will just fix bugs. Hope is not like this, I’m just being realistic :(

source open classifieds

I use this actually to stop spammers from certain countries…I know a bit to radical, but after using IP (of banned lists), captchas, akismet, banned names etc…I don’t know what else to do :S. (it seems is already working no spam in 1 week)

Usage:

$geoip=geoIP('81.60.189.183');//using an existing IP
$geoip=geoIP();//will use clients IP
 
print_r($geoip);
 
echo $geoip['country'];
echo $geoip['countryAb'];
echo $geoip['city'];
 
 if ($geoip['country']=='india')  die('country not allowed');//to ban a country

The code:

function get_tag($tag,$xml){
	preg_match_all('/<'.$tag.'>(.*)<\/'.$tag.'>$/imU',$xml,$match);
	return $match[1];
}
 
function valid_ip($ip){
	return ( ! preg_match( "/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/", $ip)) ? FALSE : TRUE;
}
 
function geoIP($stringIp=-1){
 
    if (!valid_ip($stringIp)) $stringIp = $_SERVER['REMOTE_ADDR'];
 
    if ($_COOKIE['geoip']){
        $geoip=unserialize($_COOKIE['geoip']);        
        if ($geoip['ip']==$stringIp) return $geoip;//only return if IP is the same if not continue
    }
 
	$url='http://api.hostip.info/?ip='.$stringIp;// Making an API call to Hostip:
	$xml = file_get_contents($url);//echo $url;
 
	$city = get_tag('gml:name',$xml);
	$city = strtolower ($city[1]);
 
	$countryName = get_tag('countryName',$xml);
	$countryName = strtolower ($countryName[0]);
 
	$countryAbbrev = get_tag('countryAbbrev',$xml);
	$countryAbbrev = strtolower ($countryAbbrev[0]);
 
	$geoip['ip']=$stringIp;
	$geoip['city']=$city;
	$geoip['country']=$countryName;
	$geoip['countryAb']=$countryAbbrev;
 
	setcookie('geoip',serialize($geoip), time()+60*60*24*14);// Setting a cookie with the data, which is set to expire in 2 weeks:
	return $geoip;
}

After more than2 month of hard work done by Chema, Arnaldo and Oliver (soon I will introduce the new team) we are glad to release today Open Classifieds 1.7.

There’s many new things that I’m sure you will love:

• Changed default theme to wpClassifieds
• Modified install database script to add locations support
• Added support for custom SMTP host configuration
• Added new admin section to manage locations
• Added new sidebar function to show location links (locations)
• Changed way the images are stored, also deleted table images.
• Added Site Stats in admin
• Added expire headers for better cache
• Now prices allows float numbers
• No hacker defense in admin
• Account management, create new users account to post!
• Email templates
• Improved installer step by step.
• New look for Admin and installer.
• Advertisement setting for AdSense in admin.
• Among others

Download

How to install

• Download
• Unpack
• Run the installation in http://yourdomain.com/install/
• Follow the steps
• Working!

How to upgrade

• Make backups for everything
• Do same as install
• Then run http://yourdomain.com/install/upgrade.php
• Check your site ;)

Please any doubt use the forum for this release.

We are working in the documentation, new screenshots, etc…

For the translations please read this.

Enjoy ;)

source open classifieds blog

Because of that here you have the Open Classifieds 1.7. Release Candidate 2, which is going to be the latest RC.

Next week 1.7.0. will be officially released.

Download now Open Classifieds 1.7. RC 2

How to install

• Download
• Unpack
• Run the installation in http://yourdomain.com/install/
• Follow the steps
• Test!

How to upgrade

• Make backups for everything
• Erase all your content except for the folder /images/
• Do same as install
• Then run http://yourdomain.com/install/upgrade.php
• Hope everything goes well ;)

Please don’t use yet this software in production environments.

Use the forum for 1.7. RC 2 for any doubts of bug hunting.

We need also to re do almost all the open-classifieds.com page, updating all the content to fit 1.7. documentation etc…

source Open Classifieds blog

Finally!

After 2 month of hard work done by Chema, Arnaldo and Oliver (soon I will introduce the new team) we are glad to release today the first release candidate for Open Classifieds 1.7.

There’s many new things that I’m sure you will love:

• Changed default theme to wpClassifieds
• Modified install database script to add locations support
• Added support for custom SMTP host configuration
• Added new admin section to manage locations
• Added new sidebar function to show location links (locations)
• Changed way the images are stored, also deleted table images.
• Added Site Stats in admin
• Added expire headers for better cache
• Now prices allows float numbers
• No hacker defense in admin
• Account management, create new users account to post!
• Email templates
• Improved installer step by step.
• New look for Admin and installer.
• Advertisement setting for AdSense in admin.
• Among others

Not for production environments!!

Test it please, and bring us feedback in the specific forum for this release.

Download

How to install

• Download
• Unpack
• Run the installation in http://yourdomain.com/install/
• Follow the steps
• Test!

How to upgrade

• Make backups for everything
• Do same as install
• Then run http://yourdomain.com/install/upgrade.php
• Hope everything goes well ;)

I rewrited the function and now looks like this, the hacker defense for php:

function hackerDefense(){
	// begin hacker defense
	$notAllowedExp = array(	
			'/<[^>]*script.*\"?[^>]*>/','/<[^>]*style.*\"?[^>]*>/',
			'/<[^>]*object.*\"?[^>]*>/','/<[^>]*iframe.*\"?[^>]*>/',
			'/<[^>]*applet.*\"?[^>]*>/','/<[^>]*window.*\"?[^>]*>/',
			'/<[^>]*docuemnt.*\"?[^>]*>/','/<[^>]*cookie.*\"?[^>]*>/',
			'/<[^>]*meta.*\"?[^>]*>/','/<[^>]*alert.*\"?[^>]*>/',
			'/<[^>]*form.*\"?[^>]*>/','/<[^>]*php.*\"?[^>]*>/','/<[^>]*img.*\"?[^>]*>/'
			);//not allowed in the system
 
	foreach ($_POST as $postvalue) {	//checking posts				
		foreach ($notAllowedExp as $exp){ //checking there's no matches
			if ( preg_match($exp, $postvalue) ) die ("Code not allowed");//die!!!
		}
	}
	// end hacker defense 	
}

HTML:

<input type="text" name="s" id="s" value="" onkeyup="showSugestions();" />
<div id="livesearch"></div>

JavaScript:

function ajax(id,page){//loads using ajax
 
	if (window.XMLHttpRequest) xmlhttp=new XMLHttpRequest();// code for IE7+, Firefox, Chrome, Opera, Safari
	else xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");// code for IE6, IE5
 
	xmlhttp.onreadystatechange=function(){
	  	if (xmlhttp.readyState==4 && xmlhttp.status==200){
	  		document.getElementById(id).innerHTML=xmlhttp.responseText;
	  	}
	}
 
	xmlhttp.open("GET",page,true);
	xmlhttp.send();
}
 
function showResult(){//used in the search box
	str=document.getElementById("s").value;
	if (str.length==0){ 
	  document.getElementById("livesearch").innerHTML="";
	  document.getElementById("livesearch").style.border="0px";
	  return;
	}
	ajax("livesearch","/livesearch.php?q="+str);
	if (document.getElementById("livesearch").innerHTML!="") document.getElementById("livesearch").style.border="1px solid #A5ACB2";
}
 
var timeout;
function showSugestions(){
	clearTimeout(timeout);
	timeout=setTimeout("showResult()",500);
}

PHP:
This is just an example now returns the same string, you should add here you sql or xml etc…

//get the q parameter from URL
$q=$_GET["q"];//echo $q;
 
//lookup all links from the sql if length of q>0
if (strlen($q)>0 && strlen($q)<245){
//here the code to return
   $hint.=$q;
}
 
//output the response
echo $hint;

Imagine how many less request you will have since the browser have that info already cached!

How to do it in PHP, just put this code at the top of your code, before anything it’s output.

$expire=60*60*24*1;// seconds, minutes, hours, days
header('Pragma: public');
header('Cache-Control: maxage='.$expire);
header('Expires: ' . gmdate('D, d M Y H:i:s', time()+$expire) . ' GMT');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');

Just be aware of the time you put, if your site needs to have the latest fresh news it may be not be agood Idea to use more than few minutes expire.

This will be implemented int he new version of Open Classifieds ;), 1.7. coming soon….

Source: php.net

The thing is that I use my own framework to develop PHP, but what is a framework exactly? when is a framework or just a set of utils?

My point is that I don’t like frameworks such as Zend or others that are heavy, loaded with stuff I will never use, of course this can be great for backends where there’s lack of performance since there’s not many users…I’m talking about the scenario of front end.

In front end architecture the king is the MVC design pattern. Why not just create a bunch of utilities to have an easy fast MVC and then add the classes or functions that you need?

For this things can be great any of this solutions:

Fat Free: Light MVC framework with many extra functionality in just few KB, take a look, really good documentation. Just I don’t like too much the templating feature since PHP it’s actually a template engine it self, don’t forget that…

Miminal PHP MVC: I think the name it’s enough to know what’s about. This is more or less what I’m using with more functionality that I use in my projects, but the concept it self is great, MINIMAL.

The no-framework PHP MVC framework: This is more an article written by Rasmus Lerdorf (creator of PHP) regarding frameworks. Really interesting reading.

I still don’t have my framework clean enough to make it public but I just would like to share something really simple but at the same time really useful as it is the folder structure for my projects:

/Root - nothing here is public to the web users
/cache  - for cached files if I don use something as APC or Xcache
/core - Here they go the includes of the application and external classes, aldo the main controller of the APP.
/locale - Localization goes here
/models - models for the APP classes
/public  - here goes the visible part of the web, normally contains just 1 php file and CSS's, images, htaccess. etc.
/templates - PHP files to include as templates for content

It’s pretty simple but just following this you have a clean start and easy to control source, period ;)

Please if you know any other light framework let me know, since I’m building mine from the things I like the most of each of them :P

To fix the Video card:

UPDATE:
Finally something that works good, and official.

wget http://dl.dropbox.com/u/1338581/Gma500/scripts/poulsbo.sh && sh ./poulsbo.sh

Old, not so good:

• Add in /etc/grub.d/40-custom

insmod 915resolution
915resolution 5c 1366 768
set gfxmode=1366x768

• edit /etc/default/grub
• add a line with  ”GRUB_GFXMODE=1366×768″
• update-grub

On next reboot you’ll have 1366×768 resolution in X, even if slow, at least it looks better.

Waiting the driver…..

source ubuntuforums

I use this in PHP:

$key = md5(uniqid(mt_rand(), false));

This should be unique, but can you believe that will never be repeated? I don’t trust it…

Just check it in your DB just in case:

function generateKey(){//Generate a unique key 
    do{
	$key = md5(uniqid(mt_rand(), false));
    }
    while(validateKeyn($key));
 
    return $key;
}
 
function validateKey($key){//check the DB
       $query = "SELECT theKey FROM Table WHERE theKey ='".trim($key)."' LIMIT 1";
       $result=mysql_query($query);
 
	if (mysql_num_rows($result)) return true;
	else return false;
}

Also imagine you need to create a kind of serial number, you can use this interesting function from corner:

// Generate Guid 
function NewGuid() { 
    $s = strtoupper(md5(uniqid(rand(),true))); 
    $guidText = 
        substr($s,0,8) . '-' . 
        substr($s,8,4) . '-' . 
        substr($s,12,4). '-' . 
        substr($s,16,4). '-' . 
        substr($s,20); 
    return $guidText;
}
// End Generate Guid 
$Guid = NewGuid();

This will return something like: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX style unique id, (8 letters)-(4 letters)-(4 letters)-(4 letters)-(12 letters)

Update: I just found that is “a unique” instead of “an unique” xD

Show me the code!

HTML

<div class="OneOfTwo" style="width:60%">
	<div style="float:left;">
		<strong>Left</strong><br />
		<select id="available" size="5" multiple="multiple" style="width: 170px;">
		<option>Left 1</option>
		<option>Left 2</option>
		<option>Left 3</option>
		<option>Left 4</option>
		<option>Left 5</option>
		</select>
	</div>
	<div style="float:left;height:50px;padding-top:25px;">
		<input type="button"  value="&lt;" onclick="swapElement('selected','available')" /><br />
		<input type="button" value="&gt;" onclick="swapElement('available','selected')"  /><br />
	</div>
	<div style="float:left;">
		<strong>Right</strong><br />
		<select id="selected" name="SIDEBAR[]" size="5" multiple="multiple" style="width: 170px;">
		<option>Right 1</option>
		<option>Right 2</option>
		<option>Right 3</option>
		<option>Right 4</option>
		<option>Right 5</option>
		</select>
		<br />
		<input type="button"  value="UP" onclick=" moveUp('selected')" />
		<input type="button"  value="DOWN" onclick="moveDown('selected')" />
	</div>
</div>
<div style="clear:both"></div>

JavaScript

function moveUp(selectId) {
	var selectList = document.getElementById(selectId);
	var selectOptions = selectList.getElementsByTagName('option');
	for (var i = 1; i < selectOptions.length; i++) {
		var opt = selectOptions[i];
		if (opt.selected) {
			selectList.removeChild(opt);
			selectList.insertBefore(opt, selectOptions[i - 1]);
		}
       }
}
 
function moveDown(selectId) {
	var selectList = document.getElementById(selectId);
	var selectOptions = selectList.getElementsByTagName('option');
	for (var i = selectOptions.length - 2; i >= 0; i--) {
		var opt = selectOptions[i];
		if (opt.selected) {
		   var nextOpt = selectOptions[i + 1];
		   opt = selectList.removeChild(opt);
		   nextOpt = selectList.replaceChild(opt, nextOpt);
		   selectList.insertBefore(nextOpt, opt);
		}
       }
}
function swapElement(fromList,toList){
    var selectOptions = document.getElementById(fromList);
    for (var i = 0; i < selectOptions.length; i++) {
        var opt = selectOptions[i];
        if (opt.selected) {
            document.getElementById(fromList).removeChild(opt);
            document.getElementById(toList).appendChild(opt);
            i--;
        }
    }
}
function selectAllOptions(selStr)
{
    var selObj = document.getElementById(selStr);
    for (var i=0; i<selObj.options.length; i++) {
        selObj.options[i].selected = true;
    }
}

How to catch everything in PHP, using a form:

First in the form we need to select all the elements of the input before sending:

inside here the selects

To catch it in PHP:

 $_POST["SIDEBAR"]=implode(",",$_POST["SIDEBAR"]);

Now you have in $_POST["SIDEBAR"] all the elements separated by coma, remember that you receive an Array.

Source from different places I , II

I have tried different ways with sockets, header and curl in order to know which one is the fastest option.

Tested code done to the site yahoo.com (10 attempts each and we keep best result as time):

Sockets + Header:

$url = @parse_url($url); 
if (!$url) return false; 
 
$url = array_map('trim', $url); 
$url['port'] = (!isset($url['port'])) ? 80 : (int)$url['port']; 
 
$path = (isset($url['path'])) ? $url['path'] : '/'; 
$path .= (isset($url['query'])) ? "?$url[query]" : ''; 
 
if (isset($url['host']) && $url['host'] != gethostbyname($url['host'])) { 
 
     $fp = fsockopen($url['host'], $url['port'], $errno, $errstr, 30); 
 
      if (!$fp) return false; //socket not opened
 
        fputs($fp, "HEAD $path HTTP/1.1\r\nHost: $url[host]\r\n\r\n"); //socket opened
        $headers = fread($fp, 4096); 
        fclose($fp); 
 
	 if(preg_match('#^HTTP/.*\s+[(200|301|302)]+\s#i', $headers)){//matching header
	       return true; 
	 } 
	 else return false;
 
 } // if parse url
 else return false;

Time: 0.222 seconds, never more than 0.225s

Curl:

$resURL = curl_init(); 
curl_setopt($resURL, CURLOPT_URL, $url); 
curl_setopt($resURL, CURLOPT_BINARYTRANSFER, 1); 
curl_setopt($resURL, CURLOPT_HEADERFUNCTION, 'curlHeaderCallback'); 
curl_setopt($resURL, CURLOPT_FAILONERROR, 1); 
curl_exec ($resURL); 
$intReturnCode = curl_getinfo($resURL, CURLINFO_HTTP_CODE); 
curl_close ($resURL); 
if ($intReturnCode != 200 && $intReturnCode != 302 && $intReturnCode != 304) { 
    return false;
}
else return true;

Time: 0.224 seconds, few times reached 0.227

Headers:

@$headers = get_headers($url); 
if (preg_match('/^HTTP\/\d\.\d\s+(200|301|302)/', $headers[0])){
   return true; 
}
else return false;

Time: 0.891 seconds, few times more than 1.5s

As you can see for me the fastest way is Socket + Header, even though Curl is pretty fast!

Also note, that I didn’t use other systems such as fopen or file_get_contents since we don’t need to retrieve the page, and what we need is just the header.

Extra, check url correct formation:

function isURL($url){
	$pattern='|^http(s)?://[a-z0-9-]+(.[a-z0-9-]+)*(:[0-9]+)?(/.*)?$|i';
	if(preg_match($pattern, $url) > 0) return true;
	else return false;
}

find . -name '.svn' -type d | xargs rm -rf

This searches for all directories which have svn related files. This is a useful command, but might not work as expected if there are hundreds of thousands files on the server. In this case the following command may be useful:

find . -name .svn -prune -exec rm -rf {} \;

Source devarticles.in

It currently works for MySam working as follows:

• If the table has deleted or split rows, repair the table.
• If the index pages are not sorted, sort them.
• If the table’s statistics are not up to date, update them.

And for InnoDB, rebuilds the table to update index statistics and free unused space.

And if we want to do this in PHP for all the tables in your DB simply do this:

    $result  = mysql_query('SHOW TABLE STATUS FROM '. DB_NAME); 
    while ($row = mysql_fetch_array($result)) $tables[]=$row[0];  
    $tables=implode(", ",$tables); 
    mysql_query('OPTIMIZE TABLE '.$tables);
    echo "<h3>Optimized all the tables found in the database: $tables</h3>";

That’s all! simple yet effective ;)

Before I explain more tricks I will like to make a note; I don’t recommend you to change anything from the core of WP. We could make WP much faster by just tweaking a bit the core…but I don’t recommend to you if later you need to upgrade you WP you will lose all that changes!

Then I’m going to focus in tweaking the Theme and usage of some plugins.

• Use less plugins, and remove the tables they are created and no longer are needed
• Get rid off the widget bar and make it static! This will reduce lot of calls to the DB.
• Try to make it everything as static as possible ;)
• Use a CDN, less stress for your server, since will receive less requests. You can use Coral CDN (a bit slow) or Amazon for example.
• Try to use only one CSS and one JS, with w3 total cache this is kind of easy to do.
• Be careful with missing files, if the file doesn’t exist a 404 page returns and needs to be executed :S you can check this here tools.pingdom.com (great tool)
• Erase the comments and use Disqus (export them first, you can use the plugin), this is extremely tweaking, but can be a last solution, I’m not at this point yet but….maybe.
• W3 Total Cache is probably the best cache plugin now a days, give it a try!

And I think that’s all….

This is really handy if you are not using a cache system such as APC or xcache, and you store your cached files in folders.

For this we will use TMPFS

Tmpfs is like a ramdisk, but different. Like a ramdisk, tmpfs can use your RAM, but it can also use your swap devices for storage. And while a traditional ramdisk is a block device and requires a mkfs command of some kind before you can actually use it, tmpfs is a filesystem, not a block device; you just mount it, and it’s there. All in all, this makes tmpfs the niftiest RAM-based filesystem I’ve had the opportunity to meet.

Example to use it in your WordPress:
(check the right paths)

Edit /etc/fstab/ and we add the file system

tmpfs /home/neo22s/wp-content/cache tmpfs defaults,size=2g,noexec,nosuid,uid=648,gid=648,mode=1755 0 0

Add a new line at /etc/rc.local in order to execute it on system start up:

ionice -c3 -n7 nice -n 19 rsync -ahv --stats --delete /_b/tmpfs/cache/ /home/neo22s/wp-content/cache/ 1>/dev/null

New crontab job (using crontab-e), to execute

*/5 * * * * /usr/bin/ionice -c3 -n7 /bin/nice -n 19 /usr/bin/rsync -ah --stats --delete /home/neo22s/wp-content/cache/ /_b/tmpfs/cache/ 1>/dev/null

Done!

Currently I’m not using this method since I have xcache that make my life easier working with w3 total cache plugin, great solution.

Of course you can use TMPFS for many other things, check askapache, where you can find loads of info and examples a great work.

Since then there’s been more than 16.000 downloads and as far as I know few thousands of sites currently using it ;)

I want also to use this post to ask for help.

The growth of downloads and forum posts it’s been increasing considerable. This brings lot of work…

I need help to continue developing and to maintain this soft.

Currently the 2.0 version is not even started due to the lack of help.

Also here there’s a list of things you help with!

• Development
• Design
• Documentation (the FAQs are really old v1.5.4)
• Translate the site to any other language
• Donations to pay hosting!
• And any other kind of help it’s welcome.

UPDATE:

Chi, an Australian friend of mine, did this awesome new design for OC, but needs to be coded to HTML+CSS, after that I can make it work in OC ;)

BTW I’m at the Campus Party Europe, having lot of fun ;)

source open classifieds blog