[Arianne-commits] stendhal_website/scripts achievement.php, NONE, 1.1 website.php, 1.16, 1.17

[Hendrik B. <nh...@us...>]

Update of /cvsroot/arianne/stendhal_website/scripts
In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv6678/scripts

Modified Files:
	website.php 
Added Files:
	achievement.php 
Log Message:
dump list of achievements

Index: website.php
===================================================================
RCS file: /cvsroot/arianne/stendhal_website/scripts/website.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** website.php	28 Oct 2010 19:20:48 -0000	1.16
--- website.php	30 Nov 2010 22:09:23 -0000	1.17
***************
*** 25,28 ****
--- 25,29 ----
  
  require_once('scripts/account.php');
+ require_once('scripts/achievement.php');
  require_once('scripts/cache.php');
  require_once('scripts/events.php');

--- NEW FILE: achievement.php ---
<?php
/*
 Stendhal website - a website to manage and ease playing of Stendhal game
 Copyright (C) 2009-2010   Hendrik Brummermann

 This program is free software: you can redistribute it and/or modify
 it under the terms of the GNU Affero General Public License as published by
 the Free Software Foundation, either version 3 of the License, or
 (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU Affero General Public License for more details.

 You should have received a copy of the GNU Affero General Public License
 along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
/**
  * An achievement player can reach..
  */
class Achievement {
	public $id;
	public $identifier;
	public $title;
	public $category;
	public $base_score;
	public $description;
	public $count;
 
	function __construct($id, $identifier, $title, $category, $base_score, $description, $count) {
		$this->id = $id;
		$this->identifier = $identifier;
		$this->title = $title;
		$this->category = $category;
		$this->base_score = $base_score;
		$this->description = $description;
		$this->count = $count;
	}


	/**
	  * Returns a list of npcs that meet the given condition.
	  * Note: Parmaters must be sql escaped.
	  */
	public static function getAchievements($where='', $sortby='name', $cond='') {
		$query = 'SELECT achievement.id, achievement.identifier, achievement.title, '
			. 'achievement.category, achievement.base_score, achievement.description, '
			. 'count(*) As cnt '
			. 'FROM achievement, reached_achievement '
			. 'WHERE achievement.id = reached_achievement.achievement_id '
			. 'GROUP BY achievement.id, achievement.identifier, achievement.title, '
			. 'achievement.category, achievement.base_score, achievement.description';
		$result = mysql_query($query, getGameDB());
		$list = array();

		while($row = mysql_fetch_assoc($result)) {
			$list[] = new Achievement($row['id'], $row['identifier'], $row['title'], 
				$row['category'], $row['base_score'], $row['description'], $row['cnt']);
		}
		mysql_free_result($result);
		return $list;
	}
}
?>