Count emails on gmail.com

As the app says they will generate report in which you will see various information about your year using of gmail.com.

I disappointed a bit after i couldn't login into the site on chrome.
And finally it will take up to 72 hours to generate report. So i still didn't got mine yet :)

We’ll scan your emails, and email you a private link when it is ready. Due to the overwhelming demand for these reports, we're advising everyone that it may take up to 72 hours as we get through everyones Emails.

Anyway i think that its cool tool too found out how effective was your gmail account.

Source: https://yearinreview.toutapp.com

htaccess redirect from www to non-www

Code for htaccess to create redirect from site's url with www to site's url without www:

RewriteCond %{HTTP_HOST} ^www\.example\.com [NC] RewriteRule ^(.*)$ http://example.com/$1 [L,R=301]

RewriteCond %{HTTP_HOST} ^www\.(.*)$ [NC] RewriteRule ^(.*)$ http://%1/$1 [R=301,L]

Source: http://stackoverflow.com/questions/234723/generic-htaccess-redirect-www-to-non-www

HTML crossed text

Easiest thing, but i have never used it before.

Today is my first time so i was searching for html tag code which crosses text.

I found it easily. It calls - "line-through". Its an value for text decoration tag.

tag code looks in html like:

text-decoration: line-through;

Example:

Crossed text here

Explode mysql select value

Today i have faced again with same problem - I was forced to explode value while selecting in MySQL.

Value of the field looks like - Kaina: 60000 LT (17376 EUR)
And i need this - 60000

So i made the select query:


SELECT
SUBSTRING( SUBSTRING_INDEX(`field`,' LT',1), -7) as `field_sub`
FROM `table`


As you can notice, first i have exploded the field value so it be like - Kaina: 60000
After i removed first 7 symbols.

Done... i got 60000

GL

Joomla K2 watermark image

We need to edit file - item.php which exists in our administrator folder, full path:
\administrator\components\com_k2\models\item.php

first we need to define the variable:
$img_url_watermark = "../images/watermark.png"; //(line 202)

near the comment line
//Original image

Then we need to paste the lines after each image comment to which we want to add watermark (i recommand not to add to small and xsmall... images )
$handle->image_watermark = $img_url_watermark;
$handle->image_watermark_position = "TL";

Than we need to add the code:
//gallery watermark
if($dir = opendir($savepath.DS.$row->id)) {
while (false !== ($file = readdir($dir))) {
$handle = new Upload ($savepath.DS.$row->id.'/'.$file);
$handle->allowed = array('image/*');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->image_resize = ture;
$handle->image_x = 1024;
$handle->image_ratio_y = true;
$handle->image_watermark = $img_url_watermark;
$handle->image_watermark_position = "TL";
$handle->image_convert = "jpg";
$handle->jpeg_quality = 85;
$handle->Process($savepath.DS.$row->id);
$handle->Clean();
}
closedir($dir);
}
//end

After the code:

if (!JArchive::extract($savepath.DS.$handle->file_dst_name, $savepath.DS.$row->id)) {
$mainframe->redirect('index.php?option=com_k2&view=items', JText::_('Gallery upload error: Cannot extract archive!'), 'error');
} else {
$row->gallery = '{gallery}'.$row->id.'{/gallery}';
}
JFile::delete($savepath.DS.$handle->file_dst_name);
$handle->Clean();

Its about 430~ line

That is all.... done :)

p.s. some sources where the solution was fount

http://api.ning.com/files/HXT6DGp5WSJFHL5RzYp-Jb*WUL4Ep5eAy*opKr8s8KN4pt-DDD92wDPKlmNCmWeQd8msVcosqVIjDLKY3jJ-pZ*6PcJz56pR/diff1.gif
http://api.ning.com/files/*txNFL3oxugapDshDybYqwZ6pM1HRBera8DL7uZp5keDIc40jfg8UZf-SEvT3aVakQ35-yRj-RYTlZXBcGxHOa0R2gQPSkPN/diff2and3.gif
http://api.ning.com/files/2ryzVIrGkDjAz*ZMCXk1aYFdbHTiKTrxNSCfUK97YXCGDhmGv7azhnkMQ1cnJp7EdCivLSbtwdV1HmnwnnjnleMveePM*1LS/diff4.gif
http://community.getk2.org/forum/topics/im-just-trying-to-add-a-png

Mysql Table rows

Easiest way for me to check how many rows in tables of database is to use the query:

SHOW TABLE STATUS FROM `database_name`

easy.. good luck

Skype smiles newest 5.5 icons

 (wfh)
(facepalm)
 (fingers)
(tumbleweed)
 (lalala)
 (waiting)
 (h5) or (highfive)


Also


(devil) - devil
(wtf) - what the fuck

Prestashop CMS block location header

Several days ago i faced with prestashop problem. I tried to hook right column cms block to header. But as prestashop developers says, that it was developed to hook only left or right side.

So here is my solution for this:

in global.css i changed right_column class position to relative and moved it up.

CSS looks like this after my changes:

position: relative;
left: 0px;
top: -200px;
width: 191px;
margin-left: 21px;
overflow: hidden

After this my center_column looked weird ( not full width ) and chaing it's width changes everything ( right_column drops down and starts to move... ). So i figured out this solution for the place: I changed center_column position to absolute, added padding-left so it dont overlay on left_column and added width which i was required from the beggining.

CSS looks like this after my changes:

position: absolute;
padding-left: 290px;
width: 810px;
margin: 0 0 30px 0;
overflow: hidden


Good luck with you prestashop hacking!

Posting code on blogger

I faced again with problem of posting PHP code on blogger. So here is very simple and nice Code converter for posting code on Blogger.
http://francois.schnell.free.fr/tools/BloggerPaste/BloggerPaste.html

Simple Google Weather Unofficial Api

Hey guys. If you are searching for very simple google weather Unofficial api, so here is the code for it.

<?php                   
//Created by Roman Losev 2011
//http://pilotaz.blogspot.com/
//email: pilotaz@gmail.com
//Thanks for feedback.

$url = "http://www.google.com/ig/api?weather=Vilnius+Lithuania&hl=lt";

ini_set("user_agent","Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0) Gecko/20100101 Firefox/6.0"); 
ini_set("content_type","text/xml; charset=\"UTF-8\"");                                      
ini_set("accept_charset","utf-8;q=0.7,*;q=0.7");
ini_set("max_execution_time", 0);
ini_set("memory_limit", "1000M");

$xml = simplexml_load_file($url);   

$image_size = "80";
$count = 0;
echo '<div id="weather" align="center">';
$img = IMG_URL."me/hero_bg.gif";
echo "<table border='0' width='400' style=\"background: url(".$img.") bottom left repeat-x #FFF; border: 1px solid #EEE; padding: 20px\">";
foreach($xml->weather as $item) {  
echo "<tr><td colspan=\"4\" align='center'>Vilniuje šiandien: ".$item->current_conditions->temp_c['data']."° C, ".$item->current_conditions->humidity['data'].", ".$item->current_conditions->wind_condition['data']."</td></tr><tr>"; 
    foreach($item->forecast_conditions as $new) {  
         echo '<td style="padding: 4px;" align="center"><div class="weatherIcon">';
         echo '<img src="http://www.google.com/' . $new->icon['data'] . '"/ width="'.$image_size.'" height="'.$image_size.'" style="border: 1px solid #a1a1a1"><br/>';
         echo $new->day_of_week['data'].": ".$new->low['data']." - ".$new->high['data']."° C";
         echo '</div>';
         echo "</td>";
    }
}
echo "</tr></table>";
echo '</div><br>'; 
?>

[Solution] user agent stylesheet override site stylesheet on Chrome but not Firefox

My problem was this: i wanted to put bold on text which was in select's option by putting style - wont-weight. I had succeed only on Firefox. Because chrome user agent stylesheet were overriding my stylesheet.
I tried to solve the problem for hours. Finally with my friend's help i found the website - electrictoolbox. And it says that only firefox allows to do that... that means we cant use wont-weight on chrome for option, select and optgroup.

My solution was for the bold text changing wont-weight style into color, with dark color for normal text and lighter color for bold required. Also i needed disabling option of bold, so i just added " disabled='disabled' ". That is all..

My result:


a
b


Good luck.

PHP string replace all except numbers and chars

Here is PHP function(code) to remove all but not characters and numbers.

$result= preg_replace("/[^a-zA-Z0-9]+/", "", $text);

p.s. If you are looking to delete everything but numbers, than look here:
http://pilotaz.blogspot.com/2011/05/php-remove-all-characters-and-leave_29.html

PHP multidimensional array check

Today i faced with problem that array had array inside it. It means that the array is multidimensional. So i was forced to recheck the array check with function is_array to new check. Here is the code of check:

function is_multi($a) {
    $rv = array_filter($a,'is_array');
    if(count($rv)>0) return true;
    return false;
}

Source: http://stackoverflow.com/questions/145337/checking-if-array-is-multidimensional-or-not
Big thanks to Vinko Vrsalovic

CSS compressor

Today i have created my own css compressor. I often do css compression, but i always used other sites. So today i created my own and using it! All you need just copy your css code, paste into css code field and press compress. The compressor will compress css code for you. Mostly i get 20% compressed code. Compression can be high and can be low, it all depends on your CSS code writing. The more compressed code you write, the less it will be need to compress.
So now you dont need to write it compressed. Just write as you like and after compress into compact size called "min" aka "mini" ( most of programmers use .min tag for jquery files , like jquery.blabla.min.js )

Screenshot:

Source:
CSS compressor

Create table with auto increament id

i always use sql code to create table with auto increament id, because some times some servers dont allow to do one with auto increament id.

here is a code to do that:

CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=MyISAM;

Ping domain

Have you ever tried to ping any site or domain? The site will allow you to do this - http://www.igloro.info/en/ping.html

Once you are there, just type your desired url or domain name and press Ping.

My outcome:

http://pilotaz.blogspot.com is Alive (76 ms)

RGB test

Have you ever wanted to test how looks one or another rgb hex code? So the page will allow you to do the trick - http://www.igloro.info/en/rgbtest.html .

It is very easy to use. Just enter your desired rgb hex value and press test.

Site description:

RGB test - is a tester which allows you to test how hex color could look.

source: http://www.igloro.info/en/rgbtest.html

My outcome:

RGB: #c0c0c0

Red: 192, Green: 192, Blue: 192

Inverse RGB: #3f3f3f

Red: 63, Green: 63, Blue: 63

Pagerank counter

All websites has their own pagerank. And you can check your website's page rank on various pagerank counter's pages.

One of the pagerank counter pages is: http://www.igloro.info/en/pagerank.html

Description of the page:

Check your site's pagerank here. Igloro pagerank counter is one of methods which calculates and determine what your site's google page rank ( Google PR ) is. Important pages receive a higher PageRank and are more likely to appear at the top of the search results. Google Pagerank is a measure from 0 to 10. Google Pagerank is based on backlinks. More good quality backlinks you have, better for your site. Improving your Google page rank (building quality backlinks) is very important if you want to improve your search engine rankings.

Function of the page is easy.

1. enter website url
2. press check.

My outcome:

http://pilotaz.blogspot.com Page Rank is: 1

2011-06-10: http://pilotaz.blogspot.com Page Rank was: 0 

Md5 generator

Md5 is coding. And most of time it used for mysql database's passwords. After coding password with md5 you will get 25 chars length string.

There are a lot of good md5 generators, example:

http://www.igloro.info/en/md5.html

Sometimes people required to create md5 force way. So just input your password or whatever else string into string field and press genereate md5.

Here is my result for "password" string md5 generation:

md5: 5f4dcc3b5aa765d61d8327deb882cf99

sha1: 5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8

md4: 8a9d093f14f8701df17732b2bb182c74

crc32b: 35c246d5

crc32: bbeda74f

md2: f03881a88c6e39135f0ecc60efd609b9

Web development - seo keywords optimization tools - my new blog

So, few days ago i created my new blog for my new project - igloro.info ( You are all welcome to visit my new blog here: http://seokeywordstools.blogspot.com/ ). I write update's news there and description about all tools we are created.