Comanda /status

[BaDB0y95]

Am si eu o probelma cu comanda /status ar trebui sa imi modifice statusul in opened si closed si nu imi modifica nimic, o sa las mai joc comanda si din mysql ce ar trebui sa afecteze ca randuri

 

Ce trebuie sa mai modific in comanda sa o fac sa mearga ca nu ii pot da de cap deloc sa imi dea voie sa pun doar 0 si 1

 

1 Opened

2 Closed

 

CMD:status(playerid, params [])
{
    if(pInfo[playerid][pRank] < 6 || pInfo[playerid][pMember] == 13) return SendClientMessage(playerid, COLOR_DARKGRAY, "You not have minimum rank 6.");
    new motd[90];
    if(sscanf(params, "s[90]", motd)) return SendClientMessage(playerid, 0x8EC7DCFF, "Syntax: {FFFFFF}/status [MOTD Text]");
    if(strlen(motd) > 89) return SendClientMessage(playerid, COLOR_DARKGRAY, "Maximum characters allowed for faction MOTD is 90.");
    if(!IsValidMOTD(motd)) return SendClientMessage(playerid, COLOR_DARKGRAY, "Invalid characters, valid characters are: A-Z, a-z, 0-9, (. , : ! ?).");
    mysql_tquery(MySQLCon, "SELECT option_value FROM `inf_options` WHERE `option_name`='factionAppStatus1' OR `option_name`='factionAppStatus2' OR `option_name`='factionAppStatus3' OR `option_name`='factionAppStatus4'OR `option_name`='factionAppStatus5'OR `option_name`='factionAppStatus6'OR `option_name`='factionAppStatus7'OR `option_name`='factionAppStatus8'OR `option_name`='factionAppStatus9'OR `option_name`='factionAppStatus10'OR `option_name`='factionAppStatus11'OR `option_name`='factionAppStatus12'OR `option_name`='factionAppStatus14'OR `option_name`='factionAppStatus15'OR `option_name`='factionAppStatus16'OR `option_name`='factionAppStatus17'OR `option_name`='factionAppStatus18'OR `option_name`='factionAppStatus19'", "OnFUP", "");
    format(stringf[pInfo[playerid][pMember]-1], 100, "Faction MOTD: {FFFFFF}%s", motd), SendClientMessage(playerid, 0xA9C4E4FF, stringf[pInfo[playerid][pMember]-1]);
    return 1;
}

 

					92	factionAppStatus1	1	2020-05-25 12:40:38	0000-00-00 00:00:00
					93	factionAppStatus2	1	2020-01-31 22:41:49	0000-00-00 00:00:00
					94	factionAppStatus3	1	2020-05-22 15:49:47	0000-00-00 00:00:00
					95	factionAppStatus4	1	2020-05-26 00:51:33	0000-00-00 00:00:00
					96	factionAppStatus5	1	2020-04-05 21:13:44	0000-00-00 00:00:00
					97	factionAppStatus6	1	2021-05-29 01:47:35	0000-00-00 00:00:00
					98	factionAppStatus7	1	2020-05-11 14:12:23	0000-00-00 00:00:00
					99	factionAppStatus8	1	2020-05-24 20:35:12	0000-00-00 00:00:00
					100	factionAppStatus9	1	2020-04-17 22:49:34	0000-00-00 00:00:00
					101	factionAppStatus10	1	2020-04-26 22:42:48	0000-00-00 00:00:00
					102	factionAppStatus11	1	2020-01-31 22:42:21	0000-00-00 00:00:00
					103	factionAppStatus12	1	2020-02-17 13:33:41	0000-00-00 00:00:00
					104	factionAppStatus14	1	2020-04-24 12:58:32	0000-00-00 00:00:00
					105	factionAppStatus15	1	2020-04-06 19:37:50	0000-00-00 00:00:00
					106	factionAppStatus16	1	2021-05-29 01:47:10	0000-00-00 00:00:00
					107	factionAppStatus17	1	2020-05-08 01:08:20	0000-00-00 00:00:00
					108	factionAppStatus18	1	2020-04-03 21:06:53	0000-00-00 00:00:00
					109	factionAppStatus19	1	2021-05-29 01:47:00	0000-00-00 00:00:00

 

 

Edited June 27, 2021 by BaDB0y95

[VAurel]

Putin mai multe informatii? de exemplu, ce se intampla cand folosesti comanda? Ce iti apare pe chat si etc.

[BaDB0y95]

Comanda asta trebuie sa modifice statusul aplicatilor adica la comanda /leaders apare opened sau closed daca factiunea recruteaza sau nu, cand o folosesc se modifica motd in joc ar trebuie sa imi afecteaza acele randuri si sa pot pune 0 sau 1 nu sa scriu litere

[S0NNIX]

1 oră în urmă, BaDB0y95 a spus:

Comanda asta trebuie sa modifice statusul aplicatilor adica la comanda /leaders apare opened sau closed daca factiunea recruteaza sau nu, cand o folosesc se modifica motd in joc ar trebuie sa imi afecteaza acele randuri si sa pot pune 0 sau 1 nu sa scriu litere

Cred ca te referi la comanda /factions, nu la /leaders. Iar din ce vad eu acolo, comanda aia iti modifica MOTD-ul factiunii, nu si statusul ei, adica daca aplicatiile sunt deschise sau inchise. Faction MOTD-ul este un mesaj care le apare membrilor factiunii.

Si de ce ai face o selectie din baza de date cand trebuie sa actualizezi ceva in baza de date?

Pentru statusul aplicatiilor factiunii, cel mai probabil ai o alta comanda sau poti sa faci tu una, in cazul in care nu exista deja o comanda facuta special in acel sens.

[BaDB0y95]

Cand tastez comanda /leaders imi apare daca sunt aplicatiile deschise sau nu si le pot modifica doar din baza de date unde am pus mai sus as face o comanda dar nu inteleg cum sa o fac sa afecteze fiecare rand