Armed and Hammered
 

hey can you fix your redirection script?

i got it somewhat working by auto incrementing the id..
but i dont fuck with perl

so can you rewrite the setup to drop the mysql table or update it and make the id # increment properly.. thanks

It's a freebie. Feel free to modify it as you see fit. I really don't have any time to support it. I wrote it in about an hour late one night for someone here as a freebie. Sounds like you're on the right track though.

Customer support my ass hahaha

hehehe

:winkwink:

I know, I am such a jerk. Not supporting free scripts. What the hell was I thinking?

hyper contact me icq 9287771

i can prob tell you how to fix it in 5 mins.

okay i have it fixed..
i just need to know how to drop the table if it exists.. i tried the php way but it didnt seem to work


########## Create Tables ################
my($query) = "CREATE TABLE TGPDredirect (
wid int auto_increment NOT NULL,
wurl varchar(255) NOT NULL,
whits varchar(10) NOT NULL,
PRIMARY KEY (wid)
)TYPE=INNODB;";
my($sth) = $dbh->prepare($query);
$sth->execute() or die "Unable to execute query: ".$sth->errstr;
$sth->finish;


tell me how to drop the table before creation and i will post the zip so you can give them the correct one

You don't want to auto-increment.

Do
ALTER TABLE `whatever`.`TGPDredirect` CHANGE `wid` `wid` INT(5) DEFAULT '0' NOT NULL

Here

http://www.tgpdevil.com/scripts/free.shtml

The setup is fixed. Now stop crying. :winkwink:

lol.. but why dont you want to auto increment it?

Trust me.

i do trust you..
i just want to know the reason

Add a link. Now delete the link you just added. Now add another. Notice anything? Skipped a number, didn't it?

nope it didnt