local function mysql_value_char ( ply )
unique_id = mysql.Query("SELECT unique_id FROM player_info WHERE unique_id = '"..SteamID.."'");
name = mysql.Query(db, "SELECT name FROM player_info WHERE unique_id = '"..SteamID.."'");
age = mysql.Query(db, "SELECT age FROM player_info WHERE unique_id = '"..SteamID.."'");
model = mysql.Query(db, "SELECT model FROM player_info WHERE unique_id = '"..SteamID.."'");
strengh = mysql.Query(db, "SELECT strengh FROM player_info WHERE unique_id = '"..SteamID.."'");
endurance = mysql.Query(db, "SELECT endurance FROM player_info WHERE unique_id = '"..SteamID.."'");
speed = mysql.Query(db, "SELECT speed FROM player_info WHERE unique_id = '"..SteamID.."'");
aim = mysql.Query(db, "SELECT aim FROM player_info WHERE unique_id = '"..SteamID.."'");
money = mysql.Query(db, "SELECT money FROM player_info WHERE unique_id = '"..SteamID.."'");
-------------------------------
ply:SetNWString("unique_id", unique_id);
ply:SetNWString("name", name);
ply:SetNWInt("age", age);
ply:SetNWString("model", model);
ply:SetNWInt("strengh", strengh);
ply:SetNWInt("endurance", endurance);
ply:SetNWInt("speed", speed);
ply:SetNWInt("aim", aim);
ply:SetNWInt("money", money);
-------------------------------
Msg(""..unique_id.."");
Msg(""..name.."");
Msg(""..money.."");
Msg(""..model.."");
end
local function SaveStat ( ply )
money = ply:GetNWInt("money");
unique_id = ply:GetNWString("unique_id");
name = ply:GetNWString("name");
age = ply:GetNWInt("age");
model = ply:GetNWString("model");
strengh = ply:GetNWInt("strengh");
endurance = ply:GetNWInt("endurance");
speed = ply:GetNWInt("speed");
aim = ply:GetNWInt("aim");
mysql.Query(db, "UPDATE player_info SET money = "..money..", name = "..name..", age = "..age..", model = "..model..", strengh = "..strengh..", endurance = "..endurance..", speed = "..speed..", aim = "..aim.." WHERE unique_id = '"..unique_id.."'");
ply:ChatPrint("Your Character has been updated!");
end
function player_exists( ply )
SteamID = ply:GetNWString("SteamID")
result = mysql.Query(db, "SELECT unique_id, money, name, age, model, strengh, endurance, speed, aim FROM player_info WHERE unique_id = '"..SteamID.."'");
if (result) then
mysql_value_char( ply );
else
ply:PrintChat("Player does not exist! Please create one though the Character Create window!");
end
end
function Initialize()
tables_exist()
end
function PlayerInitialSpawn( ply )
timer.Create("Steam_id_delay", 1, 1, function()
SteamID = ply:SteamID();
ply:SetNWString("SteamID", SteamID);
timer.Create("SaveStat", 10, 0, function() saveStat( ply ) end);
player_exists( ply );
end)
end
hook.Add( "PlayerInitialSpawn", "PlayerInitialSpawn", PlayerInitialSpawn )
hook.Add( "Initialize", "Initialize", Initialize )