iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games3 - XXXXsdfwe

cenphoenix

浏览: 162130 次
性别:
来自: 大连

最近访客更多访客>>

shamoyuu

个人唯一用户填写

青春追梦

robotmen

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games3

博客分类：

iphone

MySQL SQL SQL Server PHP XHTML

Displaying The Scores Table

As mentioned before, we will be displaying a table on a webpage. The url that the webview will access will be something like this

http://icodeblog.com/ws/get_scores.php?sort=score%20DESC

There are quite a few parameters that can be used with my script that will determine how the table will be displayed. The parameters and their descriptions are in the table below:

Variable Description

type	This value will determine what data the table will display. The possible values for it are global, device, and name. Global will simply show the global high scores list containing all of the users. Device is specific to the calling users device. It will only display high scores for a given udid. Finally, we have name, which will only display high scores for a given username.
offset	Used for paging the SQL results. It will be the first parameter in the ORDER BY clause of the SQL select statement. Ex: An offset of 10 will tell the system to show records starting with the 10th.
count	Used for paging the SQL results. It will be the second parameter in the ORDER BY clause of the SQL select statement. This is basically the number of results to show in the table.
sort	Tells the table how to sort. If this isn’t specified, the sorting is default set to “score DESC”. This will order by scores from highest to lowest.
udid	The UDID of the device viewing the leaderboard. This variable is required if you specify type=device
name	The name of the device viewing the leaderboard. This variable is required if you specify type=name

As you can see, you have quite a bit of control over how the results get displayed. You may want to offer multiple high score views to your user (global, personal, etc…). You can also fancy this up quite a bit and give the users the ability to view the high scores of other users on the list.

Here is the code for get_scores.php

<?php
    // get_scores.php
	/** MySQL database name */
	define('DB_NAME', '');
	/** MySQL database username */
	define('DB_USER', '');
	/** MySQL database password */
	define('DB_PASSWORD', '');
	/** MySQL hostname */
	define('DB_HOST', $_ENV{DATABASE_SERVER});
 
	$table = "highscores";
 
	// Initialization
	$conn = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
	mysql_select_db(DB_NAME, $conn);
 
	// Error checking
	if(!$conn) {
		die('Could not connect ' . mysql_error());
	}
 
	$type   = isset($_GET['type']) ? $_GET['type'] : "global";
	$offset = isset($_GET['offset']) ? $_GET['offset'] : "0";
	$count  = isset($_GET['count']) ? $_GET['count'] : "10";
	$sort   = isset($_GET['sort']) ? $_GET['sort'] : "score DESC";
 
	// Localize the GET variables
	$udid  = isset($_GET['udid']) ? $_GET['udid'] : "";
	$name  = isset($_GET['name']) ? $_GET['name']  : "";
 
	// Protect against sql injections
	$type   = mysql_real_escape_string($type);
	$offset = mysql_real_escape_string($offset);
	$count  = mysql_real_escape_string($count);
	$sort   = mysql_real_escape_string($sort);
	$udid   = mysql_real_escape_string($udid);
	$name   = mysql_real_escape_string($name);
 
	// Build the sql query
	$sql = "SELECT * FROM $table WHERE ";
 
	switch($type) {
		case "global":
			$sql .= "1 ";
			break;
		case "device":
			$sql .= "udid = '$udid' ";
			break;
		case "name":
			$sql .= "name = '$name' ";
			break;
	}
 
	$sql .= "ORDER BY $sort ";
	$sql .= "LIMIT $offset,$count ";
 
	$result = mysql_query($sql,$conn);
 
	if(!$result) {
		die("Error retrieving scores " . mysql_error());
	}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
         "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta name="viewport" content="width=320; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;"/>
	</head>
	<body>
		<?php
			// Display the table	
			echo '<table style="width:100%">
					<thead>
						<tr>
							<th>Name</th>
							<th>Score</th>
						</tr>
					</thead>
					<tbody>';
		    while ($row = mysql_fetch_object($result)) {
				echo '<tr>
						<td>
						'.$row->name.'
						</td>
						<td>
						'.$row->score.'
						</td>
					  </tr>';
			}
			echo '</tbody>
				</table>';	
			mysql_free_result($result);
			mysql_close($conn);
		?>
	</body>
</html>

After initialization, we build the SQL query based on the parameters that were specified. This will determine what data will get displayed. Notice that after the code to query the database, there is some HTML. This is because we want to output a full HTML page for our table. You can use this opportunity to ad things such as styling, images, and advertising.

Within the body, we simply loop over the results returned from MYSQL and output the score data. And that’s it! You now have a fully functional high score server.

With our server complete, there are only two things left to do: submit score data in our iphone application and display the leaderboard.

分享到：

iPhone Coding Tutorial – Creating an O ... | iPhone Coding Tutorial – Creating an O ...

2010-01-06 11:02
浏览 1075
评论(0)
分类:移动开发
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games3

Displaying The Scores Table

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games3

Displaying The Scores Table

评论

发表评论

相关推荐

UIPickerView – spinning multiple components

UITableView效果收集

日期处理

uninstall xcode

从一个url中获得文本信息(转)

将图片保存在iPhone的相册中(转)

一些遊戲製作有關的博客(转)

Beautiful Snowflakes

Layer Programming with Quartz Core

如何移除Three20中private API

iphone下Three20库(From Facebook)的设置使用方法

Opera Masks

Java读取星际译王(StarDict)词库

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games4

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games2

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games1

iPhone Coding Tutorial – Inserting A UITextField In A UIAlertView

iPhone Coding Tutorial – In Application Emailing

Objective-C内存管理总结〜CC专版

tell user the status

最近访客更多访客>>