PDA

View Full Version : Forum Home Enhancements - User's Social Groups on Forum Home (like forumlist, fully templated)


cellarius
01-30-2009, 10:00 PM
Available for vB4:
https://vborg.vbsupport.ru/showthread.php?t=221581



What does it do?

Shows all social groups the actual user is a member of or is subscribed to, just below the forumlist (or anywhere else on forumhome). If there are new messages, the corresponding forum statusicon is highlighted - just like in forumlist.
If there are no groups to show, you can choose to show a teaser message.

Things to set in AdminCP/Options:
show member of / subscribed to /nothing
sort by name or last message date
limit max number of groups shown, then link to appropriate page (grouplist for members, usercp for subscribers)
restrict use by usergroup
show a teaser message if there are no groups to show
show buttons to open new discussion etc.
apply custom css to grouptitle
trim group description to max length or disable
parse bbcode in group descriptions
use a different set of statusicons for groups than for forums
use .png for statusicons instead of .gif (global in AdminCP, per style in groupsbit template)
show groupicon instead of statusicon

Looks

Out of the box: I tried to copy the standard look of the forumlist on forumhome.
As requested, it is now fully templated (following the forumbit-scheme) for easy adjustment to custom styles.
See the screenshot of a modified example in this post (https://vborg.vbsupport.ru/showpost.php?p=1734791&postcount=45).

Install/upgrade

Upload folder "images" to your forum root (can be omitted if you do not want to use the buttons).
Import the product file.
Check settings in AdminCP->Options->Social Groups on Forumhome.

Template edit
Will be automatically inserted below your forums list if you are using TMS (https://vborg.vbsupport.ru/showthread.php?t=152931), which I highly recommend to do. If not:

Find:
<!-- /main -->Above add:
$cel_social_groupsIf you don't like it there, you can insert $cel_social_groups anywhere you like on forumhome.


Technical stuff
1 product file that adds
+ 3 templates (following the forumbit-scheme)
+ 3 plugins
+ adds 2 queries to forumhome (only if groups are shown, of course).
+ a bunch of phrases (prefix: cel_sgfh_).
+ 4 png-buttons, taken from the silk icon set (http://www.famfamfam.com/lab/icons/silk/).


Limitations
Marking of new messages only works with database, not with cookie based marking of read threads (-> AdminCP setting)
Explanation: This mod relys on the information in the database when a discussion was last read by the actual user. If you rely on cookies for this, you can use this mod anyway, but there will be no marking if there are unread messages by changed statusicons.
3.7 Discussion groups will show up as "no messages yet" as long as there was no message written under 3.8
Explanation: When converting the old 3.7 message board into a discussion, Jelsoft was a little bit slack. While normally all the information about the last updated discussion is stored in the socialgroups table, this information is not entered for the auto-created discussion. For example: The discussion ID for the last updated discussion simply is 0 instead of the actual id of the auto created discussion. Therefore, this mod can not retrieve the information it needs since the discussion is not linked to the social group. This only changes when the first message under 3.8 is written.
Not a bug note: In vB 3.8 there was an issue where the last discussion title was not correctly updated by vB in the socialgroup table. This would lead this mod to show a wrong last discussion title under some circumstances. This was resolved in 3.8.1.
See Bugtracker: http://www.vbulletin.com/forum/project.php?issueid=27176Version history

v 1.4
+ some bugfixes
+ option to turn teaser message off
+ option to show several buttons: to start a new discussion - see the group's members list - see the group' photos (only shown if there are any attached pictures) - unsubscribe (only if subscribed groups are shown) (Thanks to glorify (https://vborg.vbsupport.ru/showpost.php?p=1736102&postcount=54))
1.4.1: Template/Style error in Google Chrome fixed

v 1.3
+ now fully templated. New templates: forumhome_cel_social_groups_groupsbit and forumhome_cel_social_groups_lastmsgby.
1.3.1: Link to user profile error fixed

v 1.2
+ added option to sort groups by date of last message
+ added missing phrase

v 1.1
+ improved database query
+ limitations somewhat lessened
+ added settings page to AdminCP
+ choose whether to show groups the user is a member of or subscribed to
+ limit number of groups shown, then link to appropriate page
+ restrict use by usergroup
+ some minor bugfixes


Planned features (no promises made!)

none atm

option to use a set of different statusicons for the groups
option to use the social group's icon instead of the statusicon
and to go with that, for additional/substitunional unread marking, possibility to add css markup to the social group's title


Translations
Polish (https://vborg.vbsupport.ru/showpost.php?p=1788526&postcount=99) (thanks to RadioErewan (https://vborg.vbsupport.ru/member.php?u=243082))
German (https://vborg.vbsupport.ru/showpost.php?p=1795672&postcount=118) (thanks to redlabour (https://vborg.vbsupport.ru/member.php?u=51916))
Screenshots:

AdminCP
Forumhome (with groupicon and css formatted groupname, bbcode in description parsed)
Forumhome (with forum statusicons and trimmed description -> bbcode not parsed)### Don't forget to click install! ###
(No support if you don't)

cellarius
01-31-2009, 03:22 PM
Reserved

digicom
01-31-2009, 03:23 PM
Install
Just import product file.

there is no product file attached??

cellarius
01-31-2009, 03:34 PM
there is no product file attached??
Well, just give a man a few seconds to prepare ;)

Subah
01-31-2009, 03:48 PM
Thank you

Well, just give a man a few seconds to prepare ;)

looooooool

RvG2
01-31-2009, 03:58 PM
FINALLY! :) gosh you are heaven sent here.

I have installed it, I am a member on one of my groups there were new posts but still i did not see it forumhome.

Have I done wro ng?

cellarius
01-31-2009, 04:15 PM
Did you do the template edit?

RvG2
01-31-2009, 04:17 PM
yes it shows only You are currently not a member of a social group.
See what you are missing

although there are new posts in the group.

RvG2
01-31-2009, 04:22 PM
what is this? reisekalender.php

cellarius
01-31-2009, 06:16 PM
what is this? reisekalender.php
Sorry, a relict from another of my mods where I took this snippet from :o

Please re-download and re-import the product file. Should be fixed.

Concerning your other problem: Are you a member of these social groups and have you read the limitations in the fist post?

Mark.B
01-31-2009, 06:56 PM
Needs a bit of tidying up of the html but works fine.

Would be nice if it could pull a thumbnail of the group icon somehow, I did have a play but I get all in a tizz with database queries after a while.

cellarius
01-31-2009, 08:33 PM
Uploaded a new version of the product with a corrected xml. If you downloaded before, please reinstall.

RvG2
02-01-2009, 01:52 PM
yes this works perfectly. :)

TalkTemplate
02-01-2009, 02:22 PM
looks nice i will try it!

glorify
02-01-2009, 04:17 PM
Any way you could have it so only the subscribed groups show?

cellarius
02-01-2009, 04:44 PM
:erm: Hm, that's the way it's designed and it works - at least for me...

glorify
02-01-2009, 04:51 PM
Naw--I have all groups showing I am a member of

RvG2
02-01-2009, 05:11 PM
request: option to control how many groups to show in forumhome with a link to "show all group messages" or the likes...

Phaedrus
02-01-2009, 05:18 PM
Excellent. With TMS it was just a product import!

Sweet!

cellarius
02-01-2009, 05:26 PM
@glorify: Ah, ok, I see where you make the difference, of course: member of vs. subscribed.

Try replacing the database query at the top of the plugin with this:

*** Code removed, it's a feature now ***

Untested, let me know if it works.

RvG2
02-01-2009, 05:38 PM
cellarius, i think you can make it an option in admincp to select whether we want to show group messages as member or subscribed only.

Phoenix81377
02-01-2009, 05:59 PM
Works great for me! Thank you!

glorify
02-01-2009, 07:39 PM
@glorify: Ah, ok, I see where you make the difference, of course: member of vs. subscribed.

Try replacing the database query at the top of the plugin with this:

$result = $db->query_read("
SELECT
socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, socialgroup.lastpost, socialgroup.lastposter, socialgroup.lastposterid, socialgroup.lastgmid, socialgroup.visible, socialgroup.lastdiscussion, socialgroup.discussions, socialgroup.members,
discussionread.readtime
FROM " . TABLE_PREFIX . "socialgroup as socialgroup
LEFT JOIN " . TABLE_PREFIX . "discussionread as discussionread
ON socialgroup.lastdiscussionid = discussionread.discussionid
INNER JOIN " . TABLE_PREFIX . "socialgroupmember as socialgroupmember
ON socialgroup.groupid = socialgroupmember.groupid
INNER JOIN " . TABLE_PREFIX . "subscribegroup as subscribegroup
ON socialgroup.groupid = subscribegroup.groupid
WHERE socialgroupmember.userid = " . $vbulletin->userinfo['userid'] . " AND subscribegroup.userid = " . $vbulletin->userinfo['userid'] . "
GROUP BY name
ORDER BY name ASC, lastpost DESC
");
Untested, let me know if it works.
Will let you know. Thanks :)

One question---if there are no subscribed or memberships, does the box not show at all?
cellarius, i think you can make it an option in admincp to select whether we want to show group messages as member or subscribed only.
I like it.

cellarius
02-02-2009, 06:33 AM
From mod description:
What does it do?
[...]
If a user is not a member of a social group, it will display a text referring to the groups.

cellarius
02-02-2009, 11:37 AM
============== Important upgrade notes ==============
For upgrading from v1.0, please uninstall old version first!
If you changed templates manually, please note that the variable to insert has changed.

v 1.1
+ improved database query
+ limitations somewhat lessened
+ added settings page to AdminCP
+ choose whether to show groups the user is a member of or subscribed to
+ limit number of groups shown, then link to appropriate page
+ restrict use by usergroup
+ some minor bugfixes

glorify
02-03-2009, 12:04 AM
Man--I was almost where I wanted this but the only problem I have is the $cel_sgfh_output. I wanna be able to mod the look a tad easier to reflect my style---any way of making the output a template? I hate having to modify the plugin.

I really love the mod, and I believe it's something vb should use as stock.

glorify
02-03-2009, 03:48 AM
Found a bug---

When it displays (yes I have thread marking enabled correctly), It shows the last group thread, and the latest thread reply linked to the username.

Problem is, the last group thread and the latest group reply can be different. An example---

The last group thread was started 3 days ago (which is what the mod shows on forumhome). The latest reply was from a different thread tonight (which is linked to with the username on the forumhome.

Example of what it shows:

Thread Title 5 (started yesterday) shows it because it's the latest thread (still links to the latest reply though)
by Username (linked to Thread Title 1) linked to it because it's the latest reply

Keyser Soze
02-03-2009, 09:04 AM
Great mod. You forgot to phrase the string "No messages yet". Please add a vbulletin-phrase for this string.

cellarius
02-03-2009, 12:12 PM
Sorry, I corrected that. Product file updated.

Diana Notacat
02-03-2009, 02:18 PM
This is working out WONDERFULLY for my boards so far! We needed this so much!

I would love to see an option where it will list your groups by "Newest messages". That way the most recently update groups are on the main page and people can click "Show More" to see the rest of their groups. (I'm not sure if this is already a feature, cause right now it's listing the groups in a random looking order.)

cellarius
02-03-2009, 02:30 PM
Hm, might it be that right now it's listing the groups in an alphabetical looking order ;)

Yep, that should be doable. I'll look into it.

cellarius
02-03-2009, 02:56 PM
This is working out WONDERFULLY for my boards so far! We needed this so much!

I would love to see an option where it will list your groups by "Newest messages". That way the most recently update groups are on the main page and people can click "Show More" to see the rest of their groups. (I'm not sure if this is already a feature, cause right now it's listing the groups in a random looking order.)

Hm, might it be that right now it's listing the groups in an alphabetical looking order ;)

Yep, that should be doable. I'll look into it.
Check out version 1.2, with special regards to Diana, apparantly not one of the felidae ;)

Diana Notacat
02-03-2009, 02:57 PM
Hm, might it be that right now it's listing the groups in an alphabetical looking order ;)

Yep, that should be doable. I'll look into it.

YAY~! Thank you, you wonderful coder you! <3

RvG2
02-03-2009, 04:18 PM
cell, you are one of remarkable coders here in vb.org!

thank you so much :)

glorify
02-03-2009, 04:49 PM
Thanks a ton bro. I'll post a screen of my modded look later tonight when I get home.

Kudos.

glorify
02-04-2009, 12:11 AM
Found a bug---

When it displays (yes I have thread marking enabled correctly), It shows the last group thread, and the latest thread reply linked to the username.

Problem is, the last group thread and the latest group reply can be different. An example---

The last group thread was started 3 days ago (which is what the mod shows on forumhome). The latest reply was from a different thread tonight (which is linked to with the username on the forumhome.

Example of what it shows:

Thread Title 5 (started yesterday) shows it because it's the latest thread (still links to the latest reply though)
by Username (linked to Thread Title 1) linked to it because it's the latest reply

Sorry, I corrected that. Product file updated.

Same problem :(

cellarius
02-04-2009, 04:32 AM
Yeah, I see where that might be a bug. I somehow overlooked that bug report, sorry.
I'll look into it.

cellarius
02-04-2009, 05:25 AM
Found a bug---

When it displays (yes I have thread marking enabled correctly), It shows the last group thread, and the latest thread reply linked to the username.

Problem is, the last group thread and the latest group reply can be different. An example---

The last group thread was started 3 days ago (which is what the mod shows on forumhome). The latest reply was from a different thread tonight (which is linked to with the username on the forumhome.

Example of what it shows:

Thread Title 5 (started yesterday) shows it because it's the latest thread (still links to the latest reply though)
by Username (linked to Thread Title 1) linked to it because it's the latest reply

I tested this on two test boards and my live board, and I don't have this issue. That made me look into the bug tracker: This is not a bug of this mod, but was a bug in vB 3.8.0 that was fixed in 3.8.1, so please update your forums - that will resolve the issue.

http://www.vbulletin.com/forum/project.php?issueid=27176

Keyser Soze
02-04-2009, 06:13 AM
Can someone please explain why this mod says "no messages yet" for almost every group, although there are aready some messages in these groups (see attached screenshot)?

cellarius
02-04-2009, 07:06 AM
Just read the mod description, please.
Limitations
3.7 Discussion groups will show up as "no massages yet" as long as there was no message written under 3.8
Explanation: When converting the old 3.7 message board into a discussion, Jelsoft was a little bit slack. While normally all the information about the last updated discussion is stored in the socialgroups table, this information is not entered for the auto-created discussion. For example: The discussion ID for the last updated discussion simply is 0 instead of the actual id of the auto created discussion. Therefore, this mod can not retrieve the information it needs since the discussion is not linked to the social group. This only changes when the first message under 3.8 is written.

Keyser Soze
02-04-2009, 07:14 AM
I apologize :o
Thanks again for this great mod. :)

cellarius
02-04-2009, 09:08 AM
No need to apologize. BTW, great movie. The Usual Suspects, I mean. :)

glorify
02-04-2009, 11:08 AM
I was wondering if this could be a 3.8 to 3.8.1 issue. You may change the mod version to 3.8.1.

Thanks a ton for your work and also going to all templates--makes it a tad easier to mod.

cellarius
02-04-2009, 11:32 AM
I was wondering if this could be a 3.8 to 3.8.1 issue. You may change the mod version to 3.8.1.
Yep, you got a point there. I'll do that.

glorify
02-05-2009, 01:22 AM
Promised a screen, here it is. Added links to start a new discussion, unsubscribe, view members, and view photos :)

Thanks man.

cellarius
02-05-2009, 04:40 AM
Promised a screen, here it is. Added links to start a new discussion, view members, and view photos :)

Thanks man.
Hey, looks great! I might steal that idea with the buttons, for some later release, if I may - really like it :up:

BTW - still interested in showing the group icon? I was thinking of making showing them an option in a later release.

glorify
02-05-2009, 11:06 AM
Thanks! Oh yeah--no problem :)

I think someone else was interested in the group icon. I just wanted it to look my default stuff.

bbcentral
02-05-2009, 01:39 PM
Proudly marked as installed!

Social Groups almost stayed turned off because vBulletin has no notification options built-in for them, at least this way my members will be able to keep track without having to manually remember to check the page!

I made a couple of tiny modifications, I changed the templates to match my forum better ("Last Post" is the final column), and also I copied one of the IF statements to surround the entire main template. So now the entire box doesn't appear unless you are a member of a social group, because I don't want the 99% of my members who aren't in a social group to get constantly reminded what they're missing out on :P

Keep up the great work, you may have just single-handedly saved Social Groups for many vBulletin users :D

glorify
02-05-2009, 05:26 PM
I copied one of the IF statements to surround the entire main template. So now the entire box doesn't appear unless you are a member of a social group
I did something similar as well. Shows up if only something is subscribed to. Debated, tho, because as is, I think it does encourage people to join groups.

Chance4Today
02-06-2009, 04:20 AM
Thanks :)

cellarius
02-06-2009, 04:28 AM
I made a couple of tiny modifications, I changed the templates to match my forum better ("Last Post" is the final column), and also I copied one of the IF statements to surround the entire main template. So now the entire box doesn't appear unless you are a member of a social group, because I don't want the 99% of my members who aren't in a social group to get constantly reminded what they're missing out on :P
I'll make that an option for the next version.

cellarius
02-06-2009, 04:43 AM
Added a planned features list.

Diana Notacat
02-06-2009, 10:14 AM
I am just going to sing my praises again! : D Since I installed the mod people are actually remembering they're in groups and posting in them now! Loves! <3

glorify
02-06-2009, 01:55 PM
cellarius, I added an unsubscribe link as well and updated the screen (https://vborg.vbsupport.ru/showpost.php?p=1734791&postcount=45).

If you are interested in the link code for each without having to search, here they are:

New Discussion
<a href="group.php?$session[sessionurl]do=message&amp;groupid=$cel_groups[groupid]">

Unsubscribe
<a href="group.php?$session[sessionurl]do=unsubscribe&amp;groupid=$cel_groups[groupid]">

View Members
<a href="group.php?$session[sessionurl]do=viewmembers&amp;groupid=$cel_groups[groupid]">

View Photos

<a href="group.php?$session[sessionurl]do=grouppictures&amp;groupid=$cel_groups[groupid]">

And, you may not need these, but attached are the icons I used, from FAMFAMFAM.

cellarius
02-06-2009, 02:46 PM
Hey glorify, thanks for this - this safes me some time. :)

And yes, I'll probably use the silk iconset, since that's the one I prefer, too (and have already used for other projects, for instance my photo popup mod). :up:

DanaRVT
02-07-2009, 09:20 AM
Found an error.... if you click on the members name under last msg posted by... it doesn't take you to their profile because instead of appending the userid it appends the user name.

member.php?u=usernamehere

^^Like such. Instead of

member.php?u=1

How do I fix that?

cellarius
02-07-2009, 10:38 AM
Found an error.... if you click on the members name under last msg posted by... it doesn't take you to their profile because instead of appending the userid it appends the user name.

member.php?u=usernamehere

^^Like such. Instead of

member.php?u=1

How do I fix that?
By reinstalling the product: Bugfix release 1.3.1

Thanks for reporting this!

For those with modified templates:

In template forumhome_cel_social_groups_groupsbit find:
member.php?$session[sessionurl]u=$cel_groups[lastposter]change to:
member.php?$session[sessionurl]u=$cel_groups[lastposterid]

DanaRVT
02-07-2009, 11:31 AM
Thanks for the fast fix! Proudly marked as installed!!

starman?
02-16-2009, 04:09 PM
Cellarius - excellent work. V.much appreciated. IMHO This has probably saved social groups for my site.

EDIT: It's been running approx 3 hours and I've never seen so much activity in the Social Groups. Seriously Thank You!

Glorify:f you are interested in the link code for each without having to search, here they are:

Love your little addition - I'd like to know which template should I edit & where to insert your code. (keep answers clean please ;) )

drsli
02-16-2009, 06:01 PM
Many thanks! :)

Merriweather
02-17-2009, 07:52 AM
It says I am not subscribed to any group discussions but I am... ?? How do I fix that? I've got the database forum markers on instead of cookies, is there something else to cause it to tell me I have no subscriptions?

cellarius
02-17-2009, 08:58 AM
It says I am not subscribed to any group discussions but I am... ?? How do I fix that? I've got the database forum markers on instead of cookies, is there something else to cause it to tell me I have no subscriptions?
This mod does not show subscribed group discussions but subscribed groups.

RvG2
02-17-2009, 01:35 PM
cellarius, is it possible to create a mod for group notifications?

Merriweather
02-17-2009, 01:55 PM
This mod does not show subscribed group discussions but subscribed groups.

Oh, duh.... now I just need to figure out how to subscribe to a group! :D

ETA: Do you mean be a member of a group? Because I am a member of 4 groups. I can't find any options to subscribe to a group... ???

cellarius
02-17-2009, 03:46 PM
No. Please read the description of this mod: It can show groups you are a member of or groups you are subscribed to. That's two different things.

But you may have missed this in the release notes for 3.8.1 (http://www.vbulletin.com/forum/showthread.php?t=298045):
Social Group Subscription Temporarily Disabled

Due to confusion over the functionality provided, vBulletin 3.8.1 has temporarily disabled the ability to subscribe to entire social groups. You may still subscribe to individual social group discussions.

We are planning to improve this feature and re-implement it for the release of vBulletin 3.8.2.

If you wish to re-enable the feature yourself, you can remove the HTML comment around the "subscribe to this group" link in the socialgroups_group template.So, just set this mod to show all groups the user is a member of, if you don't want to reenable groups subscription manually.

cellarius
02-17-2009, 03:48 PM
cellarius, is it possible to create a mod for group notifications?
Probably :)

But I guess you want to know whether I will make one. The answer to this is: No, sorry. It would be quite complicated to implement (as it would have to go into the system of the other notifications to make sense). Even tho I'd like to see that too, I just don't have the time at the moment. And hopefully we will see better integration in 4.0 :mad:

RvG2
02-17-2009, 06:10 PM
Yes you are right. vB4 is almost there...

itsheinz
02-19-2009, 07:03 AM
waaa its not showing in my home..someone help me.

Mukashi
02-19-2009, 11:21 PM
Getting an error with this mod currently. On the forum home page, while the block for the social groups displays, no discussions will, and it gives the user an error saying they're not a member of any social groups. Additionally, this error message is displayed at the top of the page.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 191

Julie
02-22-2009, 07:39 AM
Works like a charm, thanks! :)

Phoenix81377
02-22-2009, 07:19 PM
I installed the latest version and I am running 3.8.1 but I am still having this issue: the last discussion title not correctly updated by vB in the socialgroup table.

What could I be missing?

aztecboi2003
02-24-2009, 01:25 AM
Great mod, but how do I get my last post to show up underneath the forum title like that screenshot shows?

Merriweather
03-12-2009, 05:24 AM
Ok, so I reinstalled and now the issue is that it's not displaying properly -- the column titles (Groups, Last Post, members, Post) are showing ABOVE the "Subscription Updates" table header, but the forumhome_cel_social_groups_groupsbit template doesn't seem to include all of that code, so where is it getting the rest?

Man, did that even make any sense??

Merriweather
03-12-2009, 05:41 AM
ETA ~ Ok, that must be the vB default as I see in the screen shot, but my forums are the opposite... is there more than one template I need to edit for this one?

Found it: forumhome_cel_social_groups :)

McCarroll21
03-12-2009, 10:45 AM
I'm loving this, but I'm having a problem with getting the forum icon to show correctly. When there is a new post, the forum marker doesn't change. It shows the forum marker for one without a new post. Any ideas?

Saidinou
03-12-2009, 03:56 PM
Hello and thank you for this product,


I have a problem when vBseo is enabled. All the latest post are linked as:

/forum/group.php

sinucello
03-12-2009, 05:38 PM
Hi,

this sounds very good. But I`m a bit afraid that it makes my already loooong forum start page even longer. I guess I`ll have to add another mod for a tabbed start page before I can use this one ;-).

all the best,
Sacha

hoopsta
03-12-2009, 05:42 PM
Hi,

this sounds very good. But I`m a bit afraid that it makes my already loooong forum start page even longer. I guess I`ll have to add another mod for a tabbed start page before I can use this one ;-).

all the best,
Sacha

haha yes you do have a ton of forums!

Dontom
03-13-2009, 11:00 AM
if you want to disable the teaser for users without subscriptions the just put a
<if condition="$cel_groups_hasresults">

template

</if>

around your forumhome_cel_social_groups template

hoopsta
03-14-2009, 04:24 AM
good idea, but what is this eror message all about?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 246

hoopsta
03-15-2009, 07:18 PM
good idea, but what is this eror message all about?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 246

anyone?

silly rabbit
03-18-2009, 10:46 AM
good idea, but what is this eror message all about?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 246


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 378

hoopsta, getting same and have seen it before . . . pretty sure it has to do with running mysqli (5.0.67) - see here (http://dev.mysql.com/doc/refman/5.0/en/mysql-num-rows.html), will investigate further. Edit "Plugin Manager-> forumhome code -> forumhome_start" and the one reference is around line 97!
Rabbit

hoopsta, I upgraded to patch release 3.8.1 and still no avail! I did the following, simply comment "// " the function out and added "TRUE" ? ? ? It seems to be working ok (shows *last message*) but ? ? ? (hardly ideal!) "google" returned no satisfactory solution & vBulletin com was no help at all 'cause all they could suggest is "disable the plugin"!

I am also running PHP 5.2.6
// if (mysql_num_rows($result) > 0)
if (TRUE)

I also changed standard phrasing "New messages in my social groups" to " Latest messages in Your Social Groups" (function the same as original? :confused:)

hoopsta
03-18-2009, 11:36 PM
yea this is to bad because I could really use this hack on my forum

qbn720
03-19-2009, 04:22 AM
Installed and Nominated. Excellent add-on, I love it. Displaying them as forums is an exceptionally brilliant idea.

+ For the future versions of this hack, see if you can limit the description area for the social groups. It's only a minor disruption but it's absolutely worth it.

imedic
03-23-2009, 02:34 PM
Great product. Unfortunately I get on 3.8.1 the following error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 186

It does show the table but keeps saying "You are currently not a member of a social group." even if I am member / creator of usergroups.

I will keep a close eye for this one and install it when it will work for me.

smnet
03-23-2009, 03:52 PM
Great product. Unfortunately I get on 3.8.1 the following error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 186

It does show the table but keeps saying "You are currently not a member of a social group." even if I am member / creator of usergroups.

I will keep a close eye for this one and install it when it will work for me.

I am having the exact same issue almost.

Database read marking is on, i am a member of several groups and creator of several.

Nothing shows on forum home except a message which reads:-

You are currently not a member of a social group.
See what you are missing

Does anyone know why this mod doesnt work properly for me?

Edit: I've also subscribed to some new groups and still nothing shows.

Saidinou
03-23-2009, 04:22 PM
Hello,

can anyone tell me if links (last post) work with vBseo?

PrincessFiona
03-24-2009, 09:04 PM
perfect, thanks!

I don't suppose you could code something like this for the blogs that a member is subscribed to???? =)

Kris

Revan
03-30-2009, 11:38 AM
For those with the "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 186" error, open the forumhome code plugin and change
mysql_num_rows
to
$db->num_rows

Bit silly mistake, and there's some sessionurl variable mess-ups (using $session[sessionurl] when there's no parameter after "?" instead of just using $session[sessionurl_q] and no "?"), but overall it's a good mod and I'm glad I found it :)

imedic
04-08-2009, 08:12 AM
Thanks Revan. All is working now. Great mode!

wacodep
04-10-2009, 12:19 PM
What are the chanced of getting this to work with the Social Forums mod (converts the lame, neutered SG 'discussions' to actual forums)?

https://vborg.vbsupport.ru/showthread.php?t=207315

cellarius
04-10-2009, 02:18 PM
Hello and thank you for this product,


I have a problem when vBseo is enabled. All the latest post are linked as:

/forum/group.php
I use vBSEO myself and do not experience this problem, sorry... for me, the "latest"-links work perfectly well.

I'm loving this, but I'm having a problem with getting the forum icon to show correctly. When there is a new post, the forum marker doesn't change. It shows the forum marker for one without a new post. Any ideas?


perfect, thanks!

I don't suppose you could code something like this for the blogs that a member is subscribed to???? =)

Kris
Might this
Limitations
Marking of new messages only works with database, not with cookie based marking of read threads (-> AdminCP setting)
Explanation: This mod relys on the information in the database when a discussion was last read by the actual user. If you rely on cookies for this, you can use this mod anyway, but there will be no marking if there are unread messages by changed statusicons.
be the problem?
For those with the "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/index.php(67) : eval()'d code on line 186" error, open the forumhome code plugin and change
mysql_num_rowsto
$db->num_rowsBit silly mistake, and there's some sessionurl variable mess-ups (using $session[sessionurl] when there's no parameter after "?" instead of just using $session[sessionurl_q] and no "?"), but overall it's a good mod and I'm glad I found it :)
Thanks for the fix, will be included in an upcoming release (soon ;)). 'course you're right, that was a really stupid one :o:D Also the wrong session variable.

What are the chanced of getting this to work with the Social Forums mod (converts the lame, neutered SG 'discussions' to actual forums)?

https://vborg.vbsupport.ru/showthread.php?t=207315
None, really. I do not use that mod and will not change this one until I know what vB4 will make of the social groups.

wacodep
04-10-2009, 03:41 PM
None, really. I do not use that mod and will not change this one until I know what vB4 will make of the social groups.It was worth asking, right? :)

The standard 'discussion' areas for SG's are lame as hell. You can't do half the stuff in them as you can with a real forum, such as attach files to messages posted in the threads, etc.

Hopefully, JelSoft will see the err of their ways and create REAL forums for the SG's 'discussion' areas instead of the neutered ones there now (3.8.x).

wacodep
04-10-2009, 03:50 PM
None, really. I do not use that mod and will not change this one until I know what vB4 will make of the social groups.How about if you provided a way to toggle the display of the "Last Post" and "Posts" columns? That way, it would just show the group and the member count?

cellarius
04-10-2009, 04:39 PM
v 1.4
+ some bugfixes
+ option to turn teaser message off
+ option to show several buttons: to start a new discussion - see the group's members list - see the group' photos (only shown if there are any attached pictures) - unsubscribe (only if subscribed groups are shown) (Thanks to glorify (https://vborg.vbsupport.ru/showpost.php?p=1736102&postcount=54))

cellarius
04-10-2009, 04:43 PM
How about if you provided a way to toggle the display of the "Last Post" and "Posts" columns? That way, it would just show the group and the member count?
Sorry: But that's why the mod is fully templated. Just edit forumhome_cel_social_groups_groupsbit to easily achieve what you want. ;)

wacodep
04-10-2009, 05:43 PM
Sorry: But that's why the mod is fully templated. Just edit forumhome_cel_social_groups_groupsbit to easily achieve what you want. ;)I *already* did that. I was just making a suggestion.

Forget it. Thanks.

cellarius
04-10-2009, 06:47 PM
I *already* did that. I was just making a suggestion.

Forget it. Thanks.
Hey, what's the problem? I develop this mod along the lines that suit my needs. If someone suggests a idea I like, I pick it up. If I don't like it or do not see the need, I don't. See: I'm not getting exactly paid for this ;)

You made a suggestion and I declined, telling you how to achieve what you want. How am I to know what you did or did not already do? No need to get tetchy.

RadioErewan
04-10-2009, 10:48 PM
Here you have Polish translation of this mod (unfortunately there are few hard coded phrases for admin options).

Regards

cellarius
04-11-2009, 07:26 AM
Thanks for the translation!

Also: Just found a template/style-error that (for me) only showed up in Google Chrome. Version 1.4.1 fixes only this small issue.

sensimilla
04-12-2009, 07:16 PM
Great job, thanks.

nick_ramsay
04-13-2009, 12:14 PM
I think this is a great mod. It's completely changed how social groups are perceived by my users. I do have one request though. There's a plugin I'm using that enables BBCode in Social Group descriptions, but unfortunately that BBCode doesn't get converted in the descriptions shown on the homepage. It would be great if a future version of this mod could accommodate BBCode, even if it's not yet standard in vB social groups.

wacodep
04-13-2009, 02:22 PM
Hey, what's the problem? I develop this mod along the lines that suit my needs. If someone suggests a idea I like, I pick it up. If I don't like it or do not see the need, I don't. See: I'm not getting exactly paid for this ;)

You made a suggestion and I declined, telling you how to achieve what you want. How am I to know what you did or did not already do? No need to get tetchy.I'm fairly certain that I said, "Forget it. Thanks."

Generally, that means there is no need to continue defending your decision, as I have accepted it.

Again, thanks for your work on this.

starman?
04-13-2009, 07:33 PM
I've just updated this to include the icons. Thanks again cellarius.

I was wondering if you could tell me how to adjust the width of the columns in your plug-in, as it doesn't align with my forums and I'm a fussy aesthetic type of a guy?

cellarius
04-14-2009, 07:15 AM
No need to dive into the plugin. The columns are established in the template forumhome_cel_social_groups. That's just html, you can change column widths there fairly easily.

starman?
04-14-2009, 01:59 PM
Cheers and appreciated.

cellarius
04-14-2009, 09:25 PM
I think this is a great mod. It's completely changed how social groups are perceived by my users. I do have one request though. There's a plugin I'm using that enables BBCode in Social Group descriptions, but unfortunately that BBCode doesn't get converted in the descriptions shown on the homepage. It would be great if a future version of this mod could accommodate BBCode, even if it's not yet standard in vB social groups.
I'll think about it, tho at the moment I'm inclined to wait until vB4 is out at least in beta before adding to this mod any features, sorry.

Revan
04-19-2009, 02:38 PM
I've made the following changes to this mod in order to make it fit into my forums more cleanly, and it'd be nice if some of these changes made it into the final mod (maybe via options)?

Variable: Placement changed:
Under $forumbits in the FORUMHOME template.Change/Reasoning:
Changed placement to make it snap to the bottom of the forum list, in order to make it more in line with the rest of the forum lists.
Template forumhome_cel_social_groups:
<if condition="$show_cel_sgfh">
<if condition="($cel_groups_hasresults) OR ($vboptions[cel_sgfh_show_teaser])">
<tbody>
<tr>
<td class="tcat" colspan="5">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('new_social_disc');"><img id="collapseimg_new_social_disc" src="$stylevar/collapse_tcat$vbcollapse[collapseimg_new_social_disc].gif" alt="" border="0" /></a>
<a href="group.php$session[sessionurl_q]">$vbphrase[social_groups]</a>$vbphrase[cel_sgfh_forumhome_title]
</td>
</tr>
</tbody>
<tbody id="collapseobj_new_social_disc" style="$vbcollapse[collapseobj_new_social_disc]">
$cel_sgfh_output
</tbody>
<if condition="$cel_groups_limit">
<tbody>
<tr>
<td class="tfoot smallfont" colspan="5" align="center">
<strong>
<a href="$cel_groups_show_more_link_href">$vbphrase[cel_sgfh_show_more]</a>
</strong>
</td>
</tr>
</tbody>
</if>
</if>
</if>
Changes/Reasoning:
Removed the custom header in order to make it respect the width of the forumbits.

Template forumhome_cel_social_groups_groupsbit:
<if condition="($cel_groups_hasresults)">
<tr>
<td class="alt2Active">
<img src="$stylevar[imgdir_statusicon]/$forum[imageprefix]$statusimg.gif" alt="" border="0" />
</td>
<td class="alt1">
<if condition="$vboptions[cel_sgfh_showbuttons]">
<div style="float: right; padding: 3px;">
<a href="group.php?$session[sessionurl]do=message&amp;groupid=$cel_groups[groupid]"><img src="$stylevar[imgdir_button]/cel_sgfh_new_discussion.png" alt="$vbphrase[cel_sgfh_new_discussion]" border="0" /></a>
<a href="group.php?$session[sessionurl]do=viewmembers&amp;groupid=$cel_groups[groupid]"><img src="$stylevar[imgdir_button]/cel_sgfh_members.png" alt="$vbphrase[cel_sgfh_members_button]" border="0" /></a>
<if condition="$cel_groups_pictures"><a href="group.php?$session[sessionurl]do=grouppictures&amp;groupid=$cel_groups[groupid]"><img src="$stylevar[imgdir_button]/cel_sgfh_picture.png" alt="$vbphrase[cel_sgfh_picture]" border="0" /></a></if>
<if condition="$vboptions[cel_sgfh_show]==subscribed"><a href="group.php?$session[sessionurl]do=unsubscribe&amp;groupid=$cel_groups[groupid]"><img src="$stylevar[imgdir_button]/cel_sgfh_unsubscribe.png" alt="$vbphrase[cel_sgfh_unsubscribe]" border="0" /></a></if>
</div>
</if>
<a href="group.php?$session[sessionurl]groupid=$cel_groups[groupid]">$cel_groups[name]</a><br /><span class="smallfont">$cel_groups[description]</span>
</td>
<td class="alt2 smallfont">
<div style="white-space: nowrap">
$cel_sgfh_output_lastmsg
</div>
</td>
<td class="alt1" align="center">
$cel_groups[discussions]
</td>
<td class="alt2" align="center">
$cel_groups[visible]
</td>
</tr>

<else />
<tr>
<td class="alt1" colspan="5">$cel_groups_no_result_phrase</td>
</tr>
</if>Changes/Reasoning:
Removed hard-coded [I].gif extension from the plugin in order to support skins using transparent PNGs as their forum_on and forum_off images.
Changed members to discussions (equivalent of threads).
Template forumhome_cel_social_groups_lastmsgby:
<div class="smallfont" align="$stylevar[left]">
<div>
<span style="white-space:nowrap">
<a href="group.php?$session[sessionurl]do=discuss&amp;gmid=$cel_groups[lastgmid]" style="white-space:nowrap" title="$vbphrase[go_to_last_post]"><strong>$cel_groups[trimmed_lastdiscussion]</strong></a></span>
</div>
<div style="white-space:nowrap<if condition="is_browser('ie', 6)">; float:$stylevar[left]</if>">
<phrase 1="member.php?$session[sessionurl]u=$cel_groups[lastposterid]" 2="$cel_groups[lastposter]">$vbphrase[by_x]</phrase>
</div>
<div align="$stylevar[right]" style="white-space:nowrap">
$cel_groups[lastmsgdate] <if condition="!$show['detailedtime']"><span class="time">$cel_groups[lastmsgtime]</span></if>
<a href="group.php?$session[sessionurl]do=discuss&amp;gmid=$cel_groups[lastgmid]#gmessage$cel_groups[lastgmid]"><img class="inlineimg" src="$stylevar/lastpost.gif" alt="$vbphrase[go_to_last_post]" border="0" /></a>
</div>
</div>Changes/Reasoning:
Fixed [I]&gmid to &amp;gmid, because of XHTML validity.
Plugin forumhome code:
if ($cel_groups['readtime'] AND $cel_groups['lastpost'] > $cel_groups['readtime'])
{
$statusimg = "forum_new";
}
else
{
$statusimg = "forum_old";
}
Changes/Reasoning:
Removed hard-coded .gif extension from the plugin in order to support skins using transparent PNGs as their forum_on and forum_off images.

I believe these changes, especially if added as options, will be beneficial for those like me, who prefer to have the Social Groups list exactly the same way as any other forum category :)

BigDog56
04-19-2009, 05:04 PM
Installed, works great! thank you!

BigDog56
04-20-2009, 11:45 AM
Had to uninstall it. Seems no one's posts were showing up in any of the forums. On forum home you would see them, but when you went to the forum itself, no posts showed up from the time the mod was installed.

cellarius
04-20-2009, 01:18 PM
Had to uninstall it. Seems no one's posts were showing up in any of the forums. On forum home you would see them, but when you went to the forum itself, no posts showed up from the time the mod was installed.
This mod is not about forums, it's about social groups. So I'm not really sure what your problem was or is. If I am to help you on this, I will require a significantly clearer description of what the problem is and what you are doing.

If I'm guessing right: There's no function in this mod that possibly could prevent posts to social groups discussions inside the social groups system from being displayed. This mod does not mess in any way with the social groups system as is, it only qeries information from the database and displays it - and it does so only on Forumhome.

BigDog56
04-20-2009, 01:47 PM
This mod is not about forums, it's about social groups. So I'm not really sure what your problem was or is. If I am to help you on this, I will require a significantly clearer description of what the problem is and what you are doing.

If I'm guessing right: There's no function in this mod that possibly could prevent posts to social groups discussions inside the social groups system from being displayed. This mod does not mess in any way with the social groups system as is, it only qeries information from the database and displays it - and it does so only on Forumhome.

Thanks for the response. The posts that don't show are in the forum, not the posts in the social groups. Example. I create a thread in one of our forums called chit chat. On the forum home page, on the right hand side it shows the most recent post in that forum, hence the new thread. But when I click on the chit chat forum, the thread is not there. Nor are any new posts any member made. Once I disabled the mod, the posts and thread appeared. Maybe this is clashing with another modification.

cellarius
04-20-2009, 02:03 PM
Yeah, probably a conflict of some sort. Though I really cannot see this mod influencing the display of threads or posts in forums :eek:

BigDog56
04-20-2009, 02:06 PM
Update: I repaired and optimized all my tables and reinstalled it. Seems to be working ok. I'll let you know!

cellarius
04-20-2009, 02:18 PM
Good news! :up: Hope it works out for you!

BigDog56
04-20-2009, 02:22 PM
Good news! :up: Hope it works out for you!

Thank you! And thank you for your hard work creating this mod! :up:

der_darkon
04-20-2009, 03:19 PM
Great Mod, i really love it :)

Is there any way to get this into the VBa CMPS-Portal?

redlabour
04-21-2009, 03:25 AM
Awesome Mod. Here is the german Translation (Frontend)....

@cellarius - please include the Template edit-Instruction at the next Update to the install.txt. ;)

Regards

cellarius
04-21-2009, 05:19 AM
Awesome Mod. Here is the german Translation (Frontend)....
Danke daf?r! H?tt' ich eigentlich auch schon mal machen k?nnen :o

@cellarius - please include the Template edit-Instruction at the next Update to the install.txt. ;)
Will do.

cellarius
04-21-2009, 03:31 PM
Update to version 1.5 - What's new?

Enhanced core feature: checking for unread messages
Explanation: up to now, the mod only took into account the last message in a social group, meaning: if the user read the last message, but there were still unread messages in other discussions, the group was marked as read anyway. This has now been changed: As long as there are *any* unread messages in a social group, it will be marked as containing unread messages. When checking the mod takes into account the database Read Marking Limit set in vB options, i.e. after a certain number of days messages will no longer be taken into account.
Cost: This feature adds one additional query to forumhome (not per group listed, but overall). This means that this mod adds 2 queries alltogether.New Options in AdminCP
apply custom css formatting to grouptitle
trim group description or disable it (will trim at spaces only, not inside words)
parse bbcode in group descriptions (cannot be used together with trimming as closing tags might get lost)
option to use a statusicon different from the forums (see instructions in AdminCP options)
use .png instead of .gif files for statusicons
show groupicon instead of statusicon (marking of new groups via grouptitle css)

Hope you like it!

cellarius
04-21-2009, 04:22 PM
I believe these changes, especially if added as options, will be beneficial for those like me, who prefer to have the Social Groups list exactly the same way as any other forum category :)
As you can see, some of them made it into the new release, some did not. The decision to put the groups into an extra block was made to have some distinction - they are not the same as any other forum, after all. Who wishs to treat them like you do can follow your example - that's what templates are for :)

Revan
04-21-2009, 05:58 PM
Well I'm most pleased that the .png change made it into the mod - template edits, I can deal with, but remembering code changes would be a hassle ;)
Nice going on the read marking change =D

Updating now :)


EDIT: Nevermind, the .png setting is global when it should be per-skin, like I put in my templates. I still need to edit the code to produce the wanted effect :(
Best way to do this would be to define the result of the AdminCP option in the template, rather than the code, so that a forum could set their default (if the majority of skins uses gifs, they use gif extension in the option, and vice versa), but still allow us to customise the extension per-skin.
Hopefully that made sense XD

cellarius
04-21-2009, 06:25 PM
Hi, try this one.
I started to change this right after your first edit, but I guess I just had the same idea ;) I hope this will work for you.

I updated the product .zip accordingly.

blackenizer
04-21-2009, 06:31 PM
When I click on the option

groups user is a member of
The forum page does not come up.

but it works if I select
groups user is subscribed to

cellarius
04-21-2009, 06:37 PM
When I click on the option

groups user is a member of
The forum page does not come up.

but it works if I select
groups user is subscribed to
I cannot reproduce this - I myself use it with the "member of"-option only, without problems both on my test and my life-board.

Revan
04-21-2009, 07:57 PM
Working like a charm now, thanks mate :D

cellarius
04-21-2009, 08:06 PM
Working like a charm now, thanks mate :D
Good to hear :cool::up:

redlabour
04-21-2009, 08:20 PM
Please use the Update-Mail Function. You have 120 Installs but only a few Downloads every Update. ;)

redlabour
04-21-2009, 08:38 PM
BUG after Updating shown at Top of Forumhome/Header:

Warnung: Invalid argument supplied for foreach() in [path]/index.php(67) : eval()'d code (Zeile 458)

cellarius
04-21-2009, 09:12 PM
Uh - I don't get that error... on neither of my boards. Since there's no line 458 in the plugin, I do not know exactly which of the two foreach statements in the plugin might be responsible. Since this only happens after upgrade, probably the newly added ;) Can't see what might be causing it at the moment.

Please try the following: in the plugin add
$array_discussionread = array();before
while ($array = $db->fetch_array($result_discussionread))


Are you using PHP 4 or PHP 5?

If the above does not fix it, please try to replace
foreach ($array_discussionread[$cel_groups['groupid']] as $discussions)with
foreach ((array) $array_discussionread[$cel_groups['groupid']] as $discussions)

redlabour
04-22-2009, 03:21 PM
Are you using PHP 4 or PHP 5?

If the above does not fix it, please try to replace
foreach ($array_discussionread[$cel_groups['groupid']] as $discussions)with
foreach ((array) $array_discussionread[$cel_groups['groupid']] as $discussions)

PHP5 - the second Hint works now! :)

cellarius
04-22-2009, 03:35 PM
Good to know. Will include this into the package and then send an upgrade notification ;)

redlabour
04-22-2009, 04:50 PM
Awesome! :)

Revan
04-22-2009, 06:40 PM
It's good practice to always init your arrays like that, and if you are foreach'ing variables you didn't have complete control over, you should either typecast like in your second fix, or check "if (!is_array($arr)) { $arr = array(); }" :)
Reason is, if a database returns no rows, it doesn't create any arrays you manipulate inside a while() result iterator.

cellarius
04-22-2009, 08:55 PM
Yep, just learned that ;)

Namaless
04-26-2009, 04:28 PM
Italian Language Pack: https://vborg.vbsupport.ru/showthread.php?t=212226

Thanks for this MOD.

BigPete7978
04-28-2009, 03:42 AM
Is there any reason that the small images wouldn't show up (and just appear as broken images)? I already uploaded them to both my images folder and the individual style folder. I don't get what could be causing this.

cellarius
04-28-2009, 04:28 AM
You mean the icons to start a new discussion etc.? There's only one reason for this: they have not been uploaded to the correct folder. Do you use a custom style with different folders? This mod always looks for the buttons in the folder of the skin as set in AdminCP. So probably you have to upload them to that folder, too.

BigPete7978
04-28-2009, 03:30 PM
You mean the icons to start a new discussion etc.? There's only one reason for this: they have not been uploaded to the correct folder. Do you use a custom style with different folders? This mod always looks for the buttons in the folder of the skin as set in AdminCP. So probably you have to upload them to that folder, too.Yes I have a custom folder. But I uploaded them to the correct path there as well. :confused:

BigPete7978
04-28-2009, 03:35 PM
Nvm figured it out. :-P

Renada
05-21-2009, 03:31 PM
Hi cellarius,

I wonder if you could help - I've just installed this and get the error in the attached image - all the code shows up at the top of the page.

Thanks in advance,
Renada :)

Oblivion Knight
05-21-2009, 04:36 PM
Hi cellarius,

I wonder if you could help - I've just installed this and get the error in the attached image - all the code shows up at the top of the page.

Thanks in advance,
Renada :)
I had that same problem, you need to edit one of the plugins.. More specifically, the one on the hook forumhome_start.

Find and delete this at the very top and at the very bottom of the plugin:
?><?Save, and you're done.

Renada
05-21-2009, 05:32 PM
I had that same problem, you need to edit one of the plugins.. More specifically, the one on the hook forumhome_start.

Find and delete this at the very top and at the very bottom of the plugin:
?><?Save, and you're done.


Thank you so much, that fixed the problem :)

One more thing, slightly off topic though. I want to add a block of text to the "Social Groups" main page - do you have any idea which template I need to edit? I've tried several and it doesn't appear to show up anywhere.

Thanks again :)
Renada

trotskid
05-21-2009, 10:24 PM
Very nice addon, thanks!

Where can I fix the width of these columns in order to align with the rest of the forum?

http://img211.imageshack.us/img211/7291/groupforum.jpg

Greetings

cellarius
05-22-2009, 02:49 PM
Adapt template forumhome_cel_social_groups to your needs - just like you did with forumhome

trotskid
05-22-2009, 05:44 PM
Thank you very much ;)

ryancooper
06-07-2009, 11:52 AM
is there a way someone can put this in a standalone php file so I can call it in my ajax tabs?

Does that mane cents? LOL :D

trotskid
06-12-2009, 04:29 PM
Hi. The title of groups appears in normal style but I would like to show it with bold text like the titles for forums on forumhome. Where can I modify that?

Thanks

Oblivion Knight
06-12-2009, 04:55 PM
Hi. The title of groups appears in normal style but I would like to show it with bold text like the titles for forums on forumhome. Where can I modify that?

ThanksIn the template forumhome_cel_social_groups_groupbit, find:
<a href="group.php?$session[sessionurl]groupid=$cel_groups[groupid]" style="$cel_sgfh_css">$cel_groups[name]</a>


Replace with:
<a href="group.php?$session[sessionurl]groupid=$cel_groups[groupid]"><strong>$cel_groups[name]</strong></a>

cellarius
06-12-2009, 10:29 PM
No need to edit the template. Just apply css to the grouptitle in the options for this mod in AdminCP.

trotskid
06-13-2009, 04:50 AM
Thanks to both.

Where can I find that exactly, cellarius?

trotskid
06-13-2009, 05:11 AM
Another question. I?ve seen that the bar of title and description respect to the forums are reversed. It?s possible to fix this?

Greetings ;)

cellarius
06-13-2009, 07:29 AM
Forget what I wrote - the css is for unread groups titles only. I misunderstood your questioin. You'll have to do the template edit.

Your second question: The standard setup for Forumhome is the way that this mod uses (see vbulletin.com). You can change that by editing the templates of this mod along the same lines you edited your forums display.

ragtek
06-13-2009, 07:50 AM
yea
had also the idea some days ago, good that i've found it here instead of spending time with coding

trotskid
06-13-2009, 09:49 AM
Your second question: The standard setup for Forumhome is the way that this mod uses (see vbulletin.com). You can change that by editing the templates of this mod along the same lines you edited your forums display.

I can?t understand. What?s the standard setup? All of my styles (5), including the default, shows like the screenshot, and I have not made any change on forumhome.

cellarius
06-13-2009, 10:26 AM
As I said: Look at vbulletin.com. They are running the standard style, and there the lines for the forums you pointed out are arranged in the way that this mod does. Since your style is different, it has to be modified. To adapt this, you'll have to adapt the templates for this mod.

cad2go
07-03-2009, 11:30 AM
Works a treat. Thanks.

l_amhed
07-06-2009, 08:31 PM
Buongiorno cellarius.

First, thanks for your hack which is working very well.
Then, a little question, I'm using SocialForums :
https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=socialforums38

I'd like to have the last post of the social forum appearing in the cell instead of the last discussion, can you help me ?

Thanks !

cellarius
07-06-2009, 09:06 PM
Sorry, since I do not use (and do not know) this mod, I really can't, sorry.

l_amhed
07-06-2009, 09:39 PM
Owwww too bad .... But thank you again for this very usefull hack.

webgroup
07-06-2009, 10:05 PM
how can I resize the group icons? they are showing full size, too big.

thanks

cellarius
07-06-2009, 10:22 PM
The mod uses the thumb size of the icon, which is 80x80, as can be seen in the screenshot. The big version is max. 200x200. Both values can not be changed in vB as far as I'm aware.

webgroup
07-06-2009, 10:51 PM
where can I change the size?

cellarius
07-06-2009, 11:00 PM
As I said: You can't.

webgroup
07-06-2009, 11:02 PM
the group icons in my groups page are looking small, why the icons dont show the same in the forumhome?

cellarius
07-06-2009, 11:06 PM
I already told you that this mod uses the thumb size. It does on all my forums.l

How can I tell you what's wrong or even if there's anything wrong at all, if you provide no information at all? How about a link where the problem can be seen?

webgroup
07-09-2009, 05:26 PM
I know what you say, in my groups page, all thumbs for groups show at 80x80, like its suppose to be.
Your hack is displaying the groups icons in forumhome at 200x200
I would like to know hot to change it, or if you can add this feature in a next release.

Thanks

cellarius
07-09-2009, 08:52 PM
As I said in my last post: Please provide me with a link or additional information so I can have a look. On all my forums the thumb is used (the img src for the icon sports the "type=groupthumb" url parameter; in fact, the image url is exactly the same as in grouplist). At least tell me: What exact URL is used to show the icon?

I hear that two users have this issue. I don't. I'm perfectly willing to have a look, but as long as you refrain from providing me with information, I will refrain from looking into the issue. That simple.

cad2go
07-13-2009, 03:19 PM
I'm having issues with this now:o

The group icons don't show when picked. When they originally did they were the big 200x200 ones not the 80x80. I think it stopped working after you fixed up the photopost but I'm not sure as I've had it just at "Show Icons? yes" since before then.

cellarius
07-13-2009, 03:52 PM
I think it stopped working after you fixed up the photopost.
Photopost? This mod has nothing to do with Photopost - are you sure you don't mix this up with my other mod?

cad2go
07-13-2009, 05:01 PM
Photopost? This mod has nothing to do with Photopost - are you sure you don't mix this up with my other mod?

Yes.

I'm talking about the timing of it stopping working and even when it did work fully it still showed the big group icons not the 80x80 ones.

Oblivion Knight
07-13-2009, 07:50 PM
I also had the problem with group thumbnails showing fullsize, so I decided to use custom statusicons per groupid with this little edit of your forumhome_start plugin:
if ($vbulletin->options['cel_sgfh_iconfile'])
{
$oldicon = "group" . $cel_groups[groupid] . "_old";
$newicon = "group" . $cel_groups[groupid] . "_new";
}Then for each group, you need to upload groupX_old.gif and groupX_new.gif to images/statusicon, replacing X with the groupid.

Of course, this is only particularly useful if only admins can create social groups. It's not much good if you allow members to create their own, and/or if you have LOADS of them.

cellarius
07-14-2009, 10:19 AM
I repeat, now the third time: As long as nobody at least wants to give me the img source url to one of the group icons, there's really nothing I can do, since it works fine for me.

The code in the plugin calls for the groupthumb, and this code has not changed for a long time now:
$statusimg = "image.php?groupid= " . $cel_groups[groupid] . "&amp;dateline=" . $cel_groups[dateline] . "&amp;type=groupthumb"; Is this type-parameter in the URL that calls the group icon on your forumhome?

cad2go
07-14-2009, 11:45 AM
you've got a space after 'image.php?groupid'?

image.php?groupid=%204&amp;dateline=1246647737&amp;type=gr oupthumb.gif

http://www.rletc.com/forum/image.php?groupid=4&dateline=1246647737&type=groupthumb.gif is nothing anyway.

cellarius
07-14-2009, 01:08 PM
Somehow the code got corrupted during copy&paste. Inserted the (now hopefully) correct code from line 324 of the plugin in my previous post.

//Oh, indeed there is a space too much. Fixing this however does not solve the problem. Can someone confirm who has this problems that your groups icons are stored in the filesystem, not the database?

cad2go
07-14-2009, 02:54 PM
mine are filespace - I can re-admin you over on the site if you like

Also was going to manually edit the teaser with some of the group icons - might be a thought for a later version to mimic the new groups bit in groups.php - I'll probably put them in a row. Just a thought.

cellarius
07-14-2009, 02:57 PM
OK, please try the attached plugin. I added a check whether the icons are stored in the database or in the file system and act accordingly. Import the attached product file to test.

Mind you: I was able to see that there were no icons displayed at all if the icons were stored in the filesystem; this has now been fixed.

I still can't reproduce the issue where not thumbs, but the original sizend groups icons are shown. If pulled from the file system this should be impossible: the icons are taken directly from the respective "thumbs" folder in your filesystem. So if the images are too big, they're safed like that in there and there's probably nothing I can do. If this happens with images in the database: if there is the "type=groupthumbs"-parameter present, that should trigger image.php to show the thumb sized icons. This follows exactly the call from the groups.php.

cad2go
07-14-2009, 03:05 PM
lol

That didn't go well. I've had to uninstall the product. :D Let me just reinstall the original.

cellarius
07-14-2009, 03:06 PM
What happened?

cad2go
07-14-2009, 03:11 PM
I got that content encoding message that I got before.

?><? What's this at the start of the plugin php? It's not in your new version?

cad2go
07-14-2009, 03:17 PM
I had the group icons up when I first installed this - that's the annoying part.

cellarius
07-14-2009, 03:22 PM
That's just a helper for me coding - it should not be there in the first place; that's got nothing to do with it. That encoding issue of yours beats me. Try importing the product file I attached above.

cad2go
07-14-2009, 03:26 PM
Perfect!

cellarius
07-14-2009, 03:27 PM
I had the group icons up when I first installed this - that's the annoying part.
Could it be it stopped working when you moved your icons from database to file system? That's really the only thing I could think of, since the icons were new in 1.5 and there have been no changes to the mod since then.

cellarius
07-14-2009, 03:27 PM
Perfect!
This means: The product import went o.k. and the icons work now?

//BTW: The link to your RLetc-Forum in your sig is broken ;)

cad2go
07-14-2009, 03:32 PM
Yeah everything works

(even my sig now I hope!)

cellarius
07-14-2009, 03:36 PM
Yeah everything works
Great to hear. Hopefully it'll work out for the others, too.

(even my sig now I hope!)
It does. Duplex debugging. ;)

cellarius
07-14-2009, 03:45 PM
Bugfix version 1.5.1

Problem with group icons fixed when icons are saved in file system
Hopefully this will solve the icon-related problems that were reported during the last days. A check whether the icons are stored in the database or in the file system has been added, and the mod now acts accordingly.

cad2go
07-14-2009, 03:46 PM
lol

So what do you think about listing the social groups that a user is NOT a member of AFTER the main list ie.

Here's some other groups you may be interested in joining but haven't joined yet

icon, icon, icon

or listing 5 random/latest in the teaser?

cellarius
07-14-2009, 03:49 PM
I might think about that after I see what vB4 has in store for the groups. Until then this mod is feature frozen, I'm afraid :)

cad2go
07-14-2009, 03:50 PM
cool - cheers for all the help

redlabour
07-14-2009, 08:04 PM
Uh - I don't get that error... on neither of my boards. Since there's no line 458 in the plugin, I do not know exactly which of the two foreach statements in the plugin might be responsible. Since this only happens after upgrade, probably the newly added ;) Can't see what might be causing it at the moment.

Please try the following: in the plugin add
$array_discussionread = array();before
while ($array = $db->fetch_array($result_discussionread))


Are you using PHP 4 or PHP 5?

If the above does not fix it, please try to replace
foreach ($array_discussionread[$cel_groups['groupid']] as $discussions)with
foreach ((array) $array_discussionread[$cel_groups['groupid']] as $discussions)

PHP5 - the second Hint works now! :)

Good to know. Will include this into the package and then send an upgrade notification ;)

It is still not included in the new Update!!! ;)

webgroup
07-14-2009, 08:49 PM
Nice, the icons are showing correctly now.
But Im gettin this error and I had to disable the hack:

Warning: Invalid argument supplied for foreach() in [path]/index.php(67) : eval()'d code on line 212

redlabour
07-14-2009, 09:05 PM
Ehhmmm....look one Posting behind yours and relax and reinstall! :rolleyes:

webgroup
07-14-2009, 09:12 PM
Oh ok, I edited the code as stated above and now its working!
im using php5

Breakpoint
07-14-2009, 09:41 PM
Thanks I will need to insstall this!

yotsume
07-14-2009, 09:55 PM
Does this mod work with vb3.7x. I get a database error after installing this mod and doing the template edit:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT
socialgroup.groupid,
socialgroup.name,
socialgroup.description,
socialgroup.picturecount,
socialgroup.lastpost,
socialgroup.lastposter,
socialgroup.lastposterid,
socialgroup.lastgmid,
socialgroup.visible,
socialgroup.lastdiscussion,
socialgroup.discussions,
socialgroup.members,
socialgroupicon.dateline
FROM vb_socialgroup as socialgroup
INNER JOIN vb_socialgroupmember as socialgroupmember
ON socialgroup.groupid = socialgroupmember.groupid
LEFT JOIN vb_socialgroupicon as socialgroupicon
ON socialgroupicon.groupid = socialgroup.groupid
WHERE socialgroupmember.userid = 1
GROUP BY name
ORDER BY lastpost DESC;

MySQL Error : Table 'xxxxxxxxx.vb_socialgroupicon' doesn't exist
Error Number : 1146
Request Date : Tuesday, July 14th 2009 @ 06:45:29 PM
Error Date : Tuesday, July 14th 2009 @ 06:45:29 PM
Script : http://www.xxxxxxxx.com/forum.php
Referrer : http://www.xxxxxxxx.com/admincp/index.php?do=head
IP Address : xx.xxx.xx.xxx
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-log

Did I miss something???

BigDog56
07-15-2009, 05:38 AM
Updated and thank you!

sensimilla
07-15-2009, 02:20 PM
The new version messed my forumhome display.
Back to 1.5.0

cellarius
07-15-2009, 02:35 PM
Does this mod work with vb3.7x. I get a database error after installing this mod and doing the template edit:
Did I miss something???
Yes. User group dsicussions were only introduced in 3.8, so there's no way this mod can work on 3.7.

cellarius
07-15-2009, 03:29 PM
The new version messed my forumhome display.
Back to 1.5.0

If you have modified the templates, you'll have to implement a change. Sorry, I forgot to mention this in the upgrade notification, I'll do that now. If you only imported the product and did not change your forumhome_cel_social_groups_groupsbit template, this is done automatically,

In forumhome_cel_social_groups_groupsbit find
<img src="$statusimg$icon_ext" alt="" border="0" />replace with
<img src="$statusimg" alt="" border="0" />Please note: It will no longer be possible to use .gif or .png on a per style basis, since I can't keep the icon extension variable in the template (this collides with bug concerning icons stored in the file system). You'll have to choose either png or gif for all your styles. As a workaround you always can convert the few icons needed for new or old groups.

cellarius
07-15-2009, 03:48 PM
It is still not included in the new Update!!! ;)
Your right :o, sorry 'bout that!

Updated the zip file.

yotsume
07-15-2009, 05:42 PM
Yes. User group discussions were only introduced in 3.8, so there's no way this mod can work on 3.7.

Thanks I will have to update my board. Not getting around that. ;)

MichaelaS
07-16-2009, 11:28 PM
I installed it without any errors at all, installed like a charm. I then added the template edit, and saved it. Nothing happened.

Ideas?

cellarius
07-18-2009, 11:28 AM
You either did something wrong or you use a highly customized style? There's really no way for us to say what's causing this on your end without any information and even knowing your site address.

zeus_r6
07-22-2009, 08:57 PM
Any chance this mod will work with 3.7.4?

cellarius
07-23-2009, 06:42 PM
User group dsicussions were only introduced in 3.8, so there's no way this mod can work on 3.7.

So: No.

e@sy
08-02-2009, 06:53 AM
Sorry for my englisch. It is not my best friend.

I have a little problem in the presentation of the Social Group description.

The correct one

Tipps & Tricks

but on Forumhome the AddOn show's me

Tipps &amp; Tricks

adamdavidconn
08-25-2009, 02:36 PM
Hi.
Great Mod.
A few things.

Firstly, how would I change the text which appears on forum index? I want to new messages in Social Groups, and the text Social Groups above that.

Thanks.
Adam

cellarius
08-25-2009, 02:54 PM
Just like you would do for forums. It mimicks forumdisplay and can be changed just in the same way. That's why it's templated.

wacnstac
09-04-2009, 11:58 AM
Love the mod have it installed. Would be even better if the icons indicating new posts also worked on cookies.

mp3u
09-24-2009, 10:23 AM
Thank you for this!

Xencored
09-28-2009, 04:40 AM
Hi mate

Ive jsut added the code to get it to show and there is like a <br /> break above the box and not one after ehich on my forum there needs to be and i cant fine the template to check

choccyclaire
09-28-2009, 08:25 AM
I have category spacing on my forum. How would I go about altering your template to tie in with this?

cassis2k
09-28-2009, 02:43 PM
Very good job, I use it. Thx :)

cellarius
09-29-2009, 04:40 AM
Hi mate

Ive jsut added the code to get it to show and there is like a <br /> break above the box and not one after ehich on my forum there needs to be and i cant fine the template to check
Template forumhome_cel_social_groups.

Hint: If you want to find out which template exactly you have to look at if you're trying to find out something like this:
AdminCP->General Settings->Add Template Name in HTML Comments->Yes

I have category spacing on my forum. How would I go about altering your template to tie in with this?
Along the same way you altered the forums. Since I don't know how you did that, I really can't comment. But the templating of this mod follows the same lines as the forums listing.

Xencored
09-29-2009, 04:52 AM
Template forumhome_cel_social_groups.

Hint: If you want to find out which template exactly you have to look at if you're trying to find out something like this:
AdminCP->General Settings->Add Template Name in HTML Comments->Yes


Omg thanks for that hint and for telling me the template :up:
And ive fixed it up thanks bro

nominated love all the social group mods :D

choccyclaire
10-08-2009, 10:04 PM
Thanks I worked out the category spacing pretty easily actually. :)

Xencored
11-07-2009, 02:42 PM
Changed my skins over mate and ive lost this on all my skins

also the $cel_social_groups Is on every skin yet its still not showing mate :confused:

cellarius
11-07-2009, 03:57 PM
Well, if it worked before there's nothing I can say than it has to be an issue with your styles - as long as you sure you have not deactivated the mod or any of it's components. And, of course, make sure the needed templates are present in your styles.

cellarius
11-15-2009, 09:43 PM
I'm happy to announce that this mod has been succesfully (I hope ;)) ported to vB4 beta 3. It was the first one I tried when I layed hands on alpha 1, and now I polished it for the public beta. Hope some of you find it still useful with vB4, forum and/or suite.

Here we go: https://vborg.vbsupport.ru/showthread.php?t=221581

cellarius
11-17-2009, 11:08 PM
If you're using this mod, you may also be interested in my new one: It shows a notification if there are new messages in discussions:
https://vborg.vbsupport.ru/showthread.php?t=228247

106326

MrRem
12-21-2009, 08:26 AM
Is there a way to make this compatible with this mod:
https://vborg.vbsupport.ru/showthread.php?t=207315

Or could someone enlighten me if vBulletin 4.0 Gold will have Social Groups using the normal forum layout (i.e Signatures, postbits, messages showing in latest posts) etc ?

cellarius
12-21-2009, 09:51 AM
I don't use that mod, so I don't know how it works. If you want to look at the groups in vB4, then just go to http://www.vbulletin.com/forum/groups.php (http://www.vbulletin.com/forums/groups.php)

MrRem
12-21-2009, 10:07 AM
OK, what about changing this part of the template:
forumhome_cel_social_groups_lastmsgby

so it contains a link to the group rather than displaying the thread and last psot by?
I'm not very good with coding so any help or pointers would be most appreciated :)

identitas
01-19-2010, 02:45 PM
I can't get it to show up. I have it activated in the vbulletin-settings. I use it inside vBadvanced CMPS, as module called "social groups last messages", calling a template containing "$cel_social_groups".

What shall I do to get it activated?

I use vbulletin 3.8.4 patch 2.

cellarius
01-19-2010, 04:10 PM
I do not use vBA and thus really have no idea what is needed to make things work with that.

identitas
01-19-2010, 04:24 PM
I do not use vBA and thus really have no idea what is needed to make things work with that.

It works at "forumhome" I notice now. But I want it to appear on a diffrent page than "forumhome", how can I do this?

When I place it elsewhere it doesn't show anything.

cellarius
01-19-2010, 05:22 PM
It may work if you change the hook of the main plugin to a hook that is executed wherever you want to show it. I would advaise against a hook that is executed everywhere, since that may add strain to the server.

identitas
01-19-2010, 08:03 PM
It may work if you change the hook of the main plugin to a hook that is executed wherever you want to show it. I would advaise against a hook that is executed everywhere, since that may add strain to the server.

Thanx for the tips . I changed hook in:

"fetch template" - hook to - "global_start"
"forumhome code" - hook to - "global_start"

Still it gives no output. Any ideas?

cellarius
01-19-2010, 10:30 PM
You must not change the hook for fetch_template. That needs to stay there. As I said, I still do not think it's a good idea to execute this mod with every single pageload of the forum, but that's for you to decide. As I said, I can not help you with vBA. You should probably ask at their place for help with this.

Spinball
01-25-2010, 11:35 AM
How difficult would it be to have it show all the social group categories and social groups as sub forums irrespective of who was logged in? I.e it shows all of them?

cellarius
01-25-2010, 08:03 PM
That would be a different modification.

BlackThorn
02-17-2010, 08:48 AM
Cel hi, thanks installed but why guests can't see that add-on? How I can permission that for guests?

cellarius
02-17-2010, 11:03 AM
Because guests can't join social groups or subscribe to them. There's nothing to show.

BlackThorn
02-17-2010, 02:58 PM
Because guests can't join social groups or subscribe to them. There's nothing to show.

Brother, "because guests cant view the arguments and cant join" you said. But in my site, groups.php is free to view for guests. Guests can't write a comment but they can view it. and btw i editted your plug-in. I removed that comment and other buttons. Means groups have to be seen there but they don't. Guests cannot view it and i think it's absurd...

Now, here is the demos :

https://vborg.vbsupport.ru/external/2010/02/36.png

Guests :

https://vborg.vbsupport.ru/external/2010/02/37.png

cellarius
02-18-2010, 05:23 AM
Would you be so kind and read the modifications description?

This mod shows groups a user is a member of or is subscribed to. That's explained right in the first sentence. It does not show all groups. Since guests can not join groups (this has nothing to do with reading!) and can not subscribe to groups, there is nothing to show. If you do not like how this mod works, I suggest you don't use it.

Hummie
05-07-2010, 02:41 AM
Your third screenshot shows an admincp area for editing, yet I cannot find it in my admincp. Where is it?

In addition, where do I make the default font size for social groups larger?

cellarius
05-07-2010, 04:50 AM
AdminCP->Settings->Options. It has it's own standard options group, usually somewhere at the end of the list. Changing the font size in social groups has nothing to do with this mod, please open your own thread for this.

Hummie
05-09-2010, 02:33 PM
Thanks.

cellarius
06-18-2010, 11:25 AM
New build 1.5.2: just a minor fix for a PHP 5.3 issue.

BirdOPrey5
06-18-2010, 04:17 PM
Upgrade installed and working fine in 3.8.4 PL2.

haytham
10-07-2010, 03:23 PM
Installed and nominated. Thank you.

PhotoNut
01-27-2011, 03:24 AM
Does this work on 4.x? Cause I REALLY want it!! lol

BirdOPrey5
01-27-2011, 04:52 AM
Does this work on 4.x? Cause I REALLY want it!! lol

The very first line of the very first post says "Available for VB4" followed by a link.

Majidm
03-26-2011, 04:42 AM
Great mod thanks a lot