[Ajuda] Fixar comando dar DP on/off MYSQL - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] Fixar comando dar DP on/off MYSQL (/showthread.php?tid=594296)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] Fixar comando dar DP on/off MYSQL (/showthread.php?tid=594296)
Fixar comando dar DP on/off MYSQL - warriorfrog - 15.11.2015
Tentei fazer o comando de dar DP online/offline com MYSQL, seguindo alguns tуpicos aqui do fуrum, mas nгo consegui, alguйm me ajuda a fixar?
Erros nos comentarios (//)
Код:
CMD:givedp(playerid, params[]) {
new player[MAX_PLAYER_NAME], quantidade, string[128];
if(sscanf(params,"si", player, quantidade)) return SendClientMessage(playerid, -1, "Use: /givedp [player-name] [ammount]");
new idplayer;
idplayer = GetPlayerIdFromName(player);
if(idplayer >= 0) {
idplayer = GetPlayerIdFromName(player);
DP[idplayer] += quantidade;
format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (ONLINE)", PlayerName(playerid), quantidade, PlayerName(idplayer) );
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
SendClientMessage(idplayer, COLOR_LIGHTBLUE, string);
}
else {
new rows, fields;
cache_get_data(rows, fields);
if (!rows) return SendClientMessage(playerid, -1, "Nгo hб nenhum player com esse nome.");
new query[200], dpatual;
format(query, sizeof(query), "SELECT * FROM accounts WHERE Username='%s'", player);
mysql_query(ConnectMYSQL,query);
mysql_store_result(); // error 017: undefined symbol "mysql_store_result"
while(mysql_fetch_row_format(query,"|")) // error 017: undefined symbol "mysql_fetch_row_format"
{
dpatual = cache_get_field_content_int(0, "DP");
}
mysql_free_result(); // error 017: undefined symbol "mysql_store_result"
format(query, sizeof(query), "UPDATE accounts SET DP=%d WHERE Username='%s'",
dpatual + quantidade,
player);
mysql_query(ConnectMYSQL,query);
format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (OFFLINE)", PlayerName(playerid), quantidade, player );
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
SendClientMessage(idplayer, COLOR_LIGHTBLUE, string);
}
return 1;
}
Re: Fixar comando dar DP on/off MYSQL - warriorfrog - 16.11.2015
Alguйm por favor poderia me ajudar?
Re: Fixar comando dar DP on/off MYSQL - warriorfrog - 17.11.2015
alguйm sabe?
Re: Fixar comando dar DP on/off MYSQL - warriorfrog - 18.11.2015
Olб pessoal? Os erros estгo sу aqui
Код:
mysql_store_result(); // error 017: undefined symbol "mysql_store_result"
while(mysql_fetch_row_format(query,"|")) // error 017: undefined symbol "mysql_fetch_row_format"
{
dpatual = cache_get_field_content_int(0, "DP");
}
mysql_free_result(); // error 017: undefined symbol "mysql_store_result"
Re: Fixar comando dar DP on/off MYSQL - warriorfrog - 19.11.2015
alguйm?
Re: Fixar comando dar DP on/off MYSQL - warriorfrog - 27.11.2015
alguйm?
Re: Fixar comando dar DP on/off MYSQL - Danzou - 27.11.2015
https://sampforum.blast.hk/showthread.php?tid=56564
Re: Fixar comando dar DP on/off MYSQL - n0minal - 27.11.2015
Tб tudo errado amigo, usando funзхes da R5 na R7/R33+
Re: Fixar comando dar DP on/off MYSQL - cicinho - 27.11.2015
Olб warriorfrog, aqui estб o comando funcional:
Код:
CMD:givedp(playerid, params[])
{
new Nameid[25], valor,string[128],query[160],idplayer;
if(sscanf(params,"s[25]i", Nameid, valor))
return SendClientMessage(playerid, -1, "Use: /givedp [player-name] [ammount]");
idplayer = GetPlayerIdFromName(Nameid);
if(IsPlayerConnected(idplayer))
{
DP[idplayer] += valor;
format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (ONLINE)", PlayerName(playerid), valor, PlayerName(idplayer));
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
SendClientMessage(idplayer, COLOR_LIGHTBLUE, string);
}else{
mysql_format(ConnectMYSQL, query, sizeof query, "SELECT `Username`, `DP` FROM accounts WHERE Username = '%e' LIMIT 1", Nameid);
mysql_tquery(ConnectMYSQL, query, "AddDP", "isi", playerid, Nameid, valor);
}
return true;
}
forward AddDP(playerid, Nameid[], valor);
public AddDP(playerid, Nameid[], valor)
{
new query[200], string[128];
if(cache_get_row_count(ConnectMYSQL) == 1)
{
dpatual = cache_get_field_content_int(0, "DP");
mysql_format(ConnectMYSQL, query, sizeof query, "UPDATE accounts SET DP = '%d' WHERE Username = '%s'", dpatual+valor, Nameid);
mysql_tquery(ConnectMYSQL, query, "", "");
format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (OFFLINE)", PlayerName(playerid), valor, Nameid);
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
}
else
SendClientMessage(playerid, -1, "Nгo hб nenhum player com esse nome.");
return true;
}
Re: Fixar comando dar DP on/off MYSQL - warriorfrog - 29.11.2015
Quote:
|
Originally Posted by cicinho
 Olб warriorfrog, aqui estб o comando funcional:
Код:
CMD:givedp(playerid, params[])
{
new Nameid[25], valor,string[128],query[160],idplayer;
if(sscanf(params,"s[25]i", Nameid, valor))
return SendClientMessage(playerid, -1, "Use: /givedp [player-name] [ammount]");
idplayer = GetPlayerIdFromName(Nameid);
if(IsPlayerConnected(idplayer))
{
DP[idplayer] += valor;
format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (ONLINE)", PlayerName(playerid), valor, PlayerName(idplayer));
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
SendClientMessage(idplayer, COLOR_LIGHTBLUE, string);
}else{
mysql_format(ConnectMYSQL, query, sizeof query, "SELECT `Username`, `DP` FROM accounts WHERE Username = '%e' LIMIT 1", Nameid);
mysql_tquery(ConnectMYSQL, query, "AddDP", "isi", playerid, Nameid, valor);
}
return true;
}
forward AddDP(playerid, Nameid[], valor);
public AddDP(playerid, Nameid[], valor)
{
new query[200], string[128];
if(cache_get_row_count(ConnectMYSQL) == 1)
{
dpatual = cache_get_field_content_int(0, "DP");
mysql_format(ConnectMYSQL, query, sizeof query, "UPDATE accounts SET DP = '%d' WHERE Username = '%s'", dpatual+valor, Nameid);
mysql_tquery(ConnectMYSQL, query, "", "");
format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (OFFLINE)", PlayerName(playerid), valor, Nameid);
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
}
else
SendClientMessage(playerid, -1, "Nгo hб nenhum player com esse nome.");
return true;
}
|