phpBB.nl

Hallo. Ik heb een tracker gemaakt. Maar die wou ik ook in phpbb zelf zetten. Dus ik heb het een beetje aangepast, en in page_tail.php gezet. Alleen doet ie het niet. Dit is de code:

Code: Selecteer alles

$sql = "SELECT topic_id, topic_title, topic_last_post_id, topic_time FROM " . TOPICS_TABLE . " WHERE topic_status = 0 AND forum_id != 19 ORDER BY topic_last_post_id DESC LIMIT 0, 10";
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$i = 0;
while($i < 10 && $topics = mysql_fetch_row($result))
{
	$topicname = $topics[$i]['topic_title'];
	$template->assign_vars(array(
	'TEST_VAR' => $topicname));
	$i++;
}

Ik weet niet hoe ik dit wel werken kan krijgen.. iemand?

Probeer eens zo:

Code: Selecteer alles

$sql = "SELECT topic_id, topic_title, topic_last_post_id, topic_time FROM " . TOPICS_TABLE . " WHERE topic_status = 0 AND forum_id != 19 ORDER BY topic_last_post_id DESC LIMIT 0, 10";
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}

$topics = array();
while( $topics[] = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);

for($i = 0; $i < 10; $i++;)
{
   $topicname = $topics[$i]['topic_title'];
   $template->assign_vars(array(
   'TEST_VAR' => $topicname));
}

Nee.. dit werkt ook niet. Ik heb het inmiddels ook al met assign_block_vars geprobeerd, en dat werkt ook niet. Iemand nog een idee? Ik zie overigens niks.. geen foutmelding.. helemaal niks

Doe eens dit om te bekijken of er wel wat in de array zit:

Code: Selecteer alles

$sql = "SELECT topic_id, topic_title, topic_last_post_id, topic_time FROM " . TOPICS_TABLE . " WHERE topic_status = 0 AND forum_id != 19 ORDER BY topic_last_post_id DESC LIMIT 0, 10";
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}

$topics = array();
while( $topics[] = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);
print_r($topics);

Dit krijg ik eruit

Code: Selecteer alles

Array ( [0] => Array ( [topic_id] => 97 [topic_title] => Belangrijk [topic_last_post_id] => 1035 [topic_time] => 1105194454 ) [1] => Array ( [topic_id] => 95 [topic_title] => cmr04 [topic_last_post_id] => 1007 [topic_time] => 1105100369 ) [2] => Array ( [topic_id] => 93 [topic_title] => Eminem - The Kids (unreleased) [topic_last_post_id] => 953 [topic_time] => 1105024919 ) [3] => Array ( [topic_id] => 92 [topic_title] => kleine bug [topic_last_post_id] => 949 [topic_time] => 1105015910 ) [4] => Array ( [topic_id] => 91 [topic_title] => Maluch [topic_last_post_id] => 915 [topic_time] => 1104884056 ) [5] => Array ( [topic_id] => 9 [topic_title] => Guidelines [topic_last_post_id] => 873 [topic_time] => 1101141713 ) [6] => Array ( [topic_id] => 83 [topic_title] => half life2 [topic_last_post_id] => 814 [topic_time] => 1104258973 ) [7] => Array ( [topic_id] => 70 [topic_title] => kerstlan [topic_last_post_id] => 813 [topic_time] => 1103973242 ) [8] => Array ( [topic_id] => 82 [topic_title] => BugForum » BELANGRIJK [topic_last_post_id] => 804 [topic_time] => 1104137367 ) [9] => Array ( [topic_id] => 62 [topic_title] => favo car [topic_last_post_id] => 774 [topic_time] => 1103645574 ) [10] => )

Er zit dus wel iets in, de sql is niet fout.

Code: Selecteer alles

$sql = "SELECT topic_id, topic_title, topic_last_post_id, topic_time FROM " . TOPICS_TABLE . " WHERE topic_status = 0 AND forum_id != 19 ORDER BY topic_last_post_id DESC LIMIT 0, 10";
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}

$topics = array();
while( $topics[] = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);

for($i = 0; $i < 10; $i++;)
{
   $topicname = $topics[$i]['topic_title'];
   $template->assign_block_vars('test',	array(
   'TEST_VAR' => $topicname));
}

In de tpl moet je dan

{test.TEST_VAR}

gebruiken.

oke.. dit werkt.. máár.. nu staat de tracker bovenaan.. terwijl ik dat stukje wel in de goeie tabel heb gezet..

edit: Bedankt

hij doet het.. 8)

dubbelpost

Ik wil nu de juiste tijden krijgen, dus probeer ik dit:

$sql = "SELECT post_time FROM ".POSTS_TABLE." WHERE post_id = '$topiclastpost'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$result = mysql_fetch_assoc($result);

Maar ik wil het wel op de phpbb manier doen. Hoe doe ik dat?

Je hebt topic_time al uit de database gehaald, nu alleen nog omzetten naar "leesbaar" formaat (niet het UNIX formaat)

Code: Selecteer alles

$topic_time = create_date($board_config['default_dateformat'], $topics[$i]['topic_time'], $board_config['board_timezone']);

Zoiets denk ik.

Ja.. dat snap ik wel. Dat heb ik ook al gedaan. Maar ik bedoel. PHPBB heeft toch z'n eigen database functies enzo. Dus ik snap niet hoe ik het script dan op die manier moet doen..

Ik snap niet precies wat je wilt

Ik gebruikte mysql_fetch_assoc, maar phpbb gebruik $db->fetch_assoc(); of iets dergelijks.. maar ik snap niet hoe ik die datums van de berichten er dan uit kan krijgen op die manier

Je kan die functie gewoon hetzelfde gebruiken, of de normale PHP functie gebruiken.

phpBB.nl

Tracker

Tracker