Major Additions - iTrader v2.8 - Powerful Rating System

Please nominate this mod for MOTM!

iTrader 2.8
Click here for a version for vBulletin 3


This modification offers you a rating system for trades which are made on your board. As it is an advantage of the rating system on ebay, this gives your users some secureness.

=================================
NOTICE ABOUT THE AUTHOR:

I added vBulletin 4 support for this modification because Nexus (vbenhancer) announced that he won't do this in the next time. He gave me the permissions to release it here. Thank you!

Please do not contact vbenhancer for support! He is not responsible for this version.

=================================

Installation
The installation is as easy as abc. You only have to upload the files and import the product in your vBulletin admincp.

Update
Also updating this modification (including this from vB3) isn't very difficult. Only overwrite all files and the product in your vBulletin admincp.

Screenshots
itrader_rateuser.png
Rate a trader/seller

itrader_user270.jpg
iTrader Profile

itrader_main270.jpg
iTrader Main Page

itrader_tab.png
iTrader Profile Tab

Known issues:
none

Feature requests:

- microCLASSIFIEDS/AUCTIONS integration (?)
- latest threads of a selected forum on itrader main page

* Implemented in upcoming release

Release History
Cick here

Translations:
- German by Andre31

Please DONATE for further releases!

[digitalpoint]

The indexes defined in the iTrader table are not scalable at ALL. It's causing full table scans for queries and joins done when you are looking at iTrader stuff for any user. This was causing our user table to have locking issues since those queries are joined to the user table, which in turn causes everything in the forum to slow down (even if it has nothing to do with iTrader).

1. The index rateid index has no need for it to include the dateline column in the index.

2. The index rateduserid is an exact duplicate of the rateid index. This index should include rateduserid and dateline columns (it incorrectly includes rateid and dateline).

3. An index for rateduserid + buyselltrade columns is needed.

I've made those changes to our itrader table and now our itrader table (which has 526,000+ iTrader ratings) does not cause issues any longer.

This is what our indexes look like now:



Hopefully we will see index fixes in a future version of iTrader package?

[Manoel J?nior]

Great question digitalpoint!

[entertain]

@digitalpoint:
I didn't want to change the database structure, because maybe vbenhancer is going to release v3 with the old structures and this would make an update to v3 very, very difficult.

[sevenmix]

Hi

First of all thanks to keep updating this awesome plugin.

My question: Is there any way to keep the rate seller button on every post and not only the first one?

Thanks in advance, greetings.

[entertain]

@sevenmix:
Admin CP -> Plugins & Products -> Plugin Manager

Edit plug-in: iTrader Navbar Link (postbit_display_complete)

Search for:

PHP Code:

    if (in_array($this->forum['forumid'], $itrader_forumsurl_ok) AND $this->registry->options['itrader_rate_trade'] AND $this->registry->bf_ugp['itraderpermissions']['canrate'] AND $vbulletin->userinfo['userid'] != $thread[postuserid] AND $this->post['postid'] == $this->thread['firstpostid']) 


change into

PHP Code:

    if (in_array($this->forum['forumid'], $itrader_forumsurl_ok) AND $this->registry->options['itrader_rate_trade'] AND $this->registry->bf_ugp['itraderpermissions']['canrate'] AND $vbulletin->userinfo['userid'] != $thread[postuserid]) 


(untested )

[sevenmix]

Thanks very much entertain, that works perfectly

[Retal]

Hello, the links under usernames on the page "Left for others" lead to the iTrader page of the user who left the rating, not the user who was rated.

Solution

itrader.php
Change

PHP Code:

        $templater = vB_Template::create('itrader_userbits');
            $templater->register('itrader', $itrader);
            $templater->register('userinfo', $userinfo);
        $itrader_userbits .= $templater->render(); 


to

PHP Code:

        $templater = vB_Template::create('itrader_userbits');
            $templater->register('itrader', $itrader);
            $templater->register('userinfo', $userinfo);
            $templater->register('viewuser', $viewuser);
        $itrader_userbits .= $templater->render(); 


Template itrader_userbits
Change

<a href="{vb:raw vboptions.bburl}/itrader.php?{vb:raw session.sessionurl}u={vb:raw itrader.userid}">{vb:raw itrader.username}</a>(<strong>{vb:raw itrader.itrader_total}</strong>)

to

<a href="{vb:raw vboptions.bburl}/itrader.php?{vb:raw session.sessionurl}u=<vb:if condition="$viewuser['viewtype'] == 4">{vb:raw itrader.rateduserid}<vb:else />{vb:raw itrader.userid}</vb:if>">{vb:raw itrader.username}</a> (<strong>{vb:raw itrader.itrader_total}</strong>)

[sung]

Originally Posted by entertain

@digitalpoint:
I didn't want to change the database structure, because maybe vbenhancer is going to release v3 with the old structures and this would make an update to v3 very, very difficult.

If he was changing the table schema you'd be correct, however changing the indexes won't have any effect on that since you can just rebuild them.

To make his changes you'd just put the following queries in the install/upgrade code:

alter table itrader drop index rateid;
alter table itrader drop index rateduserid;
alter table itrader add index rateid (rateid);
alter table itrader add index rateduserid (rateduserid, dateline);
alter table itrader add index rateduserid2 (rateduserid, buyselltrade);

And to go back to the previous indexes:

alter table itrader drop index rateid;
alter table itrader drop index rateduserid;
alter table itrader drop index rateduserid2;
alter table itrader add index rateid (rateid, dateline);
alter table itrader add index rateduserid (rateid, dateline);

Unless you have some inside knowledge about a 3.x release, no sense in making the current version slower for no reason.

[entertain]

@sung:
Thanks! Is it possible that itrader_main became very slow after these changes?

(Taking around 2-3 seconds to load, all other (itrader) pages around 0,05 to 0,10 seconds)

[KevinAlthaus]

Is this version fully working in vb 4.0?