[HELP]Gang system problem ......

[HELP]Gang system problem ...... - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [HELP]Gang system problem ...... (/showthread.php?tid=252513)

[HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

I've got a gang system for my server..............but the problem is this.....

C:\DOCUME~1\Vyom\MYDOCU~1\gang.pwn(181) : warning 215: expression has no effect
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

1 Warning.

The compiling is succesfull but when my server is on and type and gang commands like /gangs or something
the server closes it self and i get reconnecting to the server....and when i try to find the samp-server its has been itself closed...........guys plz help........and also give me some gang system if you guys got one.................

NOTE-Dont tell me to search it because i have searched and only got a on which is good.........if you want the script tell me.............

THANK YOU!!!!!

Re: [HELP]Gang system problem ...... - paulj - 01.05.2011

Show us some piece of code.. without a clue we cant help

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

Quote:

Originally Posted by paulj

Show us some piece of code.. without a clue we cant help

aahh here the whole script..........

Код:

//********************* [ Credits ] ******************************************//
/*

				Gang Script by Cameltoe
				        Version 1.1
				        
		I do not demand to keep the credits but it is appreciated.

*/
//******************** [ Includes ] ******************************************//
#include <a_samp>
#include <mysql>
#include <sscanf2>
#include <zcmd>

//******************** [ Forwards ] ******************************************//


//******************** [ Defines ] ******************************************//

// Script
#define GANG_VERSION "1.1"
#define mysql_init

// 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   "admin"
#define DB_DB   "gang"
#define DB_PASS   "admin"

#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];

//******************** [ Callbakcs ] *****************************************//

#if defined filsterscript

public OnFilterScriptInit()
{
	InitMysqlConnection();
    
	printf("_____________________________________");
	printf("|                                   |");
	printf("|           Gang FS v%s            |", GANG_VERSION);
	printf("|               By                  |");
	printf("|            Cameltoe               |");
	printf("_____________________________________");
	return 1;


#else

main()
{
	InitMysqlConnection();

	printf("_____________________________________");
	printf("|                                   |");
	printf("|           Gang FS v%s            |", GANG_VERSION);
	printf("|               By                  |");
	printf("|            Cameltoe               |");
	printf("_____________________________________");
	return 1;
}

#endif

public OnPlayerConnect(playerid)
{
	new Query[128];
    ResetPlayerInfo(playerid);
    
    if(CheckUser(playerid))
    {
        LoadPlayerInfo(playerid);
    }
    else
    {
    	format(Query, sizeof(Query), "INSERT INTO users (id, username, gang) VALUES (NULL, '%s', 0);", GetPlayerNameEx(playerid));
        mysql_query(Query);
    }
	return 1;
}

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)
{
	new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
	mysql_query(Query);
	mysql_store_result();
	if(mysql_num_rows()) return 1;
	return 0;
}

stock LoadPlayerInfo(playerid)
{
	new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
	mysql_query(Query);
	mysql_store_result();
	mysql_fetch_row(Query, "|");
	sscanf(Query, "p<|>e<is[25]i>", PlayerInfo[playerid]);
}

stock CheckGangByName(Name[])
{
	new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE name = '%s';", Name);
	mysql_query(Query);
	mysql_store_result();
	if(mysql_num_rows()) return 1;
	return 0;
}

stock CheckGangById(GangID)
{
	new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID;
	mysql_query(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(256);
    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(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;
}

Re: [HELP]Gang system problem ...... - G*Mafia - 01.05.2011

Shows us line 181

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

Quote:

Originally Posted by G*Mafia

Shows us line 181

i have given you the whole script ...............!!!!
plz help to fix it...........

Re: [HELP]Gang system problem ...... - Cameltoe - 01.05.2011

Quote:

Originally Posted by ronaldoraul

i have given you the whole script ...............!!!!
plz help to fix it...........

Looks like you failed to copy/paste my code or something

pawn Код:

//********************* [ Credits ] ******************************************//
/*

                Gang Script by Cameltoe
                        Version 1.1

        I do not demand to keep the credits but it is appreciated.

*/
//******************** [ Includes ] ******************************************//
#include <a_samp>
#include <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   "admin"
#define DB_DB   "gang"
#define DB_PASS   "admin"

#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];

//******************** [ Callbakcs ] *****************************************//

#if defined filsterscript

public OnFilterScriptInit()
{
    InitMysqlConnection();

    printf("_____________________________________");
    printf("|                                   |");
    printf("|           Gang FS v%s            |", GANG_VERSION);
    printf("|               By                  |");
    printf("|            Cameltoe               |");
    printf("_____________________________________");
    return 1;


#else

main()
{
    InitMysqlConnection();

    printf("_____________________________________");
    printf("|                                   |");
    printf("|           Gang FS v%s            |", GANG_VERSION);
    printf("|               By                  |");
    printf("|            Cameltoe               |");
    printf("_____________________________________");
    return 1;
}

#endif

public OnPlayerConnect(playerid)
{
    new Query[128];
    ResetPlayerInfo(playerid);

    if(CheckUser(playerid))
    {
        LoadPlayerInfo(playerid);
    }
    else
    {
        format(Query, sizeof(Query), "INSERT INTO users (id, username, gang) VALUES (NULL, '%s', 0);", GetPlayerNameEx(playerid));
        mysql_query(Query);
    }
    return 1;
}

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)
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock LoadPlayerInfo(playerid)
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row(Query, "|");
    sscanf(Query, "p<|>e<is[25]i>", PlayerInfo[playerid]);
}

stock CheckGangByName(Name[])
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE name = '%s';", Name);
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock CheckGangById(GangID)
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID;
    mysql_query(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(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;
}

Copy paste the whole thing, compile & enjoy!

E: Btw, you are not supposed to make an thread about problems regarding an fs. Post the problem at the fs thread.

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

Quote:

Originally Posted by Cameltoe

Looks like you failed to copy/paste my code or something

pawn Код:

//********************* [ Credits ] ******************************************//
/*

                Gang Script by Cameltoe
                        Version 1.1

        I do not demand to keep the credits but it is appreciated.

*/
//******************** [ Includes ] ******************************************//
#include <a_samp>
#include <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   "admin"
#define DB_DB   "gang"
#define DB_PASS   "admin"

#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];

//******************** [ Callbakcs ] *****************************************//

#if defined filsterscript

public OnFilterScriptInit()
{
    InitMysqlConnection();

    printf("_____________________________________");
    printf("|                                   |");
    printf("|           Gang FS v%s            |", GANG_VERSION);
    printf("|               By                  |");
    printf("|            Cameltoe               |");
    printf("_____________________________________");
    return 1;


#else

main()
{
    InitMysqlConnection();

    printf("_____________________________________");
    printf("|                                   |");
    printf("|           Gang FS v%s            |", GANG_VERSION);
    printf("|               By                  |");
    printf("|            Cameltoe               |");
    printf("_____________________________________");
    return 1;
}

#endif

public OnPlayerConnect(playerid)
{
    new Query[128];
    ResetPlayerInfo(playerid);

    if(CheckUser(playerid))
    {
        LoadPlayerInfo(playerid);
    }
    else
    {
        format(Query, sizeof(Query), "INSERT INTO users (id, username, gang) VALUES (NULL, '%s', 0);", GetPlayerNameEx(playerid));
        mysql_query(Query);
    }
    return 1;
}

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)
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock LoadPlayerInfo(playerid)
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row(Query, "|");
    sscanf(Query, "p<|>e<is[25]i>", PlayerInfo[playerid]);
}

stock CheckGangByName(Name[])
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE name = '%s';", Name);
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows()) return 1;
    return 0;
}

stock CheckGangById(GangID)
{
    new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID;
    mysql_query(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(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;
}

Copy paste the whole thing, compile & enjoy!

E: Btw, you are not supposed to make an thread about problems regarding an fs. Post the problem at the fs thread.

E:\vyom\My Pen Drive\GTA San Andreas\my new stunt server(upgraded)\filterscripts\gang.pwn(180) : error 017: undefined symbol "mysql_init"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase

1 Error.

again...........

Re: [HELP]Gang system problem ...... - Cameltoe - 01.05.2011

Quote:

Originally Posted by ronaldoraul

This fs were made within strickens mysql plugin. Download his include.

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

Quote:

Originally Posted by Cameltoe

I'm pretty sure you downloaded wrong mysql include. Here's the right anyhow.

it happend the same when type and gang cmd.......it crashed show the server is restarting and connection to.............help sir .........

Re: [HELP]Gang system problem ...... - Cameltoe - 01.05.2011

Quote:

Originally Posted by ronaldoraul

it happend the same when type and gang cmd.......it crashed show the server is restarting and connection to.............help sir .........

Did you set up the MySql DB properly?

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

Quote:

Originally Posted by Cameltoe

Did you set up the MySql DB properly?

noo...........can u help me in setting up ..plz plz..............

Re: [HELP]Gang system problem ...... - Cameltoe - 01.05.2011

Quote:

Originally Posted by ronaldoraul

noo...........can u help me in setting up ..plz plz..............

No, i will not. There's tutorials that show you how to.

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 01.05.2011

Quote:

Originally Posted by Cameltoe

No, i will not. There's tutorials that show you how to.

that was rude........

can u give me the link.....

Re: [HELP]Gang system problem ...... - Cameltoe - 01.05.2011

Quote:

Originally Posted by ronaldoraul

that was rude........

can u give me the link.....

Yeah, sure.. dude i'm rude, that's probably why i wrote this filterscript and relased it aswell.

Re: [HELP]Gang system problem ...... - ScopE iMarkx - 01.05.2011

Quote:

Originally Posted by Cameltoe

Yeah, sure.. dude i'm rude, that's probably why i wrote this filterscript and relased it aswell.

I would like to see that tutorial also, can you give me the link please? Thanks

Re: [HELP]Gang system problem ...... - Maftaca - 01.05.2011

Don't have any idea but the problem sometimes happines to me and then it gone !!

Re: [HELP]Gang system problem ...... - Cameltoe - 01.05.2011

Quote:

Originally Posted by ScopE iMarkx

I would like to see that tutorial also, can you give me the link please? Thanks

Xampp ( Apache + MySql + Php )
Xampp ( How to setup )
Mysql for beginners @ Sa-mp forum

...

Re: [HELP]Gang system problem ...... - ScopE iMarkx - 01.05.2011

Quote:

Originally Posted by Cameltoe

Xampp ( Apache + MySql + Php )
Xampp ( How to setup )
Mysql for beginners @ Sa-mp forum

...

Thank you very much!

Re: [HELP]Gang system problem ...... - Ronaldo_raul™ - 02.05.2011

Quote:

Originally Posted by Cameltoe

Xampp ( Apache + MySql + Php )
Xampp ( How to setup )
Mysql for beginners @ Sa-mp forum

...

thanks bro...........thank you very much i m sorry for that i tld you u so rude...........i was so frausteted..........

RESPECT