phpBB España Oficial

Código: Seleccionar todo

$bank_row = $db->sql_fetchrow($result);

		$holding[$poster_id] = ( $bank_row['holding'] ) ? $bank_row['holding'] : '0';
		$bank_row = '';
	}

Código: Seleccionar todo

	$sql = "SELECT *
		FROM " . USER_ITEMS_TABLE . "
		WHERE user_id='{$poster_id}'
			AND ( worn = 0 or worn = 1 )
		GROuP BY `item_name`
		ORDER BY `id`";
	$result = $db->sql_query($sql);

	$user_items = '<br />';

	while ( $t_row = $db->sql_fetchrow($result) )
	{
		if ($t_row['icon_location'] != '')
            {
		      $img_src = $t_row['icon_location'];
			$user_items .= ' <img src="' . $img_src . '" title="' . $t_row['item_name'] . '" alt="' . $t_row['item_name'] . '" />';
		}
		elseif (file_exists('shop/images/' . $t_row['item_name'] . '.jpg'))
		{
			$user_items .= ' <img src="shop/images/' . $t_row['item_name'] . '.jpg" title="' . $t_row['item_name'] . '" alt="' . $t_row['item_name'] . '" />';
		}
		elseif (file_exists('shop/images/' . $t_row['item_name'] . '.png'))
		{
			$user_items .= ' <img src="shop/images/' . $t_row['item_name'] . '.png" title="' . $t_row['item_name'] . '" alt="' . $t_row['item_name'] . '" />';
		}
		elseif (file_exists('shop/images/' . $t_row['item_name'] . '.gif'))
		{
			$user_items .= ' <img src="shop/images/' . $t_row['item_name'] . '.gif" title="' . $t_row['item_name'] . '" alt="' . $t_row['item_name'] . '" />';
		}
}