SA-MP Forums Archive
(AYUDA) Transformar algo a 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: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: (AYUDA) Transformar algo a MYSQL (/showthread.php?tid=385643)



(AYUDA) Transformar algo a MYSQL - digman - 16.10.2012

Bueno necesito transformar a mysql esto:

Код:
public LoadCar()
{
	new arrCoords[34][64], strFromFile2[256];
	new File: file = fopen("cars.cfg", io_read);
	if (file)
	{
	    printf("-========= Coches en venta =======-");
		new idx = VV;
		while (idx < sizeof(CarInfo))
		{
			fread(file, strFromFile2);
			split(strFromFile2, arrCoords, ',');
			CarInfo[idx][cModel] 		= strval(arrCoords[0]);
			CarInfo[idx][cLocationx] 	= floatstr(arrCoords[1]);
			CarInfo[idx][cLocationy] 	= floatstr(arrCoords[2]);
			CarInfo[idx][cLocationz] 	= floatstr(arrCoords[3]);
			CarInfo[idx][cAngle] 		= floatstr(arrCoords[4]);
			CarInfo[idx][cColorOne] 	= strval(arrCoords[5]);
			CarInfo[idx][cColorTwo] 	= strval(arrCoords[6]);
			strmid(CarInfo[idx][cOwner], arrCoords[7], 0, strlen(arrCoords[7]), 255);
			strmid(CarInfo[idx][cName], arrCoords[8], 0, strlen(arrCoords[8]), 255);
			CarInfo[idx][cValue] 		= strval(arrCoords[9]);
			CarInfo[idx][cOwned] 		= strval(arrCoords[10]);
			CarInfo[idx][cLock] 		= strval(arrCoords[11]);
			CarInfo[idx][cBattery] 		= strval(arrCoords[12]);
			CarInfo[idx][cSpoiler] 		= strval(arrCoords[13]);
			CarInfo[idx][cHood] 		= strval(arrCoords[14]);
			CarInfo[idx][cRoof] 		= strval(arrCoords[15]);
			CarInfo[idx][cSideskirt] 	= strval(arrCoords[16]);
			CarInfo[idx][cNitro] 		= strval(arrCoords[17]);
			CarInfo[idx][cLamps] 		= strval(arrCoords[18]);
			CarInfo[idx][cExhaust] 		= strval(arrCoords[19]);
			CarInfo[idx][cWheel] 		= strval(arrCoords[20]);
			CarInfo[idx][cHydraulics] 	= strval(arrCoords[21]);
			CarInfo[idx][cPaintjob] 	= strval(arrCoords[22]);
			CarInfo[idx][cFrontBumper] 	= strval(arrCoords[23]);
			CarInfo[idx][cRearBumper] 	= strval(arrCoords[24]);
			CarInfo[idx][cVents] 		= strval(arrCoords[25]);
			CarInfo[idx][cEmbargo] 		= strval(arrCoords[26]);
			CarInfo[idx][cMulta] 		= strval(arrCoords[27]);
			strmid(CarInfo[idx][cPlate], arrCoords[28], 0, strlen(arrCoords[28]), 255);
			CarInfo[idx][cGas] 			= strval(arrCoords[29]);
			CarInfo[idx][cAlarm] 		= strval(arrCoords[30]);
			CarInfo[idx][cVehTime]      = strval(arrCoords[31]);
			CarInfo[idx][cGPS]          = strval(arrCoords[32]);
			printf("(%d) %s",idx,CarInfo[idx][cName]);
			idx++;
		}
	}
	return 1;
}
y esto:

Код:
function UpdateCars()
{
    new idx, File: file2, coordsstring[256];
	idx = VV;
 	while (idx < sizeof(CarInfo))
  	{
		format(coordsstring, sizeof(coordsstring), "%d,%f,%f,%f,%f,%d,%d,%s,%s,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%s,%d,%d,%d,%d\n",
		CarInfo[idx][cModel],
		CarInfo[idx][cLocationx],
		CarInfo[idx][cLocationy],
		CarInfo[idx][cLocationz],
		CarInfo[idx][cAngle],
		CarInfo[idx][cColorOne],
		CarInfo[idx][cColorTwo],
		CarInfo[idx][cOwner],
		CarInfo[idx][cName],
		CarInfo[idx][cValue],
		CarInfo[idx][cOwned],
		CarInfo[idx][cLock],
		CarInfo[idx][cBattery],
		CarInfo[idx][cSpoiler],
		CarInfo[idx][cHood],
		CarInfo[idx][cRoof],
		CarInfo[idx][cSideskirt],
		CarInfo[idx][cNitro],
		CarInfo[idx][cLamps],
		CarInfo[idx][cExhaust],
		CarInfo[idx][cWheel],
		CarInfo[idx][cHydraulics],
		CarInfo[idx][cPaintjob],
		CarInfo[idx][cFrontBumper],
		CarInfo[idx][cRearBumper],
		CarInfo[idx][cVents],
		CarInfo[idx][cEmbargo],
		CarInfo[idx][cMulta],
		CarInfo[idx][cPlate],
		CarInfo[idx][cGas],
		CarInfo[idx][cAlarm],
		CarInfo[idx][cVehTime],
		CarInfo[idx][cGPS]);
		
		if(idx == VV)	file2 = fopen("cars.cfg", io_write);
		else			file2 = fopen("cars.cfg", io_append);
		
		fwrite(file2, coordsstring);
		idx++;
		fclose(file2);
	}
}
o algun ejemplo ya q estoy aprendiendo mysql .


Respuesta: (AYUDA) Transformar algo a MYSQL - TheChaoz - 17.10.2012

Lo que tu quieres es que te hagan el codigo, por lo cual va en Pedidos de Script. Y si quieres ejemplos, todo el foro esta lleno de codigos sobre sistemas de cuentas basados en SQL (tutoriales, includes, filterscripts, etc) solo hay que tener la voluntad de buscar.

Tema Cerrado