imported>mutante m |
imported>mutante m |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
For [[User:Zakx|Zakx]]. Thank you, [[User:mutante|mutante]] 23:11, 5 Mar 2005 (CET) |
For [[User:Zakx|Zakx]]. Thank you, [[User:mutante|mutante]] 23:11, 5 Mar 2005 (CET) |
||
| + | |||
| + | You dont need all those fields though,Zakx. |
||
| + | Also see: [[Custom_Recent_Changes]] , the query used there goes like: |
||
| + | |||
| + | $res = mysql_query("SELECT rc_id,rc_timestamp,rc_title,rc_comment,rc_user_text FROM recentchanges WHERE rc_title LIKE \"$input%\" ORDER by rc_timestamp desc", $hd) or die ("Unable to run query"); |
||
| + | |||
| + | In a default [[Mediawiki]] installation the db name is "wikidb" and the user is "wikiuser". |
||
| + | Only password would need to be configurable of course. |
||
| + | |||
| + | [[User:mutante|mutante]] 23:15, 5 Mar 2005 (CET) |
||
<pre> |
<pre> |
||
mysql> use wikidb; |
mysql> use wikidb; |
||
| − | Reading table information for completion of table and column names |
||
| − | You can turn off this feature to get a quicker startup with -A |
||
Database changed |
Database changed |
||
| Line 58: | Line 66: | ||
</pre> |
</pre> |
||
| + | |||
| + | [[Category:Internal]] |
||
| + | [[Category:Wiki]] |
||
| + | |||
| + | [[Category:Mediawiki]] |
||
Latest revision as of 16:14, 30 October 2005
Description of the "recentchanges" table in "wikidb".
For Zakx. Thank you, mutante 23:11, 5 Mar 2005 (CET)
You dont need all those fields though,Zakx. Also see: Custom_Recent_Changes , the query used there goes like:
$res = mysql_query("SELECT rc_id,rc_timestamp,rc_title,rc_comment,rc_user_text FROM recentchanges WHERE rc_title LIKE \"$input%\" ORDER by rc_timestamp desc", $hd) or die ("Unable to run query");
In a default Mediawiki installation the db name is "wikidb" and the user is "wikiuser". Only password would need to be configurable of course.
mutante 23:15, 5 Mar 2005 (CET)
mysql> use wikidb; Database changed mysql> describe recentchanges; +-------------------+---------------------+------+-----+---------+-------------- --+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+-------------- --+ | rc_timestamp | varchar(14) binary | | MUL | | | | rc_cur_time | varchar(14) binary | | | | | | rc_user | int(10) unsigned | | | 0 | | | rc_user_text | varchar(255) binary | | | | | | rc_namespace | tinyint(3) unsigned | | MUL | 0 | | | rc_title | varchar(255) binary | | | | | | rc_comment | varchar(255) binary | | | | | | rc_minor | tinyint(3) unsigned | | | 0 | | | rc_bot | tinyint(3) unsigned | | | 0 | | | rc_new | tinyint(3) unsigned | | MUL | 0 | | | rc_cur_id | int(10) unsigned | | MUL | 0 | | | rc_this_oldid | int(10) unsigned | | | 0 | | | rc_last_oldid | int(10) unsigned | | | 0 | | | rc_type | tinyint(3) unsigned | | | 0 | | | rc_moved_to_ns | tinyint(3) unsigned | | | 0 | | | rc_moved_to_title | varchar(255) binary | | | | | | rc_ip | varchar(15) | | MUL | | | | rc_id | int(8) | | PRI | NULL | auto_incremen t | +-------------------+---------------------+------+-----+---------+-------------- --+ 18 rows in set (0.03 sec)