Auto Gallery SQL Question... - GoFuckYourself.com

FreeHugeMovies · 05-06-2002, 07:57 PM

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 · 05-06-2002, 08:07 PM

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

FreeHugeMovies · 05-06-2002, 08:17 PM

What?

Hot Tropical Babes · 05-06-2002, 08:19 PM

just put the code next to your manually added link

Hot Tropical Babes · 05-06-2002, 08:20 PM

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

FATPad · 05-06-2002, 08:21 PM

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

FreeHugeMovies · 05-06-2002, 08:22 PM

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

grumpy · 05-06-2002, 08:22 PM

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

FATPad · 05-06-2002, 08:24 PM

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 · 05-06-2002, 08:25 PM

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 · 05-06-2002, 08:27 PM

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 · 05-06-2002, 08:50 PM

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:

Code:

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

FreeHugeMovies · 05-06-2002, 10:07 PM

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 · 05-06-2002, 10:52 PM

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:

Code:

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

Code:

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 · 05-07-2002, 12:26 PM

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 · 05-07-2002, 12:40 PM

Quote:

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 · 05-07-2002, 01:04 PM

Quote:

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:

Code:

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

FreeHugeMovies · 05-07-2002, 01:10 PM

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.







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

Pipecrew · 05-07-2002, 01:14 PM

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 · 05-07-2002, 02:00 PM

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!

05-06-2002, 07:57 PM	#1
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	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?

05-06-2002, 08:07 PM	#2
Hot Tropical Babes Confirmed User Join Date: Feb 2001 Location: Orlando FL Posts: 3,014	I just pulled my code out,, didnt like it in there __________________ <BR> Trade with Big Tits TGP Trade with Titman

05-06-2002, 08:19 PM	#4
Hot Tropical Babes Confirmed User Join Date: Feb 2001 Location: Orlando FL Posts: 3,014	just put the code next to your manually added link __________________ <BR> Trade with Big Tits TGP Trade with Titman

05-06-2002, 08:20 PM	#5
Hot Tropical Babes Confirmed User Join Date: Feb 2001 Location: Orlando FL Posts: 3,014	aw fuckit ,, that aint gonna work either.. lemme think someore __________________ <BR> Trade with Big Tits TGP Trade with Titman

05-06-2002, 08:21 PM	#6
FATPad Confirmed User Join Date: Oct 2001 Posts: 6,693	hehe. I had to do that for my copy of Autogallery Pro. __________________ <a href="http://www.adultcontent.co.uk">Adult Content UK - Great British Content</a>

05-06-2002, 08:17 PM	#3
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	What?

05-06-2002, 08:22 PM	#7
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	LOL, I was looking for the Auto Gallery code that is needed.

05-06-2002, 08:22 PM	#8
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	describe it some more..maybe with an example...think i can put it in a javascript for you __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

05-06-2002, 08:24 PM	#9
FATPad Confirmed User Join Date: Oct 2001 Posts: 6,693	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. ;) __________________ <a href="http://www.adultcontent.co.uk">Adult Content UK - Great British Content</a>

05-06-2002, 08:25 PM	#10
Hot Tropical Babes Confirmed User Join Date: Feb 2001 Location: Orlando FL Posts: 3,014	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,, !! __________________ <BR> Trade with Big Tits TGP Trade with Titman

05-06-2002, 08:27 PM	#11
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	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.

05-06-2002, 08:50 PM	#12
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	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: Code: < !--#echo var="DATE_LOCAL" -- >

05-06-2002, 10:07 PM	#13
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	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.

05-06-2002, 10:52 PM	#14
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	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: Code: < !--#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: Code: 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.

05-07-2002, 12:26 PM	#15
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	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.

05-07-2002, 01:10 PM	#18
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	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!

05-07-2002, 01:14 PM	#19
Pipecrew Master of Gfy.com Industry Role: Join Date: Feb 2002 Posts: 14,887	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

05-07-2002, 02:00 PM	#20
FreeHugeMovies Too lazy to set a custom title Join Date: Dec 2001 Location: Charlotte, NC Posts: 14,139	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!