SimplePortal
Customization => Blocks and Modifications => Topic started by: NIBOGO on March 09, 2010, 09:36:05 PM
-
This is a block to show the recent groups in the SMF Social Groups Mod (http://www.smfpacks.com/index.php?action=page;sa=sg):
Create a new php block and add this content:
SMF 2.0
global $smcFunc, $scripturl;
echo'Recent Groups:<br />';
$dbresult = $smcFunc['db_query']('', '
SELECT id_group, group_name, image
FROM {db_prefix}social_groups
ORDER BY id_group DESC
LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
echo'<a href="'.$scripturl.'?action=sgroups;sa=view;id='.$row['id_group'].'"><img src="'.$row['image'].'" alt="'.$row['group_name'].'" /></a>';
}
$smcFunc['db_free_result']($dbresult);
SMF 1.1.X:
global $db_prefix, $scripturl;
echo 'Recent Groups:<br />';
$dbresult = db_query('
SELECT ID_GROUP, groupName, image
FROM {$db_prefix}social_groups
ORDER BY ID_GROUP DESC
LIMIT 5', __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($dbresult))
{
echo'<a href="'.$scripturl.'?action=sgroups;sa=view;id='.$row['ID_GROUP'].'"><img src="'.$row['image'].'" alt="'.$row['groupName'].'" /></a>';
}
mysql_free_result($dbresult);
Best Regards
-
Moved to the Blocks and Modifications board.
Note for all, this block will only work for SMF 2.
-
Moved to the Blocks and Modifications board.
Note for all, this block will only work for SMF 2.
Thanks for remind me, already added to the topic title
-
For SMF 1.1...
global $db_prefix, $scripturl;
echo 'Recent Groups:<br />';
$dbresult = db_query('
SELECT ID_GROUP, groupName, image
FROM {$db_prefix}social_groups
ORDER BY ID_GROUP DESC
LIMIT 5', __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($members_result))
{
echo'<a href="'.$scripturl.'?action=sgroups;sa=view;id='.$row['ID_GROUP'].'"><img src="'.$row['image'].'" alt="'.$row['groupName'].'" /></a>';
}
mysql_free_result($dbresult);
-
For SMF 1.1...
global $db_prefix, $scripturl;
echo 'Recent Groups:<br />';
$dbresult = db_query('
SELECT ID_GROUP, groupName, image
FROM {$db_prefix}social_groups
ORDER BY ID_GROUP DESC
LIMIT 5', __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($members_result))
{
echo'<a href="'.$scripturl.'?action=sgroups;sa=view;id='.$row['ID_GROUP'].'"><img src="'.$row['image'].'" alt="'.$row['groupName'].'" /></a>';
}
mysql_free_result($dbresult);
There is a error in that code that I already fix in the SMF 2.0 version, here is the patched version:
global $db_prefix, $scripturl;
echo 'Recent Groups:<br />';
$dbresult = db_query('
SELECT ID_GROUP, groupName, image
FROM {$db_prefix}social_groups
ORDER BY ID_GROUP DESC
LIMIT 5', __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($dbresult))
{
echo'<a href="'.$scripturl.'?action=sgroups;sa=view;id='.$row['ID_GROUP'].'"><img src="'.$row['image'].'" alt="'.$row['groupName'].'" /></a>';
}
mysql_free_result($dbresult);
Thanks ccbtimewiz :)
-
You're welcome.
-
Can the group name be added above the group image? :|
-
Can the group name be added above the group image? :|
Sure:
global $smcFunc, $scripturl;
echo'Recent Groups:<br />';
$dbresult = $smcFunc['db_query']('', '
SELECT id_group, group_name, image
FROM {db_prefix}social_groups
ORDER BY id_group DESC
LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
echo'<a href="'.$scripturl.'?action=sgroups;sa=view;id='.$row['id_group'].'"><img src="'.$row['image'].'" alt="'.$row['group_name'].'" /><br />'.$row['group_name'].'</a>';
}
$smcFunc['db_free_result']($dbresult);
You can use some tags to center the text like <div align="center">'.$row['group_name'].'</div>
-
Isn't work for me. =[
The image path is wrong.
PS: Most difficult thing in this forum is type the correct captcha. lol
-
The image link isn't working, how can this be fixed?
-
Okay, I managed to fix the broken image link. Simply replace this piece of code:
<img src="'.$row['image'].'" alt="'.$row['group_name'].'" />
With this:
<img src="http://www.fullurltoyourboard.com/sogroups/'.$row['image'].'" alt="'.$row['group_name'].'" />
Replace the link with the full link to your forum installation and it should work. I'm not a coder, so this is only a quick fix, if anyone has a better idea it would be appreciated. :D