Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql:Connect("localhost", "root", "", "bleach", 3306);
- local meta = FindMetaTable( "Player" )
- net.Receive( "BleachRecieveCharacter", function( len, ply )
- local name = net.ReadString()
- local description = net.ReadString()
- local division = net.ReadString()
- local division = tonumber(division)
- ply:CreateCharacter( name, description, division)
- end )
- concommand.Add("hey", function(ply)
- --[[ --]]
- queryObj = mysql:Create("characterinfo");
- queryObj:Create("characterid", "INT NOT NULL");
- queryObj:Create("division", "INT NOT NULL");
- queryObj:Create("seat", "INT NOT NULL");
- queryObj:Create("name", "VARCHAR(255) NOT NULL");
- queryObj:Create("description", "VARCHAR(255) NOT NULL");
- queryObj:Create("items", "VARCHAR(255) NOT NULL");
- queryObj:Create("reiatsu", "INT NOT NULL");
- queryObj:Create("ken", "INT NOT NULL");
- queryObj:Create("steam_id", "VARCHAR(25) NOT NULL AUTO_INCREMENT");
- queryObj:PrimaryKey("steam_id");
- queryObj:Execute();
- --[[
- local insertObj = mysql:Insert("characterinfo");
- insertObj:Insert("characterid", 1);
- insertObj:Insert("name", "Ichigo");
- insertObj:Insert("description", "Stronk");
- insertObj:Insert("seat", 20);
- insertObj:Insert("division", 1);
- insertObj:Insert("reiatsu", 125000);
- insertObj:Insert("ken", 350000);
- insertObj:Insert("items", "another_zanpakto");
- insertObj:Insert("steam_id", ply:SteamID());
- insertObj:Execute();
- --]]
- PrintTable(Zanpakto)
- end)
- function CreateSeat(ply)
- local insertObj = mysql:Insert("characterinfo");
- insertObj:Insert("seat", 20);
- insertObj:Insert("steam_id", ply:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print(string.format("Seat created for ", ply:Name()));
- end);
- insertObj:Execute();
- end
- function UpdateSeat(ply)
- local insertObj = mysql:Update("characterinfo");
- insertObj:Update("seat", ply.CurrentSeat);
- insertObj:Where("steam_id", ply:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print("is now updated in mysql for seat");
- end);
- insertObj:Execute();
- end
- function Getseat(ply)
- local queryObj = mysql:Select("characterinfo");
- queryObj:Select("seat")
- queryObj:Where("steam_id", ply:SteamID());
- queryObj:Callback(function(result, status, lastID)
- if (type(result) == "table" and #result > 0) then
- PrintTable(result)
- ply.CurrentSeat = result[1].seat
- if ply.CurrentSeat >= 2 then
- if ply.CurrentSeat == 1 then
- Divisions[tonumber(ply.CurrentDivision)].Seat[ply.CurrentSeat].Captain = ply
- else
- Divisions[tonumber(ply.CurrentDivision)].Seat[ply.CurrentSeat].Lieutenant = ply
- end
- else
- table.insert(Divisions[tonumber(ply.CurrentDivision)].Seat[ply.CurrentSeat], ply)
- end
- else
- CreateSeat(ply)
- ply.CurrentSeat = 20
- end;
- end);
- queryObj:Execute();
- end
- -- reiatsu
- function CreateReiatsu(ply)
- local insertObj = mysql:Insert("characterinfo");
- insertObj:Insert("reiatsu", 10);
- insertObj:Insert("steam_id", ply:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print(string.format("Reiatsu created for ", ply:Name()));
- end);
- insertObj:Execute();
- end
- function UpdateReiatsu(ply)
- local insertObj = mysql:Update("characterinfo");
- insertObj:Update("reiatsu", ply.reiatsu);
- insertObj:Where("steam_id", ply:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print("is now updated in mysql for reiatsu");
- end);
- insertObj:Execute();
- end
- function GetReiatsu(ply)
- local queryObj = mysql:Select("characterinfo");
- queryObj:Select("reiatsu")
- queryObj:Where("steam_id", ply:SteamID());
- queryObj:Callback(function(result, status, lastID)
- if (type(result) == "table" and #result > 0) then
- PrintTable(result)
- local rei = result[1].reiatsu
- ply.reiatsu = rei
- else
- CreateReiatsu(ply)
- ply.CurrentReiatsu = 10
- ply.reiatsu = 10
- end;
- end);
- queryObj:Execute();
- end
- -- kan
- function CreateKan(ply)
- local insertObj = mysql:Insert("characterinfo");
- insertObj:Insert("kan", 100);
- insertObj:Insert("steam_id", ply:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print(string.format("kan created for ", ply:Name()));
- end);
- insertObj:Execute();
- end
- function UpdateKan(ply)
- local insertObj = mysql:Update("characterinfo");
- insertObj:Update("kan", ply.kan);
- insertObj:Where("steam_id", ply:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print("is now updated in mysql for kan");
- end);
- insertObj:Execute();
- end
- function GetKan(ply)
- local queryObj = mysql:Select("characterinfo");
- queryObj:Select("kan")
- queryObj:Where("steam_id", ply:SteamID());
- queryObj:Callback(function(result, status, lastID)
- if (type(result) == "table" and #result > 0) then
- PrintTable(result)
- local currnen = result[1].kan
- ply.kan = currnen
- else
- CreateKan(ply)
- ply.kan = 100
- end;
- end);
- queryObj:Execute();
- end
- function meta:CreateCharacter(name, description, division)
- local insertObj = mysql:Insert("characterinfo");
- insertObj:Insert("kan", 100);
- insertObj:Insert("name", name);
- insertObj:Insert("description", description);
- insertObj:Insert("items", "none");
- insertObj:Insert("reiatsu", 10);
- insertObj:Insert("characterid", 1);
- insertObj:Insert("division", division);
- insertObj:Insert("seat", 20);
- insertObj:Insert("steam_id", self:SteamID());
- insertObj:Callback(function(result, status, lastID)
- print("Character created for ".. tostring(self));
- self.kan = 100
- self.CurrentReiatsu = 10
- self.reiatsu = 10
- self.CurrentSeat = 20
- self.CurrentDivision = division
- table.insert(Divisions[tonumber(division)].Seat[20], self)
- end);
- insertObj:Execute();
- end
- function meta:GetCharacter()
- local queryObj = mysql:Select("characterinfo");
- queryObj:Select("kan")
- queryObj:Select("name")
- queryObj:Select("description")
- queryObj:Select("items")
- queryObj:Select("reiatsu")
- queryObj:Select("characterid")
- queryObj:Select("division")
- queryObj:Select("seat")
- queryObj:Where("steam_id", self:SteamID());
- queryObj:Callback(function(result, status, lastID)
- if (type(result) == "table" and #result > 0) then
- --if found do
- self.characters = {}
- self.characters[result[1].characterid] = {
- name = result[1].name,
- description = result[1].description,
- kan = result[1].kan,
- reiatsu = result[1].reiatsu,
- characterid = result[1].characterid,
- division = result[1].division,
- items = result[1].items,
- seat = result[1].seat
- }
- self.CurrentReiatsu = result[1].reiatsu
- self.reiatsu = result[1].reiatsu
- self.kan = result[1].kan
- PrintTable(self.characters)
- self.CurrentSeat = result[1].seat
- self.CurrentDivision = result[1].division
- print("Current Division" .. tostring(self.CurrentDivision))
- print("Current Seat" .. tostring(self.CurrentSeat))
- if self.CurrentSeat >= 2 then
- if self.CurrentSeat == 1 then
- Divisions[tonumber(self.CurrentDivision)].Seat[self.CurrentSeat].Captain = self
- end
- if self.CurrentSeat == 2 then
- Divisions[tonumber(self.CurrentDivision)].Seat[self.CurrentSeat].Lieutenant = self
- end
- end
- if self.CurrentSeat >= 3 then
- print("YESAA")
- table.insert(Divisions[tonumber(self.CurrentDivision)].Seat[self.CurrentSeat], self)
- end
- else
- --if not found do
- print("Character needs to be created for ".. tostring(self))
- net.Start("BleachCreateCharacter")
- net.WriteEntity(self)
- net.Send(self)
- end;
- end);
- queryObj:Execute();
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement