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.

Seo keywords optimization tools.

Currently working on my own new project. In the project im trying to create tool for monitoring seo keywords of other projects.

I have a lot fun and im trying to use most newest tools to create it. There already is some good tools, like keywords searching, google pagerank counter, urls counter, google analytics monitoring and much much more coming!

Hope to see some testers there and ill would like to hear some suggestions from your side if you are very interested in it.

It is a bit bugged for now but ill fix everything very soon.

Also it will be multi language project. But for beggining there will be only 2 languages - Lithuanian and English.

Source: http://www.igloro.info

Optimize your website

At work as programmer i need to optimize page load time.

So here is some tweaks which you can use for your own web sites.

1. Optimizing your CSS and JS ( Javascript, Jquery and so on... ).
All pages uses css and js. Most of time they are huge. like 50-500 kb for css and same for JS.

Most of time i use the tool to see how fast my page is loading:

http://tools.pingdom.com

Best way to optimize CSS is:
Explode CSS files by parts and use only required ones for pages you are using. After compress it with such tools as http://www.cssdrive.com/index.php/main/csscompressor. And in same time combine these ones together into one single load ( search google for CSS.php combiner ).


Best way to optimize JS is:
Explode by files and use only required code you are using. Compress these files with tools like this: http://www.compress-javascript.com/ ( Some codes don't work after compress, you can try to find another good compressor which will compress better than this one. Let me know if you find anything.. )
In same time combine them with combiners into one file. ( search google for JS.php combiner ).

2. Cache! Best way to optimize website is to use cache.
There also some good tweaks about cache. For example using GZIP cache.
Most of time gzip compressed code with 80% success. For example if you code is 100kb, gzip will compress into 20kb and load it into user browser.
To check gzip compression im using such tools as this one: http://www.whatsmyip.org/http_compression/

3. Images! Less images - better. But as you know, logos and so on.. are important for web sites.
Big web sites as facebook using very nice technique - one big image with all images: http://static.ak.fbcdn.net/rsrc.php/v1/zi/r/uVYVvAILt0K.png

4. HTML, PHP code optimization gives some results too. Spaces, tabs, else { } and so on are pretty good on lowering some kbs...
but each kb less will be some gigabytes less for server load per day-week-month if your web site is big!.

5. Javascript lazyloading - it is very nice tool for loading images. It will load image only if user sees the image. If the image is not in visible spot, it will not be loaded.
Source: http://www.appelsiini.net/projects/lazyload

And remember, that visitor is important of all web sites!