How to link odbc tables using VBA

[MMcCarthy]

Hi everyone

I am using this as a test question to test the new Rate up/down feature for threads and posts. For anyone looking for a legitimate answer to this question please check out this insight.

Now anyone can post a reply here either commenting on the answer or anything else (withing site rules) and others can use the new up/down feature. Please feel free to post as many comments as you wish so we can thoroughly check out this feature.

Mary
ADMIN

BTW the icons don't always load on page refresh (bug to be fixed) but if you refresh a second time you should see them.

[marypmcc]

OK I am posting this under a pseudonym. I forgot to say in my original post that the visuals are not what the final visuals will be and we are testing the feature more than the visuals but feel free to give your input.

Mary

[RedSon]

I have a beef about this. I want to be able to change my choice. If i click on up, and change my mind, i want to be able to do it!

[YarrOfDoom]

The tooltip for "good" says "bad".
And edit resets it, good.
And did my multi-edit just break it?
Don't mind me just experimenting.
It appears it doesn't always show, based on either the missing of an empty line, or the post not being big enough.
Also randomly adds empty lines.

[RedSon]

Edit resets it?? what are you talking about?

[Banfa]

If you refresh the page sometimes the ratings don't get drawn.

Will anything be carried into the forums list of questions? The rating of the first post may be?

[RedSon]

If you refresh the page sometimes the ratings don't get drawn.

Same here.

[YarrOfDoom]

Edit resets it?? what are you talking about?

I voted my own post bad and edited it, after that it said 0/0 (or so I remember, though I don't really trust my own memory).
Edit for test.
Test points out it didn't actually say '0/0', but looked like no votes anyway. Trying to vote again however resulted in "you have already voted".

Redson edited this...

Nah, says I already voted on this one...

[Niheel]

so this is just the rating mechanism, now it's time to add what you guys want with the up votes and down.

mary suggested, with an upvote, send a good job PM and with a down vote send a PM that asks member to review our guidelines (link provided) and make changes, this will also move up the edit of a post to like 72 hrs giving members ample time to make changes to rate.

the idea is make moderating down to one click, also after x down votes move the post into soft delete, or lets say a super mod or admin clicks down vote and it does get soft deleted + pm noticed to author

[RedSon]

NO! Please do not send more PMs. We already send one when chosen as a best answer that is is way annoying! I don't need more every time someone upvotes my post. However I do like it to send PM when something is downvoted. Let's spam them to read the guidelines!

EDIT:
Grrr, thanks alot mary!!!

[YarrOfDoom]

Might result in a PM-flood, so I'd say send a PM if it reaches a certain number of votes and has a good/bad-ratio out of certain bounds at that point.
I like the increase edit-time idea.

[MMcCarthy]

How about we settle on bad vote gets PM but good vote only gets PM at certain milestones to be chosen.

[MMcCarthy]

EDIT:
Grrr, thanks alot mary!!!

Oh sure blame everything on me as usual :D

[Niheel]

@banfa, think that has to do with the JS calls or maybe cache, will work on improving the performance of that later

[MMcCarthy]

Ok guys so when say a post or thread has more than 5 down votes what do you want to do. Do you want to leave it to mods to soft delete. In this case we would have to make it easy for mods to see lists of all threads with more than 5 up-down votes. Remember, deleting that thread will of course delete any posts in that thread.

We could make it even easier on mods and automate a soft delete when voting results in a certain minus figure. For example 5 up votes and 15 down votes would give a total of -10 and if we set the threshold at -10 the thread or post would automatically soft delete.