User Tools

Site Tools


wordpress

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
wordpress [2009/08/06 12:00] suapapawordpress [2013/08/03 05:04] (current) – external edit 127.0.0.1
Line 8: Line 8:
 DELETE FROM wp_posts WHERE post_type = "revision"; DELETE FROM wp_posts WHERE post_type = "revision";
 </code> </code>
 +  *[[http://luv4.us/archives/1626|WP 자동저장/리비전 기능 조절하기]]
 <code python> <code python>
 mport MySQLdb mport MySQLdb
  
-db = MySQLdb.connect(db='suapapa_blog', user='blog_admin', passwd='enakflxhRl', host='localhost')+db = MySQLdb.connect(db='suapapa_blog', user='blog_admin', passwd='******', host='localhost')
 c = db.cursor() c = db.cursor()
 c.execute('DELETE FROM wp_posts WHERE post_type = "revision"') c.execute('DELETE FROM wp_posts WHERE post_type = "revision"')
Line 32: Line 33:
  
 db.commit() db.commit()
- 
- 
-</code> 
- 
-<code mysql> 
-mysql> desc wp_postmeta; 
-+------------+--------------+------+-----+---------+----------------+ 
-| Field      | Type         | Null | Key | Default | Extra          | 
-+------------+--------------+------+-----+---------+----------------+ 
-| meta_id    | bigint(20)   | NO   | PRI | NULL    | auto_increment | 
-| post_id    | bigint(20)   | NO   | MUL | 0                      | 
-| meta_key   | varchar(255) | YES  | MUL | NULL    |                | 
-| meta_value | longtext     | YES  |     | NULL    |                | 
-+------------+--------------+------+-----+---------+----------------+ 
-4 rows in set (0.00 sec) 
 </code> </code>
  
-======== wp_multilingual ======+====== 다국어 지원 ====== 
 +  *[[http://wordpress.org/extend/plugins/tags/multilingual|다국어지원 플러그인들]] 
 +===== wp_multilingual =====
 저장된 번역은 다음과 같이 쌍으로 존재함. 저장된 번역은 다음과 같이 쌍으로 존재함.
 <code mysql> <code mysql>
Line 56: Line 44:
 |    1339 |     421 | searchsyn           | |    1339 |     421 | searchsyn           |
 </code> </code>
 +/home/suapapa/wp-content/plugins/wp-multilingual/multilingual.php
 <code php> <code php>
 +$str = serialize(array(base64_encode(serialize(unserialize(serialize($translation))))));
 +...
 $GLOBALS['wpdb']->query( $GLOBALS['wpdb']->query(
 "INSERT INTO ".$GLOBALS['table_prefix']. "INSERT INTO ".$GLOBALS['table_prefix'].
Line 71: Line 62:
 $translations = unserialize(base64_decode($translations[0])); $translations = unserialize(base64_decode($translations[0]));
 </code> </code>
 +====== themes ======
 +  *[[http://getk2.com/|K2]]
 +====== references ======
 +  *[[http://codex.wordpress.org/Database_Description|WP Database Description]]
wordpress.1249560042.txt.gz · Last modified: 2013/08/03 05:04 (external edit)