Seed Weed, 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: Seed Weed, Mysql (/showthread.php?tid=465756)

---

Seed Weed, Mysql - introx - 23.09.2013

[S'rry for my bad bad english, I'm french..]

Hi,

I make a system for /plantseed ( /plantergraine ) and /takeweed (/ramasserweed) but I can plant just 1 seed because the position of the seed = wplant[playerid] = CreateDynamicObject( 3409, x, y, z-2 , 0, 0, 96 );

If i plant 2 seed, i can just recolt the second seed..

I want make this with Mysql and all player can collect all seed... But i don't know how to make with Mysql..

Command:
http://pastebin.com/1grjgqXG

forward, public:
http://pastebin.com/dgvUnTdg

Thank's

Introx.

---

Re: Seed Weed, Mysql - StreetGT - 23.09.2013

create a field in table of weed -> ( Username ), if weed was planted by username, then you can take it.
Just create a loop, check position and check username.

---

Re : Seed Weed, Mysql - introx - 23.09.2013

And how i can check coordonnйe with mysql please?

if(PlayerToPoint(2.0, playerid, HERE, HERE, HERE))

---

Re: Seed Weed, Mysql - CoaPsyFactor - 24.09.2013

simply create column x,y,z with type float

---

Re : Seed Weed, Mysql - introx - 24.09.2013

Hmm thank's, but how i can destroyobject with mysql?
How the gamemode know where is the position of a plant, if i have 2, 3, 4 weed ?

---