×
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 22:17, 5 March 2005 by imported>mutante

    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");
    

    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.