Doesn't load object[MySQL] - 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: Doesn't load object[MySQL] (/showthread.php?tid=620190)

---

Doesn't load object[MySQL] - vassilis - 27.10.2016

At mysql_log it loads it correctly but i guess i have forgotten something?

mysql_log.txt
Loading Function
It doesn't create the object though.. Have i done something wrong on creatingobject? or the materialtext?

---

Re: Doesn't load object[MySQL] - AndySedeyn - 27.10.2016

It shouldn't be in a loop as your script only allows one object per player.

---

Re: Doesn't load object[MySQL] - Konstantinos - 27.10.2016

I want to point out about the string loading though. The 4th parameter is the connection handle and not the length of the said string to store the text.

---

Re: Doesn't load object[MySQL] - vassilis - 27.10.2016

But how could i make it so each player can have max 3 objects?

Ok thanks. I don't really think though that's the problem since it loads it correctly.

---

Re: Doesn't load object[MySQL] - AndySedeyn - 27.10.2016

Add an extra dimension which goes up to MAX_TAGS_PER_PLAYER which you can define to any value you like.

---

Re: Doesn't load object[MySQL] - vassilis - 27.10.2016

Ok and let's say the player has created the object
How should i use the variable with one more dimension?
For example
How this should be changed with the extra dimension?
EDIT: Forgot to mention that i am using in my script

---

Re: Doesn't load object[MySQL] - AndySedeyn - 27.10.2016

You can do two things:

• Keep count on how many objects the player already has:
  
  PHP код:

  enum E_PLAYER_DATA {

    tagCount
};
new PlayerInfo[MAX_PLAYERS][E_PLAYER_DATA];

enum E_TAG_DATA {

    // enumerators
};
new TagInfo[MAX_PLAYERS][MAX_TAGS_PER_PLAYER][E_TAG_DATA];

CMD:create(playerid, params[]) 
{ 
    if(PlayerInfo[playerid][tagCount] >= MAX_TAGS_PER_PLAYER)
        return SendClientMessage(playerid, -1, "You have reached the maximum amount of tags per player.");
    
    new tagIndex = ((PlayerInfo[playerid][tagCount] == 0) ? (PlayerInfo[playerid][tagCount]) : (PlayerInfo[playerid][tagCount] - 1));
    TagInfo[playerid][tagIndex][TagObject] = CreateDynamicObject(19482, X, Y, Z, 0.0, 0.0, 0.0, -1, -1, -1, 300.0, 300.0);
    return 1; 
} 

• Or via more sophisticated loops:
  
  PHP код:

  enum E_TAG_INFO {

    bool:tagExists
};
new TagInfo[MAX_PLAYERS][MAX_TAGS_PER_PLAYER][E_TAG_INFO];

function SprayTag_GetFreeID(playerid) {

    for(new i = 0; i < MAX_TAGS_PER_PLAYER; i++) if(!TagInfo[playerid][i][tagExists]) {

        return i; // Return the free index
    }
    return -1; // All tags are in use (= player has reached MAX_TAGS_PER_PLAYER tags).
}

CMD:create(playerid, params[]) 
{ 
    new tagIndex = SprayTag_GetFreeID(playerid);

    if(tagIndex == -1) {

        return SendClientMessage(playerid, -1, "You have reached the maximum amount of tags per player.");
    }

    TagInfo[playerid][tagIndex][TagObject] = CreateDynamicObject(19482, X, Y, Z, 0.0, 0.0, 0.0, -1, -1, -1, 300.0, 300.0);
    return 1; 
} 


These are just short and incomplete examples on how you could tackle the problem.

---

Re: Doesn't load object[MySQL] - vassilis - 27.10.2016

Thank you for taking into consideration my queries. I really had problems understanding how "houseids", "bizids" and other custom ids work. I think i understood a lot.

One last question? How could i use TagInfo[playerid][][tagExists] ?

---

Re: Doesn't load object[MySQL] - AndySedeyn - 27.10.2016

You can't. I can't think of a situation where that might be a solution.

---

Re: Doesn't load object[MySQL] - vassilis - 27.10.2016

Will it be better If i change my enum to TagInfo[MAX_TAGS_PER_PLAYER][TagInformation], removing all [playerid] dimensions ?
Doing something like that:
at top of the script

Function
My command

---