Profile Enhancements - iTrader 2.1.0 (Interim Release)

To hold people over until I get the full updated version with new features released, I'm posting this Interim version that has been tested / updated for vBulletin 3.7.x

There are no new features in this release, it is simply compatability updates and minor bug fixes. There are changes to both files & templates, but no changes to the iTrader tables.

--------------------

iTrader - A user feedback add-on for vBulletin 3.7.x
Copyright ?2004-2008 Jason Rabel, All Rights Reserved.
__________________________________
Latest iTrader Verson: 2.1.0
vB Versions Supported: 3.7.x
Author: Jason Rabel
Contact: PM me here.
Site: EXTREME Overclocking
??????????????????????????????????
Description:
iTrader for vBulletin has evolved from Trader Ratings for vB 3.0.x which evolved from Buy/Sell/Trade User Rating System for vB 2.x. 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 somewhat based on the honor system since there is no automatic way to truly tell if they did engage in a transaction. iTrader 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 in each transaction: Buyer, Seller, or Trade
• Leave multiple comments about the deal
• Dates & IPs are all recorded to prevent abuse
• Specify a thread URL to the deal
• Advanced URL checking
• 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)
• iTrader Admins can edit/delete anyone's ratings (just incase)
• PM notification when new rating or comment is left
• Per-usergroup permissions
• Lots of admin controllable options

Installation / Upgrade Info:
Read the included readme file, it explains everything.

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

Donations:
This add-on will always be free, however your donations are kindly accepted and will help towards further development. The link is on the right under "The Developer" info.

[DsmNikki]

Installed Works Awesome Thanks

[packetattack]

Figured it out. I had to follow the version number update after doing the debug option. Works great!

Thanks!

[Digital Jedi]

Originally Posted by TimberFloorAu

We still have SQL errors, caused during and after the removal of this mod. My suggestion would be, unless your a database whizzkid, or the author actually ever posts here again, to avoid until he has answered some issues, and addressed them, and or its gone gold.

Ozzy

So far your the only one I know of who has reported any database errors. When did you encounter your first error? Are you sure you fully uninstalled? You should no longer have any tables in the database.

Technically, this isn't a BETA version, but an interim release until the full version is completed, which is reported to be an undermined amount of time. What you might have here, since I'm not hearing this to be a common problem, is a modification conflict with something else. Have you tried disabling your hacks to see if you still get the error with them all off?

[MoneyProBlog]

Originally Posted by Shazz

For whatever template you want to display it in, postbit, profile etc. The directions are inside the zip.

Use the 3.6.x version

iTrader 2.0

I don't think the instructions are going to be enough for me to get this one.

Below are the instructions inside the zip:

-----------------------------------------------------------

Two fields are added to the "user" table to facilitate rating usage pretty much anywhere you please within the forum. The two fields are:

* itrader_total - iTrader Score (stored as an integer)
* itrader_pcnt - Percent Positive Feedback (also stored as an integer)

Most likely you will want to add the score info to the postbit and/or postbit_legacy template(s), MEMBERINFO, and memberlist_resultsbit template. Actual placement and style is entirely up to you, however here's a sample to get you started. Note that the MEMBERINFO & memberlist_resultsbit templates won't need the conditional around the text since you can't view a "guest" in those cases.

<if condition="$post['userid']"><div>iTrader: (<b><a href="itrader.php?$session[sessionurl]u=$post[userid]">$post[itrader_total]</a></b>)</div></if>

Additionally it would be wise to have some sort of link that is easily accessible to your members so they can view their own ratings. My suggestion would be to add some code in the navbar or usercp menu somewhere. If no userid is specified then the system defaults to the user's own iTrader page.

<a href="itrader.php?$session[sessionurl]">iTrader</a>

Use your imagination where you want these links to be visible, there's nothing set in stone where it should be display or how it should look. Some people wanted the percent score so I added in this version. You can get creative and use some stars or something based on their score or positive ranking.

If you only wanted the info to show up for specific usegroup, you can use the "is_member_of()" function conditional in your templates. Also if you only wanted it to show up for specific forum sections, you could use the "in_array()" function. Read more in the vBulletin documentation for nifty things with template conditionals.

Sorry to skimp on the documentation, next release will be much better, however most people should know what they are doing by now with templates and if you don't, spend the time to learn as you can greatly enhance your forum.

------------------------------------------------------------------------------------------------------------

Can anybody give me the code and where to put it (in relation to the other code) for the member info and member list templates? I've never implemented a hack besides putting the initial code in the post bit legacy and inserting the vbulletin blog so I can't use my imagination on where to put it.

Shazz, Mark, and all those that have helped - thank you very much. I'm very new to this code and I am struggling.

I've tried implementing the codes suggested but none have worked - either nothing happens or it screws up the other code.

[Digital Jedi]

Originally Posted by MoneyProBlog

I don't think the instructions are going to be enough for me to get this one.

Below are the instructions inside the zip:

-----------------------------------------------------------

Two fields are added to the "user" table to facilitate rating usage pretty much anywhere you please within the forum. The two fields are:

* itrader_total - iTrader Score (stored as an integer)
* itrader_pcnt - Percent Positive Feedback (also stored as an integer)

Most likely you will want to add the score info to the postbit and/or postbit_legacy template(s), MEMBERINFO, and memberlist_resultsbit template. Actual placement and style is entirely up to you, however here's a sample to get you started. Note that the MEMBERINFO & memberlist_resultsbit templates won't need the conditional around the text since you can't view a "guest" in those cases.

<if condition="$post['userid']"><div>iTrader: (<b><a href="itrader.php?$session[sessionurl]u=$post[userid]">$post[itrader_total]</a></b>)</div></if>

Additionally it would be wise to have some sort of link that is easily accessible to your members so they can view their own ratings. My suggestion would be to add some code in the navbar or usercp menu somewhere. If no userid is specified then the system defaults to the user's own iTrader page.

<a href="itrader.php?$session[sessionurl]">iTrader</a>

Use your imagination where you want these links to be visible, there's nothing set in stone where it should be display or how it should look. Some people wanted the percent score so I added in this version. You can get creative and use some stars or something based on their score or positive ranking.

If you only wanted the info to show up for specific usegroup, you can use the "is_member_of()" function conditional in your templates. Also if you only wanted it to show up for specific forum sections, you could use the "in_array()" function. Read more in the vBulletin documentation for nifty things with template conditionals.

Sorry to skimp on the documentation, next release will be much better, however most people should know what they are doing by now with templates and if you don't, spend the time to learn as you can greatly enhance your forum.

------------------------------------------------------------------------------------------------------------

Can anybody give me the code and where to put it (in relation to the other code) for the member info and member list templates? I've never implemented a hack besides putting the initial code in the post bit legacy and inserting the vbulletin blog so I can't use my imagination on where to put it.

Shazz, Mark, and all those that have helped - thank you very much. I'm very new to this code and I am struggling.

I've tried implementing the codes suggested but none have worked - either nothing happens or it screws up the other code.

The block of code that begins with if condition, just put that anywhere in your postbit_legacy template.

[MoneyProBlog]

I have it in and working in the postbit legacy but I can't implement it anywhere else.

Thanks for the reply.

[Digital Jedi]

That block of code is only for the postbits, and not anywhere else. The next line of code in the documentation is for creating a link to iTrader everywhere else.

[TimberFloorAu]

Originally Posted by Digital Jedi

So far your the only one I know of who has reported any database errors. When did you encounter your first error? Are you sure you fully uninstalled? You should no longer have any tables in the database.

Technically, this isn't a BETA version, but an interim release until the full version is completed, which is reported to be an undermined amount of time. What you might have here, since I'm not hearing this to be a common problem, is a modification conflict with something else. Have you tried disabling your hacks to see if you still get the error with them all off?

we are getting approx 50 emails per day from our site , with itrader related error.

I have no idea why and what is causing it, we have removed the product in its entirety, and also reverted any template changes, according to reverse install procedures.


Error email we receive is thus...

Database error in vBulletin 3.7.2:

Invalid SQL:

                                       SELECT languageid,
                       phrasegroup_global AS phrasegroup_global,
                       phrasegroup_itrader AS phrasegroup_itrader,
                       phrasegroup_prefix AS phrasegroup_prefix,
                       phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
                       options AS lang_options,
                       languagecode AS lang_code,
                       charset AS lang_charset,
                       locale AS lang_locale,
                       imagesoverride AS lang_imagesoverride,
                       dateoverride AS lang_dateoverride,
                       timeoverride AS lang_timeoverride,
                       registereddateoverride AS lang_registereddateoverride,
                       calformat1override AS lang_calformat1override,
                       calformat2override AS lang_calformat2override,
                       logdateoverride AS lang_logdateoverride,
                       decimalsep AS lang_decimalsep,
                       thousandsep AS lang_thousandsep
                                       FROM yobromoflanguage
                                       WHERE languageid = 1;

MySQL Error   : Unknown column 'phrasegroup_itrader' in 'field list'
Error Number  : 1054
Request Date  : Monday, August 4th 2008 @ 06:47:20 PM
Error Date    : Monday, August 4th 2008 @ 06:47:20 PM
Script        : http://www.yobromofo.com/forum/itrader.php?u=34
Referrer      :
IP Address    : xx.xx.xx.xx
Username      :
Classname     : vB_Database
MySQL Version :

However, I have noticed, the user id is always the same.
It being one of our moderators.

Any suggestions greatly received, as its driving me mad !

[Raptor]

all installed ok - however i cannot see where / how to leave feedback ?

any clues ? Thanks

[Raptor]

ok found the link itrader_feedback.php?u=X

great mod *installed*