Alex_Jemison
Умник
PHP:
[21:37:38 12/22/18] [ERROR] CMySQLQuery::Execute - (error #1060) Duplicate column name 'OnNumber' (Query: "ALTER TABLE `ownable` ADD `OnNumber` TEXT CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL , ADD `Register` TEXT CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL , ADD `OnRegister` TEXT CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL")
[21:37:38 12/22/18] [ERROR] CMySQLQuery::Execute - (error #1060) Duplicate column name 'NumberColor' (Query: "ALTER TABLE `ownable` ADD `NumberColor` INT NOT NULL")
PHP:
if(GLS[66]==0)
{
mysql_query(mysql,"ALTER TABLE `ownable` ADD `OnNumber` TEXT CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL , ADD `Register` TEXT CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL , ADD `OnRegister` TEXT CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL",false);
mysql_query(mysql, "UPDATE `ownable` SET `OnNumber`='The State', `Register`='The State', `OnRegister`='The State', `Number`='SA'", false);
mysql_query(mysql,"ALTER TABLE `ownable` ADD `NumberColor` INT NOT NULL", false);
mysql_query(mysql,"UPDATE `accounts` SET `AskBan`='0', `GetBonus`=0 ;");
GLS[66]=1;
}
