+
−{-
+
− * Hedgewars, a free turn based strategy game
+
− * Copyright (c) 2004-2015 Andrey Korotaev <unC0Rr@gmail.com>
+
− *
+
− * This program is free software; you can redistribute it and/or modify
+
− * it under the terms of the GNU General Public License as published by
+
− * the Free Software Foundation; version 2 of the License
+
− *
+
− * 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 General Public License for more details.
+
− *
+
− * You should have received a copy of the GNU General Public License
+
− * along with this program; if not, write to the Free Software
+
− * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+
− \-}
+
−
+
−{-# LANGUAGE ScopedTypeVariables, OverloadedStrings #-}
+
−
+
−module Main where
+
−
+
−import Prelude hiding (catch)
+
−import Control.Monad
+
−import Control.Exception
+
−import System.IO
+
−import Data.Maybe
+
−import Database.MySQL.Simple
+
−import Database.MySQL.Simple.QueryResults
+
−import Database.MySQL.Simple.Result
+
−import Data.List (lookup)
+
−import qualified Data.ByteString.Char8 as B
+
−import Data.Word
+
−--------------------------
+
−import CoreTypes
+
−import Utils
+
−
+
−
+
−dbQueryAccount =
+
−    "SELECT CASE WHEN users.status = 1 THEN users.pass ELSE '' END, \
+
−    \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 3), \
+
−    \ (SELECT COUNT(users_roles.rid) FROM users_roles WHERE users.uid = users_roles.uid AND users_roles.rid = 13) \
+
−    \ FROM users WHERE users.name = ?"
+
−
+
−dbQueryStats =
+
−    "INSERT INTO gameserver_stats (players, rooms, last_update) VALUES (?, ?, UNIX_TIMESTAMP())"
+
−
+
−dbQueryAchievement =
+
−    "INSERT INTO achievements (time, typeid, userid, value, filename, location, protocol) \
+
−    \ VALUES (?, (SELECT id FROM achievement_types WHERE name = ?), (SELECT uid FROM users WHERE name = ?), \
+
−    \ ?, ?, ?, ?)"
+
−
+
−dbQueryReplayFilename = "SELECT filename FROM achievements WHERE id = ?"
+
−
+
−
+
−dbInteractionLoop dbConn = forever $ do
+
−    q <- liftM read getLine
+
−    hPutStrLn stderr $ show q
+
−
+
−    case q of
+
−        CheckAccount clId clUid clNick _ -> do
+
−                results <- query dbConn dbQueryAccount $ Only clNick
+
−                let response = case results of
+
−                        [(pass, adm, contr)] ->
+
−                            (
+
−                                clId,
+
−                                clUid,
+
−                                HasAccount
+
−                                    (pass)
+
−                                    (adm == Just (1 :: Int))
+
−                                    (contr == Just (1 :: Int))
+
−                            )
+
−                        _ ->
+
−                            (clId, clUid, Guest)
+
−                print response
+
−                hFlush stdout
+
−
+
−        GetReplayName clId clUid fileId -> do
+
−                results <- query dbConn dbQueryReplayFilename $ Only fileId
+
−                let fn = if null results then "" else fromOnly $ head results
+
−                print (clId, clUid, ReplayName fn)
+
−                hFlush stdout
+
−
+
−        SendStats clients rooms ->
+
−                void $ execute dbConn dbQueryStats (clients, rooms)
+
−        StoreAchievements p fileName teams info ->
+
−            mapM_ (execute dbConn dbQueryAchievement) $ (parseStats p fileName teams) info
+
−
+
−
+
−--readTime = read . B.unpack . B.take 19 . B.drop 8
+
−readTime = B.take 19 . B.drop 8
+
−
+
−parseStats :: 
+
−    Word16 
+
−    -> B.ByteString 
+
−    -> [(B.ByteString, B.ByteString)] 
+
−    -> [B.ByteString] 
+
−    -> [(B.ByteString, B.ByteString, B.ByteString, Int, B.ByteString, B.ByteString, Int)]
+
−parseStats p fileName teams = ps
+
−    where
+
−    time = readTime fileName
+
−    ps [] = []
+
−    ps ("DRAW" : bs) = ps bs
+
−    ps ("WINNERS" : n : bs) = ps $ drop (readInt_ n) bs
+
−    ps ("ACHIEVEMENT" : typ : teamname : location : value : bs) =
+
−        ( time
+
−        , typ
+
−        , fromMaybe "" (lookup teamname teams)
+
−        , readInt_ value
+
−        , fileName
+
−        , location
+
−        , fromIntegral p
+
−        ) : ps bs
+
−    ps (b:bs) = ps bs
+
−
+
−
+
−dbConnectionLoop mySQLConnectionInfo =
+
−    Control.Exception.handle (\(e :: SomeException) -> hPutStrLn stderr $ show e) $
+
−        bracket
+
−            (connect mySQLConnectionInfo)
+
−            close
+
−            dbInteractionLoop
+
−
+
−
+
−--processRequest :: DBQuery -> IO String
+
−--processRequest (CheckAccount clId clUid clNick clHost) = return $ show (clclId, clUid, Guest)
+
−
+
−main = do
+
−        dbHost <- getLine
+
−        dbName <- getLine
+
−        dbLogin <- getLine
+
−        dbPassword <- getLine
+
−
+
−        let mySQLConnectInfo = defaultConnectInfo {
+
−            connectHost = dbHost
+
−            , connectDatabase = dbName
+
−            , connectUser = dbLogin
+
−            , connectPassword = dbPassword
+
−            }
+
−
+
−        dbConnectionLoop mySQLConnectInfo