All pastes #1657318 Raw Edit

MySQL in SA-MP

public c v1 · immutable
#1657318 ·published 2009-11-04 21:05 UTC
rendered paste body
	for(new a = 0; a < MAX_VEHICLES; a++) {	    new string[256];	    format(string, 256, "SELECT * FROM carros WHERE id = %d", a);	    mysql_query(string);	    if(mysql_num_rows() == 1) {	        new linha[1024];	        new dono[256];	        new gasolina;	        new Float:x, Float:y, Float:z, Float:angulo;	        new modelo;	        mysql_store_result();	        mysql_fetch_row(linha);	        mysql_fetch_field_row(dono, "dono");     	    format(string, 256, "SELECT 'gasolina' FROM carros WHERE id = %d", a);	    	mysql_query(string);	        gasolina = mysql_fetch_int();	        format(string, 256, "SELECT 'modelo' FROM carros WHERE id = %d", a);	    	mysql_query(string);	        modelo = mysql_fetch_int();	        format(string, 256, "SELECT 'p_x' FROM carros WHERE id = %d", a);	        mysql_query(string);	        mysql_fetch_float(x);	        format(string, 256, "SELECT 'p_y' FROM carros WHERE id = %d", a);	        mysql_query(string);	        mysql_fetch_float(y);	        format(string, 256, "SELECT 'p_y' FROM carros WHERE id = %d", a);	        mysql_query(string);	        mysql_fetch_float(y);	        format(string, 256, "SELECT 'z' FROM carros WHERE id = %d", a);	        mysql_query(string);	        mysql_fetch_float(z);	        format(string, 256, "SELECT 'angulo' FROM carros WHERE id = %d", a);	        mysql_query(string);	        mysql_fetch_float(angulo);	        //CarroD[a] = dono;	        //CarroG[a] = gasolina;	        //CarroM[a] = modelo;	        //Carro[a] = AddStaticVehicle(CarroM[a], x, y, z, angulo, 1, 1);		}	}