Sqlite

[Mihaela]

Buna seara la toti , am o problema cu database...nu stiu din ce cauza nu citeste numele gangului...a respectivului player...

stock IsPlayerGangMember(playerid, gang_name[])
{
	new player_name[MAX_PLAYER_NAME], GQuery[100];
	GetPlayerName(playerid,player_name,sizeof(player_name));
	format(GQuery, sizeof(GQuery), "SELECT `gangname` FROM `gmembers` WHERE `playername` = '%s' AND `gangname` = '%s'", player_name, gang_name);
 	Result = db_query( Database, GQuery );
	new rows = db_num_rows( Result );
	db_free_result(Result);
	if(!rows) return 0;
	else return ( 1 );
}

Iar la comanda...

CMD:og(playerid, params[])
{
	if(IsPlayerGangMember(playerid, "Test"))
	{
	    if(IsPlayerInRangeOfPoint(playerid, 20, -1987.9939, -1000.6446, 34.1694))
	    {
		    MoveObject(ptest,-1987.9939, -1000.6446, 26.4083,2.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
		else if(IsPlayerInRangeOfPoint(playerid, 20, -1986.7006, -739.3145, 32.6947))
		{
		    MoveObject(ptest2,-1986.7006, -739.3145, 26.5725,2.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
		else return SendClientMessage(playerid,red, "You are not near you'r gate!");
	}
	else return SendClientMessage(playerid,red,"ERROR: You are not in this gang!");
}

cand dau /og imi spune "You are not in this gang!" cu toate ca am acel gang creeat...si cu numele Test m-am uitat in database , gang-ul este creeat...gmembers , gangs la fel...merge totu perfect doar ca nu "citeste" dc?

[Джо]

Mai ai altceva legat de acest gang?

Doar la acest gang iti face probleme sau doar acesta l-ai creat?

[Mihaela]

am 3 ganguri ... la fiecare comanda (og,cg,blowgate,repairgate) dar nu merge comanda decat la al 2-lea gang .. (adica cel din mijloc) si nu stiu dece... si am toate asa...

if(.....

else if(....

else if(...

CMD:og(playerid, params[])
{
	if(IsPlayerGangMember(playerid, "Test"))
	{
	    if(IsPlayerInRangeOfPoint(playerid, 20, -1987.9939, -1000.6446, 34.1694))
	    {
		    MoveObject(pstaff,-1987.9939, -1000.6446, 26.4083,2.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
		else if(IsPlayerInRangeOfPoint(playerid, 20, -1986.7006, -739.3145, 32.6947))
		{
		    MoveObject(pstaff2,-1986.7006, -739.3145, 26.5725,2.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
	}
	else if(IsPlayerGangMember(playerid, "Gang"))
	{
	    if(IsPlayerInRangeOfPoint(playerid, 20,1446.4800, 663.3500, 13.2300))
		{
		    MoveObject(pthug,1446.4800, 663.3500, 5.0630,2.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
		else if(IsPlayerInRangeOfPoint(playerid, 20,1379.8400, 769.4716, 10.9618))
		{
            MoveObject(pthug2,1379.8400, 769.4716, 5.3137,2.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
	}
	else if(IsPlayerGangMember(playerid, "Pro"))
	{
	    if(IsPlayerInRangeOfPoint(playerid, 30,1014.9017, -2549.5063, 1.8635))
		{
		    MoveObject(ptest,1014.8335, -2567.0544, 9.4962,4.5);
		    MoveObject(ptest2,1014.8761, -2558.3257, 9.4962,4.5);
		    MoveObject(ptest3,1014.9017, -2549.5063, 9.4962,4.5);
		    MoveObject(ptest4,1014.8791, -2540.6987, 9.4962,4.5);
		    MoveObject(ptest5,1014.8402, -2531.8809, 9.4962,4.5);
		    GameTextForPlayer(playerid, "~n~~r~Gate is~n~~y~Opening", 3000, 3);
		    return 1;
		}
	}
	else return SendClientMessage(playerid,red,"ERROR: You don't have gang!");
	return ( 1 );
}

Test , Gang , Pro sunt numele de la ganguri...

[Джо]

Nu se salveaza gang-urile,ai stockplayerstats?

[Mihaela]

am spus ca se creeaza merge totu perfect DOAR CA NU CITESTE DACA PLAYERU ESTE IN RESPECTIVU GANG CITESTE DOAR DIN GANGU CU NUMELE "gang" ATAT nu stiu dece

[Джо]

Intra in folderul cu server>>scriptfilles>>users>>Intrii intr-un user dorit>>vezi daca scrie ceva de gangs=0 sau 1,2 sau respectiv 3.Daca nu anunta aici,trebuie sa faci si ceva din gamemode.

[Mihaela]

:| inteleg ca tu folosesti dini dar eu sunt pe sqlite scrie si la numele postului :| si app...uite merge perfect   restu doar ca la comenzi nu stiu ce are

http://postimg.org/image/q09cxi33h/

http://postimg.org/image/6jzt6rew3/

http://postimg.org/image/q0583dfav/