Joomler!.net - Decided on Joomla!

Wiki or Wordpress? No it is JContentPlus.

Pickup! Component

Components Jboard(仮称)・・・作成中

by Joomler! Wednesday, 03 June 2009
Jboard(仮称)・・・作成中 というか、かなり出来上がってきた。 Jboard (現在のフォーラムのデータをマイグレーションしたもの) 一見、ほぼFireboardのように見える。というかまんまだが、デザインは好きなのでこうなった。 Fireboard(Kunena)と何が違うか(一部予定)(予定は未...

Pickup! Module

Modules Google シリーズのLoading画像

by Joomler! Monday, 10 September 2007
Google シリーズのLoading画像 Google関連モジュールのLoading画像はいつも、 Ajaxload - Ajax loading gif generator ここで作成しています。  便利・簡単!ここで作成して"images/stories"へアップロード。  そして、"Loading..."欄へ書き込めばOK。

Pickup! Plugin

Plugins jQueryでLightBox

by Joomler! Monday, 19 November 2007
jQueryでLightBox jQueryでLightBoxみたいな表示ができるプラグインがありますが、それをもじってひねっている最中です。そんな中AptanaがAptana Studioになったものを使っているのですが、良くなっていて使いやすい。まだ、すべての機能を使っているわけではないので不明部分も多々ありま...

Skypeしませんか?

もし、オンラインなら是非声をかけて下さい。
※マイクが使えない時もあります

最初は、チャットから!
Skype Me!

Latestnews

MultiBox MultiBox plugin for Joomla!3.x

by Joomler! Monday, 06 May 2013
MultiBox plugin for Joomla!3.x Easily popup from the link!! jQuery plugin from mootools multibox     Features(differenc...

Joomla! CMS Configure ScribeFire for XMLRPC New!!

by Joomler! Friday, 27 April 2012
Configure ScribeFire for XMLRPC New!! ScribeFire on XMLRPC for Joomla! (XMLRPC version 1.8 or higher) It seems that it is required two steps in order to...

Joomla! CMS How to configure “ScribeFire”

by Joomler! Thursday, 01 December 2011
How to configure “ScribeFire” Blogging with “XMLRPC for Joomla!” and “ScribeFire” Add account Your blog’s URL Checking s...

JContent+ (JContentPlus) 3つのExtensionをUpdateしました

by Joomler! Saturday, 26 December 2009
3つのExtensionをUpdateしました JContentPlus 1.5.8 Trackbackの不具合対応 Latestモジュール、Relatedモジュール、mostreadモジュールに選択されたユーザがある場合、そのユーザの記事を表示するオプションを追加しまし...

Others Ubuntu機炎上

by Joomler! Friday, 25 December 2009
Ubuntu機炎上 昨日、UbuntuからXPにと書いたことが悪かったのか、サーバーマシンから煙が・・・。ひぇぇぇぇぇ。 ハードディスクを認識したりしなかったりと、この間から調子が悪くて、今回もPCのケースを開けてATAのケーブルを変更したりしていました。何...
Written by:Joomler! 18562 hits Friday, 19 April 2013 15:34

XMLRPC for Joomla!2.5.x and 3.x version 2.0.3 released.

Fix

  • Plugin trigger
  • Clean cache

How to install or update

  • Normal install
 
Written by:Joomler! 7103 hits Saturday, 06 April 2013 10:29

滅多に無いが、たまたまJoomla2.5のslowログがあった。メインサイト(私のサイトでは無い)では無いので少ないのは当然だが、そのクエリがやけに長いものだったので気になった。以下のようなクエリ

SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END AS modified, a.modified_by, uam.name AS modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id IS NOT NULL THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id AS contactid,parent.title AS parent_title, parent.id AS parent_id, parent.path AS parent_route, parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count AS rating_count,c.published, CASE WHEN badcats.id IS NULL THEN c.published ELSE 0 END AS parents_published
FROM jos_content AS a
LEFT JOIN jos_categories AS c ON c.id = a.catid
LEFT JOIN jos_users AS ua ON ua.id = a.created_by
LEFT JOIN jos_users AS uam ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jos_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN jos_categories AS parent ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id AS id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id
WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-04-05 14:51:16') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-04-05 14:51:16')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY   CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC LIMIT 0, 4;

整形せず、ログのままだがこれでは見づらい。最近は、複雑なクエリを書くことが多く、いつも使っているエディタではなかなか整形してくれなくて困っていた。検索してみると良さそうなJavascriptで作られた整形アプリがあったのでサイト上にアップしてみた。(設置している間は、ブックマークして使ってもらってかまわない。)

http://www.joomler.net/dmlbreaker/

 
8 / 50

JContentPlus for Joomla!1.5 powered by Joomler!.net

Latest Extensions

Joomla!2.5 Template Selector version 1.8.4 released!

by Joomler! Thursday, 26 June 2014
Template Selector version 1.8.4 released! Template Selector version 1.8.4 released! Fix bug It works on pages other than a top page by Chrome or other browsers. Thanks.   まだ足りなかったようだ。検証不足ですねぇ。 さてさて、次の準...

Joomla!2.5 Template Selector version 1.8.3 released!

by Joomler! Monday, 24 March 2014
Template Selector version 1.8.3 released! Template Selector 1.8.3 released!! Features It changed so that each path might be specified. Please see demo. http://demo3.joomler.net/ for Joomla 3.2 http://demo16.joomle...

Joomla!3.x Two factor authentication Extend

by Joomler! Tuesday, 12 November 2013
Two factor authentication Extend Two factor authentication Extend released. Featured This plugin simplifies Two factor authetication. This plugin can make two factor authetication skip by carrying out the check of O...

Joomla!2.5 XMLRPC for Joomla!2.5 and 3.1.x Updated!! v2.0.7

by Joomler! Friday, 31 May 2013
XMLRPC for Joomla!2.5 and 3.1.x Updated!! v2.0.7 XMLRPC for Joomla!2.5.x version 2.0.7 released. Changes Move service from controller to view Some changes within it for BLOGSY for iPad XMLRPC endpoint SEF: http://yoursi...

Joomla!3.x XMLRPC for Joomla3.x supported Tags

by Joomler! Thursday, 30 May 2013
XMLRPC for Joomla3.x supported Tags XMLRPC for Joomla!3.x version 2.0.6 released. New feature Support Tags * Note: Tag has the same meaning as a meta-keyword. If Tag is added, it will be added also to a meta-keyword...

JContentPlus Search

Donate


Login

JBoard Latest Posts

Re:Error opening articles
Avatar Ondrej Vysek 2017/09/01 05:51
As the quotes were removed from the post, here is the log file
Template Selector for Joomla! do you still support it?
Avatar ptrou 2017/04/07 04:11
Hi, Do you still support it? After selecting a template and press switch it change the cookie, ...
Windows Live Writer 2012 + Joomla v3 Problems
Avatar St Declans National School 2016/02/09 04:50
Hi Folks, We have been using the XMLRPC plug-in (pkg-xmlrpc-joomla-2-0-7-for3-1-x.tar.gz) for ...
Live Writer Error
Avatar ts 2016/01/14 18:51
Hello, since January 13th Windows Live Writer is not working with our Joomla 3.3 installation ...
Re:Template Selector - Problems with Joomla 3.3.6 Version
Avatar Chris Snowdon 2015/07/22 05:27
I am on Joomla 3.4.3 and I have the same issue. The module displays OK and the list of templates ...

JBoard Popular Posts

Fireboardについて・・・
Avatar 吉原清一 2007/12/05 00:07
突然の投稿、失礼いたします。 いつもJoomla情報が豊富で役立つJoomlerさんのサイトを見て、勉強させていただいております。ありがとうございます。 素晴らしいCSM,Jooml...
Google翻訳ツールいいですね~
Avatar 吉原清一 2008/03/27 17:53
お疲れ様です^_^ リリースされてたのに気づいたので、 Google翻訳ツール導入してみました!かなりいい感じですね~…。 海外からのお客さんも、これとサイト全文翻訳つければ グロー...
Google Docs to Joomla 1.0.x with XML-RPC
Avatar Michael Smith 2008/05/14 05:38
Hi. I am trying to post content to my Joomla 1.0.15 site using Google Docs and its support for t...
Joomla全般の雑談
Avatar 吉原清一 2008/02/12 17:54
Joomlaに関する雑談スレッドです http://joomlaeasy.net/multithumb-for-joomla-15.html Joomla Easy.netさんの先日の記...
サイトデザインリニューアルおめでとう&お疲れさまです
Avatar 吉原清一 2008/05/13 08:31
お久しぶりです~。ようやくJoomla1.5.3にアップデートできました サイトがいつの間にかカッコヨクなってますね^_^ AjaxVoteがついてて、あれっ、これもう出たんだっ?と思っ...
joomler.net is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla!(R) name is used under a limited license from Open Source Matters in the United States and other countries.
joomler.net is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.