I am almost positive the issue is with SQLite, as I have never worked with it before and I am not getting any lua errors.
I also created a console command to manually save the stats. This does return a saveStats does not exist error (saveStats is a function in the database)
The database is in a separate file. The database is included in the init code. The PLayerInitialSpawn function in the database is called in the init file under the GM function of the same name, but while no errors appear, neither do the messages.
Alternately, if anyone knows a simpler way to store player data on a server, that would be great.
[code]
function sql_value_stats ( ply )
unique_id = sql.QueryValue("SELECT unique_id FROM player_info WHERE unique_id = '"..steamID.."'")
money = sql.QueryValue("SELECT money FROM player_info WHERE unique_id = '"..steamID.."'")
ply:SetNWString("unique_id", unique_id)
ply:SetNWInt("money", money)
end
function sql_value_skills ( ply ) --assign skills when a player joins (but has skill data)
unique_id = sql.QueryValue("SELECT unique_id FROM player_skills WHERE unique_id = '"..steamID.."'")
ply:SetNWString("unique_id", unique_id)
--SKILL = sql.QueryValue("SELECT SKILL FROM player_skills WHERE unique_id = '"..steamID.."'")
--ply:SetNWInt("SKILL", SKILL)
--Get The Skills
--Misc Skills
health = sql.QueryValue("SELECT health FROM player_skills WHERE unique_id = '"..steamID.."'")
if health < 100 then
health = 100
end
regeneration = sql.QueryValue("SELECT regeneration FROM player_skills WHERE unique_id = '"..steamID.."'")
maxstamina = sql.QueryValue("SELECT maxstamina FROM player_skills WHERE unique_id = '"..steamID.."'")
medical = sql.QueryValue("SELECT medical FROM player_skills WHERE unique_id = '"..steamID.."'")
damagereduction = sql.QueryValue("SELECT damagereduction FROM player_skills WHERE unique_id = '"..steamID.."'")
--Power Weapons
Powerrecoil = sql.QueryValue("SELECT Powerrecoil FROM player_skills WHERE unique_id = '"..steamID.."'")
Powerdamage = sql.QueryValue("SELECT Powerdamage FROM player_skills WHERE unique_id = '"..steamID.."'")
Poweraccuracy = sql.QueryValue("SELECT Poweraccuracy FROM player_skills WHERE unique_id = '"..steamID.."'")
Powerreload = sql.QueryValue("SELECT Powerreload FROM player_skills WHERE unique_id = '"..steamID.."'")
Powerironsight = sql.QueryValue("SELECT Powerironsight FROM player_skills WHERE unique_id = '"..steamID.."'")
Powershove = sql.QueryValue("SELECT Powershove FROM player_skills WHERE unique_id = '"..steamID.."'")
Powerlunge = sql.QueryValue("SELECT Powerlunge FROM player_skills WHERE unique_id = '"..steamID.."'")
--Precision Weapons
Precisionrecoil = sql.QueryValue("SELECT Precisionrecoil FROM player_skills WHERE unique_id = '"..steamID.."'")
Precisiondamage = sql.QueryValue("SELECT Precisiondamage FROM player_skills WHERE unique_id = '"..steamID.."'")
Precisionaccuracy = sql.QueryValue("SELECT Precisionaccuracy FROM player_skills WHERE unique_id = '"..steamID.."'")
Precisionreload = sql.QueryValue("SELECT Precisionreload FROM player_skills WHERE unique_id = '"..steamID.."'")
Precisionironsight = sql.QueryValue("SELECT Precisionironsight FROM player_skills WHERE unique_id = '"..steamID.."'")
Precisionshove = sql.QueryValue("SELECT Precisionshove FROM player_skills WHERE unique_id = '"..steamID.."'")
Precisionlunge = sql.QueryValue("SELECT Precisionlunge FROM player_skills WHERE unique_id = '"..steamID.."'")
--Light Weapons
Lightrecoil = sql.QueryValue("SELECT Lightrecoil FROM player_skills WHERE unique_id = '"..steamID.."'")
Lightdamage = sql.QueryValue("SELECT Lightdamage FROM player_skills WHERE unique_id = '"..steamID.."'")
Lightaccuracy = sql.QueryValue("SELECT Lightaccuracy FROM player_skills WHERE unique_id = '"..steamID.."'")
Lightreload = sql.QueryValue("SELECT Lightreload FROM player_skills WHERE unique_id = '"..steamID.."'")
Lightironsight = sql.QueryValue("SELECT Lightironsight FROM player_skills WHERE unique_id = '"..steamID.."'")
Lightshove = sql.QueryValue("SELECT Lightshove FROM player_skills WHERE unique_id = '"..steamID.."'")
Lightlunge = sql.QueryValue("SELECT Lightlunge FROM player_skills WHERE unique_id = '"..steamID.."'")
--Shotgun Weapons
Shotgunrecoil = sql.QueryValue("SELECT Shotgunrecoil FROM player_skills WHERE unique_id = '"..steamID.."'")
Shotgundamage = sql.QueryValue("SELECT Shotgundamage FROM player_skills WHERE unique_id = '"..steamID.."'")
Shotgunaccuracy = sql.QueryValue("SELECT Shotgunaccuracy FROM player_skills WHERE unique_id = '"..steamID.."'")
Shotgunreload = sql.QueryValue("SELECT Shotgunreload FROM player_skills WHERE unique_id = '"..steamID.."'")
Shotgunironsight = sql.QueryValue("SELECT Shotgunironsight FROM player_skills WHERE unique_id = '"..steamID.."'")
Shotgunshove = sql.QueryValue("SELECT Shotgunshove FROM player_skills WHERE unique_id = '"..steamID.."'")
Shotgunlunge = sql.QueryValue("SELECT ShotgunlungeFROM player_skills WHERE unique_id = '"..steamID.."'")
--Explosives Weapons
Explosivesrecoil = sql.QueryValue("SELECT Explosivesrecoil FROM player_skills WHERE unique_id = '"..steamID.."'")
Explosivesdamage = sql.QueryValue("SELECT Explosivesdamage FROM player_skills WHERE unique_id = '"..steamID.."'")
Explosivesaccuracy = sql.QueryValue("SELECT Explosivesaccuracy FROM player_skills WHERE unique_id = '"..steamID.."'")
Explosivesreload = sql.QueryValue("SELECT Explosivesreload FROM player_skills WHERE unique_id = '"..steamID.."'")
Explosivesironsight = sql.QueryValue("SELECT Explosivesironsight FROM player_skills WHERE unique_id = '"..steamID.."'")
--Melee Weapons
Meleedamage = sql.QueryValue("SELECT Meleedamage FROM player_skills WHERE unique_id = '"..steamID.."'")
Meleeattackspeed = sql.QueryValue("SELECT Meleeattackspeed FROM player_skills WHERE unique_id = '"..steamID.."'")
Meleeshove = sql.QueryValue("SELECT Meleeshove FROM player_skills WHERE unique_id = '"..steamID.."'")
Meleelunge = sql.QueryValue("SELECT Meleelunge FROM player_skills WHERE unique_id = '"..steamID.."'")
--Get The Skills Experience
--Misc Skills
healthExper = sql.QueryValue("SELECT healthEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
regenerationExper = sql.QueryValue("SELECT regenerationEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
maxstaminaExper = sql.QueryValue("SELECT maxstaminaEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
medicalExper = sql.QueryValue("SELECT medicalEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
damagereductionExper = sql.QueryValue("SELECT damagereductionEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
--Power Weapons
PowerrecoilExper = sql.QueryValue("SELECT PowerrecoilEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PowerdamageExper = sql.QueryValue("SELECT PowerdamageEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PoweraccuracyExper = sql.QueryValue("SELECT PoweraccuracyEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PowerreloadExper = sql.QueryValue("SELECT PowerreloadEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PowerironsightExper = sql.QueryValue("SELECT PowerironsightEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PowershoveExper = sql.QueryValue("SELECT PowershoveEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PowerlungeExper = sql.QueryValue("SELECT PowerlungeEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
--Precision Weapons
PrecisionrecoilExper = sql.QueryValue("SELECT PrecisionrecoilEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PrecisiondamageExper = sql.QueryValue("SELECT PrecisiondamageEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PrecisionaccuracyExper = sql.QueryValue("SELECT PrecisionaccuracyEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PrecisionreloadExper = sql.QueryValue("SELECT PrecisionreloadEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PrecisionironsightExper = sql.QueryValue("SELECT PrecisionironsightEXP FROM player_skills WHERE unique_id = '"..steamID.."'")
PrecisionshoveExper = sql.
so many NWVars, it will lag like shit
Sorry, you need to Log In to post a reply to this thread.
