27.10.2014, 20:05
Esses dias fui atualizar o meu MYSQL Plugin e agora minha gang ta dando erro plzz ajude-me ate agora nao achei algo que me indique oq mudou pro novo mysql
Ta dando esses Erros
Bom se alguem tiver o site onde mostre oq mudou no MySql pliz informe que irei estudar mais
Код:
//******************** [ Includes ] ******************************************// #include <a_samp> #include <a_mysql> #include <sscanf2> #include <zcmd> //******************** [ Forwards ] ******************************************// //******************** [ Defines ] ******************************************// // Script #define GANG_VERSION "1.1" // Colors #define COLOR_RED 0xFF000000 #define COLOR_GREEN 0x00FF0000 #define COLOR_BLUE 0x0000FF00 #define COLOR_YELLOW 0xFFFF0000 // Mysql #define DB_HOST "localhost" #define DB_USER "nossoserver" #define DB_DB "serversamp" #define DB_PASS "enois" #define CREATE_DB_USERS \ "CREATE TABLE IF NOT EXISTS users (id INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,\ username VARCHAR(25) NOT NULL, gang INT(5) NOT NULL) ENGINE = MyISAM;" #define CREATE_DB_GANGS \ "CREATE TABLE IF NOT EXISTS gangs (id INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,\ name VARCHAR(100) NOT NULL, owner VARCHAR(25) NOT NULL) ENGINE = MyISAM;" // Dialogs #define DIALOG_GANG_INFO 1 //******************** [ Enums ] *********************************************// enum pInfo { Id, Username[25], Gang, } //******************** [ Symbols ] *******************************************// new PlayerInfo[MAX_PLAYERS][pInfo]; new Invite[MAX_PLAYERS]; new Query[128], Pipeline; //******************** [ Callbakcs ] *****************************************// #if defined filsterscript public OnFilterScriptInit() { mysql_log(LOG_DEBUG); Pipeline = mysql_connect(sz_Connection, sz_User, sz_DB, sz_Password); if(mysql_errno(Pipeline) != 0) print("Could not connect to database!"); return 1; #else main(){} #endif public OnPlayerConnect(playerid) { ResetPlayerInfo(playerid); if(CheckUser(playerid)) { LoadPlayerInfo(playerid); } else { mysql_format(Pipeline, Query, sizeof(Query), "INSERT INTO users (id, username, gang) VALUES (NULL, '%s', 0);", GetPlayerNameEx(playerid)); mysql_tquery(Pipeline, Query, "", ""); } return 1; } public OnPlayerText(playerid, text[]) { new string[128]; if(PlayerInfo[playerid][Gang]) format(string, sizeof(string), "[ %s ] %s ( %d ) : %s", GetGangName(PlayerInfo[playerid][Gang]), GetPlayerNameEx(playerid), playerid, text); else format(string, sizeof(string), "%s ( %d ) : %s", GetPlayerNameEx(playerid), playerid, text); return SendClientMessageToAll(GetPlayerColor(playerid), string); } public OnPlayerCommandText(playerid, cmdtext[]) { return 0; } public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { switch(dialogid) { case DIALOG_GANG_INFO: { ShowGangInfoForPlayer(listitem + 1, playerid); } } return 1; } //******************** [ Functions ] *****************************************// //******************** [ Stocks ] ********************************************// stock CheckUser(playerid) { mysql_format(Pipeline, Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid)); mysql_tquery(Pipeline, Query, "", ""); mysql_free_result(); if(mysql_num_rows()) return 1; return 0; } stock LoadPlayerInfo(playerid) { mysql_format(Pipeline, Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid)); mysql_tquery(Pipeline, Query, "", ""); mysql_store_result(); mysql_fetch_row(Query, "|"); sscanf(Query, "p<|>e<is[25]i>", PlayerInfo[playerid]); } stock CheckGangByName(Name[]) { mysql_format(Pipeline, Query, sizeof(Query), "SELECT * FROM gangs WHERE name = '%s';", Name); mysql_tquery(Pipeline, Query, "", ""); mysql_store_result(); if(mysql_num_rows()) return 1; return 0; } stock CheckGangById(GangID) { mysql_format(Pipeline, Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID; mysql_tquery(Pipeline, Query, "", ""); mysql_store_result(); if(mysql_num_rows()) return 1; return 0; } stock ResetPlayerInfo(playerid) { Invite[playerid] = 0; PlayerInfo[playerid][Gang] = 0; } stock InitMysqlConnection() { mysql_init(); mysql_connect(DB_HOST, DB_USER, DB_PASS, DB_DB); mysql_query(CREATE_DB_USERS); mysql_query(CREATE_DB_GANGS); } stock IsPlayerGangLeader(playerid) { new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d AND owner = '%s';", PlayerInfo[playerid][Gang], GetPlayerNameEx(playerid)); mysql_query(Query); mysql_store_result(); if(mysql_num_rows()) return 1; return 0; } stock IsMySelf(pID, oID) { if(pID == oID) return 1; return 0; } stock GetGangName(GangID) { new gName[100], Query[150]; format(Query, sizeof(Query), "SELECT name FROM gangs WHERE id = %d;", GangID); mysql_query(Query); mysql_store_result(); mysql_fetch_string(gName); return gName; } stock GetGangMemberCount(gID) { new Query[150]; format(Query, sizeof(Query), "SELECT * FROM users WHERE gang = %d;", gID); mysql_query(Query); mysql_store_result(); return mysql_num_rows(); } stock GetGangCount() { new Query[150]; format(Query, sizeof(Query), "SELECT * FROM gangs;"); mysql_query(Query); mysql_store_result(); return mysql_num_rows(); } stock ShowGangInfoForPlayer(GangID, pID) { new tGid, tGname[100], tGOwner[25], Query[150], string[200]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID); mysql_query(Query); mysql_store_result(); if(!mysql_num_rows()) return 0; mysql_fetch_row(Query, "|"); sscanf(Query, "p<|>is[100]s[25]", tGid, tGname, tGOwner); format(string, sizeof(string), "Id: %d - Name: %s - Owner: %s - Members: %d", tGid, tGname, tGOwner, GetGangMemberCount(GangID)); return ShowPlayerDialog(pID, DIALOG_GANG_INFO, DIALOG_STYLE_MSGBOX, "Cameltoe's Gang FS", string, "Cancel", ""); } stock GetPlayerNameEx(playerid) { new pName[25]; GetPlayerName(playerid, pName, 25); return pName; } stock strmatch(const String1[], const String2[]) { if ((strcmp(String1, String2, true, strlen(String2)) == 0) && (strlen(String2) == strlen(String1))) return true; else return false; } //******************** [ Commands ] ******************************************// command(g, playerid, params[]) { new string[128]; if(!PlayerInfo[playerid][Gang]) return SendClientMessage(playerid, COLOR_YELLOW, "You have to be member of an gang to use this command."); format(string, sizeof(string), "Gang : %s ( %d ) : %s", GetPlayerNameEx(playerid), playerid, params); for(new pID; pID < MAX_PLAYERS; pID++) { if(IsPlayerConnected(pID)) { SendClientMessage(pID, GetPlayerColor(playerid), string); } } return 1; } command(gangs, playerid, params[]) { new gID, tGid, tGname[100], tGOwner[25], Query[200], string[1000]; // Change this depending on how many gangs you have. if(sscanf(params, "u", gID)) { format(Query, sizeof(Query), "SELECT * FROM gangs"); mysql_query(Query); mysql_store_result(); while(mysql_fetch_row(Query, "|")) { if(!mysql_num_rows()) continue; sscanf(Query, "p<|>is[100]s[25]", tGid, tGname, tGOwner); format(string, sizeof(string), "%sId: %d - Name: %s - Owner: %s\r\n", string, tGid, tGname, tGOwner); } ShowPlayerDialog(playerid, DIALOG_GANG_INFO, DIALOG_STYLE_LIST, "Cameltoe's Gang FS", string, "Info", "Cancel"); } else { if(!ShowGangInfoForPlayer(gID, playerid)) SendClientMessage(playerid, COLOR_YELLOW, "Invalid gang id."); } return 1; } command(ganginfo, playerid, params[]) { new gID; if(sscanf(params, "i", gID)) return SendClientMessage(playerid, COLOR_YELLOW, "Usage: /ganginfo [ gangID ]"); if(!ShowGangInfoForPlayer(gID, playerid)) SendClientMessage(playerid, COLOR_YELLOW, "Invalid gang id."); return 1; } command(retreat, playerid, params[]) { new Query[100], string[128]; if(Invite[playerid] == 0 && PlayerInfo[playerid][Gang] == 0) return SendClientMessage(playerid, COLOR_YELLOW, "You are not an member of any gang."); format(string, sizeof(string), "You now left %s.", GetGangName(PlayerInfo[playerid][Gang])); SendClientMessage(playerid, COLOR_GREEN, string); format(string, sizeof(string), "%s [ %d ] left %s.", GetPlayerNameEx(playerid), playerid, GetGangName(PlayerInfo[playerid][Gang])); SendClientMessageToAll(COLOR_GREEN, string); if(IsPlayerGangLeader(playerid)) { format(Query, sizeof(Query), "DELETE FROM gangs WHERE owner = '%s';", GetPlayerNameEx(playerid)); mysql_query(Query); format(Query, sizeof(Query), "UPDATE users SET gang = 0 WHERE gang = %d;", PlayerInfo[playerid][Gang]); mysql_query(Query); } format(Query, sizeof(Query), "UPDATE users SET gang = 0 WHERE username = '%s';", GetPlayerNameEx(playerid)); PlayerInfo[playerid][Gang] = 0; mysql_query(Query); return 1; } command(deny, playerid, params[]) { new string[128]; if(PlayerInfo[playerid][Gang] != 0) return SendClientMessage(playerid, COLOR_YELLOW, "You are already in an gang."); if(Invite[playerid] == 0) return SendClientMessage(playerid, COLOR_YELLOW, "You have not received any gang invite."); format(string, sizeof(string), "You denyed the gang invite."); SendClientMessage(playerid, COLOR_GREEN, string); Invite[playerid] = 0; return 1; } command(accept, playerid, params[]) { new Query[100], string[128]; if(PlayerInfo[playerid][Gang] != 0) return SendClientMessage(playerid, COLOR_YELLOW, "You are already in an gang."); if(Invite[playerid] == 0) return SendClientMessage(playerid, COLOR_YELLOW, "You have not received any gang invite."); format(Query, sizeof(Query), "UPDATE users SET gang = %d WHERE username = '%s';", Invite[playerid], GetPlayerNameEx(playerid)); format(string, sizeof(string), "You are now an member of %s, type /retreat to leave the gang.", GetGangName(Invite[playerid])); SendClientMessage(playerid, COLOR_GREEN, string); format(string, sizeof(string), "%s [ %d ] is now an member of %s!", GetPlayerNameEx(playerid), playerid, GetGangName(Invite[playerid])); SendClientMessageToAll(COLOR_GREEN, string); PlayerInfo[playerid][Gang] = Invite[playerid]; Invite[playerid] = 0; mysql_query(Query); return 1; } command(invite, playerid, params[]) { new pID, string[128]; if(!IsPlayerGangLeader(playerid)) return SendClientMessage(playerid, COLOR_YELLOW, "You have to be gang leader to use this comamnd."); if(sscanf(params, "u", pID)) return SendClientMessage(playerid, COLOR_YELLOW, "Usage: /invite [ Playerid / Name ]"); if(!IsPlayerConnected(pID)) return SendClientMessage(playerid, COLOR_YELLOW, "This player isn't connected."); if(IsMySelf(playerid, pID)) return SendClientMessage(playerid, COLOR_YELLOW, "You cannot invite yourself."); if(PlayerInfo[pID][Gang] != 0) return SendClientMessage(playerid, COLOR_YELLOW, "This player is already in an gang."); if(Invite[pID] != 0 && Invite[pID] != PlayerInfo[playerid][Gang]) return SendClientMessage(playerid, COLOR_YELLOW, "This player is already invited by an other gang, please wait for the player to reject the invitation"); if(Invite[pID] == PlayerInfo[playerid][Gang]) return SendClientMessage(playerid, COLOR_YELLOW, "You have already invited this player please stand by for input."); format(string, sizeof(string), "You were invited to join %s, type /accept or /deny .. W/e you feel like.", GetGangName(PlayerInfo[playerid][Gang])); SendClientMessage(pID, COLOR_GREEN, string); format(string, sizeof(string), "You invited %s to join your gang, please wait for the player to accept the invite.", GetPlayerNameEx(pID)); SendClientMessage(playerid, COLOR_GREEN, string); Invite[pID] = PlayerInfo[playerid][Gang]; return 1; } command(kick, playerid, params[]) { new pID, string[128], Query[100]; if(!IsPlayerGangLeader(playerid)) return SendClientMessage(playerid, COLOR_YELLOW, "You have to be gang leader to use this comamnd."); if(sscanf(params, "u", pID)) return SendClientMessage(playerid, COLOR_YELLOW, "Usage: /kick [ Playerid / Name ]"); if(!IsPlayerConnected(pID)) return SendClientMessage(playerid, COLOR_YELLOW, "This player isn't connected."); if(IsMySelf(playerid, pID)) return SendClientMessage(playerid, COLOR_YELLOW, "You cannot kick yourself."); if(PlayerInfo[pID][Gang] != PlayerInfo[playerid][Gang]) return SendClientMessage(playerid, COLOR_YELLOW, "This player isn't an member of your gang."); format(Query, sizeof(Query), "UPDATE users SET gang = 0 WHERE username = '%s';", GetPlayerNameEx(pID)); format(string, sizeof(string), "You were kicked out of the gang."); SendClientMessage(pID, COLOR_GREEN, string); format(string, sizeof(string), "%s [ %d ] were kicked out of %s.", GetPlayerNameEx(pID), pID, GetGangName(PlayerInfo[playerid][Gang])); SendClientMessageToAll(COLOR_GREEN, string); format(string, sizeof(string), "You kicked %s [ %d ] from your gang, if this was an mistake please reinvite the player with /invite.", GetPlayerNameEx(pID), pID); SendClientMessage(playerid, COLOR_GREEN, string); PlayerInfo[pID][Gang] = 0; mysql_query(Query); return 1; } command(creategang, playerid, params[]) { new string[128], gName[100], Query[200]; if(PlayerInfo[playerid][Gang] != 0) return SendClientMessage(playerid, COLOR_YELLOW, "You are already an member of an gang, please quit that gang before creating a new one."); if(sscanf(params, "s[100]", gName)) return SendClientMessage(playerid, COLOR_YELLOW, "Usage: /creategang [ Gang-name ]."); if(CheckGangByName(gName)) return SendClientMessage(playerid, COLOR_YELLOW, "An gang with this name already exists."); format(Query, sizeof(Query), "INSERT INTO gangs (id, name, owner) VALUES (NULL, '%s', '%s');", gName, GetPlayerNameEx(playerid)); format(string, sizeof(string), "You created an gang with name : %s, you were sat as owner of the gang.", gName); SendClientMessage(playerid, COLOR_GREEN, string); mysql_query(Query); PlayerInfo[playerid][Gang] = mysql_insert_id(); format(Query, sizeof(Query), "UPDATE users SET gang = %d WHERE username = '%s';", PlayerInfo[playerid][Gang], GetPlayerNameEx(playerid)); mysql_query(Query); return 1; }
Quote:
|
C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(126) : error 017: undefined symbol "mysql_free_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(127) : error 017: undefined symbol "mysql_num_rows" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(135) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(136) : error 017: undefined symbol "mysql_fetch_row" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(144) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(145) : error 017: undefined symbol "mysql_num_rows" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(174) : warning 219: local variable "Query" shadows a variable at a preceding level C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(175) : error 035: argument type mismatch (argument 1) C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(176) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(177) : error 017: undefined symbol "mysql_num_rows" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(189) : warning 219: local variable "Query" shadows a variable at a preceding level C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(190) : error 035: argument type mismatch (argument 1) C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(191) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(192) : error 017: undefined symbol "mysql_fetch_string" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(19  : warning 219: local variable "Query" shadows a variable at a preceding levelC:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(199) : error 035: argument type mismatch (argument 1) C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(200) : warning 217: loose indentation C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(200) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(201) : error 017: undefined symbol "mysql_num_rows" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(214) : warning 219: local variable "Query" shadows a variable at a preceding level C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(216) : error 035: argument type mismatch (argument 1) C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(217) : warning 217: loose indentation C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(217) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(21 : error 017: undefined symbol "mysql_num_rows"C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(219) : error 017: undefined symbol "mysql_fetch_row" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(256) : warning 219: local variable "Query" shadows a variable at a preceding level C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(260) : error 035: argument type mismatch (argument 1) C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(261) : warning 217: loose indentation C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(261) : error 017: undefined symbol "mysql_store_result" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(262) : error 017: undefined symbol "mysql_fetch_row" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(264) : error 017: undefined symbol "mysql_num_rows" C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(287) : warning 219: local variable "Query" shadows a variable at a preceding level C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(289) : warning 217: loose indentation C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(293) : warning 217: loose indentation C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(296) : warning 217: loose indentation C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(296) : error 035: argument type mismatch (argument 1) C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(29 : error 035: argument type mismatch (argument 1)C:\Users\pcserver\Desktop\Servidor Samp\gamemodes\gangs.pwn(302) : error 035: argument type mismatch (argument 1) Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 26 Errors. |
