I take it the pages aren't dynamically generated with PHP and centralised CSS then?Which reminds me, I need to update the archives to the new site style. Sigh.
Other D.C.Simpson O&M art work
Furries? Are they the nutters that pretend to be animals and draw humans that look like animals? Christ, I sink my head into my paws... -Rooster
I haven't had a lot of luck getting outside scripts to play nice with Keenspot scripts. I'd hate to put you to that much trouble for something we might not be able to make work.My offer still stands to code an archive script for youI wish. I don't know how to do any of that stuff.I take it the pages aren't dynamically generated with PHP and centralised CSS then?Which reminds me, I need to update the archives to the new site style. Sigh.
I'm very good at making stuff work, even on difficult servers. I just need to know if it has PHP and MySQL support then you could have a nice search enabled archive systemI haven't had a lot of luck getting outside scripts to play nice with Keenspot scripts. I'd hate to put you to that much trouble for something we might not be able to make work.My offer still stands to code an archive script for youI wish. I don't know how to do any of that stuff.I take it the pages aren't dynamically generated with PHP and centralised CSS then?Which reminds me, I need to update the archives to the new site style. Sigh.
I don't mind the work, I'm not working on any major PHP projects anymore so I could use the practice
Why bother to write one? HouseRules has one ready-made, I'd just need to fix it up a bit so you're able to add completely new strips. But I'm willing to help out in making it work.
Furries? Are they the nutters that pretend to be animals and draw humans that look like animals? Christ, I sink my head into my paws... -Rooster
Just finished witting one, but would love to see how you handled some aspects like sunday strips in the middle of a storyline and non-standard filenames. Are you using MySQL? Also, how did you calculate the previous/next strip?Why bother to write one? HouseRules has one ready-made, I'd just need to fix it up a bit so you're able to add completely new strips. But I'm willing to help out in making it work.
Sunday strips are done by interrupting the storyline and starting another with a NULL name. This causes the script not to show a story name, but continue the previous one instead.
Calculating the previous strip is a matter of selecting all strips whose date is before the current one, and then ordering them by date:
You can use LIMIT 1 to get that specific one, but since the strips on HR are pre-stored, and the file existence determines whether the strip is there, it first iterates through the results and returns the first one that has an existing file name.
Getting the next works the same way.
Calculating the previous strip is a matter of selecting all strips whose date is before the current one, and then ordering them by date:
Code: Select all
"SELECT YEAR(date) AS year, MONTH(date) AS month, DAYOFMONTH(date) AS day, title
FROM strips
WHERE date < '" . $year . "-" . $month . "-" . $day . "'
ORDER BY date DESC"
Getting the next works the same way.
Furries? Are they the nutters that pretend to be animals and draw humans that look like animals? Christ, I sink my head into my paws... -Rooster
Sounds similar to how I handled it, except I showed the story as "Storyline cont.".Sunday strips are done by interrupting the storyline and starting another with a NULL name. This causes the script not to show a story name, but continue the previous one instead.
So, you cycle through every strip until you reach the requested strip then use the previous results? Sounds kinda slow. Although I'm using three MySQL queries so I'm not so sure mine's any better LOL.Calculating the previous strip is a matter of selecting all strips whose date is before the current one, and then ordering them by date:You can use LIMIT 1 to get that specific one, but since the strips on HR are pre-stored, and the file existence determines whether the strip is there, it first iterates through the results and returns the first one that has an existing file name.Code: Select all
"SELECT YEAR(date) AS year, MONTH(date) AS month, DAYOFMONTH(date) AS day, title FROM strips WHERE date < '" . $year . "-" . $month . "-" . $day . "' ORDER BY date DESC"
Getting the next works the same way.
Edit: 2 MySQL queries
No, it gets all strips that are before the current strip, ordered by closest to current first. Then it iterates through the results in order, checking to see if the file for that strip exists for each one. If it finds a strip for which the file exists, it stops looking and returns that one.So, you cycle through every strip until you reach the requested strip then use the previous results? Sounds kinda slow. Although I'm using three MySQL queries so I'm not so sure mine's any better LOL.
Furries? Are they the nutters that pretend to be animals and draw humans that look like animals? Christ, I sink my head into my paws... -Rooster
TECH TALK!!!!! *sounds the siren*
Astro> gforce's smiles can cure cancer in kittensgforce422 is awesome because:
-He made the absolute nicest comments about me in the other topic. I didn't respond to them yet, because I suck, but they are greatly appreciated! =D
-I would say he would also be a good runner up as one of the nicest people alive.
-He joined the IRC sometimes. But not enough, I say! Chat moar =D
-He is evidently only 18 year old but he could easily pass for 25. =D
-He is a drummer like *I* am and this in itself is cool.
Astro> the happiness radiating from your person is enough to solve tensor calculus
<mib_4do271>everything you touch explodes in pillows of happiness
- Tom Flapwell
- Posts:5465
- Joined:Wed Feb 23, 2005 1:48 pm
- Location:DC
- Contact:
Both Sliver and DCS himself are double-posting. Shall we consider the rule disbanded?
See other much-maligned creatures in my webcomic: http://downscale.comicgenesis.com
Who is online
Users browsing this forum: No registered users and 30 guests