ERRO GANHAR VIP AO CADASTRAR MUSITE
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
