| Author |
Message |
ClickBouyow
Corporal
Joined: Jun 04, 2003
Posts: 66
|
 Posted:
Thu Jun 12, 2003 3:51 am |
  |
I searched the forum and didn't find anything specific to phpnuke 6.6 on this subject. I am using fiblack theme and I shows that there are PM's when there aren't any. Anyone got a fix for this?
Thanks |
|
|
   |
|
mikem
Theme Guru
Joined: Jan 13, 2003
Posts: 1582
Location: Corn fields of Indiana
|
| Posted:
Thu Jun 12, 2003 9:51 am |
|
|
|
|
ClickBouyow
Corporal
Joined: Jun 04, 2003
Posts: 66
|
| Posted:
Thu Jun 12, 2003 11:09 am |
|
| mikem wrote: |
Where are you seeing this information. In the Forums or in a Block?
mikem |
I see this in the User Info Block. The "Who's Online" block shows 0 PMs. |
|
|
|
|
mikem
Theme Guru
Joined: Jan 13, 2003
Posts: 1582
Location: Corn fields of Indiana
|
| Posted:
Thu Jun 12, 2003 1:54 pm |
|
Open you user info block..You should see two lines like this
| Code: |
$newpms = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND privmsgs_type='5' OR privmsgs_type='1'"));
$oldpms = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND privmsgs_type='0'")); |
try changing them to this
| Code: |
$newpms = $db->sql_numrows( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='1' or privmsgs_type='5')", $dbi );
$oldpms = $db->sql_numrows($db->sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='0')", $dbi ); |
mikem |
_________________
Getting Started | My Projects |
|
|
|
ClickBouyow
Corporal
Joined: Jun 04, 2003
Posts: 66
|
| Posted:
Thu Jun 12, 2003 2:31 pm |
|
| Quote: |
| Parse error: parse error, unexpected ';' in /home/virtual/site11/fst/var/www/html/blocks/block-User_Info.php on line 115 |
Is what I get then.
this is what I put in:
| Quote: |
$newpms = $db->sql_numrows( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='1' or privmsgs_type='5')", $dbi );
$oldpms = $db->sql_numrows($db->sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='0')", $dbi ); |
To replace this:
| Quote: |
$newpms = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND privmsgs_type='5' OR privmsgs_type='1'"));
$oldpms = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND privmsgs_type='0'")); |
Should there be 2 )) at the end of each line? Otherwise the statement is not closed? |
|
|
|
|
Viper
Lieutenant
Joined: May 04, 2003
Posts: 282
Location: Louisville, KY USA
|
| Posted:
Thu Jun 12, 2003 5:11 pm |
|
I believe you would only add the second ) to the last line, at least that's what I tried and it worked, just a few minutes ago.
Linzilla |
_________________
Building A Better PHP-Nuke Community!
 |
|
 |
|
mikem
Theme Guru
Joined: Jan 13, 2003
Posts: 1582
Location: Corn fields of Indiana
|
| Posted:
Thu Jun 12, 2003 5:54 pm |
|
Obvious that code won't work..Have you considered trying another block to see if it is indeed the block that is the problem.
Try getting one of the Site Visitors blocks from
http://www.nukemods.com
Make sure you get the one for Nuke6.5
Test it out and see if it works correctly.
mikem |
_________________
Getting Started | My Projects |
|
|
|
ClickBouyow
Corporal
Joined: Jun 04, 2003
Posts: 66
|
| Posted:
Fri Jun 13, 2003 3:32 am |
|
| mikem wrote: |
Obvious that code won't work..Have you considered trying another block to see if it is indeed the block that is the problem.
Try getting one of the Site Visitors blocks from
http://www.nukemods.com
Make sure you get the one for Nuke6.5
Test it out and see if it works correctly.
mikem |
I tried a different block and it works. Bug report time?? Anyway, the one I got from nukemods is ugly, so I'll keep looking for a better one.
Thanks! |
|
|
|
|
|
|
