gallery manager script for my tgp - GoFuckYourself.com

gallerypost · 04-22-2002, 08:41 AM

Hey guys.

I need a gallery manager script for my tgp.

The thing is that i need a very simple script, it's just need to let access to a few guys who building the galleries to my tgp to submit them.

It should save the urls on a mysql database and every day at XX:XX pick 40 galleries from the ones that it didn't display yet.. and display them....

What the best one to do so ?

DarkJedi · 04-22-2002, 10:12 AM

sorry, i dont know

Babaganoosh · 04-22-2002, 10:19 AM

You might like http://www.tgpdevil.com

Matt 26z · 04-22-2002, 10:41 AM

I'm sure you are looking for the finished script, but even a beginner at PHP could do it.

This would be a very simple script with many different ways to do it.

You could store them in the DB like so:

Date URL1 URL2 URL3.....
Date URL1 URL2 URL3.....

Then with PHP or whatever just pull up the row you want by the date that matches today's date.

The submission area would be nothing more than a password protected form page.

mike503 · 05-22-2002, 12:56 AM

gallerypost, talk to me on icq, i have already created a program for what you want, but on a more distributed level.

45226474

Jimbo · 05-22-2002, 01:13 AM

Quote:

Originally posted by Matt 26z
I'm sure you are looking for the finished script, but even a beginner at PHP could do it.

This would be a very simple script with many different ways to do it.

You could store them in the DB like so:

Date URL1 URL2 URL3.....
Date URL1 URL2 URL3.....

Then with PHP or whatever just pull up the row you want by the date that matches today's date.

The submission area would be nothing more than a password protected form page.

not a good way of using databases

if I understand your DB modeling you'll have to create a new column for every new galleries... what about days that has less galleries then the biggest submission day? empty column?

it should be

Table: galleries

Url Date Desc NbPics etc

the point is 1 gallery per line

then you could use a SELECT * from galleries where date=<date you want>;

or just SELECT ... LIMIT 40 to get 40 galleries. of course you would have to delete...

why the hell I'm I posting this?

ServerGenius · 05-22-2002, 01:31 AM

doing galleries from MySQL isn't smart anyway....why would you
do that....for every hit you will have queries.....goodluckonce
your site goes big!

If you are going to store the galleries and all other info in
database then you better generate the index.html from a template once per day.

That way you have your stuff organised and easy for the admin
and your site fast eating low resources even if it's busy...

DynaMite

a1ka1ine · 05-22-2002, 01:42 AM

yeh... yesterday i had little/no experience of PHP. i picked up a "learn PHP in 24 hours" book, and today i have a TGP gallery management system, allowing people to submit a TGP, it auto emails them confirmation, and i have an admin area to view and approve them.. all using a mysql db

really quite simple. im working on a link management system now which is a little harder, with ranking and referrel codes and stuff

komm susser todd-NGE.

a1ka1ine · 05-22-2002, 01:46 AM

Quote:

Originally posted by DynaSpain
doing galleries from MySQL isn't smart anyway....why would you
do that....for every hit you will have queries.....goodluckonce
your site goes big!

If you are going to store the galleries and all other info in
database then you better generate the index.html from a template once per day.

That way you have your stuff organised and easy for the admin
and your site fast eating low resources even if it's busy...

DynaMite

Yeh, pretty good.. my TGP management system on my site now needs re-writing, im getting about 5k page views and ive noticed its slowed down a bit... hmm.

Jimbo · 05-22-2002, 06:47 AM

Quote:

Originally posted by DynaSpain
doing galleries from MySQL isn't smart anyway....why would you
do that....for every hit you will have queries.....goodluckonce
your site goes big!

If you are going to store the galleries and all other info in
database then you better generate the index.html from a template once per day.

That way you have your stuff organised and easy for the admin
and your site fast eating low resources even if it's busy...

DynaMite

we're not talking of selecting a gallery ewach time a user visits the site

ServerGenius · 05-22-2002, 06:56 AM

Quote:

Originally posted by Jimbo

we're not talking of selecting a gallery ewach time a user visits the site

Well some did and unexperienced coders would do it...so I thought
it was worth mentioning

DynaMite

04-22-2002, 08:41 AM	#1
gallerypost Confirmed User Join Date: Nov 2001 Posts: 711	gallery manager script for my tgp Hey guys. I need a gallery manager script for my tgp. The thing is that i need a very simple script, it's just need to let access to a few guys who building the galleries to my tgp to submit them. It should save the urls on a mysql database and every day at XX:XX pick 40 galleries from the ones that it didn't display yet.. and display them.... What the best one to do so ?

04-22-2002, 10:19 AM	#3
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	You might like http://www.tgpdevil.com __________________ I like pie.

05-22-2002, 12:56 AM	#5
mike503 Confirmed User Industry Role: Join Date: May 2002 Location: oregon. Posts: 2,243	gallerypost, talk to me on icq, i have already created a program for what you want, but on a more distributed level. 45226474 __________________ php/mysql guru. hosting, coding, all that jazz.

05-22-2002, 01:31 AM	#7
ServerGenius Confirmed User Join Date: Feb 2002 Location: Amsterdam Posts: 9,377	doing galleries from MySQL isn't smart anyway....why would you do that....for every hit you will have queries.....goodluckonce your site goes big! If you are going to store the galleries and all other info in database then you better generate the index.html from a template once per day. That way you have your stuff organised and easy for the admin and your site fast eating low resources even if it's busy... DynaMite __________________ \| http://www.sinnerscash.com/ \| ICQ: 370820 \| Skype: SinnersCash \| AdultWhosWho \|

04-22-2002, 10:12 AM	#2
DarkJedi No Refunds Issued. Industry Role: Join Date: Feb 2001 Location: GFY Posts: 28,300	sorry, i dont know

04-22-2002, 10:41 AM	#4
Matt 26z So Fucking Banned Industry Role: Join Date: Apr 2002 Location: ¤ª"˜¨๑۩۞۩๑¨˜"ª¤ Posts: 18,481	I'm sure you are looking for the finished script, but even a beginner at PHP could do it. This would be a very simple script with many different ways to do it. You could store them in the DB like so: Date URL1 URL2 URL3..... Date URL1 URL2 URL3..... Then with PHP or whatever just pull up the row you want by the date that matches today's date. The submission area would be nothing more than a password protected form page.

05-22-2002, 01:42 AM	#8
a1ka1ine Confirmed User Industry Role: Join Date: Apr 2002 Posts: 3,387	yeh... yesterday i had little/no experience of PHP. i picked up a "learn PHP in 24 hours" book, and today i have a TGP gallery management system, allowing people to submit a TGP, it auto emails them confirmation, and i have an admin area to view and approve them.. all using a mysql db really quite simple. im working on a link management system now which is a little harder, with ranking and referrel codes and stuff komm susser todd-NGE.