Thanks Ingmar! The missing ingredient is I don’t know how to execute this command. Would I log in through SSH and then paste the command and send it to the server?
Obviously I should back my database up before I do anything. Any other advice?
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
June 16, 2009 3:48pm
Subscribe [5]#16 / Oct 15, 2009 4:14pm
Thanks Ingmar! The missing ingredient is I don’t know how to execute this command. Would I log in through SSH and then paste the command and send it to the server?
Obviously I should back my database up before I do anything. Any other advice?
#17 / Oct 15, 2009 4:25pm
You can use it with the query module, eg:
<ul>
{exp:query sql="SELECT title AS my_title, url_title AS my_url_title, field_id_1 AS my_body
FROM `exp_weblog_titles` NATURAL JOIN `exp_weblog_data`
WHERE UNIX_TIMESTAMP(ADDDATE(entry_date, INTERVAL 30 DAY)) <= UNIX_TIMESTAMP(NOW())
AND status = 'open'
ORDER BY view_count_one DESC
LIMIT 10"}
<li><a href="http://../{url_title}">{my_title}</a>
</li>
{/exp:query}
</ul>Something like that, at any rate.