Help about mysql function - Printable Version

Help about mysql function - 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 about mysql function (/showthread.php?tid=652929)

Help about mysql function - masuzaron - 22.04.2018

I am starded working on my faction system that runs on BlueG's mysql plugin.
I just don't know how to create /makefaction command, to be more precise, how to check if
there is available ID in table "FACTIONS" and use that id for faction I created.
I also tried to convert this plugin in Mysql 40+ from BueG's but I also have problem with making command.
https://sampforum.blast.hk/showthread.php?tid=606469
So, if someone can just igve me the basic example for /makeorg command with BlueG's mysql plugin i would appriciate that.

Re: Help about mysql function - TitoRayne - 22.04.2018

May you please link down the codes you used aswell as the screenshot of your phpmyadmin

Re: Help about mysql function - masuzaron - 22.04.2018

When player uses /makefaction [name][type]

PHP код:



stock CreateFaction(fname[], Float:PlayerPosX, Float:PlayerPosY, Float:PlayerPosZ, ftype)

{

    DB::CreateRow(FactionTable, "FactionName", fname);

 

    new year, month, day;

 

    getdate(year, month, day);

 

    new fcID = GetAvailableFactionID();

 

    FactionInfo[fcID][dbID] = ReturnLastKey();

    FactionInfo[fcID][fID] = fcID;

 

    FactionInfo[fcID][fType] = ftype;

    FactionInfo[fcID][fX] = PlayerPosX;

    FactionInfo[fcID][fY] = PlayerPosY;

    FactionInfo[fcID][fZ] = PlayerPosZ;

 

    new cdate[30];

    format(cdate, sizeof cdate, "%02d/%02d/%d", day, month, year);

 

    DB::SetLastIntEntry(FactionTable, "fType", ftype, "Reference");

    DB::SetLastFloatEntry(FactionTable, "LockerX", PlayerPosX, "Reference");

    DB::SetLastFloatEntry(FactionTable, "LockerY", PlayerPosY, "Reference");

    DB::SetLastFloatEntry(FactionTable, "LockerZ", PlayerPosZ, "Reference");

    DB::SetLastStringEntry(FactionTable, "CreationDate", cdate, "Reference");

 

    LoadFactions();

 

    #if defined DEBUG_MODE

        printf("[FACTION CREATION] %s has been created today (%s). [IG ID: %d | SQL ID: %d]", fname, cdate, fcID, FactionInfo[fcID][dbID]);

    #endif

    return 1;

}

GetAvailableFactionID(); from stock above

PHP код:



stock GetAvailableFactionID()

{

    new id;

    for(new i; i < MAX_FACTIONS; i++)

    {

        if(FactionInfo[i][dbID] == 0)

        {

            id = i;

            break;

        }

    }

    return id;

}

and returnlastkey

PHP код:



stock ReturnLastKey()

{

    return DB::GetRowsPoolSize(FactionTable);

}

I need this to be converted to BlueG's Mysql plugin 40+

Re: Help about mysql function - jasperschellekens - 22.04.2018

Quote:

Originally Posted by masuzaron

I just don't know how to create /makefaction command, to be more precise, how to check if
there is available ID in table "FACTIONS" and use that id for faction I created.

SQL has nice options called autoincrement and primary key.
You can set these as fieldname ID for example.
Take a look at this query to create a table:

Код:

CREATE TABLE Persons (
    ID int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);

The field ID in the table Persons was created as auto_increment and "PRIMARY KEY (ID)" makes this field a primary key.
This feature allows you to have an unique ID for each row in the database and you are not required to count it scriptwise.
For example when there are 4 rows in the table with id 1,2,3 and 4, SQL automatically created ID 5 at the next row and 6 for the one after that and go on..

All you have to do in your query is putt "null" as ID and SQL will do the rest for you:

PHP код:



format(Query, sizeof(Query), "INSERT INTO `Persons` (`ID`, `LastName`, `FirstName`, `Age`) VALUES(NULL,'%s', '%s', '%d')", LastNameVar[playerid], FirstNameVar[playerid], AgeVar[playerid]);

Re: Help about mysql function - masuzaron - 22.04.2018

Quote:

Originally Posted by jasperschellekens

SQL has nice options called autoincrement and primary key.
You can set these as fieldname ID for example.
Take a look at this query to create a table:

Код:

CREATE TABLE Persons (
    ID int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);

PHP код:



format(Query, sizeof(Query), "INSERT INTO `Persons` (`ID`, `LastName`, `FirstName`, `Age`) VALUES(NULL,'%s', '%s', '%d')", LastNameVar[playerid], FirstNameVar[playerid], AgeVar[playerid]);

Thank you.