| Code:
|
$postrow = array();
if ($row = $db->sql_fetchrow($result))
{
do
{
$postrow[] = $row;
}
while ($row = $db->sql_fetchrow($result));
$db->sql_freeresult($result);
$total_posts = count($postrow);
}
|
| Code:
|
$postrow = array();
$userids= array();
if ($postrow = $db->sql_fetchrowset($result)) {
foreach($postrow as $key => $value) {
$sql = 'SELECT ufv.value as value, uf.name as name
FROM `' . $user_prefix . '_users_field_values` ufv, `' . $user_prefix . '_users_fields` uf
WHERE ufv.uid="' . $postrow[$key]['user_id'] . '"
AND uf.fid = ufv.fid';
$results = $db->sql_query($sql);
$row = $db->sql_fetchrowset($results, MYSQL_ASSOC);
foreach($row as $key2 => $value2) {
$postrow[$key]['custom_fields'][$row[$key2]['name']] = $row[$key2]['value'];
}
}
$db->sql_freeresult($result);
$total_posts = count($postrow);
}
|
| Code:
|
$template->assign_block_vars('postrow', array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'POSTER_NAME' => $poster,
'POSTER_RANK' => $poster_rank,
'RANK_IMAGE' => $rank_image,
'POSTER_JOINED' => $poster_joined,
'POSTER_POSTS' => $poster_posts,
'POSTER_FROM' => $poster_from,
'POSTER_AVATAR' => $poster_avatar,
'POST_DATE' => $post_date,
'POST_SUBJECT' => $post_subject,
'MESSAGE' => $message,
'SIGNATURE' => $user_sig,
'EDITED_MESSAGE' => $l_edited_by,
|
| Code:
|
|
'GAMERTAG' =>$postrow[$i]['custom_fields']['Gamertag'],
|
| Code:
|
|
{postrow.RANK_IMAGE}<br />
|
| Code:
|
|
<a href="http://gamercard.xbox.com/{postrow.GAMERTAG}.card"><img src="http://card.mygamercard.net/mini/{postrow.GAMERTAG}.png" border=0></a><br />
|
38.107.179.216
