Member Info Top X - Page 3

09-13-2006, 09:00 AM

The Geek

Senior Member

Join Date: Aug 2005

Posts: 6,717

Member Info Top X

This was whipped together for Trana who has been asking for a few weeks for it.

...

Click here to read the entire release

Last edited by The Geek; 01-23-2007 at 02:24 PM..

#20

By trana on 09-26-2006, 06:58 PM

Quote:

Originally Posted by The Geek

Any forums you want to pull from need to be in the list. It doesnt do any searching of child forums or anything.

No, what I meant was that it appears that a subforum that was listed in the admincp options would not be searched unless the parent is also listed. Does that sound possible?

It is working now, so thank you again.

#21

By The Geek on 09-27-2006, 09:43 PM

Shouldnt be the case. Couldnt for the life of me figure out why that would be... anyway... as long as its sorted for now

#22

By trana on 10-05-2006, 04:16 AM

Can you help me get the code straightened out for displaying the header image next to the title?

I see you have this:

Code:

$results = $db->query_read("SELECT t.title, t.views, t.replycount, t.threadid FROM " . TABLE_PREFIX . "thread t WHERE t.visible=1 " . ($forumid ? " AND t.forumid in (-1$forumid) " : "") . "AND t.postuserid = $userinfo[userid] $orderby LIMIT " . (intval($limit) ? $limit : "5"));


        $bits = "";
        while ($result = $db->fetch_array($results))
        {
            $bits .= "<div class=\"smallfont\">
			    <a href='showthread.php?t=$result[threadid]' title='$result[title]'>$result[title]</a></div>";
	}
        if ($bits)
        {
            eval('$GARS_addon_member_top .="' . fetch_template('GARS_addon_member_top') . '";');
        }

Do I need to do a separate SELECT to load the header images from the gars table or can it all be included on the one $results?

Thanks.

#23

By The Geek on 10-05-2006, 06:46 AM

No, however your query should be more like this one:

PHP Code:


			
$results = $db->query_read("SELECT g.header_image, t.title, t.views, t.replycount, t.threadid FROM " . TABLE_PREFIX . "thread t INNER JOIN " . TABLE_PREFIX . "gars g ON t.threadid = g.threadid WHERE t.visible=1 " . ($forumid ? " AND t.forumid in (-1$forumid) " : "") . "AND t.postuserid = $userinfo[userid] $orderby LIMIT " . (intval($limit) ? $limit : "5"));

Havent tested it, but it should be fine.

#24

By trana on 10-05-2006, 10:13 PM

Quote:

Originally Posted by The Geek

No, however your query should be more like this one:

PHP Code:


			
$results = $db->query_read("SELECT g.header_image, t.title, t.views, t.replycount, t.threadid FROM " . TABLE_PREFIX . "thread t INNER JOIN " . TABLE_PREFIX . "gars g ON t.threadid = g.threadid WHERE t.visible=1 " . ($forumid ? " AND t.forumid in (-1$forumid) " : "") . "AND t.postuserid = $userinfo[userid] $orderby LIMIT " . (intval($limit) ? $limit : "5"));

Havent tested it, but it should be fine.

But then I need to point to the proper forum right?

Like here?

Code:

<img alt=\"\" src='forum/" . ($info[$result['threadid']]['header'] == "" ? $this->settings['url_to_header_images'] . '/' . $this->type['default_image'] : $info[$result['threadid']]['header']) . "' style='border: 0px #000000;padding:0px;' />

#25

By The Geek on 10-06-2006, 06:23 AM

How are you trying to make it look?

#26

By trana on 10-06-2006, 07:28 PM

I just want to show the header image in a row next to the title. I can work out the formatting of the $bits to get it to look like the rest of my page, but I can't seem to merge how you derived the location of the header files. It would be easy if I could just call it like I can do with $avatar.

Last edited by trana; 10-06-2006 at 07:30 PM..

#27

By The Geek on 10-07-2006, 10:57 PM

oh... hold on... you're not after the forum name, but after the header image? The header image is called header_image not header. Try that.

#28

By trana on 10-08-2006, 01:49 AM

Quote:

Originally Posted by The Geek

oh... hold on... you're not after the forum name, but after the header image? The header image is called header_image not header. Try that.

Right, but the header images are based on your own directory structure right? So I need to put in the directory name as well? I'm using the CMPS GARS block as an example of how to call the header image and it has a whole bunch of stuff with the admin settings and $this (???) which are required to point to the actual header image. Is there another way?

Thanks Geek!

#29

By The Geek on 10-08-2006, 10:12 AM

Hang fire and Ill retweak this to include the option to display a header image

Release Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Release	Release Starter	Category	Comments	Last Post
new user need info	jskoh	Geek Article and Review System	1	10-13-2009 06:58 PM
Info Block	abrecher	Geek Gazette	1	06-06-2009 08:41 AM
Please Info	AES	Geek Article and Review System	3	06-09-2006 02:15 PM
Featured/Latest/Top Active/Top Read Tutorials showing wrong thing	Azhria Lilu	Geek Article and Review System	5	05-22-2006 08:28 PM
How do I show top X by ratings (top.php)	fyjpm	Geek Article and Review System	1	03-22-2006 05:51 PM