SQLite wont create a table - Printable Version

SQLite wont create a table - 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: SQLite wont create a table (/showthread.php?tid=467754)

SQLite wont create a table - Mattakil - 04.10.2013

Under OnGameModeInit:

pawn Код:

db_query(survival, "CREATE TABLE IF NOT EXISTS `ACCOUNTS` (`NAME`, `PASSWORD`, `IP`, `LEVEL`, `CASH`, `ADMINLEVEL`, `HOURS`, `JOB`, `BANNED`, `SPAWN`, `BANK`, `FOOD`, `WATER`, `SKIN`, `FACTION`, `FACTION_LEVEL`, `VEHICLE1`, `VEHICLE2`, `VEHICLE3`, `VEHICLE4`, VEHICLE5`)");

it doesnt create table if not exists!

Re: SQLite wont create a table - Jefff - 04.10.2013

`VEHICLE5`

Re: SQLite wont create a table - DanishHaq - 04.10.2013

EDIT: Bad reply > don't use this :P.

Make sure the array for the "survival" is large enough.

Re: SQLite wont create a table - -Prodigy- - 04.10.2013

Quote:

Originally Posted by DanishHaq

Make sure the array for the "survival" is large enough.

You should see the wiki before responding: https://sampwiki.blast.hk/wiki/Db_query

Re: SQLite wont create a table - DanishHaq - 04.10.2013

Quote:

Originally Posted by -Prodigy-

You should see the wiki before responding: https://sampwiki.blast.hk/wiki/Db_query

Ah, my mistake, sorry.

Re: SQLite wont create a table - Mattakil - 05.10.2013

Quote:

Originally Posted by Jefff

`VEHICLE5`

Thanks for pointing that out, it didnt fix it though D:

Re: SQLite wont create a table - Mattakil - 05.10.2013

fixed.