[D-Orange]

02-25-03 at 11:34 AM Zelda-King said this in Post #157
[B]I didn't alter anything and I have the same problem;

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT u.username, e.entryid, e.journalid, e.title, e.entry, e.timestamp, e.userid, e.private, e.displayorder, e.comments
FROM journal_entry e
LEFT JOIN user u ON e.userid = u.userid
WHERE e.journalid = 14
ORDER BY e.timestamp DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Tuesday 25th of February 2003 03:18:48 AM
Script: http://www.gamercrossfire.net/bb/bb/...14&action=view
Referer:

-------------------------------

Much appreciated. I used this. A few notes though;

In memberlist.php use

PHP Code:

// vBJournal Hack by Ryangel
    if($userinfo[journal]==1){
        $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';
    }
    else {
        $journal = ''; 


instead of

PHP Code:

// vBJournal Hack by Ryangel
    if($userinfo[journal]==1){
        $journal = '<a href="journal.php?s=&journalid='.$userinfo[userid].'&action=view"><img src="images/journal.gif" alt="View '.$userinfo[username].'\'s Journal" border="0"/></a>';
    }
    else {
        $journal = '';
// vBJournal Hack by Ryangel 


In the memberlist template add;

<td bgcolor="{*tableheadbgcolor*}" align="center"><smallfont color="{*tableheadtextcolor*}"><b>Journal</b></smallfont></td>

above

$memberlistbits

rather than putting

<td bgcolor="#1D6AA0" align="center"><smallfont color="#EEEEFF"><b>Journal</b></smallfont></td>

below it.

In the memberlistbit template use;

<td bgcolor="{*firstaltcolor*}">$journal</td>

rather than

<td bgcolor="#13486D">$journal</td>

Most of this isn't your fault. I noticed when you put something like {*tableheadbgcolor*} (without the *s) it's replaced with the tableheadbgcolor HTML for this board.

Remove all the *s in my coding for it to work.

[/i]

I've done this, however I get a Parse error: parse error in /home/guforum/public_html/test/memberlist.php on line 202

version is 2.3.0

any thoughts what's wrong?