PDA

View Full Version : Seed Weed, Mysql


introx
23/09/2013, 09:38 PM
[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.

StreetGT
23/09/2013, 09:41 PM
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.

introx
23/09/2013, 11:16 PM
And how i can check coordonnée with mysql please?

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

CoaPsyFactor
24/09/2013, 12:10 AM
simply create column x,y,z with type float

introx
24/09/2013, 06:26 PM
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 ?