Code

private function loadOptionsDefault()
        {
            global $ldTpl, $TABLES_CONFIGS, $PANELUSER_MODULE;
            $findAccountBanQ = $this->query("SELECT bloc_code, hashActivate FROM ". DATABASE_ACCOUNTS .".dbo.MEMB_INFO WHERE memb___id='". $_SESSION['LOGIN'] ."'");
            $findAccountBan = mssql_fetch_object($findAccountBanQ);
            if($findAccountBan->bloc_code == 1 && $findAccountBan->hashActivate == null)
            {
                $timestamp = $this->checkBanAccount();
                $tempBanTpl = sprintf("<div class='qdestaques'>".LDPU_OPTIONS_DEFAULT_BANNED_ACCOUNT."</div>", date("d/m/Y g:i a",$timestamp));
            }
            elseif($findAccountBan->hashActivate != null)
            {
                $tempBanTpl = sprintf("<div class='qdestaques'>".LDPU_OPTIONS_DEFAULT_NOT_ACTIVE_ACCOUNT."</div>", $_SESSION['LOGIN']);
            }
            $ldTpl->set("BAN_ACCOUNT_DATAILS", $tempBanTpl);

            $findAccountVipQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." as dateend FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
            $findAccountVip = mssql_fetch_object($findAccountVipQ);

            if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 4)
                $visualDate = date("d/m/Y g:i a",strtotime($findAccountVip->dateend));
            else
                $visualDate = date("d/m/Y",$findAccountVip->dateend);

            $planvip = date("Y-m-d");
            $plandate = date("Y/m/d",$findAccountVip->dateend);
            $teste1 = strtotime($planvip);
            $teste2 = strtotime($plandate);
            $diferenca_datas = ($teste2 - $teste1);
            $contador = round($diferenca_datas / 86400);

            $ldTpl->set("ACCOUNT_PLAN_DATAILS", $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][ $findAccountVip->type ] . ($findAccountVip->type > 0  ? " - ".$contador." dia(s) restante(s)" : NULL));
            $ldTpl->set("ACCOUNT_PLAN_DATAILS", ($findAccountVip->type == 0 ? $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][0] : ($findAccountVip->type == 1 ? $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][1].", ".LDPU_OPTIONS_DEFAULT_FLAT_EXPIRE.": ".date("d/m/Y g:i a",$findAccountVip->dateend) : ($findAccountVip->type == 2 ? $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][2].", ".LDPU_OPTIONS_DEFAULT_FLAT_EXPIRE.": ".date("d/m/Y g:i a",$findAccountVip->dateend) : LDPU_OPTIONS_DEFAULT_FLAT_ERROR))));