Posts

Showing posts from 2011

Excel disable auto increment in formula by row and column

=CONCATENATE(J29,$H29,"mmm") If you want to copy across, but always refer to H29. =CONCATENATE(J29,H$29,"mmm") If you want to copy down, but always refer to H29. =CONCATENATE(J29,$H$29,"mmm")If you want to copy down and across, but always refer to H29. $h29 -> places dollar before column disables auto increment in column h$29 -> places dollar before row disables auto increment in row $h$29 -> places dollar before row and column disables auto increment in row & column. Was very hard to find out that. src  http://forums.techarena.in/windows-software/1181179.htm

Virtuemart fetchscript off

$_REQUEST['usefetchscript'] = "0"; /administrator/components/com_virtuemart/virtuemart.cfg.php http://www.joomlahackers.net/virtuemart-tutorials/how-to-switch-off-fetchscript-in-virtuemart.html

Enable IP range in IPTABLES

iptables -A INPUT -p tcp --destination-port 22 -m iprange --src-range 192.168.1.100-192.168.1.200 -j ACCEPT http://www.cyberciti.biz/tips/linux-iptables-how-to-specify-a-range-of-ip-addresses-or-ports.html

Clear on mouse click function

http://www.java-scripts.net/javascripts/Clear-Form-Field-Value-on-Click.phtml Clear default form value script- By Ada Shimar (ada@chalktv.com) */ function clearText(thefield){ if (thefield.defaultValue==thefield.value) thefield.value = "" } </script> <form> <input type="text" value="Search this site" onFocus="clearText(this)"> </form>

PHP truncating text function

http://www.the-art-of-web.com/php/truncate/ here is very good and cool function for truncating text. function myTruncate($string, $limit, $break=".", $pad="...") { // return with no change if string is shorter than $limit if( strlen ($string) <= $limit) return $string; // is $break present between $limit and the end of the string? if(false !== ($breakpoint = strpos ($string, $break, $limit))) { if($breakpoint < strlen($string) - 1) { $string = substr ($string, 0, $breakpoint) . $pad; } } return $string; }

Advertising websites

You can Monetize your Gaming website using this Great sites. Will add more later http://www.metanetwork.com/ https://www.cpmstar.com/ http://mmotraffic.com/ http://www.criteo.com http://www.google.com/doubleclick http://www.openx.org/ http://www.zedo.com/

Antivirus Tools

I often forgets name of my precious Antivirus tools. It is time to note them. For hidden folders and system fixes - RRT - Sergiwa  http://www.sergiwa.com For virus removal - Kaspersky, Kaspersky Virus Removal Tool   http://www.kaspersky.com/virus-removal-tools  Big but powerful. For system registry fix - CCleaner -  http://download.cnet.com/ccleaner/

Google Maps Api tutorial

Google maps have many functionality API. I've used that api to create complete map of ub long time ago. Lately I had to do same thing again, and with user point generator. Or I'd say map point long lang getter something like that. So I've used this script for map point LL getter http://www.gorissen.info/Pierre/maps/googleMapLocationv3.php And used this tutorial for google map with custom controls and other things. This is very great tutorial http://econym.org.uk/gmap/

Configuring RED5

So It is been 1 - 2 years when I first tried RED5. At that time everything was like dark room. This yesterday I tried RED5 again. Installed perfectly following instructions. And 1st thing I needed to do was open 5080,443 and 1935 ports, this ports needs to be open on servers. After that I better remove default welcome page. Cause that page has many demos including live streams. It is better removed or renamed. Default page is located in webapps/root. Also remember to remove vod and everything from wepapps. Next thing to do is Securing Oflademo prevent used on other sites. Secure plugin is here  http://www.red5.org/wiki/Examples/SecurityExample All I had to do was removing original oflademo and putting secured one, also i putted  plugin in plugin directory. And changed configuration that points text files. Now it seems everything works fine now

Installing red5 on centos 5.x

Image
Hello just quick link for you.  http://www.sohailriaz.com/how-to-install-red5-server-on-centos-53/ Above link will install red5. But keep in mind install ant manually from  http://ant.apache.org/bindownload.cgi  , the post mirror is down and yum install will mess up things. And at the end make sure ur init.d/red5 file is chmodded 755. just in case if something bad happens above post I'll back it up here

Repair and optimize all database at once

Today somehow our mysql service crashed tables being broken. It is really painful to repair them 1 by 1 through phpmyadmin. So if you have access through SSH then you can run just a single command from console. All posts around internet gives you mysqlcheck -Aor but this won't work unless you dont have pass for root. All you have to do is add -p on it like this mysqlcheck -Aorp this will ask your root password. Explanation  -A -> All Databases -o -> optimize -r -> repair -p -> Password If just wanna repair exclude -o, and just wanna optimize exclude -r. Thats all

Lets use Chrome Browser

I've been using IE till 8th upgrade. IE8 was a quite a buggy and crashes often. Then I headed to Mozilla Firefox it's been very good till 3.6. But from 3.6 it uses crazy memory, like 500MB. Usually I opens 10 - 20 tabs and 2 - 3 browsers. So I needed new browser. I've tried Chrome before. About half year ago maybe. Chrome was so useless and buggy. But I wanted to give it a try one more time. This time Chrome was so different. It uses same memory like Firefox but not a single task. It uses bout 5 - 6 tasks and 10 - 70MB ram. So it wont crash and slows down computer like firefox when uses 500 and above memory. And more importantly chrome has a very big field of view. My laptop uses 1366 x 768 firefox and ie user interface can fill about 100 px from height top and bottom Chrome uses only about 50px something. And somehow chrome manages operate more faster than my previous browsers. And it has integrated web inspector in it like Firebug. If you really want to you can install Fi...

Rounded Flags

Found a really nice rounded flags for all country. Here is the link http://www.shareapic.net/content.php?gid=277004&owner=berryblitz I should say sphere flags cause it is 3D.