[Arianne-commits] stendhal_website/scripts players.php,1.42,1.43

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

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

Modified Files:
	players.php 
Log Message:
cut off sentence in best player box around 60 characters

Index: players.php
===================================================================
RCS file: /cvsroot/arianne/stendhal_website/scripts/players.php,v
retrieving revision 1.42
retrieving revision 1.43
diff -C2 -d -r1.42 -r1.43
*** players.php	14 Jun 2010 17:25:45 -0000	1.42
--- players.php	19 Jun 2010 14:17:03 -0000	1.43
***************
*** 17,87 ****
   along with this program.  If not, see <http://www.gnu.org/licenses/>.
   */
- 
  /**
!  * A class that represent a player, what it is and what it equips.
!  */
  class Player {
! 	/* Name of the player */
! 	public $name;
! 	/* Sentence that the player wrote using /sentence */
! 	public $sentence;
! 	/* Level of the player */
! 	public $level;
! 	/* An outfit representing the player look in game. */
! 	public $outfit;
! 	/* The age of the player */
! 	public $age;
! 	/* XP of the player. It is a special attribute. */
! 	public $xp;
! 	/* adminlevel */
! 	public $adminlevel;
! 	/* Attributes the player has as a array key=>value */
! 	public $attributes;
! 	/* Money the player has. */
! 	public $money;
! 	/* Equipment the player has in slots in a array slot=>item */
! 	public $equipment;

! 	function __construct($name, $sentence, $age, $level, $xp, $married, $outfit, $money, $adminlevel, $attributes, $equipment) {
! 		$this->name=$name;
! 		$this->sentence=$sentence;
! 		$this->age=$age;
! 		$this->level=$level;
! 		$this->outfit=$outfit;
! 		$this->xp=$xp;
! 		$this->married=$married;
! 		$this->attributes=$attributes;
! 		$this->adminlevel=$adminlevel;
! 		$this->money=$money;
! 		$this->equipment=$equipment;
! 	}

! 	function show() {
! 		echo '<div class="playerBox">';
! 		echo '  <a href="'.rewriteURL('/character/'.surlencode($this->name).'.html').'">';
! 		echo '  <img src="'.rewriteURL('/images/outfit/'.surlencode($this->outfit).'.png').'" alt="" width="48" height="64">';
! 		echo '  <span class="block name">'.htmlspecialchars(utf8_encode($this->name)).'</span>';
! 		echo ' </a>';
! 		echo '  <div class="xp">'.$this->xp.' xp</div>';
! 		if ($this->sentence != '') {
! 			echo ' <div class="quote">'.htmlspecialchars(utf8_encode($this->sentence)).'</div>';
! 		} else {
! 			echo ' <div style="clear:left"></div>';
! 		}
! 		echo '</div>';
  	}

! 	function getDeaths() {
! 		##
! 		## HACK AHEAD - MOVE AWAY - HACK AHEAD - MAKE ROOM
! 		##
! 		if(STENDHAL_PLEASE_MAKE_IT_FAST) {
! 			return array();
! 		}
! 		##
! 		## HACK AHEAD - MOVE AWAY - HACK AHEAD - MAKE ROOM
! 		##

! 		$result = mysql_query("
      select
        timedate,
--- 17,86 ----
   along with this program.  If not, see <http://www.gnu.org/licenses/>.
   */
  /**
!   * A class that represent a player, what it is and what it equips.
!   */
  class Player {
!   /* Name of the player */
!   public $name;
!   /* Sentence that the player wrote using /sentence */
!   public $sentence;
!   /* Level of the player */
!   public $level;
!   /* An outfit representing the player look in game. */
!   public $outfit;
!   /* The age of the player */
!   public $age;
!   /* XP of the player. It is a special attribute. */
!   public $xp;
!   /* adminlevel */
!   public $adminlevel;
!   /* Attributes the player has as a array key=>value */
!   public $attributes;
!   /* Money the player has. */
!   public $money;
!   /* Equipment the player has in slots in a array slot=>item */
!   public $equipment;

!   function __construct($name, $sentence, $age, $level, $xp, $married, $outfit, $money, $adminlevel, $attributes, $equipment) {
!     $this->name=$name;
!     $this->sentence=$sentence;
!     $this->age=$age;
!     $this->level=$level;
!     $this->outfit=$outfit;
!     $this->xp=$xp;
!     $this->married=$married;
!     $this->attributes=$attributes;
!     $this->adminlevel=$adminlevel;
!     $this->money=$money;
!     $this->equipment=$equipment;
!   }

!   function show() {
!     echo '<div class="playerBox">';
!     echo '  <a href="'.rewriteURL('/character/'.surlencode($this->name).'.html').'">';
!     echo '  <img src="'.rewriteURL('/images/outfit/'.surlencode($this->outfit).'.png').'" alt="" width="48" height="64">';
!     echo '  <span class="block name">'.htmlspecialchars(utf8_encode($this->name)).'</span>';
!     echo ' </a>';
!     echo '  <div class="xp">'.$this->xp.' xp</div>';
!     if ($this->sentence != '') {
! 		echo ' <div class="quote">'.htmlspecialchars(utf8_encode( substr($this->sentence, 0, strpos($this->sentence, ' ', 60) - 1))).'</div>';
!     } else {
! 		echo ' <div style="clear:left"></div>';
  	}
+     echo '</div>';
+   }

!   function getDeaths() {
!     ##
!     ## HACK AHEAD - MOVE AWAY - HACK AHEAD - MAKE ROOM
!     ##
!     if(STENDHAL_PLEASE_MAKE_IT_FAST) {
!       return array();
!     }
!     ##
!     ## HACK AHEAD - MOVE AWAY - HACK AHEAD - MAKE ROOM
!     ##

!     $result = mysql_query("
      select
        timedate,
***************
*** 96,148 ****
      limit 4", getGameDB());

! 		$kills=array();

! 		/*
! 		 * TODO: Refactor to use the new table.
! 		 */

! 		while($row=mysql_fetch_assoc($result)) {
! 			$kills[$row['timedate']]=$row['source'];
! 		}

! 		mysql_free_result($result);
! 		return $kills;
! 	}

! 	function getAccountInfo() {
  		// TODO: use character.timedate
  		$result=mysql_query('select characters.timedate, status from account, characters where account.id=characters.player_id AND charname="'.mysql_real_escape_string($this->name).'"',getGameDB());
! 		$account=array();
! 
! 		$row=mysql_fetch_assoc($result);

! 		$account["register"]=$row["timedate"];
! 		$account["status"]=$row["status"];

! 		mysql_free_result($result);

! 		return $account;
! 	}

! 	function getDMScore() {
! 		$result=mysql_query('select points from halloffame where charname="'.mysql_real_escape_string($this->name).'" and fametype="D"',getGameDB());

! 		while($row=mysql_fetch_assoc($result)) {
! 			$points=$row['points'];
! 		}

! 		mysql_free_result($result);
! 		if(sizeof($points)==0){
! 			$points=0;
! 		}
! 		return $points;

  	}
  }

  /**
!  * Returns a list of players online and offline that meet the given condition.
!  * Note: Parmaters must be sql escaped.
!  */
  function getPlayers($where='', $sortby='name', $cond='limit 2') {
  	return _getPlayers('select distinct character_stats.* from character_stats '.$where.' order by '.$sortby.' '.$cond, getGameDB());
--- 95,147 ----
      limit 4", getGameDB());

!     $kills=array();

!     /*
!      * TODO: Refactor to use the new table.
!      */

!     while($row=mysql_fetch_assoc($result)) {
!       $kills[$row['timedate']]=$row['source'];
!     }

!     mysql_free_result($result);
!     return $kills;
!   }

!   function getAccountInfo() {
  		// TODO: use character.timedate
  		$result=mysql_query('select characters.timedate, status from account, characters where account.id=characters.player_id AND charname="'.mysql_real_escape_string($this->name).'"',getGameDB());
!     $account=array();

!     $row=mysql_fetch_assoc($result);

!     $account["register"]=$row["timedate"];
!     $account["status"]=$row["status"];

!     mysql_free_result($result);

!     return $account;
!   }

!   function getDMScore() {
!    $result=mysql_query('select points from halloffame where charname="'.mysql_real_escape_string($this->name).'" and fametype="D"',getGameDB());

!     while($row=mysql_fetch_assoc($result)) {
!       $points=$row['points'];
!     }

+     mysql_free_result($result);
+     if(sizeof($points)==0){
+ 	$points=0;
  	}
+     return $points;
+ 
+   }
  }

  /**
!   * Returns a list of players online and offline that meet the given condition.
!   * Note: Parmaters must be sql escaped.
!   */
  function getPlayers($where='', $sortby='name', $cond='limit 2') {
  	return _getPlayers('select distinct character_stats.* from character_stats '.$where.' order by '.$sortby.' '.$cond, getGameDB());
***************
*** 151,160 ****
  function getPlayer($name) {
  	$player=_getPlayers('select character_stats.* from character_stats where name="'.mysql_real_escape_string($name).'" limit 1', getGameDB());
! 	return $player[0];
  }

  function getBestPlayer($where='') {
! 	$player=_getPlayers('select  *,xp/(age+1) as xp_age_rel from character_stats '.$where.' order by xp_age_rel desc limit 1', getGameDB());
! 	return $player[0];
  }

--- 150,159 ----
  function getPlayer($name) {
  	$player=_getPlayers('select character_stats.* from character_stats where name="'.mysql_real_escape_string($name).'" limit 1', getGameDB());
!     return $player[0];
  }

  function getBestPlayer($where='') {
!     $player=_getPlayers('select  *,xp/(age+1) as xp_age_rel from character_stats '.$where.' order by xp_age_rel desc limit 1', getGameDB());
!     return $player[0];
  }

***************
*** 165,170 ****

  /**
!  * Returns a list of players that are online right now.
!  */
  function getOnlinePlayers() {
  	return _getPlayers('select character_stats.* from character_stats where online=1 order by name');
--- 164,169 ----

  /**
!   * Returns a list of players that are online right now.
!   */
  function getOnlinePlayers() {
  	return _getPlayers('select character_stats.* from character_stats where online=1 order by name');
***************
*** 180,224 ****
  function getCharactersForUsername($username) {
  	return _getPlayers('SELECT character_stats.* FROM character_stats, characters, account '
! 	.'WHERE account.username=\''.mysql_real_escape_string($username).'\' AND '
! 	.'characters.player_id=account.id AND character_stats.name=characters.charname');
  }

  function _getPlayers($query) {
  //	echo $query;
! 	$result = mysql_query($query,getGameDB());
! 	$list=array();

! 	while($row=mysql_fetch_assoc($result)) {
! 		$attributes=array();
! 		$attributes['atk']=$row['atk'];
! 		$attributes['def']=$row['def'];
! 		$attributes['hp']=$row['hp'];
! 		$attributes['karma']=$row['karma'];

! 		$equipment=array();
! 		$equipment['head']=$row['head'];
! 		$equipment['armor']=$row['armor'];
! 		$equipment['lhand']=$row['lhand'];
! 		$equipment['rhand']=$row['rhand'];
! 		$equipment['legs']=$row['legs'];
! 		$equipment['feet']=$row['feet'];
! 		$equipment['cloak']=$row['cloak'];

! 		$list[]=new Player($row['name'],
! 		$row['sentence'],
! 		$row['age'],
! 		$row['level'],
! 		$row['xp'],
! 		$row['married'],
! 		$row['outfit'],
! 		$row['money'],
! 		$row['admin'],
! 		$attributes,
! 		$equipment);
! 	}

! 	mysql_free_result($result);

! 	return $list;
  }

--- 179,223 ----
  function getCharactersForUsername($username) {
  	return _getPlayers('SELECT character_stats.* FROM character_stats, characters, account '
! 		.'WHERE account.username=\''.mysql_real_escape_string($username).'\' AND '
! 		.'characters.player_id=account.id AND character_stats.name=characters.charname');
  }

  function _getPlayers($query) {
  //	echo $query;
!     $result = mysql_query($query,getGameDB());
!     $list=array();

!     while($row=mysql_fetch_assoc($result)) {
!       $attributes=array();
!       $attributes['atk']=$row['atk'];
!       $attributes['def']=$row['def'];
!       $attributes['hp']=$row['hp'];
!       $attributes['karma']=$row['karma'];

!       $equipment=array();
!       $equipment['head']=$row['head'];
!       $equipment['armor']=$row['armor'];
!       $equipment['lhand']=$row['lhand'];
!       $equipment['rhand']=$row['rhand'];
!       $equipment['legs']=$row['legs'];
!       $equipment['feet']=$row['feet'];
!       $equipment['cloak']=$row['cloak'];

!       $list[]=new Player($row['name'],
!                      $row['sentence'],
!                      $row['age'],
!                      $row['level'],
!                      $row['xp'],
!                      $row['married'],
!                      $row['outfit'],
!                      $row['money'],
!                      $row['admin'],
!                      $attributes,
!                      $equipment);
!     }

!     mysql_free_result($result);

!     return $list;
  }

[Arianne-commits] stendhal_website/scripts players.php,1.42,1.43

Arianne is an engine to develop multiplayer online games like Stendhal

[Arianne-commits] stendhal_website/scripts players.php,1.42,1.43