[bigdaddy424]

Table will only be created on sqlite environment so put SQLite in title instead of SQL. They're completely different from one another.

[Supremache]

Originally Posted by bigdaddy424 Table will only be created on sqlite environment so put SQLite in title instead of SQL. They're completely different from one another.

I did, "SQL_SetAffinity( "sqlite" );", but i don't know how to test it, so before iam upload a plugin with sql code i add debug logs for show if it is work or not so i'm ask for if there who know how to use it for tell me if the code has an issue.
.
API is the same but the difference is the title SQL_SetAffinity("sqlite") or SQL_SetAffinity("mysql")
https://forums.alliedmods.net/showthread.php?t=256024

[bigdaddy424]

I understand that the language they use is almost the same but until you support MySQL you must change your title so people don't come up to this thread saying why it doesn't work. It would take you less time to update it than reply to this.

[Supremache]

Originally Posted by bigdaddy424 I understand that the language they use is almost the same but until you support MySQL you must change your title so people don't come up to this thread saying why it doesn't work. It would take you less time to update it than reply to this.

• Added an option to to select MySql or Sqlite.
• Added an option to name nvault.

[sigerman]

PHP Code: L 04/10/2022 - 03:29:11: [AMXX] Plugin says: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`SteamID` VARCHAR(64) UNIQUE, `Cash` INT(16) NOT NULL)' at line 1

Please If you could help me, your plugin calls all my attention

[Supremache]

Originally Posted by sigerman Please If you could help me, your plugin calls all my attention

I will fix it in the next version but for now replace this:

PHP Code:

formatex( szQuery, charsmax( szQuery ), "CREATE TABLE IF NOT EXISTS `%s` (ID INTEGER PRIMARY KEY AUTOINCREMENT,\
            `SteamID` VARCHAR(%i) UNIQUE, `Cash` INT(%i) NOT NULL);", g_iSettings[ SQL_TABLE ], MAX_AUTHID_LENGTH, MAX_CASH_LENGTH ); 


PHP Code:

formatex( szQuery, charsmax( szQuery ), "CREATE TABLE IF NOT EXISTS `%s` (`SteamID` VARCHAR(%i) NOT NULL,\
            `Cash` INT(%i) NOT NULL, PRIMARY KEY(SteamID));", g_iSettings[ SQL_TABLE ], MAX_AUTHID_LENGTH, MAX_CASH_LENGTH ); 


[sigerman]

It works, thanks

I was testing the plugin and I've found out that donate and reset options in the menu does not give a respone in case you have access to It

It would be nice also, to save by ip and name in the mysql option

It is a very well done plugin, I will use It on my servers, I apreciate your work!

Originally Posted by Supremache I will fix it in the next version but for now replace this: PHP Code: formatex( szQuery, charsmax( szQuery ), "CREATE TABLE IF NOT EXISTS `%s` (ID INTEGER PRIMARY KEY AUTOINCREMENT,\             `SteamID` VARCHAR(%i) UNIQUE, `Cash` INT(%i) NOT NULL);", g_iSettings[ SQL_TABLE ], MAX_AUTHID_LENGTH, MAX_CASH_LENGTH );  PHP Code: formatex( szQuery, charsmax( szQuery ), "CREATE TABLE IF NOT EXISTS `%s` (`SteamID` VARCHAR(%i) NOT NULL,\             `Cash` INT(%i) NOT NULL, PRIMARY KEY(SteamID));", g_iSettings[ SQL_TABLE ], MAX_AUTHID_LENGTH, MAX_CASH_LENGTH );

[Supremache]

Originally Posted by sigerman I was testing the plugin and I've found out that donate and reset options in the menu does not give a respone in case you have access to It

Check the config file.

Originally Posted by sigerman It would be nice also, to save by ip and name in the mysql option

I will

[Supremache]

Originally Posted by sigerman I was testing the plugin and I've found out that donate and reset options in the menu does not give a respone in case you have access to It

If you are testing it alone, it won't appear your name because there is a code that disappear it from the menu 'if( ( iPlayer = szPlayers[ i ] ) != id )'

Originally Posted by sigerman It would be nice also, to save by ip and name in the mysql option

• Added option to save SQL date using IP, name

[sigerman]

I was testing alone, ups! It works fine

Your support is so fast and caring, I will recommend your plugin. Thanks.
________

Edit: I've found this while the plugin is configured to save by name L 04/18/2022 - 15:12:45: [Bank2.0-10-5461.amxx] [SQL Error] Query failed (1054): Unknown column 'Player' in 'field list'

Originally Posted by Supremache If you are testing it alone, it won't appear your name because there is a code that disappear it from the menu 'if( ( iPlayer = szPlayers[ i ] ) != id )' Added option to save SQL date using IP, name