SA-MP Forums Archive
mysql functions load - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql functions load (/showthread.php?tid=214988)


mysql functions load - NewbBeginner - 22.01.2011

Код:
stock Loadveh()
{
	new
	    vehid
  	;
	format(Query, sizeof(Query), "SELECT * FROM `cars` WHERE `carid` = '%d'", vehid);
	mysql_query(Query);
	mysql_store_result();

    if(mysql_retrieve_row())
    {
        new
			Data[128]
		;
        mysql_fetch_field_row(Data,"Carid"); CarInfo[carid][vCarid] = strval(Data);
        mysql_fetch_field_row(Data,"PosX"); CarInfo[carid][vPosX] = strval(Data);
        mysql_fetch_field_row(Data,"PosY"); CarInfo[carid][vPosY] = strval(Data);
        mysql_fetch_field_row(Data,"PosZ"); CarInfo[carid][vPosZ] = strval(Data);
        mysql_fetch_field_row(Data,"CarAngle"); CarInfo[carid][vCarAngle] = strval(Data);
        AddStaticVehicleEx(CarInfo[carid][vCarid], CarInfo[carid][vPosX], CarInfo[carid][vPosY], CarInfo[carid][vPosZ], CarInfo[carid][vCarAngle], -1, -1, -1);
	}
    mysql_free_result();
}
None errors, but it doesnt load.

Re: mysql functions load - Kaylux - 22.01.2011

Appart from the fact that your variable is empty. Post your MySQL error log.

Re: mysql functions load - NewbBeginner - 22.01.2011

Код:
[18:23:52] CMySQLHandler::Query(SELECT * FROM `cars` WHERE `carid` = '0') - Successfully executed.


Re: mysql functions load - NewbBeginner - 22.01.2011

Still need help.