thank you for this Nathan. I'm going to try and draw up the pseudo code and look at what Bash/Curl statements i need to accomplishi it. Your code will certainly help, i'm sure. I am also going to see if i can find a course on Bash or a tutur and if need be pay for it.<br>
thanks everyone and sorry again for spamming your system.<br>Stephen<br><br><br><div class="gmail_quote">On Sun, Apr 17, 2011 at 4:15 PM, Nathan Friend <span dir="ltr"><<a href="mailto:nathan.friend@gmail.com">nathan.friend@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">As a starter for 1.2<br>
<br>
mysql -uUsername -pPassword<br>
USE YourDatabaseName;<br>
SELECT * FROM wp_comments WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <=<br>
comment_date;<br>
<br>
This will give you all comments in the last 24 hours. If you only<br>
want specific fields you can replace the * with comma separated field<br>
names.<br>
<br>
SELECT comment_author_email,comment_author_ip,comment_date FROM<br>
wp_comments WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= comment_date;<br>
<br>
Let me know how you get on.<br>
<br>
Cheers,<br>
<br>
Nathan.<br>
<div><div></div><div class="h5"><br>
On Fri, Apr 15, 2011 at 4:34 PM, Stephen Ryan <<a href="mailto:intrench@googlemail.com">intrench@googlemail.com</a>> wrote:<br>
> 1.1 - This is also an exercise in learning to code everyday, so i have to<br>
> write the scripts myself vs. using premade apps.<br>
><br>
> 1.2 My website is wordpress, so i guess, like you say i will have to work<br>
> out what commands to query WP db.<br>
><br>
> 1.3 Again, i am interested in writing script to pull data of all kinds so<br>
> for me stats analysis will be an excercise in scoping how the data is laid<br>
> out in the stats app (whatever that may be) and then writing a script that<br>
> scrapes the data and saves it to file which i can vi it.<br>
><br>
> I want to be able to write code that uses Curl to crawl and identify<br>
> metadata and scrape the tags for inspection. So say i want to use SEO on my<br>
> website, i can run the script and it will tell me where the holes are in my<br>
> SEO.<br>
><br>
> Hope thats a bit clearer.<br>
><br>
> Cheers<br>
><br>
> Stephen<br>
><br>
</div></div>> _______________________________________________<br>
> Kent mailing list<br>
> <a href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a><br>
> <a href="https://mailman.lug.org.uk/mailman/listinfo/kent" target="_blank">https://mailman.lug.org.uk/mailman/listinfo/kent</a><br>
><br>
<br>
_______________________________________________<br>
Kent mailing list<br>
<a href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a><br>
<a href="https://mailman.lug.org.uk/mailman/listinfo/kent" target="_blank">https://mailman.lug.org.uk/mailman/listinfo/kent</a><br>
</blockquote></div><br><div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>