The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
iTrader v2.8 - Powerful Rating System Details »» | |||||||||||||||||||||||||||||||||||
iTrader v2.8 - Powerful Rating System
Developer Last Online: Feb 2015
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! Download Now
Screenshots
Supporters / CoAuthors Show Your Support
|
16 благодарности(ей) от: | ||
Athena1984, Baja, CarpCharacin, eTiKeT?, halilkoca, kralksk, mariohn, Melodym, mitch84, nacaruncr, sharif_aly, Skaut, StormBreaker, thang28101993 |
Comments |
#372
|
||||
|
||||
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? |
#373
|
|||
|
|||
Great question digitalpoint!
|
#374
|
|||
|
|||
@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. |
#375
|
||||
|
||||
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. |
#376
|
|||
|
|||
@sevenmix:
Admin CP -> Plugins & Products -> Plugin Manager Edit plug-in: iTrader Navbar Link (postbit_display_complete) Search for: PHP Code:
PHP Code:
|
#377
|
||||
|
||||
Thanks very much entertain, that works perfectly
|
#378
|
|||
|
|||
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:
PHP Code:
Change HTML Code:
<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>) HTML Code:
<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>) |
#379
|
|||
|
|||
Quote:
To make his changes you'd just put the following queries in the install/upgrade code: 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: Code:
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. |
#380
|
|||
|
|||
@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) |
#381
|
|||
|
|||
Is this version fully working in vb 4.0?
|
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|