SimplePortal
Customization => Blocks and Modifications => Block Requests => Topic started by: Kobar on November 15, 2012, 04:14:02 AM
-
Hello all,
I have this php block for blogs set as a block. My question: How do I:
- make this compatible with Member Color Link
- remove date (for example: on November 12, 2012, 14:54:17 )
- italicize the subject
Here is the php block:
<?php
global $smcFunc, $context, $scripturl, $modSettings, $txt, $settings;
$limit = 5;
$sql = $smcFunc['db_query']('','
SELECT co.id_initial, co.subject, co.body, co.time, co.id_cat, co.icon, co.id_member, ca.id_cat, ca.title,
mem.avatar, mem.real_name, mem.id_member,
IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type
FROM {db_prefix}blog_comments AS co, {db_prefix}blog_categories AS ca, {db_prefix}members AS mem
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = mem.id_member)
WHERE co.is_started = {int:s} AND co.id_cat = ca.id_cat AND mem.id_member = co.id_member
ORDER BY co.id_initial DESC
LIMIT {int:limit}',
array(
'limit' => $limit,
's' => 1,
)
);
$context['info'] = array();
$width = 50;
$height = 50;
while($row = $smcFunc['db_fetch_assoc']($sql))
{
$image = '<img src="'.$settings['images_url'].'/post/'.$row['icon'].'.gif" alt="" /> ';
$context['info'][] = array(
'id' => $row['id_initial'],
'id_member' => $row['id_member'],
'member' => '<a href="'.$scripturl.'?action=profile;u='.$row['id_member'].'">'.$row['real_name'].'</a>',
'avatar' => $row['avatar'] == '' ? ($row['id_attach'] > 0 ? '<img width="'.$width.'" height="'.$height.'" src="' . (empty($row['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $row['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) . '" alt="" class="avatar" border="0" />' : '') : (stristr($row['avatar'], 'http://') ? '<img width="'.$width.'" height="'.$height.'"src="' . $row['avatar'] . '" alt="" class="avatar" border="0" />' : '<img width="'.$width.'" height="'.$height.'"src="' . $modSettings['avatar_url'] . '/' . $smcFunc['htmlspecialchars']($row['avatar']) . '" alt="" class="avatar" border="0" />'),
'subject' => $row['subject'],
'time' => timeformat($row['time']),
'id_cat' => $row['id_cat'],
'title' => $row['title'],
'icon' => !empty($row['icon']) ? $image : '',
'cat' => '<a href="'.$scripturl.'?blog='.$row['id_member'].';sa=cat;id='.$row['id_cat'].'">'.$row['title'].'</a>',
);
}
echo'
<table style="width: 100%;">';
foreach($context['info'] AS $post)
{
echo'
<tr>
<td>
<div class="smalltext">
'.$post['icon'].'<a href="'.$scripturl.'?blog='.$post['id_member'].';sa=topic;id='.$post['id'].'" style="font-weight: bold;">'.$post['subject'].'</a> '.$txt['by'].' '.$post['member'].' '.$txt['on'].' '.$post['time'].'
</div>
</td>
</tr>';
}
echo'
</table>';
?>
I know that you have your own Blog block by default but it's not working with the ADK Blog mod. :)
Thanks in advance,
-
- remove date (for example: on November 12, 2012, 14:54:17 )
- italicize the subject
Find
'.$post['icon'].'<a href="'.$scripturl.'?blog='.$post['id_member'].';sa=topic;id='.$post['id'].'" style="font-weight: bold;">'.$post['subject'].'</a> '.$txt['by'].' '.$post['member'].' '.$txt['on'].' '.$post['time'].'
replace with
'.$post['icon'].'<i><a href="'.$scripturl.'?blog='.$post['id_member'].';sa=topic;id='.$post['id'].'" style="font-weight: bold;">'.$post['subject'].'</a></i> '.$txt['by'].' '.$post['member'].'
As for membergroup color link, Gotta do some database retrieving. may try and get to that later if i have time.
Install this MOD, works MUCH better than member group color link MOD, because i never have to do any modifications to make group colors show like you have to. http://custom.simplemachines.org/mods/index.php?mod=3067
-
Try this
<?php
global $smcFunc, $context, $scripturl, $modSettings, $txt, $settings;
$limit = 5;
$sql = $smcFunc['db_query']('','
SELECT co.id_initial, co.subject, co.body, co.time, co.id_cat, co.icon, co.id_member, ca.id_cat, ca.title,
mem.avatar, mem.real_name, mem.id_member, gp.online_color,
IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type
FROM {db_prefix}blog_comments AS co, {db_prefix}blog_categories AS ca, {db_prefix}members AS mem
LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = mem.id_member)
LEFT JOIN {db_prefix}membergroups AS gp ON (gp.id_group = mem.id_group)
WHERE co.is_started = {int:s} AND co.id_cat = ca.id_cat AND mem.id_member = co.id_member
ORDER BY co.id_initial DESC
LIMIT {int:limit}',
array(
'limit' => $limit,
's' => 1,
)
);
$context['info'] = array();
$width = 50;
$height = 50;
while($row = $smcFunc['db_fetch_assoc']($sql))
{
$image = '<img src="'.$settings['images_url'].'/post/'.$row['icon'].'.gif" alt="" /> ';
if ((!empty($row['online_color'])) && $row['online_color'])
$name = '<span style="color:'.$row['online_color'].'">'.$row['real_name'].'</span>';
else
$name = '<span>' . $row['real_name']. '</span>';
$context['info'][] = array(
'id' => $row['id_initial'],
'id_member' => $row['id_member'],
'member' => '<a href="'.$scripturl.'?action=profile;u='.$row['id_member'].'">',$name,'</a>',
'avatar' => $row['avatar'] == '' ? ($row['id_attach'] > 0 ? '<img width="'.$width.'" height="'.$height.'" src="' . (empty($row['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $row['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) . '" alt="" class="avatar" border="0" />' : '') : (stristr($row['avatar'], 'http://') ? '<img width="'.$width.'" height="'.$height.'"src="' . $row['avatar'] . '" alt="" class="avatar" border="0" />' : '<img width="'.$width.'" height="'.$height.'"src="' . $modSettings['avatar_url'] . '/' . $smcFunc['htmlspecialchars']($row['avatar']) . '" alt="" class="avatar" border="0" />'),
'subject' => $row['subject'],
'time' => timeformat($row['time']),
'id_cat' => $row['id_cat'],
'title' => $row['title'],
'icon' => !empty($row['icon']) ? $image : '',
'cat' => '<a href="'.$scripturl.'?blog='.$row['id_member'].';sa=cat;id='.$row['id_cat'].'">'.$row['title'].'</a>',
);
}
echo'
<table style="width: 100%;">';
foreach($context['info'] AS $post)
{
echo'
<tr>
<td>
<div class="smalltext">
'.$post['icon'].'<i><a href="'.$scripturl.'?blog='.$post['id_member'].';sa=topic;id='.$post['id'].'" style="font-weight: bold;">'.$post['subject'].'</a></i> '.$txt['by'].' '.$post['member'].'
</div>
</td>
</tr>';
}
echo'
</table>';
?>
-
Thank you although the 'member color link' is still not compatible with it.. :(
I'm in no position to trade the MCL for the SimpleColorizer
-
I'll look into it, but i dont use adk blog so i cant really test it out, and go from there.
I'm in no position to trade the MCL for the SimpleColorizer
Not sure what you mean by this? You can actually use both at the same time. Simple Colorizer makes NO file edits whatsoever, just hooks. So it installs clean
-
I have both installed on my forum; I am in love with SimpleColorizer! Its made all the links everywhere pretty XD; haha