[Klug-general] Bash / Curl Tuition - Answers to Nathan's questions 16:32pm 15/04/2011

[Stephen Ryan]

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.
thanks everyone and sorry again for spamming your system.
Stephen


On Sun, Apr 17, 2011 at 4:15 PM, Nathan Friend <nathan.friend at gmail.com>wrote:

> As a starter for 1.2
>
> mysql -uUsername -pPassword
> USE YourDatabaseName;
> SELECT * FROM wp_comments WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <=
> comment_date;
>
> This will give you all comments in the last 24 hours.  If you only
> want specific fields you can replace the * with comma separated field
> names.
>
> SELECT comment_author_email,comment_author_ip,comment_date FROM
> wp_comments WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= comment_date;
>
> Let me know how you get on.
>
> Cheers,
>
> Nathan.
>
> On Fri, Apr 15, 2011 at 4:34 PM, Stephen Ryan <intrench at googlemail.com>
> wrote:
> > 1.1 - This is also an exercise in learning to code everyday, so i have to
> > write the scripts myself vs. using premade apps.
> >
> > 1.2  My website is wordpress, so i guess, like you say i will have to
> work
> > out what commands to query WP db.
> >
> > 1.3  Again, i am interested in writing script to pull data of all kinds
> so
> > for me stats analysis will be an excercise in scoping how the data is
> laid
> > out in the stats app (whatever that may be) and then writing a script
> that
> > scrapes the data and saves it to file which i can vi it.
> >
> > I want to be able to write code that uses Curl to crawl and identify
> > metadata and scrape the tags for inspection. So say i want to use SEO on
> my
> > website, i can run the script and it will tell me where the holes are in
> my
> > SEO.
> >
> > Hope thats a bit clearer.
> >
> > Cheers
> >
> > Stephen
> >
> > _______________________________________________
> > Kent mailing list
> > Kent at mailman.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/kent
> >
>
> _______________________________________________
> Kent mailing list
> Kent at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/kent
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/kent/attachments/20110417/6dbbb03e/attachment.htm>