vb.org Archive - Major Additions - GRPS: Groups Commune 2.0.x

Found a bug when trying to view a member's groups from the postbit that throws an SQL error (only happens to people that are in groups). Here is the problem and the fix. In viewgroups.php find:

Code:

                SELECT grps.groupid, grps.title, grps.description, grps.approved, grps.leaderid, grps_setting.image_name

                FROM grps

                LEFT JOIN " . TABLE_PREFIX . "user ON (user.userid = grps.leaderid)

                LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)

                WHERE grps.approved = '1' AND grps.groupid IN($grps_ids_imploded)

                ORDER BY grps.title ASC

And change it to:

Code:

                SELECT grps.groupid, grps.title, grps.description, grps.approved, grps.leaderid, grps_setting.image_name

                FROM grps

                LEFT JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "user.userid = grps.leaderid)

                LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)

                WHERE grps.approved = '1' AND grps.groupid IN($grps_ids_imploded)

                ORDER BY grps.title ASC

quiklink

07-07-2007 04:24 AM

Fantastic mod by the way. Haven't opened ours up yet, but will be doing so very soon.

sabret00the

07-08-2007 07:12 PM

Quote:

Originally Posted by bada_bing (Post 1284010)

sabret00the

Did you get my PM????

yes, i only had time to open it today though.

sabret00the

07-08-2007 07:13 PM

Quote:

Originally Posted by Rickeo (Post 1284910)

One issue here in my groups section it shows the defualt group photo that say there is no group photo how do I go about adding a group photo for a group I dont see the option ANYWEHRE.

If there isn't an option how do I remove that annoying photo coming up on the group discrption saying no group photo.

Thanks

~Rick~

it's been a long day after getting in from last night and not having a real sleep so bare with me, but i don't get what you mean. you'd like custom images per group?

sabret00the

07-08-2007 08:56 PM

Because i'm checking out a few things, here's a file that will go into 2.0.13 it fixes an issue in editpost.php

just replace your existing one with that.

also here's a fixed viewgroups.php

Rickeo

07-08-2007 09:42 PM

Got an issue no1 can reply to any of admins threads permissions are set right just wont post.

quiklink

07-08-2007 09:44 PM

Just as a note there is a similar issue in the feed.php I believe as there was in the viewgroups.php. I've also got groups showing in the user profiles as well now if you'd like the code.

djilou

07-09-2007 03:42 PM

Quote:

Originally Posted by sabret00the (Post 1286145)

Because i'm checking out a few things, here's a file that will go into 2.0.13 it fixes an issue in editpost.php

just replace your existing one with that.

also here's a fixed viewgroups.php

still have pagination problem with the new viewgroups.php

Quote:

Originally Posted by djilou (Post 1283452)

the number of groups on the categories listing page is wrong (http://www.site.com/groups/browse.php?c=1).
It shows something like 1 2 3 4 5 >, when in actuality there is one page. This is happening on all groups.
this is happening when you have more than 2 pages on some categories

Quote:

Originally Posted by quiklink (Post 1286195)

Just as a note there is a similar issue in the feed.php I believe as there was in the viewgroups.php. I've also got groups showing in the user profiles as well now if you'd like the code.

Would you share your code with us please?

quiklink

07-09-2007 04:11 PM

Quote:

Originally Posted by djilou (Post 1286800)

Would you share your code with us please?

Sure, but I need to ferret out a bug first that's causing problems for unregistered members to view the profile. Hopefully I can post it later today.

djilou

07-09-2007 09:19 PM

thank you

All times are GMT. The time now is 01:07 AM.

Page 175 of 205

175

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02150 seconds Memory Usage 1,745KB 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 (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: