Version: 2.0.13, by sabret00the
Developer Last Online: Apr 2010
Category: Major Additions -
Version: 3.6.4
Rating:
Released: 09-22-2006
Last Update: 09-28-2007
Installs: 233
DB Changes Uses Plugins Template Edits
Additional Files
No support by the author.
Welcome ladies and gentleman, this is the release thread for GRPS, an interactive groups commune. I hope you enjoy this release and i sincerely hope it provides everything to your community in which you're looking for.
What is it?
It's a groups commune. The original idea is that forums with lots and lots of forums on the front-page suck, as a result i thought most of the conversation was rather obscure in regards to what the forums were trying to achieve, so it'd be nice to have that all going on elsewhere, not detracting away from the content and stopping your front-page from looking like a car crash.
Features?
Groups Home
Groups Activity List
Newest Groups
Most Popular Groups
Largest Groups
Category List
Group Search by Title
Group Sort by Alphabetical Title, Categories, Member Count
Users can create groups
Admin switch to moderate groups or not
Admin CP access to moderation panel
Groups Page
Posts since last visit notification
Group Info
Group Leader shown with avatar
Category
Type
Groups can be listed as public, private or hidden
Start Date
Member count
Post count
Group Desciption
Shows group title
Shows random image
Shows group information set by group leader
Groups Thread List (Forum)
Status Icon
Title
Threads use postbit as per the forums
Thread Author with avatar and time that the thread was started
Last reply with avatar, username and time that the last reply was posted
Post New Thread Button
Groups Members can create threads
Newest Members
Shows five newest members
Link to view all members
Shows all members of the group
Group Options
Users can join/leave groups
PM Notification for group leaders upon join requests (when moderation enabled).
PM Notification for of acceptance or refusal.
Users can send invites to other users via PM
Groups Thread
Groups Info Box (see above for more info)
Group Description box (see above for more info)
Newest Members List (see above for more info)
List of groups posts using forums postbit
Pagination using native vBulletin pagination
Group Leader/Moderation Options
Open/Close Thread
Stick Thread
Delete Thread
Users have the ability to report posts
Moderators have the ability to view IP and host.
Group Leader Options
Groups Management
WYSIWYG Editor
Reason for editing box
Group Options
Private Posts
Only group leader can make threads
Moderate Members
Show group text edit details
Hide group image on group pages
Hidden Group
This option is only available to admins
Group Members Moderation
Ability to accept or deny new members
Postbit Integration
View Users Groups
User Control Panel (Integration)
List of groups appears in usercp in order of the last post
Administrator Options
vBulletin Options
Turn groups on or off
Groups Limit Per User
Posts Per Page (threads)
Check Forum Activity Posts
Check Forum Activity Time
Number of Random Images
Turn email notification of new groups on/off
Usergroup Options
Can view groups
Can create groups
Can join groups
Can post messages in groups
Can edit messages in groups
Can delete messages posted in groups
Numbers of groups usergroup can join limited
Can moderate groups
See above for more info
Can view IP Addresses
Category Editor
Edit
Edit cat id (please not this can ef up your show)
Edit cat title
Edit cat description
Add
New Cat Title And Description
Groups Editor
Search for group by id
Edit
Title
Desciption
Categoryid
Group leader id
Private Posts
Moderate Members
Hidden group
Special Thanks to harry1951, without his help testing and his recommendations, this would've never ended up the way it did.
Honestly, i can't think of anything else, if you appreciate the work gone into this mod, please donate (in GBP) (right click open in new window)
Hopefully you all appreciate that i just relaunched my site and rather than soak up the atmosphere there or go out drinking i came to release this tonight.
Screens below, rest to your right
Please note this mod does work with 3.5.x
PLEASE DO NOT JOIN MY SITE IN A BID TO PLAY WITH IT OR HAVE A LOOK AT IT FURTHER, MY SITE IS SOMETHING I VALUE FOR BEING SOMEWHERE I CAN CHILL AT, IT'S NOT A TEST SUITE OR DEMO!
Bug Fixes
Groups v2.0.0 RC1b.zip: fix regarding incorrect table prefixes in index.php and editpost.php
Groups v2.0.0 RC2.zip: fix regarding incorrect table prefixes in functions_grps.php and class_grps.php. also fix regarding installation instructions.
Groups v2.0.0 RC3.zip: fix regarding inability to get to create groups page. updated simplified instructions, sadly still not cool html ones and also added ability to delete groups, delete categories and of course the menu options to get to these.
Groups v2.0.0 RC3c.zip: fix regarding edit being stated as 70's on group stages, requires re-installtion of the plugin only.
Groups v2.0.0 RC4.zip: various bug fixes and new general setting, please reupload all files and then reinstall the product.
Groups v2.0.0 RC5.zip: bug fixes regarding fixing links to forums being broken and forcing redirects for create group outcomes.
Groups v2.0.0 RC6.zip: various bug fixes including table prefixes in admincp, invitations system now features in-line erroneous username fall-back and clean up regarding broken images in viewthread.php
Groups v2.0.0 RC7.zip: bug fixes including missing phrases and missing 'noavatar.gif for group leader on groups info.
Groups v2.0.0 RC8.zip: various bug fixes including missing phrases, smilies not working. new function to turn of new group moderation. form now working on print_no_permission page (thanks Adrian) and something else i forgot.
Groups v2.0.0 RC9.zip: fixes two spelling mistakes, moves viewthread.php string_replacements to admincp and simplifies the installer experience. (yeah i thought there'd be more to it too).
Groups v2.0.0 RC9b.zip: re-fixes two spelling mistakes, fixes a viewthread.php string_replacement via the admincp and turns the default random image count down to that of which is provided.
Groups v2.0.0 RC10.zip: optimises some of the code, cuts down on queries in exchange for additional joins and now forces compatibility in groups/viewthread.php with vBulletin options. also adds new option in admincp in order to make usercp listing work better out of the box.
Groups v2.0.0 RC11.zip: fixes a problem with avatars not displaying correctly in thread listing and also optimises the code in membership.php
Groups v2.0.0.zip: adds and array_merge to the code and smilie popup fixed. now features hooks for plug-in 'easability'. uCS integration moved to external plugin too.
Groups v2.0.1.zip: removes one hook, fixes problem with membership.php, fixes problem editgroup.php not remembering options and fixes avatar problem.
Groups v2.0.2.zip: various bug fixes (like missing pagenavs, more elegant removal of reputation button and infraction button and php notices), one or two new features (like intuitive page titles) and now fully phrased.
Groups v2.0.3.zip: bug fix regarding now being able to select categories. includes a new feature which is basically pagination for the thread listings.
Groups v2.0.4.zip: bug fix regarding not being able to moderate group memberships.
Groups v2.0.5.zip: bug fix regarding those introduced via 2.0.4, new features such as double post prevention disable, admins can override privacy settings, usergroup permission text more intuitive and end-user usability increased with modification to threadbit on groups.php. group leaders can now kick users from there groups.
Groups v2.0.6.zip: bug fix including report, missing edit button and other misc small bugs, new features such as disable hidden groups, allow mods to see private groups, and resign from group handing off to another user.
Groups v2.0.7.zip: bug fix including fixing post counts, thread goto's and fatal php errors.
Groups v2.0.8.zip: bug fix regarding inability to delete posts, problem with editing posts and other misc errors.
Groups v2.0.9.zip: various bug fixes including wywiwyg error, admin cp error and redirect/goto errors.
Groups v2.0.9b.zip: fixes problem with upgrade4.php
Groups v2.0.10.zip: various bug fixes including acknowledging renamed modcp and admincp dir's also adds option regarding removing of posts at group exit/kick.
Groups v2.0.11.zip: various bug fixes including security/privacy fixes.
Groups v2.0.12.zip: permission bug fixed.
Groups v2.0.13.zip: various bug fixes including ability to ignore members in groups and newreply bug.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Okay, I put the full URL in the paths under the style options and the forum images are now working, thanks. I have a custom header and have to work out the paths to the images as they are not set in the style options. Also, my forum root is forum.php not index.php so my the link back to my forum says http://www.guitarblast.com/groups/forum.php, again we don't want groups in there.
Here is how my cofig is set:
PHP Code:
chdir("/home/guitar/public_html");
sadly the forum thing in the navbar is not something i forsaw, in fact if it was upto me, the navbar would have the groups at the root and not the forums, however jelsoft :ermmm: anyhoo to fix that you're gonna have to do a file edit.
Thats what they are currently (can't have trailing slash) .. i tried /images/buttons which had the same effect.. http://www.mysite.com/images/xxxx returned even less images... like even the dropdown arrows and buttons were missing..
still no style or css on the pages tho..
Quote:
i can give you the exact text if you run this file Attachment 53877
Thats what they are currently (can't have trailing slash) .. i tried /images/buttons which had the same effect.. http://www.mysite.com/images/xxxx returned even less images... like even the dropdown arrows and buttons were missing..
still no style or css on the pages tho..
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
// temp admin options
// url of the grps
$groupurl = "$vbulletin->options[homeurl]/groups/?groupid=$groupid";
if ($vbulletin->options['grps_status']=="0") {
eval(print_standard_error('grps_statusoff'));
}
// this switch handles the right column
$grps_pagetitle = "Browse Groups";
// ###################### pagenav
$pagenavcount = $db->query_first("
SELECT COUNT(*) AS totalgroups
FROM grps
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
WHERE grps.approved = '1'
ORDER BY grps.title
");
switch ($vbulletin->GPC['view'])
{
case "alphabetical":
// creates the pagenav
$page = ($vbulletin->GPC['page'] < 1) ? "1" : intval($vbulletin->GPC['page']);
$totalgroups = $db->query_first("SELECT COUNT(groupid) AS total FROM grps WHERE approved = '1' ");
$totalgroups = $totalgroups['total'];
$currentlocation = "browse.php?" . $vbulletin->session->vars['sessionurl'] ."view=alphabetical";
$perpage = "25";
$pagenumber = $page;
$lowerlimit = ($page * $perpage);
$query_lowerlimit = ($lowerlimit - $perpage);
// add's page title
$grps_pagetitle .= " Alphabetically";
$grps_alphabetical = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps_setting.hidden_group != '1'
ORDER BY grps.title
LIMIT $query_lowerlimit, $perpage ");
$grps_categoryinfo['catname'] = "All " . $vbulletin->options[hometitle] . " Groups In Alphabetical Order";
$hideviewall = 1;
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
if (!$db->num_rows($grps_alphabetical))
{ // no groups, this becomes obselete after the first group gets created
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups currently found in the database</td></tr>";
}
else
{ // display the information
while ($grps_categoryinfo = $db->fetch_array($grps_alphabetical))
{
$grps_categoryinfo['title'] = stripslashes($grps_categoryinfo['title']);
$grps_categoryinfo['description'] = nl2br(stripslashes($grps_categoryinfo['description']));
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catbit") . "\";");
} //now echo the date into the template
}
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
break;
case "bymembers":
// creates the pagenav
$page = ($vbulletin->GPC['page'] < 1) ? "1" : intval($vbulletin->GPC['page']);
$totalgroups = $db->query_first("SELECT COUNT(groupid) AS total FROM grps WHERE approved = '1'");
$totalgroups = $totalgroups['total'];
$currentlocation = "browse.php?" . $vbulletin->session->vars['sessionurl'] ."view=bymembers";
$perpage = "25";
$pagenumber = $page;
$lowerlimit = ($page * $perpage);
$query_lowerlimit = ($lowerlimit - $perpage);
// add's page title
$grps_pagetitle .= " By Number Of Members";
$grps_members = $db->query_read("
SELECT COUNT(*) AS totalmembers, grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps_user
LEFT JOIN grps ON (grps.groupid = grps_user.groupid)
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps_setting.hidden_group != '1'
GROUP BY grps.groupid
ORDER BY totalmembers DESC, grps.title
LIMIT $query_lowerlimit, $perpage ");
$grps_categoryinfo['catname'] = $vbulletin->options[hometitle] . " Groups Ordered By Size";
$hideviewall = 1;
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
if (!$db->num_rows($grps_members))
{ // no groups, this becomes obselete after the first group gets created
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups currently found in the database</td></tr>";
}
else
{ // display the information
while ($grps_categoryinfo = $db->fetch_array($grps_members))
{
$grps_categoryinfo['title'] = stripslashes($grps_categoryinfo['title']);
$grps_categoryinfo['description'] = nl2br(stripslashes($grps_categoryinfo['description']));
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catbit") . "\";");
} //now echo the date into the template
}
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
break;
default:
// creates the pagenav
$page = ($vbulletin->GPC['page'] < 1) ? "1" : intval($vbulletin->GPC['page']);
$totalgroups = $db->query_first("SELECT COUNT(groupid) AS total FROM grps WHERE approved = '1'");
$totalgroups = $totalgroups['total'];
$currentlocation = "browse.php?" . $vbulletin->session->vars['sessionurl'];
$perpage = "25";
$pagenumber = $page;
$lowerlimit = ($page * $perpage);
$query_lowerlimit = ($lowerlimit - $perpage);
// page title for grouphome.
$grps_pagetitle .= " By Categories";
// selects the number of validated groups for group home
$total = $db->query_read("
SELECT groupid
FROM grps
WHERE approved = 1
");
$num = number_format($db->num_rows($total));
$grps_limit=10;
if ($vbulletin->options[grps_moderation]=="1")
{
$grps_moderation="WHERE grps.visible=1";
}
$grps_categories = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps_categories
INNER JOIN grps ON grps_categories.catid = grps.catid AND grps.approved = '1'
INNER JOIN grps AS G2 ON grps_categories.catid = G2.catid AND G2.approved = '1' AND grps.title >= G2.title
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps_setting.hidden_group != '1'
GROUP BY grps_categories.title, grps.title, grps.description, grps.leaderid
HAVING COUNT(*) <= 10
ORDER BY grps.catid, grps.title
LIMIT $query_lowerlimit, $perpage ");
if (!$db->num_rows($grps_categories))
{ // no groups, this becomes obselete after the first group gets created
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups found in this catergory at this time</td></tr>";
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
}
else
{ // display the information
$row = "0";
while ($grps_categoryinfo = $db->fetch_array($grps_categories))
{
if ($row == 0)
{
if ($grps_categoryinfo[catid] != $grps_catidstore)
{
// reset catname store
$grps_catidstore = $grps_categoryinfo['catid'];
}
$row++;
} //now echo the date into the template
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
}
if ($vbulletin->GPC['c'] != "")
{
$c = intval($vbulletin->GPC['c']);
$groupsforcat = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps.catid = $c AND grps_setting.hidden_group != '1'
ORDER BY grps.title
LIMIT $query_lowerlimit, $perpage ");
$catname = $db->query_first("
SELECT title AS catname, catid
FROM grps_categories
WHERE catid = $c ");
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
if (!$db->num_rows($groupsforcat))
{ // no groups, this becomes obselete after the first group gets created
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups found in this catergory at this time</td></tr>";
}
else
{ // display the information
while ($grps_categoryinfo = $db->fetch_array($groupsforcat))
{
$grps_categoryinfo['title'] = stripslashes($grps_categoryinfo['title']);
$grps_categoryinfo['description'] = nl2br(stripslashes($grps_categoryinfo['description']));
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catbit") . "\";");
} //now echo the date into the template
}
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
}
}
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
// temp admin options
// url of the grps
$groupurl = "$vbulletin->options[homeurl]/groups/?groupid=$groupid";
if ($vbulletin->options['grps_status']=="0") {
eval(print_standard_error('grps_statusoff'));
}
// this switch handles the right column
$grps_pagetitle = "Browse Groups";
// ###################### pagenav
$pagenavcount = $db->query_first("
SELECT COUNT(*) AS totalgroups
FROM grps
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
WHERE grps.approved = '1'
ORDER BY grps.title
");
switch ($vbulletin->GPC['view'])
{
case "alphabetical":
// creates the pagenav
$page = ($vbulletin->GPC['page'] < 1) ? "1" : intval($vbulletin->GPC['page']);
$totalgroups = $db->query_first("SELECT COUNT(groupid) AS total FROM grps WHERE approved = '1' ");
$totalgroups = $totalgroups['total'];
$currentlocation = "browse.php?" . $vbulletin->session->vars['sessionurl'] ."view=alphabetical";
$perpage = "25";
$pagenumber = $page;
$lowerlimit = ($page * $perpage);
$query_lowerlimit = ($lowerlimit - $perpage);
// add's page title
$grps_pagetitle .= " Alphabetically";
$grps_alphabetical = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps_setting.hidden_group != '1'
ORDER BY grps.title
LIMIT $query_lowerlimit, $perpage ");
$grps_categoryinfo['catname'] = "All " . $vbulletin->options[hometitle] . " Groups In Alphabetical Order";
$hideviewall = 1;
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
if (!$db->num_rows($grps_alphabetical))
{ // no groups, this becomes obselete after the first group gets created
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups currently found in the database</td></tr>";
}
else
{ // display the information
while ($grps_categoryinfo = $db->fetch_array($grps_alphabetical))
{
$grps_categoryinfo['title'] = stripslashes($grps_categoryinfo['title']);
$grps_categoryinfo['description'] = nl2br(stripslashes($grps_categoryinfo['description']));
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catbit") . "\";");
} //now echo the date into the template
}
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
break;
case "bymembers":
// creates the pagenav
$page = ($vbulletin->GPC['page'] < 1) ? "1" : intval($vbulletin->GPC['page']);
$totalgroups = $db->query_first("SELECT COUNT(groupid) AS total FROM grps WHERE approved = '1'");
$totalgroups = $totalgroups['total'];
$currentlocation = "browse.php?" . $vbulletin->session->vars['sessionurl'] ."view=bymembers";
$perpage = "25";
$pagenumber = $page;
$lowerlimit = ($page * $perpage);
$query_lowerlimit = ($lowerlimit - $perpage);
// add's page title
$grps_pagetitle .= " By Number Of Members";
$grps_members = $db->query_read("
SELECT COUNT(*) AS totalmembers, grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps_user
LEFT JOIN grps ON (grps.groupid = grps_user.groupid)
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps_setting.hidden_group != '1'
GROUP BY grps.groupid
ORDER BY totalmembers DESC, grps.title
LIMIT $query_lowerlimit, $perpage ");
$grps_categoryinfo['catname'] = $vbulletin->options[hometitle] . " Groups Ordered By Size";
$hideviewall = 1;
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
if (!$db->num_rows($grps_members))
{ // no groups, this becomes obselete after the first group gets created
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups currently found in the database</td></tr>";
}
else
{ // display the information
while ($grps_categoryinfo = $db->fetch_array($grps_members))
{
$grps_categoryinfo['title'] = stripslashes($grps_categoryinfo['title']);
$grps_categoryinfo['description'] = nl2br(stripslashes($grps_categoryinfo['description']));
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catbit") . "\";");
} //now echo the date into the template
}
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
break;
default:
// creates the pagenav
$page = ($vbulletin->GPC['page'] < 1) ? "1" : intval($vbulletin->GPC['page']);
$totalgroups = $db->query_first("SELECT COUNT(groupid) AS total FROM grps WHERE approved = '1'");
$totalgroups = $totalgroups['total'];
$currentlocation = "browse.php?" . $vbulletin->session->vars['sessionurl'];
$perpage = "25";
$pagenumber = $page;
$lowerlimit = ($page * $perpage);
$query_lowerlimit = ($lowerlimit - $perpage);
// page title for grouphome.
$grps_pagetitle .= " By Categories";
// selects the number of validated groups for group home
$total = $db->query_read("
SELECT groupid
FROM grps
WHERE approved = 1
");
$num = number_format($db->num_rows($total));
$grps_limit=10;
if ($vbulletin->options[grps_moderation]=="1")
{
$grps_moderation="WHERE grps.visible=1";
}
$grps_categories = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps_categories
INNER JOIN grps ON grps_categories.catid = grps.catid AND grps.approved = '1'
INNER JOIN grps AS G2 ON grps_categories.catid = G2.catid AND G2.approved = '1' AND grps.title >= G2.title
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps_setting.hidden_group != '1'
GROUP BY grps_categories.title, grps.title, grps.description, grps.leaderid
HAVING COUNT(*) <= 10
ORDER BY grps.catid, grps.title
LIMIT $query_lowerlimit, $perpage ");
if (!$db->num_rows($grps_categories))
{ // no groups, this becomes obselete after the first group gets created
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups found in this catergory at this time</td></tr>";
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
}
else
{ // display the information
$row = "0";
while ($grps_categoryinfo = $db->fetch_array($grps_categories))
{
if ($row == 0)
{
if ($grps_categoryinfo[catid] != $grps_catidstore)
{
// reset catname store
$grps_catidstore = $grps_categoryinfo['catid'];
}
$row++;
} //now echo the date into the template
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
}
if ($vbulletin->GPC['c'] != "")
{
$c = intval($vbulletin->GPC['c']);
$groupsforcat = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_categories.title AS catname, grps.approved, grps.leaderid, grps_setting.hidden_group
FROM grps
LEFT JOIN grps_categories ON (grps_categories.catid = grps.catid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps.catid = $c AND grps_setting.hidden_group != '1'
ORDER BY grps.title
LIMIT $query_lowerlimit, $perpage ");
$catname = $db->query_first("
SELECT title AS catname, catid
FROM grps_categories
WHERE catid = $c ");
eval("\$grps_catbits = \"" . fetch_template("groups_browse_cathead") . "\";");
if (!$db->num_rows($groupsforcat))
{ // no groups, this becomes obselete after the first group gets created
$grps_catbits .= "<tr><td class=\"alt1\" align=\"center\">no groups found in this catergory at this time</td></tr>";
}
else
{ // display the information
while ($grps_categoryinfo = $db->fetch_array($groupsforcat))
{
$grps_categoryinfo['title'] = stripslashes($grps_categoryinfo['title']);
$grps_categoryinfo['description'] = nl2br(stripslashes($grps_categoryinfo['description']));
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catbit") . "\";");
} //now echo the date into the template
}
eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") . "\";");
}
}
GRPS: Groups Commune 2.0.x Details »»
(right click open in new window)
About Developer
Visit Web Site
DB Changes 
No support by the author.
09-24-2006, 08:58 PM
As for the tatt pics, they're are on the way, sadly i was too busy sorting all this out to get on the job earlier 
.. well consider yourself told! I've been waiting for this for a loooooong time! And where's those tattoo pics?
