PHP - Force To 2 Decimal Points

hi,

i am trying to filter my gps history points.

i would like to ignore points if they are too close to the previous position.

i can do this like so.

$old_lat = $old_long = "0";

                 foreach($history['data'] as $record) {

//calculate distance in meters
$distance = distance($record['latitude'], $record['longitude'], $old_lat, $old_long, "V");

if($distance >= 300) {
echo 'add(jQuery(this), number += 1, "' . date("d-m-Y @ h:i:s",$record['timestamp']) . '", "map_post.php?n=' . $name . 'u=' . $history['user'] . '", "' . $history['user'] . '", "' . $record['latitude'] . '", "' . $record['longitude'] . '");';
                
$old_lat = $record['latitude'];
$old_long = $record['longitude'];
}

the problem with the above is that if i arrive home at 6pm on friday and stay outside my house for 24hours, it will show the latest position as at 6pm on fri.

i would like it to show the 6pm friday position but with a date 'from and to' time like (28/10/11 18:00 - 29/10/11 18:00) rarther than just (28/10/11 18:00) which looks inacurate.

Possible?

Ok i have 3 columms right now i have  date  player and points and what i want is for this script to add up each players points and send it to page  as totals decending i have got the page to show them individually but when i do group it only gets one record so i tried to add in the  sum points and it gives me a  ) Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in so i am kind of lost as to where adding the sum(points) would cause this below is the code where the problem is any help would be much appreciated

$r = mysql_query("select  * from player_points Sum(points) as total where date_entered > '$d' Group by player order by  total DESC");

I have a picture (attached), where I find the coordinates of black points, because I do not remember any point, so you want every point at which I find coordinates with mark a red cross as watermark.

At the coordinates using this script:
<?php

if(isset($_GET["obrazek_x"]))

  file_put_contents("soubor.txt",$_GET["obrazek_x"].",".$_GET["obrazek_y"]."\n",FILE_APPEND);

?> 

Coordinates I save to an external file in this format:

Code: [Select]
602;744
Could you advise me a solution to mark black points?

Okay, I'm trying to make it so that when someone levels up in my game, they can use stat bonus points to increase their abilities.

However, there doesn't seem to be a break in there to ensure that someone can't spend points that they don't have. For instance, they get 3 per level, but if they spend 6, the system lets them and shows a -3 in their stat_bonus field.

Any help would be appreciated! Thanks in advance!!


<?php

include("fightfunc.php");
include("lib.php");
//include('cookies.php');
//$link = opendb();
define("PAGENAME", "Stat Bonus");
$player = check_user($secret_key, $db);
$x = $player->username;
if($_SESSION['234asdfas']){$y = $_SESSION['234asdfas'];}else{echo 'Error: You do not have a session variable set'; exit;}

$command = 1;

$choice = $_POST['choice'];
$amount = $_POST['amount'];

if (isset($_POST["statbonus"])) {
       
   include("tmpconfig.php");
$checkquery = $db->execute("SELECT * FROM `users` WHERE `id`=?", $player->id);
//$rec = mysql_fetch_array($checkquery);
extract($_POST);
$errors = 0;
$errorlist = "";
        
if ($errors == 0) { 

$query = $db->execute("UPDATE `users` SET `stat_bonus`=? WHERE `id`=?", array($player->stat_bonus - $amount, $player->id)) or die("querya failed: ". mysql_error());
if($query)
$qry = $db->execute("select * from `users` where `id`=?", array($player->id)) or die("qry failed: ".mysql_error());
$rw = $qry->fetchrow();

if($qry){
$query2 = $db->execute("UPDATE `users` SET `stat_bonus`=?, $choice=$choice+$amount WHERE `id`=?", array($player->stat_bonus - $amount, $player->id)) or die("query2 failed: ". mysql_error());
if($query2){
echo("<br><br>You have successfully used your stat bonus points.<br>");
} elseif  
($amount > $player["stat_bonus"])
{ echo "<font color='red'>Enter an amount higher than 0!</font>"; }
  elseif
  ($amount == 0)
   { echo "<font color='red'>Enter an amount higher than 0!</font>";  }
  elseif
  (!is_numeric($amount)) { 
echo "<font color='red'>Enter an amount!</font.";
        } 
else {
echo "<font color=green><b>You have succesfully spend skill points!</b></font><br /><br />";
}}}}
$player = check_user($secret_key, $db);
?>
<table width="100%">
<tr>
  <td colspan="2"><fieldset>
<form action="" method="post">
<font size='4'><b>Skill points</b></font><br />
Every time you raise a level, you get 3 skillpoints. You can spend them here.
<br />
You currently have <font color=green><b><?=$player->stat_bonus?> Skill Points.</b></font>. Please choose an attribute:<br />
<br />
<INPUT TYPE="radio" NAME="choice" VALUE="strength" CHECKED>Strength<br />
<INPUT TYPE="radio" NAME="choice" VALUE="vitality" >Vitality<br />
<INPUT TYPE="radio" NAME="choice" VALUE="agility">Agility<br />
<INPUT TYPE="radio" NAME="choice" VALUE="wisdom">Wisdom<br />
<br />
How many skill points do you want to spend? (+1 for every skill point): <br /><br />
Amount: <INPUT TYPE="text" NAME="amount" SIZE="8" MAXLENGTH="8">
<INPUT TYPE="submit" NAME="statbonus" VALUE="Submit">
</form></fieldset></td></tr>
    </table>

Hey, I have a minigame on my website and when you bet 1 It says you lost and you lose your point but it doesn't remove it, Same with if you win it says you gain the point but doesn't add it....


Code: [Select]
function bet ($bet){ 
sleep(2);

$user1 = mysql_query("SELECT * FROM `users` WHERE `id`='" . $_SESSION['id'] . "'");
$user = mysql_fetch_object($user1);

$chance = rand (1, 2);
$bet = round ($bet);
$betPretty = number_format ($bet);

if ($bet == 0) { $echo = "You did not bet anything!"; $chance = 0; }
if ($bet < 0) { $echo = "You cannot bet a negative number."; $chance = 0; }
if ($bet > $user->minigame_points) { $echo = "This is more minigame points than you have!"; $chance = 0; }
if ($user->minigame_points == 0) { $echo = "You do not have any minigame points."; $chance = 0; }

if ($chance == 1) {
//Win
$money = $user->minigame_points+$bet;
$times_bet = $user->times_bet+1;
mysql_query ("UPDATE `users` SET `minigame_points`='" . $money . "', `times_bet`='" . $new_bet . "' WHERE `username`='" . $user->username . "'");
$money = number_format($money);
$echo = "You won $betPretty minigame points!<br /><b>Current Minigame Points:</b> $money";
}
if ($chance == 2) {
//Lose
$money = $user->minigame_points-$bet;
$times_bet = $user->times_bet+1;
mysql_query ("UPDATE `users` SET `minigame_points`='" . $money . "', `times_bet`='" . $new_bet . "' WHERE `username`='" . $user->username . "'");
$money = number_format($money);
$echo = "You lost $bet minigame points.<br /><b>Current Minigame Points:</b> $money";
}
    return $echo;