- 0
Problema Dialog
-
Similar Content
-
- 2 answers
- 374 views
-
Problema turf
By Soryn.,
- 3 answers
- 312 views
-
- 1 reply
- 187 views
-
- 9 replies
- 288 views
-
Problema
By ImJustSlim,
- 3 answers
- 289 views
-
-
Recently Browsing 0 members
- No registered users viewing this page.
Question
Maddo
Salut, m am inspirat de pe acest forum de la o problema, cineva pusese aceasta comanda intr-un reply, si am zis sa o incerc si eu, chiar mi s a parut interesant.
ce face comanda ? Simplu, e o comanda de tip /updates, doar ca este dinamica, poti creea un update direct din joc, doar ca trebuie niste salvari in baza de date, iar eu nu ma prea pricep cu baza de date, ma poate ajuta si pe mine cineva la inserarea in tabelul updates din baza de date ? Cum sa pun alea cu INT si etc, astea sunt comenzile
CMD:updates(playerid, params[])
{
new query[1000],versiune[128],updateid,vizionari,text[40][1000],rezultat[1000],query2[256],textafisare[2000],data[128], updateid2 = 0, updatetext[2000], updatedata[2000], updateversiune[2000];
mysql_format(SQL, query, sizeof(query), "SELECT * FROM `updates` WHERE `ID` > '0'");
new Cache: cache = mysql_query(SQL, query);
if(cache_get_row_count() < 1) return SCM(playerid, COLOR_GREY, "Nu exista updateuri adaugate in lista.");
for(new i, j = cache_get_row_count(); i != j; i++)
{
updateid = cache_get_field_content_int(i, "ID");
vizionari = cache_get_field_content_int(i, "Vizionari");
cache_get_field_content(i, "Versiune", rezultat); format(versiune, 128, rezultat);
cache_get_field_content(i, "Data", rezultat); format(data, 128, rezultat);
for(new a = 0; a < 40; a++)
{
format(query2, sizeof(query2), "Text%d",a);
cache_get_field_content(i, query2,rezultat); format(text[a], 1000, rezultat);
strcat(updatetext[a], text[a], 1000);
}
strcat(updatedata[updateid2], data, 128);
strcat(updateversiune[updateid2], versiune, 128);
updateid2++;
if(updateid == 1) format(textafisare, sizeof(textafisare), "{0066FF}ID\t{FFFFFF}Versiune\t{0066FF}Data\t{FFFFFF}Vizionari\n{FFFFFF}Update {0066FF}# %d\t{FFFFFF}%s\t{0066FF}%s{FFFFFF}\t%d",updateid, versiune,data, vizionari);
if(updateid > 1) format(textafisare, sizeof(textafisare), "%s\n{FFFFFF}Update {0066FF}# %d\t{FFFFFF}%s\t{0066FF}%s{FFFFFF}\t%d",textafisare,updateid,versiune,data, vizionari);
}
ShowPlayerDialog(playerid, DIALOG_UPDATES, DIALOG_STYLE_TABLIST_HEADERS, "SERVER: Updates", textafisare, "Seleteaza","Anuleaza");
cache_delete(cache);
return 1;
}
CMD:au(playerid, params[])
{
if(PlayerInfo[playerid][pAdmin] >= 7)
{
new versiune[128],data[128],query[1000];
if(sscanf(params, "s[128]", versiune)) return SCM(playerid, -1, "USAGE: /addupdate [nume versiune]");
new year, month,day;
getdate(year, month, day);
format(data, sizeof(data), "%02d.%02d.%d",day,month,year);
mysql_format(SQL, query, sizeof(query), "INSERT INTO `updates` (`Versiune`,`Data`) VALUES ('%s','%s')",versiune,data);
mysql_tquery(SQL, query, "", "");
SCM(playerid, -1, "{0066FF}UPDATE: {FFFFFF}Versiunea a fos adaugata cu succes.");
}
return 1;
}
CMD:aul(playerid, params[])
{
if(PlayerInfo[playerid][pAdmin] >= 7)
{
new versiune[512],query[1000],linie,id;
if(sscanf(params, "iis[128]", linie,id,versiune)) return SCM(playerid, -1, "USAGE: /addupdateline [linie (0-40)] [id] [descriere]");
mysql_format(SQL, query, sizeof(query), "UPDATE `updates` SET `Text%d`='%s' WHERE `ID`='%d'",linie,versiune,id);
mysql_tquery(SQL, query, "", "");
SCM(playerid, -1, "{0066FF}UPDATE: {FFFFFF}Linia a fos adaugata cu succes.");
}
return 1;
}
Link to comment
Share on other sites
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.