Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Trader Ratings v1.2.0 Details »»
Trader Ratings v1.2.0
Version: 1.2.0, by eoc_Jason eoc_Jason is offline
Developer Last Online: Jan 2020 Show Printable Version Email this Page

Version: 3.0.7 Rating:
Released: 05-31-2004 Last Update: 11-14-2004 Installs: 254
DB Changes
 
No support by the author.

Trader Ratings - A user feedback hack
Copyright ?2004 Jason Rabel, All Rights Reserved.
__________________________________
Latest TR Verson: 1.2.0
vB Versions: 3.0.0 - 3.0.9
Author: Jason Rabel
Contact: PM me here, I'll respond.
Site: EXTREME Overclocking
??????????????????????????????????

Updates:
??????????????????????????????????
1.2.0 - September 4, 2004
- Added Trader Ratings Stats Page (finally!)
- Added PM notification when someone receives feedback
- Changed how positive feedback percentage score is calculated (bugfix)
- Ability to "close" the Trader Ratings pages (for maintainence or whatever) - TRATING_CLOSED
- Ability to set the URL field when submitting feedback to required or optional - TRATING_REQ_URL

1.1.0 - June 7, 2004
- Added time-based user edit/delete abilities, set via TRATING_UEDIT constant in traderratings.php file
- Userdate field is now an int field to be consistent with vBulletin
- Userrating field changed to tinyint to save space
- Fixed timeframes for showing historical ratings
- Made some various code consolidation
- Added missing ".TABLE_PREFIX." statement
- Templates.txt file shows code for postbit & MEMBERINFO, with conditional examples
- All 3 templates changed heavily
- Added some more phrases & fixed missing phrases

1.0.1 - June 2, 2004
- Fixed a "divide by zero" display error
- Postbit template fixed so guests do not have a trader rating

1.0.0 - June 1, 2004
- Initial Public Release

Description:
??????????????????????????????????
Trader Ratings has evolved from my vB2 Buy/Sell/Trade User Rating System. This is a rating system for when members buy / sell / trade items from each other (presumably on a FS section of your forum). It is based on the honor system since there is no way to truly tell if they did engage in a transaction. (But I'm working on a way to fix that.) Trader Ratings came about because it was a pain to try and maintain a single thread listing good / bad traders and so far has worked out quite well.

Features:
??????????????????????????????????
? Rate another member: Positive / Negative / Neutral
? Specify Buyer, Seller, or Trade
? Leave comments about the deal
? Records date when rating created
? Specify a URL to the deal
? Display ratings over time
? Filter based on Buyer/Seller/Trade/or feedback they left for others
? Users can edit/delete ratings left for others (time based limitation)
? Admins & Mods can edit/delete anyone's ratings (just incase)
? Stats page showing best & worst rated members, and recent ratings
? PM notification when a person is rated

Basic Info:
??????????????????????????????????
I haven't written a FAQ or any real documentation yet, but the way the system works is very simple. The only part that might confuse someone is that the Feedback Score is based only on UNIQUE members. Also, there are simple checks in place to make sure they actually do select proper info and enter a comment. A user is not able to rate themself (obviously). Permissions for viewing / rating are similar to standard forum viewing / posting permissions. Also it checks to make sure users exist and all that good stuff.

Installation Info:
??????????????????????????????????
This hack is very simply to implement requiring only:
? 1 new file
? 5 new templates / 2-3 template changes (navbar, posbit/postbit_legacy, MEMBERINFO, memberlist_resultsbit)
? 52 new phrases
? 1 new DB table / 1 table DB change & index

An install/upgrade PHP file is included to do all the template/phrase/DB stuff, so basically you run that, upload the file, and edit your postbit template. BAM!

Screen Shots / Demos:
??????????????????????????????????
See Screenshots below, or you can view them on my forums: My Trader Rating Page

Standard Disclaimer:
??????????????????????????????????
BACKUP YOUR DATABASE & FILES BEFORE IMPLEMENTING THIS HACK!!!

Forums Using This Hack:
??????????????????????????????????
EXTREME Overclocking Forums
i-Club -- Forums
Accord Tuner
NSX Prime
Honda-Acura.net
Guns Network
PimpRig

(PM me your forum if you want me to add you to the list)

Donations:
??????????????????????????????????
This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you.


Plans For Future Releases:
??????????????????????????????????
? rebuttal / followup comments
? item description (possibly instead of thread url)
? button on thread that buyer/seller clicks to tie the transaction to two people

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #122  
Old 06-08-2004, 03:46 AM
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Location: Houston, TX
Posts: 493
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Drumsy - Yeah, that happened to one other peson, because the indexes were missing beforehand.

You will need to manually run the following SQL statements to complete the upgrade:
Code:
ALTER TABLE user_rate_trade DROP userdate;
ALTER TABLE user_rate_trade CHANGE datetmp userdate INT(10) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user_rate_trade ADD INDEX rateduser_2 (rateduser,userdate,userrating);
ALTER TABLE user_rate_trade ADD INDEX rateduser_3 (rateduser,userbuysell,userdate,userrateid);
Reply With Quote
  #123  
Old 06-08-2004, 03:55 AM
drumsy's Avatar
drumsy drumsy is offline
 
Join Date: Nov 2001
Location: Charlotte, NC
Posts: 292
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually I just commented out those lines and refreshed the screen. Seems to have worked! :thumbup:
Reply With Quote
  #124  
Old 06-08-2004, 04:04 AM
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Location: Houston, TX
Posts: 493
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

commented out? I hope you mean the code above the alter table lines I posted previously? You have to let it drop the old userdate table and rename the new one because of how time is stored and utilized in the new version.
Reply With Quote
  #125  
Old 06-08-2004, 04:07 AM
drumsy's Avatar
drumsy drumsy is offline
 
Join Date: Nov 2001
Location: Charlotte, NC
Posts: 292
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Correct. I commented everything from the lines dropping those columns and above. All of the additions went through successfully.
Reply With Quote
  #126  
Old 06-08-2004, 10:48 AM
cogimo cogimo is offline
 
Join Date: Apr 2003
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

HI

I just installed the trader rating hack, when I try to go to traderratings.php

I get this message

I made all the changes per instructions

This user has not registered and therefore does not have a profile to view.

Please advise
Reply With Quote
  #127  
Old 06-08-2004, 11:42 AM
cogimo cogimo is offline
 
Join Date: Apr 2003
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cogimo
HI

I just installed the trader rating hack, when I try to go to traderratings.php

I get this message

I made all the changes per instructions

This user has not registered and therefore does not have a profile to view.

Please advise
I fixed the first problem


he second problem I am having is the rating is above the forum post, how do I get it below the usertitle

please see this example

http://www.celebratingfathers.com/bo...hread.php?t=23
Reply With Quote
  #128  
Old 06-08-2004, 03:12 PM
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Location: Houston, TX
Posts: 493
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Move the traderratings code in your postbit to below the usertitle variable....
Reply With Quote
  #129  
Old 06-08-2004, 08:30 PM
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Location: Houston, TX
Posts: 493
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay, last night I couldn't sleep so I pondered on the part of making verified deals, and conceptually here's what I have come up with:

1. In your forum's FS/WTB section, whenever a user makes a new thread, the first post has an additional buton somewhere. Not sure of the name yet, maybe "Deal" or "Buy/Sell" or whatever...

2. Anyhow, people can reply to the thread as usual, however when someone agrees to purchase/sell said item, they click on the button in the first post. This does two things. First - it closes the thread and prepends the thread title with "SOLD -". Second - It creates a relationship between the user who clicked the button, and the person who posted the thread.

(Maybe have an intermediary page that confirms that they do indend to purchase/sell said item and must check a box before confirming.)

3. It will send a PM to both people, just as notification of the transaction. Also in each member's trader ratings page it will have a "pending transactions" link.

4. Under the pending transactions page it lists people who they have done the steps above. If neither person has rated each other, there will be a "cancel" button, however both parties much cancel for it to actually take place, then the original thread will automatically be reopend and title changed back. If one person rates the other, then neither can cancel the deal. They will also have a preset amount of time to rate the other person before the opportunity is lost.

5. The old rating still will still be in place, however they will be considered "unverified" deals. With the steps mentioned above, they will be considered "verified" deals, since there is a link back, they clicked the link with the knowledge of engaging in the transaction, etc...



Overall this shouldn't be too difficult to implement, and I think will enhance this hack a lot. Please give your feedback & suggestions as it's easier to make changes before I start writing/changing any code...
Reply With Quote
  #130  
Old 06-08-2004, 08:35 PM
Yahhoon23 Yahhoon23 is offline
 
Join Date: Dec 2003
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I love it except for one minor detail that may create problems.

Say for example someone does in fact clicks the button and then decides they don't want to purchase the item. What will take place? I mean like eBay for example once you use Buy It Now, technically the same deal, if someone doesn't pay, they force being left negative feedback and the seller has to re-list or re-post the item.

So with this, are we making the buy/sell relationship that strict whereas the person buying will in turn have no choice after they hit the button and confirm, and they must purchase or have no choice but recieve negative feedback.

My main point is how strict in fact the button will be. I love the idea of after clicking the button it closes the thread and PMs both users but I just don't want people to be forced into deals as a result of clicking the button.

I guess actually maybe it won't matter and this whole post was meaningless because as long as you can be clear with how it will work to your forum members, it shouldn't be that much of a problem.
Reply With Quote
  #131  
Old 06-08-2004, 08:36 PM
Yahhoon23 Yahhoon23 is offline
 
Join Date: Dec 2003
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok nevermind. I decided to skip reading #4 and #5 and decided to just start typing without reading your whole post

That actually makes it alot better with those options and doesn't necessarily lock them into a deal.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:21 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05214 seconds
  • Memory Usage 2,324KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete