[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bzflag-commits
Subject:    SF.net SVN: bzflag:[22342] trunk/tools/BZStatCollector
From:       jeffm2501 () users ! sourceforge ! net
Date:       2012-01-22 4:35:35
Message-ID: E1Rop9T-0005wF-D2 () sfp-svn-2 ! v30 ! ch3 ! sourceforge ! com
[Download RAW message or body]

Revision: 22342
          http://bzflag.svn.sourceforge.net/bzflag/?rev=22342&view=rev
Author:   jeffm2501
Date:     2012-01-22 04:35:35 +0000 (Sun, 22 Jan 2012)
Log Message:
-----------
store separate score for use in queries.

Modified Paths:
--------------
    trunk/tools/BZStatCollector/DatabaseStore/DBStore.cs
    trunk/tools/BZStatCollector/schema/database.sql

Modified: trunk/tools/BZStatCollector/DatabaseStore/DBStore.cs
===================================================================
--- trunk/tools/BZStatCollector/DatabaseStore/DBStore.cs	2012-01-21 02:26:47 UTC (rev \
                22341)
+++ trunk/tools/BZStatCollector/DatabaseStore/DBStore.cs	2012-01-22 04:35:35 UTC (rev \
22342) @@ -108,7 +108,7 @@
             DateTime now = DateTime.Now;
             foreach (KeyValuePair<int, GameQuery.PlayerInfo> player in \
connector.GameInfo.Players)  {
-                string query = String.Format("INSERT INTO player_updates \
(PlayerName, ServerName, Team, Score, Timestamp) VALUES (@PLAYER, @SERVER, @TEAM, \
@SCORE, @TIMESTAMP)"); +                string query = String.Format("INSERT INTO \
player_updates (PlayerName, ServerName, Team, Score, Wins, Losses, Teamkills, \
Timestamp) VALUES (@PLAYER, @SERVER, @TEAM, @SCORE, @WINS, @LOSSES, @TKS, \
@TIMESTAMP)");  
                 try
                 {
@@ -118,6 +118,11 @@
                     command.Parameters.Add(new MySqlParameter("TEAM", \
player.Value.Team.ToString()));  command.Parameters.Add(new MySqlParameter("SCORE", \
player.Value.Wins.ToString() + ":" + player.Value.Losses.ToString() + ":" + \
                player.Value.TKs.ToString()));
                     command.Parameters.Add(new MySqlParameter("TIMESTAMP", \
DateTime.Now)); +
+                    command.Parameters.Add(new MySqlParameter("WINS", \
player.Value.Wins.ToString())); +                    command.Parameters.Add(new \
MySqlParameter("LOSSES", player.Value.Losses.ToString())); +                    \
command.Parameters.Add(new MySqlParameter("TKS", player.Value.TKs.ToString())); +
                     command.ExecuteNonQuery();
 
                     query = String.Format("SELECT ID FROM player_names WHERE \
PlayerName=@PLAYER");

Modified: trunk/tools/BZStatCollector/schema/database.sql
===================================================================
--- trunk/tools/BZStatCollector/schema/database.sql	2012-01-21 02:26:47 UTC (rev \
                22341)
+++ trunk/tools/BZStatCollector/schema/database.sql	2012-01-22 04:35:35 UTC (rev \
22342) @@ -45,6 +45,9 @@
   `Team` text,
   `Score` text,
   `Timestamp` datetime DEFAULT NULL,
+  `Wins` int(11),
+  `Losses` int(11),
+  `Teamkills` int(11),
   PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;

This was sent by the SourceForge.net collaborative development platform, the world's \
largest Open Source development site.


------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
BZFlag-commits mailing list
BZFlag-commits@lists.SourceForge.net
https://lists.SourceForge.net/lists/listinfo/bzflag-commits
irc: #BZFlag @ irc.freenode.net


[prev in list] [next in list] [prev in thread] [next in thread]