基本的数据统计

lovehuai · 发表于 2010-8-20 01:22:50

#include <amxmodx>
#include <cstrike>
#include <amxmisc>
#include <csx>
#include <dbi>
#include <acfun> // 如果你要用就删掉这个
#define Lp_MAX 33
new Set_Money[4] = {0,5500,3300,1100}; // 前三杀敌奖励
new Lp_Kill[Lp_MAX],Lp_Death[Lp_MAX],Lp_Tk[Lp_MAX],Lp_Shot[Lp_MAX],Lp_Hit[Lp_MAX],Lp_Damage[Lp_MAX]; // 杀敌,死亡,Tk,开枪,命中,伤害
new Lp_Head[Lp_MAX],Lp_vHead[Lp_MAX],Lp_OneK[Lp_MAX],Lp_OneD[Lp_MAX],Lp_FK[Lp_MAX],Lp_FD[Lp_MAX]; // 爆头,被爆头,最先杀敌,最先死亡,最后杀敌,最后死亡
new Lp_Time[Lp_MAX],Lp_Round[Lp_MAX],Lp_TE[Lp_MAX],Lp_CT[Lp_MAX],Lp_SP[Lp_MAX]; // 在线时间,游戏回合,匪徒回合,警察回合,观战回合
new Lp_Planted[Lp_MAX],Lp_Explode[Lp_MAX],Lp_Defusing[Lp_MAX],Lp_Defused[Lp_MAX],Lp_DefusBad[Lp_MAX]; // 安装C4,爆破C4,拆除C4,拆除成功,拆除失败
new Kill_Count,Death_Count,Kill_ID,Death_ID; // 杀敌计数,死亡计数,杀敌ID,死亡ID
new g_host[Lp_MAX], g_user[Lp_MAX], g_pass[Lp_MAX], g_dbname[Lp_MAX], g_error[Lp_MAX],amx_sql_stats[Lp_MAX],Sql:g_dbc,Result:g_result
new User_Mid[Lp_MAX]; // 玩家Mid[UserId]
public plugin_init()
{
register_plugin("MySql数据统计", "1.3.7", "小坏/root@lovehuai.cn");
register_event("SendAudio", "Event_Round_End", "a", "2&%!MRAD_terwin", "2&%!MRAD_ctwin", "2&%!MRAD_rounddraw"); // 回合结束
register_event("TextMsg", "Event_Round_Restart", "a", "2&#Game_C", "2&#Game_w") // 服务器刷新事件
register_logevent("Event_Round_Start", 2, "1=Round_Start"); // 回合开始 ggystudio说不要用HLTV事件于是乎咱的插件就都换这个了 - -!
register_event("ResetHUD", "Event_User_ResetHUD", "be", "1=0", "2=0"); // 玩家HUD刷新
// register_logevent("Event_Round_End", 2, "1=Round_End"); // 回合结束
// register_logevent("Event_Round_Restart", 2, "1&Restart_Round_"); // 服务器刷新事件
register_cvar("stats_sql_host", "127.0.0.1");
register_cvar("stats_sql_user", "root");
register_cvar("stats_sql_pass", "love");
register_cvar("stats_sql_db", "amx");
register_cvar("stats_sql_table", "dwstats");
new configsDir[64];
get_configsdir(configsDir, 63);
server_cmd("exec %s/stats_sql.cfg", configsDir);
server_exec();
return PLUGIN_CONTINUE;
}
public plugin_cfg()
{
get_cvar_string("stats_sql_host",g_host,Lp_MAX);
get_cvar_string("stats_sql_user",g_user,Lp_MAX);
get_cvar_string("stats_sql_pass",g_pass,Lp_MAX);
get_cvar_string("stats_sql_db",g_dbname,Lp_MAX);
get_cvar_string("stats_sql_table", amx_sql_stats, Lp_MAX);
return PLUGIN_CONTINUE
}
public Event_User_ResetHUD(id) // 玩家HUD刷新
{
Lp_Round[id]++; // 玩家回合数
switch(cs_get_user_team(id)) // 团队数
{
case CS_TEAM_T:{Lp_TE[id]++;}
case CS_TEAM_CT:{Lp_CT[id]++;}
case CS_TEAM_SPECTATOR:{Lp_SP[id]++;}
}
return PLUGIN_CONTINUE;
}
public Event_Round_Start() // 回合开始
{
Lp_FK[Kill_ID]++; // 最后杀敌这里感觉有点不妥可能会引起数据乱X
Lp_FD[Death_ID]++; // 最后死亡
ResetID(); // 复位杀敌/死亡计数等
return PLUGIN_CONTINUE;
}
public Event_Round_End() // 回合结束因为没有找到好用的攻击次数统计所以暂用 get_user_rstats 来获取攻击次数
{
new Temp_Stats[8];
for(new i=1; i<=get_playersnum(0);i++)
{
if(get_user_rstats(i,Temp_Stats,"") && (User_Mid[i] > 0)){
Lp_Shot[i] += Temp_Stats[4];
Save_User_Stats(i);
}
}
return PLUGIN_CONTINUE;
}
public Event_Round_Restart() // 服务器刷新事件
{
ResetID(); // 服务器刷新强制复位
return PLUGIN_CONTINUE;
}
public client_connect(id) // 玩家接入
{
User_Mid[id] = 0;
Reset_User_Stats(id);
return PLUGIN_CONTINUE;
}
public client_putinserver(id) // 玩家进入到游戏
{
Get_User_StatS3(id)
return PLUGIN_CONTINUE;
}
public client_disconnect(id) // 玩家断开连接
{
new Temp_Stats[8];
if(get_user_rstats(id,Temp_Stats,"") && (User_Mid[id] > 0)){
Lp_Shot[id] += Temp_Stats[4];
Save_User_Stats(id);
}
reset_user_wstats(id); // 删掉
return PLUGIN_CONTINUE;
}
public client_damage(attacker,victim,damage,wpnindex,hitplace,TK) // 玩家受到伤害
{
if(!TK && attacker != victim){
Lp_Hit[attacker]++; // 命中
Lp_Damage[attacker] += damage; // 伤害
}
return PLUGIN_CONTINUE;
}
public client_death(Killer,Victim,wpnindex,hitplace,TK) // 玩家死亡事件
{
Lp_Death[Victim]++; // 死亡
Lp_Kill[Killer]++; // 杀敌
if(TK) {
Lp_Tk[Killer]++;
} else if(Killer != Victim){
Kill_Count++;
Death_Count++
Kill_ID = Killer;
Death_ID = Victim;
if(Kill_Count == 1){ Lp_OneK[Killer]++; Lp_OneD[Victim]++;} // 更新玩家最先杀敌最先第一死亡
if(hitplace==1){ // 如果死亡时是被击中头部更新玩家爆头/被爆头
Lp_Head[Killer]++;
Lp_vHead[Victim]++;
}
if (Kill_Count < 4) { // 前三杀敌奖励
cs_set_user_money(Killer,cs_get_user_money(Killer)+Set_Money[Kill_Count]);
new Name[32];
get_user_name(Killer,Name,32);
client_print(0,print_chat,"%s 第%i杀敌! 获得$:%i 奖励",Name,Kill_Count,Set_Money[Kill_Count]);
}
}
return PLUGIN_CONTINUE;
}
public bomb_planted(id) // 安放C4
{
Lp_Planted[id]++;
return PLUGIN_CONTINUE;
}
public bomb_explode(id,defuser) // C4爆炸
{
Lp_Explode[id]++;
return PLUGIN_CONTINUE;
}
public bomb_defusing(id) // 尝试C4中
{
Lp_Defusing[id]++;
return PLUGIN_CONTINUE;
}
public bomb_defused(id) // C4拆除成功
{
Lp_Defused[id]++;
return PLUGIN_CONTINUE;
}
public ResetID() // 最新杀敌/死亡杀敌/死亡ID复位[冲0]
{
Kill_Count = 0;
Death_Count = 0;
Kill_ID = 0;
Death_ID = 0;
}
public Get_User_StatS3(id)
{
User_Mid[id] = acfun_get_user_mid(id);
/*
我整合了DeDe Cms的网站管理系统这里是我在admin_sql 里register_native
这个返回的是玩家在网站管理系统里的注册序号如果你要用可以把它改为get_user_name 或者ip 或者info之类的
切记要把数据库mid字段改为varchar 长度32 我这里用的是int 长度10 如果你不改
直接往里写会杯具的
*/
new name[33];
get_user_name(id,name,32);
if(User_Mid[id] != 0)
{
g_dbc = dbi_connect(g_host,g_user,g_pass,g_dbname,g_error,Lp_MAX);
if (g_dbc == SQL_FAILED)
{
log_amx("数据库连接失败");
} else {
g_result = dbi_query(g_dbc,"SELECT * FROM `%s` WHERE mid = '%i'",amx_sql_stats,User_Mid[id]);
while (dbi_nextrow(g_result) > 0 )
{
Lp_Kill[id] = dbi_result(g_result,"Kill");
Lp_Death[id] = dbi_result(g_result,"Death");
Lp_Tk[id] = dbi_result(g_result,"Tk");
Lp_Shot[id] = dbi_result(g_result,"Shot");
Lp_Hit[id] = dbi_result(g_result,"Hit");
Lp_Damage[id] = dbi_result(g_result,"Damage");
Lp_Head[id] = dbi_result(g_result,"Head");
Lp_vHead[id] = dbi_result(g_result,"vHead");
Lp_OneK[id] = dbi_result(g_result,"OneK");
Lp_OneD[id] = dbi_result(g_result,"OneD");
Lp_FK[id] = dbi_result(g_result,"FK");
Lp_FD[id] = dbi_result(g_result,"FD");
Lp_Time[id] = dbi_result(g_result,"Time");
Lp_Round[id] = dbi_result(g_result,"Round");
Lp_TE[id] = dbi_result(g_result,"TE");
Lp_CT[id] = dbi_result(g_result,"CT");
Lp_SP[id] = dbi_result(g_result,"SP");
Lp_Planted[id] = dbi_result(g_result,"Planted");
Lp_Explode[id] = dbi_result(g_result,"Explode");
Lp_Defusing[id] = dbi_result(g_result,"Defusing");
Lp_Defused[id] = dbi_result(g_result,"Defused");
Lp_DefusBad[id] = dbi_result(g_result,"DefusBad");
}
dbi_free_result(g_result);
dbi_close(g_dbc);
}
}
}
public Save_User_Stats(id)
{
g_dbc = dbi_connect(g_host,g_user,g_pass,g_dbname,g_error,Lp_MAX);
if (g_dbc == SQL_FAILED)
{
log_amx("数据库连接失败");
} else {
dbi_query(g_dbc,"INSERT INTO `%s` (`mid`) VALUES ('%i');",amx_sql_stats,User_Mid[id]);
dbi_query(g_dbc,"set names 'utf8'");
new Sql_Text[641];
new name[33];
get_user_name(id,name,32);
Lp_Time[id] += get_user_time(id);
new len = format(Sql_Text,640,"UPDATE `%s` SET `name` = '%s',`date` = '%i',`Kill` = '%i',`Death` = '%i',`Tk` = '%i',`Shot` = '%i',`Hit` = '%i',`Damage` = '%i',`Head` = '%i',`vHead` = '%i',`OneK` = '%i',`OneD` = '%i',`FK` = '%i',",
amx_sql_stats,name,get_systime(),Lp_Kill[id],Lp_Death[id],Lp_Tk[id],Lp_Shot[id],Lp_Hit[id],Lp_Damage[id],Lp_Head[id],Lp_vHead[id],Lp_OneK[id],Lp_OneD[id],Lp_FK[id]);
len += format(Sql_Text[len],640-len,"`FD` = '%i',`Time` = '%i',`Round` = '%i',`TE` = '%i',`CT` = '%i',`SP` = '%i',`Planted` = '%i',`Explode` = '%i',`Defusing` = '%i',`Defused` = '%i',`DefusBad` = '%i' WHERE `mid` ='%i';",
Lp_FD[id],Lp_Time[id],Lp_Round[id],Lp_TE[id],Lp_CT[id],Lp_SP[id],Lp_Planted[id],Lp_Explode[id],Lp_Defusing[id],Lp_Defused[id],Lp_DefusBad[id],User_Mid[id]);
dbi_query(g_dbc,"%s",Sql_Text);
dbi_close(g_dbc);
}
}
public Reset_User_Stats(id)
{
Lp_Kill[id] = 0;
Lp_Death[id] = 0;
Lp_Tk[id] = 0;
Lp_Shot[id] = 0;
Lp_Hit[id] = 0;
Lp_Damage[id] = 0;
Lp_Head[id] = 0;
Lp_vHead[id] = 0;
Lp_OneK[id] = 0;
Lp_OneD[id] = 0;
Lp_FK[id] = 0;
Lp_FD[id] = 0;
Lp_Time[id] = 0;
Lp_Round[id] = 0;
Lp_TE[id] = 0;
Lp_CT[id] = 0;
Lp_SP[id] = 0;
Lp_Planted[id] = 0;
Lp_Explode[id] = 0;
Lp_Defusing[id] = 0;
Lp_Defused[id] = 0;
Lp_DefusBad[id] = 0;
}

复制代码

assu · 发表于 2010-8-21 21:13:31

沙发:victory:

20061234 · 发表于 2010-8-21 22:07:40

LZ 教我架中文ID注册

yangxi2008 · 发表于 2010-8-22 16:26:54

这东西不错啊

bin*010 · 发表于 2010-8-23 00:26:56

嘻嘻,收下,拿回去研究

laoklaole · 发表于 2010-10-11 16:42:35

看都晕人

20576526 · 发表于 2010-10-17 22:24:52

编辑不成功，唉

rfyttyytr4557 · 发表于 2010-10-20 00:17:17

提示: 作者被禁止或删除内容自动屏蔽

homework · 发表于 2010-11-5 12:18:19

楼主的东西很有内涵！！

laoklaole · 发表于 2011-5-20 14:52:40

错误代码。。。。

rfyttyytr4557 rfyttyytr4557 当前离线积分 1 IP卡狗仔卡	发表于 2010-10-20 00:17:17 \| 显示全部楼层来自中国–浙江–金华–永康市提示: 作者被禁止或删除内容自动屏蔽
rfyttyytr4557 rfyttyytr4557 当前离线积分 1 IP卡狗仔卡
	回复使用道具举报显身卡

基本的数据统计

本帖子中包含更多资源