public async Task Pick(CommandContext ctx, [RemainingText, Description("Person you want to pick.")] DiscordMember pick) { try { Set playerMatch = Matchmaker.Sets.FirstOrDefault(e => e.GetPickingTeam().IsCaptain(ctx.Message.Author.Id)); Logger.Warn(string.Join(",", Matchmaker.Sets[0].BravoTeam.Players.Select(x => x.Nickname))); if (playerMatch == null || !CommandHelper.SetChannelIds.Contains(ctx.Channel.Id)) { return; } SdlPlayer sdlPlayer = await MySqlClient.RetrieveSdlPlayer(pick.Id); await PickPlayer(playerMatch, sdlPlayer, ctx.Channel); } catch (Exception e) { Logger.Error(e); throw; } }
internal void Awake() { Client = new DiscordSocketClient(); MySqlClient = new MySqlClient(EnvManager.Server, EnvManager.Database, EnvManager.Table, EnvManager.UserId, EnvManager.Password); RoleMonitor = new RoleMonitor(MySqlClient); UserMonitor = new UserMonitor(MySqlClient); }
public async Task SetRole(CommandContext ctx, [Description("One of four options: front, mid, back, flex.")] string role) { role = role[0].ToString().ToUpper() + string.Join(string.Empty, role.Skip(1)); SdlPlayer player; try { player = await MySqlClient.RetrieveSdlPlayer(ctx.User.Id); } catch (SdlMySqlException e) { /*await e.OutputToDiscordUser(ctx);*/ throw; } if (role == "Front" || role == "Back" || role == "Mid" || role == "Flex") { // TODO roleNum parameter await MySqlClient.SetRoleAsync(player, role, 1); } else { await ctx.RespondAsync("You must specify Front, Flex, Mid, or Back!"); return; } await ctx.RespondAsync($"Your role has been set to {role}."); }
public async Task FriendCode(CommandContext ctx, [Description("Friend code in the format 0000-0000-0000 or SW-0000-0000-0000")] string code) { code = code.Replace("SW-", string.Empty); if (code.Split('-').Length != 3 || code.Split('-').Any(e => !int.TryParse(e, out int _) || e.Length != 4)) { await ctx.RespondAsync("Please use the format 0000-0000-0000!"); return; } SdlPlayer player; try { player = await MySqlClient.RetrieveSdlPlayer(ctx.User.Id); } catch (SdlMySqlException e) { /*await e.OutputToDiscordUser(ctx);*/ throw; } await MySqlClient.SetFriendCodeAsync(player, code); await ctx.RespondAsync($"Set your friend code to {code}!"); }
public bool mysql_init() { st = new Settings(); mysqlClient = new MySqlClient( st.db_host, st.db_port, st.db_username, st.db_password, st.db_database ); bool is_true = mysqlClient.Test_Connection(); if (!is_true) { Console.WriteLine("MySQL connection is incorrect."); return(false); } Console.WriteLine("MySQL connection is good."); mysqlQuery = new MySqlQuery(mysqlClient); myRequest = new Request(mysqlClient, st.api_webhook, st.api_access_token); myRequest.Start(); return(true); }
public static void Main(string[] args) { if (args.Length < 2) { Console.WriteLine("<database> <tablename>"); return; } var loop = Loop.Default; MySqlClient client = new MySqlClient(loop); client.IPEndPoint = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 3306); client.Username = "******"; client.Password = ""; client.Connect() .OnError((error) => { Console.WriteLine(error.Message); client.Disconnect(); }); client.Query(string.Format("use {0}", args[0])); Query(client, args[0], args[1]); loop.Run(); }
/// <summary> /// For SelfTest, the user's QfRuntimeConnection will be called by the generated code. We still need the provider /// </summary> /// <param name="connection">Must be open</param> /// <param name="provider">Must be a built-in provider. No DI for self-test.</param> /// <param name="Query">The query text</param> /// <returns></returns> public List <ResultFieldDetails> GetFields(IDbConnection connection, string provider, string Query) { // how do I be registering with tiny inside someone else's program ? IProvider prov = null; switch (provider) { case "System.Data.SqlClient": prov = new SqlClient(); break; case "Npgsql": prov = new Providers.Npgsql(); break; case "MySql.Data.MySqlClient": prov = new MySqlClient(); break; } if (connection.State != ConnectionState.Open) { connection.Open(); } return(GetFields(connection, prov, Query)); }
public bool mysql_init() { string guid = Guid.NewGuid().ToString(); lblLabelStatus.Text = "Service connecting..."; st = new Settings(); mysqlClient = new MySqlClient( st.db_host, st.db_port, st.db_username, st.db_password, st.db_database ); bool is_true = mysqlClient.Test_Connection(); if (!is_true) { Console.WriteLine("Service connection is incorrect."); lblLabelStatus.Text = "Service connection is incorrect."; return(false); } Console.WriteLine("Service connection is good."); lblLabelStatus.Text = "Service Looks Good."; mysqlQuery = new MySqlQuery(mysqlClient); myRequest = new Request(mysqlClient, st.api_webhook, st.api_access_token); myRequest.Status_Event += new Request.StatusEventHandler(Status_Logs); myRequest.Start(); return(true); }
public static string GenerateDetailOrderID() { mutex.WaitOne(); string detailId = default(string); _count++; string sql = "SELECT Max(DetailID) FROM DetailedOrder"; if (mySqlclient == null) { mySqlclient = MySqlClient.GetMySqlClient(); } detailId = mySqlclient.ExecuteScalar(sql, null) as string; if (detailId == null) { detailId = "DP" + DateTime.Now.ToString("yyyyMMdd") + _count.ToString("0000"); } else { string temp = detailId.Substring(2, 8); string comp = DateTime.Today.Date.ToString("yyyyMMdd"); if (temp.Equals(comp)) { string tmp = detailId.Substring(2); detailId = "DP" + (Convert.ToInt64(tmp) + _count); } else { detailId = "DP" + DateTime.Now.ToString("yyyyMMdd") + _count.ToString("00000"); } } mutex.ReleaseMutex(); return(detailId); }
public async Task <ApiUser> Authenticate(string username, string password) { ApiUser[] users = await MySqlClient.GetApiUsers(); ApiUser user = users.SingleOrDefault(x => x.UserName == username && x.PasswordHash == password); // return null if user not found if (user == null) { return(null); } // authentication successful so generate jwt token JwtSecurityTokenHandler tokenHandler = new JwtSecurityTokenHandler(); byte[] key = Encoding.ASCII.GetBytes(this.appSettings.Secret); SecurityTokenDescriptor tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(new[] { new Claim(ClaimTypes.Name, user.Id) }), Expires = DateTime.UtcNow.AddDays(7), SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature) }; SecurityToken token = tokenHandler.CreateToken(tokenDescriptor); user.Token = tokenHandler.WriteToken(token); return(user); }
public static async Task <decimal> ReportScores(Set playerSet, bool forgiveLosing = false) { decimal points = CalculatePoints(playerSet); if (forgiveLosing) { DiscordMessage feedMessage = await(await Program.Client.GetGuildAsync(570743985530863649)) .GetChannel(666563839646760960).GetMessageAsync(OrderedFeedMessages[playerSet.SetNumber - 1]); await feedMessage.ModifyAsync(embed : playerSet.GetFeedEmbedBuilder(null) .WithDescription("The set ended unnaturally.").Build()); } //TimePeriod happyPeriod = new TimePeriod(TimeSpan.Parse("20:00"), TimeSpan.Parse("21:00")); //TimePeriod halfPeriod = new TimePeriod(TimeSpan.Parse("1:00"), TimeSpan.Parse("2:00")); if (forgiveLosing) { await MySqlClient.ReportScores(playerSet, points, 0); } //else if (happyPeriod.IsWithinPeriod(playerSet.StartTime.GetValueOrDefault()) || // halfPeriod.IsWithinPeriod(playerSet.StartTime.GetValueOrDefault())) //{ // await AirTableClient.ReportScores(playerSet, points, points / 2); //} else { await MySqlClient.ReportScores(playerSet, points, points); } await Program.UpdateStandingsAsync(); return(points); }
private bool ViewTx(string txid) { DataTable dt, dttx; using (var sqlc = new MySqlClient(SiaClassicLib.Config.ConnectionString)) { dt = sqlc.FillTable($"SELECT value,unlockhash FROM siacoinoutputs WHERE tx_id='{txid}'"); dttx = sqlc.FillTable($"SELECT height,timestamp FROM txs JOIN blocks on height=blockheight WHERE txs.id='{txid}'"); } if (dttx.Rows.Count == 0) { return(false); } dttx.AddTimeColumn("time", "timestamp"); var height = dttx.Rows[0]["height"].ToString(); TxViewPanel.Visible = true; TxViewListView.DataSource = dt; TxViewListView.DataBind(); TxViewIdLabel.Text = txid; TxViewHeightHyperLink.NavigateUrl = $"/Default?block={height}"; TxViewHeightHyperLink.Text = "Block " + height; TxViewTimeLabel.Text = dttx.Rows[0]["time"].ToString(); return(true); }
public async Task ForceRegister(CommandContext ctx, DiscordMember player, int startingPower, [RemainingText] string nickname) { try { if ((await MySqlClient.RetrieveAllSdlPlayers()).Any(x => x.DiscordId == player.Id)) { await ctx.RespondAsync("This player is already in the database and cannot be force registered."); return; } await MySqlClient.RegisterPlayer(player.Id, startingPower, nickname); } catch (Exception e) { await ctx.RespondAsync($"Failed to force register user.\nException: {e}"); } DiscordChannel registeredChannel = await ctx.Client.GetChannelAsync(588806681303973931); await registeredChannel.SendMessageAsync($"Manually registered {player.Mention} " + $"with a starting power of {startingPower} " + $"and the nickname `{nickname}`."); await ctx.RespondAsync("Successfully force registered user."); }
public IQueryAdapter GetQueryReactor() { IDatabaseClient databaseClient = new MySqlClient(this); databaseClient.Connect(); return(databaseClient.GetQueryReactor()); }
public IQueryAdapter GetQueryReactor() { IDatabaseClient databaseClient = new MySqlClient(this); databaseClient.Connect(); return databaseClient.GetQueryReactor(); }
public async Task PickFor(CommandContext ctx, int setNumber, DiscordMember pick) { Set playerMatch = Matchmaker.Sets[setNumber - 1]; SdlPlayer sdlPlayer = await MySqlClient.RetrieveSdlPlayer(pick.Id); await PickPlayer(playerMatch, sdlPlayer, ctx.Channel); }
public async Task DistributeRoles(CommandContext ctx) { DiscordRole classOneRole = ctx.Guild.GetRole(600770643075661824); DiscordRole classTwoRole = ctx.Guild.GetRole(600770814521901076); DiscordRole classThreeRole = ctx.Guild.GetRole(600770862307606542); DiscordRole classFourRole = ctx.Guild.GetRole(600770905282576406); foreach (SdlPlayer sdlPlayer in await MySqlClient.RetrieveAllSdlPlayers()) { try { DiscordMember sdlGuildUser = await ctx.Guild.GetMemberAsync(sdlPlayer.DiscordId); switch (Matchmaker.GetClass(sdlPlayer.PowerLevel)) { case SdlClass.Zero: break; case SdlClass.One: if (sdlGuildUser.Roles.All(e => e.Id != classOneRole.Id)) { await sdlGuildUser.GrantRoleAsync(classOneRole); } break; case SdlClass.Two: if (sdlGuildUser.Roles.All(e => e.Id != classTwoRole.Id)) { await sdlGuildUser.GrantRoleAsync(classTwoRole); } break; case SdlClass.Three: if (sdlGuildUser.Roles.All(e => e.Id != classThreeRole.Id)) { await sdlGuildUser.GrantRoleAsync(classThreeRole); } break; case SdlClass.Four: if (sdlGuildUser.Roles.All(e => e.Id != classFourRole.Id)) { await sdlGuildUser.GrantRoleAsync(classFourRole); } break; default: break; } } catch (Exception e) { Console.WriteLine(e); } } await ctx.RespondAsync("I'm Sam, the dancing Matzo man. Making Matzos fast I can. I'm Sam the dancing Matzo man."); }
public static void CreateMediaStoreAssembly(MediaStoreSystem system, string suffix) { var webForm = new WebForm() { Name = "WebForm" + suffix }; var audioStore = new AudioStore() { Name = "AudioStore" + suffix }; var encodingadapter = new EncodingAdapter() { Name = "EncodingAdapter" + suffix }; var encoder = new OggEncoder() { Name = "OggEncoder" + suffix }; var userMgmt = new UserManagement() { Name = "UserManagement" + suffix }; var dbAdapter = new DBAdapter() { Name = "DBAdapter" + suffix }; var mySqlClient = new MySqlClient() { Name = "MySqlClient" + suffix }; system.AssemblyContexts.Add(webForm); system.AssemblyContexts.Add(audioStore); system.AssemblyContexts.Add(userMgmt); system.AssemblyContexts.Add(encodingadapter); system.AssemblyContexts.Add(encoder); system.AssemblyContexts.Add(dbAdapter); system.AssemblyContexts.Add(mySqlClient); webForm.Application = audioStore; audioStore.UserManagement = userMgmt; audioStore.AudioDB = encodingadapter; userMgmt.Database = dbAdapter; encodingadapter.Encoder = encoder; encodingadapter.Database = dbAdapter; dbAdapter.Command = mySqlClient; dbAdapter.Connection = mySqlClient; dbAdapter.DataReader = mySqlClient; system.Frontend = webForm; }
public static async Task UpdateStandingsAsync() { DiscordChannel standingChannel = await Client.GetChannelAsync(592230066654674945); foreach (DiscordMessage discordMessage in await standingChannel.GetMessagesAsync()) { await standingChannel.DeleteMessageAsync(discordMessage, "Standings update."); } SdlPlayer[] players = await MySqlClient.RetrieveAllSdlPlayers(); List <SdlPlayer> orderedPlayers = players .Where(x => standingChannel.Guild.Members.Any(y => y.Id == x.DiscordId && MySqlClient.CheckHasPlayedSet(x).Result&& y.Roles.Any(z => z.Name.Equals("player", StringComparison.InvariantCultureIgnoreCase)))) .OrderByDescending(x => x.PowerLevel).ToList(); var playerStandings = orderedPlayers.Select(x => new { Player = x, Rank = orderedPlayers.FindLastIndex(y => y.PowerLevel == x.PowerLevel) + 1 }); List <DiscordEmbedBuilder> standingEmbeds = new List <DiscordEmbedBuilder> { new DiscordEmbedBuilder().WithDescription("").WithColor(Color.Gold) }; int startStanding = 1; int endStanding = 0; foreach (var playerStanding in playerStandings) { string standingLine = $"\n{playerStanding.Rank}: {playerStanding.Player.DiscordId.ToUserMention()} [{playerStanding.Player.PowerLevel}]"; if (standingEmbeds.Last().Description.Length + standingLine.Length > 2048) { standingEmbeds.Last().Title = $"Standings ({startStanding} - {endStanding})"; standingEmbeds.Add(new DiscordEmbedBuilder().WithDescription("").WithColor(Color.Silver)); startStanding = endStanding + 1; endStanding = startStanding; } standingEmbeds.Last().Description += standingLine; endStanding++; } standingEmbeds.Last().Title = $"Standings ({startStanding} - {endStanding})"; foreach (DiscordEmbedBuilder standingEmbed in standingEmbeds) { await standingChannel.SendMessageAsync(embed : standingEmbed.Build()); } }
private static async Task Commands_CommandExecuted(CommandExecutionEventArgs e) { try { if (!MySqlClient.IsConnectionOpen()) { await MySqlClient.RefreshConnectionAsync(); } } catch (Exception exception) { Console.WriteLine(exception); await e.Context.RespondAsync("<@&572539082039885839> Unable to refresh MySQL connection!"); } }
public async Task Stage(CommandContext ctx) { try { Stage[] stages = await MySqlClient.GetMapList(); Stage selectedStage = stages[Globals.Random.Next(0, stages.Length - 1)]; await ctx.RespondAsync(embed : selectedStage.GetEmbedBuilder().Build()); } catch (Exception e) { Logger.Error(e); throw; } }
private void UpdateAtHeight(MySqlClient sqlc, int height) { Console.WriteLine(DateTime.Now + " Updating at height=" + height); dynamic b = wc.GetObject("consensus/blocks?height=" + height); // ONLY outputs NOW string sql = string.Empty; //var minerpayouts = "0"; //using (var h = new Hastings()) //{ // if (b.minerpayouts != null) // foreach (var v in b.minerpayouts) // h.Add(v.value.Value); // minerpayouts = h.ToString(); //} //var sql = $"INSERT INTO `blocks` VALUES('{b.height}', '{b.id}', '{b.parentid}', '{b.timestamp}', " + // $"'{minerpayouts}', '{b.transactions.Count}');\n" // ; foreach (dynamic tx in b.transactions) { //sql += $"INSERT INTO `txs` VALUES('{tx.id}', '{b.height}', '{tx.siacoininputs.Count}','{tx.siacoinoutputs.Count}'," + // $" '{tx.filecontracts.Count}','{tx.filecontractrevisions.Count}','{tx.storageproofs.Count}','{tx.siafundinputs.Count}'," + // $" '{tx.siafundoutputs.Count}','{tx.minerfees.Count}','{tx.arbitrarydata.Count}','{tx.transactionsignatures.Count}');\n"; foreach (dynamic output in tx.siacoinoutputs) { //using (var h = new Hastings()) //{ // h.Add(output.value.Value); // sql += $"INSERT INTO `siacoinoutputs` VALUES('{output.id}', '{b.height}', '{tx.id}', '{h.ToString()}', '{output.unlockhash}');\n"; //} sql += $"UPDATE siacoinoutputs SET unlockhash='{output.unlockhash}' WHERE id='{output.id}';\n"; } } //sqlc.ExecuteNonQuery($"START TRANSACTION;\n{sql}COMMIT;"); if (sql.Length > 0) { sqlc.ExecuteNonQuery(sql); } }
private static async Task Commands_CommandErrored(CommandErrorEventArgs e) { try { if (!MySqlClient.IsConnectionOpen()) { await MySqlClient.RefreshConnectionAsync(); await e.Context.RespondAsync("The MySQL connection is being refreshed. " + "Please wait around a minute before attempting the command again."); } } catch (Exception exception) { Console.WriteLine(exception); await e.Context.RespondAsync("<@&572539082039885839> Unable to refresh MySQL connection!"); } }
private void InsertAtHeight(MySqlClient sqlc, int height) { Console.WriteLine(DateTime.Now + " Writing block height=" + height); dynamic b = wc.GetObject("consensus/blocks?height=" + height); var minerpayouts = "0"; using (var h = new Hastings()) { if (b.minerpayouts != null) { foreach (var v in b.minerpayouts) { h.Add(v.value.Value); } } minerpayouts = h.ToString(); } var sql = $"INSERT INTO `blocks` VALUES('{b.height}', '{b.id}', '{b.parentid}', '{b.timestamp}', " + $"'{minerpayouts}', '{b.transactions.Count}');\n" ; foreach (dynamic tx in b.transactions) { sql += $"INSERT INTO `txs` VALUES('{tx.id}', '{b.height}', '{tx.siacoininputs.Count}','{tx.siacoinoutputs.Count}'," + $" '{tx.filecontracts.Count}','{tx.filecontractrevisions.Count}','{tx.storageproofs.Count}','{tx.siafundinputs.Count}'," + $" '{tx.siafundoutputs.Count}','{tx.minerfees.Count}','{tx.arbitrarydata.Count}','{tx.transactionsignatures.Count}');\n"; foreach (dynamic output in tx.siacoinoutputs) { using (var h = new Hastings()) { h.Add(output.value.Value); sql += $"INSERT INTO `siacoinoutputs` VALUES('{output.id}', '{b.height}', '{tx.id}', '{h.ToString()}', '{output.unlockhash}');\n"; } } } //sqlc.ExecuteNonQuery($"START TRANSACTION;\n{sql}COMMIT;"); sqlc.ExecuteNonQuery(sql); }
public Request(MySqlClient mysqlClient, string api_webhook, string api_access_token) { mysqlQuery = new MySqlQuery(mysqlClient); notification = new Notification(mysqlClient); thread_command = new Thread(process_sms_commmand); thread_sms = new Thread(process_sms); //thread_wallet = new Thread(monitor_wallet); Json.ApiUrl = api_webhook; Json.AccessToken = api_access_token; Die = false; KeepAlive = false; }
public void UpdateOutput(int heightStart = 180000, int heightEnd = 212578) { try { using (var sqlc = new MySqlClient(connStr)) for (int height = heightStart; height <= heightEnd; ++height) { if (Console.KeyAvailable && Console.ReadKey().KeyChar == 27) { break; } UpdateAtHeight(sqlc, height); } } catch (Exception x) { Console.WriteLine(x.Message); Console.WriteLine(x.StackTrace); } }
public async Task Penalty(CommandContext ctx, DiscordMember user, int amount, [RemainingText] string notes) { try { if (amount <= 0) { await ctx.RespondAsync("Amount should be greater than zero."); return; } await MySqlClient.PenalizePlayer(await MySqlClient.RetrieveSdlPlayer(user.Id), amount, notes); } catch (Exception e) { Logger.Error(e); throw; } await ctx.RespondAsync($"Penalized {user.Mention} {amount} points."); }
private bool ViewBlockList(int offset) { DataTable dt; using (var sqlc = new MySqlClient(SiaClassicLib.Config.ConnectionString)) { dt = sqlc.FillTable($"SELECT height,timestamp,minerpayouts,tx_count FROM blocks ORDER BY height DESC LIMIT {offset},20"); } if (dt.Rows.Count == 0) { return(false); } dt.AddTimeColumn("time", "timestamp"); BlockListPanel.Visible = true; BlockListView.DataSource = dt; BlockListView.DataBind(); BlockListOffsetLabel.Text = offset.ToString(); return(true); }
public static string GenerateStaffID() { mutex.WaitOne(); string staffId = default(string); Random ran = new Random(); staffId = "S" + DateTime.Now.ToString("yyyyMMdd") + ran.Next(100, 999).ToString(); string sql = "SELECT Count(StaffId) FROM StaffInfo Where StaffId='" + staffId + "'"; if (mySqlclient == null) { mySqlclient = MySqlClient.GetMySqlClient(); } int count = Convert.ToInt32(mySqlclient.ExecuteScalar(sql, null)); if (count > 0) { GenerateStaffID(); } mutex.ReleaseMutex(); return(staffId); }
private static void DataAccessTest() { //SqlClient client = new SqlClient("SqlServerConnectionStr"); //IList<ISort> sortRules = new List<ISort> { new Sort { PropertyName = "IMUMemberId", Ascending = true } }; //string sql = "SELECT IMUId,IMUMemberId FROM IMUserInfo WITH(NOLOCK) WHERE IMUId<@IMUId"; //List<IMUserInfo> ressult = client.QueryByPage<IMUserInfo>(sql, 0, 10, new { IMUId = 3 }, sortRules); //IMUserInfo entity = client.GetEntityById<IMUserInfo>(3); BaseClient myClient = new MySqlClient("MySqlConnectionStr"); //IList<ISort> mySortRules = new List<ISort> { new Sort { PropertyName = "Id", Ascending = false } }; string sql = "DELETE FROM PersonInfo WHERE Id=@Id"; //var list = myClient.QueryByPage<PersonInfo>(sql, 0, 5, new { Id = 5 }, mySortRules); //var entity = myClient.GetEntityById<PersonInfo>(5); //PersonInfo pi = new PersonInfo { Id = 10, Name = "Leon100" }; //int isSuccess = myClient.ExcuteNonQuery(sql, new { Id = 9 }); //transaction myClient.GetConnection().Open(); IDbTransaction tran = myClient.GetConnection().BeginTransaction(); try { int isSuccess1 = myClient.ExcuteNonQuery(sql, new { Id = 1 }, tran); int isSuccess2 = myClient.ExcuteNonQuery(sql, new { Id = 2 }, tran); int isSuccess3 = myClient.ExcuteNonQuery(sql, new { Id = 3 }, tran); throw new Exception("执行不下去了"); } catch (Exception e) { tran.Rollback(); myClient.GetConnection().Close(); return; } tran.Commit(); myClient.GetConnection().Close(); }
public static void Query(MySqlClient client, string database, string table) { client.Query(string.Format("SELECT * FROM {0}", table)) .On(fields: (fields) => { foreach (var field in fields) { Console.Write("{0}({1})\t", field.Type, field.Length); } Console.WriteLine(); }) .On(row: (data) => { for (int i = 0; i < data.Length; i++) { Console.Write(data.GetRawValue(i)); Console.Write("\t"); } Console.WriteLine(); }).On(end: () => { client.Disconnect(); }).On(error: (error) => { Console.WriteLine("Error: {0}", error.Message); client.Disconnect(); }); }
private bool ViewBlock(int height) { DataTable dt; string ts; using (var sqlc = new MySqlClient(SiaClassicLib.Config.ConnectionString)) { dt = sqlc.FillTable($"SELECT id,siacoininputs,siacoinoutputs,filecontracts,filecontractrevisions,storageproofs," + "siafundinputs,siafundoutputs,minerfees,arbitrarydata,transactionsignatures FROM txs WHERE blockheight=" + height); ts = sqlc.ExecuteScalar($"SELECT timestamp FROM blocks WHERE height=" + height)?.ToString(); } if (dt.Rows.Count == 0) { return(false); } BlockViewPanel.Visible = true; BlockViewListView.DataSource = dt; BlockViewListView.DataBind(); BlockHeightLabel.Text = height.ToString(); BlockTimeLabel.Text = ClassLibrary.Extensions.TimeStampToString(ts); return(true); }
internal QueryAdapter(MySqlClient client) { this.client = client; }
public MySqlDatabase() { Client = new MySqlClient(SharpMod.Context); }
internal NormalQueryReactor(MySqlClient client) : base(client) { base.command = client.getNewCommand(); }
internal TransactionQueryReactor(MySqlClient client) : base(client) { this.initTransaction(); }