1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
/*
* UserBackendMysql.h
*
* Copyright (C) 2008 Matthias Schiffer <matthias@gamezock.de>
*
* 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, either version 3 of the License, or
* (at your option) any later version.
*
* 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, see <http://www.gnu.org/licenses/>.
*/
#ifndef MAD_MODULES_USERBACKENDMYSQL_H_
#define MAD_MODULES_USERBACKENDMYSQL_H_
#include <Server/UserBackend.h>
#include <Server/UserManager.h>
#include <Common/Configurable.h>
#include <mysql/mysql.h>
namespace Mad {
namespace Modules {
class UserBackendMysql : public Server::UserBackend, private Common::Configurable {
private:
static boost::shared_ptr<UserBackendMysql> backend;
std::string host, username, passwd, db, unixSocket;
uint16_t port;
std::string queryListUsers, queryListGroups;
std::string queryListUserGroups, queryListGroupUsers;
std::string queryUserById, queryUserByName;
std::string queryGroupById, queryGroupByName;
MYSQL *mysql;
UserBackendMysql() : port(0), mysql(0) {}
protected:
virtual bool handleConfigEntry(const Common::ConfigEntry &entry, bool);
virtual void configFinished();
virtual boost::shared_ptr<std::map<unsigned long, Common::UserInfo> > getUserList() throw(Net::Exception);
virtual boost::shared_ptr<Common::UserInfo> getUserInfo(unsigned long uid) throw(Net::Exception);
virtual boost::shared_ptr<Common::UserInfo> getUserInfoByName(const std::string &name) throw(Net::Exception);
virtual boost::shared_ptr<std::set<unsigned long> > getUserGroupList(unsigned long uid) throw(Net::Exception);
virtual boost::shared_ptr<std::map<unsigned long, Common::GroupInfo> > getGroupList() throw(Net::Exception);
virtual std::string getGroupName(unsigned long gid) throw(Net::Exception);
virtual unsigned long getGroupId(const std::string &name) throw(Net::Exception);
virtual boost::shared_ptr<std::set<unsigned long> > getGroupUserList(unsigned long gid) throw(Net::Exception);
public:
virtual ~UserBackendMysql() {
if(mysql) {
mysql_close(mysql);
mysql = 0;
}
}
static void registerBackend();
static void unregisterBackend();
};
}
}
#endif /* MAD_MODULES_USERBACKENDMYSQL_H_ */
|
