public BuffManager(IDbConnection db)
{
IQueryBuilder sqliteQueryCreator;
this.database = db;
SqlColumn[] sqlColumn = new SqlColumn[2];
SqlColumn sqlColumn1 = new SqlColumn("BuffID", MySqlDbType.Int32, new int?(50));
sqlColumn1.Primary = true;
sqlColumn[0] = sqlColumn1;
sqlColumn[1] = new SqlColumn("AllowedGroups", MySqlDbType.Text);
SqlTable sqlTable = new SqlTable("BuffBans", sqlColumn);
IDbConnection dbConnection = db;
if (DbExt.GetSqlType(db) == SqlType.Sqlite)
{
sqliteQueryCreator = new SqliteQueryCreator();
}
else
{
sqliteQueryCreator = new MysqlQueryCreator();
}
(new SqlTableCreator(dbConnection, sqliteQueryCreator)).EnsureTableStructure(sqlTable);
this.UpdateBuffBans();
}
public static void TryCreateTable()
{
try
{
SqlTable sqlTable = new SqlTable("PowerfulSign", new SqlColumn[]
{
new SqlColumn("SignID", MySql.Data.MySqlClient.MySqlDbType.Int32)
{
Primary = true,
AutoIncrement = true
},
new SqlColumn("Owner", MySql.Data.MySqlClient.MySqlDbType.Int32),
new SqlColumn("Friends", MySql.Data.MySqlClient.MySqlDbType.Text),
new SqlColumn("Text", MySql.Data.MySqlClient.MySqlDbType.Text),
new SqlColumn("CanEdit", MySql.Data.MySqlClient.MySqlDbType.Int32)
{
DefaultValue = "1"
}, //0为true, 1为false
new SqlColumn("X", MySql.Data.MySqlClient.MySqlDbType.Int32),
new SqlColumn("Y", MySql.Data.MySqlClient.MySqlDbType.Int32),
new SqlColumn("WorldID", MySql.Data.MySqlClient.MySqlDbType.Int32)
});
IDbConnection db = TShock.DB;
IQueryBuilder queryBuilder2;
if (DbExt.GetSqlType(TShock.DB) != SqlType.Sqlite)
{
IQueryBuilder queryBuilder = new MysqlQueryCreator();
queryBuilder2 = queryBuilder;
}
else
{
IQueryBuilder queryBuilder = new SqliteQueryCreator();
queryBuilder2 = queryBuilder;
}
new SqlTableCreator(db, queryBuilder2).EnsureTableStructure(sqlTable);
CheckSignImport();
}
catch (Exception ex) { TShock.Log.Error(ex.Message); }
//Main.sign = new Sign[1000];
}
