AquilaX’s development blog

75% discount on HostGator only today

Today HostGator is offering 75% discount for hosting with code: 75OFF

¶ Posted 27 November 2009 † AquilaX § /dev/null ‡ Comments (0)

Move table in postgres to different schema

To move table to different schema in PostgreSQL use:

ALTER TABLE table_name SET SCHEMA schema_name;

¶ Posted 26 August 2009 † AquilaX § PostgreSQL ‡ Comments (0)

Playing with big files

If you're looking for a big text file to play with, why don't you try http://www.dotnetdotcom.org/.

We invite you to help us share the content of internet by downloading the first part of our index. It has roughly 600,000 pages and is shared in an easy to parse text file. We are making this available as a bit torrent to help conserve bandwidth. Enjoy!

¶ Posted 24 August 2009 † AquilaX § /dev/null ‡ Comments (0)

Rating for Blogger (Blogspot)

If you want to add rating system for your posts in Blogger, check Outbrain (http://www.outbrain.com/). They have fully automated script for that.
I'm using it form my animated gifs blog.

¶ Posted 31 July 2009 † AquilaX § /dev/null § Java Script ‡ Comments (0)

Get parameters in Code Igniter

If you want to use GET parameters in Code igniter just for specific controller do use the following line in your Controller's constructor:

 
    parse_str($_SERVER['QUERY_STRING'],$_GET);

Also make sure to call your script like this (even if you use mod_rewrite to get rid of index.php):

www.example.com/index.php/controller/method/?par1=1&par2=2

¶ Posted 29 May 2009 † AquilaX § PHP ‡ Comments (0)

Smooth tile scrolling with Slick

game1

This is my first attempt for smooth tile scrolling in Slick. The offx/offy coordinates are not entirely correct for hero, smaller than the tile image but it's a good start the "smooth" part comes from shx/shy variables which offset the rendering position. The code is after the break:

Update: Check the project source code page at Google Code: http://code.google.com/p/jmuonline/

¶ Posted 05 May 2009 † AquilaX § Slick ‡ Comments (0)

Media Wiki Bot

I needed a bot to quickly modify the pages of wiki.muonlinehelp.com. So I created Mutex which kind of helps do the job. It's full of bugs with no error handling but works for me.

Usage:

 
<?
  require 'class.mediawiki.php';
  $mw = new mediawiki('http://yourwikiurl/api.php');
  $mw->login('bot_user', 'bot_password');
  $mw->editPage('title', 'page_text');
?>

You can get the source code from here.

¶ Posted 24 March 2009 † AquilaX § /dev/null § PHP ‡ Comments (0)

Randomize timestamp in MySQL

To randomize timestamp column in mysql You can use the following statement:

 
UPDATE your_table SET
timestamp_field = TIMESTAMPADD(MINUTE, RAND()*60,timestamp_field);

¶ Posted 16 February 2009 † AquilaX § MySql ‡ Comments (0)

Show images depending on the browser’s width with CSS only

I had the make promo offers sections form our site. Usually this is an easy task but the requirement on this case was to preserve the full page width design and keep the page usable for 600px wide screens.

So let's start with the HTML portion.

 
<div id="top_offers">
  <a href="#"><img src="1.png" alt="image 1"/></a>
  <a href="#"><img src="2.png" alt="image 2"/></a>
  <a href="#"><img src="3.png" alt="image 3"/></a>
  <a href="#"><img src="4.png" alt="image 4"/></a>
  <a href="#"><img src="5.png" alt="image 5"/></a>
</div>

The HTML will render as this:
Screen Shot 1

Let's add a little css to get the desired effect:

 
  #top_offers{
    height: 190px;
    background-color: #d3d7cf;
    overflow: hidden; /* hide the excess images*/
    text-align: justify; /* or center here */
  }
  #top_offers a img{
    margin: 20px;
    border:none;
  }

Which brings the following results:
Screen Shot 2

Screen Shot 3

You can play with the example here.

¶ Posted 20 January 2009 † AquilaX § css ‡ Comments (0)

Linux batch encoding convert one liner

 
find -name '*.php' -exec iconv -f cp1251 -t utf8 '{}' -o '{}'.utf8 \;

Idea taken from here.

¶ Posted 27 November 2008 † AquilaX § Linux ‡ Comments (0)