Changeset 592

Timestamp:

03/02/09 16:52:47 (12 months ago)

Author:

jparker

Message:

• 자잘한 버그 및 버전 번호 수정(cron 문제 포함)

Location:

plugins/trunk

Files:

• CT_RecentRG_Default/index.php (modified) (3 diffs)
• CT_RecentRG_Default/index.xml (modified) (1 diff)
• CT_RecentTB_Default/index.php (modified) (3 diffs)
• CT_RecentTB_Default/index.xml (modified) (2 diffs)
• CT_Textcube_Plugin_N_Skin/index.php (modified) (3 diffs)
• CT_Textcube_Plugin_N_Skin/index.xml (modified) (2 diffs)
• CT_textcube_howto/index.php (modified) (5 diffs)
• CT_textcube_howto/index.xml (modified) (2 diffs)
• JP_CT_RecentCommentNotifies/index.php (modified) (1 diff)
• JP_CT_RecentCommentNotifies/index.xml (modified) (1 diff)
• JP_FlashCounterViewTT/help.txt (deleted)
• JP_FlashCounterViewTT/index.xml (modified) (2 diffs)
• JP_FlickrYoutubeMediaSearch/index.xml (modified) (1 diff)

plugins/trunk/CT_RecentRG_Default/index.php

@@ -1 +1 @@
 <?php
-/* Recent Guestbook plugin for Textcube 1.6
+/* Recent Guestbook plugin for Tattertools 1.1
    ----------------------------------
-   Version 1.6
-   Tatter Network Foundation development team / Needlworks
+   Version 1.0
+   Tatter and Friends development team.
 
    Creator          : Peris
@@ -10 +10 @@
 
    Created at       : 2006.7.25
-   Last modified at : 2008.02.25
+   Last modified at : 2007.08.10
 
  This plugin shows recent eeplies on 'quilt'.
@@ -35 +35 @@
     $limitLine = ($data['repliesList'])?$data['repliesList']:$skinSetting['commentsOnRecent'];
     $sql = "SELECT * FROM {$database['prefix']}Comments WHERE blogid = {$blogid} AND entry=0 AND isFiltered = 0 {$repliesChk} ORDER BY written DESC LIMIT {$limitLine}";
-    if ($result = mysql_query($sql)) {
-        while ($comment = mysql_fetch_array($result)) {
+    if ($result = POD::query($sql)) {
+        while ($comment = POD::fetch($result, 'array')) {
             if ($data['repliesChk'] == 2) {
-                $row = DBQuery::queryCell("select count(*) from {$database['prefix']}Comments where blogid = $blogid AND parent = ".$comment['id']);
+                $row = POD::queryCell("select count(*) from {$database['prefix']}Comments where blogid = $blogid AND parent = ".$comment['id']);
                 $comment['replier'] = ($row)?"<img src=\"{$pluginURL}/replier.gif\" width=\"11\" height=\"9\" align=\"top\" style=\"margin-left:2px;\"/>":"";
             }else{$comment['replier'] = "";}

plugins/trunk/CT_RecentRG_Default/index.xml

@@ -10 +10 @@
   <description xml:lang="ja">最新 ゲストブック ・プラグ・イン</description>
   <license>GPL</license>
-  <author xml:lang="en" link="http://needlworks.org"><![CDATA[Yong-ju, Park (jparker / Needlworks)]]></author>
-  <author xml:lang="ko" link="http://needlworks.org"><![CDATA[박용주 (jparker / Needlworks)]]></author>
-  <author xml:lang="ja" link="http://needlworks.org"><![CDATA[Yong-ju, Park (jparker / Needlworks)]]></author>
+  <author xml:lang="en" link="http://needlworks.org">Needlworks</author>
+  <author xml:lang="ko" link="http://needlworks.org">Needlworks</author>
+  <author xml:lang="ja" link="http://needlworks.org">Needlworks</author>
   <safety changeData="no" exposeData="no" accessLocal="no" accessRemote="no" accessRaw="yes" />
   <requirements>
-    <textcube>1.6</textcube>
+    <textcube>1.5</textcube>
   </requirements>
   <binding>

plugins/trunk/CT_RecentTB_Default/index.php

@@ -1 +1 @@
 <?php
-/* Recent Trackbacks plugin for Textcube 1.5
+/* Recent Trackbacks plugin for Textcube 1.8
    ----------------------------------
-   Version 1.0
+   Version 1.1
    Tatter and Friends development team.
 
    Creator          : NANI
-   Maintainer       : Peris, inureyes, graphittie
+   Maintainer       : Peris, inureyes, graphittie, J.Parker
 
    Created at       : 2006.10.10
-   Last modified at : 2007.8.10
+   Last modified at : 2009.1.05 (J.Parker)
 
  This plugin shows recent trackback on 'quilt'.
@@ -25 +25 @@
 */
 
-// lib/model/trackback.php : 46 line
 function _getRecentTrackbacks($blogid) {
     global $database;
     global $skinSetting;
     $trackbacks = array();
-    $sql = doesHaveOwnership() ? "SELECT * 
-        FROM 
-            {$database['prefix']}Trackbacks 
-        WHERE 
-            blogid = $blogid AND isFiltered = 0 
-        ORDER BY 
-            written 
-        DESC LIMIT 
-            {$skinSetting['trackbacksOnRecent']}" : 
-        "SELECT t.* 
-        FROM 
-            {$database['prefix']}Trackbacks t 
-            LEFT JOIN {$database['prefix']}Entries e ON t.blogid = e.blogid AND t.entry = e.id
-            LEFT JOIN {$database['prefix']}Categories c ON e.blogid = c.blogid AND e.category = c.id
-        WHERE 
-            t.blogid = $blogid AND e.draft = 0 AND e.visibility >= 2 AND (c.visibility > 1 OR e.category = 0) AND t.isFiltered = 0 
-        ORDER BY 
-            t.written 
-        DESC LIMIT 
+    $sql = "SELECT * FROM {$database['prefix']}RemoteResponses
+        WHERE
+            blogid = $blogid AND type = 'trackback' AND isFiltered = 0
+        ORDER BY
+            written
+        DESC LIMIT
             {$skinSetting['trackbacksOnRecent']}";
-    if ($result = DBQuery::query($sql)) {
-        while ($trackback = mysql_fetch_array($result))
+
+    if ($result = POD::query($sql)) {
+        while ($trackback = POD::fetch($result, 'array'))
             array_push($trackbacks, $trackback);
     }
@@ -58 +45 @@
 
 function CT_RecentTB_Default($target) {
-    global $blogid;
-    global $blogURL;
+    global $blogid, $blogURL;
     requireComponent("Eolin.PHP.Core");
     requireComponent("Textcube.Function.misc");
-    
+
     $target .= '<ul>';
     $trackbacks = _getRecentTrackbacks($blogid);

plugins/trunk/CT_RecentTB_Default/index.xml

@@ -4 +4 @@
   <title xml:lang="ko">최근 글걸기</title>
   <link>http://http://needlworks.org/</link>
-  <version>1.1</version>
+  <version>1.8.0105</version>
   <description xml:lang="en">Shows recent trackbacks</description>
   <description xml:lang="ko">최근에 걸린 글들을 보여줍니다</description>
@@ -12 +12 @@
   <safety changeData="no" exposeData="no" accessLocal="no" accessRemote="no" accessRaw="yes" />
   <requirements>
-    <textcube>1.5</textcube>
+    <textcube>1.7</textcube>
   </requirements>
   <binding>

plugins/trunk/CT_Textcube_Plugin_N_Skin/index.php

@@ -29 +29 @@
                 <li id="Addon-tab-4" class="no-selected-tab" onclick="selectAddonTab('Addon-tab-4', 'Addon-tab-1', 'Addon-tab-2', 'Addon-tab-3');hideLayer('CT_Addon3');hideLayer('CT_Addon2');hideLayer('CT_Addon1');showLayer('CT_Addon4');">검색</li>
             </ul>
-        </div>  
+        </div>
     <?
     $target .= ob_get_contents();
     ob_end_clean();
-
     $recentRssURLS = array('http://textcube.org/plugin/plugin/newRecentRSS?blogname=all', 'http://textcube.org/plugin/plugin/newRecentRSS?blogname=plugin', 'http://textcube.org/plugin/plugin/newRecentRSS?blogname=theme');
     $OL_CNT = 0;
     foreach ($recentRssURLS as $recentRssURL){
         $OL_CNT++;
-        if(!is_null(getServiceSetting('TextcubePSAddon'.$OL_CNT))) {
-            $AddonEntries = unserialize(getServiceSetting('TextcubePSAddon'.$OL_CNT));
+        if(!is_null(getServiceSetting('Textcube_PS_Addon_'.$OL_CNT))) {
+
+            $AddonEntries = unserialize(getServiceSetting('Textcube_PS_Addon_'.$OL_CNT));
             $result = 0;
         } else {
             list($result, $feed, $xml, $AddonEntries) = CT_textcube_Plugin_N_Skin_getRemoteFeed($recentRssURL);
-            setServiceSetting('TextcubePSAddon'.$OL_CNT,serialize($AddonEntries));
+            setServiceSetting('Textcube_PS_Addon_'.$OL_CNT,serialize($AddonEntries));
         }
         if ($result == 0) {
@@ -116 +116 @@
                     else if(isset($rssInfo['path'])) {
                         if($rssInfo['path']{0} == '/')
-                            $rssURL = "{$urlInfo['scheme']}://{$urlInfo['host']}{$rssInfo['path']}";                            
+                            $rssURL = "{$urlInfo['scheme']}://{$urlInfo['host']}{$rssInfo['path']}";
                         else
                             $rssURL = "{$urlInfo['scheme']}://{$urlInfo['host']}".(isset($urlInfo['path']) ? rtrim($urlInfo['path'], '/') : '').'/'.$rssInfo['path'];
@@ -163 +163 @@
 }
 
-function CT_textcube_Plugin_N_Skin_sweep($target, $mother = true) {
-    requireModel('common.setting'); 
-    removeServiceSetting('TextcubePSAddon1'); 
-    removeServiceSetting('TextcubePSAddon2');
-    removeServiceSetting('TextcubePSAddon3');
-    return $target;
+function CT_textcube_Plugin_N_Skin_sweep() {
+    CT_PNS_removeServiceSetting('Textcube_PS_Addon_1');
+    CT_PNS_removeServiceSetting('Textcube_PS_Addon_2');
+    CT_PNS_removeServiceSetting('Textcube_PS_Addon_3');
+    return true;
+}
+
+function CT_PNS_removeServiceSetting($name,$pruneSimilarEntries = false) {
+    global $database;
+    clearServiceSettingCache();
+    if($pruneSimilarEntries) return POD::execute("DELETE FROM {$database['prefix']}ServiceSettings WHERE name like '".POD::escapeString($name)."'");
+    else return POD::execute("DELETE FROM {$database['prefix']}ServiceSettings WHERE name = '".POD::escapeString($name)."'");
 }
 ?>

plugins/trunk/CT_Textcube_Plugin_N_Skin/index.xml

@@ -3 +3 @@
   <title xml:lang="ko"><![CDATA[텍스트큐브 최근 플러그인/스킨]]></title>
   <link>http://textcube.org/</link>
-  <version>1.6.0603</version>
+  <version>1.9.0302</version>
   <description xml:lang="ko"><![CDATA[텍스트큐브 플러그인/스킨 블로그의 글을 보여줍니다.]]></description>
   <license>GPL</license>
@@ -15 +15 @@
   <binding>
     <center handler="CT_textcube_Plugin_N_Skin" />
-    <listener event="Cron12h">CT_textcube_Plugin_N_Skin_sweep</listener>
+    <listener event="Cron6h">CT_textcube_Plugin_N_Skin_sweep</listener>
     <listener event="AddPostEditorToolbox">Null</listener>
   </binding>

plugins/trunk/CT_textcube_howto/index.php

@@ -26 +26 @@
                 <li id="howto-tab-3" class="no-selected-tab" onclick="selectTab('howto-tab-3', 'howto-tab-1', 'howto-tab-2');hideLayer('CT_howTo2');hideLayer('CT_howTo1');showLayer('CT_howTo3');">팁 검색</li>
             </ul>
-        </div>  
+        </div>
     <?
     $target .= ob_get_contents();
@@ -35 +35 @@
     foreach ($noticeURLS as $noticeURL){
         $OL_CNT++;
-        if(!is_null(getServiceSetting('Textcubehowto'.$OL_CNT))) {
-            $howtoEntries = unserialize(getServiceSetting('Textcubehowto'.$OL_CNT));
+        if(!is_null(getServiceSetting('Textcube_howto_'.$OL_CNT))) {
+            $howtoEntries = unserialize(getServiceSetting('Textcube_howto_'.$OL_CNT));
             $result = 0;
         } else {
             list($result, $feed, $xml, $howtoEntries) = CT_textcube_howto_getRemoteFeed($noticeURL);
-            setServiceSetting('Textcubehowto'.$OL_CNT,serialize($howtoEntries));
+            setServiceSetting('Textcube_howto_'.$OL_CNT,serialize($howtoEntries));
         }
         if ($result == 0) {
@@ -74 +74 @@
     $target .= '    <p style="height: 30px; padding-top: 20px; text-align: center;">'.CRLF;
     $target .= '        <input type="text" size="12" id="searchhowtokey" name="searchhowtokey" value="" onkeypress="if (event.keyCode == 13) { searchHowTo(); return false; }" class="searchfield" />'.CRLF;
-    $target .= '        <input type="button" size="8" value="'._t('검색').'" onclick="searchHowTo();" class="searchbutton" />'.CRLF;
+    $target .= '        <input type="button" size="8" value="검 색" onclick="searchHowTo();" class="searchbutton" />'.CRLF;
     $target .= '    </p>'.CRLF;
     $target .= '</ol>'.CRLF;
@@ -109 +109 @@
                     else if(isset($rssInfo['path'])) {
                         if($rssInfo['path']{0} == '/')
-                            $rssURL = "{$urlInfo['scheme']}://{$urlInfo['host']}{$rssInfo['path']}";                            
+                            $rssURL = "{$urlInfo['scheme']}://{$urlInfo['host']}{$rssInfo['path']}";
                         else
                             $rssURL = "{$urlInfo['scheme']}://{$urlInfo['host']}".(isset($urlInfo['path']) ? rtrim($urlInfo['path'], '/') : '').'/'.$rssInfo['path'];
@@ -153 +153 @@
 }
 
-function CT_textcube_howto_sweep($target, $mother = true) {
-    requireModel('common.setting');
-    removeServiceSetting('Textcubehowto1'); 
-    removeServiceSetting('Textcubehowto2');
-    return $target;
+function CT_textcube_howto_sweep() {
+    CT_HWT_removeServiceSetting('Textcube_howto_1');
+    CT_HWT_removeServiceSetting('Textcube_howto_2');
+    return true;
+}
+function CT_HWT_removeServiceSetting($name,$pruneSimilarEntries = false) {
+    global $database;
+    clearServiceSettingCache();
+    if($pruneSimilarEntries) return POD::execute("DELETE FROM {$database['prefix']}ServiceSettings WHERE name like '".POD::escapeString($name)."'");
+    else return POD::execute("DELETE FROM {$database['prefix']}ServiceSettings WHERE name = '".POD::escapeString($name)."'");
 }
 ?>

plugins/trunk/CT_textcube_howto/index.xml

@@ -4 +4 @@
   <title xml:lang="ko">텍스트큐브 팁</title>
   <link>http://howto.textcube.org/</link>
-  <version>1.6.0531</version>
+  <version>1.9.0302</version>
   <description xml:lang="en">Shows latest posts from howto.textcube.org.</description>
   <description xml:lang="ko">텍스트큐브 팁 블로그의 글을 보여줍니다.</description>
@@ -16 +16 @@
   <binding>
     <center handler="CT_textcube_howto" />
-    <listener event="Cron12h">CT_textcube_howto_sweep</listener>
+    <listener event="Cron6h">CT_textcube_howto_sweep</listener>
     <listener event="AddPostEditorToolbox">Null</listener>
   </binding>

plugins/trunk/JP_CT_RecentCommentNotifies/index.php

@@ -33 +33 @@
             WHERE c.blogid = $blogid AND c.parent=$parent";
     $sql .= ' ORDER BY c.written ASC';
-    if ($result = DBQuery::query($sql)) {
-        while ($comment = mysql_fetch_array($result)) {
+    if ($result = POD::query($sql)) {
+        while ($comment = POD::fetch($result, 'array')) {
             if (($comment['secret'] == 1) && !$authorized) {
                 $comment['name'] = '';

plugins/trunk/JP_CT_RecentCommentNotifies/index.xml

@@ -3 +3 @@
   <title xml:lang="en">Recent Comment Notifies</title>
   <title xml:lang="ko">최근 댓글 알리미</title>
-  <version>1.6.0225</version>
+  <version>1.9.0302</version>
   <description xml:lang="en">Shows recent comment notifies</description>
   <description xml:lang="ko">최근에 작성된 댓글 알림 내역을 보여줍니다</description>

plugins/trunk/JP_FlashCounterViewTT/index.xml

@@ -2 +2 @@
 <plugin version="1.0">
   <title>JP Flash Counter View</title>
-  <version>1.6.0609</version>
+  <version>1.9.0302</version>
   <description>태터 0.9* 구버젼부터 써오던 혀니님(http://www.web2dew.com/blog.bung)께서 만드신 플래쉬카운터를 Textcube 1.5 코어에 맞게 플러그인화 했습니다. 플래쉬카운터의 원 저작권은 혀니님께 있습니다. (IE패치용)</description>
   <license>GPL</license>
@@ -11 +11 @@
   <requirements>
     <textcube>1.6</textcube>
-    <textcube>1.7</textcube>
   </requirements>
   <binding>

plugins/trunk/JP_FlickrYoutubeMediaSearch/index.xml

@@ -4 +4 @@
   <title xml:lang="ko">JP Flickr와 YouTube 미디어 검색.</title>
   <link>http://create74.com/</link>
-  <version>1.8.0108</version>
+  <version>1.9.0108</version>
   <description xml:lang="en"><![CDATA[Flickr and YouTube media search.]]></description>
   <description xml:lang="ko"><![CDATA[Flickr와 YouTube의 미디어를 검색합니다.]]></description>