1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Cannot get 3D text label to display after loading.
willsuckformoney
High-roller
*****
Posts: 1,494
Threads: 120
Joined: Dec 2009
Reputation: 0
#1

03.04.2015, 01:08
( Последний раз редактировалось willsuckformoney; 03.04.2015 в 01:43. )
The pickup creates, the houses load etc. But it does not show the text label. The code looks fine in my eyes.

pawn Код:
//OnGameModeInIt
        for(new h; h < MAX_HOUSES; h++)
    {
        mysql_format(mysql, query, sizeof(query), "SELECT * FROM `houses` WHERE `hID` = '%d' LIMIT 1", h);
        mysql_tquery(mysql, query, "OnHousesLoad", "d", h);
    }

//callback
public OnHousesLoad(houseid)
{
    hInfo[houseid][hID] = cache_get_field_content_int(0, "hID");
    if(hInfo[houseid][hID] > 0)
    {
        hInfo[houseid][owned] = cache_get_field_content_int(0, "owned");
        cache_get_field_content(0, "owner",hInfo[houseid][owner]);
        cache_get_field_content(0, "address",hInfo[houseid][address]);
        hInfo[houseid][cost] = cache_get_field_content_int(0, "cost");
        hInfo[houseid][Int] = cache_get_field_content_int(0, "Int");
        hInfo[houseid][hX] = cache_get_field_content_float(0, "hX");
        hInfo[houseid][hY] = cache_get_field_content_float(0, "hY");
        hInfo[houseid][hZ] = cache_get_field_content_float(0, "hZ");
        hInfo[houseid][tX] = cache_get_field_content_float(0, "tX");
        hInfo[houseid][tY] = cache_get_field_content_float(0, "tY");
        hInfo[houseid][tZ] = cache_get_field_content_float(0, "tZ");
    
        hPickup[houseid] = CreateDynamicPickup(1273,1,hInfo[houseid][hX],hInfo[houseid][hY],hInfo[houseid][hZ]);
        House[houseid] = CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ], 50);
    
        Houses++;
        printf("%d Houses Have Been Loaded.",Houses);
    }
    return 1;
}
Find
Reply
X337
Gangsta
*****
Posts: 872
Threads: 25
Joined: Sep 2014
Reputation: 0
#2

03.04.2015, 02:21
Код:
public OnHousesLoad(houseid)
{
	new tempString[128];
    	hInfo[houseid][hID] = cache_get_field_content_int(0, "hID");
	if(hInfo[houseid][hID] > 0)
	{
		hInfo[houseid][owned] = cache_get_field_content_int(0, "owned");
		cache_get_field_content(0, "owner", tempString);
		format(hInfo[houseid][owner], 128, "%s", tempString);
		cache_get_field_content(0, "address", tempString);
		format(hInfo[houseid][address], 128, "%s", tempString);
		hInfo[houseid][cost] = cache_get_field_content_int(0, "cost");
		hInfo[houseid][Int] = cache_get_field_content_int(0, "Int");
		hInfo[houseid][hX] = cache_get_field_content_float(0, "hX");
		hInfo[houseid][hY] = cache_get_field_content_float(0, "hY");
		hInfo[houseid][hZ] = cache_get_field_content_float(0, "hZ");
		hInfo[houseid][tX] = cache_get_field_content_float(0, "tX");
		hInfo[houseid][tY] = cache_get_field_content_float(0, "tY");
		hInfo[houseid][tZ] = cache_get_field_content_float(0, "tZ");
	
	   	hPickup[houseid] = CreateDynamicPickup(1273,1,hInfo[houseid][hX],hInfo[houseid][hY],hInfo[houseid][hZ]);
		House[houseid] = CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ] + 1.0, 50);
	
		Houses++;
		printf("%d Houses Have Been Loaded.",Houses);
	}
	return 1;
}
Hope it'll work sir
Find
Reply
[ABK]Antonio
High-roller
*****
Posts: 1,223
Threads: 5
Joined: Sep 2011
Reputation: 0
#3

03.04.2015, 02:34
Quote:
Originally Posted by bondowocopz
Посмотреть сообщение
Код:
public OnHousesLoad(houseid)
{
	new tempString[128];
    	hInfo[houseid][hID] = cache_get_field_content_int(0, "hID");
	if(hInfo[houseid][hID] > 0)
	{
		hInfo[houseid][owned] = cache_get_field_content_int(0, "owned");
		cache_get_field_content(0, "owner", tempString);
		format(hInfo[houseid][owner], 128, "%s", tempString);
		cache_get_field_content(0, "address", tempString);
		format(hInfo[houseid][address], 128, "%s", tempString);
		hInfo[houseid][cost] = cache_get_field_content_int(0, "cost");
		hInfo[houseid][Int] = cache_get_field_content_int(0, "Int");
		hInfo[houseid][hX] = cache_get_field_content_float(0, "hX");
		hInfo[houseid][hY] = cache_get_field_content_float(0, "hY");
		hInfo[houseid][hZ] = cache_get_field_content_float(0, "hZ");
		hInfo[houseid][tX] = cache_get_field_content_float(0, "tX");
		hInfo[houseid][tY] = cache_get_field_content_float(0, "tY");
		hInfo[houseid][tZ] = cache_get_field_content_float(0, "tZ");
	
	   	hPickup[houseid] = CreateDynamicPickup(1273,1,hInfo[houseid][hX],hInfo[houseid][hY],hInfo[houseid][hZ]);
		House[houseid] = CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ] + 1.0, 50);
	
		Houses++;
		printf("%d Houses Have Been Loaded.",Houses);
	}
	return 1;
}
Hope it'll work sir
cache_get_field_content(row, field_name[], destination[], connectionHandle = 1, max_len = sizeof(destination)

Why he would need a separate string for this is beyond me.

Not sure what the problem is, just thought I'd show this guy that.


There's 1 way to find out what's happening though.
pawn Код:
printf("HouseID: %i | Address: %s | X,Y,Z: %f,%f,%f", houseid, hInfo[houseid][address], hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ]);
Though, if the pickup is being created as well it seems a bit weird.
Find
Reply
willsuckformoney
High-roller
*****
Posts: 1,494
Threads: 120
Joined: Dec 2009
Reputation: 0
#4

03.04.2015, 14:51
Quote:
Originally Posted by bondowocopz
Посмотреть сообщение
Код:
public OnHousesLoad(houseid)
{
	new tempString[128];
    	hInfo[houseid][hID] = cache_get_field_content_int(0, "hID");
	if(hInfo[houseid][hID] > 0)
	{
		hInfo[houseid][owned] = cache_get_field_content_int(0, "owned");
		cache_get_field_content(0, "owner", tempString);
		format(hInfo[houseid][owner], 128, "%s", tempString);
		cache_get_field_content(0, "address", tempString);
		format(hInfo[houseid][address], 128, "%s", tempString);
		hInfo[houseid][cost] = cache_get_field_content_int(0, "cost");
		hInfo[houseid][Int] = cache_get_field_content_int(0, "Int");
		hInfo[houseid][hX] = cache_get_field_content_float(0, "hX");
		hInfo[houseid][hY] = cache_get_field_content_float(0, "hY");
		hInfo[houseid][hZ] = cache_get_field_content_float(0, "hZ");
		hInfo[houseid][tX] = cache_get_field_content_float(0, "tX");
		hInfo[houseid][tY] = cache_get_field_content_float(0, "tY");
		hInfo[houseid][tZ] = cache_get_field_content_float(0, "tZ");
	
	   	hPickup[houseid] = CreateDynamicPickup(1273,1,hInfo[houseid][hX],hInfo[houseid][hY],hInfo[houseid][hZ]);
		House[houseid] = CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ] + 1.0, 50);
	
		Houses++;
		printf("%d Houses Have Been Loaded.",Houses);
	}
	return 1;
}
Hope it'll work sir
No change, and Antonio, I added the print that you suggested, and it prints out the right coordinates. I'm clueless right now.
Find
Reply
Chlorine
Banned
Posts: 16
Threads: 0
Joined: Mar 2015
#5

03.04.2015, 14:57
Try this:
pawn Код:
ublic OnHousesLoad(houseid)
{
    hInfo[houseid][hID] = cache_get_field_content_int(0, "hID");
    if(hInfo[houseid][hID] > 0)
    {
        hInfo[houseid][owned] = cache_get_field_content_int(0, "owned");
        cache_get_field_content(0, "owner",hInfo[houseid][owner]);
        cache_get_field_content(0, "address",hInfo[houseid][address]);
        hInfo[houseid][cost] = cache_get_field_content_int(0, "cost");
        hInfo[houseid][Int] = cache_get_field_content_int(0, "Int");
        hInfo[houseid][hX] = cache_get_field_content_float(0, "hX");
        hInfo[houseid][hY] = cache_get_field_content_float(0, "hY");
        hInfo[houseid][hZ] = cache_get_field_content_float(0, "hZ");
        hInfo[houseid][tX] = cache_get_field_content_float(0, "tX");
        hInfo[houseid][tY] = cache_get_field_content_float(0, "tY");
        hInfo[houseid][tZ] = cache_get_field_content_float(0, "tZ");
    
        hPickup[houseid] = CreateDynamicPickup(1273,1,hInfo[houseid][hX],hInfo[houseid][hY],hInfo[houseid][hZ]);
        House[houseid] = CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ]+0.5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 50);
    
        Houses++;
        printf("%d Houses Have Been Loaded.",Houses);
    }
    return 1;
}
Find
Reply
willsuckformoney
High-roller
*****
Posts: 1,494
Threads: 120
Joined: Dec 2009
Reputation: 0
#6

03.04.2015, 22:16
Quote:
Originally Posted by Chlorine
Посмотреть сообщение
Try this:
pawn Код:
ublic OnHousesLoad(houseid)
{
    hInfo[houseid][hID] = cache_get_field_content_int(0, "hID");
    if(hInfo[houseid][hID] > 0)
    {
        hInfo[houseid][owned] = cache_get_field_content_int(0, "owned");
        cache_get_field_content(0, "owner",hInfo[houseid][owner]);
        cache_get_field_content(0, "address",hInfo[houseid][address]);
        hInfo[houseid][cost] = cache_get_field_content_int(0, "cost");
        hInfo[houseid][Int] = cache_get_field_content_int(0, "Int");
        hInfo[houseid][hX] = cache_get_field_content_float(0, "hX");
        hInfo[houseid][hY] = cache_get_field_content_float(0, "hY");
        hInfo[houseid][hZ] = cache_get_field_content_float(0, "hZ");
        hInfo[houseid][tX] = cache_get_field_content_float(0, "tX");
        hInfo[houseid][tY] = cache_get_field_content_float(0, "tY");
        hInfo[houseid][tZ] = cache_get_field_content_float(0, "tZ");
    
        hPickup[houseid] = CreateDynamicPickup(1273,1,hInfo[houseid][hX],hInfo[houseid][hY],hInfo[houseid][hZ]);
        House[houseid] = CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ]+0.5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 50);
    
        Houses++;
        printf("%d Houses Have Been Loaded.",Houses);
    }
    return 1;
}
This still did not display the label..
Find
Reply
angelxeneize
Big Clucker
***
Posts: 74
Threads: 12
Joined: Dec 2011
Reputation: 0
#7

27.05.2015, 15:29
CreateDynamic3DTextLabel(hInfo[houseid][address], COLOR_GREEN, hInfo[houseid][hX], hInfo[houseid][hY], hInfo[houseid][hZ]+0.5, 25,INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0,-1,-1, -1, 100);
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#8

27.05.2015, 15:44
Please do not treat SQL like a dirty file system. Please read: https://sampforum.blast.hk/showthread.php?tid=366019. Bit outdated in terms of code, but the mindset still applies.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help