Coding style

include_once('facebook.php');
 
define('FB_API_KEY', 'abcdef0123456789abcd');
define('FB_SECRET_KEY', 'abcdef0123456789abcd');
define('MYSQL_HOST', 'monhost');
define('MYSQL_USER', 'monlogin');
define('MYSQL_PASS', 'monpass');
define('MYSQL_DB', 'mabase');
 
$facebook = new Facebook(FB_API_KEY, FB_SECRET_KEY);
$user = $facebook->require_login();
?>
 
En s'appuyant sur le design existant, on crée deux onglets correspondant aux deux fonctionnalités "Envoyer une boulette" et "Voir les scores" :
 
<fb:tabs>
    <fb:tab-item href="http://apps.facebook.com/boulettebattle/index.php?action=envoyer" title="Envoyer des boulettes" <?php echo (isset($_GET['action']) && $_GET['action'] == 'envoyer' ? 'selected="true"' : '') ?> />
    <fb:tab-item href="http://apps.facebook.com/boulettebattle/index.php?action=topscores" title="Top scores" <?php echo (isset($_GET['action']) && $_GET['action'] == 'topscores' ? 'selected="true"' : '') ?> />
</fb:tabs>

$friends = $facebook->api_client->friends_get();
$users = $facebook->api_client->users_getInfo($friends, array('uid', 'name'));

<ul class="friendlist">
<?php foreach ($users as $user):?>
<li><a href="http://apps.facebook.com/boulettebattle/index.php?action=envoyer&pid=<?php echo $user['uid']; ?>"><fb:profile-pic uid="<?php echo $user['uid'];?>" size="square" /><?php echo $user['name']; ?></a></li>
<?php endforeach;?>
</ul>

if (isset($_GET['action']) && isset($_GET['pid']) && $_GET['action'] == 'envoyer') {
$cnx = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
 
if (!$cnx) {
$error = 'Cannot connect to MySQL';
break;
}
 
$b = mysql_select_db(MYSQL_DB);
 
if (!$b) {
$error = 'Cannot open DB';
break;
}
 
if (!is_numeric($_GET['pid'])) {
$error = 'Error : bad ID';
break;
}
 
$sql = 'INSERT INTO `works_boulette` (uid_from, uid_to) VALUES (' . (integer)$user . ', ' . (integer)$_GET['pid'] . ')';
mysql_query($sql);
 
// Notification au destinataire
$zeuser = $facebook->api_client->users_getInfo($_GET['pid'], array('name'));
$facebook->api_client->notifications_send(array($_GET['pid']), ' vous a envoye une <a href="http://apps.facebook.com/boulettebattle/">boulette virtuelle</a>', '<fb:notif-subject>Vous avez recu une nouvelle boulette virtuelle</fb:notif-subject>', ' vous a envoye une <a href="http://apps.facebook.com/boulettebattle/">boulette virtuelle</a>');
}

if (isset($_GET['action']) && $_GET['action'] == 'topscores') {
	$cnx = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
 
	if (!$cnx) {
		$error = 'Cannot connect to MySQL';
		break;
	}
 
	$b = mysql_select_db(MYSQL_DB);
 
	if (!$b) {
		$error = 'Cannot open DB';
		break;
	}
 
	$sql = 'SELECT uid_from AS uid, COUNT(uid_from) AS nb FROM `works_boulette` GROUP BY uid_from ORDER BY nb ASC';
	$rs = mysql_query($sql);
	$topscores = array();
 
	while ($tab = mysql_fetch_assoc($rs)) {
		$topscores[] = $tab;
	}
 
	mysql_close();
}

<fb:explanation>
	<fb:message>Top bouletteurs</fb:message>
	Voici les meilleurs lanceurs de boulettes !
</fb:explanation>

<table cellspacing="3">
<?php foreach ($topscores as $topuser): ?>
<tr>
	<td><fb:profile-pic uid="<?php echo $topuser['uid'];?>" size="square" /></td>
	<td><fb:name uid="<?php echo $topuser['uid'];?>" useyou="false" /></td>
	<td class="boulette"><?php echo $topuser['nb']; ?></td>
</tr>
<?php endforeach; ?>
</table>