1:    2:    3:    4:    5:    6:    7:    8:    9:   10:   11:   12:   13:   14:   15:   16:   17:   18:   19:   20:   21:   22:   23:   24:   25:   26:   27:   28:   29:   30:   31:   32:   33:   34:   35:   36:   37:   38:   39:   40:   41:   42:   43:   44:   45:   46:   47:   48:   49:   50:   51:   52:   53:   54:   55:   56:   57:   58:   59:   60:   61:   62:   63:   64:   65:   66:   67:   68:   69:   70:   71:   72:   73:   74:   75:   76:   77:   78:   79:   80:   81:   82:   83:   84:   85:   86:   87:   88:   89:   90:   91:   92:   93:   94:   95:   96:   97:   98:   99:  100:  101:  102:  103:  104:  105:  106:  107:  108:  109:  110:  111:  112:  113:  114:  115:  116:  117:  118:  119:  120:  121:  122:  123:  124:  125:  126:  127:  128:  129:  130:  131:  132:  133:  134:  135:  136:  137:  138:  139:  140:  141:  142:  143:  144:  145:  146:  147:  148:  149:  150:  151:  152:  153:  154:  155:  156:  157:  158:  159:  160:  161:  162:  163:  164:  165:  166:  167:  168:  169:  170:  171:  172:  173:  174:  175:  176:  177:  178:  179:  180:  181:  182:  183:  184:  185:  186:  187:  188:  189:  190:  191:  192:  193:  194:  195:  196:  197:  198:  199:  200:  201:  202:  203:  204:  205:  206:  207:  208:  209:  210:  211:  212:  213:  214:  215:  216:  217:  218:  219:  220:  221:  222:  223:  224:  225:  226:  227:  228:  229:  230:  231:  232:  233:  234:  235:  236:  237:  238:  239:  240:  241:  242:  243:  244:  245:  246:  247:  248:  249:  250:  251:  252:  253:  254:  255:  256:  257:  258:  259:  260:  261:  262:  263:  264:  265:  266:  267:  268:  269:  270:  271:  272:  273:  274:  275:  276:  277:  278:  279:  280:  281:  282:  283:  284:  285:  286:  287:  288:  289:  290:  291:  292:  293:  294:  295:  296:  297:  298:  299:  300:  301:  302:  303:  304:  305:  306:  307:  308:  309:  310:  311:  312:  313:  314:  315:  316:  317:  318:  319:  320:  321:  322:  323:  324:  325:  326:  327:  328:  329:  330:  331:  332:  333:  334:  335:  336:  337:  338:  339:  340:  341:  342:  343:  344:  345:  346:  347:  348:  349:  350:  351:  352:  353:  354:  355:  356:  357:  358:  359:  360:  361:  362:  363:  364:  365:  366:  367:  368:  369:  370:  371:  372:  373:  374:  375:  376:  377:  378:  379:  380:  381:  382:  383:  384:  385:  386:  387:  388:  389:  390:  391:  392:  393:  394:  395:  396:  397:  398:  399:  400:  401:  402:  403:  404:  405:  406:  407:  408:  409:  410:  411:  412:  413:  414:  415:  416:  417:  418:  419:  420:  421:  422:  423:  424:  425:  426:  427:  428:  429:  430:  431:  432:  433:  434:  435:  436:  437:  438:  439:  440:  441:  442:  443:  444:  445:  446:  447:  448:  449:  450:  451:  452:  453:  454:  455:  456:  457:  458:  459:  460:  461:  462:  463:  464:  465:  466:  467:  468:  469:  470:  471:  472:  473:  474:  475:  476:  477:  478:  479:  480:  481:  482:  483:  484:  485:  486:  487:  488:  489:  490:  491:  492:  493:  494:  495:  496:  497:  498:  499:  500:  501:  502:  503:  504:  505:  506:  507:  508:  509:  510:  511:  512:  513:  514:  515:  516:  517:  518:  519:  520:  521:  522:  523:  524:  525:  526:  527:  528:  529:  530:  531:  532:  533:  534:  535:  536:  537:  538:  539:  540:  541:  542:  543:  544:  545:  546:  547:  548:  549:  550:  551:  552:  553:  554:  555:  556:  557:  558:  559:  560:  561:  562:  563:  564:  565:  566:  567:  568:  569:  570:  571:  572:  573:  574:  575:  576:  577:  578:  579:  580:  581:  582:  583:  584:  585:  586:  587:  588:  589:  590:  591:  592:  593:  594:  595:  596:  597:  598:  599:  600:  601:  602:  603:  604:  605:  606:  607:  608:  609:  610:  611:  612:  613:  614:  615:  616:  617:  618:  619:  620:  621:  622:  623:  624:  625:  626:  627:  628:  629:  630:  631:  632:  633:  634:  635:  636:  637:  638:  639:  640:  641:  642:  643:  644:  645:  646:  647:  648:  649:  650:  651:  652:  653:  654:  655:  656:  657:  658:  659:  660:  661:  662:  663:  664:  665:  666:  667:  668:  669:  670:  671:  672:  673:  674:  675:  676:  677:  678:  679:  680:  681:  682:  683:  684:  685:  686:  687:  688:  689:  690:  691:  692:  693:  694:  695:  696:  697:  698:  699:  700:  701:  702:  703:  704:  705:  706:  707:  708:  709:  710:  711:  712:  713:  714:  715:  716:  717:  718:  719:  720:  721:  722:  723:  724:  725:  726:  727:  728:  729:  730:  731:  732:  733:  734:  735:  736:  737:  738:  739:  740:  741:  742:  743:  744:  745:  746:  747:  748:  749:  750:  751:  752:  753:  754:  755:  756:  757:  758:  759:  760:  761:  762:  763:  764:  765:  766:  767:  768:  769:  770:  771:  772:  773:  774:  775:  776:  777:  778:  779:  780:  781:  782:  783:  784:  785:  786:  787:  788:  789:  790:  791:  792:  793:  794:  795:  796:  797:  798:  799:  800:  801:  802:  803:  804:  805:  806:  807:  808:  809:  810:  811:  812:  813:  814:  815:  816:  817:  818:  819:  820:  821:  822:  823:  824:  825:  826:  827:  828:  829:  830:  831:  832:  833:  834:  835:  836:  837:  838:  839:  840:  841:  842:  843:  844:  845:  846:  847:  848:  849:  850:  851:  852:  853:  854:  855:  856:  857:  858:  859:  860:  861:  862:  863:  864:  865:  866:  867:  868:  869:  870:  871:  872:  873:  874:  875:  876:  877:  878:  879:  880:  881:  882:  883:  884:  885:  886:  887:  888:  889:  890:  891:  892:  893:  894:  895:  896:  897:  898:  899:  900:  901:  902:  903:  904:  905:  906:  907:  908:  909:  910:  911:  912:  913:  914:  915:  916:  917:  918:  919:  920:  921:  922:  923:  924:  925:  926:  927:  928:  929:  930:  931:  932:  933:  934:  935:  936:  937:  938:  939:  940:  941:  942:  943:  944:  945:  946:  947:  948:  949:  950:  951:  952:  953:  954:  955:  956:  957:  958:  959:  960:  961:  962:  963:  964:  965:  966:  967:  968:  969:  970:  971:  972:  973:  974:  975:  976:  977:  978:  979:  980:  981:  982:  983:  984:  985:  986:  987:  988:  989:  990:  991:  992:  993:  994:  995:  996:  997:  998:  999: 1000: 1001: 1002: 1003: 1004: 1005: 1006: 1007: 1008: 1009: 1010: 1011: 1012: 1013: 1014: 1015: 1016: 1017: 1018: 1019: 1020: 1021: 1022: 1023: 1024: 1025: 1026: 1027: 1028: 1029: 1030: 1031: 1032: 1033: 1034: 1035: 1036: 1037: 1038: 1039: 1040: 1041: 1042: 1043: 1044: 1045: 1046: 1047: 1048: 1049: 1050: 1051: 1052: 1053: 1054: 1055: 1056: 1057: 1058: 1059: 1060: 1061: 1062: 1063: 1064: 1065: 1066: 1067: 1068: 1069: 1070: 1071: 1072: 1073: 1074: 1075: 1076: 1077: 1078: 1079: 1080: 1081: 1082: 1083: 1084: 1085: 1086: 1087: 1088: 1089: 1090: 1091: 1092: 1093: 1094: 1095: 1096: 1097: 1098: 1099: 1100: 1101: 1102: 1103: 1104: 1105: 1106: 1107: 1108: 1109: 1110: 1111: 1112: 1113: 1114: 1115: 1116: 1117: 1118: 1119: 1120: 1121: 1122: 1123: 1124: 1125: 1126: 1127: 1128: 1129: 1130: 1131: 1132: 1133: 1134: 1135: 1136: 1137: 1138: 1139: 1140: 1141: 1142: 1143: 1144: 1145: 1146: 1147: 1148: 1149: 1150: 1151: 1152: 1153: 1154: 1155: 1156: 1157: 1158: 1159: 1160: 1161: 1162: 1163: 1164: 1165: 1166: 1167: 1168: 1169: 1170: 1171: 1172: 1173: 1174: 1175: 1176: 1177: 1178: 1179: 1180: 1181: 1182: 1183: 1184: 1185: 1186: 1187: 1188: 1189: 1190: 1191: 1192: 1193: 1194: 1195: 1196: 1197: 1198: 1199: 1200: 1201: 1202: 1203: 1204: 1205: 1206: 1207: 1208: 1209: 1210: 1211: 1212: 1213: 1214: 1215: 1216: 1217: 1218: 1219: 1220: 1221: 1222: 1223: 1224: 1225: 1226: 1227: 1228: 1229: 1230: 1231: 1232: 1233: 1234: 1235: 1236: 1237: 1238: 1239: 1240: 1241: 1242: 1243: 1244: 1245: 1246: 1247: 1248: 1249: 1250: 1251: 1252: 1253: 1254: 1255: 1256: 1257: 1258: 1259: 1260: 1261: 1262: 1263: 1264: 1265: 1266: 1267: 1268: 1269: 1270: 1271: 1272: 1273: 1274: 1275: 1276: 1277: 1278: 1279: 1280: 1281: 1282: 1283: 1284: 1285: 1286: 1287: 1288: 1289: 1290: 1291: 1292: 1293: 1294: 1295: 1296: 1297: 1298: 1299: 1300: 1301: 1302: 1303: 1304: 1305: 1306: 1307: 1308: 1309: 1310: 1311: 1312: 1313: 1314: 1315: 1316: 1317: 1318: 1319: 1320: 1321: 1322: 1323: 1324: 1325: 1326: 1327: 1328: 1329: 1330: 1331: 1332: 1333: 1334: 1335: 1336: 1337: 1338: 1339: 1340: 1341: 1342: 1343: 1344: 1345: 1346: 1347: 1348: 1349: 1350: 1351: 1352: 1353: 1354: 1355: 1356: 1357: 1358: 1359: 1360: 1361: 1362: 1363: 1364: 1365: 1366: 1367: 1368: 1369: 1370: 1371: 1372: 1373: 1374: 1375: 1376: 1377: 1378: 1379: 1380: 1381: 1382: 1383: 1384: 1385: 1386: 1387: 1388: 1389: 1390: 1391: 1392: 1393: 1394: 1395: 1396: 1397: 1398: 1399: 1400: 1401: 1402: 1403: 1404: 1405: 1406: 1407: 1408: 1409: 1410: 1411: 1412: 1413: 1414: 1415: 1416: 1417: 1418: 1419: 1420: 1421: 1422: 1423: 1424: 1425: 1426: 1427: 1428: 1429: 1430: 1431: 1432: 1433: 1434: 1435: 1436: 1437: 1438: 1439: 1440: 1441: 1442: 1443: 1444: 1445: 1446: 1447: 1448: 1449: 1450: 1451: 1452: 1453: 1454: 1455: 1456: 1457: 1458: 1459: 1460: 1461: 1462: 1463: 1464: 1465: 

<?php

elFinder::$netDrivers['dropbox'] = 'Dropbox';

/**
 * Simple elFinder driver for FTP
 *
 * @author Dmitry (dio) Levashov
 * @author Cem (discofever)
 **/
class elFinderVolumeDropbox extends elFinderVolumeDriver {

    /**
     * Driver id
     * Must be started from letter and contains [a-z0-9]
     * Used as part of volume id
     *
     * @var string
     **/
    protected $driverId = 'd';

    /**
     * OAuth object
     *
     * @var oauth
     **/
    protected $oauth = null;

    /**
     * Dropbox object
     *
     * @var dropbox
     **/
    protected $dropbox = null;

    /**
     * Directory for meta data caches
     * If not set driver not cache meta data
     *
     * @var string
     **/
    protected $metaCache = '';

    /**
     * Last API error message
     *
     * @var string
     **/
    protected $apiError = '';

    /**
     * Directory for tmp files
     * If not set driver will try to use tmbDir as tmpDir
     *
     * @var string
     **/
    protected $tmp = '';
    
    /**
     * Dropbox.com uid
     *
     * @var string
     **/
    protected $dropboxUid = '';
    
    /**
     * Dropbox download host, replaces 'www.dropbox.com' of shares URL
     * 
     * @var string
     */
    private $dropbox_dlhost = 'dl.dropboxusercontent.com';
    
    private $dropbox_phpFound = false;
    
    private $DB_TableName = '';
    
    private $tmbPrefix = '';

    /**
     * Constructor
     * Extend options with required fields
     *
     * @author Dmitry (dio) Levashov
     * @author Cem (DiscoFever)
     */
    public function __construct() {

        // check with composer
        $this->dropbox_phpFound = class_exists('Dropbox_API');
        
        if (! $this->dropbox_phpFound) {
            // check with pear
            if (include_once 'Dropbox/autoload.php') {
                $this->dropbox_phpFound = in_array('Dropbox_autoload', spl_autoload_functions());
            }
        }
        
        $opts = array(
            'consumerKey'       => '',
            'consumerSecret'    => '',
            'accessToken'       => '',
            'accessTokenSecret' => '',
            'dropboxUid'        => '',
            'root'              => 'dropbox',
            'path'              => '/',
            'separator'         => '/',
            'PDO_DSN'           => '', // if empty use 'sqlite:(metaCachePath|tmbPath)/elFinder_dropbox_db_(hash:dropboxUid+consumerSecret)'
            'PDO_User'          => '',
            'PDO_Pass'          => '',
            'PDO_Options'       => array(),
            'PDO_DBName'        => 'dropbox',
            'treeDeep'          => 0,
            'tmbPath'           => '',
            'tmbURL'            => '',
            'tmpPath'           => '',
            'getTmbSize'        => 'large', // small: 32x32, medium or s: 64x64, large or m: 128x128, l: 640x480, xl: 1024x768
            'metaCachePath'     => '',
            'metaCacheTime'     => '600', // 10m
            'acceptedName'      => '#^[^/\\?*:|"<>]*[^./\\?*:|"<>]$#',
            'rootCssClass'      => 'elfinder-navbar-root-dropbox'
        );
        $this->options = array_merge($this->options, $opts);
        $this->options['mimeDetect'] = 'internal';
    }

    /**
     * Prepare
     * Call from elFinder::netmout() before volume->mount()
     *
     * @param $options
     * @return Array
     * @author Naoki Sawada
     */
    public function netmountPrepare($options) {
        if (empty($options['consumerKey']) && defined('ELFINDER_DROPBOX_CONSUMERKEY')) $options['consumerKey'] = ELFINDER_DROPBOX_CONSUMERKEY;
        if (empty($options['consumerSecret']) && defined('ELFINDER_DROPBOX_CONSUMERSECRET')) $options['consumerSecret'] = ELFINDER_DROPBOX_CONSUMERSECRET;
        
        if ($options['user'] === 'init') {

            if (! $this->dropbox_phpFound || empty($options['consumerKey']) || empty($options['consumerSecret']) || !class_exists('PDO', false)) {
                return array('exit' => true, 'body' => '{msg:errNetMountNoDriver}');
            }
            
            if (defined('ELFINDER_DROPBOX_USE_CURL_PUT')) {
                $this->oauth = new Dropbox_OAuth_Curl($options['consumerKey'], $options['consumerSecret']);
            } else {
                if (class_exists('OAuth', false)) {
                    $this->oauth = new Dropbox_OAuth_PHP($options['consumerKey'], $options['consumerSecret']);
                } else {
                    if (! class_exists('HTTP_OAuth_Consumer')) {
                        // We're going to try to load in manually
                        include 'HTTP/OAuth/Consumer.php';
                    }
                    if (class_exists('HTTP_OAuth_Consumer', false)) {
                        $this->oauth = new Dropbox_OAuth_PEAR($options['consumerKey'], $options['consumerSecret']);
                    }
                }
            }
            
            if (! $this->oauth) {
                return array('exit' => true, 'body' => '{msg:errNetMountNoDriver}');
            }

            if ($options['pass'] === 'init') {
                $html = '';
                if ($sessionToken = $this->session->get('DropboxTokens')) {
                    // token check
                    try {
                        list(, $accessToken, $accessTokenSecret) = $sessionToken;
                        $this->oauth->setToken($accessToken, $accessTokenSecret);
                        $this->dropbox = new Dropbox_API($this->oauth, $this->options['root']);
                        $this->dropbox->getAccountInfo();
                        $script = '<script>
                            $("#'.$options['id'].'").elfinder("instance").trigger("netmount", {protocol: "dropbox", mode: "done"});
                        </script>';
                        $html = $script;
                    } catch (Dropbox_Exception $e) {
                        $this->session->remove('DropboxTokens');
                    }
                }
                if (! $html) {
                    // get customdata
                    $cdata = '';
                    $innerKeys = array('cmd', 'host', 'options', 'pass', 'protocol', 'user');
                    $this->ARGS = $_SERVER['REQUEST_METHOD'] === 'POST'? $_POST : $_GET;
                    foreach($this->ARGS as $k => $v) {
                        if (! in_array($k, $innerKeys)) {
                            $cdata .= '&' . $k . '=' . rawurlencode($v);
                        }
                    }
                    if (strpos($options['url'], 'http') !== 0 ) {
                        $options['url'] = elFinder::getConnectorUrl();
                    }
                    $callback  = $options['url']
                               . '?cmd=netmount&protocol=dropbox&host=dropbox.com&user=init&pass=return&node='.$options['id'].$cdata;
                    
                    try {
                        $tokens = $this->oauth->getRequestToken();
                        $url= $this->oauth->getAuthorizeUrl(rawurlencode($callback));
                    } catch (Dropbox_Exception $e) {
                        return array('exit' => true, 'body' => '{msg:errAccess}');
                    }
                    
                    $this->session->set('DropboxAuthTokens', $tokens);
                    $html = '<input id="elf-volumedriver-dropbox-host-btn" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only" value="{msg:btnApprove}" type="button" onclick="window.open(\''.$url.'\')">';
                    $html .= '<script>
                        $("#'.$options['id'].'").elfinder("instance").trigger("netmount", {protocol: "dropbox", mode: "makebtn"});
                    </script>';
                }
                return array('exit' => true, 'body' => $html);
            } else {
                $this->oauth->setToken($this->session->get('DropboxAuthTokens'));
                $this->session->remove('DropboxAuthTokens');
                $tokens = $this->oauth->getAccessToken();
                $this->session->set('DropboxTokens', array($_GET['uid'], $tokens['token'], $tokens['token_secret']));
                
                $out = array(
                    'node' => $_GET['node'],
                    'json' => '{"protocol": "dropbox", "mode": "done"}',
                    'bind' => 'netmount'
                );
                
                return array('exit' => 'callback', 'out' => $out);
            }
        }
        if ($sessionToken = $this->session->get('DropboxTokens')) {
            list($options['dropboxUid'], $options['accessToken'], $options['accessTokenSecret']) = $sessionToken;
        }
        unset($options['user'], $options['pass']);
        return $options;
    }

    /**
     * process of on netunmount
     * Drop table `dropbox` & rm thumbs
     *
     * @param $netVolumes
     * @param $key
     * @return bool
     * @internal param array $options
     */
    public function netunmount($netVolumes, $key) {
        $count = 0;
        $dropboxUid = '';
        if (isset($netVolumes[$key])) {
            $dropboxUid = $netVolumes[$key]['dropboxUid'];
        }
        foreach($netVolumes as $volume) {
            if ($volume['host'] === 'dropbox' && $volume['dropboxUid'] === $dropboxUid) {
                $count++;
            }
        }
        if ($count === 1) {
            $this->DB->exec('drop table '.$this->DB_TableName);
            foreach(glob(rtrim($this->options['tmbPath'], '\\/').DIRECTORY_SEPARATOR.$this->tmbPrefix.'*.png') as $tmb) {
                unlink($tmb);
            }
        }
        return true;
    }
    
    /*********************************************************************/
    /*                        INIT AND CONFIGURE                         */
    /*********************************************************************/

    /**
     * Prepare FTP connection
     * Connect to remote server and check if credentials are correct, if so, store the connection id in $ftp_conn
     *
     * @return bool
     * @author Dmitry (dio) Levashov
     * @author Cem (DiscoFever)
     **/
    protected function init() {
        if (!class_exists('PDO', false)) {
            return $this->setError('PHP PDO class is require.');
        }
        
        if (!$this->options['consumerKey']
        ||  !$this->options['consumerSecret']
        ||  !$this->options['accessToken']
        ||  !$this->options['accessTokenSecret']) {
            return $this->setError('Required options undefined.');
        }
        
        if (empty($this->options['metaCachePath']) && defined('ELFINDER_DROPBOX_META_CACHE_PATH')) {
            $this->options['metaCachePath'] = ELFINDER_DROPBOX_META_CACHE_PATH;
        }
        
        // make net mount key
        $this->netMountKey = md5(join('-', array('dropbox', $this->options['path'])));

        if (! $this->oauth) {
            if (defined('ELFINDER_DROPBOX_USE_CURL_PUT')) {
                $this->oauth = new Dropbox_OAuth_Curl($this->options['consumerKey'], $this->options['consumerSecret']);
            } else {
                if (class_exists('OAuth', false)) {
                    $this->oauth = new Dropbox_OAuth_PHP($this->options['consumerKey'], $this->options['consumerSecret']);
                } else {
                    if (! class_exists('HTTP_OAuth_Consumer')) {
                        // We're going to try to load in manually
                        include 'HTTP/OAuth/Consumer.php';
                    }
                    if (class_exists('HTTP_OAuth_Consumer', false)) {
                        $this->oauth = new Dropbox_OAuth_PEAR($this->options['consumerKey'], $this->options['consumerSecret']);
                    }
                }
            }
        }
        
        if (! $this->oauth) {
            return $this->setError('OAuth extension not loaded.');
        }

        // normalize root path
        $this->root = $this->options['path'] = $this->_normpath($this->options['path']);

        if (empty($this->options['alias'])) {
            $this->options['alias'] = ($this->options['path'] === '/')? 'Dropbox.com'  : 'Dropbox'.$this->options['path'];
        }

        $this->rootName = $this->options['alias'];

        try {
            $this->oauth->setToken($this->options['accessToken'], $this->options['accessTokenSecret']);
            $this->dropbox = new Dropbox_API($this->oauth, $this->options['root']);
        } catch (Dropbox_Exception $e) {
            $this->session->remove('DropboxTokens');
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        
        // user
        if (empty($this->options['dropboxUid'])) {
            try {
                $res = $this->dropbox->getAccountInfo();
                $this->options['dropboxUid'] = $res['uid'];
            } catch (Dropbox_Exception $e) {
                $this->session->remove('DropboxTokens');
                return $this->setError('Dropbox error: '.$e->getMessage());
            }
        }
        
        $this->dropboxUid = $this->options['dropboxUid'];
        $this->tmbPrefix = 'dropbox'.base_convert($this->dropboxUid, 10, 32);

        if (!empty($this->options['tmpPath'])) {
            if ((is_dir($this->options['tmpPath']) || mkdir($this->options['tmpPath'])) && is_writable($this->options['tmpPath'])) {
                $this->tmp = $this->options['tmpPath'];
            }
        }
        if (!$this->tmp && is_writable($this->options['tmbPath'])) {
            $this->tmp = $this->options['tmbPath'];
        }
        if (!$this->tmp && ($tmp = elFinder::getStaticVar('commonTempPath'))) {
            $this->tmp = $tmp;
        }
        
        if (!empty($this->options['metaCachePath'])) {
            if ((is_dir($this->options['metaCachePath']) || mkdir($this->options['metaCachePath'])) && is_writable($this->options['metaCachePath'])) {
                $this->metaCache = $this->options['metaCachePath'];
            }
        }
        if (!$this->metaCache && $this->tmp) {
            $this->metaCache = $this->tmp;
        }
        
        if (!$this->metaCache) {
            return $this->setError('Cache dirctory (metaCachePath or tmp) is require.');
        }
        
        // setup PDO
        if (! $this->options['PDO_DSN']) {
            $this->options['PDO_DSN'] = 'sqlite:'.$this->metaCache.DIRECTORY_SEPARATOR.'.elFinder_dropbox_db_'.md5($this->dropboxUid.$this->options['consumerSecret']);
        }
        // DataBase table name
        $this->DB_TableName = $this->options['PDO_DBName'];
        // DataBase check or make table
        try {
            $this->DB = new PDO($this->options['PDO_DSN'], $this->options['PDO_User'], $this->options['PDO_Pass'], $this->options['PDO_Options']);
            if (! $this->checkDB()) {
                return $this->setError('Can not make DB table');
            }
        } catch (PDOException $e) {
            return $this->setError('PDO connection failed: '.$e->getMessage());
        }
        
        $res = $this->deltaCheck($this->isMyReload());
        if ($res !== true) {
            if (is_string($res)) {
                return $this->setError($res);
            } else {
                return $this->setError('Could not check API "delta"');
            }
        }
        
        if (is_null($this->options['syncChkAsTs'])) {
            $this->options['syncChkAsTs'] = true;
        }
        if ($this->options['syncChkAsTs']) {
            // 'tsPlSleep' minmum 5 sec
            $this->options['tsPlSleep'] = max(5, $this->options['tsPlSleep']);
        } else {
            // 'lsPlSleep' minmum 10 sec
            $this->options['lsPlSleep'] = max(10, $this->options['lsPlSleep']);
        }
        
        return true;
    }


    /**
     * Configure after successful mount.
     *
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function configure() {
        parent::configure();
        
        $this->disabled[] = 'archive';
        $this->disabled[] = 'extract';
    }
    
    /**
     * Check DB for delta cache
     * 
     * @return bool
     */
    private function checkDB() {
        $res = $this->query('SELECT * FROM sqlite_master WHERE type=\'table\' AND name=\''.$this->DB_TableName.'\'');
        if ($res && isset($_REQUEST['init'])) {
            // check is index(nameidx) UNIQUE?
            $chk = $this->query('SELECT sql FROM sqlite_master WHERE type=\'index\' and name=\'nameidx\'');
            if (!$chk || strpos(strtoupper($chk[0]), 'UNIQUE') === false) {
                // remake
                $this->DB->exec('DROP TABLE '.$this->DB_TableName);
                $res = false;
            }
        }
        if (! $res) {
            try {
                $this->DB->exec('CREATE TABLE '.$this->DB_TableName.'(path text, fname text, dat blob, isdir integer);');
                $this->DB->exec('CREATE UNIQUE INDEX nameidx ON '.$this->DB_TableName.'(path, fname)');
                $this->DB->exec('CREATE INDEX isdiridx ON '.$this->DB_TableName.'(isdir)');
            } catch (PDOException $e) {
                return $this->setError($e->getMessage());
            }
        }
        return true;
    }
    
    /**
     * DB query and fetchAll
     * 
     * @param string $sql
     * @return boolean|array
     */
    private function query($sql) {
        if ($sth = $this->DB->query($sql)) {
            $res = $sth->fetchAll(PDO::FETCH_COLUMN);
        } else {
            $res = false;
        }
        return $res;
    }
    
    /**
     * Get dat(dropbox metadata) from DB
     * 
     * @param string $path
     * @return array dropbox metadata
     */
    private function getDBdat($path) {
        if ($res = $this->query('select dat from '.$this->DB_TableName.' where path='.$this->DB->quote(strtolower($this->_dirname($path))).' and fname='.$this->DB->quote(strtolower($this->_basename($path))).' limit 1')) {
            return unserialize($res[0]);
        } else {
            return array();
        }
    }
    
    /**
     * Update DB dat(dropbox metadata)
     * 
     * @param string $path
     * @param array $dat
     * @return bool|array
     */
    private function updateDBdat($path, $dat) {
        return $this->query('update '.$this->DB_TableName.' set dat='.$this->DB->quote(serialize($dat))
                . ', isdir=' . ($dat['is_dir']? 1 : 0)
                . ' where path='.$this->DB->quote(strtolower($this->_dirname($path))).' and fname='.$this->DB->quote(strtolower($this->_basename($path))));
    }
    /*********************************************************************/
    /*                               FS API                              */
    /*********************************************************************/

    /**
     * Close opened connection
     *
     * @return void
     * @author Dmitry (dio) Levashov
     **/
    public function umount() {

    }
    
    /**
     * Get delta data and DB update
     * 
     * @param boolean $refresh force refresh
     * @return true|string error message
     */
    protected function deltaCheck($refresh = true) {
        $chk = false;
        if (! $refresh && $chk = $this->query('select dat from '.$this->DB_TableName.' where path=\'\' and fname=\'\' limit 1')) {
            $chk = unserialize($chk[0]);
        }
        if ($chk && ($chk['mtime'] + $this->options['metaCacheTime']) > $_SERVER['REQUEST_TIME']) {
            return true;
        }
        
        try {
            $more = true;
            $this->DB->beginTransaction();
            
            if ($res = $this->query('select dat from '.$this->DB_TableName.' where path=\'\' and fname=\'\' limit 1')) {
                $res = unserialize($res[0]);
                $cursor = $res['cursor'];
            } else {
                $cursor = '';
            }
            $delete = false;
            $reset = false;
            $ptimes = array();
            $now = time();
            do {
                 ini_set('max_execution_time', 120);
                $_info = $this->dropbox->delta($cursor);
                if (! empty($_info['reset'])) {
                    $this->DB->exec('TRUNCATE table '.$this->DB_TableName);
                    $this->DB->exec('insert into '.$this->DB_TableName.' values(\'\', \'\', \''.serialize(array('cursor' => '', 'mtime' => 0)).'\', 0);');
                    $this->DB->exec('insert into '.$this->DB_TableName.' values(\'/\', \'\', \''.serialize(array(
                        'path'      => '/',
                        'is_dir'    => 1,
                        'mime_type' => '',
                        'bytes'     => 0
                    )).'\', 0);');
                    $reset = true;
                }
                $cursor = $_info['cursor'];
                
                foreach($_info['entries'] as $entry) {
                    $key = strtolower($entry[0]);
                    $pkey = strtolower($this->_dirname($key));
                    
                    $path = $this->DB->quote($pkey);
                    $fname = $this->DB->quote(strtolower($this->_basename($key)));
                    $where = 'where path='.$path.' and fname='.$fname;
                    
                    if (empty($entry[1])) {
                        $ptimes[$pkey] = isset($ptimes[$pkey])? max(array($now, $ptimes[$pkey])) : $now;
                        $this->DB->exec('delete from '.$this->DB_TableName.' '.$where);
                        ! $delete && $delete = true;
                        continue;
                    }

                    $_itemTime = strtotime(isset($entry[1]['client_mtime'])? $entry[1]['client_mtime'] : $entry[1]['modified']);
                    $ptimes[$pkey] = isset($ptimes[$pkey])? max(array($_itemTime, $ptimes[$pkey])) : $_itemTime;
                    $sql = 'select path from '.$this->DB_TableName.' '.$where.' limit 1';
                    if (! $reset && $this->query($sql)) {
                        $this->DB->exec('update '.$this->DB_TableName.' set dat='.$this->DB->quote(serialize($entry[1])).', isdir='.($entry[1]['is_dir']? 1 : 0).' ' .$where);
                    } else {
                        $this->DB->exec('insert into '.$this->DB_TableName.' values ('.$path.', '.$fname.', '.$this->DB->quote(serialize($entry[1])).', '.(int)$entry[1]['is_dir'].')');
                    }
                }
            } while (! empty($_info['has_more']));
            
            // update time stamp of parent holder
            foreach ($ptimes as $_p => $_t) {
                if ($praw = $this->getDBdat($_p)) {
                    $_update = false;
                    if (isset($praw['client_mtime']) && $_t > strtotime($praw['client_mtime'])) {
                        $praw['client_mtime'] = date('r', $_t);
                        $_update = true;
                    }
                    if (isset($praw['modified']) && $_t > strtotime($praw['modified'])) {
                        $praw['modified'] = date('r', $_t);
                        $_update = true;
                    }
                    if ($_update) {
                        $pwhere = 'where path='.$this->DB->quote(strtolower($this->_dirname($_p))).' and fname='.$this->DB->quote(strtolower($this->_basename($_p)));
                        $this->DB->exec('update '.$this->DB_TableName.' set dat='.$this->DB->quote(serialize($praw)).' '.$pwhere);
                    }
                }
            }
            
            $this->DB->exec('update '.$this->DB_TableName.' set dat='.$this->DB->quote(serialize(array('cursor'=>$cursor, 'mtime'=>$_SERVER['REQUEST_TIME']))).' where path=\'\' and fname=\'\'');
            if (! $this->DB->commit()) {
                $e = $this->DB->errorInfo();
                return $e[2];
            }
            if ($delete) {
                $this->DB->exec('vacuum');
            }
        } catch(Dropbox_Exception $e) {
            return $e->getMessage();
        }
        return true;
    }
    
    /**
     * Parse line from dropbox metadata output and return file stat (array)
     *
     * @param  string  $raw  line from ftp_rawlist() output
     * @return array
     * @author Dmitry Levashov
     **/
    protected function parseRaw($raw) {
        $stat = array();

        $stat['rev']   = isset($raw['rev'])? $raw['rev'] : 'root';
        $stat['name']  = $this->_basename($raw['path']);
        $stat['mime']  = $raw['is_dir']? 'directory' : $raw['mime_type'];
        $stat['size']  = $stat['mime'] == 'directory' ? 0 : $raw['bytes'];
        $stat['ts']    = isset($raw['client_mtime'])? strtotime($raw['client_mtime']) :
                        (isset($raw['modified'])? strtotime($raw['modified']) : $_SERVER['REQUEST_TIME']);
        $stat['dirs'] = 0;
        if ($raw['is_dir']) {
            $stat['dirs'] = (int)(bool)$this->query('select path from '.$this->DB_TableName.' where isdir=1 and path='.$this->DB->quote(strtolower($raw['path'])));
        }
        
        if (!empty($raw['url'])) {
            $stat['url'] = $raw['url'];
        } else if (! $this->disabledGetUrl) {
            $stat['url'] = '1';
        }
        if (isset($raw['width'])) $stat['width'] = $raw['width'];
        if (isset($raw['height'])) $stat['height'] = $raw['height'];
        
        return $stat;
    }

    /**
     * Cache dir contents
     *
     * @param  string  $path  dir path
     * @return string
     * @author Dmitry Levashov
     **/
    protected function cacheDir($path) {
        $this->dirsCache[$path] = array();
        $hasDir = false;
        
        $res = $this->query('select dat from '.$this->DB_TableName.' where path='.$this->DB->quote(strtolower($path)));
        
        if ($res) {
            foreach($res as $raw) {
                $raw = unserialize($raw);
                if ($stat = $this->parseRaw($raw)) {
                    $stat = $this->updateCache($raw['path'], $stat);
                    if (empty($stat['hidden']) && $path !== $raw['path']) {
                        if (! $hasDir && $stat['mime'] === 'directory') {
                            $hasDir = true;
                        }
                        $this->dirsCache[$path][] = $raw['path'];
                    }
                }
            }
        }
        
        if (isset($this->sessionCache['subdirs'])) {
            $this->sessionCache['subdirs'][$path] = $hasDir;
        }
        
        return $this->dirsCache[$path];
    }

    /**
    * Recursive files search
    *
    * @param  string  $path   dir path
    * @param  string  $q      search string
    * @param  array   $mimes
    * @return array
    * @author Naoki Sawada
    **/
    protected function doSearch($path, $q, $mimes) {
        $result = array();
        $sth = $this->DB->prepare('select dat from '.$this->DB_TableName.' WHERE path LIKE ? AND fname LIKE ?');
        $sth->execute(array((($path === '/')? '' : strtolower($path)).'%', '%'.strtolower($q).'%'));
        $res = $sth->fetchAll(PDO::FETCH_COLUMN);
        $timeout = $this->options['searchTimeout']? $this->searchStart + $this->options['searchTimeout'] : 0;
        
        if ($res) {
            foreach($res as $raw) {
                if ($timeout && $timeout < time()) {
                    $this->setError(elFinder::ERROR_SEARCH_TIMEOUT, $this->path($this->encode($path)));
                    break;
                }
                
                $raw = unserialize($raw);
                if ($stat = $this->parseRaw($raw)) {
                    if (!isset($this->cache[$raw['path']])) {
                        $stat = $this->updateCache($raw['path'], $stat);
                    }
                    if (!empty($stat['hidden']) || ($mimes && $stat['mime'] === 'directory') || !$this->mimeAccepted($stat['mime'], $mimes)) {
                        continue;
                    }
                    $stat = $this->stat($raw['path']);
                    $stat['path'] = $this->path($stat['hash']);
                    $result[] = $stat;
                }
            }
        }
        return $result;
    }
    
    /**
    * Copy file/recursive copy dir only in current volume.
    * Return new file path or false.
    *
    * @param  string  $src   source path
    * @param  string  $dst   destination dir path
    * @param  string  $name  new file name (optionaly)
    * @return string|false
    * @author Dmitry (dio) Levashov
    * @author Naoki Sawada
    **/
    protected function copy($src, $dst, $name) {

        $this->clearcache();

        return $this->_copy($src, $dst, $name)
        ? $this->_joinPath($dst, $name)
        : $this->setError(elFinder::ERROR_COPY, $this->_path($src));
    }

    /**
     * Remove file/ recursive remove dir
     *
     * @param  string $path file path
     * @param  bool $force try to remove even if file locked
     * @param bool $recursive
     * @return bool
     * @author Dmitry (dio) Levashov
     * @author Naoki Sawada
     */
    protected function remove($path, $force = false, $recursive = false) {
        $stat = $this->stat($path);
        $stat['realpath'] = $path;
        $this->rmTmb($stat);
        $this->clearcache();
    
        if (empty($stat)) {
            return $this->setError(elFinder::ERROR_RM, $this->_path($path), elFinder::ERROR_FILE_NOT_FOUND);
        }
    
        if (!$force && !empty($stat['locked'])) {
            return $this->setError(elFinder::ERROR_LOCKED, $this->_path($path));
        }
    
        if ($stat['mime'] == 'directory') {
            if (!$recursive && !$this->_rmdir($path)) {
                return $this->setError(elFinder::ERROR_RM, $this->_path($path));
            }
        } else {
            if (!$recursive && !$this->_unlink($path)) {
                return $this->setError(elFinder::ERROR_RM, $this->_path($path));
            }
        }
    
        $this->removed[] = $stat;
        return true;
    }

    /**
     * Create thumnbnail and return it's URL on success
     *
     * @param  string $path file path
     * @param $stat
     * @return false|string
     * @internal param string $mime file mime type
     * @author Dmitry (dio) Levashov
     * @author Naoki Sawada
     */
    protected function createTmb($path, $stat) {
        if (!$stat || !$this->canCreateTmb($path, $stat)) {
            return false;
        }
    
        $name = $this->tmbname($stat);
        $tmb  = $this->tmbPath.DIRECTORY_SEPARATOR.$name;
    
        // copy image into tmbPath so some drivers does not store files on local fs
        if (! $data = $this->getThumbnail($path, $this->options['getTmbSize'])) {
            return false;
        }
        if (! file_put_contents($tmb, $data)) {
            return false;
        }
    
        $result = false;
    
        $tmbSize = $this->tmbSize;
    
        if (($s = getimagesize($tmb)) == false) {
            return false;
        }
    
        /* If image smaller or equal thumbnail size - just fitting to thumbnail square */
        if ($s[0] <= $tmbSize && $s[1]  <= $tmbSize) {
            $result = $this->imgSquareFit($tmb, $tmbSize, $tmbSize, 'center', 'middle', $this->options['tmbBgColor'], 'png' );
    
        } else {
    
            if ($this->options['tmbCrop']) {
    
                /* Resize and crop if image bigger than thumbnail */
                if (!(($s[0] > $tmbSize && $s[1] <= $tmbSize) || ($s[0] <= $tmbSize && $s[1] > $tmbSize) ) || ($s[0] > $tmbSize && $s[1] > $tmbSize)) {
                    $result = $this->imgResize($tmb, $tmbSize, $tmbSize, true, false, 'png');
                }
    
                if (($s = getimagesize($tmb)) != false) {
                    $x = $s[0] > $tmbSize ? intval(($s[0] - $tmbSize)/2) : 0;
                    $y = $s[1] > $tmbSize ? intval(($s[1] - $tmbSize)/2) : 0;
                    $result = $this->imgCrop($tmb, $tmbSize, $tmbSize, $x, $y, 'png');
                }
    
            } else {
                $result = $this->imgResize($tmb, $tmbSize, $tmbSize, true, true, 'png');
            }
        
            $result = $this->imgSquareFit($tmb, $tmbSize, $tmbSize, 'center', 'middle', $this->options['tmbBgColor'], 'png' );
        }
        
        if (!$result) {
            unlink($tmb);
            return false;
        }
    
        return $name;
    }
    
    /**
     * Return thumbnail file name for required file
     *
     * @param  array  $stat  file stat
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function tmbname($stat) {
        return $this->tmbPrefix.$stat['rev'].'.png';
    }
    
    /**
     * Get thumbnail from dropbox.com
     * @param string $path
     * @param string $size
     * @return string | boolean
     */
    protected function getThumbnail($path, $size = 'small') {
        try {
            return $this->dropbox->getThumbnail($path, $size);
        } catch (Dropbox_Exception $e) {
            return false;
        }
    }
    
    /**
    * Return content URL
    *
    * @param string  $hash  file hash
    * @param array $options options
    * @return array
    * @author Naoki Sawada
    **/
    public function getContentUrl($hash, $options = array()) {
        if (($file = $this->file($hash)) == false || !$file['url'] || $file['url'] == 1) {
            $path = $this->decode($hash);
            $cache = $this->getDBdat($path);
            $url = '';
            if (isset($cache['share']) && strpos($cache['share'], $this->dropbox_dlhost) !== false) {
                $res = $this->getHttpResponseHeader($cache['share']);
                if (preg_match("/^HTTP\/[01\.]+ ([0-9]{3})/", $res, $match)) {
                    if ($match[1] < 400) {
                        $url = $cache['share'];
                    }
                }
            }
            if (! $url) {
                try {
                    $res = $this->dropbox->share($path, null, false);
                    $url = $res['url'];
                    if (strpos($url, 'www.dropbox.com') === false) {
                        $res = $this->getHttpResponseHeader($url);
                        if (preg_match('/^location:\s*(http[^\s]+)/im', $res, $match)) {
                            $url = $match[1];
                        }
                    }
                    list($url) = explode('?', $url);
                    $url = str_replace('www.dropbox.com', $this->dropbox_dlhost, $url);
                    if (! isset($cache['share']) || $cache['share'] !== $url) {
                        $cache['share'] = $url;
                        $this->updateDBdat($path, $cache);
                    }
                } catch (Dropbox_Exception $e) {
                    return false;
                }
            }
            return $url;
        }
        return $file['url'];
    }
    
    /**
     * Get HTTP request response header string
     * 
     * @param string $url target URL
     * @return string
     * @author Naoki Sawada
     */
    private function getHttpResponseHeader($url) {
        if (function_exists('curl_exec')) {

            $c = curl_init();
            curl_setopt( $c, CURLOPT_RETURNTRANSFER, true );
            curl_setopt( $c, CURLOPT_CUSTOMREQUEST, 'HEAD' );
            curl_setopt( $c, CURLOPT_HEADER, 1 );
            curl_setopt( $c, CURLOPT_NOBODY, true );
            curl_setopt( $c, CURLOPT_URL, $url );
            $res = curl_exec( $c );
            
        } else {
            
            require_once 'HTTP/Request2.php';
            try {
                $request2 = new HTTP_Request2();
                $request2->setConfig(array(
                    'ssl_verify_peer' => false,
                    'ssl_verify_host' => false
                ));
                $request2->setUrl($url);
                $request2->setMethod(HTTP_Request2::METHOD_HEAD);
                $result = $request2->send();
                $res = array();
                $res[] = 'HTTP/'.$result->getVersion().' '.$result->getStatus().' '.$result->getReasonPhrase();
                foreach($result->getHeader() as $key => $val) {
                    $res[] = $key . ': ' . $val;
                }
                $res = join("\r\n", $res);
            } catch( HTTP_Request2_Exception $e ){
                $res = '';
            } catch (Exception $e){
                $res = '';
            }
        
        }
        return $res;
    }
    
    /*********************** paths/urls *************************/

    /**
     * Return parent directory path
     *
     * @param  string  $path  file path
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _dirname($path) {
        return $this->_normpath(substr($path, 0, strrpos($path, '/')));
    }

    /**
     * Return file name
     *
     * @param  string  $path  file path
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _basename($path) {
        return substr($path, strrpos($path, '/') + 1);
    }

    /**
     * Join dir name and file name and retur full path
     *
     * @param  string  $dir
     * @param  string  $name
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _joinPath($dir, $name) {
        return $this->_normpath($dir.'/'.$name);
    }

    /**
     * Return normalized path, this works the same as os.path.normpath() in Python
     *
     * @param  string  $path  path
     * @return string
     * @author Troex Nevelin
     **/
    protected function _normpath($path) {
        $path = '/' . ltrim($path, '/');
        return $path;
    }

    /**
     * Return file path related to root dir
     *
     * @param  string  $path  file path
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _relpath($path) {
        return $path;
    }

    /**
     * Convert path related to root dir into real path
     *
     * @param  string  $path  file path
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _abspath($path) {
        return $path;
    }

    /**
     * Return fake path started from root dir
     *
     * @param  string  $path  file path
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _path($path) {
        return $this->rootName . $this->_normpath(substr($path, strlen($this->root)));
    }

    /**
     * Return true if $path is children of $parent
     *
     * @param  string  $path    path to check
     * @param  string  $parent  parent path
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _inpath($path, $parent) {
        return $path == $parent || strpos($path, $parent.'/') === 0;
    }

    /***************** file stat ********************/
    /**
     * Return stat for given path.
     * Stat contains following fields:
     * - (int)    size    file size in b. required
     * - (int)    ts      file modification time in unix time. required
     * - (string) mime    mimetype. required for folders, others - optionally
     * - (bool)   read    read permissions. required
     * - (bool)   write   write permissions. required
     * - (bool)   locked  is object locked. optionally
     * - (bool)   hidden  is object hidden. optionally
     * - (string) alias   for symlinks - link target path relative to root path. optionally
     * - (string) target  for symlinks - link target path. optionally
     *
     * If file does not exists - returns empty array or false.
     *
     * @param  string  $path    file path
     * @return array|false
     * @author Dmitry (dio) Levashov
     **/
    protected function _stat($path) {
        //if (!empty($this->ARGS['reload']) && isset($this->ARGS['target']) && strpos($this->ARGS['target'], $this->id) === 0) {
        if ($this->isMyReload()) {
            $this->deltaCheck();
        }
        if ($raw = $this->getDBdat($path)) {
            return $this->parseRaw($raw);
        }
        return false;
    }

    /**
     * Return true if path is dir and has at least one childs directory
     *
     * @param  string  $path  dir path
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _subdirs($path) {
        return ($stat = $this->stat($path)) && isset($stat['dirs']) ? $stat['dirs'] : false;
    }

    /**
     * Return object width and height
     * Ususaly used for images, but can be realize for video etc...
     *
     * @param  string  $path  file path
     * @param  string  $mime  file mime type
     * @return string
     * @author Dmitry (dio) Levashov
     **/
    protected function _dimensions($path, $mime) {
        if (strpos($mime, 'image') !== 0) return '';
        $cache = $this->getDBdat($path);
        if (isset($cache['width']) && isset($cache['height'])) {
            return $cache['width'].'x'.$cache['height'];
        }
        $ret = '';
        if ($work = $this->getWorkFile($path)) {
            if ($size = getimagesize($work)) {
                $cache['width'] = $size[0];
                $cache['height'] = $size[1];
                $this->updateDBdat($path, $cache);
                $ret = $size[0].'x'.$size[1];
            }
        }
        is_file($work) && unlink($work);
        return $ret;
    }

    /******************** file/dir content *********************/

    /**
     * Return files list in directory.
     *
     * @param  string  $path  dir path
     * @return array
     * @author Dmitry (dio) Levashov
     * @author Cem (DiscoFever)
     **/
    protected function _scandir($path) {
        return isset($this->dirsCache[$path])
            ? $this->dirsCache[$path]
            : $this->cacheDir($path);
    }

    /**
     * Open file and return file pointer
     *
     * @param  string $path file path
     * @param string $mode
     * @return false|resource
     * @internal param bool $write open file for writing
     * @author Dmitry (dio) Levashov
     */
    protected function _fopen($path, $mode='rb') {

        if (($mode == 'rb' || $mode == 'r')) {
            try {
                $res = $this->dropbox->media($path);
                $url = parse_url($res['url']);
                $fp = stream_socket_client('ssl://'.$url['host'].':443');
                fputs($fp, "GET {$url['path']} HTTP/1.0\r\n");
                fputs($fp, "Host: {$url['host']}\r\n");
                fputs($fp, "\r\n");
                while(trim(fgets($fp)) !== ''){};
                return $fp;
            } catch (Dropbox_Exception $e) {
                return false;
            }
        }
        
        if ($this->tmp) {
            $contents = $this->_getContents($path);
            
            if ($contents === false) {
                return false;
            }
            
            if ($local = $this->getTempFile($path)) {
                if (file_put_contents($local, $contents, LOCK_EX) !== false) {
                    return fopen($local, $mode);
                }
            }
        }

        return false;
    }

    /**
     * Close opened file
     *
     * @param  resource $fp file pointer
     * @param string $path
     * @return bool
     * @author Dmitry (dio) Levashov
     */
    protected function _fclose($fp, $path='') {
        fclose($fp);
        if ($path) {
            unlink($this->getTempFile($path));
        }
    }

    /********************  file/dir manipulations *************************/

    /**
     * Create dir and return created dir path or false on failed
     *
     * @param  string  $path  parent dir path
     * @param string  $name  new directory name
     * @return string|bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _mkdir($path, $name) {
        $path = $this->_normpath($path.'/'.$name);
        try {
            $this->dropbox->createFolder($path);
        } catch (Dropbox_Exception $e) {
            $this->deltaCheck();
            if ($this->dir($this->encode($path))) {
                return $path;
            }
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        $this->deltaCheck();
        return $path;
    }

    /**
     * Create file and return it's path or false on failed
     *
     * @param  string  $path  parent dir path
     * @param string  $name  new file name
     * @return string|bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _mkfile($path, $name) {
        return $this->_filePutContents($path.'/'.$name, '');
    }

    /**
     * Create symlink. FTP driver does not support symlinks.
     *
     * @param  string $target link target
     * @param  string $path symlink path
     * @param string $name
     * @return bool
     * @author Dmitry (dio) Levashov
     */
    protected function _symlink($target, $path, $name) {
        return false;
    }

    /**
     * Copy file into another file
     *
     * @param  string  $source     source file path
     * @param  string  $targetDir  target directory path
     * @param  string  $name       new file name
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _copy($source, $targetDir, $name) {
        $path = $this->_normpath($targetDir.'/'.$name);
        try {
            $this->dropbox->copy($source, $path);
        } catch (Dropbox_Exception $e) {
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        $this->deltaCheck();
        return true;
    }

    /**
     * Move file into another parent dir.
     * Return new file path or false.
     *
     * @param  string $source source file path
     * @param $targetDir
     * @param  string $name file name
     * @return bool|string
     * @internal param string $target target dir path
     * @author Dmitry (dio) Levashov
     */
    protected function _move($source, $targetDir, $name) {
        $target = $this->_normpath($targetDir.'/'.$name);
        try {
            $this->dropbox->move($source, $target);
        } catch (Dropbox_Exception $e) {
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        $this->deltaCheck();
        return $target;
    }

    /**
     * Remove file
     *
     * @param  string  $path  file path
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _unlink($path) {
        try {
            $this->dropbox->delete($path);
        } catch (Dropbox_Exception $e) {
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        $this->deltaCheck();
        return true;
    }

    /**
     * Remove dir
     *
     * @param  string  $path  dir path
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _rmdir($path) {
        return $this->_unlink($path);
    }

    /**
     * Create new file and write into it from file pointer.
     * Return new file path or false on error.
     *
     * @param  resource $fp file pointer
     * @param string $path
     * @param  string $name file name
     * @param  array $stat file stat (required by some virtual fs)
     * @return bool|string
     * @internal param string $dir target dir path
     * @author Dmitry (dio) Levashov
     */
    protected function _save($fp, $path, $name, $stat) {
        if ($name) $path .= '/'.$name;
        $path = $this->_normpath($path);
        try {
            $this->dropbox->putFile($path, $fp);
        } catch (Dropbox_Exception $e) {
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        $this->deltaCheck();
        if (is_array($stat)) {
            $raw = $this->getDBdat($path);
            if (isset($stat['width'])) $raw['width'] = $stat['width'];
            if (isset($stat['height'])) $raw['height'] = $stat['height'];
            $this->updateDBdat($path, $raw);
        }
        return $path;
    }

    /**
     * Get file contents
     *
     * @param  string  $path  file path
     * @return string|false
     * @author Dmitry (dio) Levashov
     **/
    protected function _getContents($path) {
        $contents = '';
        try {
            $contents = $this->dropbox->getFile($path);
        } catch (Dropbox_Exception $e) {
            return $this->setError('Dropbox error: '.$e->getMessage());
        }
        return $contents;
    }

    /**
     * Write a string to a file
     *
     * @param  string  $path     file path
     * @param  string  $content  new file content
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _filePutContents($path, $content) {
        $res = false;

        if ($local = $this->getTempFile($path)) {
            if (file_put_contents($local, $content, LOCK_EX) !== false
            && ($fp = fopen($local, 'rb'))) {
                clearstatcache();
                $res = $this->_save($fp, $path, '', array());
                fclose($fp);
            }
            file_exists($local) && unlink($local);
        }

        return $res;
    }

    /**
     * Detect available archivers
     *
     * @return array
     **/
    protected function _checkArchivers() {
        // die('Not yet implemented. (_checkArchivers)');
        return array();
    }

    /**
     * chmod implementation
     *
     * @param string $path
     * @param string $mode
     * @return bool
     */
    protected function _chmod($path, $mode) {
        return false;
    }

    /**
     * Unpack archive
     *
     * @param  string  $path  archive path
     * @param  array   $arc   archiver command and arguments (same as in $this->archivers)
     * @return true
     * @return void
     * @author Dmitry (dio) Levashov
     * @author Alexey Sukhotin
     **/
    protected function _unpack($path, $arc) {
        die('Not yet implemented. (_unpack)');
    }

    /**
     * Recursive symlinks search
     *
     * @param  string  $path  file/dir path
     * @return bool
     * @author Dmitry (dio) Levashov
     **/
    protected function _findSymlinks($path) {
        die('Not yet implemented. (_findSymlinks)');
    }

    /**
     * Extract files from archive
     *
     * @param  string  $path  archive path
     * @param  array   $arc   archiver command and arguments (same as in $this->archivers)
     * @return true
     * @author Dmitry (dio) Levashov,
     * @author Alexey Sukhotin
     **/
    protected function _extract($path, $arc) {
        die('Not yet implemented. (_extract)');

    }

    /**
     * Create archive and return its path
     *
     * @param  string  $dir    target dir
     * @param  array   $files  files names list
     * @param  string  $name   archive name
     * @param  array   $arc    archiver options
     * @return string|bool
     * @author Dmitry (dio) Levashov,
     * @author Alexey Sukhotin
     **/
    protected function _archive($dir, $files, $name, $arc) {
        die('Not yet implemented. (_archive)');
    }

} // END class