Помогите с системой сохранения денег

Спойлер [+]

JavaScript code:

1. PS_USE_MYSQL = false; -- True/false to set whether MySQL is used.
2.  
3. local MYSQL_HOSTNAME = "localhost";             -- The host of your database.
4. local MYSQL_USERNAME = "root";                  -- Which user it will be logged in with.
5. local MYSQL_PASSWORD = "password";              -- The password for the user.
6. local MYSQL_DATABASE = "lightrp";               -- Which database contains the tables.
7. local MYSQL_PORT = 3306;                                -- The port for the database. Default is 3306.
8.  
9. -- You shouldn't be changing anything below this line
10. -- unless you want to modify which module to use or something else.
11.  
12. db = db or {};
13.  
14. -- These are assumed tables that are assumed already made.
15. -- Used in the persist functions.
16. db.tables = {
17.         money = {table = "Money", data = "number"}
18. /*      title = {table = "Title", data = "string"},
19.         karma = {table = "Karma", data = "number"},
20.         model = {table = "Model", data = "string"},
21.         hat = {table = "Hat", data = "string"},
22.         particle = {table = "Particle", data = "string"},
23.         color = {table = "Color", data = "string"},
24.         bank = {table = "Bank", data = "number"}*/
25. };
26.  
27. function db:Connect()
28.         if (self.obj) then
29.                 print("[Light RP] MySQL connection already exists.");
30.  
31.                 return;
32.         end;
33.  
34.         print("[Light RP] Loading MySQL...");
35.  
36.         local database = mysqloo.connect(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_PORT);
37.  
38.         function database:onConnected()
39.                 db.obj = self;
40.  
41.                 MsgC(Color(0, 255, 0), "[Light RP] Connected to the database!\n");
42.         end;
43.  
44.         function database:onConnectionFailed(message)
45.                 MsgC(Color(255, 0, 0), "[Light RP] Connection failed! "..message.."\n");
46.                 MsgC(Color(255, 0, 0), "[Light RP] Reverting to file/SQLite storage.\n");
47.  
48.                 PS_USE_MYSQL = false;
49.         end;
50.  
51.         if (database) then
52.                 database:connect();
53.  
54.                 timer.Create("ps_SQLHeartBeat", 30, 0, function()
55.                         if (PS_USE_MYSQL) then
56.                                 db:Query("SELECT 1 + 1");
57.                         end;
58.                 end);
59.         end;
60. end;
61.  
62. function db:Query(query, Callback)
63.         if (!query) then
64.                 return;
65.         end;
66.  
67.         if (!PS_USE_MYSQL or !self.obj) then
68.                 MsgC(Color(255, 255, 0), "[Light RP MySQL] Warning! A query is being made but no database!\n");
69.  
70.                 return;
71.         end;
72.  
73.         local query = self.obj:query(query);
74.                 if (Callback) then
75.                         function query:onSuccess(data)
76.                                 Callback(data);
77.                         end;
78.                 end;
79.  
80.                 function query:onError(message, sql)
81.                         MsgC(Color(255, 0, 0), "[Light RP] Query Error! "..message.."\n");
82.                         MsgC(Color(255, 0, 0), "[Light RP] "..sql.."\n");                      
83.                 end;
84.         query:start();
85. end;
86.  
87. if (!PS_USE_MYSQL) then
88.         MsgC(Color(255, 0, 0), "[Light RP] Not using MySQL, switching to file/SQLite storage.\n");
89.  
90.         return;
91. else
92.         require("mysqloo");
93.  
94.         db:Connect();
95. end;

sv_mysql.lua

JavaScript code:

1. --[[
2.         The use of a MySQL database is completely optional.
3.         This gamemode will be using gmsv_mysqloo which can be
4.         found at: <a href="http://forum.gmod-fan.ru/away.php?s=http%3A%2F%2Ffacepunch.com%2Fshowthread.php%3Ft%3D1220537" target="_blank">http://facepunch.com/showthread.php?t=1220537</a>
5.  
6.         Thanks to Drakehawke.
7.  
8.         IMPORTANT! Make sure that you execute the .sql file included in gamemodes/pistachio
9.         Otherwise your gamemode will not use MySQL correctly.
10. --]]
11.  
12. PS_USE_MYSQL = false; -- True/false to set whether MySQL is used.
13.  
14. local MYSQL_HOSTNAME = "localhost";             -- The host of your database.
15. local MYSQL_USERNAME = "root";                  -- Which user it will be logged in with.
16. local MYSQL_PASSWORD = "password";              -- The password for the user.
17. local MYSQL_DATABASE = "lightrp";               -- Which database contains the tables.
18. local MYSQL_PORT = 3306;                                -- The port for the database. Default is 3306.
19.  
20. -- You shouldn't be changing anything below this line
21. -- unless you want to modify which module to use or something else.
22.  
23. db = db or {};
24.  
25. -- These are assumed tables that are assumed already made.
26. -- Used in the persist functions.
27. db.tables = {
28.         money = {table = "Money", data = "number"}
29. /*      title = {table = "Title", data = "string"},
30.         karma = {table = "Karma", data = "number"},
31.         model = {table = "Model", data = "string"},
32.         hat = {table = "Hat", data = "string"},
33.         particle = {table = "Particle", data = "string"},
34.         color = {table = "Color", data = "string"},
35.         bank = {table = "Bank", data = "number"}*/
36. };
37.  
38. function db:Connect()
39.         if (self.obj) then
40.                 print("[Light RP] MySQL connection already exists.");
41.  
42.                 return;
43.         end;
44.  
45.         print("[Light RP] Loading MySQL...");
46.  
47.         local database = mysqloo.connect(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_PORT);
48.  
49.         function database:onConnected()
50.                 db.obj = self;
51.  
52.                 MsgC(Color(0, 255, 0), "[Light RP] Connected to the database!\n");
53.         end;
54.  
55.         function database:onConnectionFailed(message)
56.                 MsgC(Color(255, 0, 0), "[Light RP] Connection failed! "..message.."\n");
57.                 MsgC(Color(255, 0, 0), "[Light RP] Reverting to file/SQLite storage.\n");
58.  
59.                 PS_USE_MYSQL = false;
60.         end;
61.  
62.         if (database) then
63.                 database:connect();
64.  
65.                 timer.Create("ps_SQLHeartBeat", 30, 0, function()
66.                         if (PS_USE_MYSQL) then
67.                                 db:Query("SELECT 1 + 1");
68.                         end;
69.                 end);
70.         end;
71. end;
72.  
73. function db:Query(query, Callback)
74.         if (!query) then
75.                 return;
76.         end;
77.  
78.         if (!PS_USE_MYSQL or !self.obj) then
79.                 MsgC(Color(255, 255, 0), "[Light RP MySQL] Warning! A query is being made but no database!\n");
80.  
81.                 return;
82.         end;
83.  
84.         local query = self.obj:query(query);
85.                 if (Callback) then
86.                         function query:onSuccess(data)
87.                                 Callback(data);
88.                         end;
89.                 end;
90.  
91.                 function query:onError(message, sql)
92.                         MsgC(Color(255, 0, 0), "[Light RP] Query Error! "..message.."\n");
93.                         MsgC(Color(255, 0, 0), "[Light RP] "..sql.."\n");                      
94.                 end;
95.         query:start();
96. end;
97.  
98. if (!PS_USE_MYSQL) then
99.         MsgC(Color(255, 0, 0), "[Light RP] Not using MySQL, switching to file/SQLite storage.\n");
100.  
101.         return;
102. else
103.         require("mysqloo");
104.  
105.         db:Connect();
106. end;

lightrp2.sql

JavaScript code:

1. SET FOREIGN_KEY_CHECKS=0;
2.  
3. CREATE TABLE `players` (
4.   `Key` tinyint(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
5.   `SteamID` varchar(64) NOT NULL,
6. --  `Karma` tinyint(4) NOT NULL,
7.   `Money` int(150) NOT NULL,
8. --  `Bank` int(150) NOT NULL,
9.   `Title` text NOT NULL,
10.   `Particle` varchar(250) NOT NULL,
11.   `Color` varchar(50) NOT NULL,
12. --  `Hat` varchar(250) NOT NULL,
13. --  `Model` varchar(250) NOT NULL,
14.   PRIMARY KEY (`Key`)
15. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;