SMF 2.0 (RC5) własne zapytanie do mysql (SSI.php) Opcje

[Giluś]

Cześć, wie ktoś może jak zrobić własne zapytanie do mysql w skrypcie forum: SMF 2.0 RC5, próbuje zrobić dodatkową podstronę w tym celu używam SSI.php, tak wygląda kod podstrony:

[PHP] pobierz, plaintext 
<?php
require('/homepages/1/SSI.php');
lol();
?>
[PHP] pobierz, plaintext 

A tak wygląda moja funkcja:

[PHP] pobierz, plaintext 
function lol($output_method = 'lol')
{
	global $context, $txt, $scripturl;
 
	if ($output_method == 'lol')
	{
		if ($context['user']['is_guest'])
			echo "Czesc gościu";
		else
$wynik = mysql_query("SELECT * FROM smf_members WHERE member_name='Gilus'")  or die('Błąd zapytania'); 
 
 
if(mysql_num_rows($wynik) > 0) { 
    while($r = mysql_fetch_assoc($wynik)) { 
        echo "".$r['posts'].""; 
    }
} 		
 
 
	}
	else
		return $context['user'];
}
[PHP] pobierz, plaintext 

Jest ona przeróbką:

[PHP] pobierz, plaintext 
function ssi_welcome($output_method = 'echo')
{
	global $context, $txt, $scripturl;
 
	if ($output_method == 'echo')
	{
		if ($context['user']['is_guest'])
			echo sprintf($txt['welcome_guest'], $txt['guest_title']);
		else
			echo $context['user']['name'];
	}
	// Don't echo... then do what?!
	else
		return $context['user'];
}
[PHP] pobierz, plaintext 

I chciałbym wykonać zapytanie do mysql:

[PHP] pobierz, plaintext 
$wynik = mysql_query("SELECT * FROM smf_members WHERE member_name='Gilus'")  or die('Błąd zapytania'); 
[PHP] pobierz, plaintext 

Ale piszę: "Błąd zapytania", nie wiem co jest źle, nawet jak dam bez WHERE to tak samo jest błąd zapytania, ma ktoś może jakieś pomysły ?

[Ruio]

Sprawdź jak są wykonywane inne zapytania w skrypcie i wzoruj się na nich

[Giluś]

Tak mniej więcej wygląda topic:

[PHP] pobierz, plaintext 
// Shows the top topics.
function ssi_topTopics($type = 'replies', $num_topics = 10, $output_method = 'echo')
{
	global $db_prefix, $txt, $scripturl, $user_info, $modSettings, $smcFunc, $context;
 
	if ($modSettings['totalMessages'] > 100000)
	{
		// !!! Why don't we use {query(_wanna)_see_board}?
		$request = $smcFunc['db_query']('', '
			SELECT id_topic
			FROM {db_prefix}topics
			WHERE num_' . ($type != 'replies' ? 'views' : 'replies') . ' != 0' . ($modSettings['postmod_active'] ? '
				AND approved = {int:is_approved}' : '') . '
			ORDER BY num_' . ($type != 'replies' ? 'views' : 'replies') . ' DESC
			LIMIT {int:limit}',
			array(
				'is_approved' => 1,
				'limit' => $num_topics > 100 ? ($num_topics + ($num_topics / 2)) : 100,
			)
		);
		$topic_ids = array();
		while ($row = $smcFunc['db_fetch_assoc']($request))
			$topic_ids[] = $row['id_topic'];
		$smcFunc['db_free_result']($request);
	}
	else
		$topic_ids = array();
 
	$request = $smcFunc['db_query']('', '
		SELECT m.subject, m.id_topic, t.num_views, t.num_replies
		FROM {db_prefix}topics AS t
			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
		WHERE {query_wanna_see_board}' . ($modSettings['postmod_active'] ? '
			AND t.approved = {int:is_approved}' : '') . (!empty($topic_ids) ? '
			AND t.id_topic IN ({array_int:topic_list})' : '') . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
			AND b.id_board != {int:recycle_enable}' : '') . '
		ORDER BY t.num_' . ($type != 'replies' ? 'views' : 'replies') . ' DESC
		LIMIT {int:limit}',
		array(
			'topic_list' => $topic_ids,
			'is_approved' => 1,
			'recycle_enable' => $modSettings['recycle_board'],
			'limit' => $num_topics,
		)
	);
	$topics = array();
	while ($row = $smcFunc['db_fetch_assoc']($request))
	{
		censorText($row['subject']);
 
		$topics[] = array(
			'id' => $row['id_topic'],
			'subject' => $row['subject'],
			'num_replies' => $row['num_replies'],
			'num_views' => $row['num_views'],
			'href' => $scripturl . '?topic=' . $row['id_topic'] . '.0',
			'link' => '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.0">' . $row['subject'] . '</a>',
		);
	}
	$smcFunc['db_free_result']($request);
 
	if ($output_method != 'echo' || empty($topics))
		return $topics;
 
	echo '
		<table class="ssi_table">
			<tr>
				<th align="left"></th>
				<th align="left">', $txt['views'], '</th>
				<th align="left">', $txt['replies'], '</th>
			</tr>';
	foreach ($topics as $topic)
		echo '
			<tr>
				<td align="left">
					', $topic['link'], '
				</td>
				<td align="right">', comma_format($topic['num_views']), '</td>
				<td align="right">', comma_format($topic['num_replies']), '</td>
			</tr>';
	echo '
		</table>';
}
[PHP] pobierz, plaintext 

[erix]

Przejrzyj sobie zmienne globalne, jakie masz do dyspozycji w SSI.