SA-MP Forums Archive
Points not loading! - 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: Points not loading! (/showthread.php?tid=640570)



Points not loading! - Puff - 04.09.2017

Hii, I've these points: http://prntscr.com/ggw3nc in mySQL but it isn't showing up in the script for some reason...

here is the points.pwn.. attached.. please help thanks.


Re: Points not loading! - Puff - 04.09.2017

Help anyone?


Re: Points not loading! - Meller - 04.09.2017

Код:
public onLoadPoints() {
	new rows, fields;
	cache_get_data(rows,fields);
	new id_string[32];
	for(new i=0;i<rows;i++) {
		printf("spawning 'n' loading poiint id %i", i);
		cache_get_row(i,0,id_string);
		Points[i][EPointSQLID] = strval(id_string);
		cache_get_row(i,1,Points[i][EPointDataName]);
		cache_get_row(i,2,id_string);
		Points[i][EPointDataX] = floatstr(id_string);
		cache_get_row(i,3,id_string);
		Points[i][EPointDataY] = floatstr(id_string);
		cache_get_row(i,4,id_string);
		Points[i][EPointDataZ] = floatstr(id_string);
		cache_get_row(i,5,id_string);
		Points[i][EPointDataInt] = strval(id_string);
		cache_get_row(i,6,id_string);
		Points[i][EPointDataVW] = strval(id_string);
		cache_get_row(i,7,id_string);
		Points[i][EPointDataType] = EPointType:strval(id_string);
		cache_get_row(i,8,id_string);
		Points[i][EPointDataDeliver] = strval(id_string);
		cache_get_row(i,9,id_string);
		Points[i][EPointDataIconID] = strval(id_string);
		cache_get_row(i,10,id_string);
		Points[i][EPointPickupModel] = strval(id_string);
		cache_get_row(i,11,id_string);
		Points[i][EPointOwnerFamily] = FindFamilyBySQLID(strval(id_string));
		cache_get_row(i,12,id_string);
		Points[i][EPointCaptureTime] = strval(id_string);
		Points[i][EPointPickupID] = CreateDynamicPickup(Points[i][EPointPickupModel], 16, Points[i][EPointDataX], Points[i][EPointDataY], Points[i][EPointDataZ],Points[i][EPointDataVW],Points[i][EPointDataInt]);
		//point tip
		new pointlabel[128];
		format(pointlabel, sizeof(pointlabel), "%s {FFFFFF}(( {FF0000} %s {FFFFFF} ))", Points[i][EPointDataName], givePlayerPointTip(i));
		Points[i][EPointLabel] = CreateDynamic3DTextLabel(pointlabel, getPointColour(i), Points[i][EPointDataX], Points[i][EPointDataY], Points[i][EPointDataZ]+1.0, 10.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, Points[i][EPointDataVW],Points[i][EPointDataInt]);
		if(Points[i][EPointDataIconID] != -1) {
			new mapid = allocMapID();		
			Points[i][EPointMapSlotID] = mapid;
		}
	}
}
pointsOnGameModeInit() {
	print("gatherin' 'em mysql data");
	query[0] = 0;
	format(query, sizeof(query), "SELECT `id`,`name`,`x`,`y`,`z`,`interior`,`virtualworld`,`type`,`deliver`,`iconid`,`model`,`owner`,Unix_Timestamp(`capturetime`) FROM `points`");
	mysql_function_query(g_mysql_handle, query, true, "onLoadPoints", "");
	pointwarpoint = -1;
}
make a 2 line debug plz thx


Re: Points not loading! - Eoussama - 04.09.2017

Removed.
I didn't reload the page.