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

Reply
 
Thread Tools
Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack) Details »»
Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack)
Version: 1.00, by eoc_Jason eoc_Jason is offline
Developer Last Online: Jan 2020 Show Printable Version Email this Page

Version: 2.3.x Rating:
Released: 04-25-2003 Last Update: Never Installs: 85
 
No support by the author.

Buy / Sell / Trade User Rating System (aka eBay Style User Feedback Hack)

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

Description:
This is a rating system for when members buy / sell /trade items from each other. It is based on the honor system since there is no way to truly tell if they did engage in a transaction. However I created this system because it was a pain to try and maintain a single thread listing good / bad traders and so far has worked out quite well.

Key Features:
- Rate 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
- Admins & Super Mods can delete ratings (just incase)
- Pagination (Just for Mist )

Current Version: v1.11
There are instructions in the zip for upgrading from 1.0 -> 1.1
*Note*, I forgot the change of templates "faq" & "faq2" (added as steps 19 & 20), thats why I uploaded v1.11, otherwise everything is the same as v1.1 (If you don't want the little FAQ part, just remove the FAQ link in the getinfo template below the rating stuff)

Tested On vBulletin Version: 2.2.9, 2.3.0
(should be compatible with all versions, very simple stuff)

To Do List: (Last Edited: 05/01/03)
- Send user an email when feedback is left for them
- Allow the user who received the feedback to comment on the feedback left for them. (For Neutral/Negative Feeback Only)
- Allow optional time limits for how often you can rate someone
- Allow all columns to be sortable ASC/DSC
- create a sort of wall of fame / shame (check this thread) for more info
- have a link so you can find out all the people you rated (and how you rated them)

Additions & Changes:
1 File Uploaded
1 Table Added
1 Table Changed
3 Files Changed
10 Templates Added
5 Templates Changed

Credits:
I can't take the entire credit for this hack, while I did have the idea in my head for a while, I took bits and pieces of code off of the User Ratings hack written by EXCHANGE.

Also I would like to give a big thanks to all the members at the Extreme Overclocking Forums that helped me test out this hack as well as give me suggestions for additions and improvements.

Like My Hack?:
If you like this hack and are currently using it, please click the INSTALL button. You will receive updates in your e-mail, whenever I add new features (or fix bugs). Also any comments / suggestions are welcome. Your opinions help make it a better hack!

Sites Currenly Using This Hack:
(If you would like your site listed, please let me know so I can add it to the list!)
forums.extremeoverclocking.com
www.sportscardforum.com
www.honda-acura.net
www.graphcal-illusions.com
www.7thgencivic.com/forums/
www.vb-host.com
www.planetwrx.com

Show Your Support

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

Comments
  #122  
Old 06-21-2003, 06:34 PM
mr.children mr.children is offline
 
Join Date: Jun 2003
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thank you...but where to find the phpmyadmin thing?
should i look it up in download.com?
Reply With Quote
  #123  
Old 06-25-2003, 01:05 AM
Fi_InCogNiTo Fi_InCogNiTo is offline
 
Join Date: Jan 2003
Posts: 112
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="https://www.phpmyadmin.net" target="_blank">www.phpmyadmin.net</a>
Reply With Quote
  #124  
Old 06-27-2003, 06:32 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Why is this step needed?

Quote:
-----------------------------------------------------------------
3. Find in showthread.php (around line 58):
-----------------------------------------------------------------

LEFT JOIN user ON user.userid=post.userid

REPLACE with:

LEFT JOIN user ON user.userid=post.userid,ratetradetotal

-----------------------------------------------------------------
//END showthread.php
-----------------------------------------------------------------
As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL and all user table fields are already received in the query in part:
PHP Code:
 user.* 
So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI.
Reply With Quote
  #125  
Old 07-04-2003, 12:13 AM
Les Shaw Les Shaw is offline
 
Join Date: Dec 2001
Location: Oshawa, Ontario, Canada
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hack works well but when I click the trader rating in the thread I get a java script error ?
But no error if I click on it in the profile?

Any one have a fix for me

http://www.thecomputermechanics.com/forums/
Reply With Quote
  #126  
Old 07-14-2003, 02:48 PM
8ballstudios 8ballstudios is offline
 
Join Date: Jul 2003
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Jason,

Sorry if someone has already asked this question, I've tried to read all the messages in this thread.

Can this hack work similar to heatware.com? It looks like you have all the same features, the only difference that heatware.com allows users of several different websites to be rated (some of which are not vbulletin forums).

I plan on having a rating system for my forums (vbulletin 2.3.0 hosted), but want to make the rating system available to 4 additional sites as well (some vbulletin hosted, some not). I would do this on a seperate domain (a la heatware), not the same domain as my forums.

Is this possible?

Thanks!

Kevin
Reply With Quote
  #127  
Old 07-30-2003, 02:31 PM
PurpleCow PurpleCow is offline
 
Join Date: Mar 2003
Posts: 222
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello,

I am getting this error when i run the alter table query.

When i run this query
Quote:
ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;
I get the following error :

Quote:
SQL Error 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0
I am running on the latest version of mysql, that is almost.

Kindly help me with the right syntax.

Thank you
Reply With Quote
  #128  
Old 07-30-2003, 03:00 PM
PurpleCow PurpleCow is offline
 
Join Date: Mar 2003
Posts: 222
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay, sorry, I did a mistake.

I was supposed to run the ALTER Table query seperately, i suppose. I did that now and everything went fine and infact the hack is working fine on my boards now.

Thank you

/me clicks on install now
Reply With Quote
  #129  
Old 08-05-2003, 05:22 AM
Imprezer Imprezer is offline
 
Join Date: Dec 2002
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great hack!

Installed on www.i-club.com

Feel free to use my site as a sample!
Reply With Quote
  #130  
Old 08-20-2003, 06:26 PM
The Realist's Avatar
The Realist The Realist is offline
 
Join Date: Oct 2001
Location: UK
Posts: 842
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nice hack M8, well done.
Reply With Quote
  #131  
Old 08-20-2003, 06:33 PM
ImportPassion ImportPassion is offline
 
Join Date: Mar 2002
Location: Gilbert, AZ
Posts: 605
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
06-27-03 at 03:32 AM Logician said this in Post #123
Why is this step needed?



As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL and all user table fields are already received in the query in part:
PHP Code:
 user.* 
So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI.
ya, i saw that too, i just ignored it. mine has been working fine.


D
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 02:22 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.13258 seconds
  • Memory Usage 2,323KB
  • 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
  • (2)bbcode_php
  • (4)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
  • (1)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