Re: SQL Problem mit Danke/Thanks MOD
Verfasst: 07.03.2009 22:05
Hallo, habe nun hier die Zeilen 1500-1530 aus der "viewtopic.php" beigefügt!
Bitte um Hilfe.
//Begin Thank Post MOD
$sql = 'SELECT thanks_from
FROM ' . THANKS_TABLE . '
WHERE post_id = ' . $row['post_id'] .'
AND thanks_from = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
$give_thanks = $db->sql_fetchfield('thanks_from');
$db->sql_freeresult($result);
$sql_array = array(
'SELECT' => 'u.username, u.user_colour, t.*', '
FROM' => array(
USERS_TABLE => 'u',
THANKS_TABLE => 't'
),
'WHERE' => 't.post_id =' . $row['post_id'] . '
AND u.user_id = t.thanks_from',
'ORDER_BY' => 'u.username_clean'
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query($sql);
$thanks_list = '';
while ($row2 = $db->sql_fetchrow($result))
{
$thanks_user = get_username_string('full', $row2['thanks_from'], $row2['username'], $row2['user_colour'], $row2['username']);
$thanks_list = $thanks_list . ", " . $thanks_user;
}
Bitte um Hilfe.
//Begin Thank Post MOD
$sql = 'SELECT thanks_from
FROM ' . THANKS_TABLE . '
WHERE post_id = ' . $row['post_id'] .'
AND thanks_from = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
$give_thanks = $db->sql_fetchfield('thanks_from');
$db->sql_freeresult($result);
$sql_array = array(
'SELECT' => 'u.username, u.user_colour, t.*', '
FROM' => array(
USERS_TABLE => 'u',
THANKS_TABLE => 't'
),
'WHERE' => 't.post_id =' . $row['post_id'] . '
AND u.user_id = t.thanks_from',
'ORDER_BY' => 'u.username_clean'
);
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query($sql);
$thanks_list = '';
while ($row2 = $db->sql_fetchrow($result))
{
$thanks_user = get_username_string('full', $row2['thanks_from'], $row2['username'], $row2['user_colour'], $row2['username']);
$thanks_list = $thanks_list . ", " . $thanks_user;
}