SQL Question

NY Jester · 2008-01-11, 04:51 PM

If I have a database set up MySQL (Banners) ..how do I get individual banners listed in it? I am not really savvy with SQL, so sorry for the NewB question.

the folder I have the banners in is.. /images/banners/

And second part is, once I have the initial DB set up, is it possible to add new ones to the mix?

Thanks

horney · 2008-01-11, 06:44 PM

You just enter the URL for each banner in the table using the insert command. The harder part is writing the script to get the page layout you want from it. What are you using? PHP?

If you're not familiar with that type of coding, pay hotscripts.com a visit and see if you can pick up one that's already written. Raise it again if you don't get any joy there and I'll see if I can take you through it.

Useless · 2008-01-11, 09:45 PM

It's a monster and it's more than you could ever want, but it's free, powerful, and very stable. http://www.openads.org/ Formerly PHPadsnew.

LeRoy · 2008-01-11, 10:41 PM

Thanks UW . I needed another project on my plate.

NY Jester · 2008-01-11, 11:27 PM

UW, thats exactly what Im using I downloaded last week. If I create the DB in MYSQL openads will do the rest? As long as I add each banner to the "campeign"?

I created the DB "banners" in MySQL. BTW

Also UW, I know you wnated to have to think before you left for Vegas..LOL, is it possible to use OpenAds to show different sized banners on the same page ...such as the top of the forum here. Also Im assuming I can have it serve niche specific banners to niche specific pages?

Fonz · 2008-01-12, 05:23 AM

Openads will add everything for you, in your initial setup of openads just specify the database name, database username and database password and you're all set.

NY Jester · 2008-01-13, 02:50 AM

Nice Fonz thanks, Ive got all that in place already I set up my DB/USER/PW now just have to plug some things in SpaceManSplif is giving me a brief tut how he does his ..Im grateful for all the inpit believe me.

J-

ronnie · 2008-01-14, 08:07 AM

I was going to say the same as UW. Open ads is the way to go. I've been using it for a long time, long before it was openads. There is a learning curve, but well worth it.

2008-01-11, 04:51 PM	#1
NY Jester ICQ:147079406 Join Date: Oct 2007 Location: RockMEHardplace Posts: 2,996	SQL Question If I have a database set up MySQL (Banners) ..how do I get individual banners listed in it? I am not really savvy with SQL, so sorry for the NewB question. the folder I have the banners in is.. /images/banners/ And second part is, once I have the initial DB set up, is it possible to add new ones to the mix? Thanks __________________ The Sexy Side of Porn

2008-01-11, 09:45 PM	#3
Useless Certified Nice Person Join Date: Oct 2003 Location: Dirty Undies, NY Posts: 11,268	It's a monster and it's more than you could ever want, but it's free, powerful, and very stable. http://www.openads.org/ Formerly PHPadsnew. __________________ Click here to purchase a bridge I'm selling.

2008-01-11, 10:41 PM	#4
LeRoy "Young dumb and full of cum" Join Date: Jun 2007 Location: Porn Valley Posts: 2,372	Thanks UW . I needed another project on my plate. __________________ JAPANESE ADULT AFFILIATE PROGRAM

2008-01-11, 11:27 PM	#5
NY Jester ICQ:147079406 Join Date: Oct 2007 Location: RockMEHardplace Posts: 2,996	UW, thats exactly what Im using I downloaded last week. If I create the DB in MYSQL openads will do the rest? As long as I add each banner to the "campeign"? I created the DB "banners" in MySQL. BTW Also UW, I know you wnated to have to think before you left for Vegas..LOL, is it possible to use OpenAds to show different sized banners on the same page ...such as the top of the forum here. Also Im assuming I can have it serve niche specific banners to niche specific pages? __________________ The Sexy Side of Porn Last edited by NY Jester; 2008-01-11 at 11:31 PM..

2008-01-12, 05:23 AM	#6
Fonz Former pr0n slinger. Join Date: Aug 2003 Location: Antwerp, Belgium Posts: 7,932	Openads will add everything for you, in your initial setup of openads just specify the database name, database username and database password and you're all set. __________________ See how I abuse little trees on my Shumi no Bonsai Blog

2008-01-11, 06:44 PM	#2
horney Shut up brain, or I'll stab you with a Q-tip! Join Date: Jan 2008 Posts: 111	You just enter the URL for each banner in the table using the insert command. The harder part is writing the script to get the page layout you want from it. What are you using? PHP? If you're not familiar with that type of coding, pay hotscripts.com a visit and see if you can pick up one that's already written. Raise it again if you don't get any joy there and I'll see if I can take you through it.

2008-01-13, 02:50 AM	#7
NY Jester ICQ:147079406 Join Date: Oct 2007 Location: RockMEHardplace Posts: 2,996	Nice Fonz thanks, Ive got all that in place already I set up my DB/USER/PW now just have to plug some things in SpaceManSplif is giving me a brief tut how he does his ..Im grateful for all the inpit believe me. J- __________________ The Sexy Side of Porn

2008-01-14, 08:07 AM	#8
ronnie Wheither you think you can or you think you can't, Your right. Join Date: Jun 2004 Location: midwest Posts: 2,274	I was going to say the same as UW. Open ads is the way to go. I've been using it for a long time, long before it was openads. There is a learning curve, but well worth it.