Small Pirate

function post

$request = db_query("		SELECT
			b.ID_BOARD, b.name AS bname, t.puntos, c.ID_CAT, c.name AS cname, m.ID_TOPIC, m.ID_MSG,
			t.ID_MEMBER_STARTED, t.ID_FIRST_MSG, t.ID_LAST_MSG, m.body, m.smileysEnabled,
			m.subject, m.posterTime
		FROM (" . (empty($have_temp_table) ? '' : "{$db_prefix}topics_posted_in AS pi, ") . "{$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
			LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
		WHERE " . (empty($have_temp_table) ? '' : "t.ID_TOPIC = pi.ID_TOPIC
			AND ") . "m.ID_MEMBER = $memID
			AND m.ID_TOPIC = t.ID_TOPIC
			AND t.ID_BOARD = b.ID_BOARD
			AND $user_info[query_see_board]
			AND t.ID_FIRST_MSG = m.ID_MSG
		ORDER BY m.ID_MSG DESC
		LIMIT $_REQUEST[start], $maxIndex", __FILE__, __LINE__);
	$counter = $_REQUEST['start'];
	$context['posts'] = array();
	$board_ids = array('own' => array(), 'any' => array());
	while ($row = mysql_fetch_assoc($request))
	{
    censorText($row['subject']);

	$context['posts'][++$counter] = array(
			'counter' => $counter,
			'board' => array(
				'name' => $row['bname'],
			    'id' => $row['ID_BOARD']),
			'topic' => $row['ID_TOPIC'],
			'subject' => $row['subject'],
			'time' => timeformat($row['posterTime']),
			'id' => $row['ID_MSG'],
  	  	    'puntos' => $row['puntos'],
		);

	}
	mysql_free_result($request);

$request = db_query("		SELECT
			b.ID_BOARD, b.name, t.puntos, t.numViews, c.ID_CAT, m.ID_TOPIC, m.ID_MSG,
			t.ID_MEMBER_STARTED, t.ID_FIRST_MSG, t.ID_LAST_MSG, m.body, m.smileysEnabled,
			m.subject, m.posterTime
		FROM (" . (empty($have_temp_table) ? '' : "{$db_prefix}topics_posted_in AS pi, ") . "{$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
			LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
		WHERE " . (empty($have_temp_table) ? '' : "t.ID_TOPIC = pi.ID_TOPIC
			AND ") . "m.ID_MEMBER = $memID
			AND m.ID_TOPIC = t.ID_TOPIC
			AND t.ID_BOARD = b.ID_BOARD
			AND $user_info[query_see_board]
			AND t.ID_FIRST_MSG = m.ID_MSG
		ORDER BY m.ID_MSG DESC
		LIMIT $_REQUEST[start], $maxIndex", __FILE__, __LINE__);
	$counter = $_REQUEST['start'];
	$context['posts'] = array();
	$board_ids = array('own' => array(), 'any' => array());
	while ($row = mysql_fetch_assoc($request))
	{
    censorText($row['subject']);
	
	$context['posts'][++$counter] = array(
			'counter' => $counter,
			'board' => array(
				'name' => $row['name'],
			    'id' => $row['ID_BOARD']),
			'topic' => $row['ID_TOPIC'],
			'subject' => $row['subject'],
			'time' => timeformat($row['posterTime']),
			'id' => $row['ID_MSG'],
  	  	    'puntos' => $row['puntos'],
                    'numViews' => $row['numViews'],
		);

	}
	mysql_free_result($request);

', $post['puntos'],'

', $post['numViews'],'

GRACIAS VIRUS


Funcionó perfecto.

Acabo de escribirte un mensaje privado, espero tu respuesta.

Saludos! y MUCHAS MUCHAS GRACIAS