phpBB.de

Code: Alles auswählen

// Newest Nickpages Mod
$sql = "SELECT a.user_id, a.username, b.name, b.created FROM ".USERS_TABLE." a, ".NICKPAGE_TABLE." b WHERE b.uid=a.user_id ORDER BY b.created DESC LIMIT 6";

if (!$result = $db->sql_query($sql))
    {
        message_die(GENERAL_ERROR, 'Could not query Nickpage information', '', __LINE__, __FILE__, $sql);
    }

$nickpage_list = $db->sql_fetchrowset($result);
for($i = 0; $i < count($nickpage_list); $i++)
{
	$username = $nickpage_list[$i]['username'];
	$userdate = $nickpage_list[$i]['created'];


	if(strlen($username) > 17) { // Limit title length to avoid wrap
            $username = strip_tags($username, '<a><i><b><ul><li>');
            $username = substr($username,0,15);
            $username .= "...";
             }


	$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
	$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

	$template->assign_block_vars('nickpagemod', array(
			"ROW_COLOR" => "#" . $row_color,
			"ROW_CLASS" => $row_class,
			'NAME' => '<a href="' . append_sid("nickpage.php?user=$username") . '">' . $username . '</a>',
			'LSEEN_TIME'     => date("m.d.y", $nickpage_list[$i]['created']),
			)
			);
		}

Code: Alles auswählen

'L_NEWEST_NICKPAGES' => $lang['Newest_Nickpages'],

Code: Alles auswählen

<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
<tr>
<th nowrap="nowrap" colspan="2">{L_NEWEST_NICKPAGES}</th>
</tr>
<!-- BEGIN nickpagemod -->
<tr>
<td class="row1"><span class="gensmall"><img src="templates/fisubsilversh/images/post_ind1_bl.gif" />&nbsp;{nickpagemod.NAME}</span></td>
<td class="row2" align="center"><span class="gensmall">{nickpagemod.LSEEN_TIME}</span></td>
</tr>
<!-- END nickpagemod -->
</table>

Code: Alles auswählen

'U_NICKPAGE' => append_sid('nickpage.'.$phpEx.'?admin='.$userdata['username']),