[Arianne-commits] stendhal/data/script halloffame.sql,1.1,1.2

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

Update of /cvsroot/arianne/stendhal/data/script
In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv17060/data/script

Modified Files:
	halloffame.sql 
Log Message:
added best player xp/(age+1)

Index: halloffame.sql
===================================================================
RCS file: /cvsroot/arianne/stendhal/data/script/halloffame.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** halloffame.sql	19 Sep 2010 13:13:43 -0000	1.1
--- halloffame.sql	19 Sep 2010 17:11:34 -0000	1.2
***************
*** 110,111 ****
--- 110,124 ----
  ORDER BY xp DESC;
  
+ 
+ INSERT INTO halloffame_archive (charname, fametype, rank, points, day, recent) 
+ SELECT name, 'B', @rownum:=@rownum+1 as rank, xp/(age+1) As points, CURRENT_DATE(), 0 
+ FROM character_stats, (SELECT @rownum:=0) r 
+ WHERE admin<=600 
+ ORDER BY points DESC;
+ 
+ INSERT INTO halloffame_archive (charname, fametype, rank, points, day, recent) 
+ SELECT name, 'B', @rownum:=@rownum+1 as rank, xp/(age+1) As points, CURRENT_DATE(), 1 
+ FROM character_stats, (SELECT @rownum:=0) r 
+ WHERE admin<=600 AND character_stats.lastseen>date_sub(CURRENT_TIMESTAMP, interval 1 month)
+ ORDER BY points DESC;
+