RangerLord — Wed, 06 Jun 2007 16:35:32 +0000

That's cool. I appreciate your attempt, even if we didn't figure it out.

This feature is supposed to be added in the next update release, but I got the impression that was coming "whenever", and there were several people on the support forum looking for a fix now.

When I have time, there are some other places in the script where the author accesses this data... but like I said, with the TemplatePower crap and the lack of documentation, I'll be hard pressed to find the right file, much less be able to figure out the code.

Thanks, again, for the help, and for the book recommendation. As soon as I can, I'll check into it (still reading my last HTML/CSS book right now).

R/L

teammatt3 — Mon, 04 Jun 2007 22:54:05 +0000

Yeah dude, I'm out. I have no idea what's going on with your script. All I can say is good luck. And get that book I recommended, once you're done, you'll be writing your own content management system.

RangerLord — Mon, 04 Jun 2007 22:44:32 +0000

Have we abandoned all hope here?

(Just checking...)

R/L

RangerLord — Sat, 26 May 2007 22:56:36 +0000

The structure of the database table is:

............ratingwarning
rid...rating...|....warningtext
..1.....K........0....K (All Ages) The subject matter and material in t...
..2.....K+......0....K+ (Older Kids) The subject matter and material i...
..3.....T........0....T (Teens) The subject matter and material in this...
..4.....YA.....3....YA (Young Adult) The subject matter and material ...
..5.....R........7....R (Restricted) The subject matter and material in...
..6.....M.......7....M (Mature) The subject matter and material in thi...

and we're using the dbquery function to create an associative array where $rating['rid'] is associated with the 'rid' column of the first row, and $rating['rating'] is associated with the 'rating' column of the first row, and the other columns are ignored. Seems to me that we're only reading the first row...

...but your test loop read all the rows...

... is that right?

RangerLord — Sat, 26 May 2007 12:51:24 +0000

Include file queries.php

<?php
// Default query strings used throughout the script.  You may need to alter these to bridge to other scripts or databases.

define (\"_UIDFIELD\", \"author.uid\");  // Do not change the aliasing (the \"author.\" part)!
define (\"_PENNAMEFIELD\", \"author.penname\");  // Do not change the aliasing (the \"author.\" part)!
define (\"_EMAILFIELD\", \"author.email\");  // Do not change the aliasing (the \"author.\" part)!
define (\"_PASSWORDFIELD\", \"author.password\"); //  Do not change the aliasing (the \"author.\" part)!
define (\"_AUTHORTABLE\", $tableprefix.\"fanfiction_authors as author\"); // Do not change the aliasing (the \"as author\" part)!

define (\"_STORYQUERY\",  \"SELECT stories.*, \"._PENNAMEFIELD.\" as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated  FROM (\"._AUTHORTABLE.\", \".$tableprefix.\"fanfiction_stories as stories) WHERE \"._UIDFIELD.\" = stories.uid AND stories.validated > 0 \");
define (\"_STORYCOUNT\", \"SELECT count(sid) FROM \".$tableprefix.\"fanfiction_stories as stories WHERE validated > 0\");
define (\"_SERIESQUERY\", \"SELECT series.*, \"._PENNAMEFIELD.\" as penname FROM \"._AUTHORTABLE.\", \".$tableprefix.\"fanfiction_series as series WHERE \"._UIDFIELD.\" = series.uid \");
define (\"_SERIESCOUNT\", \"SELECT COUNT(seriesid) FROM \".$tableprefix.\"fanfiction_series as series \");
define (\"_MEMBERLIST\", \"SELECT count( stories.sid ) as stories, \"._PENNAMEFIELD.\" as penname, \"._UIDFIELD.\" as uid FROM \"._AUTHORTABLE.\" LEFT JOIN \".$tableprefix.\"fanfiction_authorprefs AS ap ON \"._UIDFIELD.\" = ap.uid LEFT JOIN \".$tableprefix.\"fanfiction_stories AS stories ON stories.validated > 0 AND (FIND_IN_SET(\"._UIDFIELD.\", stories.coauthors) > 0 OR stories.uid = \"._UIDFIELD.\") \");
define (\"_MEMBERCOUNT\", \"SELECT COUNT(DISTINCT \"._UIDFIELD.\") FROM \"._AUTHORTABLE.\" LEFT JOIN \".$tableprefix.\"fanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET(\"._UIDFIELD.\", stories.coauthors) > 0 OR stories.uid = \"._UIDFIELD.\")  LEFT JOIN \".$tableprefix.\"fanfiction_authorprefs as ap ON \"._UIDFIELD.\" = ap.uid\");
?>

Reviewing the _STORYQUERY line above, I don't see any reference to the ratings id field (listed in the database as rid). That seems, at least to me, to be a problem...

RangerLord — Sat, 26 May 2007 12:44:45 +0000

Yes, that's what I get... (you'll note the fiction archive uses K, K+, T, YA, R & M instead of the standard movie ratings):

Quote: rating id 1rating string Krating id 2rating string K+rating id 3rating string Trating id 4rating string YArating id 5rating string Rrating id 6rating string M

Changing the output line to reference $rating['rating'] gives this output:

Quote: Action Stations!
Set Condition One throughout the ship!

Obstinate Tin Soldier by Chris Taylor [Rated: (5)]

Boomer is resurrected on a Cylon ship and struggles to keep her identity and continue fighting the war.

Published Tue, 22 May 2007 21:11:30 -0500

Chronicles of a Sniper by GoldWolf [Rated: K(1)]

The story of one resistance fighter on Caprica, and then later on New Caprica.

Published Tue, 01 May 2007 07:46:38 -0500

As you can see, Chris' story shows the correct index (5) for his 'R' rating, but the rating string itself does not appear, while GoldWolf's story shows the right index as well as the 'K' rating string.

We're close here... we just need to find out why the indexing isn't working inside the while loop. It may have something to do with that _STORYQUERY variable, so I'll check that out and post it.

Thanks,
R/L

teammatt3 — Fri, 25 May 2007 19:52:41 +0000

Ok, I am totally confused. Let me make sure we're on the same page.

When you run this code,

<?php
// I changed the function dbrow to dbassoc from my original code

$ratingsresults = dbquery(\"SELECT rid, rating FROM \".$settingsprefix.\"fanfiction_ratings\");

while($ratings = dbassoc($ratingsresults))
{
   echo \"rating id {$ratings['rid']}\";
   echo \"rating string {$ratings['rating']}\";
} 
?>

you get something like

Quote:
rating id 1 rating string P rating id 2 rating string PG rating id 3 rating string PG-13

Do you get something like that output? Yes or no?

RangerLord — Fri, 25 May 2007 19:06:22 +0000

Before trudging off in search of _STORYQUERY, I decided to take a look at the ratings one more time... the only array element that seems to contain anything is $ratings[1]. Are we missing an array declaration, or is there something else wrong?

RangerLord — Fri, 25 May 2007 18:57:21 +0000

OK, no syntax error, but the output gave me the zero character... I'll track down _STORYQUERY and see what I can find.

RangerLord — Fri, 25 May 2007 18:49:20 +0000

teammatt3;219709 wrote: Man, I'm a nice guy

You are, and your help is greatly appreciated.