Auto Gallery SQL Question...

[FreeHugeMovies]

I tried to post this in their support area, but my support time has ran out. Go figure! Here is my question.

I am running version 2.0.0b. On my MGP I have a running list of galleries down a page. In that listing I have a bunch of trade links. Each day I have to go in and fix the date on perm trade links to match the surrounding galleries. I have three sections of galleries on my page. Today's, One day old and two day old.

My question is this. Is there a code I can put in the template to give me the current date when I accept other galleries around it? Also, is there any html I can put in the template to make the one day old and two day old posts as well?

[Hot Tropical Babes]

I just pulled my code out,, didnt like it in there

[FreeHugeMovies]

What?

[Hot Tropical Babes]

just put the code next to your manually added link

[Hot Tropical Babes]

aw fuckit ,, that aint gonna work either.. lemme think someore

[FATPad]

hehe. I had to do that for my copy of Autogallery Pro.

[FreeHugeMovies]

LOL, I was looking for the Auto Gallery code that is needed.

[grumpy]

describe it some more..maybe with an example...think i can put it in a javascript for you

[FATPad]

As far as I know, there is no code.

There better not be after all the time it took me to make their script do what I wanted for that. ;)

[Hot Tropical Babes]

I set up alot of my scripts, but on a certain domain, it will not do the mysql (agp), it gives me an error,,,i worked 8 hours yesterday and kept coming up with the same error. My tech guys said it isnt my server either. WTF.. so i just put the agp back up......fuckin lost the data base... oh yeah,, yesterday was the day to be around me,, !!

[FreeHugeMovies]

Here is the example you wanted. We will use my site.

http://www.freehugemovies.com/movies.shtml

The first three links are galleries. The next two links are trades. The site continues this trend all the way down the web page.

[Mr.Fiction]

I'm not sure I totally understand the problem, but here's some ideas.

You could use SSI to pull in a file that has the current date for those links. Then you would only have to change it once a day, or you could even use a cron job to change the date every night in the include file.

Easier yet, you might even be able to get a current date variable by doing this:

< !--#echo var="DATE_LOCAL" -- >

[FreeHugeMovies]

Okay I just updated my web page to give you an example. If you look you will see the dates on the left of the galleries.

Everything with a 5/7 is a new gallery I updated tonight. The script puts this time stamp on it automatically.

The perm trade links I have on my page are the ones dated 5/6. Those are the ones I manually have to change each time.

[Mr.Fiction]

Can't you just use the Autogallery variables to do this?

Like #%DATE%# or #%LUPDT%#

I don't know if that would work, but if not, how about...

You are using an SHTML page, you should be able to do it using SSI. I wasn't able to get it to work perfectly when testing.

Read this page:
http://www.wdvl.com/Authoring/SSI/Intro/config.html

To me, it looks like you should be able to do this:

< !--#config timefmt="%m/%e"-->
< !--#echo var="DATE_LOCAL"-->

The problem with this is that it' makes the month have a zero in front of it. I suppose you should just do it where you update the month number each month and just echo the day each day. For example:

5/
< !--#config timefmt="%e"-->
< !--#echo var="DATE_LOCAL"-->

For some reason, though, when I test it, I get a space in front of the day. I'm not sure why.

Alterately, you could just do a simple server side include that would pull in a text file with the current date. For example, make a cron job that runs a script to update the date in a text file each night at midnight, then just put an include for that tiny text file each place where you want the date to appear.

I'm sure there might be a better way, but that's the way I'd probably do it.

[FreeHugeMovies]

My friend Jay told me how to do this and It works well. If you guys want me to post what I did let me know.

[FATPad]

Originally posted by FreeHugeMovies
My friend Jay told me how to do this and It works well. If you guys want me to post what I did let me know.

Sure. I want to see how someone else got around this. hehe

[fiveyes]

Originally posted by Mr.Fiction
For some reason, though, when I test it, I get a space in front of the day. I'm not sure why.

new lines within the coding = a space in the rendering.
See how the given example for flastmod appears at http://www.wdvl.com/Authoring/SSI/Intro/stats.html.
Try:

5/< !--#config timefmt="%e"-->< !--#echo var="DATE_LOCAL"-->

[FreeHugeMovies]

I uploaded 3 PHP files to my server. Here are the contents of each php file.

today.php

<?php
$today = date("n/j");
PRINT "$today";
?>


yesterday.php

<?php
$yesterday = date("n/j",time()-86400);
PRINT "$yesterday";
?>

2days.php

<?php
$twodays = date("n/j",time()-172800);
PRINT "$twodays";
?>

Now where I wanted the date I would put in this line of code in the html.

<!--#include file="today.php" -->

<!--#include file="yesterday.php" -->

<!--#include file="2days.php" -->


Works like a charm and I owe Jay a great thanks for his help!

[Pipecrew]

I've spent the last 3 days trying to configure autogallery to work, its such a piece of shit when you have an existing database... grrrr, i am having problems with some bullshit temp file

[FreeHugeMovies]

It is a huge pain in the ass to get it installed or even upgraded. But, when you get it going, updating your site takes 20 mins!