Ques/Help Getting the actual attachment url through a sql query?

[Mave]

I'm grabbing my posts through a sql query, however pictures (that are attachments) result in:

Code:

[ATTACH type="full"]529[/ATTACH]

What I want is the actual url, for example for the code above, it would need to be:

Code:

jbrcjw5pq0q81_jpg-jpg.529

My current sql query is:

SQL:

    SELECT t.*, p.* FROM `xf_thread` t
    left outer join xf_post p on t.thread_id = p.thread_id
    left outer join xf_thread_prefix x on x.prefix_id = t.prefix_id
    WHERE
    (      t.reply_count > 1
       and p.post_id <>...

Read more

Continue reading...