public function process(Vtiger_Request $request) { $adb = \PearDatabase::getInstance(); if (!\SwVtTools\VtUtils::existTable('vtiger_gcal_sync')) { $adb->query("CREATE TABLE IF NOT EXISTS `vtiger_gcal_sync` (\n `user_id` int(11) NOT NULL,\n `calendar_id` varchar(500) NOT NULL\n ) ENGINE=InnoDB;"); } }
function checkDB() { $adb = \PearDatabase::getInstance(); if (!\SwVtTools\VtUtils::existTable("vtiger_tools_sidebar")) { echo "Create table vtiger_tools_sidebar ... ok<br>"; $adb->query("CREATE TABLE IF NOT EXISTS `vtiger_tools_sidebar` (\n `id` mediumint(8) unsigned NOT NULL,\n `active` TINYINT(1) NOT NULL,\n `tabid` mediumint(8) NOT NULL,\n `content` TEXT NOT NULL,\n `title` VARCHAR(128) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB;"); } if (!\SwVtTools\VtUtils::existTable("vtiger_tools_sidebar_seq")) { echo "Create table vtiger_tools_sidebar_seq ... ok<br>"; $adb->query("CREATE TABLE IF NOT EXISTS `vtiger_tools_sidebar_seq` (\n `id` mediumint(8) unsigned NOT NULL\n ) ENGINE=InnoDB;"); $adb->query("INSERT INTO vtiger_tools_sidebar_seq SET id = 1"); } }
* Created by JetBrains PhpStorm. * User: Stefan Warnat <*****@*****.**> * Date: 31.10.14 13:06 * You must not use this file without permission. */ require_once 'modules/SwVtTools/lib/SwVtTools/VtUtils.php'; $adb = \PearDatabase::getInstance(); if (empty($current_language)) { $current_language = 'en_us'; } $app_strings = return_application_language($current_language); $sql = 'SELECT * FROM vtiger_google_sync WHERE googlemodule = "Calendar"'; $result = $adb->query($sql); $oldCurrentUser2 = vglobal('current_user'); $enableSharedCalendar = false; if (\SwVtTools\VtUtils::existTable('vtiger_gcal_sync')) { $enableSharedCalendar = true; } $listView = new Google_List_View(); echo 'GoogleCal Sync' . PHP_EOL; while ($user = $adb->fetchByAssoc($result)) { $user2 = CRMEntity::getInstance('Users'); $user2->retrieveCurrentUserInfoFromFile($user['user']); vglobal('current_user', $user2); $controller = new Google_Calendar_Controller($user2); if ($enableSharedCalendar === true && method_exists($controller, 'getCalendarId')) { $calId = $controller->getCalendarId(); $controller->setCalendarId($calId); } if ($enableSharedCalendar === true && !method_exists($controller, 'getCalendarId')) { $enableSharedCalendar = false;