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 ?

sorry, i dont know

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

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.

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

45226474

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? :helpme

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 :2 cents:

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.

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.

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 :winkwink:

DynaMite :thumbsup