View Full Version : Reputation in Gallery
February 27th, 2005, 07:24 AM
I was wondering if it is possible to use vB's reputation in Gallery.
February 27th, 2005, 09:41 AM
Anything's possible. It might require a good bit of work to get a reputation system working with the gallery as well though.
February 27th, 2005, 09:49 AM
Humm.. I don't want an independent system in Gallery but the same or an extension of the one running on my board, if you understand what I mean.
The problem seems to be the overlapping postids from the forum and Gallery...
February 27th, 2005, 10:12 AM
Yup... Another column could possibly be added, but we're trying to stay away from altering the vB installation any more than necessary.
February 27th, 2005, 12:31 PM
We need a distinctive mark in the inserted postid. I took a look at the postid field in vB's reputation table and is INT type with a lengh of 11 characters so a letter is out of the question, but a number is not.
I'm a MySQL illiterate but can we precede every Gallery postid with a 0 (zero)?
It wouldn't change the way vB handles reputations or the db in any way but could make a clear distinction between Gallery and Forum postids. Then if some work needs to be done to distinguish what is what, it could be done in Gallery's side.
February 27th, 2005, 01:13 PM
011 (for example) is not a valid integer and would result in the field having '0' as the value.
February 27th, 2005, 01:36 PM
It's not my lucky day =(
Well.. I kind of really need it and will try to make it work in Gallery, so in your professional opinion, which is the lesser evil?
- making the postid field unsigned and inserting all gallery postids as negative or;
- create a new table for gallery reputation and try to join reputation tables when querying totals.
I'm inclined for the later because there's a smaller (or inexistent) chance of errors or getting everything deleted in the next vB/Gallery update but would like to know your opinion first.
February 27th, 2005, 01:42 PM
I would go with the second just because that way you don't have the risk of a vB update overwriting anything.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.