Re: Need some help please!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



PHP is serverside, meaning that the only way you can do anything having to do with PHP is to have the client go to a page. Otherwise, the PHP isn't called and so doesn't have a chance to run.

If you *really* want to do things interestingly you can maybe have your javascript go to a URL without refreshing the page (maybe the same way that images are pre-cached?). Or have a 1x1 image that it changes to another URL....

Jerry wrote:

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


--
--
paperCrane <Justin Patrin>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux