vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Trader Ratings v1.2.0 (https://vborg.vbsupport.ru/showthread.php?t=65730)

wynode 09-25-2004 05:46 AM

OK i've searched this thread but can't seem to find the solution......

Basically there have been a couple of cases where the "Submit Feedback For xxxx" link has not come up in the trader ratings screen.

For example, others have been able to rate myself, but there is at least one user who cannot rate me (the link doesn't come up).

And just now another user reported the same error when trying to rate someone else.

ANy ideas?

eoc_Jason 09-25-2004 01:44 PM

The only permissions a user must have is the "CANPOSTNEW", and also a user can not rate them self. Other than that the link should appear unless you have added custom rules to the <if> statement.

Jimboj79 09-27-2004 01:47 PM

Excellent mod thankyou :)

wynode 10-03-2004 05:15 AM

Quote:

Originally Posted by eoc_Jason
The only permissions a user must have is the "CANPOSTNEW", and also a user can not rate them self. Other than that the link should appear unless you have added custom rules to the <if> statement.

Thanks for that!

I had setup a new group and their permissions weren't set properly. That's why some users were affected and not others.

Great work...lovin this hack! :)

andrew67 10-03-2004 06:35 AM

Great hack Jason, I have it working on my test board wonderfully. But on trying to install it to my functional board I got the following errors.

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE user_rate_trade (
userrateid int(10) unsigned NOT NULL auto_increment,
rateduser int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
userrating smallint NOT NULL default '0',
usercomments varchar(80) NOT NULL default '',
userdate int(10) unsigned NOT NULL default '0',
userbuysell tinyint(1) unsigned NOT NULL default '0',
userurl varchar(255) NOT NULL default '',
PRIMARY KEY (userrateid),
KEY rateduser (rateduser,userrating),
KEY rateduser_2 (rateduser,userdate,userrating),
KEY rateduser_3 (rateduser,userbuysell,userdate,userrateid),
KEY userdate (userdate)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Table 'user_rate_trade' already exists

mysql error number: 1050

Date: Sunday 03rd of October 2004 04:08:53 PM
This I attempted to fix by search replacing all "user_rate_trade"'s in the php file with "vb3_user_rate_trade".

Then attempted to install again.
And received the following.
Quote:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'tratings', 'Trader Ratings', 1)
mysql error: Duplicate entry 'tratings-0-1' for key 2

mysql error number: 1062
Which I then fixed by removing all the phrases that were added by the php file.

Then went to install a third time and received.

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ratetradetotal'

mysql error number: 1060

Any ideas?

My next approach is to change the "vb3_user_rate_trade" to something else again and change the "ratetradetotal" to something else as I can't actually remove the tables (no access).
Cheers
andrew

Vixion 10-03-2004 01:27 PM

I am thinking about using this modification on my own forum. But I need to have something clear.

The screenshots attached in the first post, are very clear, they look like eBay, but does the system work with a unique feedback score?
I.E.
Person A. makes a trade with Person B. Because of a good trade, Person A. leave a feedback for Person B.
After 2 weeks Person A. and B. trade again. And after that trade they leave a feedback again.

Now my question;
Does every feedback counts to the total (I.E. Person A. (30)) or does the feedback-score only displays the UNIQUE trades, with UNIQUE people?

newb1e_ 10-03-2004 03:08 PM

Hi all,

looking at some of the previous question's I'm a little embaressed to ask this (ultra obvious I imagine but here goes)

in the templates editing area of the readme it says

Quote:

- Add somewhere:

<if condition="$post['userid']"><div>Trader Rating: (<a href="traderratings.php?$session[sessionurl]u=$post[userid]">$post[ratetradetotal]</a>)</div></if>
Could someone give me a quick idea where I should place the code in postbit/postbit_legacy/MEMBERINFO? Please help a newbie

thanks in advance, be gentle :surprised:

Lord Brar 10-03-2004 03:34 PM

Gee. Thanks Dude! I really needed something like this for SellAdSpace.com! The installation was Really Easy!

Wonderful Hack. Thanks!

Lord Brar 10-03-2004 03:35 PM

Forgot to add - *Clicks Install* :D

JazzleBug 10-03-2004 04:31 PM

This is excellent and will save us much time. Thanks for the hard work and support! Super easy installation!

Something I'd like to see in the future if you continue to develop this is complete admincp integration where the admin can alter the numbers without having to manually create new entries. Having seen the code and the database, I don't imagine that this would be incredibly easy as the numbers come from counting individual entries, correct? I'm certainly not a programmer (though, it's fun to think I am lol), so I don't have a clue what goes into coding something like this. I do think that it might bypass the need for a full conversion script (assuming everyone is just running around with one long thread of feedback on their forum). 'K - I'll shut up. ;)

Thanks for the script!

Steph


All times are GMT. The time now is 05:00 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01722 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete