Code: Alles auswählen
#-----[ AFTER, ADD ]------------------------------------------
#
if ( $board_config['vault_display_topics'] )
{
$sql = " SELECT * FROM " . VAULT_USERS_TABLE . "
WHERE owner_id = $poster_id ";
if( !($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql);
}
$shares = $db->sql_fetchrow($result);
$share = '<br />'.$lang['Vault_on_account'].(( $shares['account_protect'] && $userdata['user_level'] != ADMIN ) ? $lang['Vault_confidential'] : intval($shares['account_sum']).' '.$board_config['points_name']);
$share .= '<br />'.$lang['Vault_loan_account'].(( $shares['loan_protect'] && $userdata['user_level'] != ADMIN ) ? $lang['Vault_confidential'] : intval($shares['loan_sum']).' '.$board_config['points_name']);
}Code: Alles auswählen
if ( $board_config['vault_display_profile'] )
{
$template->assign_block_vars('display_shares',array());
$sql = " SELECT e.* , eu .* FROM " . VAULT_EXCHANGE_TABLE . " e
LEFT JOIN " . VAULT_EXCHANGE_USERS_TABLE . " eu ON ( eu.user_id = " . $profiledata['user_id'] . " AND e.stock_id = eu.stock_id ) ";
if( !($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql);
}
$shares = $db->sql_fetchrowset($result);
for ( $i = 0 ; $i < count($shares) ; $i ++ )
{
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('display_shares.shares' , array(
'SHARE_ROW' => $row_class,
'SHARE_NAME' => vault_get_lang($shares[$i]['stock_name']),
'SHARE_SUM' => intval($shares[$i]['stock_amount']),
));
}
$sql = " SELECT * FROM " . VAULT_USERS_TABLE . "
WHERE owner_id = " . $profiledata['user_id'];
if( !($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql);
}
$accounts = $db->sql_fetchrow($result);
$on_account = ( $accounts['account_protect'] && $userdata['user_level'] != ADMIN && $accounts['owner_id'] != $userdata['user_id'] ) ? $lang['Vault_confidential'] : intval($accounts['account_sum']).' '.$board_config['points_name'];
$loan = ( $accounts['loan_protect'] && $userdata['user_level'] != ADMIN && $accounts['owner_id'] != $userdata['user_id'] ) ? $lang['Vault_confidential'] : intval($accounts['loan_sum']).' '.$board_config['points_name'];
}