[Ajuda] Mysql ERRO * INICIANTE * - 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] Mysql ERRO * INICIANTE * (/showthread.php?tid=596444)
+- 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] Mysql ERRO * INICIANTE * (/showthread.php?tid=596444)
Mysql ERRO * INICIANTE * - VinnyScript - 18.12.2015
pq os tais erros sendo q esta tudo correto, forme o tutorial ?
Quote:
|
C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(41) : error 017: undefined symbol "mysql_store_result" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(43) : error 017: undefined symbol "mysql_num_rows" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(49) : error 017: undefined symbol "mysql_free_result" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(77) : error 017: undefined symbol "mysql_store_result" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(8  : error 017: undefined symbol "mysql_store_result"C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(90) : error 017: undefined symbol "mysql_num_rows" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(100) : error 017: undefined symbol "mysql_num_rows" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(104) : error 017: undefined symbol "mysql_free_result" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(12 : error 017: undefined symbol "mysql_store_result"C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(130) : error 017: undefined symbol "mysql_fetch_row_format" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(131) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(132) : error 017: undefined symbol "mysql_fetch_field_row" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(134) : error 017: undefined symbol "mysql_free_result" |
Re: Mysql ERRO * INICIANTE * - zPain - 18.12.2015
Й provбvel que vocк tenha se baseado em um tutorial para uma versгo mais antiga do plugin. Se nгo me engano, essas funзхes pertencem аs versхes anteriores а R7.
Re: Mysql ERRO * INICIANTE * - VinnyScript - 18.12.2015
Erros continao ;--; wtf
Код:
C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(41) : error 017: undefined symbol "mysql_query" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(77) : error 017: undefined symbol "mysql_query" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(88) : error 017: undefined symbol "mysql_query" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(119) : error 017: undefined symbol "mysql_query" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(127) : error 017: undefined symbol "mysql_query" C:\Users\Vinicius\Desktop\samp037_svr_R2-1-1_win32\gamemodes\GM.pwn(30) : warning 204: symbol is assigned a value that is never used: "mysql"
Re: Mysql ERRO * INICIANTE * - arakuta - 18.12.2015
Vamos lб, primeiro utilize a versгo mais recente do plugin. Atualmente й a R39-4.
O link do tуpico oficial й este: https://sampforum.blast.hk/showthread.php?tid=56564
A partir da versгo R7, o plugin trabalha com cache. Isso significa que vocк vai buscar os ъltimos dados fornecidos pelo banco de dados. Dessa forma, seu script fica livre para fazer outras tarefas atй que o servidor MySQL faзa as consultas, atй dizer pra vocк que ele terminou e que agora tem os dados.
Supondo que temos uma tabela de jogadores, vamos solicitar o ID ъnico do mesmo:
PHP код:
mysql_function_query(handle,"SELECT id FROM players WHERE name='Arakuta'",true,"Response_GetPlayerID","d",playerid);
Bom, o MySQL fez o que tinha que fazer e tem os dados.
PHP код:
forward Response_GetPlayerID(playerid);
PHP код:
public Response_GetPlayerID(playerid)
{
new rows, fields;
cache_get_data(rows,fields);
if(rows)
{
// foi encontrado o que procuramos
new pID = cache_get_row_int(0,0); // Pega o primeiro campo da primeira linha encontrada
printf("O ID ъnico de Arakuta й %d",pID);
}
return 1;
}
Espero ter ajudado
