Armed and Hammered - GoFuckYourself.com

hyper · 08-27-2002, 10:42 PM

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

Babaganoosh · 08-27-2002, 11:09 PM

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.

Fletch XXX · 08-27-2002, 11:11 PM

Customer support my ass hahaha

hehehe

Babaganoosh · 08-27-2002, 11:14 PM

Quote:

Originally posted by Fletch XXX
Customer support my ass hahaha

hehehe

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

Alky · 08-27-2002, 11:17 PM

hyper contact me icq 9287771

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

hyper · 08-27-2002, 11:32 PM

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

Babaganoosh · 08-27-2002, 11:39 PM

You don't want to auto-increment.

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

Babaganoosh · 08-27-2002, 11:44 PM

Here

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

The setup is fixed. Now stop crying.

hyper · 08-27-2002, 11:57 PM

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

Babaganoosh · 08-28-2002, 12:00 AM

Quote:

Originally posted by hyper
lol.. but why dont you want to auto increment it?

Trust me.

hyper · 08-28-2002, 12:06 AM

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

Babaganoosh · 08-28-2002, 12:19 AM

Quote:

Originally posted by hyper
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?

hyper · 08-28-2002, 01:15 AM

nope it didnt

08-27-2002, 10:42 PM	#1
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	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 __________________

08-27-2002, 11:09 PM	#2
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	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. __________________ I like pie.

08-27-2002, 11:11 PM	#3
Fletch XXX GFY HALL OF FAME DAMMIT!!! Join Date: Jan 2002 Location: that 504 Posts: 60,840	Customer support my ass hahaha hehehe __________________ Want an Android App for your tube, membership, or free site? Need banners or promo material? Hit us up (ICQ Fletch: 148841377) or email me fletchxxx at gmail.com - recent work - About me

08-27-2002, 11:32 PM	#6
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	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 __________________

08-27-2002, 11:39 PM	#7
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	You don't want to auto-increment. Do ALTER TABLE `whatever`.`TGPDredirect` CHANGE `wid` `wid` INT(5) DEFAULT '0' NOT NULL __________________ I like pie.

08-27-2002, 11:17 PM	#5
Alky Confirmed User Join Date: Apr 2002 Location: Houston Posts: 5,651	hyper contact me icq 9287771 i can prob tell you how to fix it in 5 mins.

08-27-2002, 11:44 PM	#8
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	Here http://www.tgpdevil.com/scripts/free.shtml The setup is fixed. Now stop crying.

08-27-2002, 11:57 PM	#9
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	lol.. but why dont you want to auto increment it? __________________

08-28-2002, 12:06 AM	#11
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	i do trust you.. i just want to know the reason __________________

08-28-2002, 01:15 AM	#13
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	nope it didnt __________________