Auto Gallery SQL Question...
 

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?

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

What?

just put the code next to your manually added link

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

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

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

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

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. ;)

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,, !!

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.

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:

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.

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:

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:

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.

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

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:

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!

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

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!