[技术类][原创]Psychostats2.3.3安装之十全大补贴

cfans

与Songsong在dt-club发表第一篇关于Psychostats的安装使用说明时隔近两年，Psychostats正式发布的版本已经到了2.3.3（3.0已经出Demo了，估计正式版也会很快发布了）。我是2005年才发现这个系统，觉得做得非常棒。于是自己动手开始安装，仔细研读了点通所有关于Psychostats的帖子，但是安装过程还是磕磕绊绊不是很顺利，多方寻求帮助无果的情况下只好在Psychostats的官方论坛上发贴，希望能从Jason Morriss（也就是tormtrooper）和JTP10181那里获得帮助，最后终于功夫不负有心人，遇到的问题都一一解决了。今天把解决方法发出来分享给大家，希望能对于我有同样爱好的朋友有所帮助。


前注：
[1]在阅读本文之前请仔细阅读Songsong发的“Psychostats2.2.b调试、安装、使用帮助”
[2]本文讨论的环境为Win2003＋CS1.5 Build2615(Ver4.1.1.1e)＋AMXX1.6＋MM1.19p28<+……>
[3]在严格安装Songsong发的说明安装的情况下出现以下问题（可能是系统Bug，或是被Songsong忽略所致）
[4]安装时注意：在运行Install.pl前应先运行update.pl将安装文件升级到最新版本。安装后依次运行install.pl -resetdb -profiles和install.pl -step web -useconf以解决缺少plr_profile表和页面错误的的问题.
在安装Psychostats2.3.3后出现如下问题：
Q1：“玩家”等几个页面打开后是空白页或者是乱码
Q2：服务器页面出现“服务器无法响应”的提示
Q3：PIP插件安装后在Console里输入ps_password <password>报错：
[PsychoStats] SQL error. Contact your admin: 'Unknown column 'password' in 'field list''

Fix1：
打开<stats root>\include\common.php
找到（第165行）：
header('Content-Type: text/html; charset=utf-8');
修改为：
header('Content-Type: text/html; charset=gb2312');

PS：这是一个系统的Bug。Psychstats的编码格式为UTF-8，在用户打开Psychstats的相应页面时，系统会根据用户浏览器默认语言的编码自动选择以那种语言编码显示。问题就出在这，实际情况是Psychstats已经确认了浏览器的编码格式但没有进行自动转换，导致只有以默认的english显示正确。该问题存在于包括简体中文在内的多个语言的PS2的多个release。


Fix2：
打开<stats root>\server.php
注意有这样一行：
'querytype' => 'halflife', // change this to 'oldhalflife' if you're using CS 1.5 or lower
将halflife改为oldhalflife即可解决。

PS：该问题仅存在于CS1.5中，1.5以上版本在按照“前注[4]”操作后就不会出现。由于CS1.5以上的数据查询方法与1.5不同所以在这里应该选择与相应版本对应的数据查询方式。

Fix3：
将以下代码另存为.sma格式，使用相应的AMXX或AMX编译器进行编译后复制到<CS root>\cstrike\addons\amxmodx\plugins下

2. /* AMX Mod (X)
3. *   PsychoStats Interface Plugin
4. *
5. *   by Jason Morriss <[email]stormtrooper@psychostats.com[/email]>
6. *   and JTP10181 <[email]jtp@jtpage.net[/email]>
7. *   [url=http://www.psychostats.com/]http://www.psychostats.com/[/url]
8. *
9. *
10. *  This program is free software; you can redistribute it and/or modify it
11. *  under the terms of the GNU General Public License as published by the
12. *  Free Software Foundation; either version 2 of the License, or (at
13. *  your option) any later version.
14. *
15. *  This program is distributed in the hope that it will be useful, but
16. *  WITHOUT ANY WARRANTY; without even the implied warranty of
17. *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
18. *  General Public License for more details.
19. *
20. *  You should have received a copy of the GNU General Public License
21. *  along with this program; if not, write to the Free Software Foundation,
22. *  Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
23. *
24. *  In addition, as a special exception, the author gives permission to
25. *  link the code of this program with the Half-Life Game Engine ("HL
26. *  Engine") and Modified Game Libraries ("MODs") developed by Valve,
27. *  L.L.C ("Valve"). You must obey the GNU General Public License in all
28. *  respects for all of the code used other than the HL Engine and MODs
29. *  from Valve. If you modify this file, you may extend this exception
30. *  to your version of the file, but you are not obligated to do so. If
31. *  you do not wish to do so, delete this exception statement from your
32. *  version.
33. */
34. //Do Not TOUCH. This is for debugging only.
35. //#define DEBUG
36. //#define MYSQLDEBUG
37. #if defined DEBUG
38. new debug_authid[]  = "STEAM_0:0:123456";
39. new debug_name[] = "Stormtrooper";
40. new debug_ipaddr[] = "0.0.0.0";
41. #endif
42. // *** DO NOT EDIT BELOW HERE ***
43. #include <amxconst>
44. #if defined AMXX_VERSION
45.   #include <amxmodx>
46.   #include <dbi>
47. #else
48.   #include <amxmod>
49.   #include <mysql>
50. #endif
51. #include <amxmisc>
52. // GLOBAL VARIABLES
53. new ps_version[] = "1.4";
54. new pshost[64], psuser[32], pspass[32], psdb[32], plrtbl[32], psuniqueid[16], psurl[255], psrankurl[255], psadminpw[64];
55. new plriplogged[33];
56. public plugin_init() {
57. register_plugin("PsychoStats PIP", ps_version, "Stormtrooper");
58. register_cvar("ps_version", ps_version);
59. register_cvar("ps_db_host","127.0.0.1");
60. register_cvar("ps_db_user","ps2");
61. register_cvar("ps_db_pass","ps2");
62. register_cvar("ps_db_name","ps_stats");
63. register_cvar("ps_db_plrtable","pstats_plr");
64. register_cvar("ps_stats_url","");
65. register_cvar("ps_rank_url","");
66. register_cvar("ps_uniqueid","worldid");
67. register_cvar("ps_admin_password","");
68. register_cvar("ps_logip","1");
69. register_concmd("ps_password", "cmdPassword", 0, "[<old password>] <new password> - sets your password in the
70. PsychoStats database");
71. register_concmd("ps_setadmin", "cmdSetAdmin", ADMIN_RCON, "<admin password> - sets you as ADMIN in the Psychostats
72. database");
73. register_concmd("ps_admin",    "cmdSetAdmin", ADMIN_RCON, "<admin password> - sets you as ADMIN in the Psychostats
74. database");
75. register_concmd("ps_username", "cmdUsername", 0, "<password> <new username> - sets your username in the PsychoStats
76. database");
77. register_clcmd("say", "HandleSay");
78. #if defined AMXX_VERSION
79. new configsDir[128];
80. get_configsdir(configsDir, 127);
81. server_cmd("exec %s/psychostats2.cfg", configsDir);
82. #else
83. server_cmd("exec addons/amx/psychostats2.cfg");
84. #endif
85. }
86. //Called by ps_setadmin, to give yourself admin access on the stats.
87. public cmdSetAdmin(id,level,cid) {
88. if (!cmd_access(id,level,cid,2)) return PLUGIN_HANDLED;
89. new cmd[128], error[256], plrmatch[65], authid[33], name[65], ipaddr[16], plrid[16], plrprofid[16], userpw[65];
90. load_pscvars();     // Load our config
91. read_argv(1, userpw, 64);   // Get the password specified by the user
92. // Load the user information
93. _getuserinfo(id, authid, name, ipaddr, plrmatch);
94. if (equal(psadminpw, "")) {
95.   console_print(id, "[PsychoStats] Server admin has disabled this feature.");
96.   return PLUGIN_HANDLED;
97. }
98. console_print(id, "[PsychoStats] Setting ADMIN flag for %s '%s'", psuniqueid, plrmatch);
99. if (!equal(psadminpw,userpw)) {
100.   console_print(id, "[PsychoStats] Invalid admin password.");
101.   return PLUGIN_HANDLED;
102. }
103. // Connect to mysql server
104. #if defined AMXX_VERSION
105. new Sql:dbh = dbi_connect(pshost, psuser, pspass, psdb, error, 255);
106. new Result:result
107. if (dbh <= SQL_FAILED ) {
108. #else
109. new dbh = mysql_connect(pshost, psuser, pspass, psdb, error, 255);
110. if (dbh < 1) {
111. #endif
112.   console_print(id, "[PsychoStats] MYSQL connect error. Contact your admin: '%s'", error);
113.   server_print("[PsychoStats] MYSQL connect error: '%s' (%s,%s,%s)", error, pshost, psuser, psdb);
114.   return PLUGIN_HANDLED;
115. }
116. format(cmd, 127, "SELECT plrid FROM %s WHERE %s='%s'", plrtbl, psuniqueid, plrmatch);
117. #if defined AMXX_VERSION
118. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED  ) return PLUGIN_HANDLED;
119. if (dbi_nextrow(result) > 0) {
120.   dbi_field(result, 1, plrid, 15);  // Player ID matching the STEAMID
121. }
122. dbi_free_result(result)
123. #else
124. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
125. if (mysql_nextrow(dbh) > 0) {
126.   mysql_getfield(dbh, 1, plrid, 15);  // Player ID matching the STEAMID
127. }
128. #endif
129. // If no plrid was returned then there is no match in the database for the current user
130. if (equal(plrid,"")) {
131.   console_print(id, "[PsychoStats] No player matches your %s '%s' in the database yet.", psuniqueid, plrmatch);
132.   console_print(id, "[PsychoStats] Please try again after the server stats have updated.");
133.   return PLUGIN_HANDLED;
134. }
135. format(cmd,127,"SELECT plrprofileid FROM %s_profile WHERE %s='%s' LIMIT 1", plrtbl, psuniqueid, plrmatch);
136. #if defined AMXX_VERSION
137. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED  ) return PLUGIN_HANDLED;
138. if (dbi_nextrow(result) > 0) {
139.   dbi_field(result, 1, plrprofid, 15);
140. }
141. dbi_free_result(result)
142. #else
143. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
144. if (mysql_nextrow(dbh) > 0) {
145.   mysql_getfield(dbh, 1, plrprofid, 15);
146. }
147. #endif
148. if (equal(plrprofid,"")) {
149.   quote_sql(name,64);
150.   if (equal(psuniqueid,"name")) {
151.    format(cmd,127,"INSERT INTO %s_profile (name, accesslevel) VALUES ('%s', 10)", plrtbl, name);
152.   }
153.   else {
154.    format(cmd,127,"INSERT INTO %s_profile (%s, name, accesslevel) VALUES ('%s', '%s', 10)", plrtbl,
155. psuniqueid, plrmatch, name);
156.   }
157. }
158. else {
159.   format(cmd,127,"UPDATE %s_profile SET accesslevel=10 WHERE plrprofileid='%s'", plrtbl, plrprofid);
160. }
161. #if defined AMXX_VERSION
162. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
163. #else
164. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
165. #endif
166. console_print(id, "[PsychoStats] Accesslevel successfully updated for %s", plrmatch);
167. if (!equal(psurl,"")) console_print(id, "[PsychoStats] Game Stats: %s", psurl);
168. #if defined AMXX_VERSION
169. dbi_close(dbh);
170. #else
171. mysql_close(dbh);
172. #endif
173. return PLUGIN_HANDLED;
174. }
175. //Called by ps_username, to assign a username to a player profile
176. public cmdUsername(id,level,cid) {
177. if (!cmd_access(id,level,cid,2)) return PLUGIN_HANDLED;
178. new cmd[256], error[256], plrmatch[65], authid[33], name[65], ipaddr[16], plrid[16], curpw[33], username[65];
179. new sqlpw[33], pwhash[33], dbpw[33], sqluser[71];
180. load_pscvars();     // Load our config
181. // Load the user information
182. _getuserinfo(id, authid, name, ipaddr, plrmatch);
183. new args = read_argc() - 1;  // Total arg's given
184. if (args > 1) {    // If we got more than 1 we have <old> <new>
185.   read_argv(1, curpw, 32);
186.   read_argv(2, username, 64);
187. }
188. else {     // we only have 1
189.   console_print(id, "[PsychoStats] You must provide your password and new username.");
190.   return PLUGIN_HANDLED;
191. }
192. console_print(id, "[PsychoStats] Changing username for %s '%s'", psuniqueid, plrmatch);
193. // Connect to mysql server
194. #if defined AMXX_VERSION
195. new Sql:dbh = dbi_connect(pshost, psuser, pspass, psdb, error, 255);
196. new Result:result
197. if (dbh <= SQL_FAILED ) {
198. #else
199. new dbh = mysql_connect(pshost, psuser, pspass, psdb, error, 255);
200. if (dbh < 1) {
201. #endif
202.   console_print(id, "[PsychoStats] MYSQL connect error. Contact your admin: '%s'", error);
203.   server_print("[PsychoStats] MYSQL connect error: '%s' (%s,%s,%s)", error, pshost, psuser, psdb);
204.   return PLUGIN_HANDLED;
205. }
206. // determine if the username specified already exists or not
207. copy(sqluser,70,username);
208. quote_sql(sqluser, 70);
209. format(cmd, 255, "SELECT plrprofileid FROM %s_profile WHERE `username`='%s' LIMIT 1", plrtbl, sqluser);
210. #if defined AMXX_VERSION
211. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
212. if (dbi_nextrow(result) > 0) {
213.   dbi_field(result, 1, plrid, 16);  // Player ID matching the STEAMID
214. }
215. dbi_free_result(result)
216. #else
217. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
218. if (mysql_nextrow(dbh) > 0) {
219.   mysql_getfield(dbh, 1, plrid, 16);  // Player ID matching the STEAMID
220. }
221. #endif
222. if (!equal(plrid,"")) {
223.   console_print(id, "[PsychoStats] Username '%s' already exists. Please try another name.", username);
224.   return PLUGIN_HANDLED;
225. }
226. // Since I don't know of any md5 functions in the AMX code, i'll just let the SQL server do it for me
227. // We're converting the curpw that the user gave into a hash so we can compare it with the current pw
228. // We also load the current password for the user here
229. copy(sqlpw,32,curpw);
230. quote_sql(sqlpw, 32);
231. format(cmd, 255, "SELECT plrprofileid, `password`, MD5('%s') as pw FROM %s_profile WHERE %s='%s' LIMIT 1", sqlpw,
232. plrtbl, psuniqueid, plrmatch);
233. #if defined AMXX_VERSION
234. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
235. if (dbi_nextrow(result) > 0) {
236.   dbi_field(result, 1, plrid, 16);  // Player ID matching the STEAMID
237.   dbi_field(result, 2, dbpw, 32);  // user's current pw (might be blank)
238.   dbi_field(result, 3, pwhash, 32);  // the converted curpw (it's an md5 hash now)
239. }
240. dbi_free_result(result)
241. #else
242. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
243. if (mysql_nextrow(dbh) > 0) {
244.   mysql_getfield(dbh, 1, plrid, 16);  // Player ID matching the STEAMID
245.   mysql_getfield(dbh, 2, dbpw, 32);  // user's current pw (might be blank)
246.   mysql_getfield(dbh, 3, pwhash, 32);  // the converted curpw (it's an md5 hash now)
247. }
248. #endif
249. // If no plrid was returned then there is no match in the database for the current user
250. if (equal(plrid,"")) {
251.   console_print(id, "[PsychoStats] No player matches your %s '%s' in the database yet.", psuniqueid, plrmatch);
252.   console_print(id, "[PsychoStats] Please create profile first using command 'ps_password'.");
253.   return PLUGIN_HANDLED;
254. }
255. // we must verify they supplied a valid password
256. if (!equali(pwhash, dbpw)) { // both pw's are md5 hashes
257.   console_print(id, "[PsychoStats] Authentication failure for %s", authid);
258.   console_print(id, "[PsychoStats] Passwords do not match!");
259.   console_print(id, "[PsychoStats] Usage: ps_username <password> <new username>");
260.   return PLUGIN_HANDLED;
261. }
262. copy(sqluser,70,username);
263. quote_sql(sqluser, 70);
264. format(cmd,255,"UPDATE %s_profile SET `username`='%s' WHERE plrprofileid='%s'", plrtbl, sqluser, plrid);
265. #if defined AMXX_VERSION
266. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
267. #else
268. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
269. #endif
270. console_print(id, "[PsychoStats] Username successfully updated for %s '%s'", psuniqueid, plrmatch);
271. if (!equal(psurl,"")) console_print(id, "[PsychoStats] Game Stats: %s", psurl);
272. #if defined AMXX_VERSION
273. dbi_close(dbh);
274. #else
275. mysql_close(dbh);
276. #endif
277. return PLUGIN_HANDLED;
278. }
279. //Called by ps_password, clients can set thier stats password
280. public cmdPassword(id,level,cid) {
281. if (!cmd_access(id,level,cid,2)) return PLUGIN_HANDLED;
282. new cmd[256], error[256], plrmatch[65], authid[33], name[65], ipaddr[16], plrid[16], plrprofid[16], oldpw[33], curpw
283. [33], newpw[33];
284. new sqlpw[33];
285. load_pscvars();     // Load our config
286. // Load the user information
287. _getuserinfo(id, authid, name, ipaddr, plrmatch);
288. new args = read_argc() - 1;  // Total arg's given
289. if (args > 1) {    // If we got more than 1 we have <old> <new>
290.   read_argv(1, oldpw, 32);
291.   read_argv(2, newpw, 32);
292. }
293. else {     // we only have 1
294.   read_argv(1, newpw, 32);
295. }
296. new msg[255];
297. msg = (args == 1) ? "[PsychoStats] Setting initial user password for player matching %s '%s'" : "[PsychoStats]
298. Changing password for player matching %s '%s'";
299. console_print(id, msg, psuniqueid, plrmatch);
300. // Connect to mysql server
301. #if defined AMXX_VERSION
302. new Sql:dbh = dbi_connect(pshost, psuser, pspass, psdb, error, 255);
303. new Result:result
304. if (dbh <= SQL_FAILED ) {
305. #else
306. new dbh = mysql_connect(pshost, psuser, pspass, psdb, error, 255);
307. if (dbh < 1) {
308. #endif
309.   console_print(id, "[PsychoStats] MYSQL connect error. Contact your admin: '%s'", error);
310.   server_print("[PsychoStats] MYSQL connect error: '%s' (%s,%s,%s)", error, pshost, psuser, psdb);
311.   return PLUGIN_HANDLED;
312. }
313. format(cmd, 255, "SELECT plrid FROM %s WHERE %s='%s' LIMIT 1", plrtbl, psuniqueid, plrmatch);
314. #if defined AMXX_VERSION
315. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
316. if (dbi_nextrow(result) > 0) {
317.   dbi_field(result, 1, plrid, 16);  // Player ID matching the STEAMID
318. }
319. dbi_free_result(result);
320. #else
321. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
322. if (mysql_nextrow(dbh) > 0) {
323.   mysql_getfield(dbh, 1, plrid, 16);  // Player ID matching the STEAMID
324. }
325. #endif
326. // If no plrid was returned then there is no match in the database for the current user
327. if (equal(plrid,"")) {
328.   console_print(id, "[PsychoStats] No player matches your %s '%s' in the database yet.", psuniqueid, plrmatch);
329.   console_print(id, "[PsychoStats] Please try again after the server stats have updated.");
330.   return PLUGIN_HANDLED;
331. }
332. // Since I don't know of any md5 functions in the AMX code, i'll just let the SQL server do it for me
333. // We're converting the oldpw that the user gave into a hash so we can compare it with the current pw
334. // We also load the current password for the user here
335. copy(sqlpw,32,oldpw);
336. quote_sql(sqlpw, 32);
337. format(cmd, 255, "SELECT plrprofileid, `password`, MD5('%s') AS pw FROM %s_profile WHERE %s='%s' LIMIT 1", sqlpw,
338. plrtbl, psuniqueid, plrmatch);
339. #if defined AMXX_VERSION
340. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
341. if (dbi_nextrow(result) > 0) {
342.   dbi_field(result, 1, plrprofid, 16);  // Player ID matching the STEAMID
343.   dbi_field(result, 2, curpw, 32);  // user's current pw (might be blank)
344.   dbi_field(result, 3, oldpw, 32);  // the converted oldpw (it's an md5 hash now)
345. }
346. dbi_free_result(result);
347. #else
348. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
349. if (mysql_nextrow(dbh) > 0) {
350.   mysql_getfield(dbh, 1, plrprofid, 16);  // Player ID matching the STEAMID
351.   mysql_getfield(dbh, 2, curpw, 32);  // user's current pw (might be blank)
352.   mysql_getfield(dbh, 3, oldpw, 32);  // the converted oldpw (it's an md5 hash now)
353. }
354. #endif
355. // If there's a current password for the user we must verify they supplied a valid password
356. if (!equal(curpw, "")) {
357.   if (args == 1) {
358.    console_print(id, "[PsychoStats] Authentication failure for %s", authid);
359.    console_print(id, "[PsychoStats] You must provide your current password in order to change it. If you
360. don't know what it is please contact your admin.");
361.    console_print(id, "[PsychoStats] Usage:  %s %s", "ps_password", "<old password> <new password>")
362.    return PLUGIN_HANDLED;
363.   }
364.   else if (!equali(curpw, oldpw)) { // both pw's are md5 hashes
365.    console_print(id, "[PsychoStats] Authentication failure for %s", authid);
366.    console_print(id, "[PsychoStats] Passwords do not match!");
367.    console_print(id, "[PsychoStats] Usage:  %s %s", "ps_password", "[<old password>] <new password>")
368.    return PLUGIN_HANDLED;
369.   }
370. }
371. copy(sqlpw,32,newpw);
372. quote_sql(sqlpw, 32);
373. if (equal(plrprofid,"")) {
374.   quote_sql(name,64);
375.   if (equal(psuniqueid,"name")) {
376.    format(cmd,255,"INSERT INTO %s_profile (name, password, accesslevel) VALUES ('%s', MD5('%s'), '1')",
377. plrtbl, name, sqlpw);
378.   }
379.   else {
380.    format(cmd,255,"INSERT INTO %s_profile (%s, name, password, accesslevel) VALUES ('%s', '%s', MD5('%
381. s'), '1')", plrtbl, psuniqueid, plrmatch, name, sqlpw);
382.   }
383. }
384. else {
385.   format(cmd,255,"UPDATE %s_profile SET `password`=MD5('%s') WHERE plrprofileid='%s'", plrtbl, sqlpw,
386. plrprofid);
387. }
388. #if defined AMXX_VERSION
389. if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
390. #else
391. if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
392. #endif
393. console_print(id, "[PsychoStats] Password successfully updated for %s '%s'", psuniqueid, plrmatch);
394. if (!equal(psurl,"")) console_print(id, "[PsychoStats] Game Stats: %s", psurl);
395. #if defined AMXX_VERSION
396. dbi_close(dbh);
397. #else
398. mysql_close(dbh);
399. #endif
400. return PLUGIN_HANDLED;
401. }
402. //This code is all for the PSRank in game MOTD popups
403. public HandleSay(id) {
404. new Speech[128];
405. read_args(Speech,127);
406. remove_quotes(Speech);
407. load_pscvars();
408. /*
409. register_clcmd("say /statsme","cmdStatsMe",0,"- displays your stats")
410. register_clcmd("say /stats","cmdStats",0,"- displays others stats")
411. register_clcmd("say /top15","cmdTop15",0,"- displays top 15 players")
412. register_clcmd("say /rank","cmdRank",0,"- displays your server stats")
413. */
414. if(containi(Speech, "/psstats") == 0) {
415.   show_motd(id, psrankurl, "Stats: Powered by PsychoStats");
416.   return PLUGIN_HANDLED;
417. }
418. if(containi(Speech, "/pstop15") == 0 || containi(Speech, "/pstop10") == 0) {
419.   new smalltt[256];
420.   format (smalltt,255,"%s/smalltopten.php",psrankurl);
421.   show_motd(id, smalltt, "Top 10: Powered by PsychoStats");
422.   return PLUGIN_HANDLED;
423. }
424. if(containi(Speech, "/psrank") == 0 || containi(Speech, "/psstatsme") == 0) {
425.   new cmd[128], error[255], rankurl[256], plrmatch[65], authid[33], name[65], ipaddr[16], plrid[16];
426.   _getuserinfo(id, authid, name, ipaddr, plrmatch);
427.   // Connect to mysql server
428.   #if defined AMXX_VERSION
429.   new Sql:dbh = dbi_connect(pshost, psuser, pspass, psdb, error, 255);
430.   new Result:result
431.   if (dbh <= SQL_FAILED ) {
432.   #else
433.   new dbh = mysql_connect(pshost, psuser, pspass, psdb, error, 255);
434.   if (dbh < 1) {
435.   #endif
436.    console_print(id, "[PsychoStats] MYSQL connect error. Contact your admin: '%s'", error);
437.    server_print("[PsychoStats] MYSQL connect error: '%s' (%s,%s,%s)", error, pshost, psuser, psdb);
438.    return PLUGIN_HANDLED;
439.   }
440.   format(cmd, 127, "SELECT plrid FROM %s WHERE %s='%s'", plrtbl, psuniqueid, plrmatch);
441.   #if defined AMXX_VERSION
442.   if ( (result = _query(dbh, cmd, id)) == RESULT_FAILED ) return PLUGIN_HANDLED;
443.   if (dbi_nextrow(result) > 0) {
444.    dbi_field(result, 1, plrid, 15);
445.   }
446.   dbi_free_result(result);
447.   #else
448.   if (!_query(dbh, cmd, id)) return PLUGIN_HANDLED;
449.   if (mysql_nextrow(dbh) > 0) {
450.    mysql_getfield(dbh, 1, plrid, 15);
451.   }
452.   #endif
453.   if (equal(plrid,"")) {
454.    client_print(id,print_chat,"[PsychoStats] No player matches your %s '%s' in the database.",
455. psuniqueid, plrmatch);
456.    format(rankurl,255,"%s/index.php?search=%s",psrankurl, plrmatch);
457.   }
458.   else {
459.    format(rankurl,255,"%s/player.php?id=%s",psrankurl,plrid);
460.   }
461.   show_motd(id, rankurl, "Rank: Powered by PsychoStats")
462.   return PLUGIN_HANDLED;
463. }
464. if(containi(Speech, "/search") == 0) {
465.   new arg1[32], arg2[32];
466.   parse(Speech,arg1,31,arg2,31);
467.   new rankurl[256];
468.   format(rankurl,255,"%s/index.php?search=%s",psrankurl,arg2);
469.   show_motd(id, rankurl, "Stats Search: Powered by PsychoStats");
470.   return PLUGIN_HANDLED;
471. }
472. return PLUGIN_CONTINUE;
473. }
475. //Below is all code to assist in IP tracking and make it more reliable
476. public logip(id) {
477. if (!plriplogged[id] && get_cvar_num("ps_logip")) {
478.   new name[32], authid[32], team[32], address[32]
479.   get_user_name(id,name,31);
480.   get_user_authid(id,authid,31);
481.   get_user_team(id,team,31);
482.   get_user_ip(id,address,31);
483.   if (equal(authid,"STEAM_ID_PENDING")) return
484.   if (get_user_userid(id) == -1) return
485.   if (equal(address,"")) return
486.   if (equal(team, "UNASSIGNED")) copy(team,31,"")
487.   log_message("^"%s<%d><%s><%s>^" triggered ^"address^" (address ^"%s^")",
488.   name,get_user_userid(id),authid,team,address);
489.   plriplogged[id] = 1;
490. }
491. }
492. public client_disconnect(id) {
493. //Only need to log it agian if the user did something on the server
494. if ((get_user_frags(id) > 0) || (get_user_deaths(id) > 0) || (get_user_time(id,1) > 30)) {
495.   //Set to 0 to make it log it agian
496.   plriplogged[id] = 0;
497.   logip(id);
498. }
499. //Set to 0 to make sure next client with this id gets logged
500. plriplogged[id] = 0;
501. }
502. public client_connect(id) {
503. plriplogged[id] = 0;
504. }
505. public client_putinserver(id) {
506. logip(id);
507. }
508. public client_infochanged(id) {
509. logip(id);
510. }
511. // Support functions
512. // This can be called from another function to load the cvars into variables
513. load_pscvars() {
514. get_cvar_string("ps_db_host", pshost, 63);
515. get_cvar_string("ps_db_user", psuser, 31);
516. get_cvar_string("ps_db_pass", pspass, 31);
517. get_cvar_string("ps_db_name", psdb, 31);
518. get_cvar_string("ps_db_plrtable", plrtbl, 31);
519. get_cvar_string("ps_stats_url", psurl, 254);
520. get_cvar_string("ps_rank_url", psrankurl, 254);
521. get_cvar_string("ps_admin_password", psadminpw, 63);
522. get_cvar_string("ps_uniqueid", psuniqueid, 15);
523. if (equal(psrankurl,"")) copy(psrankurl, 254, psurl);
524. }
525. // Load the users information
526. public _getuserinfo(id, authid[33], name[65], ipaddr[16], plrmatch[65]) {
527. #if defined DEBUG
528. copy(authid, 32, debug_authid);
529. copy(name, 32, debug_name);
530. copy(ipaddr, 15, debug_ipaddr);
531. #else
532. get_user_authid(id, authid, 32);
533. get_user_name(id, name, 32);
534. get_user_ip(id, ipaddr, 15, 1);  // 1 = do not include port
535. #endif
536. // Determine which field we want to match players on and store it in 'plrmatch'
537. if (equali(psuniqueid, "name")) {
538.   copy(plrmatch, 32, name);
539.   quote_sql(plrmatch,64);
540. }
541. else if (equali(psuniqueid, "ipaddr")) {
542.   copy(plrmatch, 15, ipaddr);
543. }
544. else {  // always default to 'worldid'
545.   copy(plrmatch, 33, authid);
546. }
547. }
548. // short-cut function for performing a mysql_query. Returns false on error.
549. #if defined AMXX_VERSION
550. public Result:_query(Sql:dbh, cmd[], id) {
551. new Result:result = dbi_query(dbh, cmd)
552. if (result == RESULT_FAILED) {
553.   new error[255];
554.   dbi_error(dbh, error, 254);
555.   console_print(id, "[PsychoStats] SQL error. Contact your admin: '%s'", error);
556.   server_print("[PsychoStats] SQL error: '%s' (%s,%s,%s)", error, pshost, psuser, psdb);
557. }
558. return result;
559. }
560. #else
561. public _query(dbh, cmd[], id) {
562. if (mysql_query(dbh, cmd) < 1) {
563.   new error[255];
564.   mysql_error(dbh, error, 254);
565.   console_print(id, "[PsychoStats] SQL error. Contact your admin: '%s'", error);
566.   server_print("[PsychoStats] SQL error: '%s' (%s,%s,%s)", error, pshost, psuser, psdb);
567.   return false;
568. }
569. return true;
570. }
571. #endif
572. // quotes the string given to be used safely in a mysql_query() call
573. quote_sql(string[],len) {
574. new charnum = 0;
575. while ( replace( string[charnum] ,len,"'","\'") != 0) {
576.   charnum += contain(string[charnum],"\'") + 2;
577. }
578. charnum = 0;
579. while ( replace( string[charnum] ,len,"`","\`") != 0) {
580.   charnum += contain(string[charnum],"\`") + 2;
581. }
582. }

复制代码

PS:该问题的出现也是由于系统Bug造成的，运行ps_password命令时PIP插件默认对pstats_plr表进行操作，但是该表根本没有password这一列
，有人将pstats_plr修改为pstats_plr_profile则会报找不到plrid这一列。这一问题即使是将Psychostats升级到最新版本也无法解决。
Stormtrooper的回复是他目前正忙于3.0的开发，没时间解决这个问题*_*||。以上代码已经修复该问题。

【小技巧】
有的朋友可能在安装theme时比较头疼，覆盖来覆盖去的总是显示有问题。其实只需要将下载的theme解压缩到PS安装目录下的themes文件夹下，然后运行install.pl -step web theme，在选择theme时就会多出一个选项（不只是psweb了）。如将psmod解压到themes文件夹下的psmod文件夹下，运行install.pl -step web theme时就会让你选择按装psweb还是psmod了。在重新安装theme后可能Q1还会出现，依法解决就可以了。


待续……

cfans

花了好长时间查找资料整理的，希望大家多多支持！

CS菜鸟鸟

看看先....................

gearfox

建议斑竹加精。。。。。

xiaolysh

支持原创！做个视频教程吧！

cfans

谢谢支持！
但是做完了放在哪啊？

xiaolysh

Post by cfans
谢谢支持！
但是做完了放在哪啊？

做好后，请联系我，空间你放心！

oouuyyaa

看看先,不错的东东!

INSUN

看看:D :sweet_kis

gearfox

如果需要空间的话，联系我也可以:)