{Help} Table not being created.

{Help} Table not being created. - 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: {Help} Table not being created. (/showthread.php?tid=620615)

{Help} Table not being created. - StrikerZ - 01.11.2016

PHP код:



CMD:createfaction(playerid, params[])

{

    if(pInfo[playerid][pLevel] >= 5)

    {

            new id,name[50],fac = FacCount;

            if(sscanf(params,"us[50]",id,name)) return SCM(playerid,COLOR_ORANGE,"USAGE: /createfaction (playerid) (faction name)");

            if(fac >= MAX_FACTIONS) return SCM(playerid,COLOR_RED,"Max faction limit reached!");

            if(pInfo[id][flevel] == 0)

            {

            new Query[128];

            format(Query, sizeof(Query), "INSERT INTO `Faction` (`Name`, `ID`, `Owner`, `Levels`, `InviteRank`, `KickRank`) VALUES('%s', '%d', '%s', '%d', '%d', '%d')", name, FacCount, PN(id), 10, 7, 7);

            db_query(Database, Query);

            pInfo[id][flevel] = 10;

            pInfo[id][fname] = name;

            pInfo[id][pfacno] = FacCount;

            FactionInfo[fac][del] = 0;

            SaveStatus(id);

            new string[120];

            format(string,sizeof(string),"You created a faction for %s with name %s.",PN(id),name);

            SCM(playerid,COLOR_YELLOW,string);

            format(string,sizeof(string),"Administrator %s has created a faction for you with name %s.",PN(playerid),name);

            SCM(id,COLOR_YELLOW,string);

            FacCount++;

            }

    }

    return 1;

}

The tables are not being created in the DB file. Any idea?

Re: {Help} Table not being created. - Threshold - 01.11.2016

This code does not create a table, it inserts into it. You need to create the table 'Faction' first. There's not much point in creating the table in your gamemode as it's likely that you'll only really need to create it once in its lifetime.

PHP код:



CREATE TABLE IF NOT EXISTS `Faction` ...

Re: {Help} Table not being created. - StrikerZ - 01.11.2016

Yea i already have that code on ongamemodeinit everything is created just the values are not being inserted of the /createfaction

Re: {Help} Table not being created. - Micko123 - 01.11.2016

Quote:

Originally Posted by Vince

It's generally not worth the effort to create tables via Pawn. Just create the database and the table structure in phpMyAdmin or another GUI you might have.

Well..

And if you have problem just use this

PHP код:



mysql_log(ERROR | WARNING);

Re: {Help} Table not being created. - StrikerZ - 01.11.2016

I'm using sqlite and not mysql

Re: {Help} Table not being created. - StrikerZ - 01.11.2016

BUMP!

Re: {Help} Table not being created. - Konstantinos - 01.11.2016

So the table exists but it doesn't insert a new row, the title is misleading.

Open server.cfg and add:

pawn Код:

db_logging 1

start the server, execute the command and post the server log.

And please don't bump within 24 hours, there are rules we all should follow.

Re: {Help} Table not being created. - StrikerZ - 01.11.2016

PHP код:



[16:30:05] [Warning] db_query: Query failed: near ",": syntax error

Only this error came

Re: {Help} Table not being created. - Konstantinos - 01.11.2016

Can you also add

pawn Код:

db_log_queries 1

in server.cfg and try again? If we have the query might be easier.