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. |
