Hi,
I have this code, comments below:
<? include("../pages/setup.php");?>
<? login();?>
<? include("../pages/header.php");?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01
Transitional//EN">
<html>
<head>
<STYLE>
.general3 {background-color:#333333;z-index:4}
.general2 {background-color:#555555;z-index:3}
.general1 {background-color:#777777;z-index:2}
.general0 {background-color:#999999;z-index:1}
</STYLE>
<title></title>
</head>
<body>
<?
include("./config.phtml");
include("./$languagefile");
mysql_connect($hostname,$mysqluser,$mysqlpassword);
$query = "select * from kras_params;";
$result = mysql_db_query($database,$query);
$row = mysql_fetch_array($result);
//fill vars
$total = $row[kr_total];
$chance = $row[kr_chance];
$maxwins = $row[kr_max_wins];
$wins = $row[kr_wins];
$timesaday = $row[kr_timesaday];
$host = $REMOTE_ADDR;
$check = 1;
$q_checktimes = "select count(*) from kras_users where
usr_ip='$host' and usr_date=CURDATE();";
$checktimes_result =
mysql_db_query($database,$q_checktimes);
$times = mysql_fetch_row($checktimes_result);
$error = "";
if ($times[0] < $timesaday) {
//poging toevoegen in database
$raisetimes = "insert into kras_users
values('$host',CURDATE(),'$HTTP_SESSION_VARS[username]');";
$raiseresult = mysql_db_query($database,$raisetimes)
or die('error: raise times failed');
} else {
$error .= "<LI>$txt_maxplay $timesaday.";
$check = 0;
}
if ($wins == $maxwins) {
$error = "<LI>$txt_maxwon";
$check = 0;
}
if ($check) {
//aantal malen dat spel gespeeld is ophogen met 1
$raisetotal = "update kras_params set
kr_total=(kr_total+1);";
$raiseresult = mysql_db_query($database,$raisetotal);
if ($total%$chance == 0) {
$raisewins = "update kras_params set
kr_wins=(kr_wins+1);";
$raisewinsresult =
mysql_db_query($database,$raisewins) or die('error:
raise wins failed');
$winner = 1;
}
?>
<SCRIPT>
sc=new
Array('gfx/crown.jpg','gfx/x.jpg','gfx/seven.jpg','gfx/diamond.jpg','gfx/ruby.jpg','gfx/magic.jpg');
z=new Array();
function check() {
var oDivs = document.all.tags("DIV");
for (i=0; i<oDivs.length; i++){
var scratched = "true";
if (oDivs(i).style.display != "none" &&
oDivs(i).scratchable == "true") {
scratched = "false";
return false;
}
}
if (scratched == "true") {
<?
echo ($winner ? "alert(\"$txt_youwon!
$HTTP_SESSION_VARS[username]\")" :
"alert(\"$txt_youlost\")");
?>
}
}
function rnd() {
return Math.floor(Math.random()*sc.length);
}
<?
if ($winner) {
echo "function scimgload() {";
echo "document.scratch1.src=sc[rnd()];";
echo "document.scratch2.src=document.scratch1.src;";
echo "document.scratch3.src=document.scratch1.src;";
echo "}";
} else {
echo "function scimgload() {";
echo "document.scratch1.src=sc[rnd()];";
echo "document.scratch2.src=sc[rnd()];";
echo "document.scratch3.src=sc[rnd()];";
echo "while (document.scratch2.src ==
document.scratch3.src) {";
echo "document.scratch3.src=sc[rnd()];";
echo "}";
echo "}";
}
?>
function scmetal() {
for (i=0;i<192;i++)
document.all['M'+i].style.display="";
}
</SCRIPT>
<SCRIPT FOR=window EVENT=onload LANGUAGE="JScript">
scimgload();
</SCRIPT>
<h1><center><font color=blue>TMC Scratch n
Match</font></H1>
<DIV scratchable="false" STYLE="position:
relative;height: 300">
<SCRIPT>
// This script must be within the relatively
positioned DIV.
for (p=0;p<3;p++)
for (i=0;i<4;i++)
for (j=0;j<4;j++)
for (k=0;k<4;k++) {
idn=p*64+i*16+j*4+k;
document.write('<DIV scratchable="true" ID="M'+idn+'"
onmouseover="style.display=\'none\';check();"
CLASS="general'+i+'"
STYLE="position:absolute;width:25;height:25;top:'+eval(0+j*25)+';left:'+eval(125+p*125+k*25)+'"></DIV>');
}
</SCRIPT>
<IMG SRC="" NAME=scratch1 ID=img1
STYLE="position:absolute;top:0;left:125;width:100;height:100;z-index:0">
<IMG SRC="" NAME=scratch2 ID=img2
STYLE="position:absolute;top:0;left:250;width:100;height:100;z-index:0">
<IMG SRC="" NAME=scratch3 ID=img3
STYLE="position:absolute;top:0;left:375;width:100;height:100;z-index:0">
<BUTTON
STYLE="position:absolute;top:150;left:250;width:auto;height:50"
onclick="location.reload()"><? echo $txt_playagain;
?></BUTTON>
</DIV>
<?
} else {
echo $error;
}
?>
</center>
</BODY>
</HTML>
It's a scartchy game, 3 boxes, run your mouse over
them to scratch, if you win it pops up a java box
saying you won and your Username.
What I want to do is do a query to a db and update an
accounting table to credit users account if they win,
and if they lose do nothing.
But I am not sure what to add with this code... Does
the page need to refresh to do a insert query or can
it do it some other way?
When they win they get a popup, page does not refresh,
to play again it restarts. Is there a way to credit
the account without refreshing? If worst comes to
worst I guess I could redirect the user to another
page to credit accounts, but this would take them away
from game and is not ideal.
Ideas/code welcome here.
Jerry
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
