1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
|
$sql = 'SELECT q.id,q.userid,q.frage,q.frage2,q.antwort1,q.antwort2,q.antwort3,q.antwort4,q.r_antwort,q.t_richtig,q.t_falsch,q.t_gesamt,q.sig,q.zeit, qs.status, u.username FROM phpbb_raetsel q
LEFT JOIN phpbb_raetsel_spiele qs ON (qs.spielid=q.id AND qs.userid= ' . $userid . ')
LEFT JOIN phpbb_users u ON (u.user_id=q.userid) WHERE q.status = 1 ORDER BY id DESC ';
$result = $db->sql_query($sql);
while ($row1 = $db->sql_fetchrow($result))
{
$id = $row1['id'];
$frage = $row1['frage'];
$richtig = $row1[t_richtig];
$falsch = $row1[t_falsch];
$gesamt = $row1[t_gesamt];
$play_status = $row1['status'];
$status = '<a href="raetsel_play.php?id=' . (int) $row1['id'] .'"><img src="./images/raetsel_ja.gif" /></a>';
$sql = 'INSERT INTO phpbb_raetsel_spiele (spielid, antwort, status) VALUES (' . (int) $row1['id'] .', 0, 2)';
$db->sql_query($sql);
}
|