The RPG Maker Resource Kit

RMRK General => General Chat => Topic started by: :) on January 15, 2009, 01:52:18 AM

Title: http://minify.me/ URL shortening
Post by: :) on January 15, 2009, 01:52:18 AM
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:
Title: Re: http://minify.me/ URL shortening
Post by: Roph on January 15, 2009, 01:56:03 AM
http://is.gd/fVT8
Title: Re: http://minify.me/ URL shortening
Post by: Irock on January 15, 2009, 01:59:13 AM
URL has been shortened! ftom 17 characters to 24 characters

old URL:

http://is.gd/fVT8

new URL:

http://minify.me/?hvn62p
Title: Re: http://minify.me/ URL shortening
Post by: :) on January 15, 2009, 02:00:16 AM
thank you irock fir that test  :mad:

edit: oh ya and link: http://www.hido.net/projects/phurl/
Title: Re: http://minify.me/ URL shortening
Post by: :) on January 16, 2009, 12:50:43 AM
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
Title: Re: http://minify.me/ URL shortening
Post by: ahref on January 19, 2009, 07:29:59 AM
couldnt you just count the rows in the table?
Title: Re: http://minify.me/ URL shortening
Post by: :) on January 19, 2009, 02:41:04 PM
im working on some stuff ^^
Title: Re: http://minify.me/ URL shortening
Post by: Holkeye on January 19, 2009, 09:07:47 PM
I don't understand, are you making this site yourself, or for someone else? Or are you just advertising it?
Title: Re: http://minify.me/ URL shortening
Post by: :) on January 19, 2009, 09:16:03 PM
it's for myself