Main Menu
  • Welcome to The RPG Maker Resource Kit.

http://minify.me/ URL shortening

Started by :), January 15, 2009, 01:52:18 AM

0 Members and 1 Guest are viewing this topic.

:)

I was bored, had 5 mins.

I probably won't end up taking the site anywhere by marketing and maybe just use it for personal use who knows. won't put any ad's just keeping it simple.

http://minify.me/

it's using a free script, so feel free to use it.


thank you for your 30 seconds  :mad:
Watch out for: HaloOfTheSun

Roph

[fright]bringing sexy back[/fright]

Irock

URL has been shortened! ftom 17 characters to 24 characters

old URL:

http://is.gd/fVT8

new URL:

http://minify.me/?hvn62p

:)

#3
thank you irock fir that test  :mad:

edit: oh ya and link: http://www.hido.net/projects/phurl/
Watch out for: HaloOfTheSun

:)

Day 2 re-dseign ;p

http://minify.me for the lazy scrollers

roph help:

    db_connect();

    do {
        $short_url = generate_url();
        $suffix    = $short_url{0};

        $result = mysql_query("SELECT url, short_url FROM url_{$suffix} WHERE short_url = '$short_url' OR url = '$url'") or die(mysql_error());
        $count  = mysql_num_rows($result);

        if ($count > 0) {
            $row = mysql_fetch_row($result);

            if (stripslashes($row[0]) == $url) {
                break;
            }
        }
        else {
            mysql_query("INSERT INTO url_{$suffix} (short_url, url, created) VALUES ('$short_url', '".mysql_real_escape_string($url)."', NOW())") or die(mysql_error());
            break;
        }
    } while ($count > 0);

    $short_url    = "http://".$config['domain']."/".((!$config['rewrite']) ? "?" : "").$short_url;
    $short_length = strlen($short_url);
$percent = $length /  $short_length;


I suck with mysql and php of course.

how would I add another 'table'? in mysql so it can add +1 to it's value everytime the script is ran? and then call that number using a variable? so I can keep count of how many url's converted. thanks :D
Watch out for: HaloOfTheSun

ahref

couldnt you just count the rows in the table?

:)

Watch out for: HaloOfTheSun

Holkeye

I don't understand, are you making this site yourself, or for someone else? Or are you just advertising it?

:)

Watch out for: HaloOfTheSun