×
Create a new article
Write your page title here:
We currently have 3,185 articles on s23. Type your article name above or create one of the articles listed here!



    s23
    3,185Articles

    Mediawiki/RecentChanges

    < Mediawiki
    Revision as of 16:14, 30 October 2005 by imported>mutante
    (diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

    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)
    
    
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.