Jump to content

CyberGod

Admin
 View Profile  See their activity

  • Content Count

    1,498

  • Donations

    $0.00 

  • Joined

  • Last visited

  • Days Won

    75

Posts posted by CyberGod

  13. Posted · Report reply

    Power of Media..

    A servant enrolled his donkey in a race & won.

     

    The local paper read: ‘SERVANT’s ASS WON’.

     

    The king was so upset with this kind of publicity that he ordered the servant to get rid of the donkey. He gave the donkey to the queen.

     

    The local paper then read:”QUEEN HAS THE BEST ASS IN TOWN”.

     

    The king fainted. Queen sold the donkey to a farmer for 10$.

     

    Next day paper read: “QUEEN SELLS HER ASS FOR $10″.

     

    This was too much, KING ordered the queen to buy back the donkey & leave it to the jungle.

     

    The next day Headlines: “QUEEN ANNOUNCES HER ASS IS WILD & FREE”

     

    The king died next day!

     

    Power of media.

    • Like 2

  19. Posted · Report reply

    Life Explained..

    On the first day, God created the dog and said:

     

    ‘Sit all day by the door of your house and bark at anyone who comes in or walks past. For this, I will give you a life span of twenty years.’

     

    The dog said: ‘That’s a long time to be barking. How about only ten years and I’ll give you back the other ten?’

     

    So God agreed.

     

    On the second day, God created the monkey and said:

     

    ‘Entertain people, do tricks, and make them laugh. For this, I’ll give you a twenty-year life span.’

     

    The monkey said: ‘Monkey tricks for twenty years? That’s a pretty long time to perform. How about I give you back ten like the Dog did?’

     

    And God agreed.

     

    On the third day, God created the cow and said:

     

    ‘You must go into the field with the farmer all day long and suffer under the sun, have calves and give milk to support the farmer’s family. For this, I will give you a life span of sixty years.’

     

    The cow said: ‘That’s kind of a tough life you want me to live for sixty years… How about twenty and I’ll give back the other forty?’

     

    And God agreed again.

     

    On the fourth day, God created humans and said:

     

    ‘Eat, sleep, play, marry and enjoy your life. For this, I’ll give you twenty years.’

     

    But the human said: ‘Only twenty years? Could you possibly give me my twenty, the forty the cow gave back, the ten the monkey gave back, and the ten the dog gave back; that makes eighty, okay?’

     

    ‘Okay,’ said God, ‘You asked for it.’

     

    So that is why for our first twenty years we eat, sleep, play and enjoy ourselves. For the next forty years we slave in the sun to support our family. For the next ten years we do monkey tricks to entertain the grandchildren. And for the last ten years we sit on the front porch and bark at everyone.

    • Like 3

  25. Posted · Report reply

    Hello all,

    First let’s explain the basics of what we are trying to do.

    We’ll build a script that will replace any type of url to a tiny url so it’s easier to post or be untraceable.

    For example this *long* google maps url

    http://maps.google.fr/maps?f=q&source=s_q&hl=fr&geocode=&q=white+house&sll=46.75984,1.738281&sspn=10.178118,28.54248&ie=UTF8&z=15&iwloc=A

    could become

    http://your.site/v/12345

    you can check it out here : http://www.djpate.com/portfolio/shortURL/create.php

    and download the source code here

    This is not very hard to do but it’s nice tutorial for beginners.

     

    Ok so let’s start with the DB schema.

    CREATE TABLE `urls` (
`id` INT NOT NULL ,
`url` VARCHAR( 250 ) NOT NULL ,
`expire` DATETIME NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;

     

    id will be our identification hash, we won’t use auto increment for privacy purpose.

    We dont want a bot to check all link starting from 1.

    url is the actual url that will be redirecting to

    and expire is the time when to delete the record from our db. I’ll take more about this feature later.

    Now that you have your db setup let’s create the db connection page. It’s always good to have only one file doing all the db stuff.

    mysql.php

    <?php

    mysql_connect("yourHost","yourLogin","yourPass") or die(mysql_error()); //connects to the db

    mysql_select_db("yourDb") or die(mysql_error()); // selects the right db

    ?>

     

    now the creation page.

    create.php

    <?php
require("mysql.php"); // to establish a connection to the db

/* configurations options */

$lengthOfTheHash = 5; // the length determine the numbers of chars in the hash created 5 => 12345 for example
$timeToExpire = 1; // in days
$urlOfYourSite = "http://www.djpate.com/portfolio/shortURL";

function createHash($length=5){ // very simple hash function to generate a random string
$valid = 0;
	while(!$valid){
		for($i=0;$i<$length;$i++){
			$possibleValues = "123456789"; // if you want to add letters you will have to change the id to varchar instead of int
			 // pick a random character from the possible ones
    		$hash .= substr($possibleValues, mt_rand(0, strlen($possibleValues)-1), 1);
		}
	$check = mysql_query("select id from urls where id = $hash") or die(mysql_error()); // checks if the hash allready exists in the db , not very likely to happen
	if(mysql_num_rows($check)==0){
		$valid = 1;
	}
	}
	return $hash;
}

if(isset($_POST['url'])){ // post was posted
	//here we want to validate that the url is valid with a regexp
	if(preg_match('|^http(s)?://[a-z0-9-]+(.[a-z0-9-]+)*(:[0-9]+)?(/.*)?$|i',$_POST['url'])){
		$hash = createHash($lengthOfTheHash);
		mysql_query("insert into urls (id,url,expire)
values ($hash,'".addslashes($_POST['url'])."',date_add(now(),interval $timeToExpire day))") or die(mysql_error());
		echo "Congrats ! here is your link : <a href=\"$urlOfYourSite/v/$hash\">$urlOfYourSite/v/$hash</a>";
	} else {
		echo "Invalid url !";
	}
} else {
	// no post data so we display the form
	?>
	<form method="post">
		URL : <input type=text name=url />
		<input type=submit value=go />
	</form>
	<?php
}
?>

     

    now let’s create the redirection page

    show.php

    <?php
if($_GET['id']){
	require("mysql.php"); // to establish a connection to the db
	$id = addslashes($_GET['id']);
	$getUrl = mysql_query("select url from urls where id = $id"); // check if the id exists in the db
	if(mysql_num_rows($getUrl)==1){ // if so we redirect using the header function
		$url = mysql_fetch_array($getUrl);
		header("location:".$url['url']);
	} else {
		echo "Error : invalid hash";
	}
} else {
	echo "Error : no hash";
}
?>

     

    And to finish up let’s make a simple url rewrite so we dont have to see the show.php

    .htaccess

    Options +FollowSymlinks
RewriteEngine on
RewriteRule ^v/([0-9]*)$ show.php?id=$1 [L]

     

    note : dont’ forget to check that you have enable the mod_rewrite on your apache conf !

    Bonus

    At this point everything should be working but you’ll end up having a problem with the url that stays in your db for years so you have to setup a cron to remove the url that reaches there expire date.

    We could do a real cron but you would need to have ssh access and php-cli installed and probably if you know what i’m talking about you dont need my help to do that.

    For those who can’t setup a real cron we are simply going to check to delete all the old record everytime someone create a new one.

    so you can just add this line before $hash = createHash($lengthOfTheHash); in create.php

    mysql_query("delete from urls where expire < now()");

     

    this will remove all url where expire date is inferior to the current date.

×