`
cenphoenix
  • 浏览: 161422 次
  • 性别: Icon_minigender_1
  • 来自: 大连
社区版块
存档分类
最新评论

iPhone Coding Tutorial – Creating an Online Leaderboard For Your Games3

阅读更多

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 – In Application Emailing

    这篇“iPhone Coding Tutorial – In Application Emailing”教程将指导开发者如何在iPhone应用程序中集成电子邮件功能,无需离开应用就能发送邮件。这篇博客文章的链接虽然不可用(已替换为示例文本),但我们可以...

    iPhone Coding Tutorial – Inserting A UITextField In A UIAlertView

    这篇教程“iPhone Coding Tutorial – Inserting A UITextField In A UIAlertViewController”将会教你如何在现代iOS环境中,在警告视图控制器中添加一个文本字段。 首先,我们需要了解`UIAlertController`的基本...

    online coding单表表单模板上传使用说明

    online coding单表表单模板上传使用说明online coding单表表单模板上传使用说明online coding单表表单模板上传使用说明online coding单表表单模板上传使用说明online coding单表表单模板上传使用说明online coding单...

    Coding Games in Python

    Beginners and experienced programmers can use Python to build and play computer games, from mind-bending brainteasers to crazy action games with explosive sound effects and 3-D graphics. Each chapter ...

    An Introduction to Coding for Constrained Systems

    An introduction to coding for constrained systems, Draft Version, 2001. by B H Marcus, R M Roth, P H Siegel

    A Tutorial on Reed-Solomon Coding for Fault-Tolerance in RAID-like Systems

    ### 一、里德-所罗门编码(Reed-Solomon Coding)基础 里德-所罗门编码是一种非二进制线性错误校正码,广泛应用于数据存储和通信系统中,以提供强大的错误检测和纠正能力。它由Irving S. Reed和Gustave Solomon于...

    Hands-On Game Development without Coding: Create 2D and 3D games.epub

    After reading this book you will be able to develop your own 2d and 3d videogames and use it on your presentations, to speed up your level design deliveries, test your game design ideas, work on your ...

    CVPR12 Tutorial on Deep Learning Sparse Coding

    百度的余凯老师在CVPR2012上的Tutorial

    JEECG Online Coding开发手册v3.6.pdf

    ### JEECG Online Coding开发手册 v3.6 知识点总结 #### 1. 单表智能表单 [Online 表单开发] ##### 1.1 创建数据表单(界面如下图) - **创建单表**: 在创建单表时需要注意的是必须包含一个主键字段,并且该主键...

    Beginning iPhone Games Development (Mar 2010) Part 2

    Beginning iPhone Games Development (Mar 2010) Part 2 of 2 Part 1 -&gt; http://download.csdn.net/source/2283635 源代码 -&gt; http://apress.com/book/view/9781430225997 iPhone games are hot! Just look at ...

    Beginning iPhone Games Development

    Beginning iPhone Games Development Apress, 2010年出品 You’ve probably already read and mastered Beginning iPhone 3 Development; Exploring the iPhone SDK, the best-selling, the second edition of ...

    Coding_Games_in_Scratch(英文版)

    《Coding Games in Scratch》是一本面向初学者的编程教材,主要使用Scratch编程语言来教授游戏开发的基础知识。Scratch是由麻省理工学院(MIT)的“终身幼儿园团队”开发的一款图形化编程工具,旨在帮助孩子们学习编程...

    cvpr12_tutorial_sparse_coding.ppt

    cvpr12_tutorial_sparse_coding.ppt

    Beginning iPhone Games Development (New!Hot!)

    How to give your users access to their iPhone libraries from within games The tools and techniques of 3D audio for creating even more realistic gaming experiences How to do networking right, including...

    JEECG Online Coding开发手册v3.6

    JEECG Online Coding开发手册v3.6主要介绍了如何使用JEECG平台进行Online表单的开发和配置。 知识点一:单表智能表单开发 在单表智能表单开发中,首先需要创建数据表单,必须为数据表单设置主键,并确保主键为ID,...

    Beginning iPhone Games Development (Mar 2010) Part 1

    Beginning iPhone Games Development (Mar 2010) Part 1 of 2 Part 2 -&gt; http://download.csdn.net/source/2283657 源代码 -&gt; http://apress.com/book/view/9781430225997 iPhone games are hot! Just look at ...

    Learning.Buildbox.2.Game.Development.1786460300

    Using an example as a tutorial, we will relate the driving principles and you'll see how you can implement these principles to develop any games on the platform. We begin by setting expectations and ...

Global site tag (gtag.js) - Google Analytics