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

Converting nVault to Mysql


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Shadows Adi
AlliedModders Donor
Join Date: Aug 2019
Location: Romania
Old 07-17-2020 , 06:59   Converting nVault to Mysql
Reply With Quote #1

Hello,

If I have a plugin that is saving data in nvault format, can I make a separate plugin that takes the data from nvault from the other plugin and puts it in a mysql database and from there a site takes the data to display it?

A firend asks to write this for him.
__________________


Accepting Paid Requests, contact PM.

MVP Of The Round View project on GITHUB / AlliedModders
CSGO REMAKE ~ CSGO MOD [STABLE + SOURCE CODE]
Shadows Adi is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 07-17-2020 , 08:26   Re: Converting nVault to Mysql
Reply With Quote #2

Yes, you would use nvault utility to read all data from the vault and write to the database tables
__________________
Bugsy is online now
Shadows Adi
AlliedModders Donor
Join Date: Aug 2019
Location: Romania
Old 07-17-2020 , 08:32   Re: Converting nVault to Mysql
Reply With Quote #3

Thanks for answer.
__________________


Accepting Paid Requests, contact PM.

MVP Of The Round View project on GITHUB / AlliedModders
CSGO REMAKE ~ CSGO MOD [STABLE + SOURCE CODE]
Shadows Adi is offline
Rohanlogs
Senior Member
Join Date: Nov 2015
Old 07-17-2020 , 16:52   Re: Converting nVault to Mysql
Reply With Quote #4

Quote:
Originally Posted by Bugsy View Post
Yes, you would use nvault utility to read all data from the vault and write to the database tables
How about the queries if there are many entries? Like thousands?
If you loop through all of the nvault data and execute a query on every loop I'm pretty sure the server will crash.
I'm not aware of any mass query transaction func in amxx, sourcemod has it.
You could try stacked queries but idk if amxx can handle it.

However before any sweaty searching I could help you doing something like saving all the data in a .txt file and use Python to query them into the database.
__________________
Rohanlogs is offline
Shadows Adi
AlliedModders Donor
Join Date: Aug 2019
Location: Romania
Old 07-17-2020 , 17:29   Re: Converting nVault to Mysql
Reply With Quote #5

My friend has a plugin that stores the data in nvault (he doesn't have the source code) he wants a plugin that takes the data from nvault of the other plugin and uploads them in a database, where they can be displayed on a website
__________________


Accepting Paid Requests, contact PM.

MVP Of The Round View project on GITHUB / AlliedModders
CSGO REMAKE ~ CSGO MOD [STABLE + SOURCE CODE]
Shadows Adi is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 07-17-2020 , 21:57   Re: Converting nVault to Mysql
Reply With Quote #6

I would recommend converting the plugin to use a database instead of nVault. This will be more efficient than using nvault and transferring data to the database to be consumed by the website.
__________________
Bugsy is online now
Reply



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 10:56.


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