Forum Giveaway

Over the course of the next 15 days (April 16 - April 30), we will keep track of how many posts each user makes. All users that have 20 posts or more during this period will be entered into a drawing to win a free copy of EditWorksPro. It's that simple, just post an average of 1.33 posts per a day for this 15 day period and you could win a prize valued at $299. I will, of course, be watching what is posted and making sure that individuals don't post junk to inflate their post count.

Can I see how many posts I have made without searching and counting manually? It would be just tragic to end up with 19 posts on the 1st...

he he... does this post count?

I'll work something up within the next couple days so that you can check....

Hmm, I have an idea - why not add "My Recent Posts" along with "Recent Posts" and "Unanswered Posts", that will list the last 20 or so threads in which one participated. This will be useful also outside the giweaway context, sometimes it's not easy to find your post and check for potential answers

Yeah, I like that idea. Or just "My Threads" That way if I need to reference some thread to retrieve information or code I can easily do so.

Good ideas....I'll make it happen..

Hi Matt

can't see how many posts I've made, no bother. What really worries me is that if I got drawn you'd say "Oh, but its USA only, I'm not paying to ship down under".

You don't say anywhere that it's USA only but then again you don't say it's not. Clarification please.

Sarah

Well, all the contests so far have been Earth-only (I know, I won a few and received the prizes without any hassle ). So I'd say that the same goes for this one.

Prizes will go to anyone in the world. In fact, the makers of EditWorks are from Australia. Also, it is electronic delivery.

Just a question, do we need 20 individual posts or 20 different threads we've been active in.

doesn't mention threads

Can moderators win?

Yep

Matt:

This is 'codecrawler' but I can't get back into the system other than as Anonymous (see below).

Here's some SQL I developed to automatically show real-time results from postings to a joke database for a contest.

SELECT jo_contact.firstname, jo_contact.lastname, COUNT( jo_jokes.SUBMID ) AS count FROM jo_contact, jo_jokes WHERE jo_contact.ID = jo_jokes.SUBMID AND jo_jokes.jokedate >= '2003-05-01' AND jo_jokes.jokedate <= '2003-06-30'GROUP BY jo_contact.lastname ORDER BY count DESC LIMIT 0, 10;

The jo_jokes.SUBMID is the jo_contact.ID number, and this SQL auto-counts the number of individual joke submissions in jo_jokes & gives a total count by the Submitter. It works great...a pain to figure out ;-(

FYI, your 'Forgot your password?' does NOT work. It allows for a Password Reset, but asks for the original password. "DUH!" ... if I remembered my original password I would use it. Please check your DB for 'codewalker' and email me my password. Thanks.

-codecrawler-