using System;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using Addon;
namespace duhhh
{
public class Class1 : CPlugin
{
MySqlConnection connection;
List<string> connected = new List<string>();
public override void OnPlayerSpawned(ServerClient Client)
{
foreach (string XUID in connected)
{
if (XUID == Client.XUID)
{
ServerSay("Welcome " + Client.Name + " from website!", true);
connected.Remove(XUID);
}
}
base.OnPlayerSpawned(Client);
}
public override void OnServerLoad()
{
connection = new MySqlConnection(string.Format("SERVER={0};DATABASE={1};UID={2};PASSWORD={3};", GetServerCFG("XUID Welcome", "SERVER", string.Empty), GetServerCFG("XUID Welcome", "DB", string.Empty), GetServerCFG("XUID Welcome", "USER", string.Empty), GetServerCFG("XUID Welcome", "PASSWORD", string.Empty)));
connection.Open();
ServerPrint("MySQL welcome by archit loaded!");
base.OnServerLoad();
}
public override string OnCheckBan(string XUID)
{
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = string.Format("select * from {0} WHERE {1} = '{2}'", GetServerCFG("XUID Welcome", "table", string.Empty), GetServerCFG("XUID Welcome", "xuid tab", string.Empty), XUID);
Reader = command.ExecuteReader();
string thisrow = "";
while (Reader.Read())
{
for (int i = 0; i < Reader.FieldCount; i++)
thisrow += Reader.GetValue(i).ToString();
}
Reader.Close();
if (!string.IsNullOrEmpty(thisrow))
{
connected.Add(XUID);
return base.OnCheckBan(XUID);
}
else
{
if (GetServerCFG("XUID Welcome", "kick message", null) != null)
return GetServerCFG("XUID Welcome", "kick message", null) + " " + XUID;
else
return null;
}
}
}
}