×
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
    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 field,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");
      +
      +
    [[User:mutante|mutante]] 23:15, 5 Mar 2005 (CET)
       
     
    <pre>
     
    <pre>

    Revision as of 22:15, 5 March 2005

    Description of the "recentchanges" table in "wikidb".

    For Zakx. Thank you, mutante 23:11, 5 Mar 2005 (CET)

    You dont need all those field,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;
    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
    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.