Raised This Month: $51 Target: $400
 12% 

Transfer vault information to SQL


Post New Thread Reply   
AlliedModders Forum Index > AMX Mod X > Plugins > Suggestions / Requests
Page 2 of 3 1 2 3
 
Thread Tools Display Modes
Bugsy
AMX Mod X Moderator
Bugsy's Avatar
Join Date: Feb 2005
Location: NJ, USA
Old 12-29-2023 , 10:40   Re: Transfer vault information to SQL
Reply With Quote #11
What is “the name”?
__________________
Bugsy is offline
amirwolf
Senior Member
amirwolf's Avatar
Join Date: Feb 2019
Location: Iran
Old 12-29-2023 , 11:38   Re: Transfer vault information to SQL
Reply With Quote #12
I mean the name
Adding the name of the player was not yet added to the main plugin
__________________
amirwolf is offline
Bugsy
AMX Mod X Moderator
Bugsy's Avatar
Join Date: Feb 2005
Location: NJ, USA
Old 12-29-2023 , 16:44   Re: Transfer vault information to SQL
Reply With Quote #13
Make sure to fill in the constants at the top (vault and DB info)

PHP Code:

#include <amxmodx>
#include <nvault_util>
#include <sqlx>

new const Version[] = "0.1";

new const VaultName[] = "YourVault";

new const DBHost[] = "";
new const DBUser[] = "";
new const DBPass[] = "";
new const DBName[] = "";

new g_Vault , Handle:g_SQLTuple;
new g_szAuthID[ 34 ] , g_szXP[ 4 ] , g_szLevel[ 4 ] , g_szNextXP[ 4 ] , g_szRank[ 16 ] , g_szNextRank[ 16 ];
new g_szBuffer[ 256 ];

public plugin_init() 
{
    register_plugin( "nVault to SQL" , Version , "bugsy" );
    register_concmd( "nvault_to_sql" , "nVault_to_SQL" );
}

public nVault_to_SQL()
{
    g_Vault = nvault_util_open( VaultName );
    
    SQL_SetAffinity( "mysql" );
    g_SQLTuple = SQL_MakeDbTuple( DBHost , DBUser , DBPass , DBName );
    
    nvault_util_readall( g_Vault , "nVault_to_SQL_Result" );
    
    nvault_util_close( g_Vault );
    SQL_FreeHandle( g_SQLTuple );
}

public nVault_to_SQL_Result( iCurrent , iTotal , const szKey[] , const szVal[] , iTimeStamp , const Data[] , iSize )
{
    //INSERT INTO `crxranks` (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('Steam_12345', 471, 3, 500, 'KilleR', 'HitMAN')
    
    parse( szVal , g_szAuthID , charsmax( g_szAuthID ) , 
            g_szXP , charsmax( g_szXP ) ,
            g_szLevel , charsmax( g_szXP ) ,
            g_szNextXP , charsmax( g_szNextXP ) ,
            g_szRank , charsmax( g_szRank ) ,
            g_szNextRank , charsmax( g_szNextRank ) );
    formatex( g_szBuffer , charsmax( g_szBuffer ) , "INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('%s', %s, %s, %s, '%s', '%s');" , g_szAuthID , g_szXP , g_szLevel , g_szNextXP , g_szRank , g_szNextRank );
    SQL_ThreadQuery( g_SQLTuple , "SQLCallBack" , g_szBuffer );
}

public SQLCallBack( FailState, Handle:Query , Error[] , Errcode, Data[] , DataSize )
{
    if ( Errcode )
    {
        set_fail_state( Error );
    }
} 
__________________
Last edited by Bugsy; 12-30-2023 at 02:18.
Bugsy is offline
amirwolf
Senior Member
amirwolf's Avatar
Join Date: Feb 2019
Location: Iran
Old 12-29-2023 , 18:00   Re: Transfer vault information to SQL
Reply With Quote #14
I am currently testing it on the local server
Information is not sent
There is no error!
__________________
amirwolf is offline
Bugsy
AMX Mod X Moderator
Bugsy's Avatar
Join Date: Feb 2005
Location: NJ, USA
Old 12-29-2023 , 18:06   Re: Transfer vault information to SQL
Reply With Quote #15
Above
SQL_ThreadQuery( g_SQLTuple , "SQLCallBack" , g_szBuffer );
Put
log_amx( g_szBuffer );

Run it and then check your log file to see if the SQL looks good.
__________________
Bugsy is offline
amirwolf
Senior Member
amirwolf's Avatar
Join Date: Feb 2019
Location: Iran
Old 12-29-2023 , 18:32   Re: Transfer vault information to SQL
Reply With Quote #16
Code:
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('19', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('3981', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('6', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('19', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('11', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('145', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('459', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('11', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('30', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('6188', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('13', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1463', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('553', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1324', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('14', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('22', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1175', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('30', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('902', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('82', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('11', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('11', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('342', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('454', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('34', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('215', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('294', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('14', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('10', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1613', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('75', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1057', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('22', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1350', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('115', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('23', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('240', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('85', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('79', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('22', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('382', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('102', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('110', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('121', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('2832', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('79', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('22', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('11', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('110', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('15', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('9', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('618', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('6', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('3831', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('11', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('8', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('467', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('1005', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('199', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('14', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('9', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('19445', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('19', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('5', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('10', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('58', , , , '', '');
L 12/30/2023 - 03:09:06: INSERT INTO crxranks (`Player`, `XP`, `Level`, `Next XP`, `Rank`, `Next Rank`) VALUES ('913', , , , '', '');
Code:
L 12/30/2023 - 03:09:06: [AMXX] Plugin ("test.amxx") is setting itself as failed.
L 12/30/2023 - 03:09:06: [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 ' , , '', '')' at line 1
L 12/30/2023 - 03:09:06: [AMXX] Run time error 1 (plugin "test.amxx") - forced exit
__________________
Last edited by amirwolf; 12-29-2023 at 18:44.
amirwolf is offline
Bugsy
AMX Mod X Moderator
Bugsy's Avatar
Join Date: Feb 2005
Location: NJ, USA
Old 12-29-2023 , 20:44   Re: Transfer vault information to SQL
Reply With Quote #17
Try setting the SQL affinity to MySQL instead of SQLite
__________________
Bugsy is offline
fysiks
Veteran Member
fysiks's Avatar
Join Date: Sep 2007
Location: Flatland, USA
Old 12-29-2023 , 21:28   Re: Transfer vault information to SQL
Reply With Quote #18
FYI, Bugsy, in your latest code, there is nothing to cause the execution of the code. I can only assume that amirwolf must have added something but if someone else tries to use the code it might not be so obvious. Having it as a server command might be better than have it being called automatically so it's harder to accidentally run it multiple times and cause conflicts in the database.
__________________
fysiks is offline
Bugsy
AMX Mod X Moderator
Bugsy's Avatar
Join Date: Feb 2005
Location: NJ, USA
Old 12-29-2023 , 21:43   Re: Transfer vault information to SQL
Reply With Quote #19
Quote:
Originally Posted by fysiks View Post
FYI, Bugsy, in your latest code, there is nothing to cause the execution of the code. I can only assume that amirwolf must have added something but if someone else tries to use the code it might not be so obvious. Having it as a server command might be better than have it being called automatically so it's harder to accidentally run it multiple times and cause conflicts in the database.
Ah yes, my bad.

@ OP

Add this to plugin_init()

register_concmd( “nvault_to_sql” , “nVault_to_SQL” );

Then execute nvault_to_sql from console.

The above plugin is updated
__________________
Last edited by Bugsy; 12-30-2023 at 02:19.
Bugsy is offline
amirwolf
Senior Member
amirwolf's Avatar
Join Date: Feb 2019
Location: Iran
Old 12-30-2023 , 06:24   Re: Transfer vault information to SQL
Reply With Quote #20
Quote:
Originally Posted by Bugsy View Post
Try setting the SQL affinity to MySQL instead of SQLite
Sorry, I don't understand this part very much, is there a link to teach it?
__________________
amirwolf is offline
Reply
AlliedModders Forum Index > AMX Mod X > Plugins > Suggestions / Requests
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 08:19.

DMCA - Archive - Top

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode