×
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

    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.