zCatch:Ranking

1 files changed, 70 insertions, 0 deletions

diff --git a/src/game/server/ranking.h b/src/game/server/ranking.h
new file mode 100644
index 00000000..6c4d1495
--- /dev/null
+++ b/src/game/server/ranking.h
@@ -0,0 +1,70 @@
+#ifndef GAME_SERVER_RANKING_H
+#define GAME_SERVER_RANKING_H
+
+#include "gamecontext.h"
+
+#include <mysql_connection.h>
+
+#include <cppconn/driver.h>
+#include <cppconn/exception.h>
+#include <cppconn/statement.h>
+
+
+class CRanking
+{
+	CGameContext *m_pGameServer;
+	IServer *m_pServer;
+
+
+	sql::Driver *m_pDriver;
+	sql::Connection *m_pConnection;
+	sql::Statement *m_pStatement;
+	sql::ResultSet *m_pResults;
+
+	// copy of config vars
+	const char* m_pDatabase;
+	const char* m_pUser;
+	const char* m_pPass;
+	const char* m_pIp;
+	int m_Port;
+
+	CGameContext *GameServer()
+	{
+		return m_pGameServer;
+	}
+	IServer *Server()
+	{
+		return m_pServer;
+	}
+
+	static void SaveRankingThread(void *pUser);
+
+	void Init();
+
+	bool Connect();
+	void Disconnect();
+	// anti SQL injection
+	void ClearString(char *pString, int size = 32);
+
+
+
+public:
+
+	CRanking(CGameContext *pGameServer);
+	~CRanking();
+
+	void SaveRanking(int ClientID);
+};
+
+struct CSqlRankData
+{
+	CRanking *m_pSqlData;
+	int m_ClientID;
+#if defined(CONF_FAMILY_WINDOWS)
+	char m_aName[16]; // Don't edit this, or all your teeth will fall http://bugs.mysql.com/bug.php?id=50046
+#else
+	char m_aName[MAX_NAME_LENGTH * 2 - 1];
+#endif
+};
+
+#endif