PDA

View Full Version : [fixed] Access & profile bug...



Joshs
Mon 14th May '01, 11:57pm
go to: http://forums.hytekcomputer.com

Under the announcements forums last post by on the main page, click Josh.

Also go to: http://forums.hytekcomputer.com/member.php?s=&action=getinfo&find=lastposter&forumid=29

Joshs
Tue 15th May '01, 1:03am
Okay, you have to be logged in....

Username: HyTECH_User
Password: Password

Joshs
Tue 15th May '01, 8:04am
I am thinking it may be an error with the permissions...

Joshs
Tue 15th May '01, 3:41pm
Anyone have any ideas? If a developer needs control panel access, just contact me...

John
Tue 15th May '01, 5:04pm
Fixed.

I'll post details once I have collated them.

John

John
Tue 15th May '01, 7:11pm
Change line 41 in showthread.php from:


$thread=$DB_site->query_first("SELECT threadid FROM thread WHERE forumid IN (0$forumslist) AND visible=1 AND (sticky=1 OR sticky=0) AND lastpost>='$foruminfo[lastpost]' AND open<>10 ORDER BY lastpost DESC LIMIT 1");


to:


$thread=$DB_site->query_first("SELECT threadid FROM thread WHERE forumid IN (0$forumslist) AND visible=1 AND (sticky=1 OR sticky=0) AND lastpost>='".($foruminfo[lastpost]-30)."' AND open<>10 ORDER BY lastpost DESC LIMIT 1");


And line 1082 of member.php from:


$thread=$DB_site->query_first("SELECT threadid FROM thread WHERE forumid IN (0$forumslist) AND visible=1 AND (sticky=1 OR sticky=0) AND lastpost>='$foruminfo[lastpost]' AND open<>10 ORDER BY lastpost DESC LIMIT 1");


to:


$thread=$DB_site->query_first("SELECT threadid FROM thread WHERE forumid IN (0$forumslist) AND visible=1 AND (sticky=1 OR sticky=0) AND lastpost>='".($foruminfo[lastpost]-30)."' AND open<>10 ORDER BY lastpost DESC LIMIT 1");


John