But today we found a bug, that made display always the mobile theme to the IE browsers….big mistake my apologies.

Also please see that our reaction against a bug (even if it’s not a security one) it’s pretty fast, we want this software to be reliable.

I’ve made just 2 changes more:

V 1.6.2
Bug in themes.php, displayed mobile theme to IE browsers
To install don’t require curl
Compressed pages to browser that support it, using ob_gzhandler

To upgrade from 1.6.1 you can simply dowload 1.6.2 and replace the files themes.php and functions.php from the /includes path

Once more sorry for any inconvenience :(

from Open Classifieds blog

This is the way I do it, checking the extension it’s loaded and that it’s possible to start the encoding:

if (extension_loaded('zlib')) {//check extension is loaded
    if(!ob_start("ob_gzhandler")) ob_start();//start HTML compression, if not normal buffer input mode
}

There’s plenty of new things and improvements, please update to the newest version.

Download Open Classifieds 1.6.1

Release notes:

From open classifieds blog

$file="some_file.jpg";
$ext=end(explode(".", $file);

Other ways:

Substring:

$ext = substr($file, strrpos($file, '.') + 1);

Using path info:

$info = pathinfo($file);
$ext=$info['extenstion'];

function is_bot(){
	$botlist = array("Teoma", "alexa", "froogle", "Gigabot", "inktomi",
	"looksmart", "URL_Spider_SQL", "Firefly", "NationalDirectory",
	"Ask Jeeves", "TECNOSEEK", "InfoSeek", "WebFindBot", "girafabot",
	"crawler", "www.galaxy.com", "Googlebot", "Scooter", "Slurp",
	"msnbot", "appie", "FAST", "WebBug", "Spade", "ZyBorg", "rabaz",
	"Baiduspider", "Feedfetcher-Google", "TechnoratiSnoop", "Rankivabot",
	"Mediapartners-Google", "Sogou web spider", "WebAlta Crawler","TweetmemeBot",
	"Butterfly","Twitturls","Me.dium","Twiceler");
 
	foreach($botlist as $bot){
		if(strpos($_SERVER['HTTP_USER_AGENT'],$bot)!==false)
		return true;	// Is a bot
	}
 
	return false;	// Not a bot
}

There’s any other better way?

Well, there was something missing and I think really important, to ping Google about the changes in the sitemap.

Simplest way of doing this:

file_get_contents('http://www.google.com/webmasters/sitemaps/ping?sitemap=http://yoursite.com/sitemap.xml');

Remember to register your site at Google webmaster tools, since if you don’t will not work.

Of course you will need to ask many things, but before you ask, what about been sure the client match all the software requirements?

Check the PHP version:

$phpversion = substr(PHP_VERSION, 0, 6);
if($phpversion >= 5.2) {
       echo "Right PHP version"; 
}
else{
	echo "No, you can't continue with the installation";
	exit;
}

In this example we require 5.2 at least to continue.

Check extension loaded in PHP:

if (!extension_loaded('curl')){
    echo 'Not found, please proceed to install';
    exit;
}
else echo 'Found';

In this example we check that CURL it’s loaded.

Checking apache module installed:

if (in_array('mod_rewrite',apache_get_modules())) echo 'Found';
else echo 'Not found';

In this example we check that mod_rewrite it’s loaded.

Checking folder permissions:

 if(is_writable('/images')) { 
	echo 'OK - Writable'; 
} 
elseif(!file_exists('/images')) { 
	echo 'File Not Found';
} 
else {
	echo 'Unwritable (check permissions, chmod 755 should fix this)';
	exit;
}

Checking mysql connection:

if (!mysql_connect($_POST["DB_HOST"],$_POST["DB_USER"],$_POST["DB_PASS"])){
	$msg=mysql_error();
	echo 'Mysql error:' .$msg;
	exit;
}
else echo "connected!";

function rssReader($url,$maxItems=15,$begin="",$end=""){
        $rss = simplexml_load_file($url);
        $i=0;
        if($rss){
            $items = $rss->channel->item;
            foreach($items as $item){
                if($i==$maxItems) return $out;
                else $out.=$begin.'<a href="'.$item->link.'" target="_blank" >'.$item->title.'</a>'.$end;
                $i++;
            }
        }
        return $out;
    }

Usage example:

echo '<ul>'.rssReader('http://neo22s.com/feed/',5,'<li>','</li>').'</ul>';

Using cache with the class fileCache:

 function rssReader($url,$maxItems=15,$cache,$begin="",$end=""){
        $cache= (bool) $cache;
        if ($cache){
            $cacheRSS= new fileCache();//seconds and path
            $out = $cacheRSS->cache($url);//getting values from cache
        }else $out=false;
 
        if (!$out) {	//no values in cache
            $rss = simplexml_load_file($url);
            $i=0;
            if($rss){
                $items = $rss->channel->item;
                foreach($items as $item){
                    if($i==$maxItems){
                        if ($cache) $cacheRSS->cache($url,$out);//save cache	
                        return $out; 
                    }
                    else $out.=$begin.'<a href="'.$item->link.'" target="_blank" >'.$item->title.'</a>'.$end;
                    $i++;
                }
            }   		
        }
        return $out;
    }

Usage example RSS with cache:

echo '<ul>'.rssReader('http://neo22s.com/feed/',5,true,'<li>','</li>').'</ul>';

Based on this one from sihan:

 $url = "http://news.google.com/?ned=us&topic=t&output=rss";
    $rss = simplexml_load_file($url);
    if($rss){
        echo '<h1>'.$rss->channel->title.'</h1>';
        echo '<li>'.$rss->channel->pubDate.'</li>';
        $items = $rss->channel->item;
        foreach($items as $item){
            $title = $item->title;
            $link = $item->link;
            $published_on = $item->pubDate;
            $description = $item->description;
            echo '<h3><a href="'.$link.'">'.$title.'</a></h3>';
            echo '<span>('.$published_on.')</span>';
            echo '<p>'.$description.'</p>';
        }
    }

This means your site will return an 500 Error.

After talking to the support for more than 1 hour they admitted they have made changes in the policies and now we should use “Options +SymLinksIfOwnerMatch” instead.

Pretty bad communication from them and making this changes without noticing them.

If you are affected by this issue, please your .htaccess for Open Classifieds should look like this to get to work:

ErrorDocument 404 /
Options +SymLinksIfOwnerMatch
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteBase /
RewriteRule ^category/(.+) index.php?category=$1
RewriteRule ^offer/(.+) index.php?category=$1&type=0
RewriteRule ^need/(.+) index.php?category=$1&type=1
RewriteRule ^type/(.+) index.php?type=$1
RewriteRule ^publish-a-new-ad-for-free/ new/index.php
RewriteRule ^contact/ contact/index.php
RewriteRule ^privacy-policy/ privacy/index.php
RewriteRule ^sitemap/ sitemap/index.php
RewriteRule ^advanced-search/ search/index.php
RewriteRule ^map/ map/index.php
RewriteRule ^(.+)/(.+)/(.+)/(.+)$ item.php?item=$1&type=$2&category=$3&title=$4
</IfModule>

Remember that needs to be in your language.

This would be fixed for Open Classifieds 1.6.1 that is coming soon with few improvements to make your life easier.

I’m getting pretty annoyed by this hosting, since I use a Privvate Server and this things should never happen (as this other one http://j.mp/d8WVXY).

More or support for Open Classifieds in the forum.

I’ve been using WordPress for over 4 years now.  I also have developed some plugins like Twitter Badge, WP-RIR, WP-PageScroll and I wrote few more thinks about it.

We can say that I’m not the average user but neither I’m a PRO developer for WP. The point is that as user I Love WordPress but from other side as technician sometimes I HATE IT.

I had a few discussions with people about the good and the bad things of WP, of course at the end for me it’s positive, but it bothers me that there’s few known issues that they should take care of and they don’t.

Anyway here’s my list with a short description.

The Love

• Easy, yep WP it’s easy and everybody knows how to use it. Great work on it.
• Community, there’s a huge community of developers and designers that releases their work for free making this software good.
• GPL, free software license, what else do you want?
• Custom, it’s pretty easy for any normal user to install plugins, themes…even change them.
• Upgrades and updates, they are automatically making your life easier, same as 1st point.
• WordCamps, this is a great idea I may say and I love it!

The Hate

• Slow, it maybe fast to you, but for me it’s a really heavy application to be a blog software. Without plugins to cache content you can’t run an instance of WP in a shared hosting….
• Data Base, this is terrible, still uses MySam, now many people will say this is an advantage, come on we are in 2010! relational data bases it’s a must have, and what about normalization?
• Download size, now a days this is no trouble, but how can be over 2MB size?
• Bugs, there’s so many WP installations that some people is trying really hard to hack this software and for instance finding bugs. Thankfully we have a great community that seems to work 24/7.
• Plugins, I love the plugins and the work from the community, but you need to be aware what you install in your WP, I know it’s not the fault of WP, but some how as they do with the themes being picky, should be with plugins testing them even just a little bit.

As conclusion I will say that they should focus to improve performance instead of adding features and more and more features….And as I said before WP it’s my favorite blogging and even CMS tool.

Last words: Thanks to the WP team and the community for the work they have done, this is just a constructive opinion meaning the best intentions.

Image from sitepoint.

I started working on 1.6 at the ends of 2009 and before the release of today we had two release candidates: RC 1, RC 2. Also I installed RC 2 successfully  in a few web sites.

In the upcoming dates we will update all the site FAQs but we already have the forum and the demo running.

What’s new
Just a briefing of what’s new:

• Using Db class phpMyDb
• Prefix for DB tables
• Advanced search
• Settings, everything from config.php in a simple form
• Now templates can have their own index (listing) and template for items
• New themes
• New Languages
• Check more in readme.txt

Download 1.6 now!

How to upgrade from previous versions:

• Make a backup of your files and DB, just in case
• Erase the files form your FTP (NOT the folder /images/)
• Upload the new files
• Run http://yoursite.com/install/
• Done

c&p from Open Classifieds blog

What about forcing the user to type a number/letter in the input you want.

With just a bit of JavaScript we can control this what is the user typing int he input.

Allow only numbers:
(also dot and del)

function isNumberKey(evt){
	var charCode = (evt.which) ? evt.which : event.keyCode;
 
	if((charCode==46||charCode==8||charCode==45||charCode==47) ||(charCode >= 48 && charCode <= 57) ){
		return true;
	}
	else {
		return false;
	}		
}

And to use it in a input would be like this for example:

<input id="math"  type="text"  onkeypress="return isNumberKey(event);" />

Try it: How much is 20+10?

Allow only letters:
(also space, del, enter)

function isAlphaKey(evt){
	var charCode = (evt.which) ? evt.which : event.keyCode;
	 if ((charCode==231 || charCode==199) || (charCode==241 || charCode==209) ||(charCode==8 || charCode==32) || ( (charCode >= 65 && charCode <= 90) || (charCode >= 97 && charCode <= 122) ) ) {
	 	return true;
	 }
	 else {
		 return false;
	 }
}

And to use it in a input would be like this for example:

<input id="name" type="text"  onkeypress="return isAlphaKey(event);"  />

Try it: Your name:

I know should be easier, but just wait a bit for HTML 5 that is going to make our life better. For sure ;)

Demo | Download | For Open Classifieds

Since I’m not a web designer, make this templete it’s been a bit difficult for me.

Why I did it then? easy, I want to learn just a bit of CSS, in order of been able to make my own changes also I had an Idea for a template for Open Classifieds but since no one would help me I’ve decided to do it myself.

I will not normally release this short of things.

With Open Classifieds 1.6, that is coming really soon, I hope I will have this template ready by then ;) In the meantime please try 1.6 RC 2.

Few webpages they are not longer supporting ie6 and are recommending to change it, to use other browser. But now the giant the “Big Boss” Google is doing one step further to say bye to IE6.

They sent me this email yesterday that I absolutely aprove!

Dear Google Apps admin,​

In order to continue to improve our products and deliver more sophisticated features and performance, we are harnessing some of the latest improvements in web browser technology. This includes faster JavaScript processing and new standards like HTML5. As a result, over the course of 2010, we will be phasing out support for Microsoft Internet Explorer 6.0 as well as other older browsers that are not supported by their own manufacturers.

We plan to begin phasing out support of these older browsers on the Google Docs suite and the Google Sites editor on March 1, 2010. After that point, certain functionality within these applications may have higher latency and may not work correctly in these older browsers. Later in 2010, we will start to phase out support for these browsers for Google Mail and Google Calendar.

Google Apps will continue to support Internet Explorer 7.0 and above, Firefox 3.0 and above, Google Chrome 4.0 and above, and Safari 3.0 and above.

Starting next week, users on these older browsers will see a message in Google Docs and the Google Sites editor explaining this change and asking them to upgrade their browser. We will also alert you again closer to March 1 to remind you of this change.

In 2009, the Google Apps team delivered more than 100 improvements to enhance your product experience. We are aiming to beat that in 2010 and continue to deliver the best and most innovative collaboration products for businesses.

Thank you for your continued support!

Sincerely,

The Google Apps team

2010 it’s going to be a better world for web developers ;)

With this function you can generate an input select from a given query.

Parameters:
1- Query to be displayed as a select, the query needs to returns at least 2 values, 1st one for the option value, and the 2nd one for the display value.
2-Input Select name, thisw woud be the name that your select will have in the form.
3-Which option it’s selected from the list. I non is set the first one it’s selected.

function sqlOption($sql,$name,$option){//generates a select tag with the values specified on the sql, 2nd parameter name for the combo, , 3rd value selected if there's
	global $ocdb;
	$result =$ocdb->query($sql);//1 value needs to be the ID, second the Name, if there's more doens't work
	$sqloption= "<select name='".$name."' id='".$name."'>
				<option value='0'>Home</option>";
	while ($row=mysql_fetch_assoc($result))
	{
		$first=mysql_field_name($result, 0);
		$second=mysql_field_name($result, 1);
 
			if ($option==$row[$first]) { $sel="selected=selected";}
			$sqloption=$sqloption .  "<option ".$sel." value='".$row[$first]."'>" .$row[$second]. "</option>";
			$sel="";
	}
		$sqloption=$sqloption . "</select>";
		echo $sqloption;
}

Same function but that can group:

Parameters:
1- Query to be displayed as a select, the query needs to returns at least 2 values, 1st one for the option value, the 2nd one for the display value, and 3rd the value we use to group with.
2-Input Select name, thisw woud be the name that your select will have in the form.
3-Which option it’s selected from the list. I non is set the first one it’s selected.

function sqlOptionGroup($sql,$name,$option){//generates a select tag with the values specified on the sql, 2nd parameter name for the combo, , 3rd value selected if there's
	global $ocdb;
	$result =$ocdb->query($sql);//1 value needs to be the ID, second the Name, 3rd is the group
	//echo $sql;
	$sqloption= "<select name='".$name."' id='".$name."' onChange=\"validateNumber(this);\" lang=false ><option></option>";
	$lastLabel = "";
	while ($row=mysql_fetch_assoc($result))
	{
		$first=mysql_field_name($result, 0);
		$second=mysql_field_name($result, 1);
		$third= mysql_field_name($result,2);
 
		if($lastLabel!=$row[$third]){
			if($lastLabel!=""){
				$sqloption.="</optgroup>";
			}
			$sqloption.="<optgroup label='$row[$third]'>";
			$lastLabel = $row[$third];
		}
 
			if ($option==$row[$first]) { $sel="selected=selected";}
			$sqloption=$sqloption .  "<option ".$sel." value='".$row[$first]."'>" .$row[$second]. "</option>";
			$sel="";
	}
		$sqloption.="</optgroup>";
		$sqloption=$sqloption . "</select>";
		echo $sqloption;
}

NOTE: Requires phpMyDB.

function getIp(){//obtain the ip
		// if getenv results in something, proxy detected
		if (getenv('HTTP_X_FORWARDED_FOR')) {
			$ip=getenv('HTTP_X_FORWARDED_FOR');
		}
		else {// otherwise no proxy detected
			$ip=getenv('REMOTE_ADDR');
		}
 
		return $ip;
}

Anyway of doing this better?

Please DOWNLOAD try / test and give me feed back in the forum for this release.

Open Classifieds 1.6 RC2 demo.

New things:

Fixed many bugs.
addthis instead of the older slower service add to any
Now templates can have their own index (listing) and template for items (check theme gallery-blue to see what I mean)
Using j.mp instead of bit.ly to short urls
sort ads by price asc or desc in advanced search
Improved seo now friendly urls for new, contact, sitemap, privacy, advanced search…

Neeed translation for all languages (except english and spanish):

//1.6 new words!
define ("T_SORT","Sort");
define ("T_LINKS","Links");
define ("T_ERROR_CODE","There was a problem with your post. Please do not include code. Go Back");
define ("T_SPAM_CONTACT","Ups! Spam? if you are not spam contact us.");
define ("T_SPAM","Spam");
define ("T_NO_SPAM","NO Spam!");
define ("T_SPAM_REPORTED","Spam reported");
define ("T_PRIVACY_COUNTRY","Spain");
define ("T_MAP","Map");
define ("T_ADV_SEARCH","Advanced search");

Please try and report.

Thanks!

Please DOWNLOAD try / test and give me feed back in the forum for this release.

Open Classifieds 1.6 RC1 demo.

Once more the change log for V 1.6 RC1:

Romanian language thank to tutankanon, russian thanks to levgen, italian thanks to paolo
Now languages are in /languages/
Created include controller that loads the needed data (before was called data.php)
Db class phpMyDb
new cache class integrated with db class
Mark as spam sends to akismet
no install if minimun requirements (PHP > 5 and writable in /includes/)
prefix for db tables (allows you to have more than one install in the same DB)
Adsense deleted, there was problems with google. please donate
Sidebar allows to change theme
config.php define in admin
categories allow duplicates, changes the post slug
advanced search in /search/
fixed few mistakes at sitemap.php

Also it’s important to check all the themes that are included since there’s few changes.

But how to make it work using PHP?

This is the way I do it for Open Classifieds:

First of all I use to defines, for the path of the file, and when it would expire:

define(SITEMAP_FILE,"sitemap.xml.gz");
define(SITEMAP_EXPIRE,3600); //seconds

At the beginning of any of your scripts we check if the sitempa it’s expired, if it’s expired we generate another time the sitemap :

if (time()>(filemtime(SITEMAP_FILE)+SITEMAP_EXPIRE)){
	generateSitemap();// the sitemap is expired then generates it
}

Then I use this function to generate the file, everytime it’s needed.

function generateSitemap(){//generates the sitemap returns the xml
	$file=SITEMAP_FILE;
	$sitemap="<?xml version='1.0' encoding='UTF-8'?>
	<urlset xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'
	xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
	xsi:schemaLocation='http://www.sitemaps.org/schemas/sitemap/0.9
			    http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd'>";
 
//to add url's:
	$sitemap.=makeUrlTag ("http://yoursite.com/rss/","", "hourly", "0.6");
//end adding urls	
 
	$sitemap.="</urlset>";
 
	if (file_exists($file))  unlink ($file);
	$gzdata = gzencode($sitemap, 9);
        $fp = fopen($file, "w");
        fwrite($fp, $gzdata);
        fclose($fp);
 
	return $sitemap;
}

Also we need this functions that I use from smart-it-consulting to make everything work good:

function makeUrlString ($urlString) {
    return htmlentities($urlString, ENT_QUOTES, 'UTF-8');
}
 
function makeIso8601TimeStamp ($dateTime) {
    if (!$dateTime) {
        $dateTime = date('Y-m-d H:i:s');
    }
    if (is_numeric(substr($dateTime, 11, 1))) {
        $isoTS = substr($dateTime, 0, 10) ."T"
                 .substr($dateTime, 11, 8) ."+00:00";
    }
    else {
        $isoTS = substr($dateTime, 0, 10);
    }
    return $isoTS;
}
 
function makeUrlTag ($url, $modifiedDateTime, $changeFrequency, $priority) {
    GLOBAL $newLine;
    GLOBAL $indent;
    GLOBAL $isoLastModifiedSite;
    $urlOpen = "$indent<url>$newLine";
    $urlValue = "";
    $urlClose = "$indent</url>$newLine";
    $locOpen = "$indent$indent<loc>";
    $locValue = "";
    $locClose = "</loc>$newLine";
    $lastmodOpen = "$indent$indent<lastmod>";
    $lastmodValue = "";
    $lastmodClose = "</lastmod>$newLine";
    $changefreqOpen = "$indent$indent<changefreq>";
    $changefreqValue = "";
    $changefreqClose = "</changefreq>$newLine";
    $priorityOpen = "$indent$indent<priority>";
    $priorityValue = "";
    $priorityClose = "</priority>$newLine";
 
    $urlTag = $urlOpen;
    $urlValue     = $locOpen .makeUrlString("$url") .$locClose;
    if ($modifiedDateTime) {
     $urlValue .= $lastmodOpen .makeIso8601TimeStamp($modifiedDateTime) .$lastmodClose;
     if (!$isoLastModifiedSite) { // last modification of web site
         $isoLastModifiedSite = makeIso8601TimeStamp($modifiedDateTime);
     }
    }
    if ($changeFrequency) {
     $urlValue .= $changefreqOpen .$changeFrequency .$changefreqClose;
    }
    if ($priority) {
     $urlValue .= $priorityOpen .$priority .$priorityClose;
    }
    $urlTag .= $urlValue;
    $urlTag .= $urlClose;
    return $urlTag;
}

And that should be all ;)

Now you can submit your sitemap.xml to the google webmaster tools!

UPDATED: Now creates the file with .gz

When I’ve installed 9.04, I had problem with the network (wifi and ethernet drivers), and the display drivers. That was all, the rest was great.

When I did the upgrade, the display once more was not working properly but the worst was the speed connection, awful.

Then I’ve decided to do a fresh clean installation:

1. Download Karmic Koala
2. Make a pen drive bootable with the app in system->administration->Usb Startup Disk Creator
3. Boot you Eeepc form the pendrive (you can find this in the bios F2->Boot)
4. Install Karmic Koala
5. After this almost everything was working fine but the display and still the internet connection

Problems and how I fixed them:

Display resolution:

I found many solutions the easier was this one:
In command shell:

wget http://gma500re.altervista.org/scripts/poulsbo_ppa.sh && sh ./poulsbo_ppa.sh
dpkg-reconfigure psb-kernel-source

Restart and works ;)

Internet connection Speed:

There’s some short of bug that for some weird reason makes your browsing experience really slow. As far as I know (and how I did to solve it) it’s caused by ipv6.

If you use firefox you can use this solution to disable ipv6 only in firefox of course.

Open a firefox browser window and type this in the address bar:

about:config

In the filter bar put:

network.dns.disableIPv6

You will disable the IPv6 DNS if you set the value to true. Once you have done that close Firefox and then reopen a browser a window. Your internet should be fast again!

But I use Chomium!! and skype….then we need to disable the module ipv6 to load on start (boot).

Open a terminal:

gksudo gedit /etc/default/grub

Look for this line and add:

GRUB_CMDLINE_LINUX_DEFAULT="ipv6.disable=1 quiet splash"

Save and close your file then run:

sudo update-grub

That’s all until now…seems everything to work pretty good, just I don’t like from karmic the new Ubuntu Software Center, I liked more the old one…

This year was specially fast at least for me. I did many things, that involves many areas from my life, travelling, studying, developing…

Maybe some of you are interested in what I’ve done this year:

• In February I moved from Holland to Thailand for 5 months.
• In March I started developing Open Classifieds, just for learning.
• I’ve visited Malaysia , Vietnam,Liverpool, …
• In July I moved from Thailand back to my home in Barcelona.
• I have twitter account since July only…
• Since August we have our lovely cat Chang (means elephant in Thai).
• In August I started this blog, with the forum and the lab ;) (Currently I have 300 unique visitors day)
• In September I started English school for first time in my life and it’s in the official school level 4 of 5.
• In October I’ve quited my work and I started a Software Engineering Master.
• I’ve went to the PHP international conference in Barcelona as Speaker.
• I started playing paddle and Ive been defeated twice by my dutch girlfriend :S

Goals 2010:

• Finish my studies successfully.
• Release Open Classifieds 2.0.
• Visit more and more countries!
• Start my own E-business (already working on it).
• Defeat my gf in Paddle, finally.
• Learn to use a PHP Framework (Still don’t know which one).
• Learn to relax and take it easy.
• Driving license for motorbike (now I can only drive 125cc).
• Attend to more conferences, even if I’m not an Speaker.
• Stop smoking (wait I never smoked!!)

BTW, HAPPY NEW YEAR!!!

I’ve wrote this class just few weeks a go since I need it for the new version of Open Classifieds (coming soon I promise, many changes).

This class uses fileCache class to be able (if you want to) to cache the query result in a really simple way (transparent to the programmer).

First Download

Usage with examples:

Constructor:
DB Constructor – connects to the server and selects a database

$ocdb = new phpMyDB(DB_USER, DB_PASS, DB_NAME,DB_HOST,DB_CHARSET);

In case of error will print using the private function print_error

Debugger:
Logs all the connection or action inside the class, you can set it on whenever you want.

$ocdb->setDebug(true);
$ocdb->returnDebug();

We set it on, and at the end of our script(or whenever you want) we should returnDebug, by default in “HTML”, but can return as an “array”.
Also you can add new “logs” with $ocdb->addLog(“any string”);

Activate cache:
Uses fileCache class. As parameter we have:
1: true or false to activate or deactivate the cache, by default false
2: Time in seconds by default 3600 (10 seconds expires in the example)
3: Path for the cache, by default cache/

$ocdb->setCache(true,10);

Normal query:
Just performs a normal query, but keeps the query counter and logs the action if debugger it’s on

$result =$ocdb->query($query);
if (mysql_num_rows($result)){
     while ($row=mysql_fetch_assoc($result)){
          echo 	$row['title'];
     }
}

getRows
Returns in rows the target query. If cache is activated automatically cache the result as an array.
Parameters:
1: Query to return values
2: Returning as “assoc” (default), “row” , “object” ,”value” (returns first field form the query)
3: Cache type “cache” or “APP” by default “cache”
Example: Cached query, returning the row as an object (cache must be activated):

$result=$ocdb->getRows($query,"object");
if ($result){//more than 1 result
	foreach ( $result as $row ){
           echo $row->title;
       }
}

getValue
Get value from first value of the query and stores it in the cache.

$query="SELECT count(*) total FROM oc_postshits";
$total_records = $ocdb->getValue($query,"APP");

In the second parameter we can use “cache” (default).

Insert:
Insert into,parameters:
1: table + fields
2: values

$ocdb->insert("categories (name,friendlyName)","'name','fname'");

To get the last id use $ocdb->getLastID();

Update:
Updates table, parameters:
1: table
2: sets
3: where

$ocdb->update("posts","isAvailable=0,isConfirmed=0","idPost=1 and password='asdsadsad'");

Delete:
Delete from, parameters:
1: table
2: where

$ocdb->delete("categories","idCategory=2");

Close db:
Closes DB connection and unsets variables.

$ocdb->closeDB();

Full example:

include "phpMyDB.php";
 
define('DB_HOST','localhost');
define('DB_USER','user');
define('DB_PASS','some pass');
define('DB_NAME','openclassifieds');
define('DB_CHARSET','utf8');
 
$ocdb = new phpMyDB(DB_USER, DB_PASS, DB_NAME,DB_HOST,DB_CHARSET);
 
$ocdb->setDebug(true);
$ocdb->setCache(true,10);
 
$ocdb->insert("postshits (idPost,ip)","97,'10.0.0.0'");
echo 'test insert see id:' . $ocdb->getLastID();
 
$query="SELECT count(*) total FROM oc_posts";
$total_records = $ocdb->getValue($query,"APP");
echo 'Total records: '.$total_records;
 
$query="SELECT p.title from oc_posts p Limit 3";
$ocdb->setCache(false);//cache deactivated
$result=$ocdb->getRows($query,"object");
$ocdb->setCache(true);//after the query is done activated once more
 
if ($result){//more than 1 result
	foreach ( $result as $row ){
		echo $row['title'];	
	}
}//if count
else echo "nothing found";
 
$ocdb->closeDB();
$ocdb->returnDebug();
 
echo $ocdb->getQueryCounter().' queries generated and '.$ocdb->getQueryCounter("cache").' queries cached';

After trying few solutions (for KDE, gnome ), I finally managed to make it work:

First you need to install Spotify in linux

At the console we create this script:

echo '#!/bin/sh' > ~/.browser2spotify
echo 'wine  "$HOME/.wine/drive_c/Program Files/Spotify/spotify.exe" /uri "$@"' >> ~/.browser2spotify
chmod 755 ~/.browser2spotify

Then we change few options from gnome to know what to do with the url’s:

gconftool-2 -t string -s /desktop/gnome/url-handlers/spotify/command "/home/${USER}/.browser2spotify %s"
gconftool-2 -s /desktop/gnome/url-handlers/spotify/needs_terminal false -t bool
gconftool-2 -s /desktop/gnome/url-handlers/spotify/enabled true -t bool

Remember to replace the user name in the folder.

That’s all!

To see if it works, try to open this any from this list:

Top 100 2009 PlayList

List provided thanks to soyplastic.

Do you remember rir.li this service to prevent you to do image hotlinking?

To make easier the usage of this service, here you have the plugin for WordPress.

Installation:

• Download
• In your WordPress go to admin Dashboard -> Plugins -> Add new->Upload
• Select the downloaded file
• Activate
• Enjoy ;)

Usage:
Once it’s installed, you can use it to copy any images in the service of rir.li like this:

<rir>http://www.turisbot.com/images/maastricht.jpg</rir>

or

[rir]http://www.turisbot.com/images/maastricht.jpg[/rir]