[Crazyboobs]

Hello, this is a mysql code
Under ongamemodeinit, is it correct? it didnt give me any error but i having a doubt.

pawn Код:

new string[900];
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    strcat(string,"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), registered INT(20), RegisteredDate INT(20), loggedin INT(20), banned INT(20), Rgun INT(20), Unlimitedb INT(20), Quickweapon INT(20), Vgoto INT(20), PlayerFly INT(20), TIP INT(20), Function1 INT(20), Function2 INT(20), Function3 INT(20),");
    strcat(string,"Function4 INT(20), Function5 INT(20), Cookies INT(20), Cakes INT(20), Biscuits INT(20), IceCreams INT(20), level INT(20), LastOn INT(20), money INT(20), kills INT(20), deaths INT(20), Bank INT(20), weed INT(20), Condoms INT(20), inalcatraz INT(20), score INT(20), hours INT(20), minutes INT(20), seconds INT(20), x1 INT(20), y1 INT(20),");
    strcat(string,"z1 INT(20), interior1 INT(20), weap1 INT(20), weap1ammo INT(20), weap2 INT(20), weap2ammo INT(20), weap3 INT(20), weap3ammo INT(20), weap4 INT(20), weap4ammo INT(20), weap5 INT(20), weap5ammo INT(20), weap6 INT(20), weap6ammo INT(20), health INT(20), armour INT(20), TimesOnServer INT(20), bowner INT(20), bowned INT(20), vowned INT(20),");
    strcat(string,"vowner INT(20), vowned2 INT(20) vowner2 INT(20), vowned3 INT(20), vowner3 INT(20), vowned4 INT(20), vowner4 INT(20), vowned5 INT(20), vowner5 INT(20), Houseid INT(20), Rentid INT(20), SpawnX INT(20), SpawnY INT(20), SpawnZ INT(20), SpawnInt INT(20)");
    mysql_query(string);
    mysql_debug(1);

[clarencecuzz]

pawn Код:

new string[900];
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), registered INT(20), RegisteredDate INT(20), loggedin INT(20), banned INT(20), Rgun INT(20), Unlimitedb INT(20), Quickweapon INT(20), Vgoto INT(20), PlayerFly INT(20), TIP INT(20), Function1 INT(20), Function2 INT(20), Function3 INT(20),");
    strcat(string,"Function4 INT(20), Function5 INT(20), Cookies INT(20), Cakes INT(20), Biscuits INT(20), IceCreams INT(20), level INT(20), LastOn INT(20), money INT(20), kills INT(20), deaths INT(20), Bank INT(20), weed INT(20), Condoms INT(20), inalcatraz INT(20), score INT(20), hours INT(20), minutes INT(20), seconds INT(20), x1 INT(20), y1 INT(20),");
    strcat(string,"z1 INT(20), interior1 INT(20), weap1 INT(20), weap1ammo INT(20), weap2 INT(20), weap2ammo INT(20), weap3 INT(20), weap3ammo INT(20), weap4 INT(20), weap4ammo INT(20), weap5 INT(20), weap5ammo INT(20), weap6 INT(20), weap6ammo INT(20), health INT(20), armour INT(20), TimesOnServer INT(20), bowner INT(20), bowned INT(20), vowned INT(20),");
    strcat(string,"vowner INT(20), vowned2 INT(20), vowner2 INT(20), vowned3 INT(20), vowner3 INT(20), vowned4 INT(20), vowner4 INT(20), vowned5 INT(20), vowner5 INT(20), Houseid INT(20), Rentid INT(20), SpawnX INT(20), SpawnY INT(20), SpawnZ INT(20), SpawnInt INT(20)");
    mysql_query(string);
    mysql_debug(1);

Not too much experience with this, but I think this is right.

[HuSs3n]

1 - there is no , after vowned2 INT(20)
2- there is no ) at the end

fixed one

pawn Код:

CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), registered INT(20), RegisteredDate INT(20), loggedin INT(20), banned INT(20), Rgun INT(20), Unlimitedb INT(20), Quickweapon INT(20), Vgoto INT(20), PlayerFly INT(20), TIP INT(20), Function1 INT(20), Function2 INT(20), Function3 INT(20),
Function4 INT(20), Function5 INT(20), Cookies INT(20), Cakes INT(20), Biscuits INT(20), IceCreams INT(20), level INT(20), LastOn INT(20), money INT(20), kills INT(20), deaths INT(20), Bank INT(20), weed INT(20), Condoms INT(20), inalcatraz INT(20), score INT(20), hours INT(20), minutes INT(20), seconds INT(20), x1 INT(20), y1 INT(20),
z1 INT(20), interior1 INT(20), weap1 INT(20), weap1ammo INT(20), weap2 INT(20), weap2ammo INT(20), weap3 INT(20), weap3ammo INT(20), weap4 INT(20), weap4ammo INT(20), weap5 INT(20), weap5ammo INT(20), weap6 INT(20), weap6ammo INT(20), health INT(20), armour INT(20), TimesOnServer INT(20), bowner INT(20), bowned INT(20), vowned INT(20),
vowner INT(20), vowned2 INT(20), vowner2 INT(20), vowned3 INT(20), vowner3 INT(20), vowned4 INT(20), vowner4 INT(20), vowned5 INT(20), vowner5 INT(20), Houseid INT(20), Rentid INT(20), SpawnX INT(20), SpawnY INT(20), SpawnZ INT(20), SpawnInt INT(20))

tested in phpmyadmin

[Crazyboobs]

Quote:

Originally Posted by HuSs3n 1 - there is no , after vowned2 INT(20) 2- there is no ) at the end fixed one pawn Код: CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), registered INT(20), RegisteredDate INT(20), loggedin INT(20), banned INT(20), Rgun INT(20), Unlimitedb INT(20), Quickweapon INT(20), Vgoto INT(20), PlayerFly INT(20), TIP INT(20), Function1 INT(20), Function2 INT(20), Function3 INT(20), Function4 INT(20), Function5 INT(20), Cookies INT(20), Cakes INT(20), Biscuits INT(20), IceCreams INT(20), level INT(20), LastOn INT(20), money INT(20), kills INT(20), deaths INT(20), Bank INT(20), weed INT(20), Condoms INT(20), inalcatraz INT(20), score INT(20), hours INT(20), minutes INT(20), seconds INT(20), x1 INT(20), y1 INT(20), z1 INT(20), interior1 INT(20), weap1 INT(20), weap1ammo INT(20), weap2 INT(20), weap2ammo INT(20), weap3 INT(20), weap3ammo INT(20), weap4 INT(20), weap4ammo INT(20), weap5 INT(20), weap5ammo INT(20), weap6 INT(20), weap6ammo INT(20), health INT(20), armour INT(20), TimesOnServer INT(20), bowner INT(20), bowned INT(20), vowned INT(20), vowner INT(20), vowned2 INT(20), vowner2 INT(20), vowned3 INT(20), vowner3 INT(20), vowned4 INT(20), vowner4 INT(20), vowned5 INT(20), vowner5 INT(20), Houseid INT(20), Rentid INT(20), SpawnX INT(20), SpawnY INT(20), SpawnZ INT(20), SpawnInt INT(20)) tested in phpmyadmin

Just copy paste this in ongamemodeinit? or i have to add anything before CREATE TABLE IF NOT EXISTS data?