MYSQL - How can I do this? - Printable Version

MYSQL - How can I do this? - 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: MYSQL - How can I do this? (/showthread.php?tid=577482)

MYSQL - How can I do this? - DarkLouis - 11.06.2015

Hi all, I created, in the time, some systems and some of this use plus variables.

I decidid of converting my gamemode from ''Y_INI to MYSQL.

Now I have this:

PHP код:



#define MAX_OBJ 31


Float:O_X[MAX_OBJ],

Float:O_Y[MAX_OBJ],

Float:O_Z[MAX_OBJ],

Float:O_rX[MAX_OBJ],

Float:O_rY[MAX_OBJ],

Float:O_rZ[MAX_OBJ],

Oggetto[MAX_OBJ],

Piazzato[MAX_OBJ],

Modello[MAX_OBJ],

Interior[MAX_OBJ],

VirtualWorld[MAX_OBJ],

I need to put in the database. How can I do this? Let's do some mats. 30 * 11 = 330 columns, .. 330. Can you tell me a way speedly, workly and a explanation? Thank you very much.

I use R-39 version of plugin MYSQL.

Re: MYSQL - How can I do this? - Vince - 11.06.2015

Ugh no. 12 columns (the 11 you listed plus a unique id), infinite rows.

Re: MYSQL - How can I do this? - DarkLouis - 12.06.2015

Yes, 11 + ID.

So.. how to do this?

Re: MYSQL - How can I do this? - DarkLouis - 12.06.2015

I need to create columns for register step.