Monster Oasis
覺得累就是進步的開始!

2010/09/03

把 wordpress blog 立即變成 mobile friendly 的套件

Filed under: Article or News,Programming/php,Software — Tags: — 11:50 am

阿毛介紹的: http://mobilepress.co.za/

裝好後它會偵測 user 的 user agent 若是 mobile 就會把頁面換成 ‘手機’ 版.

Related URL:
  1. wordpress 的 schema
  2. 裝了一個訪客計數器 ( Visitors Tracking & Statistics Tool ) ( blog / wordpress )
  3. 裝了 SyntaxHighlighter Plus , 程式碼可以看清楚了

2009/06/30

wordpress 的 schema

Filed under: DATABASE,Programming/php — Tags: , — 4:35 pm

ver 2.7:

wp_2.7

幾個查詢例:

SELECT m.* FROM  wp_posts  p , wp_postmeta m
where p.id=m.post_id
order by post_id desc

SELECT tr.*
FROM  wp_posts  p , wp_term_relationships tr
where p.id=tr.object_id
order by p.id desc

SELECT p.id , w.*
FROM  wp_posts  p , wp_term_relationships tr , wp_term_taxonomy t
where p.id=tr.object_id
and tr.term_taxonomy_id=t.term_taxonomy_id
order by p.id desc

SELECT p.id , w.*
FROM  wp_posts  p , wp_term_relationships tr , wp_term_taxonomy t ,  wp_terms w
where p.id=tr.object_id
and tr.term_taxonomy_id=t.term_taxonomy_id
and t.term_id = w.term_id
order by p.id desc
Related URL:
  1. install oracle 11g steps
  2. 一些 memcache 的資料
  3. Protected: Oracle down time / problem records / 經典
  4. Database administrator
  5. 在 gentoo 裝 oracle sqlplus package
  6. Graphical Database Schema Metadata Browser – SchemaSpy
  7. Oracle documentation library
  8. MySQL – Optimizing Database Structure
  9. Protected: 規格表 schema
  10. mysql index 的建立/使用 , Multiple-Column Indexes

2009/04/12

裝了一個訪客計數器 ( Visitors Tracking & Statistics Tool ) ( blog / wordpress )

Filed under: Software — Tags: , — 8:53 pm

還不錯, 網址: http://www.wpwp.org/

1c90f11ca98408e9c4f7bf9ebb1b82f8

2008/07/19

裝了 SyntaxHighlighter Plus , 程式碼可以看清楚了

Filed under: Programming/javascript,Programming/php,Software — Tags: , — 5:14 pm

SyntaxHighlighter Plus

It supports the following languages (the alias for use in the post is listed next to the name):

* Bash — bash, sh
* C++ — cpp, c, c++
* C# — c#, c-sharp, csharp
* CSS — css
* Delphi — delphi, pascal
* Java — java
* JavaScript — js, jscript, javascript
* PHP — php
* Python — py, python
* Ruby — rb, ruby, rails, ror
* SQL — sql
* VB — vb, vb.net

* XML/HTML — xml, html, xhtml, xslt

修改 … /wp-content/plugins/syntaxhighlighter-plus/shlfiles/SyntaxHighlighter.css
把 .dp-highlighter 的 width 改成想要的寬度

[code language=C]
#include
main() {
printf("Hello World!");
}

[/code]

Related URL:
  1. Protected: Some Simple C Programs – 好用的 C 範例程式/片段
  2. 最簡單的最好 – 用 pre 的 CSS style

www.monster.com.tw , © Copyright 2008