vb.org Archive - Add-On Releases - Forum Members (membelist.php)

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Add-On Releases - Forum Members (membelist.php) (https://vborg.vbsupport.ru/showthread.php?t=274248)

BadgerDog

04-21-2012 09:35 AM

Quote:

Originally Posted by ChrisTERiS (Post 2322126)

Currently I haven't installed somewhere a demo for this mod.

Chris

Thanks ...

Is there someplace I can go to buy the PRO version of this mod?

Regards,
Doug

Christos Teriakis

04-21-2012 10:03 AM

Quote:

Originally Posted by BadgerDog (Post 2322174)

Thanks Chris ... I understand ... :)

Is there somewhere in the plugins or code where I could add an "if usergroup = " type statement that would force it to include a specific set of usergroups for its calculations?

Appreciate your work ...

Regards,
Doug

You need to edit memberlist.php. An example for Top posters last week (lines 219-240) is showing below:

Code:

  // Week's Top Posters

// Put the usergroupids that you want to include

$include_groups = array(2,6,8);

  if ($vbulletin->options["forummembers_week"] == '1') {

      $timelimit = time() - 7 * 24 * 60 * 60;

      $mostactiveweek_get = $db->query_read("

      SELECT COUNT(post.dateline) AS postcount, post.userid,

      user.userid, user.username, user.lastpostid, user.posts, user.usergroupid

      FROM " . TABLE_PREFIX . "post AS post

        JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)

      WHERE user.posts != '0' AND user.usergroupid IN($include_groups) AND post.dateline>'".$timelimit."'

      GROUP BY post.userid

      ORDER BY postcount DESC

        LIMIT $limit

      ");

      $users = array();

      while($user = $db->fetch_array($mostactiveweek_get))

      {

                $users[] = $user;

            $totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post WHERE dateline>'".$timelimit."'");

            $mostactiveusersweek = printUsers($users, $vbulletin->options['forummembers_week_text'], 2, $totalposts['postcount']);

            unset($users);

      }

  }

Hope that it helps.

Chris

BadgerDog

04-21-2012 10:13 AM

Quote:

Originally Posted by ChrisTERiS (Post 2322182)

You need to edit memberlist.php. An example for Top posters last week (lines 219-240) is showing below:

Code:

  // Week's Top Posters

// Put the usergroupids that you want to include

$include_groups = array(2,6,8);

  if ($vbulletin->options["forummembers_week"] == '1') {

      $timelimit = time() - 7 * 24 * 60 * 60;

      $mostactiveweek_get = $db->query_read("

      SELECT COUNT(post.dateline) AS postcount, post.userid,

      user.userid, user.username, user.lastpostid, user.posts, user.usergroupid

      FROM " . TABLE_PREFIX . "post AS post

        JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)

      WHERE user.posts != '0' AND user.usergroupid IN($include_groups) AND post.dateline>'".$timelimit."'

      GROUP BY post.userid

      ORDER BY postcount DESC

        LIMIT $limit

      ");

      $users = array();

      while($user = $db->fetch_array($mostactiveweek_get))

      {

                $users[] = $user;

            $totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post WHERE dateline>'".$timelimit."'");

            $mostactiveusersweek = printUsers($users, $vbulletin->options['forummembers_week_text'], 2, $totalposts['postcount']);

            unset($users);

      }

  }

Hope that it helps.

Chris

It does Sir .. :)

Thank you ... very gracious of you to take the time to do this ...

Regards,
Doug

BadgerDog

04-21-2012 12:59 PM

Hi Chris ... :)
'
Ok, I made the changes, but now get this SQL error?

Did I miss something?

Quote:

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid,
user.userid, user.username, user.lastpostid, user.posts, user.usergroupid
FROM post AS post
JOIN user AS user ON (post.userid = user.userid)
WHERE user.posts != '0' AND user.usergroupid IN(Array) AND post.dateline>'1334411824'
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT 4;

MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Request Date : Saturday, April 21st 2012 @ 09:57:03 AM
Error Date : Saturday, April 21st 2012 @ 09:57:04 AM
Script : http://www.xxxx.com/memberlist.php
Referrer : http://www.xxxx.com/index.php
IP Address : xx.xxx.xxx.xxx
Username : Tester
Classname : vB_Database
MySQL Version : 5.0.95

Thanks...

Regards,
Doug

By the way, here's the code the way I changed it...

Quote:

// Week's Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,9,10);
if ($vbulletin->options["forummembers_week"] == '1') {
$timelimit = time() - 7 * 24 * 60 * 60;
$mostactiveweek_get = $db->query_read("
SELECT COUNT(post.dateline) AS postcount, post.userid,
user.userid, user.username, user.lastpostid, user.posts, user.usergroupid
FROM " . TABLE_PREFIX . "post AS post
JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE user.posts != '0' AND user.usergroupid IN($include_groups) AND post.dateline>'".$timelimit."'
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT $limit
");
$users = array();
while($user = $db->fetch_array($mostactiveweek_get))
{
$users[] = $user;
$totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post WHERE dateline>'".$timelimit."'");
$mostactiveusersweek = printUsers($users, $vbulletin->options['forummembers_week_text'], 2, $totalposts['postcount']);
unset($users);
}
}
// Month's Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,9,10);
if ($vbulletin->options["forummembers_month"] == '1') {
$timelimit = time() - 30 * 24 * 60 * 60;
$mostactivemonth_get = $db->query_read("
SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle,
COUNT(".TABLE_PREFIX."post.postid) AS postcount
FROM ".TABLE_PREFIX."user
LEFT JOIN ".TABLE_PREFIX."post
ON ".TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.u serid
AND dateline>'".$timelimit."'
WHERE user.usergroupid IN($include_groups)
GROUP BY ".TABLE_PREFIX."user.userid
ORDER BY postcount DESC
LIMIT $limit");
$users = array();
while($user = $db->fetch_array($mostactivemonth_get))
$users[] = $user;
$totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post WHERE dateline>'".$timelimit."'");
$mostactiveusersmonth = printUsers($users, $vbulletin->options['forummembers_month_text'], 2, $totalposts['postcount']);
unset($users);
}
// Overall Top Posters
// Put the usergroupids that you want to include
$include_groups = array(2,9,10);
if ($vbulletin->options["forummembers_overall"] == '1') {
$mostactive_get = $db->query_read("
SELECT userid, username, usertitle, posts AS postcount
FROM ".TABLE_PREFIX."user
WHERE user.usergroupid IN($include_groups)
ORDER BY posts DESC
LIMIT $limit");
$users = array();
while($user = $db->fetch_array($mostactive_get))
$users[] = $user;
$totalposts = $db->query_first("SELECT COUNT(postid) AS postcount FROM ".TABLE_PREFIX."post");
$mostactiveusers = printUsers($users, $vbulletin->options['forummembers_overall_text'], 2, $totalposts['postcount']);
unset($users);
}

Christos Teriakis

04-22-2012 09:55 AM

Hello,

A new update (ver.1.2.0) is available for download. In this version there is an extra setting where you can set which usergroup(s) to include in the TOP's blocks. The earlier version was counting posts only from Registered Members (usergroupid=2).

To upgrade upload all the files and import product-forummembers.xml selecting to overwrite.

Chris

Christos Teriakis

04-22-2012 09:57 AM

Quote:

Originally Posted by BadgerDog (Post 2322223)

Hi Chris ... :)
'
Ok, I made the changes, but now get this SQL error?

Did I miss something?

Thanks...

Regards,
Doug

From now on you don't need any custom changes as I added a new setting for this reason.

Chris

Nirjonadda

04-22-2012 10:04 AM

Where is PRO version link of this mod?

Christos Teriakis

04-22-2012 10:24 AM

Quote:

Originally Posted by Nirjonadda (Post 2322443)

Where is PRO version link of this mod?

http://www.vbulleton.com

Chris

BadgerDog

04-22-2012 12:00 PM

Quote:

Originally Posted by ChrisTERiS (Post 2322441)

From now on you don't need any custom changes as I added a new setting for this reason.

Chris

Thank you Chris ... :)

Excellent addition for us... appreciate it ...

Do you have PayPal?

Regards,
Doug

Christos Teriakis

04-22-2012 02:11 PM

Quote:

Originally Posted by BadgerDog (Post 2322464)

Thank you Chris ... :)

Excellent addition for us... appreciate it ...

Do you have PayPal?

Regards,
Doug

Thank you Doug,

Actually, I have only PayPal:D

Chris

BadgerDog

04-25-2012 04:12 PM

Anyone else not seeing background color highlighting when a user is Featured?

Also anyone know how the Administrator can EDIT user ratings, if someone makes an incorrect entry?

Thanks for any feedback ... :)

Regards,
Doug

faisaly.com

04-26-2012 01:46 AM

Mod does not work showing any usergroups on top, breaks up the borders badly and you cannot disable this mod.... have to uninstall I guess... Hope it all works out for ya...Also anyone that is going to try this backup your memberlist.php before installing so if you do uninstall you can reupload or you won't display a thing...

Tyran1

04-26-2012 02:02 AM

Please this for 3.8.7

Christos Teriakis

04-26-2012 04:55 AM

Quote:

Originally Posted by faisaly.com (Post 2323593)

Mods works fine, if you select from admincp which usergroups to show on the top. Mod can be disable or uninstall, just keeep in mind that you need to upload the original (vB) memberlist.php.

Chris

megabink

04-26-2012 06:55 AM

I can confirm that the mod works perfectly on my forum.(4.1.12)
It has some small bugs but it's not the mods fault it's the custom style i am using but i can live with that.
You can see for your self: http://www.megathemer.x10.mx
Thanks Chris for your hard work.

Christos Teriakis

04-26-2012 07:15 AM

Quote:

Originally Posted by megabink (Post 2323637)

Thank you for your supporting words. Have told many times that unfortunatelly my knowledge in design is average or even lower. I visited your site and I seen the cyan border around the blocks. Its my mistake as I've used hand coded color.

I think that I need to find a designer for correcting my mods. I don't even like to see such bad color combinations.

Edited: I also found some phrases missing (eg Join at). I think that I need to give a look on it.

Chris

megabink

04-26-2012 07:26 AM

Quote:

Originally Posted by ChrisTERiS (Post 2323638)

Thanks Chris.
It would be nice to fix some bugs,but like I told you before I can live with it.
So no worries mate,we have to remember that the most mods are free and that we have to be happy for it.

Christos Teriakis

04-26-2012 07:52 AM

Quote:

Originally Posted by megabink (Post 2323639)

we have to remember that the most mods are free and that we have to be happy for it.

Free doesn't gives me the excuse to deliver rubishes. Some missing features, yes is acceptable. But features that I'm including, I want them to work perfectly.

Chris

megabink

04-26-2012 08:18 AM

Quote:

Originally Posted by ChrisTERiS (Post 2323642)

Free doesn't gives me the excuse to deliver rubishes. Some missing features, yes is acceptable. But features that I'm including, I want them to work perfectly.

Chris

Yes i understand Chris i am also a perfectionist.
But in the meantime we have a working mod and updates are to improve things.
I am sure you will find a solution to fix the borders and the phrases in the next update.
Grt John.

faisaly.com

04-26-2012 04:22 PM

Quote:

Mods works fine, if you select from admincp which usergroups to show on the top. Mod can be disable or uninstall, just keeep in mind that you need to upload the original (vB) memberlist.php.

Mod does not work fine, no usergroups showed using vb4.1.11, borders and styles missing, and could not disable... and yes free is free... but if it causes user problems... or messes up the forum and a users work... no one will be happy... please change the title of this mod to (beta) or do not release....

Thank You...

Christos Teriakis

04-26-2012 05:05 PM

Quote:

Originally Posted by faisaly.com (Post 2323776)

Mod does not work fine....

First of all, I'll appreciate if don't use bold letters. I can read normal fonts fine.
Second. This mod works with ALL versions of 4x. Has released by Mary juts 10 days of the first release of 4.0.0. So, it's not a version problem.

Check if the usergroups that you've selected have been saved. As for disabling. It depends on what you want to see. If you just disable it WITHOUT UPLOADING the original vB memberlist.php for sure you'll see it again because memberlist.php is a file that must exist in you directory. If you've uploaded the original vB file and still you're seeing the screens of my mod, just clear your browser's cache.

As for the styling issues. Is it compatible with vB Default style? If yes, and you want it to appear ok with your custom template, then contact your designer or company from where you bought it.

Thank you
Chris

BirdOPrey5

06-01-2012 06:06 PM

Hello All,

I will be taking over this mod for ChrisTERiS. I am investigating how it will best work, I may end up starting my own mod thread with a slightly updated version in the next few days.

Please stand by while I figure out the logistics.

Thank you again to ChrisTERiS for this great mod!

BadgerDog

06-01-2012 06:13 PM

Thanks Joe ... :)

I use and like it, but it has some rough edges ...

Regards,
Doug

pantani

06-04-2012 09:15 AM

i have problem 4.2
I only see the letters, but when i click on a letter to see the members, nothing happens?

https://vborg.vbsupport.ru/external/2012/06/24.png

Christos Teriakis

06-04-2012 09:59 AM

Quote:

Originally Posted by pantani (Post 2336415)

i have problem 4.2
I only see the letters, but when i click on a letter to see the members, nothing happens?

Have you set which usergroups to show? You can find it in admincp below the General settings (left side menu).

Chris

pantani

06-04-2012 10:12 AM

Yes i have, but still nothing :(
Can't see any member?

pantani

06-04-2012 10:24 AM

i uninstalled and reinstalled, but now i get this:
But no index with letters to look for members:

https://vborg.vbsupport.ru/external/2012/06/23.png

Christos Teriakis

06-04-2012 10:53 AM

Quote:

Originally Posted by pantani (Post 2336428)

i uninstalled and reinstalled, but now i get this:
But no index with letters to look for members:

The letter index appears only when you click in any of the usergroups. But I can't see the usergrousp bar at the top, so once more I'm saying to set which usergroups to show.

Chris

pantani

06-04-2012 11:25 AM

Quote:

Originally Posted by ChrisTERiS (Post 2336420)

Have you set which usergroups to show? You can find it in admincp below the General settings (left side menu).

Chris

I'm not sure where you mean, in usergroups i gave permision to the most usergroups, where else?
Thanks

BirdOPrey5

06-04-2012 12:46 PM

On the Admin CP Sidebar there is a new menu group called Forum Members

Expand it and click on Usergroups

On that page you then select the usergroups Chris is talking about.

(I missed it to my first time.)

pantani

06-04-2012 02:34 PM

ok, the search is working, but still not showing the letter index, and selected the users who are able to see it?

pantani

06-05-2012 04:56 AM

Chris? You know what could be the probs, or what to do?

Naijasite

06-06-2012 01:14 PM

please upgrade this memberlist product to 4.2.0

doubleclick

06-29-2012 03:13 PM

Can you put a direct link to the PRO version? I noodled around www.Qapla.com and can't find any mention of it.

thanks,
dc

BirdOPrey5

07-01-2012 11:22 AM

Hello,

I have not yet updated the Pro version so it is not yet available. This mod recently underwent a change of ownership.

I will post an updated with a new free version and link to pro version when it is ready.

BirdOPrey5

11-03-2012 07:44 PM

Mod returned back to ChrisTERiS.

All times are GMT. The time now is 08:06 AM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01314 seconds Memory Usage 1,849KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (19)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (36)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: