gallery manager script for my tgp

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gallerypost
    Confirmed User
    • Nov 2001
    • 711

    #1

    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 ?
  • DarkJedi
    No Refunds Issued.
    • Feb 2001
    • 28301

    #2
    sorry, i dont know

    Comment

    • Babaganoosh
      ♥♥♥ Likes Hugs ♥♥♥
      • Nov 2001
      • 15841

      #3
      You might like http://www.tgpdevil.com
      I like pie.

      Comment

      • Matt 26z
        So Fucking Banned
        • Apr 2002
        • 18481

        #4
        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.

        Comment

        • mike503
          Confirmed User
          • May 2002
          • 2243

          #5
          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.

          Comment

          • Jimbo
            Confirmed User
            • Oct 2001
            • 3989

            #6
            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?
            free sex videos

            Comment

            • ServerGenius
              Confirmed User
              • Feb 2002
              • 9377

              #7
              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 |

              Comment

              • a1ka1ine
                Confirmed User
                • Apr 2002
                • 3387

                #8
                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.

                Comment

                • a1ka1ine
                  Confirmed User
                  • Apr 2002
                  • 3387

                  #9
                  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.

                  Comment

                  • Jimbo
                    Confirmed User
                    • Oct 2001
                    • 3989

                    #10
                    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
                    free sex videos

                    Comment

                    • ServerGenius
                      Confirmed User
                      • Feb 2002
                      • 9377

                      #11
                      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
                      | http://www.sinnerscash.com/ | ICQ: 370820 | Skype: SinnersCash | AdultWhosWho |

                      Comment

                      Working...