Subscribe to download
Compact Inventory

I got as far as getting another table inserted into the SQL database and getting it populated with data, but it was indeed a copy of the first primary. But I think I learned something that day, about the second primary being classified as a weapon upgrade. So I think I will try to save it to the database in this fashion: while primary if weaponupgrade then insert upgradeprimary, something like that should save the excess data spilling off into nowhere currently. I suspect I will get it working just a matter of time now. Some plugins actually track the players ammo for when respawned, to restore the entire loadout... completely. It's a back and forth effort but I really have nothing better to do right now.

And thanks.

good luck with second primary slot.

Oh I did forget to mention, I had to obviously add the database by name into the databases.cfg file as prescribed below (for other dummies such as myself), but even so, without the additional SQL code inserted into the plugin file, there was still no connection to the database.

"saveloadouts"
{
"driver" "sqlite"
"host" "xxx.xxx.xxx.xxx" //(server IP address here)
"database" "saveloadout"
//"timeout" "0"
"port" "3306"
}

All is working, now, for a few days without issues. Including the true/false per class template and capturing the contents linked to each steamID.

I am talking about the source mod plugin itself. The plugin was failing to reload the loadouts for players when they changed role or left the server and returned. Savelo was only functioning locally and only in the currently chosen squad role. So I added some SQL lines to the sp file and changed an "if" to a "while" and was able to get it working.

Also, I found https://inloop.github.io/sqlite-viewer/ to be a much, much lighter DB viewer. Open source and 0 downloads.

Now I intend to extend the plugin by figuring out how second primary and secondary weapons are assigned using subslots or upgrade slots via sling types, and make savelo also create/select table entries for those as well if it detects a sling type mod installed by theater vpk.

Add me if you still have questions.

Are you talking about "Compact Inventory" or "save loadout" sm plugiin? A few servers use save loadout plugin without problems. Use sqlitebrowser.org to see the db.

Update for people with similar issues:

The SQL was not completely configured. I had to add a TConnect at plugin start and also change one of the if rs.FetchRow to a while rs.MoreRows or something like that I can't remember at this moment.

I do have now in my possession a working smx and sp file that links to a SQLiteDB which functions after you leave and rejoin the server.

Now, how do we go about saving the data for the weapon subslots? I looked into it a little bit and it appears they are actually just upgrade slots... correct me if I am wrong... we should still be able to grab the upgrade slot for the second primary and secondary if we know which number defines their slot...

Hi Bot Chris, I am having trouble getting the sourcemod plugin file to work completely on our server. The issue I am having is that, in our server the plugin only works on the current game session. If you leave and come back, the loadout is back to the default theater loadout and does not return when clicking RESET. Is this a common issue and is there any way to force the SQL database on the server to be recognized by the clients? I can see the data in the .sq file but I do not have the appropriate tool it seems to open that file to see the format completely. I do see bits and pieces, SteamIDs and such. Any help is appreciated.

i see, thanks

there is no other way from client side.