My Stats 4.4b:结合discuz论坛,附上视频教程

3252533

67# mwy5ym


出现大问题了大问题````郁闷，测试了两天 居然出现 VIP玩家和OP玩家全部权限都没有用了！！！


还 真不知道是不是我服务器的问题还是 安装之后出现这个问题-`- ！！！



权限设置得非常正常，可到游戏一个权限都没有

3252533

我安装的步骤都按照你的说明 安装，也就是说 我数据库名和你的一样 和程序也一样

3252533

中文ID 额 我发布给你吧！！我用的是插件和破解DLL！！

mwy5ym

中文ID 额 我发布给你吧！！我用的是插件和破解DLL！！
3252533 发表于 2010-10-25 22:01

你的这个swds.dll我这边用不了，用了无法建立服务器。顺便说下，我的CS是3266版的
你看看是不是你那边有什么插件冲突了，
中文ID应该是可以用的，有好几个人帮我测试过了(顺便表示一下感谢)。

huajunlady

达人！ 先顶再试

Cs.K

:(搞了半天，没装成功，不知道哪里搞错了，用的是最新的4.1G版本，建议用PHP的
打开页面显示

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e37'

[MySQL][ODBC 5.1 Driver][mysqld-5.1.51-community-nt]Table 'cstrike.client' doesn't exist

/cs/stats.asp，行 110

Cs.K

ms_error.log 日志内容
L 10/26/2010 - 01:23:14: [MS4.1g] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `roundstats`(`Md5`) values('5a4db4e450fabf97a5975bd3a69b71e9')' at line 1]:[insert into `bombstats`(`Md5`) values('5a4db4e450fabf97a5975bd3a69b71e9');insert into `roundstats`(`Md5`) values('5a4db4e450fabf97a5975bd3a69b71e9');]
L 10/26/2010 - 01:23:14: [MS4.1g] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOn' at line 1]:[set names 'utf8';insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOnlineDateTime`) values('ICS|PEPSI.K','5a4db4e450fabf97a5975bd3a69b71e9','116.20.149.244',now(),now());]

cuikejie

我用的是4.1g的
我的stats页面显示是800a0bcd错误。
/mystats/stats.asp 行 112

top显示页面正常。
进入游戏三人称截图


logo文件如下

1. 
   
2. L 10/26/2010 - 01:57:12: Log file started (file "cstrike\addons\amxmodx\logs\ms_error.log") (game "cstrike") (amx "1.76c")
   
3. L 10/26/2010 - 01:57:12: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOn' at line 1]:[set names 'utf8';insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOnlineDateTime`) values('sRx|a jie !','674074faf7c22e39d37c46a1d94837ae','115.61.117.146',now(),now());]
   
4. L 10/26/2010 - 01:57:12: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `roundstats`(`Md5`) values('674074faf7c22e39d37c46a1d94837ae')' at line 1]:[insert into `bombstats`(`Md5`) values('674074faf7c22e39d37c46a1d94837ae');insert into `roundstats`(`Md5`) values('674074faf7c22e39d37c46a1d94837ae');]
   
5. L 10/26/2010 - 01:57:22: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `roundstats`(`Md5`) values('a5260048c9285c9110aab36731e2c950')' at line 1]:[insert into `bombstats`(`Md5`) values('a5260048c9285c9110aab36731e2c950');insert into `roundstats`(`Md5`) values('a5260048c9285c9110aab36731e2c950');]
   
6. L 10/26/2010 - 01:57:22: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOn' at line 1]:[set names 'utf8';insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOnlineDateTime`) values('sRx|低调的阿杰<管理>','a5260048c9285c9110aab36731e2c950','115.61.117.146',now(),now());]
   
7. L 10/26/2010 - 01:58:34: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOn' at line 1]:[set names 'utf8';insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOnlineDateTime`) values('sRx|a jie !','674074faf7c22e39d37c46a1d94837ae','115.61.117.146',now(),now());]
   
8. L 10/26/2010 - 01:58:34: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `roundstats`(`Md5`) values('674074faf7c22e39d37c46a1d94837ae')' at line 1]:[insert into `bombstats`(`Md5`) values('674074faf7c22e39d37c46a1d94837ae');insert into `roundstats`(`Md5`) values('674074faf7c22e39d37c46a1d94837ae');]
   
9. L 10/26/2010 - 01:58:34: [MS4.1g+] Error[1062][Duplicate entry '674074faf7c22e39d37c46a1d94837ae-1' for key 1]:[insert into `weaponstats`(`Md5`,`WeaponID`) values ('674074faf7c22e39d37c46a1d94837ae',1),('674074faf7c22e39d37c46a1d94837ae',3),('674074faf7c22e39d37c46a1d94837ae',4),('674074faf7c22e39d37c46a1d94837ae',5),('674074faf7c22e39d37c46a1d94837ae',6),('674074faf7c22e39d37c46a1d94837ae',7),('674074faf7c22e39d37c46a1d94837ae',8),('674074faf7c22e39d37c46a1d94837ae',9),('674074faf7c22e39d37c46a1d94837ae',10),('674074faf7c22e39d37c46a1d94837ae',11),('674074faf7c22e39d37c46a1d94837ae',12),('674074faf7c22e39d37c46a1d94837ae',13),('674074faf7c22e39d37c46a1d94837ae',14),('674074faf7c22e39d37c46a1d94837ae',15),('674074faf7c22e39d37c46a1d94837ae',16),('674074faf7c22e39d37c46a1d94837ae',17),('674074faf7c22e39d37c46a1d94837ae',18),('674074faf7c22e39d37c46a1d94837ae',19),('674074faf7c22e39d37c46a1d94837ae',20),('674074faf7c22e39d37c46a1d94837ae',21),('674074faf7c22e39d37c46a1d94837ae',22),('674074faf7c22e39d37c46a1d94837ae',23),('674074faf7c22e39d37c46a1d94837ae',24),('674074faf7c22e39d37c46a1d94837ae',25),('674074faf7c22e39d37c46a1d94837ae',26),('674074faf7c22e39d37c46a1d94837ae',27),('674074faf7c22e39d37c46a1d94837ae',28),('674074faf7c22e39d37c46a1d94837ae',29),('674074faf7c22e39d37c46a1d94837ae',30);]
   
10. L 10/26/2010 - 01:58:35: [MS4.1g+] Error[1062][Duplicate entry '674074faf7c22e39d37c46a1d94837ae-1' for key 1]:[insert into `bodypartstats`(`Md5`,`WeaponID`) values ('674074faf7c22e39d37c46a1d94837ae',1),('674074faf7c22e39d37c46a1d94837ae',3),('674074faf7c22e39d37c46a1d94837ae',4),('674074faf7c22e39d37c46a1d94837ae',5),('674074faf7c22e39d37c46a1d94837ae',6),('674074faf7c22e39d37c46a1d94837ae',7),('674074faf7c22e39d37c46a1d94837ae',8),('674074faf7c22e39d37c46a1d94837ae',9),('674074faf7c22e39d37c46a1d94837ae',10),('674074faf7c22e39d37c46a1d94837ae',11),('674074faf7c22e39d37c46a1d94837ae',12),('674074faf7c22e39d37c46a1d94837ae',13),('674074faf7c22e39d37c46a1d94837ae',14),('674074faf7c22e39d37c46a1d94837ae',15),('674074faf7c22e39d37c46a1d94837ae',16),('674074faf7c22e39d37c46a1d94837ae',17),('674074faf7c22e39d37c46a1d94837ae',18),('674074faf7c22e39d37c46a1d94837ae',19),('674074faf7c22e39d37c46a1d94837ae',20),('674074faf7c22e39d37c46a1d94837ae',21),('674074faf7c22e39d37c46a1d94837ae',22),('674074faf7c22e39d37c46a1d94837ae',23),('674074faf7c22e39d37c46a1d94837ae',24),('674074faf7c22e39d37c46a1d94837ae',25),('674074faf7c22e39d37c46a1d94837ae',26),('674074faf7c22e39d37c46a1d94837ae',27),('674074faf7c22e39d37c46a1d94837ae',28),('674074faf7c22e39d37c46a1d94837ae',29),('674074faf7c22e39d37c46a1d94837ae',30);]
    
11. L 10/26/2010 - 01:58:42: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOn' at line 1]:[set names 'utf8';insert into `client`(`NickName`,`Md5`,`LastIPAddress`,`RegisterDateTime`,`LastOnlineDateTime`) values('sRx|低调的阿杰<管理>','a5260048c9285c9110aab36731e2c950','115.61.117.146',now(),now());]
    
12. L 10/26/2010 - 01:58:43: [MS4.1g+] Error[1064][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `roundstats`(`Md5`) values('a5260048c9285c9110aab36731e2c950')' at line 1]:[insert into `bombstats`(`Md5`) values
    

复制代码

=======================

最后有可能得希望楼主可以在mystats.cfg中增加可定义的命令。因为大多玩家都习惯了/top15 ,
/rank  /rankstats 等

Cs.K

楼上的截图是语言文件没放到好
【MyStats.txt】请放到addons/amxmodx/data/lang目录下

Cs.K

还有一个小问题说下，设置数据保存的最低玩家数要求,为了防止刷分ms_min_count "6"
服务器进2人的时候提示最低要求2人，进到3个的时候一样是最低要求3人，以此类推提示。
[MS]当前在线人数2人未达到2人服务器最低要求2人为防止刷分,数据同步未开启!
[MS]当前在线人数3人未达到3人服务器最低要求3人为防止刷分,数据同步未开启!