function doesExistTable($tablename) { global $database; static $tables = array(); if (empty($tables)) { $tables = POD::tableList($database['prefix']); } $dbCaseInsensitive = Setting::getServiceSetting('lowercaseTableNames', null, 'global'); if ($dbCaseInsensitive === null) { if (in_array(POD::dbms(), array('MySQL', 'MySQLi'))) { $result = POD::queryRow("SHOW VARIABLES LIKE 'lower_case_table_names'"); $dbCaseInsensitive = $result['Value'] == 1 ? 1 : 0; } else { $dbCaseInsensitive = 1; } Setting::setServiceSetting('lowercaseTableNames', $dbCaseInsensitive, true); } if ($dbCaseInsensitive == 1) { $tablename = strtolower($tablename); } if (in_array($tablename, $tables)) { return true; } return false; }
function setBlogVersion() { $version = TEXTCUBE_VERSION_ID; if (defined('__TEXTCUBE_GAE__')) { Setting::setServiceSetting('blogVersion', $version, true); return; } $fp = fopen(__TEXTCUBE_CHECKUP_FILE__, 'w'); if ($fp !== FALSE) { fwrite($fp, $version); fclose($fp); @chmod(__TEXTCUBE_CHECKUP_FILE__, 0666); } }
function dumbCronScheduler($checkOnly = true) { $context = Model_Context::getInstance(); $now = Timestamp::getUNIXtime(); $dumbCronStamps = Setting::getServiceSetting('dumbCronStamps', serialize(array('1m' => 0, '5m' => 0, '30m' => 0, '1h' => 0, '2h' => 0, '6h' => 0, '12h' => 0, '24h' => 0, 'Daily' => 0)), true); $dumbCronStamps = unserialize($dumbCronStamps); $schedules = array('1m' => 60, '5m' => 60 * 5, '10m' => 60 * 10, '30m' => 60 * 30, '1h' => 60 * 60, '2h' => 60 * 60 * 2, '6h' => 60 * 60 * 6, '12h' => 60 * 60 * 12, '24h' => 60 * 60 * 24, 'Daily' => 60 * 60 * 24, '1w' => 60 * 60 * 24 * 7); /* Events: Cron1m, Cron5m, Cron30m, Cron1h, Cron2h, Cron6h, Cron12h */ $log_file = __TEXTCUBE_CACHE_DIR__ . '/cronlog.txt'; $log = fopen($log_file, "a"); foreach ($schedules as $d => $diff) { if (!isset($dumbCronStamps[$d])) { $dumbCronStamps[$d] = 0; } if ($now > $diff + $dumbCronStamps[$d]) { if ($checkOnly && eventExists("Cron{$d}")) { fclose($log); return true; } fireEvent("Cron{$d}", null, $now); if ($d == '6h') { importlib('model.blog.trash'); trashVan(); } fwrite($log, date('Y-m-d H:i:s') . ' ' . $context->getProperty('blog.name') . " Cron{$d} executed ({$_SERVER['REQUEST_URI']})\r\n"); $dumbCronStamps[$d] = $now; } } fclose($log); /* Keep just 1000 lines */ $logcontent = explode("\r\n", file_get_contents($log_file)); $logcontent = implode("\r\n", array_slice($logcontent, -1000)); $log = fopen($log_file, "w"); fwrite($log, $logcontent); fclose($log); Setting::setServiceSetting('dumbCronStamps', serialize($dumbCronStamps), true); return false; }
function setServiceSetting($name, $value) { return Setting::setServiceSetting($name, true); }
function treatPluginTable($plugin, $name, $fields, $keys, $version) { $context = Model_Context::getInstance(); $query = DBModel::getInstance(); if (doesExistTable($context->getProperty('database.prefix') . $name)) { $keyname = 'Database_' . $name; $value = $plugin; $result = Setting::getServiceSetting($keyname, null, true); if (is_null($result)) { $keyname = Utils_Unicode::lessenAsEncoding($keyname, 32); $value = Utils_Unicode::lessenAsEncoding($plugin . '/' . $version, 255); $query->reset('ServiceSettings'); $query->setAttribute('name', $keyname, true); $query->setAttribute('value', $value, true); $query->insert(); } else { $keyname = Utils_Unicode::lessenAsEncoding($keyname, 32); $value = Utils_Unicode::lessenAsEncoding($plugin . '/' . $version, 255); $values = explode('/', $result, 2); if (strcmp($plugin, $values[0]) != 0) { // diff plugin return false; // nothing can be done } else { if (strcmp($version, $values[1]) != 0) { $query->reset('ServiceSettings'); $query->setQualifier('name', 'equals', $keyname, true); $query->setAttribute('value', $value, true); $query->update(); $eventName = 'UpdateDB_' . $name; fireEvent($eventName, $values[1]); } } } return true; } else { $query->init($name); $query->structure = array("blogid" => array("type" => 'integer', "isNull" => false, "default" => 0, "index" => true)); $isaiExists = false; foreach ($fields as $field) { $branch = array(); $ai = ''; if (strtolower($field['attribute']) == 'int' || strtolower($field['attribute']) == 'mediumint') { if ($field['autoincrement'] == 1 && !$isaiExists) { $branch['autoincrement'] = true; //$branch['index'] = true; $isaiExists = true; if (!in_array($field['name'], $keys)) { $branch['index'] = true; } } } $branch['type'] = strtolower($field['attribute']); if ($field['isnull'] == 0) { $branch['isNull'] = false; } else { $branch['isNull'] = true; } if (!is_null($field['default'])) { $branch['default'] = $field['default']; } if ($field['length'] >= 0) { $branch['length'] = $field['length']; } $query->structure[$field['name']] = $branch; } array_unshift($keys, 'blogid'); $query->option['primary'] = $keys; if ($query->create()) { $keyname = Utils_Unicode::lessenAsEncoding('Database_' . $name, 32); $value = Utils_Unicode::lessenAsEncoding($plugin . '/' . $version, 255); Setting::setServiceSetting($keyname, $value, true); return true; } else { return false; } } return true; }
function updateRandomFeed() { global $database; $updatecycle = POD::queryCell("SELECT updatecycle FROM {$database['prefix']}FeedSettings LIMIT 1"); if ($updatecycle != 0) { if ($feed = POD::queryRow("SELECT * FROM {$database['prefix']}Feeds WHERE modified < " . (gmmktime() - $updatecycle * 60) . " ORDER BY RAND() LIMIT 1")) { Setting::setServiceSetting('lastFeedUpdate', gmmktime(), true); return array(updateFeed($feed), $feed['xmlurl']); } } return array(1, 'No feeds to update'); }
function getDefaultCenterPanel($mapping) { $ctx = Model_Context::getInstance(); $blogid = $ctx->getProperty('blog.id'); ?> <div id="<?php echo $mapping['plugin']; ?> " class="section"> <h3 class="caption<?php echo isset($_REQUEST['edit']) ? ' visible' : ' invisible'; ?> "> <span><?php echo _t('알림판'); if (isset($_REQUEST['edit'])) { ?> <a id="<?php echo $mapping['plugin']; ?> widgetup" href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/center/dashboard?edit&pos=<?php echo $positionCounter; ?> &rel=-1&edit"><?php echo _t('위로'); ?> </a> <a id="<?php echo $mapping['plugin']; ?> widgetdown" href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/center/dashboard?edit&pos=<?php echo $positionCounter; ?> &rel=1&edit"><?php echo _t('아래로'); ?> </a> <?php } ?> </span> </h3> <?php if (isset($_REQUEST['edit'])) { ?> </div> <?php return true; } else { // Get default data $stats = Statistics::getStatistics($blogid); $latestEntryId = Setting::getBlogSettingGlobal('LatestEditedEntry_user' . getUserId(), 0); $comments = getRecentComments($blogid, 10); $guestbooks = getRecentGuestbook($blogid, 10); list($commentNotifies, $paging) = getCommentsNotifiedWithPagingForOwner($blogid, 0, null, null, null, 1, 10); $trackbacks = getRecentTrackbacks($blogid, 10); $recents = array(); // title, date, link, category foreach ($comments as $comment) { array_push($recents, array('title' => $comment['comment'], 'date' => $comment['written'], 'link' => $ctx->getProperty('uri.blog') . "/" . $comment['entry'] . "#comment" . $comment['id'], 'category' => 'comment')); } foreach ($commentNotifies as $comment) { array_push($recents, array('title' => $comment['comment'], 'date' => $comment['written'], 'link' => $ctx->getProperty('uri.blog') . "/owner/communication/notify", 'category' => 'commentNotify')); } foreach ($guestbooks as $guestbook) { array_push($recents, array('title' => $guestbook['comment'], 'date' => $guestbook['written'], 'link' => $ctx->getProperty('uri.blog') . "/guestbook/" . $guestbook['id'] . "#guestbook" . $guestbook['id'], 'category' => 'guestbook')); } foreach ($trackbacks as $trackback) { array_push($recents, array('title' => $trackback['subject'], 'date' => $trackback['written'], 'link' => $ctx->getProperty('uri.blog') . "/" . $trackback['entry'] . "#trackback" . $trackback['id'], 'category' => 'trackback')); } $sort_array = array(); foreach ($recents as $uniqid => $row) { // Sorting. foreach ($row as $key => $value) { if (!array_key_exists($key, $sort_array)) { $sort_array[$key] = array(); } $sort_array[$key][$uniqid] = $value; } } if (!empty($sort_array)) { array_multisort($sort_array['date'], SORT_DESC, $recents); } $recents = array_slice($recents, 0, 14); ?> <div id="shortcut-collection"> <h4 class="caption"><span><?php echo _t('바로가기'); ?> </span></h4> <ul> <li class="newPost"><a class="newPost" href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/entry/post"><span><?php echo _t('새 글 쓰기'); ?> </span></a></li> <?php if ($latestEntryId !== 0) { $latestEntry = getEntry($blogid, $latestEntryId); if (!is_null($latestEntry)) { ?> <li class="modifyPost"><a href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/entry/edit/<?php echo $latestEntry['id']; ?> "><?php echo _f('최근글(%1) 수정', htmlspecialchars(Utils_Unicode::lessenAsEm($latestEntry['title'], 10))); ?> </a></li> <?php } } if ($ctx->getProperty('service.reader') == true) { ?> <li class="rssReader"><a href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/network/reader"><?php echo _t('RSS로 등록한 이웃 글 보기'); ?> </a></li> <?php } if (Acl::check("group.administrators")) { ?> <li class="deleteCache"><a href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/center/dashboard/cleanup" onclick="cleanupCache();return false;"><?php echo _t('캐시 지우기'); ?> </a></li> <?php if (Acl::check("group.creators")) { ?> <li class="optimizeStorage"><a href="<?php echo $ctx->getProperty('uri.blog'); ?> /owner/data" onclick="optimizeData();return false;"><?php echo _t('저장소 최적화'); ?> </a></li> <?php } } ?> <li class="clear"></li> </ul> </div> <div id="total-information"> <h4 class="caption"><span><?php echo _t('요약'); ?> </span></h4> <table class="posts-line"> <caption><?php echo _t('글'); ?> </caption> <thead> <th>type</th> <th>sum</th> </thead> <tbody> <tr> <td class="type"><?php echo _t('글'); ?> </td> <td class="sum"><?php echo number_format(getEntriesTotalCount($blogid)); ?> </td> </tr> <tr> <td class="type"><?php echo _t('댓글'); ?> </td> <td class="sum"><?php echo number_format(getCommentCount($blogid)); ?> </td> </tr> <tr> <td class="type"><?php echo _t('방명록'); ?> </td> <td class="sum"><?php echo number_format(getGuestbookCount($blogid)); ?> </td> </tr> <tr> <td class="type"><?php echo _t('걸린 글'); ?> </td> <td class="sum"><?php echo number_format(getTrackbackCount($blogid)); ?> </td> </tr> </tbody> </table> <table class="visitors-line"> <caption><?php echo _t('방문자'); ?> </caption> <thead> <th>type</th> <th>sum</th> </thead> <tbody> <tr> <td class="type"><?php echo _t('오늘'); ?> </td> <td class="sum"><?php echo number_format($stats['today']); ?> </td> </tr> <tr> <td class="type"><?php echo _t('어제'); ?> </td> <td class="sum"><?php echo number_format($stats['yesterday']); ?> </td> </tr> <tr> <td class="type"><?php echo _t('7일 평균'); ?> </td> <td class="sum"><?php $weekly = Statistics::getWeeklyStatistics(); $weeklycount = 0; foreach ($weekly as $day) { $weeklycount += $day['visits']; } echo number_format($weeklycount / 7); unset($weekly); unset($weeklycount); ?> </td> </tr> <tr> <td class="type"><?php echo _t('총방문자'); ?> </td> <td class="sum"><?php echo number_format($stats['total']); ?> </td> </tr> </tbody> </table> </div> <div id="myBlogInfo"> <h4 class="caption"><span><a href="<?php echo $ctx->getProperty('uri.blog') . '/owner/communication/comment'; ?> "><?php echo _t('알림판'); ?> </a></span></h4> <table class="recent"> <caption>asdasd</caption> <thead> <tr> <th scope="col" class="date"><?php echo _t('날짜'); ?> </th> <th scope="col" class="category"><?php echo _t('종류'); ?> </th> <th scope="col"><?php echo _t('내용'); ?> </th> </tr> </thead> <tbody> <?php foreach ($recents as $item) { ?> <tr class="<?php echo $item['category']; ?> "> <td class="date"><?php echo Timestamp::format('%m/%d', $item['date']); ?> </td> <td class="category"> <?php switch ($item['category']) { case 'trackback': echo '<a href="' . $ctx->getProperty('uri.blog') . '/owner/communication/trackback?status=received">' . _t('걸린글') . '</a>'; break; case 'comment': echo '<a href="' . $ctx->getProperty('uri.blog') . '/owner/communication/comment?status=comment">' . _t('댓글') . '</a>'; break; case 'commentNotify': echo '<a href="' . $ctx->getProperty('uri.blog') . '/owner/communication/notify">' . _t('알리미') . '</a>'; break; case 'guestbook': echo '<a href="' . $ctx->getProperty('uri.blog') . '/owner/communication/comment?status=guestbook">' . _t('방명록') . '</a>'; break; } ?> </td> <td class="title"><a href="<?php echo $item['link']; ?> "><?php echo htmlspecialchars(Utils_Unicode::lessenAsEm($item['title'], 20)); ?> </a></td> </tr> <?php } ?> </tbody> </table> </div> <?php $noticeURL = TEXTCUBE_NOTICE_URL; $noticeURLRSS = $noticeURL . ($ctx->getProperty('blog.language') ? $ctx->getProperty('blog.language') : "ko") . "/rss"; $noticeEntries = array(); if (!is_null(Setting::getServiceSetting('TextcubeNotice' . $ctx->getProperty('blog.language')))) { $noticeEntries = unserialize(Setting::getServiceSetting('TextcubeNotice' . $ctx->getProperty('blog.language'))); } else { list($result, $feed, $xml) = getRemoteFeed($noticeURLRSS); if ($result == 0) { $xmls = new XMLStruct(); $xmls->setXPathBaseIndex(1); $noticeEntries = array(); if ($xmls->open($xml, $ctx->getProperty('service.encoding'))) { if ($xmls->getAttribute('/rss', 'version')) { for ($i = 1; $link = $xmls->getValue("/rss/channel/item[{$i}]/link"); $i++) { $item = array('permalink' => rawurldecode($link)); $item['title'] = $xmls->getValue("/rss/channel/item[{$i}]/title"); if ($xmls->getValue("/rss/channel/item[{$i}]/pubDate")) { $item['written'] = parseDate($xmls->getValue("/rss/channel/item[{$i}]/pubDate")); } else { if ($xmls->getValue("/rss/channel/item[{$i}]/dc:date")) { $item['written'] = parseDate($xmls->getValue("/rss/channel/item[{$i}]/dc:date")); } else { $item['written'] = 0; } } array_push($noticeEntries, $item); } } } Setting::setServiceSetting('TextcubeNotice' . $ctx->getProperty('blog.language'), serialize($noticeEntries)); } } ?> <div id="textcube-notice"> <h4 class="caption"><span><a href="<?php echo $noticeURL . ($ctx->getProperty('blog.language') ? $ctx->getProperty('blog.language') : "ko"); ?> "><?php echo _t('공지사항'); ?> </a></span></h4> <?php if (count($noticeEntries) > 0) { array_splice($noticeEntries, 3, count($noticeEntries) - 3); ?> <table> <tbody> <?php foreach ($noticeEntries as $item) { ?> <tr> <td class="date"><?php echo Timestamp::format2($item['written']); ?> </td> <td class="title"><a href="<?php echo $item['permalink']; ?> " onclick="return openLinkInNewWindow(this);" ><?php echo htmlspecialchars(Utils_Unicode::lessenAsEm($item['title'], 35)); ?> </a></td> </tr> <?php } ?> </tbody> </table> <?php } else { ?> <div id="fail-notice"> <?php echo _t('공지사항을 가져올 수 없습니다. 잠시 후 다시 시도해 주십시오.'); ?> </div> <?php } ?> </div> <?php } ?> </div> <?php }
function trashVan() { global $database; requireModel('common.setting'); if (Timestamp::getUNIXtime() - Setting::getServiceSetting('lastTrashSweep', 0, true) > 86400) { // var_dump(Timestamp::getUNIXtime()); // var_dump(Setting::getServiceSetting('lastTrashSweep',0, true)); POD::execute("DELETE FROM {$database['prefix']}Comments where isfiltered < " . Timestamp::getUNIXtime() . " - 1296000 AND isfiltered > 0"); POD::execute("DELETE FROM {$database['prefix']}RemoteResponses where isfiltered < " . Timestamp::getUNIXtime() . " - 1296000 AND isfiltered > 0"); POD::execute("DELETE FROM {$database['prefix']}RefererLogs WHERE referred < " . Timestamp::getUNIXtime() . " - 604800"); Setting::setServiceSetting('lastTrashSweep', Timestamp::getUNIXtime(), true); } if (Timestamp::getUNIXtime() - Setting::getServiceSetting('lastNoticeRead', 0, true) > 43200) { Setting::removeServiceSetting('TextcubeNotice', true); Setting::setServiceSetting('lastNoticeRead', Timestamp::getUNIXtime(), true); } }
static function setServiceSettingGlobal($name, $value) { return Setting::setServiceSetting($name, $value, true); }
function getPluginTableName() { requireModel('common.setting'); $ctx = Model_Context::getInstance(); $likeEscape = array('/_/', '/%/'); $likeReplace = array('\\_', '\\%'); $escapename = preg_replace($likeEscape, $likeReplace, $ctx->getProperty('database.prefix')); $dbtables = POD::tableList($escapename); $dbCaseInsensitive = Setting::getServiceSetting('lowercaseTableNames', true); if ($dbCaseInsensitive === null) { $result = POD::queryRow("SHOW VARIABLES LIKE 'lower_case_table_names'"); $dbCaseInsensitive = $result['Value'] == 1 ? 1 : 0; Setting::setServiceSetting('lowercaseTableNames', $dbCaseInsensitive, true); } $definedTables = getDefinedTableNames(); $dbtables = array_values(array_diff($dbtables, $definedTables)); if ($dbCaseInsensitive == 1) { $tempTables = $definedTables; $definedTables = array(); foreach ($tempTables as $table) { $table = strtolower($table); array_push($definedTables, $table); } $tempTables = $dbtables; $dbtables = array(); foreach ($tempTables as $table) { $table = strtolower($table); array_push($dbtables, $table); } $dbtables = array_values(array_diff($dbtables, $definedTables)); } return $dbtables; }
function trashVan() { if (Timestamp::getUNIXtime() - Setting::getServiceSetting('lastTrashSweep', 0, true) > 86400) { $pool = DBModel::getInstance(); $pool->reset('Comments'); $pool->setQualifier('isfiltered', 's', Timestamp::getUNIXtime() - 1296000); $pool->setQualifier('isfiltered', 'b', 0); $pool->delete(); $pool->reset('RemoteResponses'); $pool->setQualifier('isfiltered', 's', Timestamp::getUNIXtime() - 1296000); $pool->setQualifier('isfiltered', 'b', 0); $pool->delete(); $pool->reset('RefererLogs'); $pool->setQualifier('referred', 's', Timestamp::getUNIXtime() - 604800); $pool->delete(); Setting::setServiceSetting('lastTrashSweep', Timestamp::getUNIXtime(), true); } if (Timestamp::getUNIXtime() - Setting::getServiceSetting('lastNoticeRead', 0, true) > 43200) { Setting::removeServiceSetting('TextcubeNotice', true); Setting::setServiceSetting('lastNoticeRead', Timestamp::getUNIXtime(), true); } }
public function setNotify($type) { $type = strtolower($type); switch ($type) { case "google": Setting::setServiceSetting("SitemapNotifyGoogle", $onchange ? 1 : 0); $this->notify[$type] = $onchange; break; case "yahoo": Setting::setServiceSetting("SitemapNotifyYahoo", $onchange ? 1 : 0); $this->notify[$type] = $onchange; break; case "msn": Setting::setServiceSetting("SitemapNotifyMSN", $onchange ? 1 : 0); $this->notify[$type] = $onchange; break; case "ask": Setting::setServiceSetting("SitemapNotifyASK", $onchange ? 1 : 0); $this->notify[$type] = $onchange; break; case "bing": Setting::setServiceSetting("SitemapNotifyBing", $onchange ? 1 : 0); $this->notify[$type] = $onchange; break; default: } }
function trashVan() { $context = Model_Context::getInstance(); if (Timestamp::getUNIXtime() - Setting::getServiceSetting('lastTrashSweep', 0, true) > 43200) { $pool = DBModel::getInstance(); $pool->reset('Comments'); $pool->setQualifier('isfiltered', 's', Timestamp::getUNIXtime() - $context->getProperty('service.trashtimelimit', 302400)); $pool->setQualifier('isfiltered', 'b', 0); $pool->delete(); $pool->reset('RemoteResponses'); $pool->setQualifier('isfiltered', 's', Timestamp::getUNIXtime() - $context->getProperty('service.trashtimelimit', 302400)); $pool->setQualifier('isfiltered', 'b', 0); $pool->delete(); $pool->reset('RefererLogs'); $pool->setQualifier('referred', 's', Timestamp::getUNIXtime() - 604800); $pool->delete(); Setting::setServiceSetting('lastTrashSweep', Timestamp::getUNIXtime(), true); } if (Timestamp::getUNIXtime() - Setting::getServiceSetting('lastNoticeRead', 0, true) > 43200) { Setting::removeServiceSetting('TextcubeNotice', true); Setting::setServiceSetting('lastNoticeRead', Timestamp::getUNIXtime(), true); } }
if (Setting::getServiceSetting('useNewPluginSetting', false, true) != true) { $changed = true; echo '<li>', _text('플러그인 환경 설정 저장 방식을 변경합니다.'), ': '; $query = DBModel::getInstance(); $query->reset('Plugins'); if ($candidates = $query->getAll()) { foreach ($candidates as $c) { if (!is_null($c['settings'])) { $query->reset('Plugins'); $query->setQualifier('blogid', 'equals', $c['blogid']); $query->setQualifier('name', 'equals', $c['name'], true); $query->setAttribute('settings', serialize(Setting::fetchConfigXML($c['settings'])), true); $query->update(); } } Setting::setServiceSetting('useNewPluginSetting', true, true); showCheckupMessage(true); } else { showCheckupMessage(false); } } /* From Textcube 1.9 */ if (version_compare($currentVersion, '1.9.0', '<')) { $changed = true; echo '<li>', _text('기본 에디터를 변경합니다.'), ': '; $query = DBModel::getInstance(); $query->reset('BlogSettings'); $query->setQualifier('name', 'equals', 'defaultEditor', true); $query->setQualifier('value', 'equals', 'modern', true); $query->setAttribute('value', 'tinyMCE', true); if ($query->update()) {