[Solved] Getting data into MySQL table easier.
#1

I've saved 591 vehicles using /save command and added them into my GM, but now i'm moving to mysql, and i need to get:

pawn Код:
m // model ID
x
y
z
a // angle
c // color 1
c2 // color 2
r // respawn delay
into a table. This table has:
Код:
ID
X
Y
Z
A
C
C
R
I made a command which had a loop and got all the 591 IDs into the table:
pawn Код:
CMD:auto(playerid, params[])
{
    #pragma unused params
   
    new
      query[50];
     
    for(new i = 0; i < 591; i ++)
    {
        format(query, sizeof(query), "INSERT INTO `vehicles` (ID) VALUE ('%d')", i);
        mysql_query(query);
    }
    return 1;
}
But i don't know how to get x y z a c c and r into the table faster (as that command). Can anyone help me?
Reply


Messages In This Thread
[Solved] Getting data into MySQL table easier. - by Miguel - 23.01.2010, 21:50
Re: Getting data into MySQL table easier. - by Chaprnks - 24.01.2010, 00:53
Re: Getting data into MySQL table easier. - by Miguel - 24.01.2010, 01:15

Forum Jump:


Users browsing this thread: 1 Guest(s)