Forum names on Portal announcements
leefish Offline
Hamster
*****
Posts: 1,009
Joined: Apr 2010
Post: #1
Forum names on Portal announcements
I was wandering about in the old threads here on MYBBHacks and came across this post:

http://mybbhacks.zingaburga.com/showthread.php?tid=50

I had a look at the code - I thought well, that doesn't seem to have changed much - I shall have a go. I made this code edit in my portal.php

PHP Code:
1
2
3
4
5
6
7
8
9
10
$announcements = '';
$query = $db->query("
	SELECT t.*, t.username AS threadusername, u.username, u.avatar, u.avatardimensions, f.name AS forumname
	FROM ".TABLE_PREFIX."threads t
	LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
	LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid = t.fid)
	WHERE t.fid IN (".$announcementsfids.") AND t.tid IN (0{$tids}) AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
	ORDER BY t.dateline DESC
	LIMIT 0, ".$mybb->settings['portal_numannouncements']
);


and put the edited file in my FTP. This was the result.....

[Image: attachment.php?aid=286]

I don't really understand why its doing this. Is the code non compatible now?



Attached File(s) Thumbnail(s)
   


[Image: leelink.gif]
MYBB1.6 & XThreads
(This post was last modified: 11-18-2010 11:51 AM by leefish.)
11-18-2010 11:48 AM
Visit this user's website Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
Forum names on Portal announcements - leefish - 11-18-2010 11:48 AM

 Standard Tools
Forum Jump: