SSL

Brownie points now earned for voting.

Because we'd like you adgrunts to vote, so that we get a good idea of what should end up on the "best" and "worst" lists at the end of the year, all adgrunts now earn one brownie point for each vote. (Voting is so easy, and in theory you could earn over fourtythousand if you took a voting walk through the archives).

So go ahead and make your vote count both for you and for all of us. See a great ad, rate it five hearts. See a bad one, give it just one.


Technorati Tags:
Average: 4.3 (100 votes)

Is this so that you can avoid have Ads without votes - so your database can work? :-)

I voted for this! ;-> [Test]

When we do our year-end round up, we'd prefer for the users to vote up the ads to the top. This rarely happens though. Although that's only one part of the reason for it.

J. -
My comment on this refers to when Åsk was having a problem dealing with NULL (i.e. no answer/ranking) for the Super Bowl ads (I think that was it). The rankings were slightly messed up, because her database was apparently split into 2, and she couldn't easily combine them. (I offered to help her correct the problem, using my SQL skills).

A.

Oh, so sorry. I didn't realize you were talking directly to one person.

My reply was directed to you (your initial is "J", right?), but my original posting was directed to Åsk.

yeah, I figured that much out. I was replying regarding your first comment. And I'd prefer if you didn't use my initial - you can call me Caff or caffeinegoddess...

thanx.

no prob

I know. :) (and the sql isn't the problem in old posts that have previously been voted on, the database has old votes from our previous database incarnation stored in the correct tables, but for them to appear we need to vote again, if I knew where this problem occurs I'd fix it.)

But the points for voting is not only to encourage voting, which is better the more people who do it of course, but also to perhaps stem some people who clearly only comment to get points. ;)

Åsk:
Send me your table structures, and what SQL you're using to gather the votes. I can probably find a way around your problem. [Yeah, I think I'm that good.] :-)

I've been using SQL Server since version 4.2 [1993], when it was a joint Microsoft-Sybase product. I've worked with Oracle since version 6.5 [around 1995], along with many other SQL databases, including DB2 and MySQL.

Good plan, I guess, but there are still people running around at night making hundreds of one-word comments.

Honestly, I believe the only thing that will cure that is if a major company with mucho moolah saves us all from the upgrade thing by setting the ads free. (Something I can't do, because I do not have loads of moolah.)
Allan1, didya get my very confusing tables email? Headache inducing isn't it?

Dab:

I haven't had a chance to look at my email accounts, except for the one at my client's address. I can't access any of my 6 other accounts at the office**, and my time on my home cpu has been severely limited because of running back and forth to a nursing care facility for my mother-in-law, among other things. She's coming home tomorrow, supposedly. Out of the past 4 months, she's been home with us for almost 1 month, split into 4 pieces (3 hospitalizations and 2 nursing care/physical rehab facilities).

I may have a chance tomorrow morning before we pick her up - I'll let you know.

**==> They block those accounts. I need to upgrade my phone - possibly to an iPhone, or something similar, so that I can read and respond to my own accounts when not at home

Åsk: I've just started to look at it. First impressions, it's not as bad as I expected. I'll let you know more later.

Åsk: I've had a chance to look at it this afternoon, and I've sent you a reply email with some SQL statements that may help.

Somebody get on the phone to Apple (Quicktime!) and tell them about Adland!

This is cool.

It also gives me an idea (which may or may not be possible). If users' voting history could be archived somehow then you could find out what they like and dislike and provide them with updates when certain content is posted based on their preferences. This could make the site more customizable, more personal.

Say someone votes highly for certain types of posts consistently. Then there could be some sort of automatic update that alerts the person when similar posts are made. That may or may not make sense but it sounded good when I thought of it.

In general, this kind of tracking can be done, and is usually done, to varying extents, on many websites (Amazon.com, etc).

As to whether it can be implemented on the Adland server, I'll leave it to Dabitch to comment.

Many people do not like this kind of data collection, and prefer to be able to opt-out of it, whenever a website has it.

Thank you.

I only vote if I'm promised less government and lower taxes.