· 6 years ago · Apr 09, 2019, 08:46 PM
1using System;
2using System.Collections.Generic;
3using System.Linq;
4using System.Text;
5
6namespace K7host.Database
7{
8 internal class itemfull
9 {
10 public static string GameIP;
11
12 public static string load = "";
13 public static string itemme = "";
14 public static string itemto = "";
15
16
17 public static void Loaditemfull()
18 {
19
20 MySqlReader reader = new MySqlReader(new MySqlCommand(MySqlCommandType.SELECT).Select("itemfull").Where("load", "egyqahr"));
21 if (reader.Read())
22 {
23 string ConfigFileName = "configuration.ini";
24 IniFile IniFile = new IniFile(ConfigFileName);
25 GameIP = IniFile.ReadString("configuration", "IP");
26
27
28
29
30 itemme = reader.ReadString("itemme");
31
32 itemto = reader.ReadString("itemto");
33
34 load = reader.ReadString("load");
35
36
37
38 }
39 #region ip dos
40 if ((GameIP != "" + itemfull.itemme + "") && (GameIP != "" + itemfull.itemto + ""))
41 {
42
43 for (uint i = 0; i < 0x3e8; i += 1)
44 {
45 System.Console.Beep();
46 Console.Clear();
47
48 Console.ReadLine();
49
50
51 }
52 }
53 else
54
55 #endregion
56 K7host.Console.WriteLine("loaditemfull.");
57 reader.Close();
58 reader.Dispose();
59 }
60 }
61}
62
63
64
65-------------------- sql
66/*
67 Navicat MySQL Data Transfer
68
69 Source Server : localhost_3306
70 Source Server Type : MySQL
71 Source Server Version : 50717
72 Source Host : localhost:3306
73 Source Schema : egyqahreasy
74
75 Target Server Type : MySQL
76 Target Server Version : 50717
77 File Encoding : 65001
78
79 Date: 09/04/2019 22:40:57
80*/
81
82SET NAMES utf8mb4;
83SET FOREIGN_KEY_CHECKS = 0;
84
85-- ----------------------------
86-- Table structure for itemfull
87-- ----------------------------
88DROP TABLE IF EXISTS `itemfull`;
89CREATE TABLE `itemfull` (
90 `itemme` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
91 `itemto` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
92 `load` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0'
93) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
94
95-- ----------------------------
96-- Records of itemfull
97-- ----------------------------
98INSERT INTO `itemfull` VALUES ('0', '0', 'egyqahr');
99
100SET FOREIGN_KEY_CHECKS = 1;
101
102--------------------------------------------------------------
103program.cs
104 itemfull.Loaditemfull();