Would anyone be willing to make a leaderboard for the Post Thanks Hack? My members really want to be able to see who's getting the most thanks for a competition. Please PM with quote or any questions.

I'd have to see the tables, but based on what I see, the data is there to run a simple query and tabulate the results.

--------------------
vBPicGallery - The photo gallery for vBulletin forums.
Talk to bikers around the world about motorcycles.

Yes, I took a quick stab at it myself but my vBulletin SQL-fu is weak. (If possible I'd also like their avatar displayed along with their name and thanks count, which means pulling in data from another table.) Do you just need the table structure or some sample data?

I'm interested in how and where the counts are stored. Fetching them and the user data I think we can do after we know that much.

Sounds like if we get the query, you can parse it?

--------------------
vBPicGallery - The photo gallery for vBulletin forums.
Talk to bikers around the world about motorcycles.

*moved to the marketplace*

--------------------

Post your URL and a link to your vb.com username here to get full access.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Ok, here's a snapshot of the table data:

The username field refers to the person who did the thanking, we can ignore that.

I can see from the table that we can do what you want at first glance. But it also tells me that the code in the hack is poorly written too. The indexing on this is not adaquate for your idea and I can't see it being usefull in operation. Right off the bat I can tell it's table walking.

However, I will donwload the hack and look closer and make a suggestion.

This is the like 4the or 5th hack I've seen in the last 90 days or so that is just frustrating. It's like no one knows, no one cares, or something, that the code is not noticed and improved.

So many good ideas, yet such poor coding and lack of community effort.

But when the attitude at the org is, as it has been, where they will accuse you of stealing one line of code, why would anyone think it's community oriented development anyway and help?

Then you have the folks that can't see the forest for the trees and if you tell them they have a problem, they cry. Go figure.

AUTO MERGE POST: (Auto Merge Sucks ass in a Coding forum.)

Well, it appears they are using the search table to store results. I didn't read it real close as to how it avoids the pitfalls I pointed out.

But I did confirm that the table lacks the proper index(es) for a where search which causes table walks.

At a glance a counter for this calculated at post thanks time would be cool. I didn't notice if there was one. This would solve your immediate need if it existed. If not, you have to modify that table above and create the queries to tabulate.

The hack looks pretty complicated for the purpose as a whole. But it's popular and should get improved as time goes on.

--------------------
vBPicGallery - The photo gallery for vBulletin forums.
Talk to bikers around the world about motorcycles.

hmm, if your offering free help, I'll move the thread back.
I took it as a paid request when I first read it.

--------------------

Post your URL and a link to your vb.com username here to get full access.

Have you heard about Crowdgather?
Find it on Forums

Stay up to date by installing our Tool Bar

Yeah it looked simple enough to walk through in a thread. I dunno where it's going though. I don't need the money. I was just tinkering.

--------------------
vBPicGallery - The photo gallery for vBulletin forums.
Talk to bikers around the world about motorcycles.

Anything noppid wants to do is good with me... if he provides a quote I'll happily pay him or someone else to do the job, if he points me in the right direction SQL-wise I'll happily figure out the parsing end.