private void API_onResourceStart()
{
API.requestIpl("SP1_10_real_interior");
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gtanserver;port=3306;password=;");
_userRepository = _database.Connection().As <IUserRepository>();
}
public Instructor InsertInstructor(Instructor instructor)
{
IList <UInt64> res = db.Connection().QuerySql <UInt64>(
string.Format("INSERT INTO `instructor` (name, birth_date, graduation_date, subject, bio) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}');SELECT LAST_INSERT_ID();",
instructor.name,
instructor.birth_date.ToString("yyyy-MM-dd"),
instructor.graduation_date.ToString("yyyy-MM-dd"),
instructor.subject,
instructor.bio.Replace("'", "\\'")
)
);
// Converting New ID to the instructor Int ID
instructor.id = Convert.ToInt32(res[0]);
return(instructor);
}
public Veh(string name, int ownerId)
{
Random r = new Random();
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gtanserver;port=3306;password=;");
_vehicleRepository = _database.Connection().As <IVehicleRepository>();
int vin = r.Next(100000, 1000000);
List <Veh> temp = _vehicleRepository.GetVehicleByVin(vin);
while (temp.Count > 0)
{
vin = r.Next(100000, 1000000);
temp = _vehicleRepository.GetVehicleByVin(vin);
}
// create a plate with 3 random numbers and 3 random letters and make sure it isnt already taken
string letters = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
string plate = r.Next(0, 10).ToString() + r.Next(0, 10).ToString() + r.Next(0, 10).ToString() + " " + letters[r.Next(0, 26)].ToString() + letters[r.Next(0, 26)].ToString() + letters[r.Next(0, 26)].ToString();
temp = _vehicleRepository.GetVehicleByPlate(plate);
while (temp.Count > 0)
{
plate = r.Next(0, 10).ToString() + r.Next(0, 10).ToString() + r.Next(0, 10).ToString() + " " + letters[r.Next(0, 26)].ToString() + letters[r.Next(0, 26)].ToString() + letters[r.Next(0, 26)].ToString();
temp = _vehicleRepository.GetVehicleByPlate(plate);
}
this.Plate = plate;
this.Vin = vin;
this.Inventory = "{}";
this.Name = name;
this.OwnerId = ownerId;
this.Handle = 0;
}
public bool playerHasAccessToVehicle(int charId, string plate)
{
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gtanserver;port=3306;password=;");
_vehicleRepository = _database.Connection().As <IVehicleRepository>();
List <Veh> vehs = _vehicleRepository.GetVehicleByPlate(plate);
return(charId == vehs[0].OwnerId);
}
private void ResourceStart()
{
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder(
"server=localhost;user=root;database=newserver;port=3306;password=;"
);
_userRepository = _database.Connection().As <IUserRepository>();
}
private void myResourceStart()
{
API.consoleOutput("[------------------------------------------]");
API.consoleOutput("[ Frosty Cops n Robbers ]");
API.consoleOutput("[ Version 0.0.1 ]");
API.consoleOutput("[ Created by VirtualFrost ]");
API.consoleOutput("[------------------------------------------]");
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=frosty-cnr;port=3306;password=;");
_userRepository = _database.Connection().As <IUserRepository>();
}
public User InsertUser(User user)
{
string student = "null";
string instructor = "null";
if (user.student != null)
{
user.student = Global.studentRepo.InsertStudent(user.student);
student = user.student.id + ""; // Creating New Student and converting his ID to String
}
else if (user.instructor != null)
{
user.instructor = Global.instructorRepo.InsertInstructor(user.instructor);
instructor = user.instructor.id + ""; // Creating New Instructor and converting his ID to String
}
IList <UInt64> res = db.Connection().QuerySql <UInt64>(
string.Format("INSERT INTO `user` (username, email, password, create_date, citizen_id, image_url, student_id, instructor_id) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, {7});SELECT LAST_INSERT_ID();",
user.username,
user.email,
user.getEncryptedPassword(),
user.create_date.ToString("yyyy-MM-dd"),
user.citizen_id,
user.image_url,
student,
instructor
)
);
// Converting New ID to the user Int ID
user.id = Convert.ToInt32(res[0]);
return(user);
}
public void API_onResourceStart()
{
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gamemode;port=3306;password=;");
_userRepository = _database.Connection().As <IUserRepository>();
ContextFactory.SetConnectionParameters("127.0.0.1", "root", "", "gamemode");
var uniqueUsers = ContextFactory.Instance.Users.Count();
API.consoleOutput("Unique Accounts: " + uniqueUsers);
var uniqueChars = ContextFactory.Instance.Characters.Count();
API.consoleOutput("Character Count: " + uniqueChars);
}
public void OnResourceStart()
{
// set up database connection
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gtanserver;port=3306;password="******"GAS_STATION");
// get delivery locations, convert to Vector3's, and create col shapes
// also save id in colshape entity data
foreach (var station in gasStations)
{
dynamic d = API.fromJson(station.DeliverLocation);
Vector3 pos = new Vector3((float)d.X, (float)d.Y, (float)(d.Z - 1));
var shape = API.createCylinderColShape(pos, 4, 8);
shape.setData("ID", station.Id);
// add shapes to list
deliveryColShapes.Add(shape);
}
// initailize list of tanker models
tankerModels.Add(-730904777);
tankerModels.Add(1956216962);
tankerModels.Add(-1207431159);
// synchronize list of contracts
contracts = ArrayList.Synchronized(contractsAsync);
// set up start job start blip, shape, etc...
var jobStartPos = new Vector3(1383.331, -2079.071, 51.99853 + 1);
var jobStartTextPos = new Vector3(1383.331, -2079.071, 51.99853 + 1.5);
jobStartShape = API.createSphereColShape(jobStartPos, 3f);
var jobStartMarker = API.createMarker(20, jobStartPos, new Vector3(), new Vector3(180, 0, -25), new Vector3(1, 1, 1), 150, 0, 0, 255, 0);
var jobStartTextLabel = API.createTextLabel("~b~ Trucking Job: Gas", jobStartTextPos, 100f, 0.3f, true);
var jobStartBlip = API.createBlip(jobStartMarker);
API.setBlipSprite(jobStartBlip, 477);
API.setBlipColor(jobStartBlip, 26);
API.setBlipName(jobStartBlip, "Trucking Job: Gas");
// create job return shape
jobEndPos = new Vector3(1361, -2066, 52);
jobEndShape = API.createSphereColShape(jobEndPos, 4f);
}
public Student InsertStudent(Student student)
{
IList <UInt64> res = db.Connection().QuerySql <UInt64>(
string.Format("INSERT INTO `student` (name, gpa, status, level) VALUES ('{0}', {1}, '{2}', {3});SELECT LAST_INSERT_ID();",
student.name,
student.gpa,
student.status,
student.level
)
);
// Converting New ID to the student Int ID
student.id = Convert.ToInt32(res[0]);
return(student);
}
public Vehicle createVehicleHelper(VehicleHash model, Vector3 pos, Vector3 rot, int ownerId = 0)
{
Random r = new Random();
int color = r.Next(0, 160);
Vehicle vehicle = API.createVehicle(model, pos, rot, color, color);
Veh veh = new Veh(API.getVehicleDisplayName(model), ownerId);
veh.Handle = vehicle.handle.Value;
// trigger client event to stream number plate info
API.setVehicleNumberPlate(vehicle, veh.Plate);
API.setVehicleEngineStatus(vehicle, false);
API.sendNativeToAllPlayers(Hash.SET_VEHICLE_DOORS_LOCKED, API.getEntityFromHandle <Vehicle>(vehicle), 2);
API.setEntityData(vehicle, "JSON_DATA", API.toJson(veh));
API.setEntitySyncedData(vehicle, "PLATE", veh.Plate);
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gtanserver;port=3306;password=;");
_vehicleRepository = _database.Connection().As <IVehicleRepository>();
_vehicleRepository.AddNewVehicle(veh);
return(vehicle);
}
private void API_onResourceStart()
{
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder("server=x;user=x;database=x;password=x");
_userRepository = _database.Connection().As <IUserRepository>();
}
public void OnResourceStart()
{
MySqlInsightDbProvider.RegisterProvider();
_database = new MySqlConnectionStringBuilder("server=localhost;user=root;database=gtanserver;port=3306;password=;");
_vehicleRepository = _database.Connection().As <IVehicleRepository>();
}
private void ResourceStop()
{
_database.Connection().Close();
}
private void API_onClientEventTrigger(Client player, string eventName, params object[] args)
{
if (eventName == "log_in")
{
string username = args[0].ToString();
string password = args[1].ToString();
UserAccount account = _userRepository.GetAccount(username);
if (account == null)
{
API.triggerClientEvent(player, "invalid_username_or_password");
return;
}
bool isPasswordCorrect = BCr.BCrypt.Verify(password, account.Hash);
if (isPasswordCorrect)
{
// get users characters
_characterRepository = _database.Connection().As <ICharacterRepository>();
charList = _characterRepository.GetAllCharactersWithOwnerId(account.Id);
// move player to char select location
API.setEntityPositionFrozen(player, false);
API.setEntityCollisionless(player, false);
API.setEntityTransparency(player, 255);
API.setEntityRotation(player, new Vector3(0, 0, -15));
API.setEntityPosition(player, new Vector3(-235.4913, -2002.9574, 24.6));
API.triggerClientEvent(player, "login_successful", API.toJson(charList));
}
else
{
API.triggerClientEvent(player, "invalid_username_or_password");
}
}
else if (eventName == "register")
{
string username = args[0].ToString();
string password = args[1].ToString();
// check to see if username already exists
UserAccount account = _userRepository.GetAccount(username);
if (account != null)
{
API.triggerClientEvent(player, "register_username_taken");
}
else
{
var hash = BCr.BCrypt.HashPassword(password, BCr.BCrypt.GenerateSalt(12));
account = new UserAccount
{
Username = username,
Hash = hash
};
_userRepository.RegisterAccount(account);
API.triggerClientEvent(player, "registration_successful");
}
}
else if (eventName == "choose_existing_character")
{
dynamic c = charList[(int)args[0]];
API.setEntityData(player.handle, "CHAR_ID", c.Id);
API.setEntitySyncedData(player.handle, "LOGGED_IN", true);
API.setEntityPosition(player, new Vector3(-45.70197, -1680.367, 29.4101));
API.sendChatMessageToPlayer(player, "Logged in as " + c.Name + " with ID: " + c.Id.ToString());
}
}
