| Revisión | c1caaa8e1194cb84ae46824efeac649b89770fbf (tree) |
|---|---|
| Tiempo | 2007-05-01 15:00:31 |
| Autor | (no author) <(no author)@1ca2...> |
| Commiter | (no author) |
This commit was manufactured by cvs2svn to create tag
'release-3-3-rc1'.
git-svn-id: https://svn.sourceforge.jp/svnroot/nucleus-jp/nucleus-jp/tags/release-3-3-rc1@293 1ca29b6e-896d-4ea0-84a5-967f57386b96
euc/install.php (diff)
euc/install.sql (diff) euc/nucleus/libs/ADMIN.php (diff) utf8/install.php (diff) utf8/install.sql (diff)
utf8/nucleus/documentation/devdocs/plugins.html (diff) utf8/nucleus/documentation/history.html (diff) utf8/nucleus/documentation/tips.html (diff) utf8/nucleus/libs/ADMIN.php (diff) utf8/nucleus/upgrades/index.php (diff) utf8/nucleus/upgrades/upgrade.functions.php (diff) utf8/nucleus/upgrades/upgrade.php (diff) utf8/nucleus/upgrades/upgrade0.95.php (diff) utf8/nucleus/upgrades/upgrade0.96.php (diff) utf8/nucleus/upgrades/upgrade1.0.php (diff) utf8/nucleus/upgrades/upgrade1.1.php (diff) utf8/nucleus/upgrades/upgrade1.5.php (diff) utf8/nucleus/upgrades/upgrade2.0.php (diff) utf8/nucleus/upgrades/upgrade2.5.php (diff) utf8/nucleus/upgrades/upgrade3.0.php (diff) utf8/nucleus/upgrades/upgrade3.1.php (diff) utf8/nucleus/upgrades/upgrade3.2.php (diff) utf8/nucleus/upgrades/upgrade3.3.php (diff)| @@ -18,8 +18,8 @@ | ||
| 18 | 18 | /** |
| 19 | 19 | * @license http://nucleuscms.org/license.txt GNU General Public License |
| 20 | 20 | * @copyright Copyright (C) 2002-2007 The Nucleus Group |
| 21 | - * @version $Id: install.php,v 1.6 2007-04-25 06:34:13 kimitake Exp $ | |
| 22 | - * $NucleusJP: install.php,v 1.5 2007/04/04 07:52:04 kimitake Exp $ | |
| 21 | + * @version $Id: install.php,v 1.5 2007-04-04 07:52:04 kimitake Exp $ | |
| 22 | + * $NucleusJP: install.php,v 1.7 2007/02/04 06:28:44 kimitake Exp $ | |
| 23 | 23 | */ |
| 24 | 24 | |
| 25 | 25 | /* |
| @@ -463,7 +463,6 @@ function doInstall() { | ||
| 463 | 463 | $config_actionurl = replaceDoubleBackslash($config_actionurl); |
| 464 | 464 | $config_adminpath = replaceDoubleBackslash($config_adminpath); |
| 465 | 465 | $config_skinspath = replaceDoubleBackslash($config_skinspath); |
| 466 | - $config_mediapath = replaceDoubleBackslash($config_mediapath); | |
| 467 | 466 | |
| 468 | 467 | // 1. check all the data |
| 469 | 468 | $errors = array(); |
| @@ -133,7 +133,7 @@ CREATE TABLE `nucleus_item` ( | ||
| 133 | 133 | |
| 134 | 134 | INSERT INTO `nucleus_item` VALUES (1, 'Nucleus CMS バージョン3.3へようこそ', |
| 135 | 135 | 'ウェブページの作成を補助する積み木がここにあります。それは心躍るblogになるかもしれませんし、観るものを和ませる家族のページになるかもしれませんし、実り多き趣味のサイトになるかもしれません。あるいは現在のあなたには想像がつかないものになることだってあるでしょう。<br />\r\n<br />\r\n用途が思いつきませんでしたか？ それならここへ来て正解です。なぜならあなた同様私たちにもわからないのですから。', |
| 136 | -'これはサイトにおける最初のエントリーです。スタートを切りやすいように、リンクと情報を入れておきました。<br />\r\n<br />\r\nこの記事を削除することもできますが、どちらにせよ記事を追加していくことによってやがてメインページからは見えなくなります。Nucleusを扱ううちに生じたメモをコメントとして追加し、将来アクセスできるようにこのページをブックマークしておくのも手です。<br />\r\n<br />\r\n<b>リンク</b><br />\r\n<br />\r\nNucleus CMSの<a href="http://nucleuscms.org">本家</a>と<a href="http://japan.nucleuscms.org">日本語公式</a>ページ。<br />\r\n<br />\r\nNucleus CMSのSourceForge<a href="http://sourceforge.net/projects/nucleuscms/">プロジェクト</a>（<a href="http://sourceforge.jp/projects/nucleus-jp/">日本版</a>）ページ。<br />\r\n<br />\r\nNucleus CMSのプラグイン<a href="http://wakka.xiffy.nl/Plugin/">倉庫</a>と<a href="http://japan.nucleuscms.org/wiki/plugins">日本語のリスト</a>ページ。<br />\r\n<br />\r\n<b>ドキュメント - <a href="http://docs.nucleuscms.org/">docs.nucleuscms.org</a></b><br />\r\n<br />\r\nNucleusの<a href="http://japan.nucleuscms.org/faq.php">FAQ（よくある質問集）</a>（<a href="http://nucleuscms.org/faq.php">原文</a>）ページ。<br />\r\n<br />\r\nインストール方法等は<a href="nucleus/documentation/">ユーザー向け</a>と<a href="nucleus/documentation/devdocs/">開発者向け</a>文書がファイルに含まれています。<br />\r\n<br />\r\nポップアップ<a href="./nucleus/documentation/help.html">ヘルプ</a>が管理エリアのいたるところにあり、サイトのカスタマイズやデザインを手助けしてくれることでしょう。<br />\r\n<br />\r\n一度用意されているドキュメントに目を通したら、<a href="http://wiki.nucleuscms.org/">Wiki</a>（<a href="http://japan.nucleuscms.org/wiki/">日本版</a>）を訪れてください。ユーザーの書いたハウツーや小技が掲載されています。<br />\r\n<br />\r\n<b>サポート</b><br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/">forum.nucleuscms.org</a>（本家）<br />\r\n<a href="http://japan.nucleuscms.org/bb/">japan.nucleuscms.org/bb/</a>（日本版）<br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/groupcp.php?g=3">moderators</a>とサポートフォーラムで活動する全てのボランティアに感謝します。<br />\r\n<br />\r\n- <a href="http://edmondhui.homeip.net/blog/">admun</a> - Ottawa, ON, Canada <br />\r\n- <a href="http://www.tamizhan.com/">anand</a> - Bangalore, India<br />\r\n- <a href="http://hcgtv.com">hcgtv</a> - Miami, Florida, USA<br />\r\n- <a href="http://www.adrenalinsports.nl/">ikeizer</a> - Maastricht<br />\r\n- <a href="http://www.tipos.com.br/">moraes</a> - Brazil<br />\r\n- <a href="http://roelg.nl/">roel </a>- The Netherlands<br />\r\n- <a href="http://budts.be/weblog/">TeRanEX </a>- Ekeren, Antwerp, Belgium<br />\r\n- <a href="http://www.trentadams.com/">Trent </a>- Alberta, Canada<br />\r\n- <a href="http://xiffy.nl/weblog/">xiffy </a>- Deventer<br />\r\n<br />\r\nもし手助けが必要なら、1400を超える登録ユーザーのいる私たちのフォーラムに参加してください。23,000を超える投稿された記事を検索できるようになっておりますので、求める答えに数回のクリックでたどり着けるかもしれません。<br />\r\n<br />\r\n<b>Personalization - <a href="http://skins.nucleuscms.org/">skins.nucleuscms.org</a></b><br />\r\n<br />\r\nマルチウェブログとスキン/テンプレートの組み合わせは強力な相乗効果を生み出します。個人的なサイト作成、友人や親戚あるいはクライアントに対するサイトデザインいずれに対してもです。<br />\r\n<br />\r\n636の登録された<a href="http://nucleuscms.org/sites.php">Nucleusで運用されているサイト</a>（<a href="http://japan.nucleuscms.org/sites.php">日本版</a>）の中から特色あるサイトをサンプルとしてご紹介します。<br />\r\n<br />\r\nThe Zen of Nucleus<br />\r\n- <a href="http://beefcake.nl/">beefcake.nl</a> - Beefcake | Nuke the whales!<br />\r\n- <a href="http://www.leng-lui.com//">leng-lui.com</a> - Leng-Lui.com - v7.0: "Memento"<br />\r\n<br />\r\nPersonal blogs<br />\r\n- <a href="http://bloggard.com/">bloggard.com</a> - The Adventures of Bloggard<br />\r\n- <a href="http://battleangel.org/">battleangel.org</a> - Giving meaning to the meaningless<br />\r\n- <a href="http://www.yetanotherblog.de/">yetanotherblog.de</a> - Yet Another Blog<br />\r\n<br />\r\nMulti user blogs<br />\r\n- <a href="http://tipos.com.br/">tipos.com.br</a> - Blogging community<br />\r\n<br />\r\nHobby, Travel and News sites<br />\r\n- <a href="http://adrenalinsports.nl/">adrenalinsports.nl</a> - Extreme sports<br />\r\n- <a href="http://hsbluebird.com/">hsbluebird.com</a> - Hot Springs, Montana''s Online Resource <br />\r\n- <a href="http://groningen-info.de/">groningen-info.de</a> - Neues aus Groningen. Fr Leute aus Duitsland.<br />\r\n- <a href="http://www.americandaily.com/">americandaily.com</a> - American Daily - Home<br />\r\n<br />\r\n<b>Nucleus Developer Network - <a href="http://dev.nucleuscms.org/">dev.nucleuscms.org</a></b><br />\r\n<br />\r\nThe NUDN is a hub for developer sites and programming resources.<br />\r\n<br />\r\nNUDN satellite sites, handles, location and UTC offset:<br />\r\n- <a href="http://karma.nucleuscms.org/">karma</a> - Izegem +02<br />\r\n- <a href="http://hcgtv.net/">hcgtv</a> - Miami -05<br />\r\n- <a href="http://edmondhui.homeip.net/blog/nudn.php">admun</a> - Ottawa -04<br />\r\n- <a href="http://dev.budts.be/nucleus/">TeRanEX</a> - Ekeren +02<br />\r\n<br />\r\nSourceforge.net graciously hosts our <a href="http://sourceforge.net/projects/nucleuscms/">CVS repository</a>.<br />\r\n<br />\r\nWant to play around or test changes, visit our demo site at <a href="http://demo.nucleuscms.org/">demo.nucleuscms.org</a>.<br />\r\n<br />\r\nNot sure what plugins to use, visit the <a href="http://showcase.trentadams.com/">showcase site</a> where you can see plugins at play in their native habitat.<br />\r\n<br />\r\nThen visit the plugin repository at <a href="http://plugins.nucleuscms.org/">plugins.nucleuscms.org</a> for download and installation instructions.<br />\r\n<br />\r\n<b>寄付者一覧</b><br />\r\n<br />\r\n以下の<a href="http://nucleuscms.org/donators.php">素晴らしい人々</a>による<a href="http://nucleuscms.org/donate.php">援助</a>感謝を捧げます。<em>ありがとう！</em><br />\r\n<br />\r\n- <a href="http://reddustrec.net/">dkex</a><br />\r\n- <a href="http://www.uncoverthenet.com/">Uncover the Net</a><br />\r\n- <a href="http://www.webatlas.org/">Web Atlas</a><br />\r\n- <a href="http://www.ipnlighting.com/">IPN Lighting</a><br />\r\n- <a href="http://blog.datoka.jp/">Yu (blog.datoka.jp)</a><br />\r\n- <a href="http://www.thegadgetreview.com/">Sony Gadgets and Reviews</a><br />\r\n- <a href="http://sites.proliphus.com/blueZhift/blog/">Thomas McKibben</a><br />\r\n- <a href="http://cheapweb.us/">CheapWeb.us</a><br />\r\n- Robert Seyfriedsberger<br />\r\n- <a href="http://www.toxicologie.nl/">Toxicologie.nl</a><br />\r\n- Gordon Shum<br />\r\n- <a href="http://www.subsim.com/">Neal Stevens</a><br />\r\n- <a href="http://www.GamblingHelper.com/">GamblingHelper</a><br />\r\n- Oliver Kirstein<br />\r\n- <a href="http://www.dominiek.be/">Dominiek</a><br />\r\n- <a href="http://www.aardschok.net/">Aardschok</a><br />\r\n- <a href="http://www.nieuwevoordeur.be/">nieuwevoordeur.be</a><br />\r\n- <a href="http://www.scene24.net/">Scene24</a><br />\r\n- <a href="http://www.eug.be/">Eug''s Weblog</a><br />\r\n- <a href="http://www.bloggard.com/">The Adventures of Bloggard</a><br />\r\n- <a href="http://www.voltos.com/">Arthur Cronos from Voltos</a><br />\r\n- <a href="http://www.webmaster-toolkit.com/">Free Webmaster Tools and Resources</a><br />\r\n- <a href="http://www.domilog.be/">Domi''s Weblog</a><br />\r\n- Infodoma <br />\r\n- <a href="http://carvingcode.com/">carvingCode.com</a><br />\r\n- <a href="http://www.traweb.com/">Traweb</a><br />\r\n- <a href="http://gene.mm2u.com/">Gene''s MoBlog</a><br />\r\n- <a href="http://interfacethis.com/">InterfaceThis</a><br />\r\n- <a href="http://www.thefinsters.com/flog/">The Finster Log</a><br />\r\n- <a href="http://www.mrhop.com/">Hop Nguyen</a><br />\r\n- <a href="http://www.zwavel.com/~zwavelaars" title="Zwavelaars">Zwavelaars</a><br />\r\n- <a href="http://beefcake.nl/">Joaquin Scholten</a> <br />\r\n- <a href="http://www.roelgroeneveld.com/">Roel Groeneveld</a><br />\r\n- <a href="http://lvb.net/">LVBlog</a><br />\r\n- <a href="http://xandermol.com/">Xander Mol</a><br />\r\n- Danilo Massa<br />\r\n- <a href="http://01FTP.com/">01FTP.com</a><br />\r\n- <a href="http://www.adrenalinsports.nl/">Irmo Keizer</a><br />\r\n- <a href="http://www.jasonkrogh.com/">Jason Krogh</a><br />\r\n- <a href="http://www.higuchi.com/">Osamu Higuchi</a><br />\r\n- <a href="http://www.trentadams.com/">Trent Adams</a><br />\r\n- <a href="http://www.ppcw.net/">Arne Hess</a><br />\r\n- <a href="http://hsbluebird.com/">The Bluebird</a><br />\r\n- Rainer Bickel<br />\r\n- Fritz Elfers<br />\r\n- <a href="http://www.european-wall-tapestries.com/">European Wall Tapestries</a><br />\r\n- <a href="http://www.jamier.net/">Jamie R. Rytlewski</a><br />\r\n- Madolyn Piper<br />\r\n- <a href="http://www.batteryvalues.com/">Battery Values</a><br />\r\n- <a href="http://www.mixburnrip.de/">Janko Roettgers</a><br />\r\n- Lukas Loesche<br />\r\n- <a href="http://www.seobook.com/">SEO Book</a><br />\r\n- <a href="http://www.brandweerdematen.nl/">Brandweer de Maten</a><br />\r\n- Andy Fuchs<br />\r\n- <a href="http://www.sumoforce.com/">Sumoforce</a><br />\r\n- <a href="http://love.silverindigo.com/">Al''ky''mie</a><br />\r\n- <a href="http://www.pejo.us/">Peter Johnson</a><br />\r\n- <a href="http://www.triv.nl/">TriV Internet Solutions</a><br />\r\n- <a href="http://www.torontomusicians.org/nucleus/">Margaret Stowe</a><br />\r\n- <a href="http://www.zenkey.org/">zenkey dot org</a><br />\r\n- <a href="http://www.golb.org/">Blots of Info</a><br />\r\n- <a href="http://www.zonderpartij.be/">Rudi De Kerpel</a><br />\r\n- <a href="http://staylorx.com/">Steve Taylor</a><br />\r\n- <a href="http://lmhcave.com/">Malcolm Farnsworth</a><br />\r\n- Birgit Kellner<br />\r\n- <a href="http://www.tobiasly.com/">Toby Johnson</a><br />\r\n- <a href="http://www.kapingamarangi.be/">Kapingamarangi</a><br />\r\n- <a href="http://www.pallalink.net/">Pallalink</a><br />\r\n- <a href="http://publiustx.net/">PubliusTX Weblog</a><br />\r\n- <a href="http://www.reductioadabsurdum.net/">Reductio Ad Absurdum</a><br />\r\n- <a href="http://www.gagaweb.org/">GagaWeb</a><br />\r\n- <a href="http://www.videokid.be/">Videokid</a><br />\r\n- Jon Marr<br />\r\n- <a href="http://www.docblog.org/">Luigi Cristiano</a><br />\r\n- J Keith Lehman<br />\r\n- Bohemian Cachet<br />\r\n- Jesus Mourazos<br />\r\n- <a href="http://ltp-design.com/">Stephen Jones</a><br />\r\n- <a href="http://oha.nu/">One-Handed Apps</a><br />\r\n- Alwin Hawkins<br />\r\n- <a href="http://jstigall.bloomington.in.us">Justin Stigall</a><br />\r\n- <a href="http://www.itismylife.com/">It is my life</a><br />\r\n- Greg Morrill<br />\r\n- <a href="http://www.dutchsubmarines.com/">Dutch Submarines</a><br />\r\n- <a href="http://www.7thwatch.com/">Seventh Watch Design Studios</a> <br />\r\n- <a href="http://www.macnet2.com/">MacNetv2</a> <br />\r\n- Richard Noordhof<br />\r\n- <a href="http://www.jamier.net/">Jamie Rytlewski</a><br />\r\n<br />\r\nNucleusが気に入りましたか？ <a href="http://www.hotscripts.com/Detailed/13368.html?RID=nucleus@demuynck.org">HotScripts</a>や<a href="http://www.opensourcecms.com/index.php?option=content&task=view&id=145">opensourceCMS</a>での投票をお願いします。<br />\r\n<br />\r\n<b>ライセンス</b><br />\r\n<br />\r\n私たちがフリー・ソフトウェアについて口にする場合は自由のことに言及しているのであって、価格のことではありません。私たちの<a href="http://www.gnu.org/licenses/gpl.html">一般公有使用許諾書</a>（<a href="http://www.gnu.org/licenses/gpl.ja.html">日本語訳</a>と<a href="http://www.atmarkit.co.jp/aig/03linux/gpl.html">概要</a>）は、フリー・ソフトウェアの複製物を自由に頒布できること(そして、望むならこのサービスに対して対価を請求できること)、ソース・コードを実際に受け取るか希望しさえすれば入手することが可能であること、入手したソフトウェアを変更したり新しいフリー・プログラムの一部として使用できること、以上の各内容を行なうことができるということをユーザ自身が知っていることを実現できるようにデザインされています。', 1, 1, '2005-02-16 22:57:54', 0, 0, 0, 1, 0); | |
| 136 | +'これはサイトにおける最初のエントリーです。スタートを切りやすいように、リンクと情報を入れておきました。<br />\r\n<br />\r\nこの記事を削除することもできますが、どちらにせよ記事を追加していくことによってやがてメインページからは見えなくなります。Nucleusを扱ううちに生じたメモをコメントとして追加し、将来アクセスできるようにこのページをブックマークしておくのも手です。<br />\r\n<br />\r\n<b>リンク</b><br />\r\n<br />\r\nNucleus CMSの<a href="http://nucleuscms.org">本家</a>と<a href="http://japan.nucleuscms.org">日本語公式</a>ページ。<br />\r\n<br />\r\nNucleus CMSのSourceForge<a href="http://sourceforge.net/projects/nucleuscms/">プロジェクト</a>ページ。<br />\r\n<br />\r\nNucleus CMSのプラグイン<a href="http://wakka.xiffy.nl/Plugin/">倉庫</a>と<a href="http://japan.nucleuscms.org/wakka/CategorizedPlugin">日本語のリスト</a>ページ。<br />\r\n<br />\r\n<b>ドキュメント - <a href="http://docs.nucleuscms.org/">docs.nucleuscms.org</a></b><br />\r\n<br />\r\nNucleusの<a href="http://japan.nucleuscms.org/faq.php">FAQ（よくある質問集）</a>（<a href="http://nucleuscms.org/faq.php">原文</a>）ページ。<br />\r\n<br />\r\nインストール方法等は<a href="nucleus/documentation/">ユーザー向け</a>と<a href="nucleus/documentation/devdocs/">開発者向け</a>文書がファイルに含まれています。<br />\r\n<br />\r\nポップアップ<a href="./nucleus/documentation/help.html">ヘルプ</a>が管理エリアのいたるところにあり、サイトのカスタマイズやデザインを手助けしてくれることでしょう。<br />\r\n<br />\r\n一度用意されているドキュメントに目を通したら、<a href="http://wiki.nucleuscms.org/">Wiki</a>（<a href="http://japan.nucleuscms.org/wakka/Nucleus">日本版</a>）を訪れてください。ユーザーの書いたハウツーや小技が掲載されています。<br />\r\n<br />\r\n<b>サポート</b><br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/">forum.nucleuscms.org</a>（本家）<br />\r\n<a href="http://japan.nucleuscms.org/bb/">japan.nucleuscms.org/bb/</a>（日本版）<br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/groupcp.php?g=3">moderators</a>とサポートフォーラムで活動する全てのボランティアに感謝します。<br />\r\n<br />\r\n- <a href="http://edmondhui.homeip.net/blog/">admun</a> - Ottawa, ON, Canada <br />\r\n- <a href="http://www.tamizhan.com/">anand</a> - Bangalore, India<br />\r\n- <a href="http://hcgtv.com">hcgtv</a> - Miami, Florida, USA<br />\r\n- <a href="http://www.adrenalinsports.nl/">ikeizer</a> - Maastricht<br />\r\n- <a href="http://www.tipos.com.br/">moraes</a> - Brazil<br />\r\n- <a href="http://roelg.nl/">roel </a>- The Netherlands<br />\r\n- <a href="http://budts.be/weblog/">TeRanEX </a>- Ekeren, Antwerp, Belgium<br />\r\n- <a href="http://www.trentadams.com/">Trent </a>- Alberta, Canada<br />\r\n- <a href="http://xiffy.nl/weblog/">xiffy </a>- Deventer<br />\r\n<br />\r\nもし手助けが必要なら、1400を超える登録ユーザーのいる私たちのフォーラムに参加してください。23,000を超える投稿された記事を検索できるようになっておりますので、求める答えに数回のクリックでたどり着けるかもしれません。<br />\r\n<br />\r\n<b>Personalization - <a href="http://skins.nucleuscms.org/">skins.nucleuscms.org</a></b><br />\r\n<br />\r\nマルチウェブログとスキン/テンプレートの組み合わせは強力な相乗効果を生み出します。個人的なサイト作成、友人や親戚あるいはクライアントに対するサイトデザインいずれに対してもです。<br />\r\n<br />\r\n636の登録された<a href="http://nucleuscms.org/sites.php">Nucleusで運用されているサイト</a>（<a href="http://japan.nucleuscms.org/sites.php">日本版</a>）の中から特色あるサイトをサンプルとしてご紹介します。<br />\r\n<br />\r\nThe Zen of Nucleus<br />\r\n- <a href="http://beefcake.nl/">beefcake.nl</a> - Beefcake | Nuke the whales!<br />\r\n- <a href="http://www.leng-lui.com//">leng-lui.com</a> - Leng-Lui.com - v7.0: "Memento"<br />\r\n<br />\r\nPersonal blogs<br />\r\n- <a href="http://bloggard.com/">bloggard.com</a> - The Adventures of Bloggard<br />\r\n- <a href="http://battleangel.org/">battleangel.org</a> - Giving meaning to the meaningless<br />\r\n- <a href="http://www.yetanotherblog.de/">yetanotherblog.de</a> - Yet Another Blog<br />\r\n<br />\r\nMulti user blogs<br />\r\n- <a href="http://tipos.com.br/">tipos.com.br</a> - Blogging community<br />\r\n<br />\r\nHobby, Travel and News sites<br />\r\n- <a href="http://adrenalinsports.nl/">adrenalinsports.nl</a> - Extreme sports<br />\r\n- <a href="http://hsbluebird.com/">hsbluebird.com</a> - Hot Springs, Montana''s Online Resource <br />\r\n- <a href="http://groningen-info.de/">groningen-info.de</a> - Neues aus Groningen. Fr Leute aus Duitsland.<br />\r\n- <a href="http://www.americandaily.com/">americandaily.com</a> - American Daily - Home<br />\r\n<br />\r\n<b>Nucleus Developer Network - <a href="http://dev.nucleuscms.org/">dev.nucleuscms.org</a></b><br />\r\n<br />\r\nThe NUDN is a hub for developer sites and programming resources.<br />\r\n<br />\r\nNUDN satellite sites, handles, location and UTC offset:<br />\r\n- <a href="http://karma.nucleuscms.org/">karma</a> - Izegem +02<br />\r\n- <a href="http://hcgtv.net/">hcgtv</a> - Miami -05<br />\r\n- <a href="http://edmondhui.homeip.net/blog/nudn.php">admun</a> - Ottawa -04<br />\r\n- <a href="http://dev.budts.be/nucleus/">TeRanEX</a> - Ekeren +02<br />\r\n<br />\r\nSourceforge.net graciously hosts our <a href="http://sourceforge.net/projects/nucleuscms/">CVS repository</a>.<br />\r\n<br />\r\nWant to play around or test changes, visit our demo site at <a href="http://demo.nucleuscms.org/">demo.nucleuscms.org</a>.<br />\r\n<br />\r\nNot sure what plugins to use, visit the <a href="http://showcase.trentadams.com/">showcase site</a> where you can see plugins at play in their native habitat.<br />\r\n<br />\r\nThen visit the plugin repository at <a href="http://plugins.nucleuscms.org/">plugins.nucleuscms.org</a> for download and installation instructions.<br />\r\n<br />\r\n<b>寄付者一覧</b><br />\r\n<br />\r\n以下の<a href="http://nucleuscms.org/donators.php">素晴らしい人々</a>による<a href="http://nucleuscms.org/donate.php">援助</a>感謝を捧げます。<em>ありがとう！</em><br />\r\n<br />\r\n- <a href="http://reddustrec.net/">dkex</a><br />\r\n- <a href="http://www.uncoverthenet.com/">Uncover the Net</a><br />\r\n- <a href="http://www.webatlas.org/">Web Atlas</a><br />\r\n- <a href="http://www.ipnlighting.com/">IPN Lighting</a><br />\r\n- <a href="http://blog.datoka.jp/">Yu (blog.datoka.jp)</a><br />\r\n- <a href="http://www.thegadgetreview.com/">Sony Gadgets and Reviews</a><br />\r\n- <a href="http://sites.proliphus.com/blueZhift/blog/">Thomas McKibben</a><br />\r\n- <a href="http://cheapweb.us/">CheapWeb.us</a><br />\r\n- Robert Seyfriedsberger<br />\r\n- <a href="http://www.toxicologie.nl/">Toxicologie.nl</a><br />\r\n- Gordon Shum<br />\r\n- <a href="http://www.subsim.com/">Neal Stevens</a><br />\r\n- <a href="http://www.GamblingHelper.com/">GamblingHelper</a><br />\r\n- Oliver Kirstein<br />\r\n- <a href="http://www.dominiek.be/">Dominiek</a><br />\r\n- <a href="http://www.aardschok.net/">Aardschok</a><br />\r\n- <a href="http://www.nieuwevoordeur.be/">nieuwevoordeur.be</a><br />\r\n- <a href="http://www.scene24.net/">Scene24</a><br />\r\n- <a href="http://www.eug.be/">Eug''s Weblog</a><br />\r\n- <a href="http://www.bloggard.com/">The Adventures of Bloggard</a><br />\r\n- <a href="http://www.voltos.com/">Arthur Cronos from Voltos</a><br />\r\n- <a href="http://www.webmaster-toolkit.com/">Free Webmaster Tools and Resources</a><br />\r\n- <a href="http://www.domilog.be/">Domi''s Weblog</a><br />\r\n- Infodoma <br />\r\n- <a href="http://carvingcode.com/">carvingCode.com</a><br />\r\n- <a href="http://www.traweb.com/">Traweb</a><br />\r\n- <a href="http://gene.mm2u.com/">Gene''s MoBlog</a><br />\r\n- <a href="http://interfacethis.com/">InterfaceThis</a><br />\r\n- <a href="http://www.thefinsters.com/flog/">The Finster Log</a><br />\r\n- <a href="http://www.mrhop.com/">Hop Nguyen</a><br />\r\n- <a href="http://www.zwavel.com/~zwavelaars" title="Zwavelaars">Zwavelaars</a><br />\r\n- <a href="http://beefcake.nl/">Joaquin Scholten</a> <br />\r\n- <a href="http://www.roelgroeneveld.com/">Roel Groeneveld</a><br />\r\n- <a href="http://lvb.net/">LVBlog</a><br />\r\n- <a href="http://xandermol.com/">Xander Mol</a><br />\r\n- Danilo Massa<br />\r\n- <a href="http://01FTP.com/">01FTP.com</a><br />\r\n- <a href="http://www.adrenalinsports.nl/">Irmo Keizer</a><br />\r\n- <a href="http://www.jasonkrogh.com/">Jason Krogh</a><br />\r\n- <a href="http://www.higuchi.com/">Osamu Higuchi</a><br />\r\n- <a href="http://www.trentadams.com/">Trent Adams</a><br />\r\n- <a href="http://www.ppcw.net/">Arne Hess</a><br />\r\n- <a href="http://hsbluebird.com/">The Bluebird</a><br />\r\n- Rainer Bickel<br />\r\n- Fritz Elfers<br />\r\n- <a href="http://www.european-wall-tapestries.com/">European Wall Tapestries</a><br />\r\n- <a href="http://www.jamier.net/">Jamie R. Rytlewski</a><br />\r\n- Madolyn Piper<br />\r\n- <a href="http://www.batteryvalues.com/">Battery Values</a><br />\r\n- <a href="http://www.mixburnrip.de/">Janko Roettgers</a><br />\r\n- Lukas Loesche<br />\r\n- <a href="http://www.seobook.com/">SEO Book</a><br />\r\n- <a href="http://www.brandweerdematen.nl/">Brandweer de Maten</a><br />\r\n- Andy Fuchs<br />\r\n- <a href="http://www.sumoforce.com/">Sumoforce</a><br />\r\n- <a href="http://love.silverindigo.com/">Al''ky''mie</a><br />\r\n- <a href="http://www.pejo.us/">Peter Johnson</a><br />\r\n- <a href="http://www.triv.nl/">TriV Internet Solutions</a><br />\r\n- <a href="http://www.torontomusicians.org/nucleus/">Margaret Stowe</a><br />\r\n- <a href="http://www.zenkey.org/">zenkey dot org</a><br />\r\n- <a href="http://www.golb.org/">Blots of Info</a><br />\r\n- <a href="http://www.zonderpartij.be/">Rudi De Kerpel</a><br />\r\n- <a href="http://staylorx.com/">Steve Taylor</a><br />\r\n- <a href="http://lmhcave.com/">Malcolm Farnsworth</a><br />\r\n- Birgit Kellner<br />\r\n- <a href="http://www.tobiasly.com/">Toby Johnson</a><br />\r\n- <a href="http://www.kapingamarangi.be/">Kapingamarangi</a><br />\r\n- <a href="http://www.pallalink.net/">Pallalink</a><br />\r\n- <a href="http://publiustx.net/">PubliusTX Weblog</a><br />\r\n- <a href="http://www.reductioadabsurdum.net/">Reductio Ad Absurdum</a><br />\r\n- <a href="http://www.gagaweb.org/">GagaWeb</a><br />\r\n- <a href="http://www.videokid.be/">Videokid</a><br />\r\n- Jon Marr<br />\r\n- <a href="http://www.docblog.org/">Luigi Cristiano</a><br />\r\n- J Keith Lehman<br />\r\n- Bohemian Cachet<br />\r\n- Jesus Mourazos<br />\r\n- <a href="http://ltp-design.com/">Stephen Jones</a><br />\r\n- <a href="http://oha.nu/">One-Handed Apps</a><br />\r\n- Alwin Hawkins<br />\r\n- <a href="http://jstigall.bloomington.in.us">Justin Stigall</a><br />\r\n- <a href="http://www.itismylife.com/">It is my life</a><br />\r\n- Greg Morrill<br />\r\n- <a href="http://www.dutchsubmarines.com/">Dutch Submarines</a><br />\r\n- <a href="http://www.7thwatch.com/">Seventh Watch Design Studios</a> <br />\r\n- <a href="http://www.macnet2.com/">MacNetv2</a> <br />\r\n- Richard Noordhof<br />\r\n- <a href="http://www.jamier.net/">Jamie Rytlewski</a><br />\r\n<br />\r\nNucleusが気に入りましたか？ <a href="http://www.hotscripts.com/Detailed/13368.html?RID=nucleus@demuynck.org">HotScripts</a>や<a href="http://www.opensourcecms.com/index.php?option=content&task=view&id=145">opensourceCMS</a>での投票をお願いします。<br />\r\n<br />\r\n<b>ライセンス</b><br />\r\n<br />\r\n私たちがフリー・ソフトウェアについて口にする場合は自由のことに言及しているのであって、価格のことではありません。私たちの<a href="http://www.gnu.org/licenses/gpl.html">一般公有使用許諾書</a>（<a href="http://www.gnu.org/licenses/gpl.ja.html">日本語訳</a>と<a href="http://www.atmarkit.co.jp/aig/03linux/gpl.html">概要</a>）は、フリー・ソフトウェアの複製物を自由に頒布できること(そして、望むならこのサービスに対して対価を請求できること)、ソース・コードを実際に受け取るか希望しさえすれば入手することが可能であること、入手したソフトウェアを変更したり新しいフリー・プログラムの一部として使用できること、以上の各内容を行なうことができるということをユーザ自身が知っていることを実現できるようにデザインされています。', 1, 1, '2005-02-16 22:57:54', 0, 0, 0, 1, 0); | |
| 137 | 137 | |
| 138 | 138 | CREATE TABLE `nucleus_karma` ( |
| 139 | 139 | `itemid` int(11) NOT NULL default '0', |
| @@ -201,7 +201,7 @@ CREATE TABLE `nucleus_skin` ( | ||
| 201 | 201 | PRIMARY KEY (`sdesc`,`stype`) |
| 202 | 202 | ) TYPE=MyISAM; |
| 203 | 203 | |
| 204 | -INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version="1.0" encoding="UTF-8"?>\n\n<feed xml:lang="ja" xmlns="http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <subtitle><%blogsetting(desc)%></subtitle>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel="alternate" type="text/html" href="<%blogsetting(url)%>" />\n <link rel="self" type="application/atom+xml" href="<%blogsetting(url)%><%self%>" />\n <generator uri="http://nucleuscms.org/"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>'); | |
| 204 | +INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version="1.0" encoding="UTF-8"?>\n\n<feed xml:lang="ja" xmlns="http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel="alternate" type="text/html" href="<%blogsetting(url)%>" />\n <link rel="self" type="application/atom+xml" href="<%blogsetting(url)%><%self%>" />\n <generator uri="http://nucleuscms.org/"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>'); | |
| 205 | 205 | INSERT INTO `nucleus_skin` VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>'); |
| 206 | 206 | INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="UTF-8"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>ja</language>\r\n <generator><%version%></generator>\r\n <copyright>©</copyright>\r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%adminurl%>nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>'); |
| 207 | 207 |
| @@ -243,7 +243,7 @@ INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" on | ||
| 243 | 243 | INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%Y-%m-%d'); |
| 244 | 244 | INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%H:%M:%S'); |
| 245 | 245 | INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>'); |
| 246 | -INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\r\n <title type="html"><![CDATA[<%title%>]]></title>\r\n <link rel="alternate" type="text/html" href="<%blogurl%>?itemid=<%itemid%>" />\r\n <author>\r\n <name><%author%></name>\r\n </author>\r\n <updated><%date(utc)%></updated>\r\n <published><%date(iso8601)%></published>\r\n <content type="html"><![CDATA[<%body%><%more%>]]></content>\r\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\r\n</entry>'); | |
| 246 | +INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\r\n <title type="text/html" mode="escaped"><![CDATA[<%title%>]]></title>\r\n <link rel="alternate" type="text/html" href="<%blogurl%>?itemid=<%itemid%>" />\r\n <author>\r\n <name><%author%></name>\r\n </author>\r\n <modified><%date(utc)%></modified>\r\n <issued><%date(iso8601)%></issued>\r\n <content type="text/html" mode="escaped"><![CDATA[<%body%><%more%>]]></content>\r\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\r\n</entry>'); | |
| 247 | 247 | |
| 248 | 248 | INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>'); |
| 249 | 249 | INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>'); |
| @@ -14,8 +14,8 @@ | ||
| 14 | 14 | * |
| 15 | 15 | * @license http://nucleuscms.org/license.txt GNU General Public License |
| 16 | 16 | * @copyright Copyright (C) 2002-2007 The Nucleus Group |
| 17 | - * @version $Id: ADMIN.php,v 1.11 2007-04-27 19:07:04 kimitake Exp $ | |
| 18 | - * @version $NucleusJP: ADMIN.php,v 1.10 2007/04/04 07:52:08 kimitake Exp $ | |
| 17 | + * @version $Id: ADMIN.php,v 1.10 2007-04-04 07:52:08 kimitake Exp $ | |
| 18 | + * @version $NucleusJP: ADMIN.php,v 1.20 2007/03/22 03:30:14 kmorimatsu Exp $ | |
| 19 | 19 | */ |
| 20 | 20 | |
| 21 | 21 | if ( !function_exists('requestVar') ) exit; |
| @@ -840,13 +840,13 @@ class ADMIN { | ||
| 840 | 840 | |
| 841 | 841 | // start index |
| 842 | 842 | if (postVar('start')) |
| 843 | - $start = intPostVar('start'); | |
| 843 | + $start = postVar('start'); | |
| 844 | 844 | else |
| 845 | 845 | $start = 0; |
| 846 | 846 | |
| 847 | 847 | // amount of items to show |
| 848 | 848 | if (postVar('amount')) |
| 849 | - $amount = intPostVar('amount'); | |
| 849 | + $amount = postVar('amount'); | |
| 850 | 850 | else |
| 851 | 851 | $amount = 10; |
| 852 | 852 |
| @@ -892,13 +892,13 @@ class ADMIN { | ||
| 892 | 892 | |
| 893 | 893 | // start index |
| 894 | 894 | if (postVar('start')) |
| 895 | - $start = intPostVar('start'); | |
| 895 | + $start = postVar('start'); | |
| 896 | 896 | else |
| 897 | 897 | $start = 0; |
| 898 | 898 | |
| 899 | 899 | // amount of items to show |
| 900 | 900 | if (postVar('amount')) |
| 901 | - $amount = intPostVar('amount'); | |
| 901 | + $amount = postVar('amount'); | |
| 902 | 902 | else |
| 903 | 903 | $amount = 10; |
| 904 | 904 |
| @@ -933,13 +933,13 @@ class ADMIN { | ||
| 933 | 933 | |
| 934 | 934 | // start index |
| 935 | 935 | if (postVar('start')) |
| 936 | - $start = intPostVar('start'); | |
| 936 | + $start = postVar('start'); | |
| 937 | 937 | else |
| 938 | 938 | $start = 0; |
| 939 | 939 | |
| 940 | 940 | // amount of items to show |
| 941 | 941 | if (postVar('amount')) |
| 942 | - $amount = intPostVar('amount'); | |
| 942 | + $amount = postVar('amount'); | |
| 943 | 943 | else |
| 944 | 944 | $amount = 10; |
| 945 | 945 |
| @@ -986,13 +986,13 @@ class ADMIN { | ||
| 986 | 986 | |
| 987 | 987 | // start index |
| 988 | 988 | if (postVar('start')) |
| 989 | - $start = intPostVar('start'); | |
| 989 | + $start = postVar('start'); | |
| 990 | 990 | else |
| 991 | 991 | $start = 0; |
| 992 | 992 | |
| 993 | 993 | // amount of items to show |
| 994 | 994 | if (postVar('amount')) |
| 995 | - $amount = intPostVar('amount'); | |
| 995 | + $amount = postVar('amount'); | |
| 996 | 996 | else |
| 997 | 997 | $amount = 10; |
| 998 | 998 |
| @@ -18,8 +18,8 @@ | ||
| 18 | 18 | /** |
| 19 | 19 | * @license http://nucleuscms.org/license.txt GNU General Public License |
| 20 | 20 | * @copyright Copyright (C) 2002-2007 The Nucleus Group |
| 21 | - * @version $Id: install.php,v 1.8 2007-04-25 06:34:29 kimitake Exp $ | |
| 22 | - * $NucleusJP: install.php,v 1.7 2007/02/04 06:28:44 kimitake Exp $ | |
| 21 | + * @version $Id: install.php,v 1.7 2007-02-04 06:28:44 kimitake Exp $ | |
| 22 | + * $NucleusJP: install.php,v 1.6 2006/07/17 19:59:46 kimitake Exp $ | |
| 23 | 23 | */ |
| 24 | 24 | |
| 25 | 25 | /* |
| @@ -463,7 +463,6 @@ function doInstall() { | ||
| 463 | 463 | $config_actionurl = replaceDoubleBackslash($config_actionurl); |
| 464 | 464 | $config_adminpath = replaceDoubleBackslash($config_adminpath); |
| 465 | 465 | $config_skinspath = replaceDoubleBackslash($config_skinspath); |
| 466 | - $config_mediapath = replaceDoubleBackslash($config_mediapath); | |
| 467 | 466 | |
| 468 | 467 | // 1. check all the data |
| 469 | 468 | $errors = array(); |
| @@ -133,7 +133,7 @@ CREATE TABLE `nucleus_item` ( | ||
| 133 | 133 | |
| 134 | 134 | INSERT INTO `nucleus_item` VALUES (1, 'Nucleus CMS バージョン3.3へようこそ', |
| 135 | 135 | 'ウェブページの作成を補助する積み木がここにあります。それは心躍るblogになるかもしれませんし、観るものを和ませる家族のページになるかもしれませんし、実り多き趣味のサイトになるかもしれません。あるいは現在のあなたには想像がつかないものになることだってあるでしょう。<br />\r\n<br />\r\n用途が思いつきませんでしたか？ それならここへ来て正解です。なぜならあなた同様私たちにもわからないのですから。', |
| 136 | -'これはサイトにおける最初のエントリーです。スタートを切りやすいように、リンクと情報を入れておきました。<br />\r\n<br />\r\nこの記事を削除することもできますが、どちらにせよ記事を追加していくことによってやがてメインページからは見えなくなります。Nucleusを扱ううちに生じたメモをコメントとして追加し、将来アクセスできるようにこのページをブックマークしておくのも手です。<br />\r\n<br />\r\n<b>リンク</b><br />\r\n<br />\r\nNucleus CMSの<a href="http://nucleuscms.org">本家</a>と<a href="http://japan.nucleuscms.org">日本語公式</a>ページ。<br />\r\n<br />\r\nNucleus CMSのSourceForge<a href="http://sourceforge.net/projects/nucleuscms/">プロジェクト</a>（<a href="http://sourceforge.jp/projects/nucleus-jp/">日本版</a>）ページ。<br />\r\n<br />\r\nNucleus CMSのプラグイン<a href="http://wakka.xiffy.nl/Plugin/">倉庫</a>と<a href="http://japan.nucleuscms.org/wiki/plugins">日本語のリスト</a>ページ。<br />\r\n<br />\r\n<b>ドキュメント - <a href="http://docs.nucleuscms.org/">docs.nucleuscms.org</a></b><br />\r\n<br />\r\nNucleusの<a href="http://japan.nucleuscms.org/faq.php">FAQ（よくある質問集）</a>（<a href="http://nucleuscms.org/faq.php">原文</a>）ページ。<br />\r\n<br />\r\nインストール方法等は<a href="nucleus/documentation/">ユーザー向け</a>と<a href="nucleus/documentation/devdocs/">開発者向け</a>文書がファイルに含まれています。<br />\r\n<br />\r\nポップアップ<a href="./nucleus/documentation/help.html">ヘルプ</a>が管理エリアのいたるところにあり、サイトのカスタマイズやデザインを手助けしてくれることでしょう。<br />\r\n<br />\r\n一度用意されているドキュメントに目を通したら、<a href="http://wiki.nucleuscms.org/">Wiki</a>（<a href="http://japan.nucleuscms.org/wiki/">日本版</a>）を訪れてください。ユーザーの書いたハウツーや小技が掲載されています。<br />\r\n<br />\r\n<b>サポート</b><br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/">forum.nucleuscms.org</a>（本家）<br />\r\n<a href="http://japan.nucleuscms.org/bb/">japan.nucleuscms.org/bb/</a>（日本版）<br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/groupcp.php?g=3">moderators</a>とサポートフォーラムで活動する全てのボランティアに感謝します。<br />\r\n<br />\r\n- <a href="http://edmondhui.homeip.net/blog/">admun</a> - Ottawa, ON, Canada <br />\r\n- <a href="http://www.tamizhan.com/">anand</a> - Bangalore, India<br />\r\n- <a href="http://hcgtv.com">hcgtv</a> - Miami, Florida, USA<br />\r\n- <a href="http://www.adrenalinsports.nl/">ikeizer</a> - Maastricht<br />\r\n- <a href="http://www.tipos.com.br/">moraes</a> - Brazil<br />\r\n- <a href="http://roelg.nl/">roel </a>- The Netherlands<br />\r\n- <a href="http://budts.be/weblog/">TeRanEX </a>- Ekeren, Antwerp, Belgium<br />\r\n- <a href="http://www.trentadams.com/">Trent </a>- Alberta, Canada<br />\r\n- <a href="http://xiffy.nl/weblog/">xiffy </a>- Deventer<br />\r\n<br />\r\nもし手助けが必要なら、1400を超える登録ユーザーのいる私たちのフォーラムに参加してください。23,000を超える投稿された記事を検索できるようになっておりますので、求める答えに数回のクリックでたどり着けるかもしれません。<br />\r\n<br />\r\n<b>Personalization - <a href="http://skins.nucleuscms.org/">skins.nucleuscms.org</a></b><br />\r\n<br />\r\nマルチウェブログとスキン/テンプレートの組み合わせは強力な相乗効果を生み出します。個人的なサイト作成、友人や親戚あるいはクライアントに対するサイトデザインいずれに対してもです。<br />\r\n<br />\r\n636の登録された<a href="http://nucleuscms.org/sites.php">Nucleusで運用されているサイト</a>（<a href="http://japan.nucleuscms.org/sites.php">日本版</a>）の中から特色あるサイトをサンプルとしてご紹介します。<br />\r\n<br />\r\nThe Zen of Nucleus<br />\r\n- <a href="http://beefcake.nl/">beefcake.nl</a> - Beefcake | Nuke the whales!<br />\r\n- <a href="http://www.leng-lui.com//">leng-lui.com</a> - Leng-Lui.com - v7.0: "Memento"<br />\r\n<br />\r\nPersonal blogs<br />\r\n- <a href="http://bloggard.com/">bloggard.com</a> - The Adventures of Bloggard<br />\r\n- <a href="http://battleangel.org/">battleangel.org</a> - Giving meaning to the meaningless<br />\r\n- <a href="http://www.yetanotherblog.de/">yetanotherblog.de</a> - Yet Another Blog<br />\r\n<br />\r\nMulti user blogs<br />\r\n- <a href="http://tipos.com.br/">tipos.com.br</a> - Blogging community<br />\r\n<br />\r\nHobby, Travel and News sites<br />\r\n- <a href="http://adrenalinsports.nl/">adrenalinsports.nl</a> - Extreme sports<br />\r\n- <a href="http://hsbluebird.com/">hsbluebird.com</a> - Hot Springs, Montana''s Online Resource <br />\r\n- <a href="http://groningen-info.de/">groningen-info.de</a> - Neues aus Groningen. Fr Leute aus Duitsland.<br />\r\n- <a href="http://www.americandaily.com/">americandaily.com</a> - American Daily - Home<br />\r\n<br />\r\n<b>Nucleus Developer Network - <a href="http://dev.nucleuscms.org/">dev.nucleuscms.org</a></b><br />\r\n<br />\r\nThe NUDN is a hub for developer sites and programming resources.<br />\r\n<br />\r\nNUDN satellite sites, handles, location and UTC offset:<br />\r\n- <a href="http://karma.nucleuscms.org/">karma</a> - Izegem +02<br />\r\n- <a href="http://hcgtv.net/">hcgtv</a> - Miami -05<br />\r\n- <a href="http://edmondhui.homeip.net/blog/nudn.php">admun</a> - Ottawa -04<br />\r\n- <a href="http://dev.budts.be/nucleus/">TeRanEX</a> - Ekeren +02<br />\r\n<br />\r\nSourceforge.net graciously hosts our <a href="http://sourceforge.net/projects/nucleuscms/">CVS repository</a>.<br />\r\n<br />\r\nWant to play around or test changes, visit our demo site at <a href="http://demo.nucleuscms.org/">demo.nucleuscms.org</a>.<br />\r\n<br />\r\nNot sure what plugins to use, visit the <a href="http://showcase.trentadams.com/">showcase site</a> where you can see plugins at play in their native habitat.<br />\r\n<br />\r\nThen visit the plugin repository at <a href="http://plugins.nucleuscms.org/">plugins.nucleuscms.org</a> for download and installation instructions.<br />\r\n<br />\r\n<b>寄付者一覧</b><br />\r\n<br />\r\n以下の<a href="http://nucleuscms.org/donators.php">素晴らしい人々</a>による<a href="http://nucleuscms.org/donate.php">援助</a>感謝を捧げます。<em>ありがとう！</em><br />\r\n<br />\r\n- <a href="http://reddustrec.net/">dkex</a><br />\r\n- <a href="http://www.uncoverthenet.com/">Uncover the Net</a><br />\r\n- <a href="http://www.webatlas.org/">Web Atlas</a><br />\r\n- <a href="http://www.ipnlighting.com/">IPN Lighting</a><br />\r\n- <a href="http://blog.datoka.jp/">Yu (blog.datoka.jp)</a><br />\r\n- <a href="http://www.thegadgetreview.com/">Sony Gadgets and Reviews</a><br />\r\n- <a href="http://sites.proliphus.com/blueZhift/blog/">Thomas McKibben</a><br />\r\n- <a href="http://cheapweb.us/">CheapWeb.us</a><br />\r\n- Robert Seyfriedsberger<br />\r\n- <a href="http://www.toxicologie.nl/">Toxicologie.nl</a><br />\r\n- Gordon Shum<br />\r\n- <a href="http://www.subsim.com/">Neal Stevens</a><br />\r\n- <a href="http://www.GamblingHelper.com/">GamblingHelper</a><br />\r\n- Oliver Kirstein<br />\r\n- <a href="http://www.dominiek.be/">Dominiek</a><br />\r\n- <a href="http://www.aardschok.net/">Aardschok</a><br />\r\n- <a href="http://www.nieuwevoordeur.be/">nieuwevoordeur.be</a><br />\r\n- <a href="http://www.scene24.net/">Scene24</a><br />\r\n- <a href="http://www.eug.be/">Eug''s Weblog</a><br />\r\n- <a href="http://www.bloggard.com/">The Adventures of Bloggard</a><br />\r\n- <a href="http://www.voltos.com/">Arthur Cronos from Voltos</a><br />\r\n- <a href="http://www.webmaster-toolkit.com/">Free Webmaster Tools and Resources</a><br />\r\n- <a href="http://www.domilog.be/">Domi''s Weblog</a><br />\r\n- Infodoma <br />\r\n- <a href="http://carvingcode.com/">carvingCode.com</a><br />\r\n- <a href="http://www.traweb.com/">Traweb</a><br />\r\n- <a href="http://gene.mm2u.com/">Gene''s MoBlog</a><br />\r\n- <a href="http://interfacethis.com/">InterfaceThis</a><br />\r\n- <a href="http://www.thefinsters.com/flog/">The Finster Log</a><br />\r\n- <a href="http://www.mrhop.com/">Hop Nguyen</a><br />\r\n- <a href="http://www.zwavel.com/~zwavelaars" title="Zwavelaars">Zwavelaars</a><br />\r\n- <a href="http://beefcake.nl/">Joaquin Scholten</a> <br />\r\n- <a href="http://www.roelgroeneveld.com/">Roel Groeneveld</a><br />\r\n- <a href="http://lvb.net/">LVBlog</a><br />\r\n- <a href="http://xandermol.com/">Xander Mol</a><br />\r\n- Danilo Massa<br />\r\n- <a href="http://01FTP.com/">01FTP.com</a><br />\r\n- <a href="http://www.adrenalinsports.nl/">Irmo Keizer</a><br />\r\n- <a href="http://www.jasonkrogh.com/">Jason Krogh</a><br />\r\n- <a href="http://www.higuchi.com/">Osamu Higuchi</a><br />\r\n- <a href="http://www.trentadams.com/">Trent Adams</a><br />\r\n- <a href="http://www.ppcw.net/">Arne Hess</a><br />\r\n- <a href="http://hsbluebird.com/">The Bluebird</a><br />\r\n- Rainer Bickel<br />\r\n- Fritz Elfers<br />\r\n- <a href="http://www.european-wall-tapestries.com/">European Wall Tapestries</a><br />\r\n- <a href="http://www.jamier.net/">Jamie R. Rytlewski</a><br />\r\n- Madolyn Piper<br />\r\n- <a href="http://www.batteryvalues.com/">Battery Values</a><br />\r\n- <a href="http://www.mixburnrip.de/">Janko Roettgers</a><br />\r\n- Lukas Loesche<br />\r\n- <a href="http://www.seobook.com/">SEO Book</a><br />\r\n- <a href="http://www.brandweerdematen.nl/">Brandweer de Maten</a><br />\r\n- Andy Fuchs<br />\r\n- <a href="http://www.sumoforce.com/">Sumoforce</a><br />\r\n- <a href="http://love.silverindigo.com/">Al''ky''mie</a><br />\r\n- <a href="http://www.pejo.us/">Peter Johnson</a><br />\r\n- <a href="http://www.triv.nl/">TriV Internet Solutions</a><br />\r\n- <a href="http://www.torontomusicians.org/nucleus/">Margaret Stowe</a><br />\r\n- <a href="http://www.zenkey.org/">zenkey dot org</a><br />\r\n- <a href="http://www.golb.org/">Blots of Info</a><br />\r\n- <a href="http://www.zonderpartij.be/">Rudi De Kerpel</a><br />\r\n- <a href="http://staylorx.com/">Steve Taylor</a><br />\r\n- <a href="http://lmhcave.com/">Malcolm Farnsworth</a><br />\r\n- Birgit Kellner<br />\r\n- <a href="http://www.tobiasly.com/">Toby Johnson</a><br />\r\n- <a href="http://www.kapingamarangi.be/">Kapingamarangi</a><br />\r\n- <a href="http://www.pallalink.net/">Pallalink</a><br />\r\n- <a href="http://publiustx.net/">PubliusTX Weblog</a><br />\r\n- <a href="http://www.reductioadabsurdum.net/">Reductio Ad Absurdum</a><br />\r\n- <a href="http://www.gagaweb.org/">GagaWeb</a><br />\r\n- <a href="http://www.videokid.be/">Videokid</a><br />\r\n- Jon Marr<br />\r\n- <a href="http://www.docblog.org/">Luigi Cristiano</a><br />\r\n- J Keith Lehman<br />\r\n- Bohemian Cachet<br />\r\n- Jesus Mourazos<br />\r\n- <a href="http://ltp-design.com/">Stephen Jones</a><br />\r\n- <a href="http://oha.nu/">One-Handed Apps</a><br />\r\n- Alwin Hawkins<br />\r\n- <a href="http://jstigall.bloomington.in.us">Justin Stigall</a><br />\r\n- <a href="http://www.itismylife.com/">It is my life</a><br />\r\n- Greg Morrill<br />\r\n- <a href="http://www.dutchsubmarines.com/">Dutch Submarines</a><br />\r\n- <a href="http://www.7thwatch.com/">Seventh Watch Design Studios</a> <br />\r\n- <a href="http://www.macnet2.com/">MacNetv2</a> <br />\r\n- Richard Noordhof<br />\r\n- <a href="http://www.jamier.net/">Jamie Rytlewski</a><br />\r\n<br />\r\nNucleusが気に入りましたか？ <a href="http://www.hotscripts.com/Detailed/13368.html?RID=nucleus@demuynck.org">HotScripts</a>や<a href="http://www.opensourcecms.com/index.php?option=content&task=view&id=145">opensourceCMS</a>での投票をお願いします。<br />\r\n<br />\r\n<b>ライセンス</b><br />\r\n<br />\r\n私たちがフリー・ソフトウェアについて口にする場合は自由のことに言及しているのであって、価格のことではありません。私たちの<a href="http://www.gnu.org/licenses/gpl.html">一般公有使用許諾書</a>（<a href="http://www.gnu.org/licenses/gpl.ja.html">日本語訳</a>と<a href="http://www.atmarkit.co.jp/aig/03linux/gpl.html">概要</a>）は、フリー・ソフトウェアの複製物を自由に頒布できること(そして、望むならこのサービスに対して対価を請求できること)、ソース・コードを実際に受け取るか希望しさえすれば入手することが可能であること、入手したソフトウェアを変更したり新しいフリー・プログラムの一部として使用できること、以上の各内容を行なうことができるということをユーザ自身が知っていることを実現できるようにデザインされています。', 1, 1, '2005-02-16 22:57:54', 0, 0, 0, 1, 0); | |
| 136 | +'これはサイトにおける最初のエントリーです。スタートを切りやすいように、リンクと情報を入れておきました。<br />\r\n<br />\r\nこの記事を削除することもできますが、どちらにせよ記事を追加していくことによってやがてメインページからは見えなくなります。Nucleusを扱ううちに生じたメモをコメントとして追加し、将来アクセスできるようにこのページをブックマークしておくのも手です。<br />\r\n<br />\r\n<b>リンク</b><br />\r\n<br />\r\nNucleus CMSの<a href="http://nucleuscms.org">本家</a>と<a href="http://japan.nucleuscms.org">日本語公式</a>ページ。<br />\r\n<br />\r\nNucleus CMSのSourceForge<a href="http://sourceforge.net/projects/nucleuscms/">プロジェクト</a>ページ。<br />\r\n<br />\r\nNucleus CMSのプラグイン<a href="http://wakka.xiffy.nl/Plugin/">倉庫</a>と<a href="http://japan.nucleuscms.org/wakka/CategorizedPlugin">日本語のリスト</a>ページ。<br />\r\n<br />\r\n<b>ドキュメント - <a href="http://docs.nucleuscms.org/">docs.nucleuscms.org</a></b><br />\r\n<br />\r\nNucleusの<a href="http://japan.nucleuscms.org/faq.php">FAQ（よくある質問集）</a>（<a href="http://nucleuscms.org/faq.php">原文</a>）ページ。<br />\r\n<br />\r\nインストール方法等は<a href="nucleus/documentation/">ユーザー向け</a>と<a href="nucleus/documentation/devdocs/">開発者向け</a>文書がファイルに含まれています。<br />\r\n<br />\r\nポップアップ<a href="./nucleus/documentation/help.html">ヘルプ</a>が管理エリアのいたるところにあり、サイトのカスタマイズやデザインを手助けしてくれることでしょう。<br />\r\n<br />\r\n一度用意されているドキュメントに目を通したら、<a href="http://wiki.nucleuscms.org/">Wiki</a>（<a href="http://japan.nucleuscms.org/wakka/Nucleus">日本版</a>）を訪れてください。ユーザーの書いたハウツーや小技が掲載されています。<br />\r\n<br />\r\n<b>サポート</b><br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/">forum.nucleuscms.org</a>（本家）<br />\r\n<a href="http://japan.nucleuscms.org/bb/">japan.nucleuscms.org/bb/</a>（日本版）<br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/groupcp.php?g=3">moderators</a>とサポートフォーラムで活動する全てのボランティアに感謝します。<br />\r\n<br />\r\n- <a href="http://edmondhui.homeip.net/blog/">admun</a> - Ottawa, ON, Canada <br />\r\n- <a href="http://www.tamizhan.com/">anand</a> - Bangalore, India<br />\r\n- <a href="http://hcgtv.com">hcgtv</a> - Miami, Florida, USA<br />\r\n- <a href="http://www.adrenalinsports.nl/">ikeizer</a> - Maastricht<br />\r\n- <a href="http://www.tipos.com.br/">moraes</a> - Brazil<br />\r\n- <a href="http://roelg.nl/">roel </a>- The Netherlands<br />\r\n- <a href="http://budts.be/weblog/">TeRanEX </a>- Ekeren, Antwerp, Belgium<br />\r\n- <a href="http://www.trentadams.com/">Trent </a>- Alberta, Canada<br />\r\n- <a href="http://xiffy.nl/weblog/">xiffy </a>- Deventer<br />\r\n<br />\r\nもし手助けが必要なら、1400を超える登録ユーザーのいる私たちのフォーラムに参加してください。23,000を超える投稿された記事を検索できるようになっておりますので、求める答えに数回のクリックでたどり着けるかもしれません。<br />\r\n<br />\r\n<b>Personalization - <a href="http://skins.nucleuscms.org/">skins.nucleuscms.org</a></b><br />\r\n<br />\r\nマルチウェブログとスキン/テンプレートの組み合わせは強力な相乗効果を生み出します。個人的なサイト作成、友人や親戚あるいはクライアントに対するサイトデザインいずれに対してもです。<br />\r\n<br />\r\n636の登録された<a href="http://nucleuscms.org/sites.php">Nucleusで運用されているサイト</a>（<a href="http://japan.nucleuscms.org/sites.php">日本版</a>）の中から特色あるサイトをサンプルとしてご紹介します。<br />\r\n<br />\r\nThe Zen of Nucleus<br />\r\n- <a href="http://beefcake.nl/">beefcake.nl</a> - Beefcake | Nuke the whales!<br />\r\n- <a href="http://www.leng-lui.com//">leng-lui.com</a> - Leng-Lui.com - v7.0: "Memento"<br />\r\n<br />\r\nPersonal blogs<br />\r\n- <a href="http://bloggard.com/">bloggard.com</a> - The Adventures of Bloggard<br />\r\n- <a href="http://battleangel.org/">battleangel.org</a> - Giving meaning to the meaningless<br />\r\n- <a href="http://www.yetanotherblog.de/">yetanotherblog.de</a> - Yet Another Blog<br />\r\n<br />\r\nMulti user blogs<br />\r\n- <a href="http://tipos.com.br/">tipos.com.br</a> - Blogging community<br />\r\n<br />\r\nHobby, Travel and News sites<br />\r\n- <a href="http://adrenalinsports.nl/">adrenalinsports.nl</a> - Extreme sports<br />\r\n- <a href="http://hsbluebird.com/">hsbluebird.com</a> - Hot Springs, Montana''s Online Resource <br />\r\n- <a href="http://groningen-info.de/">groningen-info.de</a> - Neues aus Groningen. Fr Leute aus Duitsland.<br />\r\n- <a href="http://www.americandaily.com/">americandaily.com</a> - American Daily - Home<br />\r\n<br />\r\n<b>Nucleus Developer Network - <a href="http://dev.nucleuscms.org/">dev.nucleuscms.org</a></b><br />\r\n<br />\r\nThe NUDN is a hub for developer sites and programming resources.<br />\r\n<br />\r\nNUDN satellite sites, handles, location and UTC offset:<br />\r\n- <a href="http://karma.nucleuscms.org/">karma</a> - Izegem +02<br />\r\n- <a href="http://hcgtv.net/">hcgtv</a> - Miami -05<br />\r\n- <a href="http://edmondhui.homeip.net/blog/nudn.php">admun</a> - Ottawa -04<br />\r\n- <a href="http://dev.budts.be/nucleus/">TeRanEX</a> - Ekeren +02<br />\r\n<br />\r\nSourceforge.net graciously hosts our <a href="http://sourceforge.net/projects/nucleuscms/">CVS repository</a>.<br />\r\n<br />\r\nWant to play around or test changes, visit our demo site at <a href="http://demo.nucleuscms.org/">demo.nucleuscms.org</a>.<br />\r\n<br />\r\nNot sure what plugins to use, visit the <a href="http://showcase.trentadams.com/">showcase site</a> where you can see plugins at play in their native habitat.<br />\r\n<br />\r\nThen visit the plugin repository at <a href="http://plugins.nucleuscms.org/">plugins.nucleuscms.org</a> for download and installation instructions.<br />\r\n<br />\r\n<b>寄付者一覧</b><br />\r\n<br />\r\n以下の<a href="http://nucleuscms.org/donators.php">素晴らしい人々</a>による<a href="http://nucleuscms.org/donate.php">援助</a>感謝を捧げます。<em>ありがとう！</em><br />\r\n<br />\r\n- <a href="http://reddustrec.net/">dkex</a><br />\r\n- <a href="http://www.uncoverthenet.com/">Uncover the Net</a><br />\r\n- <a href="http://www.webatlas.org/">Web Atlas</a><br />\r\n- <a href="http://www.ipnlighting.com/">IPN Lighting</a><br />\r\n- <a href="http://blog.datoka.jp/">Yu (blog.datoka.jp)</a><br />\r\n- <a href="http://www.thegadgetreview.com/">Sony Gadgets and Reviews</a><br />\r\n- <a href="http://sites.proliphus.com/blueZhift/blog/">Thomas McKibben</a><br />\r\n- <a href="http://cheapweb.us/">CheapWeb.us</a><br />\r\n- Robert Seyfriedsberger<br />\r\n- <a href="http://www.toxicologie.nl/">Toxicologie.nl</a><br />\r\n- Gordon Shum<br />\r\n- <a href="http://www.subsim.com/">Neal Stevens</a><br />\r\n- <a href="http://www.GamblingHelper.com/">GamblingHelper</a><br />\r\n- Oliver Kirstein<br />\r\n- <a href="http://www.dominiek.be/">Dominiek</a><br />\r\n- <a href="http://www.aardschok.net/">Aardschok</a><br />\r\n- <a href="http://www.nieuwevoordeur.be/">nieuwevoordeur.be</a><br />\r\n- <a href="http://www.scene24.net/">Scene24</a><br />\r\n- <a href="http://www.eug.be/">Eug''s Weblog</a><br />\r\n- <a href="http://www.bloggard.com/">The Adventures of Bloggard</a><br />\r\n- <a href="http://www.voltos.com/">Arthur Cronos from Voltos</a><br />\r\n- <a href="http://www.webmaster-toolkit.com/">Free Webmaster Tools and Resources</a><br />\r\n- <a href="http://www.domilog.be/">Domi''s Weblog</a><br />\r\n- Infodoma <br />\r\n- <a href="http://carvingcode.com/">carvingCode.com</a><br />\r\n- <a href="http://www.traweb.com/">Traweb</a><br />\r\n- <a href="http://gene.mm2u.com/">Gene''s MoBlog</a><br />\r\n- <a href="http://interfacethis.com/">InterfaceThis</a><br />\r\n- <a href="http://www.thefinsters.com/flog/">The Finster Log</a><br />\r\n- <a href="http://www.mrhop.com/">Hop Nguyen</a><br />\r\n- <a href="http://www.zwavel.com/~zwavelaars" title="Zwavelaars">Zwavelaars</a><br />\r\n- <a href="http://beefcake.nl/">Joaquin Scholten</a> <br />\r\n- <a href="http://www.roelgroeneveld.com/">Roel Groeneveld</a><br />\r\n- <a href="http://lvb.net/">LVBlog</a><br />\r\n- <a href="http://xandermol.com/">Xander Mol</a><br />\r\n- Danilo Massa<br />\r\n- <a href="http://01FTP.com/">01FTP.com</a><br />\r\n- <a href="http://www.adrenalinsports.nl/">Irmo Keizer</a><br />\r\n- <a href="http://www.jasonkrogh.com/">Jason Krogh</a><br />\r\n- <a href="http://www.higuchi.com/">Osamu Higuchi</a><br />\r\n- <a href="http://www.trentadams.com/">Trent Adams</a><br />\r\n- <a href="http://www.ppcw.net/">Arne Hess</a><br />\r\n- <a href="http://hsbluebird.com/">The Bluebird</a><br />\r\n- Rainer Bickel<br />\r\n- Fritz Elfers<br />\r\n- <a href="http://www.european-wall-tapestries.com/">European Wall Tapestries</a><br />\r\n- <a href="http://www.jamier.net/">Jamie R. Rytlewski</a><br />\r\n- Madolyn Piper<br />\r\n- <a href="http://www.batteryvalues.com/">Battery Values</a><br />\r\n- <a href="http://www.mixburnrip.de/">Janko Roettgers</a><br />\r\n- Lukas Loesche<br />\r\n- <a href="http://www.seobook.com/">SEO Book</a><br />\r\n- <a href="http://www.brandweerdematen.nl/">Brandweer de Maten</a><br />\r\n- Andy Fuchs<br />\r\n- <a href="http://www.sumoforce.com/">Sumoforce</a><br />\r\n- <a href="http://love.silverindigo.com/">Al''ky''mie</a><br />\r\n- <a href="http://www.pejo.us/">Peter Johnson</a><br />\r\n- <a href="http://www.triv.nl/">TriV Internet Solutions</a><br />\r\n- <a href="http://www.torontomusicians.org/nucleus/">Margaret Stowe</a><br />\r\n- <a href="http://www.zenkey.org/">zenkey dot org</a><br />\r\n- <a href="http://www.golb.org/">Blots of Info</a><br />\r\n- <a href="http://www.zonderpartij.be/">Rudi De Kerpel</a><br />\r\n- <a href="http://staylorx.com/">Steve Taylor</a><br />\r\n- <a href="http://lmhcave.com/">Malcolm Farnsworth</a><br />\r\n- Birgit Kellner<br />\r\n- <a href="http://www.tobiasly.com/">Toby Johnson</a><br />\r\n- <a href="http://www.kapingamarangi.be/">Kapingamarangi</a><br />\r\n- <a href="http://www.pallalink.net/">Pallalink</a><br />\r\n- <a href="http://publiustx.net/">PubliusTX Weblog</a><br />\r\n- <a href="http://www.reductioadabsurdum.net/">Reductio Ad Absurdum</a><br />\r\n- <a href="http://www.gagaweb.org/">GagaWeb</a><br />\r\n- <a href="http://www.videokid.be/">Videokid</a><br />\r\n- Jon Marr<br />\r\n- <a href="http://www.docblog.org/">Luigi Cristiano</a><br />\r\n- J Keith Lehman<br />\r\n- Bohemian Cachet<br />\r\n- Jesus Mourazos<br />\r\n- <a href="http://ltp-design.com/">Stephen Jones</a><br />\r\n- <a href="http://oha.nu/">One-Handed Apps</a><br />\r\n- Alwin Hawkins<br />\r\n- <a href="http://jstigall.bloomington.in.us">Justin Stigall</a><br />\r\n- <a href="http://www.itismylife.com/">It is my life</a><br />\r\n- Greg Morrill<br />\r\n- <a href="http://www.dutchsubmarines.com/">Dutch Submarines</a><br />\r\n- <a href="http://www.7thwatch.com/">Seventh Watch Design Studios</a> <br />\r\n- <a href="http://www.macnet2.com/">MacNetv2</a> <br />\r\n- Richard Noordhof<br />\r\n- <a href="http://www.jamier.net/">Jamie Rytlewski</a><br />\r\n<br />\r\nNucleusが気に入りましたか？ <a href="http://www.hotscripts.com/Detailed/13368.html?RID=nucleus@demuynck.org">HotScripts</a>や<a href="http://www.opensourcecms.com/index.php?option=content&task=view&id=145">opensourceCMS</a>での投票をお願いします。<br />\r\n<br />\r\n<b>ライセンス</b><br />\r\n<br />\r\n私たちがフリー・ソフトウェアについて口にする場合は自由のことに言及しているのであって、価格のことではありません。私たちの<a href="http://www.gnu.org/licenses/gpl.html">一般公有使用許諾書</a>（<a href="http://www.gnu.org/licenses/gpl.ja.html">日本語訳</a>と<a href="http://www.atmarkit.co.jp/aig/03linux/gpl.html">概要</a>）は、フリー・ソフトウェアの複製物を自由に頒布できること(そして、望むならこのサービスに対して対価を請求できること)、ソース・コードを実際に受け取るか希望しさえすれば入手することが可能であること、入手したソフトウェアを変更したり新しいフリー・プログラムの一部として使用できること、以上の各内容を行なうことができるということをユーザ自身が知っていることを実現できるようにデザインされています。', 1, 1, '2005-02-16 22:57:54', 0, 0, 0, 1, 0); | |
| 137 | 137 | |
| 138 | 138 | CREATE TABLE `nucleus_karma` ( |
| 139 | 139 | `itemid` int(11) NOT NULL default '0', |
| @@ -201,9 +201,9 @@ CREATE TABLE `nucleus_skin` ( | ||
| 201 | 201 | PRIMARY KEY (`sdesc`,`stype`) |
| 202 | 202 | ) TYPE=MyISAM; |
| 203 | 203 | |
| 204 | -INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version="1.0" encoding="UTF-8"?>\n\n<feed xml:lang="ja" xmlns="http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <subtitle><%blogsetting(desc)%></subtitle>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel="alternate" type="text/html" href="<%blogsetting(url)%>" />\n <link rel="self" type="application/atom+xml" href="<%blogsetting(url)%><%self%>" />\n <generator uri="http://nucleuscms.org/"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>'); | |
| 204 | +INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version="1.0" encoding="<%charset%>"?>\n\n<feed xml:lang="ja" xmlns="http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel="alternate" type="text/html" href="<%blogsetting(url)%>" />\n <link rel="self" type="application/atom+xml" href="<%blogsetting(url)%><%self%>" />\n <generator uri="http://nucleuscms.org/"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>'); | |
| 205 | 205 | INSERT INTO `nucleus_skin` VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>'); |
| 206 | -INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="UTF-8"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>ja</language>\r\n <generator><%version%></generator>\r\n <copyright>©</copyright>\r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%adminurl%>nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>'); | |
| 206 | +INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="<%charset%>"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>ja</language>\r\n <generator><%version%></generator>\r\n <copyright>©</copyright>\r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%adminurl%>nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>'); | |
| 207 | 207 | |
| 208 | 208 | CREATE TABLE `nucleus_skin_desc` ( |
| 209 | 209 | `sdnumber` int(11) NOT NULL auto_increment, |
| @@ -243,7 +243,7 @@ INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" on | ||
| 243 | 243 | INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%Y-%m-%d'); |
| 244 | 244 | INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%H:%M:%S'); |
| 245 | 245 | INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>'); |
| 246 | -INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\r\n <title type="html"><![CDATA[<%title%>]]></title>\r\n <link rel="alternate" type="text/html" href="<%blogurl%>?itemid=<%itemid%>" />\r\n <author>\r\n <name><%author%></name>\r\n </author>\r\n <updated><%date(utc)%></updated>\r\n <published><%date(iso8601)%></published>\r\n <content type="html"><![CDATA[<%body%><%more%>]]></content>\r\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\r\n</entry>'); | |
| 246 | +INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\r\n <title type="text/html" mode="escaped"><![CDATA[<%title%>]]></title>\r\n <link rel="alternate" type="text/html" href="<%blogurl%>?itemid=<%itemid%>" />\r\n <author>\r\n <name><%author%></name>\r\n </author>\r\n <modified><%date(utc)%></modified>\r\n <issued><%date(iso8601)%></issued>\r\n <content type="text/html" mode="escaped"><![CDATA[<%body%><%more%>]]></content>\r\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\r\n</entry>'); | |
| 247 | 247 | |
| 248 | 248 | INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>'); |
| 249 | 249 | INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>'); |
| @@ -1,8 +1,8 @@ | ||
| 1 | 1 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> |
| 2 | 2 | <html xmlns="http://www.w3.org/1999/xhtml" lang="ja-JP" xml:lang="ja-JP"> |
| 3 | 3 | <head> |
| 4 | - <!-- $Id: plugins.html,v 1.10 2007-04-25 19:51:32 andy Exp $ --> | |
| 5 | - <!-- $NucleusJP: plugins.html,v 1.9 2007/02/04 06:28:45 kimitake Exp $ --> | |
| 4 | + <!-- $Id: plugins.html,v 1.9 2007-02-04 06:28:45 kimitake Exp $ --> | |
| 5 | + <!-- $NucleusJP: plugins.html,v 1.8 2006/07/17 20:02:50 kimitake Exp $ --> | |
| 6 | 6 | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> |
| 7 | 7 | <title>Nucleus - プラグイン API</title> |
| 8 | 8 | <link rel="stylesheet" type="text/css" href="styles/manual.css" /> |
| @@ -33,7 +33,7 @@ | ||
| 33 | 33 | <p class="heading"> </p> |
| 34 | 34 | <div class="heading"> |
| 35 | 35 | プラグイン API |
| 36 | -<i>2007年3月26日</i> | |
| 36 | +<i>2005年7月27日</i> | |
| 37 | 37 | </div> |
| 38 | 38 | |
| 39 | 39 | <div class="note-trans"><strong>訳者注：</strong> |
| @@ -681,8 +681,6 @@ by ref</var>のように示されます。</p> | ||
| 681 | 681 | <td><dl> |
| 682 | 682 | <dt class="ref">comment</dt> |
| 683 | 683 | <dd>コメントデータ（連想配列）</dd> |
| 684 | - <dt class="ref">spamcheck</dt> | |
| 685 | - <dd>(v3.3) <em>SpamCheck</em>イベントの結果として返されるデータ構造（連想配列）</dd> | |
| 686 | 684 | </dl></td> |
| 687 | 685 | </tr> |
| 688 | 686 | <tr> |
| @@ -693,8 +691,6 @@ by ref</var>のように示されます。</p> | ||
| 693 | 691 | <dd>コメントデータ（連想配列）</dd> |
| 694 | 692 | <dt class="ref">commentid</dt> |
| 695 | 693 | <dd>コメントのID</dd> |
| 696 | - <dt class="ref">spamcheck</dt> | |
| 697 | - <dd>(v3.3) <em>SpamCheck</em>イベントの結果として返されるデータ構造（連想配列）</dd> | |
| 698 | 694 | </dl></td> |
| 699 | 695 | </tr> |
| 700 | 696 | <tr> |
| @@ -1411,36 +1407,34 @@ by ref</var>のように示されます。</p> | ||
| 1411 | 1407 | <dt class="ref">error</dt> |
| 1412 | 1408 | <dd>フォーム処理をストップするときに、<code>error</code> フィールドに空でないエラーメッセージを記入します。このエラーメッセージはユーザー側に表示されます。</dd> |
| 1413 | 1409 | <dt class="ref">comment</dt> |
| 1414 | - <dd>コメントデータの連想配列（コメントフォームのときのみ）</dd> | |
| 1415 | - <dt class="ref">spamcheck</dt> | |
| 1416 | - <dd>(v3.3) <em>SpamCheck</em>イベントの結果として返される連想配列（コメントフォームのときのみ）</dd> | |
| 1410 | + <dd>コメントフォームのとき、コメントデータに関する連想配列を含みます。</dd> | |
| 1417 | 1411 | <dt class="ro obj">member</dt> |
| 1418 | 1412 | <dd>認証フォームのとき、認証中のメンバー情報を含みます。</dd> |
| 1419 | 1413 | </dl></td> |
| 1420 | 1414 | </tr> |
| 1415 | +<!-- | |
| 1421 | 1416 | <tr> |
| 1422 | - <td>SpamCheck</td> | |
| 1423 | - <td>(v3.3) 新しいコメントが追加されるときに呼ばれます。アンチスパムのプラグインはこのイベントを使ってコメントがスパムかどうかマークを付けられます。<code>SpamCheck</code>イベントの詳しい説明は別の文書を参照のこと（<a href='http://wakka.xiffy.nl/spamcheck_api'>SpamCheck API 2.0</a>）</td> | |
| 1417 | + <td></td> | |
| 1418 | + <td></td> | |
| 1424 | 1419 | <td><dl> |
| 1425 | - <dt class="ref">spamcheck</dt> | |
| 1426 | - <dd>spamcheckのデータ構造（連想配列）</dd> | |
| 1420 | + <dt></dt> | |
| 1421 | + <dd></dd> | |
| 1427 | 1422 | </dl></td> |
| 1428 | 1423 | </tr> |
| 1429 | -<!-- | |
| 1430 | 1424 | <tr> |
| 1431 | - <td>SendPing</td> | |
| 1432 | - <td>(v3.3) Called when a new item is added and the blog is configured to send ping (need NP_Ping installed). This event is used by NP_Ping to ping various weblog listing service (i.e. pingomatic.com)</td> | |
| 1425 | + <td></td> | |
| 1426 | + <td></td> | |
| 1433 | 1427 | <td><dl> |
| 1434 | - <dt class="ref">blogid</dt> | |
| 1435 | - <dd>ID of the blog</dd> | |
| 1428 | + <dt></dt> | |
| 1429 | + <dd></dd> | |
| 1436 | 1430 | </dl></td> |
| 1437 | 1431 | </tr> |
| 1438 | 1432 | <tr> |
| 1439 | - <td>JustPosted</td> | |
| 1440 | - <td>(v3.3) Called when a future post appears on the blog the first time. The event is trigger after a skin parse is completed</td> | |
| 1433 | + <td></td> | |
| 1434 | + <td></td> | |
| 1441 | 1435 | <td><dl> |
| 1442 | - <dt class="ref">blogid</dt> | |
| 1443 | - <dd>ID of the blog</dd> | |
| 1436 | + <dt></dt> | |
| 1437 | + <dd></dd> | |
| 1444 | 1438 | </dl></td> |
| 1445 | 1439 | </tr> |
| 1446 | 1440 | <tr> |
| @@ -1,8 +1,8 @@ | ||
| 1 | 1 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> |
| 2 | 2 | <html xmlns="http://www.w3.org/1999/xhtml" lang="ja-JP" xml:lang="ja-JP"> |
| 3 | 3 | <head> |
| 4 | - <!-- $Id: history.html,v 1.13 2007-05-01 06:00:28 kimitake Exp $ --> | |
| 5 | - <!-- $NucleusJP: history.html,v 1.12 2007/03/12 05:34:46 kimitake Exp $ --> | |
| 4 | + <!-- $Id: history.html,v 1.12 2007-03-12 05:34:46 kimitake Exp $ --> | |
| 5 | + <!-- $NucleusJP: history.html,v 1.11 2007/02/06 09:04:09 kimitake Exp $ --> | |
| 6 | 6 | <title>Nucleus - History</title> |
| 7 | 7 | <link rel="stylesheet" type="text/css" href="styles/manual.css" /> |
| 8 | 8 | </head> |
| @@ -51,13 +51,7 @@ | ||
| 51 | 51 | <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=45">#45(JP)</a>: added NP_0TicketForPlugin security patch (Katsumi)</li> |
| 52 | 52 | <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=46">#46(JP)</a>: fixed date format for draft entry (Kimitake)</li> |
| 53 | 53 | <li>CHANGED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=48">#48(JP)</a>: Super-admin always can login to admin page (Kimitake)</li> |
| 54 | - <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=49">#49(JP)</a>: PLUGIN::getAllItemOptions does not work correctly. (NKJG)</li> | |
| 55 | 54 | <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=56">#56(JP)</a>: When creating db backup, the key length drops (Katsumi)</li> |
| 56 | - <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=57">#57(JP)</a>: SQL error happens when updating plugin option. (Katsumi)</li> | |
| 57 | - <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=60">#60(JP)</a>: Item link in notification email is wrong. (Shizuki)</li> | |
| 58 | - <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=62">#62(JP)</a>: email address is not referred in <%usermail%>. (Shizuki)</li> | |
| 59 | - <li>FIXED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=66">#66(JP)</a>: Even if calling PostPluginOptionsUpdate, getOption does not returns correct value. (Katsumi)</li> | |
| 60 | - <li>ADDED(JP): (<a href="http://nucleus-jp.sourceforge.jp/tracker/?do=details&id=68">#68(JP)</a>: Encrypted cookie key. (Katsumi)</li> | |
| 61 | 55 | </ul> |
| 62 | 56 | </li> |
| 63 | 57 | <li> |
| @@ -1,8 +1,8 @@ | ||
| 1 | 1 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> |
| 2 | 2 | <html xmlns="http://www.w3.org/1999/xhtml" lang="ja-JP" xml:lang="ja-JP"> |
| 3 | 3 | <head> |
| 4 | - <!-- $Id: tips.html,v 1.7 2007-04-25 07:01:16 kimitake Exp $ --> | |
| 5 | - <!-- $NucleusJP: tips.html,v 1.6 2007/02/04 06:28:45 kimitake Exp $ --> | |
| 4 | + <!-- $Id: tips.html,v 1.6 2007-02-04 06:28:45 kimitake Exp $ --> | |
| 5 | + <!-- $NucleusJP: tips.html,v 1.5 2006/07/12 07:11:46 kimitake Exp $ --> | |
| 6 | 6 | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> |
| 7 | 7 | <title>Nucleus - 便利な使い方ヒントの紹介</title> |
| 8 | 8 | <link rel="stylesheet" type="text/css" href="styles/manual.css" /> |
| @@ -136,7 +136,7 @@ Nucleusのいくつかの機能を正常動作させるためにはパーミッ | ||
| 136 | 136 | |
| 137 | 137 | <h2>Windows</h2> |
| 138 | 138 | <p> |
| 139 | -Windows版では、「FFFTP」というソフトを例に用いて説明させていただきます。FFFTPはフリーウェアです。『<a href="http://www2.biglobe.ne.jp/~sota/ffftp.html">Sota's Product : FFFTP</a>』で入手できます。また、FFFTPのインストールや基本的な使い方につきましては、『<a href="http://ftp.hm/ffftp/manual.shtml">初心者マニュアル - FFFTP Support Page.</a>』をご覧下さい。 | |
| 139 | +Windows版では、「FFFTP」というソフトを例に用いて説明させていただきます。FFFTPはフリーウェアです。『<a href="http://www2.biglobe.ne.jp/‾sota/ffftp.html">Sota's Product : FFFTP</a>』で入手できます。また、FFFTPのインストールや基本的な使い方につきましては、『<a href="http://ftp.hm/ffftp/manual.shtml">初心者マニュアル - FFFTP Support Page.</a>』をご覧下さい。 | |
| 140 | 140 | </p> |
| 141 | 141 | |
| 142 | 142 | <p> |
| @@ -388,7 +388,7 @@ selector(); | ||
| 388 | 388 | </p> |
| 389 | 389 | |
| 390 | 390 | <p> |
| 391 | -ですから、スキンとテンプレートの記述でミスを犯していなければ完全なXHTML準拠のソースコードが生成されるはずです。 | |
| 391 | +ですから、スキンとテンプレートの記述でミスを犯していなければ完全なXHTML準拠のソースコードが生成されるはずです。1点だけ付け加えておきますと、標準添付のスキンでは、敢えてdoctypeを「HTML 4 Loose」と宣言しております。これは、XHTML準拠でないコードをスキンやテンプレートや記事内に登録してしまい、正常にページ表示ができなくなる可能性を回避する為です。 | |
| 392 | 392 | </p> |
| 393 | 393 | |
| 394 | 394 |
| @@ -14,8 +14,8 @@ | ||
| 14 | 14 | * |
| 15 | 15 | * @license http://nucleuscms.org/license.txt GNU General Public License |
| 16 | 16 | * @copyright Copyright (C) 2002-2007 The Nucleus Group |
| 17 | - * @version $Id: ADMIN.php,v 1.21 2007-04-27 19:05:53 kimitake Exp $ | |
| 18 | - * @version $NucleusJP: ADMIN.php,v 1.20 2007/03/22 03:30:14 kmorimatsu Exp $ | |
| 17 | + * @version $Id: ADMIN.php,v 1.20 2007-03-22 03:30:14 kmorimatsu Exp $ | |
| 18 | + * @version $NucleusJP: ADMIN.php,v 1.19 2007/03/20 19:31:29 kmorimatsu Exp $ | |
| 19 | 19 | */ |
| 20 | 20 | |
| 21 | 21 | if ( !function_exists('requestVar') ) exit; |
| @@ -840,13 +840,13 @@ class ADMIN { | ||
| 840 | 840 | |
| 841 | 841 | // start index |
| 842 | 842 | if (postVar('start')) |
| 843 | - $start = intPostVar('start'); | |
| 843 | + $start = postVar('start'); | |
| 844 | 844 | else |
| 845 | 845 | $start = 0; |
| 846 | 846 | |
| 847 | 847 | // amount of items to show |
| 848 | 848 | if (postVar('amount')) |
| 849 | - $amount = intPostVar('amount'); | |
| 849 | + $amount = postVar('amount'); | |
| 850 | 850 | else |
| 851 | 851 | $amount = 10; |
| 852 | 852 |
| @@ -892,13 +892,13 @@ class ADMIN { | ||
| 892 | 892 | |
| 893 | 893 | // start index |
| 894 | 894 | if (postVar('start')) |
| 895 | - $start = intPostVar('start'); | |
| 895 | + $start = postVar('start'); | |
| 896 | 896 | else |
| 897 | 897 | $start = 0; |
| 898 | 898 | |
| 899 | 899 | // amount of items to show |
| 900 | 900 | if (postVar('amount')) |
| 901 | - $amount = intPostVar('amount'); | |
| 901 | + $amount = postVar('amount'); | |
| 902 | 902 | else |
| 903 | 903 | $amount = 10; |
| 904 | 904 |
| @@ -933,13 +933,13 @@ class ADMIN { | ||
| 933 | 933 | |
| 934 | 934 | // start index |
| 935 | 935 | if (postVar('start')) |
| 936 | - $start = intPostVar('start'); | |
| 936 | + $start = postVar('start'); | |
| 937 | 937 | else |
| 938 | 938 | $start = 0; |
| 939 | 939 | |
| 940 | 940 | // amount of items to show |
| 941 | 941 | if (postVar('amount')) |
| 942 | - $amount = intPostVar('amount'); | |
| 942 | + $amount = postVar('amount'); | |
| 943 | 943 | else |
| 944 | 944 | $amount = 10; |
| 945 | 945 |
| @@ -986,13 +986,13 @@ class ADMIN { | ||
| 986 | 986 | |
| 987 | 987 | // start index |
| 988 | 988 | if (postVar('start')) |
| 989 | - $start = intPostVar('start'); | |
| 989 | + $start = postVar('start'); | |
| 990 | 990 | else |
| 991 | 991 | $start = 0; |
| 992 | 992 | |
| 993 | 993 | // amount of items to show |
| 994 | 994 | if (postVar('amount')) |
| 995 | - $amount = intPostVar('amount'); | |
| 995 | + $amount = postVar('amount'); | |
| 996 | 996 | else |
| 997 | 997 | $amount = 10; |
| 998 | 998 |
| @@ -6222,4 +6222,4 @@ selector(); | ||
| 6222 | 6222 | |
| 6223 | 6223 | } // class ADMIN |
| 6224 | 6224 | |
| 6225 | -?> | |
| 6225 | +?> | |
| \ No newline at end of file |
| @@ -1,24 +1,20 @@ | ||
| 1 | 1 | <?php |
| 2 | -/* | |
| 3 | - * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/) | |
| 4 | - * Copyright (C) 2002-2007 The Nucleus Group | |
| 5 | - * | |
| 6 | - * This program is free software; you can redistribute it and/or | |
| 7 | - * modify it under the terms of the GNU General Public License | |
| 8 | - * as published by the Free Software Foundation; either version 2 | |
| 9 | - * of the License, or (at your option) any later version. | |
| 10 | - * (see nucleus/documentation/index.html#license for more info) | |
| 11 | - */ | |
| 12 | 2 | /** |
| 13 | - * @license http://nucleuscms.org/license.txt GNU General Public License | |
| 14 | - * @copyright Copyright (C) 2002-2007 The Nucleus Group | |
| 15 | - * @version $Id: index.php,v 1.11 2007-04-26 08:45:26 kimitake Exp $ | |
| 16 | - * $NucleusJP: index.php,v 1.10 2007/04/26 06:20:18 kimitake Exp $ | |
| 17 | - * | |
| 18 | - */ | |
| 19 | - | |
| 20 | -include('upgrade.functions.php'); | |
| 21 | - | |
| 3 | + * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/) | |
| 4 | + * Copyright (C) 2002-2007 The Nucleus Group | |
| 5 | + * | |
| 6 | + * This program is free software; you can redistribute it and/or | |
| 7 | + * modify it under the terms of the GNU General Public License | |
| 8 | + * as published by the Free Software Foundation; either version 2 | |
| 9 | + * of the License, or (at your option) any later version. | |
| 10 | + * (see nucleus/documentation/index.html#license for more info) | |
| 11 | + * | |
| 12 | + * $Id: index.php,v 1.9 2007-04-10 03:55:20 kmorimatsu Exp $ | |
| 13 | + * $NucleusJP: index.php,v 1.8 2007/02/04 06:28:46 kimitake Exp $ | |
| 14 | + */ | |
| 15 | + | |
| 16 | +include('upgrade.functions.php'); | |
| 17 | + | |
| 22 | 18 | // check if logged in etc |
| 23 | 19 | if (!$member->isLoggedIn()) { |
| 24 | 20 | upgrade_showLogin('index.php'); |
| @@ -44,27 +40,25 @@ upgrade_head(); | ||
| 44 | 40 | </p> |
| 45 | 41 | |
| 46 | 42 | <?php // calculate current version |
| 47 | - if (!upgrade_checkinstall(96)) $current = 95; | |
| 43 | + if (!upgrade_checkinstall(96)) $current = 95; | |
| 48 | 44 | else if (!upgrade_checkinstall(10)) $current = 96; |
| 49 | 45 | else if (!upgrade_checkinstall(11)) $current = 10; |
| 50 | - else if (!upgrade_checkinstall(15)) $current = 11; | |
| 51 | - else if (!upgrade_checkinstall(20)) $current = 15; | |
| 52 | - else if (!upgrade_checkinstall(25)) $current = 20; | |
| 53 | - else if (!upgrade_checkinstall(30)) $current = 25; | |
| 54 | - else if (!upgrade_checkinstall(31)) $current = 30; | |
| 55 | - else if (!upgrade_checkinstall(32)) $current = 31; | |
| 56 | - else if (!upgrade_checkinstall(33)) $current = 32; | |
| 46 | + else if (!upgrade_checkinstall(15)) $current = 11; | |
| 47 | + else if (!upgrade_checkinstall(20)) $current = 15; | |
| 48 | + else if (!upgrade_checkinstall(25)) $current = 20; | |
| 49 | + else if (!upgrade_checkinstall(30)) $current = 25; | |
| 50 | + else if (!upgrade_checkinstall(31)) $current = 30; | |
| 51 | + else if (!upgrade_checkinstall(32)) $current = 31; | |
| 52 | + else if (!upgrade_checkinstall(33)) $current = 32; | |
| 57 | 53 | else $current = 33; |
| 58 | 54 | |
| 59 | 55 | if ($current == 33) { |
| 60 | - ?> | |
| 61 | - <p class="ok">自動でできるアップグレードはありません。データベースは既に最新の Nucleus 用にアップデートされています。</p> | |
| 62 | - <?php | |
| 63 | - } else { | |
| 64 | - ?> | |
| 65 | - <p class="warning"><a href="upgrade.php?from=<?php echo $current?>">ここをクリックしてデータベースを Nucleus v3.3 用にアップグレードします</a></p> | |
| 66 | - <?php | |
| 67 | - } | |
| 56 | + ?> | |
| 57 | + <p class="ok">自動でできるアップグレードはありません。データベースは既に最新の Nucleus 用にアップデートされています。</p> | |
| 58 | + <?php } else { | |
| 59 | + ?> | |
| 60 | + <p class="warning"><a href="upgrade.php?from=<?php echo $current?>">ここをクリックしてデータベースを Nucleus v3.3 用にアップグレードします</a></p> | |
| 61 | + <?php } | |
| 68 | 62 | ?> |
| 69 | 63 | |
| 70 | 64 | <div class="note"> |
| @@ -93,11 +87,8 @@ if (phpversion() < '4.0.6') { | ||
| 93 | 87 | $sth = 1; |
| 94 | 88 | } |
| 95 | 89 | |
| 96 | -// from v3.3, atom feed supports 1.0 and blogsetting is added | |
| 97 | -$sth = upgrade_manual_atom1_0(); | |
| 98 | - | |
| 99 | 90 | if ($sth == 0) |
| 100 | - echo "<p class='ok'>手動変更は必要ありません。今日はラッキーな日ですね!</p>"; | |
| 91 | + echo "<p class='ok'>手動変更は必要ありません。今日はラッキーな日ですね!</p>"; | |
| 101 | 92 | |
| 102 | 93 | |
| 103 | 94 |
| @@ -109,7 +100,7 @@ function upgrade_todo($ver) { | ||
| 109 | 100 | |
| 110 | 101 | function upgrade_manual_96() { |
| 111 | 102 | global $DIR_NUCLEUS; |
| 112 | - | |
| 103 | + | |
| 113 | 104 | $guess = str_replace("/nucleus/","/media/",$DIR_NUCLEUS); |
| 114 | 105 | ?> |
| 115 | 106 | <h2>Nucleus 0.96 用に必要な変更</h2> |
| @@ -120,16 +111,16 @@ function upgrade_manual_96() { | ||
| 120 | 111 | // path to media dir |
| 121 | 112 | $DIR_MEDIA = '<b><?php echo htmlspecialchars($guess)?></b>'; |
| 122 | 113 | </pre> |
| 123 | - | |
| 114 | + | |
| 124 | 115 | <p> |
| 125 | 116 | また、ディレクトリもあなた自身の手で作る必要があります。もしファイルのアップロードを可能にしたいのであれば、media/ ディレクトリのパーミッションを777にします。（Nucleus 0.96+ のためのパーミッションの設定に関するクイックガイドが documentation/tips.html にあります） |
| 126 | 117 | </p> |
| 127 | - | |
| 118 | + | |
| 128 | 119 | <?php } |
| 129 | 120 | |
| 130 | 121 | function upgrade_manual_20() { |
| 131 | 122 | global $DIR_NUCLEUS; |
| 132 | - | |
| 123 | + | |
| 133 | 124 | $guess = str_replace("/nucleus/","/skins/",$DIR_NUCLEUS); |
| 134 | 125 | ?> |
| 135 | 126 | <h2>Nucleus 2.0 用に必要な変更</h2> |
| @@ -140,13 +131,13 @@ function upgrade_manual_20() { | ||
| 140 | 131 | // extra skin files for imported skins |
| 141 | 132 | $DIR_SKINS = '<b><?php echo htmlspecialchars($guess)?></b>'; |
| 142 | 133 | </pre> |
| 143 | - | |
| 134 | + | |
| 144 | 135 | <p>また、ディレクトリもあなた自身の手で作る必要があります。これでダウンロードしたスキンを上記ディレクトリに展開したり、Nucleus 管理画面から取り込んだりできるようになります。</p> |
| 145 | - | |
| 136 | + | |
| 146 | 137 | <h3>RSS 2.0 と RSD スキン</h3> |
| 147 | - | |
| 138 | + | |
| 148 | 139 | <p>Nucleus 2.0 を新規にインストールしたとき、RSD(Really Simple Discovery) 用のスキンの他に、RSS 2.0(Really Simple Syndication)用のスキンもまたインストールされます。<code>xml-rss2.php</code> と <code>rsd.php</code> の両ファイルはアップグレードされますが、スキンに関しては手動でインストールする必要があります。<code>upgrade-files</code>の中身をアップロードしたあと、管理者画面を開き、管理ホームにあるスキンの「読込/書出」を開きます。そこから両スキンをインストールすることができます（もしインストールするつもりがなければ、しなくても結構です）。</p> |
| 149 | - | |
| 140 | + | |
| 150 | 141 | <?php } |
| 151 | 142 | |
| 152 | 143 | function upgrade_manual_php405() { |
| @@ -157,86 +148,32 @@ function upgrade_manual_php405() { | ||
| 157 | 148 | </p> |
| 158 | 149 | <ul> |
| 159 | 150 | <li>nucleus/libs/PARSER.php のコードが下記のようになっていることを確認して下さい。（84行目から）: |
| 160 | - <pre> | |
| 151 | + <pre> | |
| 161 | 152 | |
| 162 | 153 | if (in_array($actionlc, $this->actions) || $this->norestrictions ) { |
| 163 | - <strong>$this->call_using_array($action, $this->handler, $params);</strong> | |
| 154 | + <strong>$this->call_using_array($action, $this->handler, $params);</strong> | |
| 164 | 155 | } else { |
| 165 | - // redirect to plugin action if possible | |
| 166 | - if (in_array('plugin', $this->actions) | |
| 167 | - && $manager->pluginInstalled('NP_'.$action)) | |
| 168 | - $this->doAction('plugin('.$action. | |
| 169 | - $this->pdelim.implode($this->pdelim,$params).')'); | |
| 170 | - else | |
| 171 | - echo '<b>DISALLOWED (' , $action , ')</b>'; | |
| 156 | + // redirect to plugin action if possible | |
| 157 | + if (in_array('plugin', $this->actions) | |
| 158 | + && $manager->pluginInstalled('NP_'.$action)) | |
| 159 | + $this->doAction('plugin('.$action. | |
| 160 | + $this->pdelim.implode($this->pdelim,$params).')'); | |
| 161 | + else | |
| 162 | + echo '<b>DISALLOWED (' , $action , ')</b>'; | |
| 172 | 163 | } |
| 173 | 164 | |
| 174 | 165 | |
| 175 | 166 | } |
| 176 | - </pre> | |
| 177 | - </li> | |
| 178 | - <li>nucleus/libs/PARSER.php のコードが下記のようになっていることを確認して下さい。（75行目から）: | |
| 179 | - <pre> | |
| 167 | + </pre> | |
| 168 | + </li> | |
| 169 | + <li>nucleus/libs/PARSER.php のコードが下記のようになっていることを確認して下さい。（75行目から）: | |
| 170 | + <pre> | |
| 180 | 171 | // $params = array_map('trim',$params); |
| 181 | 172 | foreach ($params as $key => $value) { $params[$key] = trim($value); } |
| 182 | - </pre> | |
| 183 | - </li> | |
| 173 | + </pre> | |
| 174 | + </li> | |
| 184 | 175 | </ul> |
| 185 | - | |
| 176 | + | |
| 186 | 177 | <?php } |
| 187 | 178 | |
| 188 | -function upgrade_manual_atom1_0() { | |
| 189 | - | |
| 190 | - $sth = 0; | |
| 191 | - | |
| 192 | - // atom 1.0 | |
| 193 | - $query = 'SELECT sddesc FROM ' . sql_table('skin_desc') | |
| 194 | - . ' WHERE sdname="feeds/atom"'; | |
| 195 | - $res = mysql_query($query); | |
| 196 | - while ($o = mysql_fetch_object($res)) { | |
| 197 | - if ($o->sddesc=='Atom 0.3 weblog syndication') | |
| 198 | - { | |
| 199 | - $sth = 1; | |
| 200 | -?> | |
| 201 | -<h2>Atom 1.0</h2> | |
| 202 | -<p>Nucleus 3.3 から atom feed が 1.0 対応になりましたので、次の手順でスキン・テンプレートのアップグレードをして下さい。</p> | |
| 203 | - | |
| 204 | -<p>管理者画面を開き、管理ホームにあるスキンの「読込/書出」を開きます。そこから atom を選択し、読み込みボタンを押して上書きインストールしてください。</p> | |
| 205 | - | |
| 206 | -<p>もし atom のスキンやテンプレートを変更している場合は、既存の内容をファイルに書き出して（skinbackup.xml というファイルが作成されます）、/skins/atom/skinbackup.xml （これが新しいファイル）と比較し、この新しいファイルを更新します。その後、前述の通り管理者画面からスキンの「読込/書出」を開いて同様にして上書きインストールして下さい。</p> | |
| 207 | - | |
| 208 | -<?php | |
| 209 | - } | |
| 210 | - } | |
| 211 | - | |
| 212 | - // default skin | |
| 213 | - $query = 'SELECT tdnumber FROM ' . sql_table('template_desc') | |
| 214 | - . ' WHERE tdname="default/index"'; | |
| 215 | - $res = mysql_query($query); | |
| 216 | - $tdnumber = 0; | |
| 217 | - while ($o = mysql_fetch_object($res)) { | |
| 218 | - $tdnumber = $o->tdnumber; | |
| 219 | - } | |
| 220 | - if ($tdnumber>0) | |
| 221 | - { | |
| 222 | - $query = 'SELECT tpartname FROM ' . sql_table('template') | |
| 223 | - . ' WHERE tdesc=' . $tdnumber . ' AND tpartname="BLOGLIST_LISTITEM"'; | |
| 224 | - $res = mysql_query($query); | |
| 225 | - if (!mysql_fetch_object($res)) { | |
| 226 | - | |
| 227 | - $sth = 1; | |
| 228 | -?> | |
| 229 | -<h2>Default スキン</h2> | |
| 230 | -<p>Nucleus 3.3 からいくつかのフォームの CSS が変更になっています。たとえば最初のページのログインフォームや、コメント投稿のためのフォームなど。このためフォームの表示が崩れるので、次の手順でDefault スキンのアップグレードをして下さい。</p> | |
| 231 | - | |
| 232 | -<p>管理者画面を開き、管理ホームにあるスキンの「読込/書出」を開きます。そこから default を選択し、読み込みボタンを押して上書きインストールしてください。</p> | |
| 233 | - | |
| 234 | -<p>もし default のスキンやテンプレートを変更している場合は、既存の内容をファイルに書き出して（skinbackup.xml というファイルが作成されます）、/skins/default/skinbackup.xml （これが新しいファイル）と比較し、この新しいファイルを更新します。その後、前述の通り管理者画面からスキンの「読込/書出」を開いて同様にして上書きインストールして下さい。</p> | |
| 235 | -<?php | |
| 236 | - } | |
| 237 | - } | |
| 238 | - | |
| 239 | - return $sth; | |
| 240 | -} | |
| 241 | - | |
| 242 | 179 | ?> |
| @@ -1,45 +1,30 @@ | ||
| 1 | -<?php | |
| 1 | +<?php | |
| 2 | 2 | |
| 3 | - /* | |
| 4 | - * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/) | |
| 5 | - * Copyright (C) 2002-2007 The Nucleus Group | |
| 6 | - * | |
| 7 | - * This program is free software; you can redistribute it and/or | |
| 8 | - * modify it under the terms of the GNU General Public License | |
| 9 | - * as published by the Free Software Foundation; either version 2 | |
| 10 | - * of the License, or (at your option) any later version. | |
| 11 | - * (see nucleus/documentation/index.html#license for more info) | |
| 12 | - */ | |
| 13 | 3 | /** |
| 14 | - * Some functions common to all upgrade scripts | |
| 15 | - * | |
| 16 | - * @license http://nucleuscms.org/license.txt GNU General Public License | |
| 17 | - * @copyright Copyright (C) 2002-2007 The Nucleus Group | |
| 18 | - * @version $Id: upgrade.functions.php,v 1.10 2007-04-26 06:20:19 kimitake Exp $ | |
| 19 | - * $NucleusJP: upgrade.functions.php,v 1.9 2007/04/14 00:44:27 kmorimatsu Exp $ | |
| 20 | - */ | |
| 4 | + * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/) | |
| 5 | + * Copyright (C) 2002-2007 The Nucleus Group | |
| 6 | + * | |
| 7 | + * This program is free software; you can redistribute it and/or | |
| 8 | + * modify it under the terms of the GNU General Public License | |
| 9 | + * as published by the Free Software Foundation; either version 2 | |
| 10 | + * of the License, or (at your option) any later version. | |
| 11 | + * (see nucleus/documentation/index.html#license for more info) | |
| 12 | + * | |
| 13 | + * Some functions common to all upgrade scripts | |
| 14 | + * | |
| 15 | + * $Id: upgrade.functions.php,v 1.9 2007-04-14 00:44:27 kmorimatsu Exp $ | |
| 16 | + * $NucleusJP: upgrade.functions.php,v 1.8 2007/04/10 03:55:20 kmorimatsu Exp $ | |
| 17 | + */ | |
| 21 | 18 | |
| 22 | 19 | include('../../config.php'); |
| 23 | - | |
| 20 | + | |
| 24 | 21 | // sql_table function did not exists in nucleus <= 2.0 |
| 25 | 22 | if (!function_exists('sql_table')) |
| 26 | 23 | { |
| 27 | 24 | function sql_table($name) { |
| 28 | 25 | return 'nucleus_' . $name; |
| 29 | 26 | } |
| 30 | - } | |
| 31 | - | |
| 32 | - //intGetVar did not exist in very early versions | |
| 33 | - if (!function_exists('intGetVar')) { | |
| 34 | - function intGetVar($name) { | |
| 35 | - if (defined($_GET)) { | |
| 36 | - return intval($_GET[$name]); | |
| 37 | - } else { | |
| 38 | - global $HTTP_GET_VARS; | |
| 39 | - return intval($HTTP_GET_VARS[$name]); | |
| 40 | - } | |
| 41 | - } | |
| 42 | - } | |
| 27 | + } | |
| 43 | 28 | |
| 44 | 29 | function upgrade_checkinstall($version) { |
| 45 | 30 | $installed = 0; |
| @@ -51,34 +36,34 @@ | ||
| 51 | 36 | break; |
| 52 | 37 | case '96': |
| 53 | 38 | $query = 'SELECT cip FROM '.sql_table('comment').' LIMIT 1'; |
| 54 | - $minrows = -1; | |
| 39 | + $minrows = -1; | |
| 55 | 40 | break; |
| 56 | 41 | case '10': |
| 57 | 42 | $query = 'SELECT mcookiekey FROM '.sql_table('member').' LIMIT 1'; |
| 58 | - $minrows = -1; | |
| 59 | - break; | |
| 43 | + $minrows = -1; | |
| 44 | + break; | |
| 60 | 45 | case '11': |
| 61 | 46 | $query = 'SELECT bnotifytype FROM '.sql_table('blog').' LIMIT 1'; |
| 62 | - $minrows = -1; | |
| 47 | + $minrows = -1; | |
| 63 | 48 | break; |
| 64 | 49 | case '15': |
| 65 | 50 | $query = 'SELECT * FROM '.sql_table('plugin_option').' LIMIT 1'; |
| 66 | - $minrows = -1; | |
| 67 | - break; | |
| 51 | + $minrows = -1; | |
| 52 | + break; | |
| 68 | 53 | case '20': |
| 69 | 54 | $query = 'SELECT sdincpref FROM '.sql_table('skin_desc').' LIMIT 1'; |
| 70 | - $minrows = -1; | |
| 71 | - break; | |
| 55 | + $minrows = -1; | |
| 56 | + break; | |
| 72 | 57 | // dev only (v2.2) |
| 73 | 58 | case '22': |
| 74 | 59 | $query = 'SELECT oid FROM '.sql_table('plugin_option_desc').' LIMIT 1'; |
| 75 | - $minrows = -1; | |
| 60 | + $minrows = -1; | |
| 76 | 61 | break; |
| 77 | 62 | // v2.5 beta |
| 78 | 63 | case '24': |
| 79 | 64 | $query = 'SELECT bincludesearch FROM ' . sql_table('blog') . ' LIMIT 1'; |
| 80 | - $minrows = -1; | |
| 81 | - break; | |
| 65 | + $minrows = -1; | |
| 66 | + break; | |
| 82 | 67 | case '25': |
| 83 | 68 | $query = 'SELECT * FROM '.sql_table('config').' WHERE name=\'DatabaseVersion\' and value >= 250 LIMIT 1'; |
| 84 | 69 | $minrows = 1; |
| @@ -106,8 +91,8 @@ | ||
| 106 | 91 | |
| 107 | 92 | return $installed; |
| 108 | 93 | } |
| 109 | - | |
| 110 | - | |
| 94 | + | |
| 95 | + | |
| 111 | 96 | /** this function gets the nucleus version, even if the getNucleusVersion |
| 112 | 97 | * function does not exist yet |
| 113 | 98 | * return 96 for all versions < 100 |
| @@ -116,13 +101,13 @@ | ||
| 116 | 101 | if (!function_exists('getNucleusVersion')) return 96; |
| 117 | 102 | return getNucleusVersion(); |
| 118 | 103 | } |
| 119 | - | |
| 104 | + | |
| 120 | 105 | function upgrade_showLogin($type) { |
| 121 | 106 | upgrade_head(); |
| 122 | 107 | ?> |
| 123 | 108 | <h1>まずはログインして下さい</h1> |
| 124 | 109 | <p>下記の情報を入力して下さい:</p> |
| 125 | - | |
| 110 | + | |
| 126 | 111 | <form method="post" action="<?php echo $type?>"> |
| 127 | 112 | |
| 128 | 113 | <ul> |
| @@ -134,12 +119,12 @@ | ||
| 134 | 119 | <input name="action" value="login" type="hidden" /> |
| 135 | 120 | <input type="submit" value="ログイン" /> |
| 136 | 121 | </p> |
| 137 | - | |
| 122 | + | |
| 138 | 123 | </form> |
| 139 | 124 | <?php upgrade_foot(); |
| 140 | 125 | exit; |
| 141 | 126 | } |
| 142 | - | |
| 127 | + | |
| 143 | 128 | function upgrade_head() { |
| 144 | 129 | ?> |
| 145 | 130 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> |
| @@ -147,10 +132,8 @@ | ||
| 147 | 132 | <head> |
| 148 | 133 | <meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8" /> |
| 149 | 134 | <title>Nucleus アップグレード</title> |
| 150 | -<?php if (file_exists("../styles/manual.css")) { ?> | |
| 151 | - <link rel="stylesheet" href="../styles/manual.css" type="text/css" /> | |
| 152 | -<?php }else{ ?> | |
| 153 | - <style type="text/css"><!-- | |
| 135 | + <style><!-- | |
| 136 | + @import url('../styles/manual.css'); | |
| 154 | 137 | .warning { |
| 155 | 138 | color: red; |
| 156 | 139 | } |
| @@ -158,24 +141,23 @@ | ||
| 158 | 141 | color: green; |
| 159 | 142 | } |
| 160 | 143 | --></style> |
| 161 | -<?php } ?> | |
| 162 | 144 | </head> |
| 163 | - <body> | |
| 145 | + <body> | |
| 164 | 146 | <?php } |
| 165 | 147 | |
| 166 | 148 | function upgrade_foot() { |
| 167 | 149 | ?> |
| 168 | 150 | </body> |
| 169 | - </html> | |
| 170 | - <?php } | |
| 171 | - | |
| 151 | + </html> | |
| 152 | + <?php } | |
| 153 | + | |
| 172 | 154 | function upgrade_error($msg) { |
| 173 | 155 | upgrade_head(); |
| 174 | 156 | ?> |
| 175 | 157 | <h1>エラー!</h1> |
| 176 | 158 | |
| 177 | 159 | <p>メッセージは以下の通り:</p> |
| 178 | - | |
| 160 | + | |
| 179 | 161 | <blockquote><div> |
| 180 | 162 | <?php echo $msg?> |
| 181 | 163 | </div></blockquote> |
| @@ -185,48 +167,48 @@ | ||
| 185 | 167 | upgrade_foot(); |
| 186 | 168 | exit; |
| 187 | 169 | } |
| 188 | - | |
| 189 | - | |
| 170 | + | |
| 171 | + | |
| 190 | 172 | function upgrade_start() { |
| 191 | 173 | global $upgrade_failures; |
| 192 | 174 | $upgrade_failures = 0; |
| 193 | - | |
| 175 | + | |
| 194 | 176 | upgrade_head(); |
| 195 | 177 | ?> |
| 196 | 178 | <h1>アップグレードの実行</h1> |
| 197 | 179 | <ul> |
| 198 | 180 | <?php } |
| 199 | - | |
| 181 | + | |
| 200 | 182 | function upgrade_end($msg = "") { |
| 201 | 183 | global $upgrade_failures; |
| 202 | 184 | if ($upgrade_failures > 0) |
| 203 | 185 | $msg = "いくつかのデータベース操作に失敗しました。もし以前にこのアップグレードスクリプトを実行していたのであれば、問題ないと思われます。"; |
| 204 | - | |
| 186 | + | |
| 205 | 187 | ?> |
| 206 | 188 | </ul> |
| 207 | - | |
| 189 | + | |
| 208 | 190 | <h1>アップグレード完了!</h1> |
| 209 | 191 | |
| 210 | 192 | <p><?php echo $msg?></p> |
| 211 | - | |
| 193 | + | |
| 212 | 194 | <p><a href="index.php">アップグレード最初のページ</a>にもどる</p> |
| 213 | 195 | |
| 214 | 196 | <?php |
| 215 | 197 | upgrade_foot(); |
| 216 | 198 | exit; |
| 217 | - } | |
| 218 | - | |
| 199 | + } | |
| 200 | + | |
| 219 | 201 | /** |
| 220 | 202 | * Tries to execute a query, gives a message when failed |
| 221 | 203 | * |
| 222 | 204 | * @param friendly name |
| 223 | - * @param query | |
| 205 | + * @param query | |
| 224 | 206 | */ |
| 225 | 207 | function upgrade_query($friendly, $query) { |
| 226 | 208 | global $upgrade_failures; |
| 227 | - | |
| 209 | + | |
| 228 | 210 | echo "<li>$friendly ... "; |
| 229 | - $res = mysql_query($query); | |
| 211 | + $res = sql_query($query); | |
| 230 | 212 | if (!$res) { |
| 231 | 213 | echo "<span style='color:red'>失敗</span>\n"; |
| 232 | 214 | echo "<blockquote>失敗の理由: " . mysql_error() . " </blockquote>"; |
| @@ -237,32 +219,16 @@ | ||
| 237 | 219 | echo "</li>"; |
| 238 | 220 | return $res; |
| 239 | 221 | } |
| 240 | - | |
| 241 | - /** | |
| 242 | - * Tries to update database version, gives a message when failed | |
| 243 | - * | |
| 244 | - * @param $version | |
| 245 | - * Schema version the database has been upgraded to | |
| 246 | - */ | |
| 247 | - function update_version($version) { | |
| 248 | - global $upgrade_failures; | |
| 249 | - $message='Updating DatabaseVersion in config table to '.$version; | |
| 250 | - if(0==$upgrade_failures){ | |
| 251 | - $query = 'UPDATE ' . sql_table('config') . ' set value=\''.$version.'\' where name=\'DatabaseVersion\''; | |
| 252 | - upgrade_query($message, $query); | |
| 253 | - }else | |
| 254 | - echo '<li>'.$message.' ... <span class="warning">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>'; | |
| 255 | - } | |
| 256 | - | |
| 222 | + | |
| 257 | 223 | /** |
| 258 | - * @param $table | |
| 224 | + * @param $table | |
| 259 | 225 | * table to check (without prefix) |
| 260 | 226 | * @param $aColumns |
| 261 | 227 | * array of column names included |
| 262 | 228 | */ |
| 263 | 229 | function upgrade_checkIfIndexExists($table, $aColumns) { |
| 264 | 230 | // get info for indices from database |
| 265 | - | |
| 231 | + | |
| 266 | 232 | $aIndices = array(); |
| 267 | 233 | $query = 'show index from ' . sql_table($table); |
| 268 | 234 | $res = mysql_query($query); |
| @@ -278,52 +244,11 @@ | ||
| 278 | 244 | $aDiff = array_diff($aIndexColumns, $aColumns); |
| 279 | 245 | if (count($aDiff) == 0) return 1; |
| 280 | 246 | } |
| 281 | - | |
| 247 | + | |
| 282 | 248 | return 0; |
| 283 | 249 | |
| 284 | 250 | } |
| 285 | 251 | |
| 286 | - /** | |
| 287 | - * Checks to see if a given table exists | |
| 288 | - * | |
| 289 | - * @param $table | |
| 290 | - * Name of table to check for existance of | |
| 291 | - * Uses sql_table internally | |
| 292 | - * @return true if table exists, false otherwise. | |
| 293 | - */ | |
| 294 | - function upgrade_checkIfTableExists($table){ | |
| 295 | - $query = 'SHOW TABLES LIKE \''.sql_table($table).'\''; | |
| 296 | - $res = mysql_query($query); | |
| 297 | - return ($res != 0) && (mysql_num_rows($res) == 1); | |
| 298 | - } | |
| 299 | 252 | |
| 300 | - /** | |
| 301 | - * Checks to see if a given configuration value exists | |
| 302 | - * | |
| 303 | - * @param $value | |
| 304 | - * Config value to check for existance of. | |
| 305 | - * Paramater must be MySQL escaped | |
| 306 | - * @return true if configuration value exists, false otherwise. | |
| 307 | - */ | |
| 308 | - function upgrade_checkIfCVExists($value){ | |
| 309 | - $query = 'SELECT name from '.sql_table('config').' WHERE name = \''.$value.'\''; | |
| 310 | - $res = mysql_query($query); | |
| 311 | - return ($res != 0) && (mysql_num_rows($res) == 1); | |
| 312 | - } | |
| 313 | 253 | |
| 314 | - /** | |
| 315 | - * Checks to see if a given column exists | |
| 316 | - * | |
| 317 | - * @param $table | |
| 318 | - * Name of table to check for column in | |
| 319 | - * Uses sql_table internally | |
| 320 | - * @param $col | |
| 321 | - * Name of column to check for existance of | |
| 322 | - * @return true if column exists, false otherwise. | |
| 323 | - */ | |
| 324 | - function upgrade_checkIfColumnExists($table, $col){ | |
| 325 | - $query = 'DESC `'.sql_table($table).'` `'.$col.'`'; | |
| 326 | - $res = mysql_query($query); | |
| 327 | - return ($res != 0) && (mysql_num_rows($res) == 1); | |
| 328 | - } | |
| 329 | 254 | ?> |
| @@ -1,23 +1,20 @@ | ||
| 1 | 1 | <?php |
| 2 | -/* | |
| 3 | - * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/) | |
| 4 | - * Copyright (C) 2002-2007 The Nucleus Group | |
| 5 | - * | |
| 6 | - * This program is free software; you can redistribute it and/or | |
| 7 | - * modify it under the terms of the GNU General Public License | |
| 8 | - * as published by the Free Software Foundation; either version 2 | |
| 9 | - * of the License, or (at your option) any later version. | |
| 10 | - * (see nucleus/documentation/index.html#license for more info) | |
| 11 | - */ | |
| 12 | 2 | /** |
| 13 | - * @license http://nucleuscms.org/license.txt GNU General Public License | |
| 14 | - * @copyright Copyright (C) 2002-2007 The Nucleus Group | |
| 15 | - * @version $Id: upgrade.php,v 1.7 2007-04-26 06:20:19 kimitake Exp $ | |
| 16 | - * $NucleusJP: upgrade.php,v 1.6 2007/04/10 03:55:20 kmorimatsu Exp $ | |
| 17 | - */ | |
| 18 | - | |
| 19 | -include('upgrade.functions.php'); | |
| 3 | + * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/) | |
| 4 | + * Copyright (C) 2002-2007 The Nucleus Group | |
| 5 | + * | |
| 6 | + * This program is free software; you can redistribute it and/or | |
| 7 | + * modify it under the terms of the GNU General Public License | |
| 8 | + * as published by the Free Software Foundation; either version 2 | |
| 9 | + * of the License, or (at your option) any later version. | |
| 10 | + * (see nucleus/documentation/index.html#license for more info) | |
| 11 | + * | |
| 12 | + * $Id: upgrade.php,v 1.6 2007-04-10 03:55:20 kmorimatsu Exp $ | |
| 13 | + * $NucleusJP: upgrade.php,v 1.5 2007/02/04 06:28:46 kimitake Exp $ | |
| 14 | + */ | |
| 20 | 15 | |
| 16 | +include('upgrade.functions.php'); | |
| 17 | + | |
| 21 | 18 | // check if logged in etc |
| 22 | 19 | if (!$member->isLoggedIn()) { |
| 23 | 20 | upgrade_showLogin('upgrade.php?from=' . intGetVar('from')); |
| @@ -63,7 +60,6 @@ switch($from) { | ||
| 63 | 60 | upgrade_do31(); |
| 64 | 61 | case 31: |
| 65 | 62 | upgrade_do32(); |
| 66 | - break; | |
| 67 | 63 | case 32: |
| 68 | 64 | upgrade_do33(); |
| 69 | 65 | break; |
| @@ -76,4 +72,4 @@ switch($from) { | ||
| 76 | 72 | |
| 77 | 73 | upgrade_end("アップグレード成功"); |
| 78 | 74 | |
| 79 | -?> | |
| \ No newline at end of file | ||
| 75 | +?> |
| @@ -1,17 +1,14 @@ | ||
| 1 | 1 | <?php |
| 2 | 2 | function upgrade_do95() { |
| 3 | 3 | |
| 4 | - if (upgrade_checkinstall(95)) | |
| 5 | - return "already installed"; | |
| 4 | +$query = 'ALTER TABLE '.sql_table('blog') | |
| 5 | + . " ADD bsendping tinyint(2) NOT NULL default '0'"; | |
| 6 | +upgrade_query("Adding 'send ping' option",$query); | |
| 7 | + | |
| 8 | +$query = 'ALTER TABLE '.sql_table('blog') | |
| 9 | + . " ADD bconvertbreaks tinyint(2) NOT NULL default '1'"; | |
| 10 | +upgrade_query("Adding convert linebreaks option",$query); | |
| 6 | 11 | |
| 7 | - if(!upgrade_checkIfColumnExists('blog', 'bconvertbreaks')){ | |
| 8 | - $query = 'ALTER TABLE '.sql_table('blog') | |
| 9 | - . " ADD bsendping tinyint(2) NOT NULL default '0'," | |
| 10 | - . " ADD bconvertbreaks tinyint(2) NOT NULL default '1'"; | |
| 11 | - upgrade_query("Adding 'send ping' and convert linebreaks options",$query); | |
| 12 | - }else{ | |
| 13 | - echo "<li>Adding 'send ping' and convert linebreaks options ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 14 | - } | |
| 15 | 12 | } |
| 16 | 13 | |
| 17 | 14 | ?> |
| \ No newline at end of file |
| @@ -4,89 +4,70 @@ function upgrade_do96() { | ||
| 4 | 4 | if (upgrade_checkinstall(96)) |
| 5 | 5 | return "already installed"; |
| 6 | 6 | |
| 7 | - // 1. create nucleus_actionlog | |
| 8 | - if (!upgrade_checkIfTableExists('actionlog')) { | |
| 9 | - $query = 'CREATE TABLE '.sql_table('actionlog')." (timestamp datetime NOT NULL default '0000-00-00 00:00:00', message varchar(255) NOT NULL default '', PRIMARY KEY (timestamp)) TYPE=MyISAM;"; | |
| 10 | - upgrade_query("Creating nucleus_actionlog table",$query); | |
| 11 | - } | |
| 12 | - | |
| 13 | - // 2. create nucleus_ban | |
| 14 | - if (!upgrade_checkIfTableExists('ban')) { | |
| 15 | - $query = 'CREATE TABLE '.sql_table('ban')." ( iprange varchar(15) NOT NULL default '', reason varchar(255) NOT NULL default '', blogid int(11) NOT NULL default '0') TYPE=MyISAM;"; | |
| 16 | - upgrade_query("Creating nucleus_ban table",$query); | |
| 17 | - } | |
| 18 | - | |
| 19 | - // 3. add ikarma to nucleus_item | |
| 20 | - if (!upgrade_checkIfColumnExists('item','ikarma')) { | |
| 21 | - $query = 'ALTER TABLE '.sql_table('item') | |
| 22 | - . " ADD ikarma int(11) NOT NULL default '0'"; | |
| 23 | - upgrade_query("Adding karma-votes to items",$query); | |
| 24 | - } | |
| 25 | - | |
| 26 | - // 4. create nucleus_karma | |
| 27 | - if (!upgrade_checkIfTableExists('karma')) { | |
| 28 | - $query = 'CREATE TABLE '.sql_table('karma')." (" | |
| 29 | - ." itemid int(11) NOT NULL default '0'," | |
| 30 | - ." ip char(15) NOT NULL default ''" | |
| 31 | - .") TYPE=MyISAM;"; | |
| 32 | - upgrade_query("Creating nucleus_karma table",$query); | |
| 33 | - } | |
| 34 | - | |
| 35 | - // 5. nucleus_config: add MediaURL, AllowedTypes, AllowLoginEdit, AllowUpload | |
| 36 | - | |
| 37 | - // create MediaURL out of IndexURL | |
| 38 | - $mediaURL = $CONF['IndexURL'] . "media/"; | |
| 39 | - | |
| 40 | - if (!upgrade_checkIfCVExists('MediaURL')) { | |
| 41 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('MediaURL', '$mediaURL');"; | |
| 42 | - upgrade_query("New setting MediaURL",$query); | |
| 43 | - } | |
| 44 | - if (!upgrade_checkIfCVExists('AllowedTypes')) { | |
| 45 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');"; | |
| 46 | - upgrade_query("New setting AllowedTypes",$query); | |
| 47 | - } | |
| 48 | - if (!upgrade_checkIfCVExists('AllowLoginEdit')) { | |
| 49 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('AllowLoginEdit', '0');"; | |
| 50 | - upgrade_query("New setting AllowLoginEdit",$query); | |
| 51 | - } | |
| 52 | - if (!upgrade_checkIfCVExists('AllowUpload')) { | |
| 53 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('AllowUpload', '1');"; | |
| 54 | - upgrade_query("New setting AllowUpload",$query); | |
| 55 | - } | |
| 56 | - | |
| 57 | - //The following blocks (6 and 7) should check for existing values and only update as needed. | |
| 58 | - // 6. add 'imagepopup' skincontents in skin 'default' | |
| 59 | - | |
| 60 | - $query = 'SELECT sdnumber FROM '.sql_table('skin_desc')." WHERE sdname='default'"; | |
| 61 | - $res = sql_query($query); | |
| 62 | - $obj = mysql_fetch_object($res); | |
| 63 | - $skinid = $obj->sdnumber; | |
| 64 | - $query = 'INSERT INTO '.sql_table('skin')." VALUES (" . $skinid . ", 'imagepopup', '<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n <title><%imagetext%></title>\r\n <style type=\"text/css\">\r\n img { border: none; }\r\n </style>\r\n</head>\r\n<body>\r\n <a href=\"javascript:window.close();\"><%image%></a>\r\n</body>\r\n</html>');"; | |
| 65 | - upgrade_query("Adding 'imagepopup' skinparts",$query); | |
| 66 | - | |
| 67 | - // 7. add POPUP_CODE, MEDIA_CODE, IMAGE_CODE to ALL templates | |
| 68 | - $query = 'SELECT tdnumber FROM '.sql_table('template_desc'); | |
| 69 | - $res = sql_query($query); // get all template ids | |
| 70 | - while ($obj = mysql_fetch_object($res)) { | |
| 71 | - $tid = $obj->tdnumber; // template id | |
| 72 | - | |
| 73 | - $query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'POPUP_CODE', '<%popuplink%>');"; | |
| 74 | - $query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'MEDIA_CODE', '<%media%>');"; | |
| 75 | - $query3 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'IMAGE_CODE', '<%image%>');"; | |
| 76 | - upgrade_query("Adding popupcode to template $tid",$query); | |
| 77 | - upgrade_query("Adding mediacode to template $tid",$query2); | |
| 78 | - upgrade_query("Adding imagecode to template $tid",$query3); | |
| 79 | - | |
| 80 | - } | |
| 7 | +// 1. create nucleus_actionlog | |
| 8 | +$query = 'CREATE TABLE '.sql_table('actionlog')." (timestamp datetime NOT NULL default '0000-00-00 00:00:00', message varchar(255) NOT NULL default '', PRIMARY KEY (timestamp)) TYPE=MyISAM;"; | |
| 9 | +upgrade_query("Creating nucleus_actionlog table",$query); | |
| 10 | + | |
| 11 | +// 2. create nucleus_ban | |
| 12 | +$query = 'CREATE TABLE '.sql_table('ban')." ( iprange varchar(15) NOT NULL default '', reason varchar(255) NOT NULL default '', blogid int(11) NOT NULL default '0') TYPE=MyISAM;"; | |
| 13 | +upgrade_query("Creating nucleus_ban table",$query); | |
| 14 | + | |
| 15 | +// 4. add ikarma to nucleus_item | |
| 16 | +$query = 'ALTER TABLE '.sql_table('item') | |
| 17 | + . " ADD ikarma int(11) NOT NULL default '0'"; | |
| 18 | +upgrade_query("Adding karma-votes to items",$query); | |
| 19 | + | |
| 20 | +// 5. create nucleus_karma | |
| 21 | +$query = 'CREATE TABLE '.sql_table('karma')." (" | |
| 22 | + ." itemid int(11) NOT NULL default '0'," | |
| 23 | + ." ip char(15) NOT NULL default ''" | |
| 24 | + .") TYPE=MyISAM;"; | |
| 25 | +upgrade_query("Creating nucleus_karma table",$query); | |
| 26 | + | |
| 27 | + | |
| 28 | +// 6. nucleus_config: add MediaURL, AllowedTypes, AllowLoginEdit, AllowUpload | |
| 29 | + | |
| 30 | +// create MediaURL out of IndexURL | |
| 31 | +$mediaURL = $CONF['IndexURL'] . "media/"; | |
| 32 | + | |
| 33 | +$query = 'INSERT INTO '.sql_table('config')." VALUES ('MediaURL', '$mediaURL');"; | |
| 34 | +$query2 = 'INSERT INTO '.sql_table('config')." VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');"; | |
| 35 | +$query3 = 'INSERT INTO '.sql_table('config')." VALUES ('AllowLoginEdit', '0');"; | |
| 36 | +$query4 = 'INSERT INTO '.sql_table('config')." VALUES ('AllowUpload', '1');"; | |
| 37 | +upgrade_query("New setting MediaURL",$query); | |
| 38 | +upgrade_query("New setting AllowedTypes",$query2); | |
| 39 | +upgrade_query("New setting AllowLoginEdit",$query3); | |
| 40 | +upgrade_query("New setting AllowUpload",$query4); | |
| 41 | + | |
| 42 | +// 7. add 'imagepopup' skincontents in skin 'default' | |
| 43 | + | |
| 44 | +$query = 'SELECT sdnumber FROM '.sql_table('skin_desc')." WHERE sdname='default'"; | |
| 45 | +$res = sql_query($query); | |
| 46 | +$obj = mysql_fetch_object($res); | |
| 47 | +$skinid = $obj->sdnumber; | |
| 48 | +$query = 'INSERT INTO '.sql_table('skin')." VALUES (" . $skinid . ", 'imagepopup', '<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n <title><%imagetext%></title>\r\n <style type=\"text/css\">\r\n img { border: none; }\r\n </style>\r\n</head>\r\n<body>\r\n <a href=\"javascript:window.close();\"><%image%></a>\r\n</body>\r\n</html>');"; | |
| 49 | +upgrade_query("Adding 'imagepopup' skinparts",$query); | |
| 50 | + | |
| 51 | +// 8. add POPUP_CODE, MEDIA_CODE, IMAGE_CODE to ALL templates | |
| 52 | +$query = 'SELECT tdnumber FROM '.sql_table('template_desc'); | |
| 53 | +$res = sql_query($query); // get all template ids | |
| 54 | +while ($obj = mysql_fetch_object($res)) { | |
| 55 | + $tid = $obj->tdnumber; // template id | |
| 56 | + | |
| 57 | + $query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'POPUP_CODE', '<%popuplink%>');"; | |
| 58 | + $query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'MEDIA_CODE', '<%media%>');"; | |
| 59 | + $query3 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'IMAGE_CODE', '<%image%>');"; | |
| 60 | + upgrade_query("Adding popupcode to template $tid",$query); | |
| 61 | + upgrade_query("Adding mediacode to template $tid",$query2); | |
| 62 | + upgrade_query("Adding imagecode to template $tid",$query3); | |
| 81 | 63 | |
| 82 | - // 8. add cip to nucleus_comment | |
| 83 | - if(0==$upgrade_failures && !upgrade_checkIfColumnExists('comment', 'cip')){ | |
| 84 | - $query = 'ALTER TABLE '.sql_table('comment') | |
| 85 | - . " ADD cip varchar(15) NOT NULL default ''"; | |
| 86 | - upgrade_query("Adding IP attribute to comments",$query); | |
| 87 | - }else{ | |
| 88 | - echo "<li>Adding IP attribute to comments ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 89 | - } | |
| 64 | +} | |
| 65 | + | |
| 66 | +// 3. add cip to nucleus_comment | |
| 67 | +$query = 'ALTER TABLE '.sql_table('comment') | |
| 68 | + . " ADD cip varchar(15) NOT NULL default ''"; | |
| 69 | +upgrade_query("Adding IP attribute to comments",$query); | |
| 70 | + | |
| 90 | 71 | } |
| 91 | 72 | |
| 92 | 73 |
| @@ -1,51 +1,41 @@ | ||
| 1 | 1 | <?php |
| 2 | 2 | function upgrade_do10() { |
| 3 | 3 | |
| 4 | - if (upgrade_checkinstall(10)) | |
| 5 | - return "already installed"; | |
| 6 | - | |
| 7 | - // 1. add extra indices to tables | |
| 8 | - if (!upgrade_checkIfIndexExists('item', array('iblog', 'itime'))) { | |
| 9 | - $query = 'ALTER TABLE '.sql_table('item').' ADD INDEX(iblog, itime);'; | |
| 10 | - upgrade_query("Adding extra index to nucleus_item",$query); | |
| 11 | - } | |
| 12 | - if (!upgrade_checkIfIndexExists('comment', array('citem'))) { | |
| 13 | - $query = 'ALTER TABLE '.sql_table('comment').' ADD INDEX(citem);'; | |
| 14 | - upgrade_query("Adding extra index to nucleus_comment",$query); | |
| 15 | - } | |
| 16 | - | |
| 17 | - // 2. add DisableJsTools to config | |
| 18 | - if (!upgrade_checkIfCVExists('DisableJsTools')) { | |
| 19 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('DisableJsTools', '0');"; | |
| 20 | - upgrade_query("Adding setting DisableJsTools",$query); | |
| 21 | - } | |
| 22 | - | |
| 23 | - // 3. Drop primary key in nucleus_actionlog | |
| 24 | - $query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY;'; | |
| 25 | - upgrade_query("Dropping primary key for actionlog table",$query); | |
| 26 | - | |
| 27 | - // 4. add mcookiekey to nucleus_member | |
| 28 | - if(0==$upgrade_failures && !upgrade_checkIfColumnExists('member', 'mcookiekey')){ | |
| 29 | - $query = 'ALTER TABLE '.sql_table('member') | |
| 30 | - . " ADD mcookiekey varchar(40) "; | |
| 31 | - $res = upgrade_query("Adding cookiekey attribute to members",$query); | |
| 32 | - | |
| 33 | - // only do this when the previous query succeeds | |
| 34 | - //A more efficent query might be 'UPDATE '.sql_table('member')." SET mpassword=MD5(mpassword)" | |
| 35 | - if ($res) { | |
| 36 | - // 5. for all members: hash their password and also copy it to mcookiekey | |
| 37 | - $query = 'SELECT * FROM '.sql_table('member'); | |
| 38 | - $res = mysql_query($query); | |
| 39 | - while ($current = mysql_fetch_object($res)) { | |
| 40 | - $hashedpw = md5($current->mpassword); | |
| 41 | - $updquery = 'UPDATE '.sql_table('member')." SET mpassword='$hashedpw' WHERE mnumber=" . $current->mnumber; | |
| 42 | - upgrade_query("Encrypting password for member " . $current->mnumber,$updquery); | |
| 43 | - } | |
| 44 | - } | |
| 45 | - }else{ | |
| 46 | - echo "<li>Adding cookiekey attribute to members ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 4 | +if (upgrade_checkinstall(10)) | |
| 5 | + return "already installed"; | |
| 6 | + | |
| 7 | +// 1. add mcookiekey to nucleus_member | |
| 8 | +$query = 'ALTER TABLE '.sql_table('member') | |
| 9 | + . " ADD mcookiekey varchar(40) "; | |
| 10 | +$res = upgrade_query("Adding cookiekey attribute to members",$query); | |
| 11 | + | |
| 12 | +// only do this when the previous query succeeds | |
| 13 | +if ($res) { | |
| 14 | + // 2. for all members: hash their password and also copy it to mcookiekey | |
| 15 | + $query = 'SELECT * FROM '.sql_table('member'); | |
| 16 | + $res = mysql_query($query); | |
| 17 | + while ($current = mysql_fetch_object($res)) { | |
| 18 | + $hashedpw = md5($current->mpassword); | |
| 19 | + $updquery = 'UPDATE '.sql_table('member')." SET mpassword='$hashedpw' WHERE mnumber=" . $current->mnumber; | |
| 20 | + upgrade_query("Encrypting password for member " . $current->mnumber,$updquery); | |
| 47 | 21 | } |
| 48 | 22 | } |
| 49 | 23 | |
| 24 | +// 3. add extra indices to tables | |
| 25 | +$query = 'ALTER TABLE '.sql_table('item').' ADD INDEX(iblog, itime);'; | |
| 26 | +upgrade_query("Adding extra index to nucleus_item",$query); | |
| 27 | +$query = 'ALTER TABLE '.sql_table('comment').' ADD INDEX(citem);'; | |
| 28 | +upgrade_query("Adding extra index to nucleus_comment",$query); | |
| 29 | + | |
| 30 | +// 4. add DisableJsTools to config | |
| 31 | +$query = 'INSERT INTO '.sql_table('config')." VALUES ('DisableJsTools', '0');"; | |
| 32 | +upgrade_query("Adding setting DisableJsTools",$query); | |
| 33 | + | |
| 34 | +// 5. Drop primary key in nucleus_actionlog | |
| 35 | +$query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY;'; | |
| 36 | +upgrade_query("Dropping primary key for actionlog table",$query); | |
| 37 | + | |
| 38 | +} | |
| 39 | + | |
| 50 | 40 | |
| 51 | 41 | ?> |
| \ No newline at end of file |
| @@ -1,111 +1,89 @@ | ||
| 1 | 1 | <?php |
| 2 | 2 | function upgrade_do11() { |
| 3 | - global $upgrade_failures; | |
| 4 | 3 | |
| 5 | - if (upgrade_checkinstall(11)) | |
| 6 | - return "already installed"; | |
| 7 | - | |
| 8 | - // 1. add some options to nucleus_config | |
| 9 | - if (!upgrade_checkIfCVExists('CookiePath')) { | |
| 10 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookiePath', '/');"; | |
| 11 | - upgrade_query('CookiePath setting',$query); | |
| 12 | - } | |
| 13 | - if (!upgrade_checkIfCVExists('CookieDomain')) { | |
| 14 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookieDomain', '');"; | |
| 15 | - upgrade_query('CookieDomain setting',$query); | |
| 16 | - } | |
| 17 | - if (!upgrade_checkIfCVExists('CookieSecure')) { | |
| 18 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookieSecure', '0');"; | |
| 19 | - upgrade_query('CookieSecure setting',$query); | |
| 20 | - } | |
| 21 | - if (!upgrade_checkIfCVExists('MediaPrefix')) { | |
| 22 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('MediaPrefix', '1');"; | |
| 23 | - upgrade_query('MediaPrefix setting',$query); | |
| 24 | - } | |
| 25 | - | |
| 26 | - // 2. add language field to member table | |
| 27 | - if(!upgrade_checkIfColumnExists('member', 'deflang')){ | |
| 28 | - upgrade_query("Language setting (member)", | |
| 29 | - 'ALTER TABLE '.sql_table('member')." ADD deflang varchar(20) NOT NULL default '';"); | |
| 30 | - } | |
| 4 | +if (upgrade_checkinstall(11)) | |
| 5 | + return "already installed"; | |
| 31 | 6 | |
| 32 | - // 3. create category table and update other tables (nucleus_item and nucleus_blog) | |
| 33 | - $mark=$upgrade_failures; | |
| 34 | - if (!upgrade_checkIfTableExists('plugin')) { | |
| 35 | - $query = 'CREATE TABLE '.sql_table('category').' (' | |
| 36 | - ." catid int(11) NOT NULL auto_increment," | |
| 37 | - ." cblog int(11) NOT NULL, " | |
| 38 | - ." cname varchar(40)," | |
| 39 | - ." cdesc varchar(200)," | |
| 40 | - ." PRIMARY KEY (catid)" | |
| 41 | - .") "; | |
| 42 | - upgrade_query('New table '.sql_table('category'), $query); | |
| 43 | - } | |
| 44 | - if(!upgrade_checkIfColumnExists('item', 'icat')){ | |
| 45 | - upgrade_query("Adding category attribute to item-table", | |
| 46 | - 'ALTER TABLE '.sql_table('item').' ADD icat int(11)'); | |
| 47 | - } | |
| 48 | - if(!upgrade_checkIfColumnExists('blog', 'bdefcat')){ | |
| 49 | - upgrade_query("Adding defcat attribute to blog-table", | |
| 50 | - 'ALTER TABLE '.sql_table('blog').' ADD bdefcat int(11)'); | |
| 51 | - } | |
| 52 | - | |
| 53 | - //The following blocks should check for existing values and only update as needed. | |
| 54 | - if($mark==$upgrade_failures){ | |
| 55 | - // 4. add 'general' categories for all blogs, and update nucleus_item | |
| 56 | - $catid = 1; // generate catids ourself | |
| 57 | - $query = 'SELECT bnumber FROM '.sql_table('blog'); | |
| 58 | - $res = mysql_query($query); | |
| 59 | - while ($current = mysql_fetch_object($res)) { | |
| 60 | - $blogid = $current->bnumber; | |
| 61 | - | |
| 62 | - $query = 'INSERT INTO '.sql_table('category')." (catid, cblog, cname, cdesc) VALUES ($catid, $blogid, 'General', 'Items that do not fit in other categories')"; | |
| 63 | - $r = upgrade_query("Adding category 'general' for blog " . $blogid, $query); | |
| 64 | - | |
| 65 | - // only perform next actions when insert went ok | |
| 66 | - if ($r) { | |
| 67 | - $query = 'UPDATE '.sql_table('blog')." SET bdefcat=$catid WHERE bnumber=$blogid"; | |
| 68 | - upgrade_query("Setting the default category for blog $blogid to the 'General' category", $query); | |
| 69 | - | |
| 70 | - $query = 'UPDATE '.sql_table('item')." SET icat=$catid WHERE iblog=$blogid"; | |
| 71 | - upgrade_query("Assigning all existing items of blog $blogid to the 'General' category",$query); | |
| 72 | - } | |
| 73 | - | |
| 74 | - $catid++; | |
| 75 | - } | |
| 76 | - | |
| 77 | - // 5. add template parts for category lists to all templates | |
| 78 | - $query = 'SELECT tdnumber FROM '.sql_table('template_desc'); | |
| 79 | - $res = sql_query($query); // get all template ids | |
| 80 | - while ($obj = mysql_fetch_object($res)) { | |
| 81 | - $tid = $obj->tdnumber; // template id | |
| 82 | - | |
| 83 | - $query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_HEADER', '<ul><li><a href=\"<%blogurl%>\">All</a></li>');"; | |
| 84 | - $query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_LISTITEM', '<li><a href=\"<%catlink%>\"><%catname%></a></li>');"; | |
| 85 | - $query3 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_FOOTER', '</ul>');"; | |
| 86 | - upgrade_query("Adding categorylist header to template $tid",$query); | |
| 87 | - upgrade_query("Adding categorylist item to template $tid",$query2); | |
| 88 | - upgrade_query("Adding categorylist footer to template $tid",$query3); | |
| 89 | - | |
| 90 | - } | |
| 91 | - } | |
| 7 | +// 1. add some options to nucleus_config | |
| 8 | +$query = 'INSERT INTO '.sql_table('config')." VALUES ('CookiePath', '/');"; | |
| 9 | +upgrade_query('CookiePath setting',$query); | |
| 10 | +$query = 'INSERT INTO '.sql_table('config')." VALUES ('CookieDomain', '');"; | |
| 11 | +upgrade_query('CookieDomain setting',$query); | |
| 12 | +$query = 'INSERT INTO '.sql_table('config')." VALUES ('CookieSecure', '0');"; | |
| 13 | +upgrade_query('CookieSecure setting',$query); | |
| 14 | +$query = 'INSERT INTO '.sql_table('config')." VALUES ('MediaPrefix', '1');"; | |
| 15 | +upgrade_query('MediaPrefix setting',$query); | |
| 16 | + | |
| 17 | + | |
| 18 | +// 2. add language field to member table | |
| 19 | +upgrade_query("Language setting (member)", | |
| 20 | + 'ALTER TABLE '.sql_table('member')." ADD deflang varchar(20) NOT NULL default '';"); | |
| 21 | + | |
| 22 | +// 3. create category table and update other tables (nucleus_item and nucleus_blog) | |
| 23 | +$query = 'CREATE TABLE '.sql_table('category').' (' | |
| 24 | + ." catid int(11) NOT NULL auto_increment," | |
| 25 | + ." cblog int(11) NOT NULL, " | |
| 26 | + ." cname varchar(40)," | |
| 27 | + ." cdesc varchar(200)," | |
| 28 | + ." PRIMARY KEY (catid)" | |
| 29 | + .") "; | |
| 30 | +upgrade_query('New table '.sql_table('category'), $query); | |
| 31 | + | |
| 32 | +upgrade_query("Adding category attribute to item-table", | |
| 33 | + 'ALTER TABLE '.sql_table('item').' ADD icat int(11)'); | |
| 34 | +upgrade_query("Adding defcat attribute to blog-table", | |
| 35 | + 'ALTER TABLE '.sql_table('blog').' ADD bdefcat int(11)'); | |
| 36 | + | |
| 37 | +// 4. add 'general' categories for all blogs, and update nucleus_item | |
| 38 | +$catid = 1; // generate catids ourself | |
| 39 | +$query = 'SELECT bnumber FROM '.sql_table('blog'); | |
| 40 | +$res = mysql_query($query); | |
| 41 | +while ($current = mysql_fetch_object($res)) { | |
| 42 | + $blogid = $current->bnumber; | |
| 92 | 43 | |
| 93 | - // 6. add content type field to skins | |
| 94 | - if(!upgrade_checkIfColumnExists('skin_desc', 'sdtype')){ | |
| 95 | - $query = 'ALTER TABLE '.sql_table('skin_desc')." ADD sdtype VARCHAR(40) NOT NULL DEFAULT 'text/html'"; | |
| 96 | - upgrade_query("Adding content type field to skins (text/html)", $query); | |
| 97 | - } | |
| 44 | + $query = 'INSERT INTO '.sql_table('category')." (catid, cblog, cname, cdesc) VALUES ($catid, $blogid, 'General', 'Items that do not fit in other categories')"; | |
| 45 | + $r = upgrade_query("Adding category 'general' for blog " . $blogid, $query); | |
| 98 | 46 | |
| 99 | - // 7. try to set content type for xml-rss skin to text/xml | |
| 100 | - $query = 'UPDATE '.sql_table('skin_desc')." SET sdtype='text/xml' WHERE sdname='xmlrss'"; | |
| 101 | - upgrade_query("Setting content type for xmlrss skin to text/xml", $query); | |
| 47 | + // only perform next actions when insert went ok | |
| 48 | + if ($r) { | |
| 49 | + $query = 'UPDATE '.sql_table('blog')." SET bdefcat=$catid WHERE bnumber=$blogid"; | |
| 50 | + upgrade_query("Setting the default category for blog $blogid to the 'General' category", $query); | |
| 102 | 51 | |
| 103 | - // 8. add bnotifytype column to blog tables | |
| 104 | - if(0==$upgrade_failures && !upgrade_checkIfColumnExists('blog', 'bnotifytype')){ | |
| 105 | - upgrade_query("Adding Notify Type Setting", | |
| 106 | - 'ALTER TABLE '.sql_table('blog')." ADD bnotifytype INT(11) NOT NULL default '15';"); | |
| 107 | - }else{ | |
| 108 | - echo "<li>Adding Notify Type Setting ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 52 | + $query = 'UPDATE '.sql_table('item')." SET icat=$catid WHERE iblog=$blogid"; | |
| 53 | + upgrade_query("Assigning all existing items of blog $blogid to the 'General' category",$query); | |
| 109 | 54 | } |
| 55 | + | |
| 56 | + $catid++; | |
| 110 | 57 | } |
| 58 | + | |
| 59 | +// 5. add content type field to skins | |
| 60 | +$query = 'ALTER TABLE '.sql_table('skin_desc')." ADD sdtype VARCHAR(40) NOT NULL DEFAULT 'text/html'"; | |
| 61 | +upgrade_query("Adding content type field to skins (text/html)", $query); | |
| 62 | + | |
| 63 | +// 6. try to set content type for xml-rss skin to text/xml | |
| 64 | +$query = 'UPDATE '.sql_table('skin_desc')." SET sdtype='text/xml' WHERE sdname='xmlrss'"; | |
| 65 | +upgrade_query("Setting content type for xmlrss skin to text/xml", $query); | |
| 66 | + | |
| 67 | +// 7. add template parts for category lists to all templates | |
| 68 | +$query = 'SELECT tdnumber FROM '.sql_table('template_desc'); | |
| 69 | +$res = sql_query($query); // get all template ids | |
| 70 | +while ($obj = mysql_fetch_object($res)) { | |
| 71 | + $tid = $obj->tdnumber; // template id | |
| 72 | + | |
| 73 | + $query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_HEADER', '<ul><li><a href=\"<%blogurl%>\">All</a></li>');"; | |
| 74 | + $query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_LISTITEM', '<li><a href=\"<%catlink%>\"><%catname%></a></li>');"; | |
| 75 | + $query3 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_FOOTER', '</ul>');"; | |
| 76 | + upgrade_query("Adding categorylist header to template $tid",$query); | |
| 77 | + upgrade_query("Adding categorylist item to template $tid",$query2); | |
| 78 | + upgrade_query("Adding categorylist footer to template $tid",$query3); | |
| 79 | + | |
| 80 | +} | |
| 81 | + | |
| 82 | +// 8. add bnotifytype column to blog tables | |
| 83 | +upgrade_query("Notify Type Setting", | |
| 84 | + 'ALTER TABLE '.sql_table('blog')." ADD bnotifytype INT(11) NOT NULL default '15';"); | |
| 85 | + | |
| 86 | + | |
| 87 | +} | |
| 88 | + | |
| 111 | 89 | ?> |
| \ No newline at end of file |
| @@ -3,37 +3,32 @@ function upgrade_do15() { | ||
| 3 | 3 | |
| 4 | 4 | if (upgrade_checkinstall(15)) |
| 5 | 5 | return "already installed"; |
| 6 | - | |
| 7 | - // create nucleus_plugin_event | |
| 8 | - if (upgrade_checkIfTableExists('plugin_events')) {//present in dev version | |
| 6 | + | |
| 7 | + // first two queries are needed for people running the development version | |
| 8 | + global $nucleus; | |
| 9 | + if (strstr($nucleus['version'],'dev')) { | |
| 9 | 10 | upgrade_query('Renaming table nucleus_plugins_events','RENAME TABLE '.sql_table('plugins_events').' TO '.sql_table('plugin_event')); |
| 10 | - }elseif (!upgrade_checkIfTableExists('plugin_event')) { | |
| 11 | - $query = 'CREATE TABLE '.sql_table('plugin_event').' (pid int(11) NOT NULL, event varchar(40)) TYPE=MyISAM;'; | |
| 12 | - upgrade_query("Creating nucleus_plugin_event table",$query); | |
| 11 | + upgrade_query('Renaming table nucleus_plugins','RENAME TABLE '.sql_table('plugins').' TO '.sql_table('plugin')); | |
| 13 | 12 | } |
| 13 | + | |
| 14 | + // create nucleus_plugin_event | |
| 15 | + $query = 'CREATE TABLE '.sql_table('plugin_event').' (pid int(11) NOT NULL, event varchar(40)) TYPE=MyISAM;'; | |
| 16 | + upgrade_query("Creating nucleus_plugin_event table",$query); | |
| 14 | 17 | |
| 15 | 18 | // create nucleus_plugin |
| 16 | - if (upgrade_checkIfTableExists('plugins')) {//present in dev version | |
| 17 | - upgrade_query('Renaming table nucleus_plugins','RENAME TABLE '.sql_table('plugins').' TO '.sql_table('plugin')); | |
| 18 | - }elseif (!upgrade_checkIfTableExists('plugin')) { | |
| 19 | - $query = 'CREATE TABLE '.sql_table('plugin')." (pid int(11) NOT NULL auto_increment, pfile varchar(40) NOT NULL, porder int(11) not null, PRIMARY KEY(pid)) TYPE=MyISAM;"; | |
| 20 | - upgrade_query("Creating nucleus_plugin table",$query); | |
| 21 | - } | |
| 19 | + $query = 'CREATE TABLE '.sql_table('plugin')." (pid int(11) NOT NULL auto_increment, pfile varchar(40) NOT NULL, porder int(11) not null, PRIMARY KEY(pid)) TYPE=MyISAM;"; | |
| 20 | + upgrade_query("Creating nucleus_plugin table",$query); | |
| 22 | 21 | |
| 23 | 22 | // add MaxUploadSize to config |
| 24 | - if (!upgrade_checkIfCVExists('MaxUploadSize')) { | |
| 25 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('MaxUploadSize','1048576')"; | |
| 26 | - upgrade_query('MaxUploadSize setting',$query); | |
| 27 | - } | |
| 23 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('MaxUploadSize','1048576')"; | |
| 24 | + upgrade_query('MaxUploadSize setting',$query); | |
| 28 | 25 | |
| 29 | 26 | |
| 30 | 27 | // try to add cblog column when it does not exists yet |
| 31 | - //The logic on the old code seems off, but my replacement may not be correct either--AWB | |
| 32 | - //$query = 'SELECT * FROM '.sql_table('comment').' WHERE cblog=0 LIMIT 1'; | |
| 33 | - //$res = mysql_query($query); | |
| 34 | - //if (!$res || (mysql_num_rows($res) > 0)) { | |
| 35 | - | |
| 36 | - if(!upgrade_checkIfColumnExists('comment', 'cblog')){ | |
| 28 | + $query = 'SELECT * FROM '.sql_table('comment').' WHERE cblog=0 LIMIT 1'; | |
| 29 | + $res = mysql_query($query); | |
| 30 | + if (!$res || (mysql_num_rows($res) > 0)) { | |
| 31 | + | |
| 37 | 32 | $query = 'ALTER TABLE '.sql_table('comment')." ADD cblog int(11) NOT NULL default '0'"; |
| 38 | 33 | upgrade_query('Adding cblog column in table nucleus_comment',$query); |
| 39 | 34 |
| @@ -48,11 +43,9 @@ function upgrade_do15() { | ||
| 48 | 43 | |
| 49 | 44 | // add 'pluginURL' to config |
| 50 | 45 | global $CONF; |
| 51 | - if (!upgrade_checkIfCVExists('PluginURL')) { | |
| 52 | - $pluginURL = $CONF['AdminURL'] . "plugins/"; | |
| 53 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('PluginURL', '$pluginURL');"; | |
| 54 | - upgrade_query('PluginURL setting', $query); | |
| 55 | - } | |
| 46 | + $pluginURL = $CONF['AdminURL'] . "plugins/"; | |
| 47 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('PluginURL', '$pluginURL');"; | |
| 48 | + upgrade_query('PluginURL setting', $query); | |
| 56 | 49 | |
| 57 | 50 | // add 'EDITLINK' to all templates |
| 58 | 51 | $query = 'SELECT tdnumber FROM '.sql_table('template_desc'); |
| @@ -84,25 +77,16 @@ function upgrade_do15() { | ||
| 84 | 77 | } |
| 85 | 78 | |
| 86 | 79 | // new setting: NonmemberMail |
| 87 | - if (!upgrade_checkIfCVExists('NonmemberMail')) { | |
| 88 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('NonmemberMail', '0');"; | |
| 89 | - upgrade_query("Adding setting NonmemberMail",$query); | |
| 90 | - } | |
| 80 | + upgrade_query('NonmemberMail setting', 'INSERT INTO '.sql_table('config')." VALUES ('NonmemberMail', '0');"); | |
| 91 | 81 | |
| 92 | 82 | // new setting: ProtectMemNames |
| 93 | - if (!upgrade_checkIfCVExists('ProtectMemNames')) { | |
| 94 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('ProtectMemNames', '1');"; | |
| 95 | - upgrade_query("Adding setting ProtectMemNames",$query); | |
| 96 | - } | |
| 83 | + upgrade_query('ProtectMemNames setting', 'INSERT INTO '.sql_table('config')." VALUES ('ProtectMemNames', '1');"); | |
| 97 | 84 | |
| 98 | 85 | // create new table: nucleus_plugin_option |
| 99 | - global $upgrade_failures; | |
| 100 | - if (0==$upgrade_failures && !upgrade_checkIfTableExists('plugin_option')) { | |
| 101 | - $query = 'CREATE TABLE '.sql_table('plugin_option')." (opid int(11) NOT NULL, oname varchar(20) NOT NULL, ovalue varchar(128) not null, odesc varchar(255), otype varchar(8), PRIMARY KEY(opid, oname)) TYPE=MyISAM;"; | |
| 102 | - upgrade_query("Creating nucleus_plugin_option table",$query); | |
| 103 | - }else{ | |
| 104 | - echo "<li>Creating nucleus_plugin_option table ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 105 | - } | |
| 86 | + $query = 'CREATE TABLE '.sql_table('plugin_option')." (opid int(11) NOT NULL, oname varchar(20) NOT NULL, ovalue varchar(128) not null, odesc varchar(255), otype varchar(8), PRIMARY KEY(opid, oname)) TYPE=MyISAM;"; | |
| 87 | + upgrade_query("Creating nucleus_plugin_option table",$query); | |
| 88 | + | |
| 89 | + | |
| 106 | 90 | } |
| 107 | 91 | |
| 108 | 92 | ?> |
| \ No newline at end of file |
| @@ -7,18 +7,14 @@ function upgrade_do20() { | ||
| 7 | 7 | // queries come here |
| 8 | 8 | |
| 9 | 9 | // add ikarmaneg |
| 10 | - if (!upgrade_checkIfColumnExists('item','ikarmaneg')) { | |
| 11 | - $query = 'ALTER TABLE '.sql_table('item') | |
| 12 | - . " ADD ikarmaneg int(11) NOT NULL default '0'"; | |
| 13 | - upgrade_query("Adding ikarmaneg column to items",$query); | |
| 14 | - } | |
| 10 | + $query = 'ALTER TABLE '.sql_table('item') | |
| 11 | + . " ADD ikarmaneg int(11) NOT NULL default '0'"; | |
| 12 | + upgrade_query("Adding ikarmaneg column to items",$query); | |
| 15 | 13 | |
| 16 | 14 | // rename ikarma to ikarmapos |
| 17 | - if (!upgrade_checkIfColumnExists('item','ikarmapos')) { | |
| 18 | - $query = 'ALTER TABLE '.sql_table('item') | |
| 19 | - . " CHANGE ikarma ikarmapos int(11) NOT NULL default '0'"; | |
| 20 | - upgrade_query("Renaming ikarma column for items to ikarmapos",$query); | |
| 21 | - } | |
| 15 | + $query = 'ALTER TABLE '.sql_table('item') | |
| 16 | + . " CHANGE ikarma ikarmapos int(11) NOT NULL default '0'"; | |
| 17 | + upgrade_query("Renaming ikarma column for items to ikarmapos",$query); | |
| 22 | 18 | |
| 23 | 19 | // drop key in actionlog |
| 24 | 20 | $query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY'; |
| @@ -29,58 +25,44 @@ function upgrade_do20() { | ||
| 29 | 25 | upgrade_query("changing max email/url length of guest comments to 100",$query); |
| 30 | 26 | |
| 31 | 27 | // create default skin option |
| 32 | - if (!upgrade_checkIfCVExists('BaseSkin')) { | |
| 33 | - $skinid = SKIN::getIdFromName('default'); | |
| 34 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('BaseSkin', '$skinid');"; | |
| 35 | - upgrade_query("Adding setting BaseSkin",$query); | |
| 36 | - } | |
| 28 | + $skinid = SKIN::getIdFromName('default'); | |
| 29 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('BaseSkin', '$skinid');"; | |
| 30 | + upgrade_query("Adding setting BaseSkin",$query); | |
| 37 | 31 | |
| 38 | - global $CONF; | |
| 39 | 32 | // add SkinsURL setting |
| 40 | - if (!upgrade_checkIfCVExists('SkinsURL')) { | |
| 41 | - $skinsurl = str_replace('/media/','/skins/',$CONF['MediaURL']); | |
| 42 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('SkinsURL', '".addslashes($skinsurl)."');"; | |
| 43 | - upgrade_query("Adding setting SkinsURL",$query); | |
| 44 | - } | |
| 33 | + global $CONF; | |
| 34 | + $skinsurl = str_replace('/media/','/skins/',$CONF['MediaURL']); | |
| 35 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('SkinsURL', '".addslashes($skinsurl)."');"; | |
| 36 | + upgrade_query("Adding setting SkinsURL",$query); | |
| 45 | 37 | |
| 46 | 38 | // add ActionURL setting |
| 47 | - if (!upgrade_checkIfCVExists('ActionURL')) { | |
| 48 | - $actionurl = str_replace('/media/','/action.php',$CONF['MediaURL']); | |
| 49 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('ActionURL', '".addslashes($actionurl)."');"; | |
| 50 | - upgrade_query("Adding setting ActionURL",$query); | |
| 51 | - } | |
| 39 | + $actionurl = str_replace('/media/','/action.php',$CONF['MediaURL']); | |
| 40 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('ActionURL', '".addslashes($actionurl)."');"; | |
| 41 | + upgrade_query("Adding setting ActionURL",$query); | |
| 52 | 42 | |
| 53 | 43 | // time offset can also be decimal (for half time zones like GMT+3:30) |
| 54 | - $query = 'ALTER TABLE '.sql_table('blog')." CHANGE btimeoffset btimeoffset DECIMAL( 3, 1 ) DEFAULT '0' NOT NULL"; | |
| 55 | - upgrade_query('Changing time offset column type to decimal',$query); | |
| 44 | + upgrade_query('Changing time offset column type to decimal','ALTER TABLE '.sql_table('blog')." CHANGE btimeoffset btimeoffset DECIMAL( 3, 1 ) DEFAULT '0' NOT NULL"); | |
| 45 | + | |
| 46 | + // add sdincmode and sdincpref to skins | |
| 47 | + $query = 'ALTER TABLE '.sql_table('skin_desc') | |
| 48 | + . " ADD sdincmode varchar(10) NOT NULL default 'normal'"; | |
| 49 | + upgrade_query('Adding IncludeMode property to skins',$query); | |
| 50 | + $query = 'ALTER TABLE '.sql_table('skin_desc') | |
| 51 | + . " ADD sdincpref varchar(50) NOT NULL default ''"; | |
| 52 | + upgrade_query('Adding IncludePrefix property to skins',$query); | |
| 56 | 53 | |
| 57 | 54 | // add ballowpast option to nucleus_blog |
| 58 | - if (!upgrade_checkIfColumnExists('blog','ballowpast')) { | |
| 59 | - $query = 'ALTER TABLE '.sql_table('blog')." ADD ballowpast tinyint(2) NOT NULL default '0'"; | |
| 60 | - upgrade_query("Adding 'Allow posting to the past' option to blogs",$query); | |
| 61 | - } | |
| 55 | + $query = 'ALTER TABLE '.sql_table('blog')." ADD ballowpast tinyint(2) NOT NULL default '0'"; | |
| 56 | + upgrade_query("Adding 'Allow posting to the past' option to blogs",$query); | |
| 62 | 57 | |
| 63 | 58 | // URLMode |
| 64 | - if (!upgrade_checkIfCVExists('URLMode')) { | |
| 65 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('URLMode', 'normal');"; | |
| 66 | - upgrade_query("Adding setting URLMode",$query); | |
| 67 | - } | |
| 59 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('URLMode', 'normal');"; | |
| 60 | + upgrade_query("Adding setting URLMode",$query); | |
| 68 | 61 | |
| 69 | 62 | // add id to nucleus_plugin_option (allows for ordening) |
| 70 | - if (!upgrade_checkIfColumnExists('plugin_option','oid')) { | |
| 71 | - $query = 'ALTER TABLE '.sql_table('plugin_option').' ADD oid int(11) NOT NULL auto_increment UNIQUE '; | |
| 72 | - upgrade_query("Adding id attribute to plugin options table",$query); | |
| 73 | - } | |
| 74 | - | |
| 75 | - // add sdincmode and sdincpref to skins | |
| 76 | - global $upgrade_failures; | |
| 77 | - if (0 == $upgrade_failures && !upgrade_checkIfColumnExists('skin_desc','sdincpref')) { | |
| 78 | - $query = 'ALTER TABLE '.sql_table('skin_desc') | |
| 79 | - . " ADD sdincmode varchar(10) NOT NULL default 'normal'," | |
| 80 | - . " ADD sdincpref varchar(50) NOT NULL default ''"; | |
| 81 | - upgrade_query('Adding IncludeMode and IncludePrefix properties to skins',$query); | |
| 82 | - }else{ | |
| 83 | - echo "<li>Adding IncludeMode and IncludePrefix properties to skins ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 84 | - } | |
| 63 | + $query = 'ALTER TABLE '.sql_table('plugin_option').' ADD oid int(11) NOT NULL auto_increment UNIQUE '; | |
| 64 | + upgrade_query("Adding id attribute to plugin options table",$query); | |
| 65 | + | |
| 85 | 66 | } |
| 67 | + | |
| 86 | 68 | ?> |
| \ No newline at end of file |
| @@ -1,7 +1,5 @@ | ||
| 1 | 1 | <?php |
| 2 | 2 | function upgrade_do25() { |
| 3 | - global $upgrade_failures; | |
| 4 | - //needed as some queries depend on the success of others | |
| 5 | 3 | |
| 6 | 4 | if (upgrade_checkinstall(25)) |
| 7 | 5 | return 'already installed'; |
| @@ -11,74 +9,65 @@ function upgrade_do25() { | ||
| 11 | 9 | if (!upgrade_checkinstall(22)) { |
| 12 | 10 | // 1. create nucleus_plugin_option_desc table |
| 13 | 11 | // create new table: nucleus_plugin_option |
| 14 | - if (!upgrade_checkIfTableExists('plugin_option_desc')) { | |
| 15 | - $query = 'CREATE TABLE '. sql_table('plugin_option_desc') . ' (' | |
| 16 | - ." oid int(11) NOT NULL auto_increment UNIQUE," | |
| 17 | - ." opid int(11) NOT NULL," | |
| 18 | - ." oname varchar(20) NOT NULL," | |
| 19 | - ." ocontext varchar(20) NOT NULL," | |
| 20 | - ." odesc varchar(255)," | |
| 21 | - ." otype varchar(20)," | |
| 22 | - ." odef text," | |
| 23 | - ." oextra text," | |
| 24 | - ." PRIMARY KEY(opid, oname, ocontext)" | |
| 25 | - .") TYPE=MyISAM;"; | |
| 26 | - upgrade_query('Creating ' . sql_table('plugin_option_desc') . ' table',$query); | |
| 27 | - } | |
| 12 | + $query = 'CREATE TABLE IF NOT EXISTS '. sql_table('plugin_option_desc') . '(' | |
| 13 | + ." oid int(11) NOT NULL auto_increment UNIQUE," | |
| 14 | + ." opid int(11) NOT NULL," | |
| 15 | + ." oname varchar(20) NOT NULL," | |
| 16 | + ." ocontext varchar(20) NOT NULL," | |
| 17 | + ." odesc varchar(255)," | |
| 18 | + ." otype varchar(20)," | |
| 19 | + ." odef text," | |
| 20 | + ." oextra text," | |
| 21 | + ." PRIMARY KEY(opid, oname, ocontext)" | |
| 22 | + .") TYPE=MyISAM;"; | |
| 23 | + upgrade_query('Creating ' . sql_table('plugin_option_desc') . ' table',$query); | |
| 28 | 24 | |
| 29 | 25 | // 2. move all data from plugin_option to plugin_option_desc |
| 30 | - if (0 == $upgrade_failures){ | |
| 31 | - $query = 'DELETE FROM ' . sql_table('plugin_option_desc'); | |
| 32 | - upgrade_query('Flushing plugin option descriptions', $query); | |
| 33 | - $query = 'SELECT * FROM ' . sql_table('plugin_option') .' ORDER BY oid ASC'; | |
| 34 | - $res = sql_query($query); | |
| 35 | - $aValues = array(); | |
| 36 | - while ($o = mysql_fetch_object($res)) { | |
| 37 | - $query = 'INSERT INTO ' . sql_table('plugin_option_desc') | |
| 38 | - .' (opid, oname, ocontext, odesc, otype)' | |
| 39 | - ." VALUES (" | |
| 40 | - ."'".addslashes($o->opid)."'," | |
| 41 | - ."'".addslashes($o->oname) ."'," | |
| 42 | - ."'global'," | |
| 43 | - ."'".addslashes($o->odesc) ."'," | |
| 44 | - ."'".addslashes($o->otype) ."')"; | |
| 45 | - upgrade_query('Moving option description for '.htmlspecialchars($o->oname).' to ' . sql_table('plugin_option_desc'), $query); | |
| 46 | - | |
| 47 | - // store new id | |
| 48 | - $aValues[] = array ( | |
| 49 | - 'id' => mysql_insert_id(), | |
| 50 | - 'value' => $o->ovalue | |
| 51 | - ); | |
| 52 | - } | |
| 26 | + $query = 'SELECT * FROM ' . sql_table('plugin_option') .' ORDER BY oid ASC'; | |
| 27 | + $res = sql_query($query); | |
| 28 | + $aValues = array(); | |
| 29 | + while ($o = mysql_fetch_object($res)) { | |
| 30 | + $query = 'INSERT INTO ' . sql_table('plugin_option_desc') | |
| 31 | + .' (opid, oname, ocontext, odesc, otype)' | |
| 32 | + ." VALUES (" | |
| 33 | + ."'".addslashes($o->opid)."'," | |
| 34 | + ."'".addslashes($o->oname) ."'," | |
| 35 | + ."'global'," | |
| 36 | + ."'".addslashes($o->odesc) ."'," | |
| 37 | + ."'".addslashes($o->otype) ."')"; | |
| 38 | + upgrade_query('Moving option description for '.htmlspecialchars($o->oname).' to ' . sql_table('plugin_option_desc'), $query); | |
| 39 | + | |
| 40 | + // store new id | |
| 41 | + $aValues[] = array ( | |
| 42 | + 'id' => mysql_insert_id(), | |
| 43 | + 'value' => $o->ovalue | |
| 44 | + ); | |
| 45 | + | |
| 53 | 46 | } |
| 54 | 47 | |
| 55 | 48 | // 3. alter plugin_options table |
| 56 | - if (0 == $upgrade_failures && !upgrade_checkIfColumnExists('plugin_option','ocontextid')) { | |
| 57 | - $query = 'ALTER TABLE ' . sql_table('plugin_option') | |
| 58 | - .' DROP PRIMARY KEY,' | |
| 59 | - .' DROP KEY oid,' | |
| 60 | - .' DROP COLUMN opid,' | |
| 61 | - .' DROP COLUMN oname,' | |
| 62 | - .' DROP COLUMN odesc,' | |
| 63 | - .' DROP COLUMN otype,' | |
| 64 | - .' ADD ocontextid INT(11) NOT NULL,' | |
| 65 | - .' ADD PRIMARY KEY (oid, ocontextid)'; | |
| 66 | - upgrade_query('Altering ' . sql_table('plugin_option') . ' table', $query); | |
| 67 | - | |
| 68 | - if(0 == $upgrade_failures){ | |
| 69 | - // 4. delete from plugin_options | |
| 70 | - $query = 'DELETE FROM ' . sql_table('plugin_option'); | |
| 71 | - upgrade_query('Cleaning ' . sql_table('plugin_option'), $query); | |
| 72 | - | |
| 73 | - // 5. refill plugin_options | |
| 74 | - foreach ($aValues as $aInfo) { | |
| 75 | - $query = 'INSERT INTO ' . sql_table('plugin_option') | |
| 76 | - .' (oid, ocontextid, ovalue)' | |
| 77 | - ." VALUES (".$aInfo['id'].",'0','".addslashes($aInfo['value'])."')"; | |
| 78 | - upgrade_query('Re-filling ' . sql_table('plugin_option') . ' ('.$aInfo['id'].')', $query); | |
| 79 | - } | |
| 80 | - } | |
| 81 | - } | |
| 49 | + $query = 'ALTER TABLE ' . sql_table('plugin_option') | |
| 50 | + .' DROP PRIMARY KEY,' | |
| 51 | + .' DROP KEY oid,' | |
| 52 | + .' DROP COLUMN opid,' | |
| 53 | + .' DROP COLUMN oname,' | |
| 54 | + .' DROP COLUMN odesc,' | |
| 55 | + .' DROP COLUMN otype,' | |
| 56 | + .' ADD ocontextid INT(11) NOT NULL,' | |
| 57 | + .' ADD PRIMARY KEY (oid, ocontextid)'; | |
| 58 | + upgrade_query('Altering ' . sql_table('plugin_option') . ' table', $query); | |
| 59 | + | |
| 60 | + // 4. delete from plugin_options | |
| 61 | + $query = 'DELETE FROM ' . sql_table('plugin_option'); | |
| 62 | + upgrade_query('Cleaning ' . sql_table('plugin_option'), $query); | |
| 63 | + | |
| 64 | + // 5. refill plugin_options | |
| 65 | + foreach ($aValues as $aInfo) { | |
| 66 | + $query = 'INSERT INTO ' . sql_table('plugin_option') | |
| 67 | + .' (oid, ocontextid, ovalue)' | |
| 68 | + ." VALUES (".$aInfo['id'].",'0','".addslashes($aInfo['value'])."')"; | |
| 69 | + upgrade_query('Re-filling ' . sql_table('plugin_option') . ' ('.$aInfo['id'].')', $query); | |
| 70 | + } | |
| 82 | 71 | } |
| 83 | 72 | |
| 84 | 73 | // -------------------- 2.0 -> 2.5 -------------------- |
| @@ -106,20 +95,13 @@ function upgrade_do25() { | ||
| 106 | 95 | $query = 'ALTER TABLE ' . sql_table('plugin_option') . ' MODIFY ovalue TEXT NOT NULL default \'\''; |
| 107 | 96 | upgrade_query('Modifying plugin options column type', $query); |
| 108 | 97 | |
| 109 | - // insert External Authentication global option | |
| 110 | - if (!upgrade_checkIfCVExists('ExtAuth')) { | |
| 111 | - $query = 'INSERT INTO ' . sql_table('config') . ' (name,value) VALUES (\'ExtAuth\',\'0\')'; | |
| 112 | - upgrade_query('Adding External Authentication option to config table', $query); | |
| 113 | - } | |
| 114 | - | |
| 115 | 98 | // insert database version (allows us to do better version checking in v3.0 upgrades) |
| 116 | - // But only if no errors in upgrade | |
| 117 | - if (0 == $upgrade_failures && !upgrade_checkIfCVExists('DatabaseVersion')) { | |
| 118 | - $query = 'INSERT INTO ' . sql_table('config') . ' (name,value) VALUES (\'DatabaseVersion\',\'250\')'; | |
| 119 | - upgrade_query('Adding DatabaseVersion to config table', $query); | |
| 120 | - }else{ | |
| 121 | - echo "<li>Adding DatabaseVersion to config table ... <span class=\"warning\">NOT EXECUTED</span>\n<blockquote>Errors occurred during upgrade process.</blockquote>"; | |
| 122 | - } | |
| 99 | + $query = 'INSERT INTO ' . sql_table('config') . ' (name,value) VALUES (\'DatabaseVersion\',\'250\')'; | |
| 100 | + upgrade_query('Adding DatabaseVersion to config table', $query); | |
| 101 | + | |
| 102 | + // insert External Authentication global option | |
| 103 | + $query = 'INSERT INTO ' . sql_table('config') . ' (name,value) VALUES (\'ExtAuth\',\'0\')'; | |
| 104 | + upgrade_query('Adding External Authentication option to config table', $query); | |
| 123 | 105 | } |
| 124 | 106 | |
| 125 | -?> | |
| \ No newline at end of file | ||
| 107 | +?> |
| @@ -6,8 +6,10 @@ function upgrade_do30() { | ||
| 6 | 6 | |
| 7 | 7 | // 2.5(beta/RC/...) -> 3.0 |
| 8 | 8 | // update database version |
| 9 | - update_version('300'); | |
| 9 | + $query = 'UPDATE ' . sql_table('config') . ' set value=\'300\' where name=\'DatabaseVersion\''; | |
| 10 | + upgrade_query('Updating DatabaseVersion in config table to 300', $query); | |
| 11 | + | |
| 10 | 12 | // nothing! |
| 11 | 13 | } |
| 12 | 14 | |
| 13 | -?> | |
| \ No newline at end of file | ||
| 15 | +?> |
| @@ -6,8 +6,10 @@ function upgrade_do31() { | ||
| 6 | 6 | |
| 7 | 7 | // 3.0 -> 3.1 |
| 8 | 8 | // update database version |
| 9 | - update_version('310'); | |
| 9 | + $query = 'UPDATE ' . sql_table('config') . ' set value=\'310\' where name=\'DatabaseVersion\''; | |
| 10 | + upgrade_query('Updating DatabaseVersion in config table to 310', $query); | |
| 11 | + | |
| 10 | 12 | // nothing! |
| 11 | 13 | } |
| 12 | 14 | |
| 13 | -?> | |
| \ No newline at end of file | ||
| 15 | +?> |
| @@ -4,41 +4,53 @@ function upgrade_do32() { | ||
| 4 | 4 | if (upgrade_checkinstall(32)) |
| 5 | 5 | return 'already installed'; |
| 6 | 6 | |
| 7 | - // create nucleus_activation table | |
| 8 | - if (!upgrade_checkIfTableExists('tickets')) { | |
| 9 | - $query = 'CREATE TABLE ' . sql_table('activation') . ' (' | |
| 10 | - . ' vkey varchar(40) NOT NULL default \'\',' | |
| 11 | - . ' vtime datetime NOT NULL default \'0000-00-00 00:00:00\',' | |
| 12 | - . ' vmember int(11) NOT NULL default \'0\',' | |
| 13 | - . ' vtype varchar(15) NOT NULL default \'\',' | |
| 14 | - . ' vextra varchar(128) NOT NULL default \'\',' | |
| 15 | - . ' PRIMARY KEY (vkey) ' | |
| 16 | - . ' )'; | |
| 17 | - upgrade_query('Creating account activation table', $query); | |
| 18 | - } | |
| 19 | - | |
| 20 | - // create CookiePrefix setting | |
| 21 | - if (!upgrade_checkIfCVExists('CookiePrefix')) { | |
| 22 | - $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookiePrefix','')"; | |
| 23 | - upgrade_query('Creating CookiePrefix config value',$query); | |
| 7 | + // The version number of 3.20 and 3.21 are wrong, | |
| 8 | + // so this upgrade function will be called. | |
| 9 | + // But database already exists, should update db version only. | |
| 10 | + $query = 'SELECT * FROM ' . sql_table('activation'); | |
| 11 | + $res = mysql_query($query); | |
| 12 | + $installed = ($res != 0) && (mysql_num_rows($res) >= 0); | |
| 13 | + if ($installed) | |
| 14 | + { | |
| 15 | + // 3.1 -> 3.1+ | |
| 16 | + // update database version | |
| 17 | + $query = 'UPDATE ' . sql_table('config') . ' set value=\'323\' where name=\'DatabaseVersion\''; | |
| 18 | + upgrade_query('Updating DatabaseVersion in config table to 323', $query); | |
| 19 | + | |
| 20 | + return; | |
| 24 | 21 | } |
| 25 | 22 | |
| 23 | + | |
| 24 | + // create nucleus_activation table | |
| 25 | + $query = 'CREATE TABLE ' . sql_table('activation') . ' (' | |
| 26 | + . ' vkey varchar(40) NOT NULL default \'\',' | |
| 27 | + . ' vtime datetime NOT NULL default \'0000-00-00 00:00:00\',' | |
| 28 | + . ' vmember int(11) NOT NULL default \'0\',' | |
| 29 | + . ' vtype varchar(15) NOT NULL default \'\',' | |
| 30 | + . ' vextra varchar(128) NOT NULL default \'\',' | |
| 31 | + . ' PRIMARY KEY (vkey) ' | |
| 32 | + . ' )'; | |
| 33 | + upgrade_query('Creating account activation table', $query); | |
| 34 | + | |
| 35 | + // create CookiePrefix setting | |
| 36 | + $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookiePrefix','')"; | |
| 37 | + upgrade_query('Creating CookiePrefix config value',$query); | |
| 38 | + | |
| 26 | 39 | // create nucleus_tickets table |
| 27 | - if (!upgrade_checkIfTableExists('tickets')) { | |
| 28 | - $query = 'CREATE TABLE ' . sql_table('tickets') . ' (' | |
| 29 | - . ' ticket varchar(40) NOT NULL default \'\',' | |
| 30 | - . ' ctime datetime NOT NULL default \'0000-00-00 00:00:00\',' | |
| 31 | - . ' member int(11) NOT NULL default \'0\', ' | |
| 32 | - . ' PRIMARY KEY (ticket, member) ' | |
| 33 | - . ' )'; | |
| 34 | - upgrade_query('Creating ticket table', $query); | |
| 35 | - } | |
| 36 | - | |
| 37 | - // 3.1 -> 3.2 | |
| 40 | + $query = 'CREATE TABLE ' . sql_table('tickets') . ' (' | |
| 41 | + . ' ticket varchar(40) NOT NULL default \'\',' | |
| 42 | + . ' ctime datetime NOT NULL default \'0000-00-00 00:00:00\',' | |
| 43 | + . ' member int(11) NOT NULL default \'0\', ' | |
| 44 | + . ' PRIMARY KEY (ticket, member) ' | |
| 45 | + . ' )'; | |
| 46 | + upgrade_query('Creating ticket table', $query); | |
| 47 | + | |
| 48 | + // 3.1 -> 3.1+ | |
| 38 | 49 | // update database version |
| 39 | - update_version('320'); | |
| 50 | + $query = 'UPDATE ' . sql_table('config') . ' set value=\'323\' where name=\'DatabaseVersion\''; | |
| 51 | + upgrade_query('Updating DatabaseVersion in config table to 323', $query); | |
| 40 | 52 | |
| 41 | 53 | // nothing! |
| 42 | 54 | } |
| 43 | 55 | |
| 44 | -?> | |
| \ No newline at end of file | ||
| 56 | +?> |
| @@ -4,31 +4,55 @@ function upgrade_do33() { | ||
| 4 | 4 | if (upgrade_checkinstall(33)) |
| 5 | 5 | return 'already installed'; |
| 6 | 6 | |
| 7 | - if (!upgrade_checkIfColumnExists('comment','cemail')) { | |
| 8 | - $query = " ALTER TABLE `" . sql_table('comment') . "` | |
| 9 | - ADD `cemail` VARCHAR( 100 ) AFTER `cmail` ;"; | |
| 10 | - | |
| 11 | - upgrade_query('Altering ' . sql_table('comment') . ' table', $query); | |
| 7 | + // alter nucleus_blog table | |
| 8 | + $query = 'ALTER TABLE ' . sql_table('blog') | |
| 9 | + . ' ADD breqemail TINYINT(2) DEFAULT \'0\' NOT NULL'; | |
| 10 | + upgrade_query('Altering ' . sql_table('blog') . ' table', $query); | |
| 11 | + | |
| 12 | + // insert breqemail default value | |
| 13 | + $query = 'UPDATE ' . sql_table('blog') | |
| 14 | + . ' SET breqemail=0'; | |
| 15 | + upgrade_query('Filling breqemail column of ' . sql_table('blog') . ' table', $query); | |
| 16 | + | |
| 17 | + // store cname from nucleus_category | |
| 18 | + $query = 'SELECT catid, cname FROM ' . sql_table('category') . ' ORDER By catid ASC'; | |
| 19 | + $res = sql_query($query); | |
| 20 | + $aValues = array(); | |
| 21 | + while ($o = mysql_fetch_object($res)) { | |
| 22 | + $aValues[] = array( | |
| 23 | + 'catid' => $o->catid, | |
| 24 | + 'cname' => $o->cname | |
| 25 | + ); | |
| 12 | 26 | } |
| 13 | 27 | |
| 14 | - if (!upgrade_checkIfColumnExists('blog','breqemail')) { | |
| 15 | - $query = " ALTER TABLE `" . sql_table('blog') . "` | |
| 16 | - ADD `breqemail` TINYINT( 2 ) DEFAULT '0' NOT NULL ;"; | |
| 17 | - | |
| 18 | - upgrade_query('Altering ' . sql_table('blog') . ' table', $query); | |
| 28 | + // alter nucleus_category | |
| 29 | + $query = 'ALTER TABLE ' . sql_table('category') | |
| 30 | + . ' DROP COLUMN cname,' | |
| 31 | + . ' ADD cname varchar(200) default NULL AFTER cblog'; | |
| 32 | + upgrade_query('Altering ' . sql_table('category') . ' table', $query); | |
| 33 | + | |
| 34 | + // refill cname to nucleus_category | |
| 35 | + foreach ($aValues as $aInfo) { | |
| 36 | + $query = 'UPDATE ' . sql_table('category') | |
| 37 | + . ' SET cname=' | |
| 38 | + . " '" . addslashes($aInfo['cname']) . "'" | |
| 39 | + . " WHERE catid=" . $aInfo['catid']; | |
| 40 | + upgrade_query('Re-filling ' . sql_table('category') | |
| 41 | + . ' (' . $aInfo['catid'] . ')', $query); | |
| 19 | 42 | } |
| 20 | 43 | |
| 21 | - // check cmail column to separate to URL and cemail | |
| 22 | - mysql_query( | |
| 23 | - 'UPDATE ' . sql_table('comment') . ' ' . | |
| 24 | - "SET cemail = cmail, cmail = '' " . | |
| 25 | - "WHERE cmail LIKE '%@%'" | |
| 26 | - ); | |
| 27 | - | |
| 28 | - // 3.2 -> 3.3 | |
| 29 | - // update database version | |
| 30 | - update_version('330'); | |
| 31 | - | |
| 44 | + // alter nucleus_comment | |
| 45 | + $query = 'ALTER TABLE ' . sql_table('comment') | |
| 46 | + . ' ADD cemail varchar(100)' | |
| 47 | + . ' AFTER cmail'; | |
| 48 | + upgrade_query('Altering ' . sql_table('comment') . ' table', $query); | |
| 49 | + | |
| 50 | + // 3.2 -> 3.2+ | |
| 51 | + // update database version | |
| 52 | + $query = 'UPDATE ' . sql_table('config') . ' set value=\'330\' where name=\'DatabaseVersion\''; | |
| 53 | + upgrade_query('Updating DatabaseVersion in config table to 330', $query); | |
| 54 | + | |
| 55 | + // nothing! | |
| 32 | 56 | } |
| 33 | 57 | |
| 34 | 58 | ?> |
Fork