MySQL Createpickup dynamic help

MySQL Createpickup dynamic help - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Createpickup dynamic help (/showthread.php?tid=153202)

MySQL Createpickup dynamic help - oliverrud - 07.06.2010

Is it possible to like do following:

Add a mysql table with following:

Код:

CREATE TABLE `pickups` (
	`ID` INT(20) NOT NULL,
	`Modelid` INT(20) NOT NULL,
	`Type` INT(20) NOT NULL,
	`PosX` INT(20) NOT NULL,
	`PosY` INT(20) NOT NULL,
	`PosZ` INT(20) NOT NULL,
	`VirtualWorld` INT(20) NOT NULL,
	PRIMARY KEY (`ID`)
)

Then have some code in your script which makes the rows which is created in the mysql table?
I'm pretty sure it's possible I just don't have a clue about how to make it.
I'm wondering if someone can lead me the right way on how to make the Createpickup load from a table instead of me having to add every:

CreatePickup(1239, 1, 2091.2627, 695.1879, 11.5609);

Inside my script.
Plus this would give me the possibility of being able to create a dynamic createpickup system.