Hi!
I have created a game journal for my game Space Zoo. It doesn't seem to be linked to my user page. What have I done wrong?
Best regards, Erik
Game Journal
Wed, 04/22/2015 - 11:07
Wed, 04/22/2015 - 11:17
#1
Game Journals
They can be "viewed" from top link "Game Journals"... They are not linked to your user account. Only BLOGS are linked...
That's why I blog rather than post "Game Journals".
FYI.
Wed, 04/22/2015 - 11:25
#3
Send a PM to...
richdurham
He might be able to help - if it's a bug.
Wed, 04/22/2015 - 19:43
#4
looking in to it.
I'm looking in to it, and forwarding the request to our more drupal oriented admin. In the mean time, if anyone here knows PHP code and can see something wrong with this without knowing whether the references are right (eg. to the node.type of "gamejournal" which is correct) then let me know and I can implement:
```
<?php
/**
* Creates a quicklist of recent game journals and a link to their
* node.
*
* To increase the length of the list, change $listlength
*
*/
global $user;
global $node;
$listlength="20";
preg_match("/\/user\/([0-9]*).*$/", request_uri(), $matches);
$tempuid = $matches[1];
$sql = "SELECT node.nid, node.title, node.created, users.name, node.uid FROM node INNER JOIN users WHERE node.uid = $tempuid AND users.uid=$tempuid AND node.status = 1 AND (node.type='gamejournal') ORDER BY name DESC LIMIT 10";
$numrows = 0;
$result = db_query($sql);
$output .= "<table><tbody>";
while ($sqlnode = db_fetch_object($result)) {
$year = format_date($sqlnode->created, 'custom', 'Y');
$month_day = format_date($sqlnode->created, 'custom', 'M j');
if ($year != $prev_year) {
$output .= "</tbody></table><h3>$year</h3><table><tbody>";
$prev_year = $year;
}
$output .= "<tr><td>". $month_day . " " . "</td><td>" . l($sqlnode->title, "node/$sqlnode->nid") . " ";
$output .= "</td><td><em>Submitted by " . $sqlnode->name . "</em><br/></td>";
$numrows++;
}
$output .= "</tbody></table>";
if (0 == $numrows)
{
$output = "<table><tr><td>No game journals created.</td></tr></table>";
}
print $output;
?>
```
Wed, 04/22/2015 - 20:11
#5
Hmm...
It's obvious the code returns NO RECORDS, because the while-loop would increment then $numrows by 1. So it's got to be something with the SQL.
Looking at the SQL, I can see nothing blatantly wrong, but some things that should be checked.
- node.status = 1? Is this true???
- (node.type='gamejournal')? Could it be 'Game Journal' or 'game journal'??? All lower case with a SPACE?!?!
That's the two (2) places I would look first.
Cheers!
Wed, 04/22/2015 - 21:37
#6
PHP student
I am currently learning PHP for school. My only question would be why you have a curly braket after the first if has already been closed. Unless there is supposed to be an else statement? Not sure. My bet is that some how your $ numrows variable is getting past the loop and going straight to the last if statement.
Again I'm a sstudent so I could be talking complete nonsense. Lol.
***edit***
answered my own question. I forgot the while loop braces. Whoops.
Wed, 04/22/2015 - 22:35
#7
Not the node.type
Thanks for the look-through, guys. Questccg - the node.type being "gamejournal" all lowercase like that with one word is indeed the machine-readable name stored for that node. I'll try wiggling the node.status to see if that makes a difference.
Short is, this code is when a user looks at their personal profile, they see a block on the left about their game journals. The code retrieves the journals they've created and lists them. That's it.
If none were created, it says so ($numrows == 0)
But it doesn't seem to be working.
Thank you for answering!
On my user page to the left it is written that "No game journals created" (as is the same for your user page). This is not true. Is this a known feature of the site?
Best regards,
Erik