05.02.2015, 19:44
Код:
C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1393) : error 035: argument type mismatch (argument 1) C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1394) : error 017: undefined symbol "mysql_store_result" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1395) : error 017: undefined symbol "mysql_num_rows" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1397) : error 017: undefined symbol "mysql_fetch_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1399) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1400) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1401) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1417) : error 017: undefined symbol "mysql_free_result" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1452) : error 035: argument type mismatch (argument 1) C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1453) : error 017: undefined symbol "mysql_store_result" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1454) : error 017: undefined symbol "mysql_fetch_row_format" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1456) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1457) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1458) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1459) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1460) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1461) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1463) : error 017: undefined symbol "mysql_free_result" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1474) : error 035: argument type mismatch (argument 1) C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1475) : error 017: undefined symbol "mysql_store_result" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1476) : error 017: undefined symbol "mysql_fetch_row_format" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1478) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1480) : error 017: undefined symbol "mysql_free_result" C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1492) : error 035: argument type mismatch (argument 1) C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(1496) : error 035: argument type mismatch (argument 1) C:\Users\The Doctor\Desktop\TESTER\gamemodes\COD-DW-v1.50.pwn(2594) : error 035: argument type mismatch (argument 1) Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 26 Errors.
Код:
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
while(mysql_fetch_row(query))
{
mysql_fetch_field_row(admin, "admin");
mysql_fetch_field_row(pname, "player");
mysql_fetch_field_row(string1, "reason");
}
new string[50], str[50], str1[100];
format(string, sizeof(string),"Admin: {FFFFFF}%s", admin);
format(str, sizeof(str),"Player: {FFFFFF}%s", pname);
format(str1, sizeof(str1),"Reason: {FFFFFF}%s", string1);
SendClientMessage(playerid, RED,"You are banned from this server!");
SendClientMessage(playerid, RED,"___________________");
SendClientMessage(playerid, RED, str);
SendClientMessage(playerid, RED, string);
SendClientMessage(playerid, RED, str1);
SendClientMessage(playerid, RED,"___________________");
SendClientMessage(playerid, RED, "If you think you this is a mistake please visit our website");
SendClientMessage(playerid, RED, "www.cod-samp.in"); //Change ME!
Kick(playerid);
}
mysql_free_result();
return 1;
}
CMD:stats(playerid,params[])
{
new id, string[1028];
sscanf(params, "u", id);
if (isnull(params))
{
format(string, sizeof(string), "_Statistics for '%s'_",PlayerName(playerid));
SendClientMessage(playerid, green, string);
format(string, sizeof(string), "Score: %d | Money: $%d | Kills: %d | Deaths: %d | Ratio: %0.2f ", GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], Float:PlayerInfo[playerid][pKills]/Float:PlayerInfo[playerid][pDeaths]);
SendClientMessage(playerid, yellow, string);
format(string, sizeof(string), "Team: %s | Rank: %s | Class: %s | Admin Level: %d | Helper: %d ", GetTeamName(playerid), GetRankName(playerid), GetClassName(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper]);
SendClientMessage(playerid, yellow, string);
}
else if(IsPlayerConnected(id))
{
format(string, sizeof(string), "_Statistics for '%s'_",PlayerName(id));
SendClientMessage(playerid, green, string);
format(string, sizeof(string), "Score: %d | Money: $%d | Kills: %d | Deaths: %d | Ratio: %0.2f ", GetPlayerScore(id), GetPlayerMoney(id), PlayerInfo[id][pKills], PlayerInfo[id][pDeaths], Float:PlayerInfo[id][pKills]/Float:PlayerInfo[id][pDeaths]);
SendClientMessage(playerid, yellow, string);
format(string, sizeof(string), "Team: %s | Rank: %s | Class: %s | Admin Level: %d | Helper: %d ", GetTeamName(id), GetRankName(id), GetClassName(id), PlayerInfo[id][pAdmin], PlayerInfo[id][pHelper]);
SendClientMessage(playerid, yellow, string);
}
else SendClientMessage(playerid,RED,"[ERROR]: Player is not connected");
return 1;
}
//===================Saving and login stocks====================================
stock MySQL_Login(playerid)
{
new query[300], pname[24], savingstring[20];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "scores"); SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); GivePlayerMoney(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "adminlevel"); PlayerInfo[playerid][pAdmin] = strval(savingstring);
mysql_fetch_field_row(savingstring, "helperlevel"); PlayerInfo[playerid][pHelper] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
}
mysql_free_result();
MySQL_vLogin(playerid); //vip log in
PlayerInfo[playerid][pLogged] = 1;
return 1;
}
stock MySQL_vLogin(playerid)
{
new query[300], pname[24], savingstring[20];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT * FROM vipdata WHERE player = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "viplevel"); PlayerInfo[playerid][pVIP] = strval(savingstring);
}
mysql_free_result();
return 1;
}
stock MySQL_Save(playerid)
{
if(PlayerInfo[playerid][pLogged] == 1)
{
if(PlayerInfo[playerid][pVIP] >= 1)
{
new query[200], viplevel = PlayerInfo[playerid][pVIP];
format(query, sizeof(query),"UPDATE `vipdata` SET `viplevel`='%d' WHERE `player`='%s'", viplevel, PlayerName(playerid));
mysql_query(query);
}
new query[200], scores = GetPlayerScore(playerid), money = GetPlayerMoney(playerid), level = PlayerInfo[playerid][pAdmin], helper = PlayerInfo[playerid][pHelper], kills = PlayerInfo[playerid][pKills], deaths = PlayerInfo[playerid][pDeaths];
format(query, sizeof(query),"UPDATE `playerdata` SET `scores`='%d', `kills`='%d' ,`deaths`='%d' ,`money`='%d' ,`adminlevel`='%d' , `helperlevel`='%d' WHERE `user`='%s'",scores, kills, deaths, money, level, helper, PlayerName(playerid));
mysql_query(query);
}
return 1;
}
