×
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

    Difference between revisions of "Mediawiki/RecentChanges"

    imported>mutante
    m
     
    imported>mutante
    m
     
    (5 intermediate revisions by the same user not shown)
    Line 1: Line 1:
     
    Description of the "recentchanges" table in "wikidb".
     
    Description of the "recentchanges" table in "wikidb".
       
    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)
    
    
    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.