Page 1 of 1
Battlefield 3 SQL
Posted: Thu Aug 01, 2013 4:44 pm
by Radwan_The_Black_Eagle
Hello.
Is there SQL file for battlefield 3? (BF3.sql) ? like Battlefield Bad Company 2 (BFBC2.sql).
Thanks.
Re: Bettlefold 3 SQL
Posted: Thu Aug 01, 2013 6:02 pm
by Lapin
Why would you use a Database ?
Re: Bettlefold 3 SQL
Posted: Thu Aug 01, 2013 6:33 pm
by Kerrigan
Since there is no (public) emulator for BF3 yet, there is no use for a database...
Also i would prefer a NoSQL format.
Re: Bettlefold 3 SQL
Posted: Fri Aug 02, 2013 3:00 am
by aXeSwY
This is a PHP Example to obtain userinfo for BF3 :
Code: Select all
<?php
$data=array('players'=>array(),'opt'=>array());
// List of players
$data['players'][]='zh1nt0';
$data['players'][]='DocDurchschnitt';
// List of options
$data['opt']['all']=true;
// Platform can be pc, 360, ps3
$platform='pc';
// Convert lists to JSON
$postdata=array();
$postdata['players']=json_encode($data['players']);
$postdata['opt']=json_encode($data['opt']);
// Run POST Request via CURL
$c=curl_init('http://api.bf3stats.com/'.$platform.'/playerlist/');
curl_setopt($c,CURLOPT_HEADER,false);
curl_setopt($c,CURLOPT_POST,true);
curl_setopt($c,CURLOPT_USERAGENT,'BF3StatsAPI/0.1');
curl_setopt($c,CURLOPT_HTTPHEADER,array('Expect:'));
curl_setopt($c,CURLOPT_RETURNTRANSFER,true);
curl_setopt($c,CURLOPT_POSTFIELDS,$postdata);
$data=curl_exec($c);
$statuscode=curl_getinfo($c,CURLINFO_HTTP_CODE);
curl_close($c);
if($statuscode==200) {
// Decode JSON Data
$data=json_decode($data,true);
// Print data for debugging
echo '<pre>';
print_r($data);
// print list of players with rank and score
foreach($data['list'] as $d) {
$stats=$d['stats'];
echo $d['name']." | ".$stats['rank']['name']." (".$stats['rank']['nr'].") Score: ".$stats['scores']['score']."\n";
}
echo '</pre>';
// ... now you use $data to do whatever
} else {
echo "BF3 Stats API error status: ".$statuscode;
}
?>