Witam mam taki skrypt zdrapki:
<?php
// Zapytanie o partie
(
"SELECT `partie` FROM `users1` WHERE `id` = '%s'",
$_SESSION['userid']
);
// Komunikat przy braku partii
if ($result['partie'] == 0) {
echo("Nie masz partii!"); }else{
// Losowanie zdrapki
(
array('points' => 10, 'filename' => 'moon.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 30, 'filename' => 'moon_30.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 30, 'filename' => 'moon_30.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 30, 'filename' => 'moon_30.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 30, 'filename' => 'moon_30.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 30, 'filename' => 'moon_30.swf'), array('points' => 10, 'filename' => 'moon.swf'), array('points' => 50, 'filename' => 'moon_50.swf') );
$count = count($zdrapki)-1; // Aktualizacja punktów
(
"UPDATE `users1` SET `points` = `points`+%d WHERE `id` = '%s'",
$zdrapki[$los]['points'],
$_SESSION['userid']
);
// Aktualizacja partii
(
"UPDATE `users1` SET `partie` = `partie`-1 WHERE `id` = '%s'",
$_SESSION['userid']
);
// Wyświetlenie zdrapki
printf('<embed src="%s" width="250" height="100"></embed>', $zdrapki[$los]['filename']); }
?>
I mam też:
<?php
$query=mysql_query("SELECT * FROM codes ORDER BY rand() LIMIT 1") or
die("BŁĄD BAZY DANYCH"); {
mysql_query("INSERT INTO zamowienia VALUES ('NULL','$_SESSION[username]','$row[name]','Event','$row[code]','".date("Y-m-d", time())."','".date("H:i:s", time())."')"); mysql_query("DELETE FROM codes WHERE id='".$row['id']."'") or
die("BŁĄD BAZY DANYCH"); echo '<object type="application/x-shockwave-flash" data="KATALOG ZE ZDRAPKA/'.$rowgame['link'].'" width="400" height="250"><param name="movie" value="KATALOG ZE ZDRAPKĄ/'.$rowgame['link'].'" /></object>'; }
?>
Jak to połączyć aby raz byly do wygrania pkty a raz kody?