Announcement

Collapse
No announcement yet.

Mysql Data to .txt file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql Data to .txt file

    Good day,

    I am wanting to perform a mysql query (or two or three ) and have it passed to a .txt file which can be opened or downloaded by a user, just like what happens with the Download PM's as a TXT file function. Anyone know of a quick and easy way to do this?
    sigpic
    Nation of Blue - Kentucky Wildcats Sports


    Some CMS Goodness: Add Avatar to Article

  • #2
    There is no standard function for this and it would require changing code. My advise is that you ask this at vbulletin.org.

    You could also generate a serverside textfile with the following SQL-statement:
    Code:
    SELECT * 
    INTO OUTFILE '/tmp/result.text'
    FIELDS TERMINATED BY ',' 
    ENCLOSED BY '"'
    LINES TERMINATED BY '\r\n'
    FROM table;
    Then let the client download that file.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X