Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void CreateTables()
- {
- char szDriver[16];
- DBDriver dbdriver = g_hDatabase.Driver;
- dbdriver.GetIdentifier(szDriver, sizeof szDriver);
- SQL_LockDatabase(g_hDatabase);
- if(StrEqual(szDriver, "sqlite", false))
- {
- g_hDatabase.Query(SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `mining_farm_main` (`auth` int(11) NOT NULL, `name` varchar(32) NOT NULL, `date` int(11) NOT NULL, `balance` int(11) NOT NULL default '0', `all_time_balance` int(11) NOT NULL default '0', `e_count` int(11) NOT NULL default '0', `e_amount` int(11) NOT NULL default '0', `farm_0` int(11) NOT NULL default '0', `farm_1` int(11) NOT NULL default '0', `farm_2` int(11) NOT NULL default '0', `farm_3` int(11) NOT NULL default '0', `farm_4` int(11) NOT NULL default '0', `farm_5` int(11) NOT NULL default '0');");
- g_hDatabase.Query(SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `mining_farm_exchange` (`auth` int(11) NOT NULL, `steamid64` varchar(32) NOT NULL, `count` int(11) NOT NULL, `price` int(11) NOT NULL, `date` int(11) NOT NULL);");
- g_hDatabase.Query(SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `mining_farm_exchange_stat` (`date` int(11) NOT NULL, `next_date` int(11) NOT NULL, `price` int(11) NOT NULL);");
- }
- else
- {
- g_hDatabase.Query(SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `mining_farm_main` (`auth` INT NOT NULL, `name` VARCHAR(64) NOT NULL default 'unknown', `date` INT NOT NULL, `balance` INT NOT NULL default '0', `all_time_balance` INT NOT NULL default '0', `e_count` INT NOT NULL default '0', `e_amount` INT NOT NULL default '0', `farm_0` INT NOT NULL default '0', `farm_1` INT NOT NULL default '0', `farm_2` INT NOT NULL default '0', `farm_3` INT NOT NULL default '0', `farm_4` INT NOT NULL default '0', `farm_5` INT NOT NULL default '0') DEFAULT CHARSET=utf8;");
- g_hDatabase.Query(SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `mining_farm_exchange` (`auth` INT NOT NULL, `steamid64` VARCHAR(64) NOT NULL, `count` INT NOT NULL, `price` INT NOT NULL, `date` INT NOT NULL) DEFAULT CHARSET=utf8;");
- g_hDatabase.Query(SQL_Callback_ErrorCheck, "CREATE TABLE IF NOT EXISTS `mining_farm_exchange_stat` (`date` INT NOT NULL, `next_date` INT NOT NULL, `price` INT NOT NULL) DEFAULT CHARSET=utf8;");
- }
- g_hDatabase.SetCharset("utf8");
- SQL_UnlockDatabase(g_hDatabase);
- #if DEBUG 1
- LogToFile(g_szLogFile, "Краш?");
- #endif
- for(int i = 1; i <= MaxClients; i++)
- {
- if(IsClientInGame(i) && !IsFakeClient(i) && g_hDatabase != null)
- {
- LoadClient(i);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement