new ClanString[ 3000 ];
    strcat( ClanString, "CREATE TABLE IF NOT EXISTS `gangs`", 3000);
    strcat( ClanString, "(`id` INT PRIMARY KEY,\
						  `name` TEXT, \
						  `owner` TEXT, \
						  `members` NUMERIC, \
						  `SpawnX` FLOAT, \
						  `SpawnY` FlOAT, \
						  `SpawnZ` FLOAT, \
						  `SpawnA` FLOAT, \
						  `Skin` NUMERIC, \
						  `BossSkin` NUMERIC, \
						  `Weap1` NUMERIC, \
						  `Weap2` NUMERIC, \
						  `Weap3` NUMERIC,", 3000);
	strcat( ClanString, "`Weap4 NUMERIC, \
						 `Weap5` NUMERIC, \
						 `Weap6` NUMERIC, \
						 `Kills` NUMERIC, \
						 `Deaths` NUMERIC, \
						 `Color` NUMERIC);", 3000);
db:Query( gDB, ClanString );

strcat( ClanString, "`Weap4 NUMERIC, \

new ClanString[ 1024 ];
	strcat( ClanString, "CREATE TABLE IF NOT EXISTS `gangs`", 1024 );
	strcat( ClanString, "(id INT PRIMARY KEY, name varchar(50), owner varchar(50), members INT, SpawnX FLOAT, SpawnY FlOAT, SpawnZ FLOAT, SpawnA FLOAT", 1024 );
	strcat( ClanString, "Skin int DEFAULT 0, BossSkin INT DEFAULT 0, Weap1 INT DEFAULT 0, Weap2 INT DEFAULT 0, Weap3 INT DEFAULT 0,Weap4 INT DEFAULT 0,Weap5 INT DEFAULT 0,Weap6 INT DEFAULT 0, Kills INT DEFAULT 0, Deaths INT DEFAULT 0, Color INT DEFAULT 0);");
	db:Query( gDB, ClanString );
	db:Query("CREATE TABLE IF NOT EXISTS `players`(id INT PRIMARY KEY, name varchar(50), gang varchar(50), rank INT DEFAULT 0, kills INT DEFAULT 0, deaths INT DEFAULT 0);");

if ( dialogid == Dialog_CreateGang )
	{
	    if ( !response ) return 1;
	    if ( sscanf( inputtext, "s[128]", inputtext[ 0 ] ) ) return ShowPlayerDialog( playerid, Dialog_CreateGang, 1, "Create an clan", "{FFFFFF}So you want to create a clan?\n\nWrite below the name of your clan:", "Next", "Exit" );
	    new DBResult:R;
		register( playerid );
		R = db:Query(xFM("SELECT `owner` FROM `gangs` WHERE `name`='%s'", inputtext[ 0 ] ) );
		if ( db:num_rows( R ) )
		{
			db_get_field_assoc( R, "owner", str, sizeof( str ) );
			format( str, sizeof( str ), "ERROR: Sorry, but that name is already token by {00FF00}%s", str );
			SendClientMessage( playerid, 0xFF0000FF, str );
			db:free_result( R );
		}
		else
		{
			format( str, sizeof( str ), "You successeful created your clan, with name: {00FF00}%s", inputtext[ 0 ] );
			SendClientMessage( playerid, 0xFFFF00FF, str );
			db:free_result( R );
			new Float:X,Float:Y,Float:Z,Float:A;
			GetPlayerPos( playerid, X, Y, Z );
			GetPlayerFacingAngle( playerid, A );
			gang[ playerid ][ spawnX ] = X;
			gang[ playerid ][ spawnY ] = Y;
			gang[ playerid ][ spawnZ ] = Z;
			gang[ playerid ][ spawnA ] = A;
			R=db:Query("SELECT * FROM `gangs`");
			new id = db:num_rows( R )+1;
			db:free_result( R );
			db:Query(xFM("INSERT INTO `gangs`(id,name,owner,members,SpawnX,SpawnY,SpawnZ,SpawnA)VALUES(%d,'%s','%s','1','%.3f','%.3f','%.3f','%.3f');", id, inputtext[ 0 ], name, X, Y, Z, A ) );

			R = db:Query(xFM("SELECT * FROM `gangs` WHERE `name`='%s'", inputtext[ 0 ] ) );

			db_get_field_assoc( R, "id", str, sizeof( str ) );

			gang[ playerid ][ ID ] = strval( str );
			gang[ playerid ][ rank ] = 5;
			SendClientMessage( playerid, 0xFF0000FF, xFM("ID:%d",gang[ playerid ][ ID ] ) );
			db:free_result( R );
			db:Query(xFM("UPDATE `players` SET `gang`='%s',`rank`='5' WHERE `name`='%s'", inputtext[ 0 ], name ) );
			SetPVarInt( playerid, "CreatingGang", 1 );
			cmd_clancolor( playerid, "" );
		}
	}