R6 Update R40 - Problem - Printable Version

R6 Update R40 - Problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: R6 Update R40 - Problem (/showthread.php?tid=652969)

R6 Update R40 - Problem - BrainDamaged - 23.04.2018

Hi,how should i update these functions for r40

Код:

Function;
mysql_fetch_field_row
mysql_free_result

Код:

#if defined EV_SQL
	public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
	{
  		print("===================================================================");
		printf("SQL Hatasi Olustu: %d", errorid);
		printf("%s", error);
		printf("Query: %s", query);
		print("===================================================================");
		return 1;
	}
#endif

Код:

if(cache_num_rows() > 0) {
	        new x, string[128], sutun[32];
   			while(cache_get_row_count()) {
			    mysql_fetch_field_row(string, "id"), x = strval(string);
				mysql_fetch_field_row(string, "sahip"), format(HouseInfo[x][ev_sahip], MAX_PLAYER_NAME, "%s", string);
				mysql_fetch_field_row(string, "isim"), format(HouseInfo[x][ev_isim], 32, "%s", string);
				mysql_fetch_field_row(string, "fiyat"), HouseInfo[x][ev_fiyat] = strval(string);
				mysql_fetch_field_row(string, "kilit"), HouseInfo[x][ev_kilit] = strval(string);
				mysql_fetch_field_row(string, "para"), HouseInfo[x][ev_para] = strval(string);
				mysql_fetch_field_row(string, "intid"), HouseInfo[x][ev_interior] = strval(string);
				mysql_fetch_field_row(string, "posinfo"), sscanf(string, "p<,>fff", HouseInfo[x][ev_x], HouseInfo[x][ev_y], HouseInfo[x][ev_z]);

Re: R6 Update R40 - Problem - BrainDamaged - 23.04.2018

First post problem is update.

Re: R6 Update R40 - Problem - Slawi - 25.04.2018

PHP код:



if(cache_num_rows() > 0) {
            new x, string[128], sutun[32];
               for new(i = 0; i < cache_num_rows(); i++) { //while(cache_get_row_count()) {
                cache_get_value_int(i, "id", x); //mysql_fetch_field_row(string, "id"), x = strval(string);
                cache_get_value(i, "sahip", HouseInfo[x][ev_sahip], MAX_PLAYER_NAME); //mysql_fetch_field_row(string, "sahip"), format(HouseInfo[x][ev_sahip], MAX_PLAYER_NAME, "%s", string);
                cache_get_value(i, "isim", HouseInfo[x][ev_isim], 32); //mysql_fetch_field_row(string, "isim"), format(HouseInfo[x][ev_isim], 32, "%s", string);
                cache_get_value_int(i, "fiyat", HouseInfo[x][ev_fiyat]); //mysql_fetch_field_row(string, "fiyat"), HouseInfo[x][ev_fiyat] = strval(string);
                cache_get_value_int(i, "kilit", HouseInfo[x][ev_kilit]); //mysql_fetch_field_row(string, "kilit"), HouseInfo[x][ev_kilit] = strval(string);
                cache_get_value_int(i, "para", HouseInfo[x][ev_para]); //mysql_fetch_field_row(string, "para"), HouseInfo[x][ev_para] = strval(string);
                cache_get_value_int(i, "intid", HouseInfo[x][ev_interior]);//mysql_fetch_field_row(string, "intid"), HouseInfo[x][ev_interior] = strval(string);
                cache_get_value(i, "posinfo", string, put here sizeof string), sscanf(string, "p<,>fff", HouseInfo[x][ev_x], HouseInfo[x][ev_y], HouseInfo[x][ev_z]); //mysql_fetch_field_row(string, "posinfo"), sscanf(string, "p<,>fff", HouseInfo[x][ev_x], HouseInfo[x][ev_y], HouseInfo[x][ev_z]);