API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 15th, 2018
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 14.17 KB | None | 0 0
raw download clone embed print report
  1.  public static void SaveCharacter(Client player)
  2.     {
  3.         if (player.GetData("status") == true)
  4.         {
  5.             using (MySqlConnection Mainpipeline = new MySqlConnection(Main.myConnectionString))
  6.             {
  7.                 try
  8.                 {
  9.                     Mainpipeline.Open();
  10.                     string query = "UPDATE characters SET name = @name, money = @money, bank = @bank, salary = @salary, char_position_x = @char_position_x, char_position_y = @char_position_y, char_position_z = @char_position_z, char_rotation_z = @char_rotation_z, char_torso = @char_torso, char_undershirt = @char_undershirt, char_undershirt_texture = @char_undershirt_texture, char_leg = @char_leg, char_leg_texture = @char_leg_texture, char_feet = @char_feet, char_feet_texture = @char_feet_texture, char_shirt = @char_shirt, char_shirt_texture = @char_shirt_texture, char_mask = @char_mask, char_mask_texture = @char_mask_texture, ";
  11.                     query = query + " `business_key` = @business_key, `group` = @group, `group_rank` = @group_rank, `job` = @job, `thirsty` = @thirsty, `hunger` = @hunger, `wanted` = @wanted, `last_crime` = @last_crime, `prison` = @prison, `prison_cell` = @prison_cell, `prison_time` = @prison_time, `hospital` = @hospital, `death` = @death, `death_seconds` = death_seconds, `leader` = @leader, `level` = @level, `exp` = @exp, ";
  12.                     query = query + "char_outfit = @char_outfit, char_outfit_duty = @char_outfit_duty, char_dimension = @char_dimension, inside_house = @inside_house, peixe_0 = @peixe_0, peixe_1 = @peixe_1, peixe_2 = @peixe_2, peixe_3 = @peixe_3, peixe_4 = @peixe_4, peixe_5 = @peixe_5, peixe_6 = @peixe_6, peixe_7 = @peixe_7, peixe_8 = @peixe_8, peixe_9 = @peixe_9, `ooc_prison_time` = @ooc_prison_time, `ooc_warning` = @ooc_warning, `ooc_mute_newbie` = @ooc_mute_newbie,";
  13.                     query = query + "`char_armor` = @char_armor, `char_armor_texture` = @char_armor_texture, `duty` = @duty, ammo_handguns = @ammo_handguns, ammo_machineguns = @ammo_machineguns, ammo_assaultrifles = @ammo_assaultrifles, ammo_sniperrifles = @ammo_sniperrifles, ammo_shotguns = @ammo_shotguns, `car_lic` = @car_lic, `truck_lic` = @truck_lic, `fly_lic` = @fly_lic, `fish_lic` = @fish_lic, `taxi_lic` = @taxi_lic, `gun_lic` = @gun_lic, ";
  14.                     query = query + "`character_hats` = @character_hats, `character_hats_texture` = @character_hats_texture, `character_glasses` = @character_glasses, `character_glasses_texture` = @character_glasses_texture, `character_ears` = @character_ears, `character_ears_texture` = @character_ears_texture, `character_cellphone` = @character_cellphone, `helmet` = @helmet, `helmet_texture` = @helmet_texture, `character_rppoints`= @character_rppoints, ";
  15.                     query = query + "`character_watches` = @character_watches, `character_watches_texture` = @character_watches_texture, `character_bracelets` = @character_bracelets, `backpack` = @backpack, `character_vip` = @character_vip, `character_vip_expire` = @character_vip_expire, `character_vip_date` = @character_vip_date, `character_donator` = @character_donator, `character_credits` = @character_credits, `health` = @health, `armor` = @armor, `LastLogin` = @LastLogin, `character_vehicle_slots` = @character_vehicle_slots, `character_house_slots` = @character_house_slots, `character_cat` = @character_cat ";
  16.                     query = query + " WHERE name = '" + player.GetData("character_name") + "'";
  17.  
  18.                     MySqlCommand myCommand = new MySqlCommand(query, Mainpipeline);
  19.  
  20.                     myCommand.Parameters.AddWithValue("@name", player.GetData("character_name"));
  21.                     myCommand.Parameters.AddWithValue("@money", player.GetData("character_money"));
  22.                     myCommand.Parameters.AddWithValue("@bank", player.GetData("character_bank"));
  23.                     myCommand.Parameters.AddWithValue("@salary", player.GetData("character_salary"));
  24.  
  25.                     myCommand.Parameters.AddWithValue("@level", player.GetData("character_level"));
  26.                     myCommand.Parameters.AddWithValue("@exp", player.GetData("character_exp"));
  27.                     myCommand.Parameters.AddWithValue("@leader", player.GetData("character_leader"));
  28.                     myCommand.Parameters.AddWithValue("@group", player.GetData("character_group"));
  29.                     myCommand.Parameters.AddWithValue("@group_rank", player.GetData("character_group_rank"));
  30.                     myCommand.Parameters.AddWithValue("@job", player.GetData("character_job"));
  31.                     myCommand.Parameters.AddWithValue("@wanted", player.GetData("character_wanted_level"));
  32.                     myCommand.Parameters.AddWithValue("@last_crime", player.GetData("character_last_crime"));
  33.                     myCommand.Parameters.AddWithValue("@business_key", player.GetData("character_business_key"));
  34.                     myCommand.Parameters.AddWithValue("@hunger", "" + player.GetData("Hunger") + "");
  35.                     myCommand.Parameters.AddWithValue("@thirsty", "" + player.GetData("Thirsty") + "");
  36.                     myCommand.Parameters.AddWithValue("@duty", player.GetData("duty"));
  37.                     myCommand.Parameters.AddWithValue("@hospital", player.GetSharedData("character_hospital"));
  38.                     myCommand.Parameters.AddWithValue("@death", player.GetSharedData("Injured"));
  39.                     myCommand.Parameters.AddWithValue("@death_seconds", player.GetSharedData("InjuredTime"));
  40.                     myCommand.Parameters.AddWithValue("@health", player.Health);
  41.                     myCommand.Parameters.AddWithValue("@armor", player.Armor);
  42.                     myCommand.Parameters.AddWithValue("@LastLogin", DateTime.Now);
  43.  
  44.                     myCommand.Parameters.AddWithValue("@prison", player.GetData("character_prison"));
  45.                     myCommand.Parameters.AddWithValue("@prison_cell", player.GetData("character_prison_cell"));
  46.                     myCommand.Parameters.AddWithValue("@prison_time", player.GetData("character_prison_time"));
  47.                     myCommand.Parameters.AddWithValue("@ooc_prison_time", player.GetData("character_ooc_prison_time"));
  48.                     myCommand.Parameters.AddWithValue("@ooc_warning", player.GetData("character_ooc_warning"));
  49.                     myCommand.Parameters.AddWithValue("@ooc_mute_newbie", player.GetData("character_ooc_mute_newbie"));
  50.  
  51.  
  52.                     myCommand.Parameters.AddWithValue("@character_vip", player.GetData("character_vip"));
  53.                     myCommand.Parameters.AddWithValue("@character_vip_expire", player.GetData("character_vip_expire"));
  54.                     myCommand.Parameters.AddWithValue("@character_vip_date", player.GetData("character_vip_date"));
  55.                     myCommand.Parameters.AddWithValue("@character_donator", player.GetData("character_donator"));
  56.                     myCommand.Parameters.AddWithValue("@character_credits", player.GetData("character_credits"));
  57.                     myCommand.Parameters.AddWithValue("@character_vehicle_slots", player.GetData("character_vehicle_slots"));
  58.                     myCommand.Parameters.AddWithValue("@character_house_slots", player.GetData("character_house_slots"));
  59.                     myCommand.Parameters.AddWithValue("@character_cat", player.GetData("character_cat"));
  60.  
  61.                     myCommand.Parameters.AddWithValue("@car_lic", player.GetData("character_car_lic"));
  62.                     myCommand.Parameters.AddWithValue("@truck_lic", player.GetData("character_truck_lic"));
  63.                     myCommand.Parameters.AddWithValue("@fly_lic", player.GetData("character_fly_lic"));
  64.                     myCommand.Parameters.AddWithValue("@fish_lic", player.GetData("character_fish_lic"));
  65.                     myCommand.Parameters.AddWithValue("@taxi_lic", player.GetData("character_taxi_lic"));
  66.                     myCommand.Parameters.AddWithValue("@gun_lic", player.GetData("character_gun_lic"));
  67.  
  68.  
  69.  
  70.                     for (int i = 0; i < 10; i++)
  71.                     {
  72.                         if (player.GetData("peixe_" + i) == 255) myCommand.Parameters.AddWithValue("@peixe_" + i, -1);
  73.                         else myCommand.Parameters.AddWithValue("@peixe_" + i, player.GetData("peixe_" + i));
  74.                     }
  75.  
  76.                     myCommand.Parameters.AddWithValue("@ammo_handguns", player.GetData("character_ammo_handguns"));
  77.                     myCommand.Parameters.AddWithValue("@ammo_machineguns", player.GetData("character_ammo_machineguns"));
  78.                     myCommand.Parameters.AddWithValue("@ammo_assaultrifles", player.GetData("character_ammo_assaultrifles"));
  79.                     myCommand.Parameters.AddWithValue("@ammo_sniperrifles", player.GetData("character_ammo_sniperrifles"));
  80.                     myCommand.Parameters.AddWithValue("@ammo_shotguns", player.GetData("character_ammo_shotguns"));
  81.  
  82.                     myCommand.Parameters.AddWithValue("@backpack", player.GetData("character_backpack"));
  83.                     myCommand.Parameters.AddWithValue("@character_rppoints", player.GetData("character_rppoints"));
  84.  
  85.  
  86.                     myCommand.Parameters.AddWithValue("@char_position_x", player.Position.X.ToString());
  87.                     myCommand.Parameters.AddWithValue("@char_position_y", player.Position.Y.ToString());
  88.                     myCommand.Parameters.AddWithValue("@char_position_z", player.Position.Z.ToString());
  89.                     myCommand.Parameters.AddWithValue("@char_rotation_z", player.Rotation.Z.ToString());
  90.  
  91.                     myCommand.Parameters.AddWithValue("@char_torso", NAPI.Data.GetEntitySharedData(player, "character_torso"));
  92.                     myCommand.Parameters.AddWithValue("@char_undershirt", NAPI.Data.GetEntitySharedData(player, "character_undershirt"));
  93.                     myCommand.Parameters.AddWithValue("@char_undershirt_texture", NAPI.Data.GetEntitySharedData(player, "character_undershirt_texture"));
  94.                     myCommand.Parameters.AddWithValue("@char_leg", NAPI.Data.GetEntitySharedData(player, "character_leg"));
  95.                     myCommand.Parameters.AddWithValue("@char_leg_texture", NAPI.Data.GetEntitySharedData(player, "character_leg_texture"));
  96.                     myCommand.Parameters.AddWithValue("@char_feet", NAPI.Data.GetEntitySharedData(player, "character_feet"));
  97.                     myCommand.Parameters.AddWithValue("@char_feet_texture", NAPI.Data.GetEntitySharedData(player, "character_feet_texture"));
  98.                     myCommand.Parameters.AddWithValue("@char_shirt", NAPI.Data.GetEntitySharedData(player, "character_shirt"));
  99.                     myCommand.Parameters.AddWithValue("@char_shirt_texture", NAPI.Data.GetEntitySharedData(player, "character_shirt_texture"));
  100.                     myCommand.Parameters.AddWithValue("@char_mask", NAPI.Data.GetEntitySharedData(player, "character_mask"));
  101.                     myCommand.Parameters.AddWithValue("@char_mask_texture", NAPI.Data.GetEntitySharedData(player, "character_mask_texture"));
  102.                     myCommand.Parameters.AddWithValue("@char_armor", NAPI.Data.GetEntitySharedData(player, "character_armor"));
  103.                     myCommand.Parameters.AddWithValue("@char_armor_texture", NAPI.Data.GetEntitySharedData(player, "character_armor_texture"));
  104.  
  105.                     myCommand.Parameters.AddWithValue("@character_hats", NAPI.Data.GetEntitySharedData(player, "character_hats"));
  106.                     myCommand.Parameters.AddWithValue("@character_hats_texture", NAPI.Data.GetEntitySharedData(player, "character_hats_texture"));
  107.                     myCommand.Parameters.AddWithValue("@character_glasses", NAPI.Data.GetEntitySharedData(player, "character_glasses"));
  108.                     myCommand.Parameters.AddWithValue("@character_glasses_texture", NAPI.Data.GetEntitySharedData(player, "character_glasses_texture"));
  109.                     myCommand.Parameters.AddWithValue("@character_ears", NAPI.Data.GetEntitySharedData(player, "character_ears"));
  110.                     myCommand.Parameters.AddWithValue("@character_ears_texture", NAPI.Data.GetEntitySharedData(player, "character_ears_texture"));
  111.                     myCommand.Parameters.AddWithValue("@character_watches", NAPI.Data.GetEntitySharedData(player, "character_watches"));
  112.                     myCommand.Parameters.AddWithValue("@character_watches_texture", NAPI.Data.GetEntitySharedData(player, "character_watches_texture"));
  113.                     myCommand.Parameters.AddWithValue("@character_bracelets", NAPI.Data.GetEntitySharedData(player, "character_bracelets"));
  114.                     myCommand.Parameters.AddWithValue("@character_bracelets_texutre", NAPI.Data.GetEntitySharedData(player, "character_bracelets_texutre"));
  115.                     myCommand.Parameters.AddWithValue("@helmet", NAPI.Data.GetEntitySharedData(player, "character_helmet"));
  116.                     myCommand.Parameters.AddWithValue("@helmet_texture", NAPI.Data.GetEntitySharedData(player, "character_helmet_texture"));
  117.  
  118.  
  119.                     myCommand.Parameters.AddWithValue("@char_outfit", player.GetData("character_outfit"));
  120.                     myCommand.Parameters.AddWithValue("@char_outfit_duty", player.GetData("character_duty_outfit"));
  121.                     myCommand.Parameters.AddWithValue("@char_dimension", player.Dimension);
  122.                     myCommand.Parameters.AddWithValue("@connected_seconds", player.GetData("connected_seconds"));
  123.                     myCommand.Parameters.AddWithValue("@character_cellphone", cellphoneSystem.GetPlayerNumber(player));
  124.  
  125.                     if (player.HasData("InsideHouse_ID"))
  126.                     {
  127.                         myCommand.Parameters.AddWithValue("@inside_house", player.GetData("InsideHouse_ID"));
  128.                     }
  129.                     else myCommand.Parameters.AddWithValue("@inside_house", "null");
  130.  
  131.                     myCommand.ExecuteNonQuery();
  132.  
  133.  
  134.                     NAPI.Util.ConsoleOutput("[BANCO DE DADOS]: A conta de " + player.GetData("character_name") + " foi salva com sucesso.");
  135.                 }
  136.                 catch (Exception ex)
  137.                 {
  138.                     NAPI.Util.ConsoleOutput("[EXCEPTION SaveAccount] " + ex.Message);
  139.                     NAPI.Util.ConsoleOutput("[EXCEPTION SaveAccount] " + ex.StackTrace);
  140.                 }
  141.             }
  142.  
  143.         }
  144.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!