OLA BOM DIA PARA TODOS.. ESTOU COM UM PEQUENO PROBLEMA COM, O MUSITE PARA GERAR BONUS VIP AO CADASTRAR SEMPRE APARESSE ESSE ERRO. Warning: mssql_query() [function.mssql-query]: message: The column name 'AccountExpireDate' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'AccountExpireDate' may appear twice in the view definition. (severity 16) in C:\AppServ\www\EXODOS\modules\classes\ldmssql.clas s.php on line 48 Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\EXODOS\modules\classes\ldmssql.clas s.php on line 48 LD_Error: Não foi possivel executar: UPDATE MuOnline.dbo.MEMB_INFO SET AccountLevel = 2, AccountExpireDate = '1458134388', AccountExpireDate = '1458566388' WHERE memb___id = 'TESTE' MINHAS SETINGS ESTAO DESSA FORMA.. $TABLES_CONFIGS['WEBVIPS'] = array("database" => "MuOnline", //webSite || MuOnline "table" => "MEMB_INFO", //webVips || MEMB_INFO "columnUsername" => "memb___id", //username || memb___id "columnType" => "AccountLevel", //type || vip "columnDateBegin" => "AccountExpireDate", "columnDateEnd" => "AccountExpireDate", "columnDateEndInteger" => "AccountExpireDate"); E OS BONUS VIP ASSIM... $REGISTER_SETTINGS['BONUS_VIP']['ACTIVE'] = TRUE; //Ativa bonus de vip no cadastro. $REGISTER_SETTINGS['BONUS_VIP']['TYPE'] = 1; //Tipo de bonus na hora do cadastro: 1 = Vip 1, 2 = Vip 2, 3 = Vip 3, 4 = Vip 4, 5 = Vip 5 $REGISTER_SETTINGS['BONUS_VIP']['DAYS'] = 10; //Quatidades de dias de vip a ser dado como brinde. BONUS VIP NO MEU ldregister.class if($TABLES_CONFIGS['WEBVIPS']['table'] != "MEMB_INFO") $this->query("INSERT INTO ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." (".$TABLES_CONFIGS['WEBVIPS']['columnUsername'].", ".$TABLES_CONFIGS['WEBVIPS']['columnType'].", ".$TABLES_CONFIGS['WEBVIPS']['columnDateBegin'].", ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd'].") VALUES ('".$login."', 0, '0', '0'); "); if($REGISTER_SETTINGS['BONUS_VIP']['ACTIVE'] == true) { $timeStampBegin = strtotime("now"); $timeStampEnd = strtotime("+ ". $REGISTER_SETTINGS['BONUS_VIP']['DAYS'] ." days"); $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnType']." = ".$REGISTER_SETTINGS['BONUS_VIP']['TYPE'].", ".$TABLES_CONFIGS['WEBVIPS']['columnDateBegin']." = '".$timeStampBegin."', ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." = '".$timeStampEnd."' WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']." = '".$login."'"); JA TENTEI EDITAR MAIS SEMPRE DA ERRO... DESDE JA AGRADESÇO
Há 1 usuários navegando neste tópico. (0 registrados e 1 visitantes)
Regras do Fórum