PHP - Leaderboard With Equal Places

Hey guys,

I've kind of taken over a project from a friend.  It's a leaderboard for posting splits for drivers.  The splits get posted to a leaderboard.xsl (which is working fine).  The update.php page is designed to update a leaderboard.xml file, this way anyone can login and update new splits for each weeks race.  (more info can be found here if you are curious).

I found a small bug in the leaderboard.xsl file.  It is meant for displaying the drivers splits, calculating the difference between drivers, what division they are, car they used and includes a 'Controller' column.  This is where the bug is. 

Normally, it will display if that driver uses a gamepad or a steering wheel.  If it's a one lap aka 'hotlap' race, the Controller column shows either a 'wheel' or 'controller' as it should.

However, if it's a multi-lap race (2+ laps), then the Controller column automatically defaults to the <xsl:otherwise> option of a "?".

Here is an example of the Controller column working properly for each driver:



Here is what it does when there are two (or more) sets of splits for each driver on the leaderboard:



The code makes the post over the character length, you can view the code here.

Any assistance/help would be great appreciated as I'll be done with the project then


Jerome

Does anyone know where I can find a php leaderboard or high scores script

For every search, I get ZERO RESULTS, and I don't understand what I'm doing wrong.

Code: [Select]
<?php
require('places_class.php');

$types = $_POST['type'];
$location = $_POST['place'];
$radius = $_POST['radius'];

$gplaces = New GooglePlaces;
$gplaces->SetLocation("$location");
$gplaces->SetRadius($radius);
$gplaces->SetTypes("$types");
$results = $gplaces->Search();

print_r($results);
?>

That's when the form is submitted, I checked the variables, and they are echoing out correctly.

Then I thought I'd hard-code the values in, same results
Code: [Select]
<?php
require('places_class.php');

$gplaces = New GooglePlaces;
$gplaces->SetLocation("40.5267,81.4778");
$gplaces->SetRadius(50);
$gplaces->SetTypes("food");
$results = $gplaces->Search();

print_r($results);
?>

Here is the class
Code: [Select]
<?php
class GooglePlaces
{
private $APIKey = "";
 
public $OutputType = "json";  //either json, xml or array
 
public $Errors = array();
 
private $APIUrl = "https://maps.googleapis.com/maps/api/place";
private $APICallType = "";
 
private $IncludeDetails = false; 
 
//all calls
private $Language = 'en';  //optional - https://spreadsheets.google.com/pub?key=p9pdwsai2hDMsLkXsoM05KQ&gid=1
 
//Search
private $Location;   //REQUIRED  - This must be provided as a google.maps.LatLng object.
private $Radius;   //REQUIRED  
private $Types;   //optional - separate tyep with pipe symbol  http://code.google.com/apis/maps/documentation/places/supported_types.html  
 
private $Name;   //optional
 
//Search, Details, 
private $Sensor = 'false'; //REQUIRED - is $Location coming from a sensor? like GPS?
 
//Details & Delete
private $Reference;
 
//Add
private $Accuracy;
 
public function Search()
    {
$this->APICallType = "search";
 
return $this->APICall();
}
 
public function Details()
    {
$this->APICallType = "details";
 
return $this->APICall();
}
 
public function Checkin()
    {
$this->APICallType = "checkin-in";
 
return $this->APICall();
}
 
public function Add()
    {
$this->APICallType = "add";
 
return $this->APICall();
}
 
public function Delete()
    {
$this->APICallType = "delete";
 
return $this->APICall();
}
 
 
public function SetLocation($Location)
{
$this->Location = $Location;
}
public function SetRadius($Radius)
{
$this->Radius = $Radius;
}
public function SetTypes($Types)
{
$this->Types = $Types;
}
public function SetLanguage($Language)
{
$this->Language = $Language;
}
public function SetName($Name)
{
$this->Name = $Name;
}
public function SetSensor($Sensor)
{
$this->Sensor = $Sensor;
}
public function SetReference($Reference)
{
$this->Reference = $Reference;
}
public function SetAccuracy($Accuracy)
{
$this->Accuracy = $Accuracy;
}
public function SetIncludeDetails($IncludeDetails)
{
$this->IncludeDetails = $IncludeDetails;
}
 
private function CheckForErrors()
{
if(empty($this->APICallType))
{
$this->Errors[] = "API Call Type is required but is missing.";
}
if(empty($this->APIKey))
{
$this->Errors[] = "API Key is is required but is missing.";
}
 
if(($this->OutputType!="json") && ($this->OutputType!="xml") && ($this->OutputType!="json"))
{
$this->Errors[] = "OutputType is required but is missing.";
}
 
 
 
}
 
 
 
private function APICall()
{
$this->CheckForErrors();
 
if($this->APICallType=="add" || $this->APICallType=="delete")
{
$URLToPostTo = $this->APIUrl."/".$this->APICallType."/".$this->OutputType."?key=".$this->APIKey."&sensor=".$this->Sensor;
 
if($this->APICallType=="add")
{
$LocationArray = explode(",", $this->Location);
$lat = trim($LocationArray[0]);
$lng = trim($LocationArray[1]);
 
$paramstopost[location][lat] = $lat;
$paramstopost[location][lng] = $lng;
$paramstopost[accuracy] = $this->Accuracy;
$paramstopost[name] = $this->Name;
$paramstopost[types] = explode("|", $this->Types);
$paramstopost[language] = $this->Language;
}
if($this->APICallType=="delete")
{
$paramstopost[reference] = $this->Reference;
}
 
$result = json_decode($this->CurlCall($URLToPostTo,json_encode($paramstopost)));
$result->errors = $this->Errors;
return $result;
 
}
 
if($this->APICallType=="search")
{
$URLparams = "location=".$this->Location."&radius=".$this->Radius."&types=".$this->Types."&language=".$this->Language."&name=".$this->Name."&sensor=".$this->Sensor;
}
if($this->APICallType=="details")
{
$URLparams = "reference=".$this->Reference."&language=".$this->Language."&sensor=".$this->Sensor;
}
if($this->APICallType=="check-in")
{
$URLparams = "reference=".$this->Reference."&language=".$this->Language."&sensor=".$this->Sensor;
}
 
 
$URLToCall = $this->APIUrl."/".$this->APICallType."/".$this->OutputType."?key=".$this->APIKey."&".$URLparams;
 
$result = json_decode(file_get_contents($URLToCall),true);
 
$result[errors] = $this->Errors;
 
if($result[status]=="OK" && $this->APICallType=="details")
{
foreach($result[result][address_components] as $key=>$component)
{
if($component[types][0]=="street_number")
{
$address_street_number = $component[short_name];
}
if($component[types][0]=="route")
{
$address_street_name = $component[short_name];
}
if($component[types][0]=="locality")
{
$address_city = $component[short_name];
}
if($component[types][0]=="administrative_area_level_1")
{
$address_state = $component[short_name];
}
if($component[types][0]=="postal_code")
{
$address_postal_code = $component[short_name];
}
}
 
$result[result][address_fixed][street_number] = $address_street_number;
$result[result][address_fixed][address_street_name] = $address_street_name;
$result[result][address_fixed][address_city] = $address_city;
$result[result][address_fixed][address_state] = $address_state;
$result[result][address_fixed][address_postal_code] = $address_postal_code;
}
return $result;
 
}
 
private function CurlCall($url,$topost)
{
$ch = curl_init(); 
curl_setopt($ch, CURLOPT_URL, $url); 
curl_setopt($ch, CURLOPT_HEADER, FALSE);  
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); 
curl_setopt($ch, CURLOPT_POSTFIELDS, $topost);
$body = curl_exec($ch); 
curl_close($ch); 
 
return $body;
 
}
 
}
?>

And yes, I do have the correct API Key, I just took it out

Can anybody see what the issue is?

Hi, I'm trying to force 2 decimal places with the following function but it 's not working.  Any suggestions? 

Code: [Select]
function ShippingCost() {
$shippingCost = 4.00;
    number_format($shippingCost,2);
return $shippingCost;
}

Hi..

I encountered problem in rounding of numbers into two decimal places.

here is my sample code:


if($W4_STATUS == 1 AND $DEPENDENTS == 0 AND $TotEarn >= 7917 AND $TotEarn <= 12500) {
   $TAX = ($TotEarn - 7917);
   $TAX = (937.50 + ($TAX * .25));
   $TAX = number_format($TAX, 2, '.', '');
}


for example from this:

 $TAX = ($TotEarn - 7917);
  $TAX = (937.50 + ($TAX * .25));

the output is: 1417.615

using this:

$TAX = number_format($TAX, 2, '.', '');

the output was : 1417.61

but it should be : 1417.62

Thank you