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)

cnczone 08-09-2004 03:47 AM

I'm using phpclassifieds insteand of the forums any hack that I can use in that situation? http://cnczone.com/classifieds/index.php

Keyser S?ze 08-09-2004 03:05 PM

think it would be possible to have a option in user options to "receive PM notification when u receive feedback"

eoc_Jason 08-09-2004 04:43 PM

I just use it with my regular FS/WTB forum sections. However I am working on a classifieds / auction hack for vBulletin (which will be free, and very easy to implement).

Quote:

Originally Posted by jamesk
THis is great,but shouldn't it be with some store or auction hack?
What are you guys using with it.


eoc_Jason 08-09-2004 04:45 PM

Edit the upgrade script to comment out the line that wants to DROP the rateduser_2 index.

I'm sure all your data is there, I'm not sure what all has been changed / updated without taking a look at it all firsthand.


Quote:

Originally Posted by Spinball
I had version 1.0.0 of this installed with vB 3.0.1.
I upgraded to vB 3.0.3, uploaded the new traderratings.php and ran the upgrade script. Clicke a couple of 'proceed type' buttons and got


I've tried re-running the script but it crashes out with another error.
Is my system fooked?


eoc_Jason 08-09-2004 04:48 PM

If they are at zero, how would you initially ever leave feedback (besides having to go to their profile page)...

There really isn't an easy way to check to see if they have left feedback but because of negative it is now at zero. You would have to modify a couple of the vB php files to join the other tables and test to see if any feedback has been left. Which is why I did the alternate by having a calculated field in the user table.

Quote:

Originally Posted by Keyser S?ze
good hack!

one thing tho, how could i make it so if someone has a rating of 0 with no ratings for negative or positive then in the post bit the trader ratings isnt there?

i have a ton of members and not that many really trade


eoc_Jason 08-09-2004 04:53 PM

I don't use PhotoPost Classifieds, nor do I care to pay for such a hack. You will have to contact the author of that hack for more info.

However I am developing my own classifieds / auction hack which will extend the usage of Trader Ratings.

This version of trader ratings was meant to be simple... As a replacement to having no ratings system in place, or the "massive trading list thread"... There could be an endless amount of features that I could put into this hack, however it's probably not going to happen as I have bigger plans for the Trader Ratings concept. In the long run there will probably be (at least) two versions. The simple / easy to implement version (this one), and the more complicated cross forum / auction-classifieds version.

EDIT - sorry for the several posts in a row. I didn't realize it has been so long since I have checked this thread and I wanted to make sure I answered each question individually.

Jason

Quote:

Originally Posted by cnczone
I'm using phpclassifieds insteand of the forums any hack that I can use in that situation? http://cnczone.com/classifieds/index.php


Skaterscafe.com 08-09-2004 05:02 PM

Great idea for a hack!

I installed it last night, but now I get several errors. The PM system does not work, when I try I get this:

Quote:

There seems to have been a slight problem with the Skateboard forums - message board for skateboarders - main forum database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience



Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=2 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Monday 09th of August 2004 12:57:48 PM
Script: http://www.skaterscafe.com/private.php?
Referer: http://www.skaterscafe.com/
Username: *********
IP Address: **********
It also appears PhotoPost quit working. PhotPost gave errors, I uploaded the upgarde hack and the error went away but now it will not upload photos.

Any ideas before I upload my backup?

Keyser S?ze 08-09-2004 07:20 PM

Quote:

Originally Posted by eoc_Jason
If they are at zero, how would you initially ever leave feedback (besides having to go to their profile page)...

There really isn't an easy way to check to see if they have left feedback but because of negative it is now at zero. You would have to modify a couple of the vB php files to join the other tables and test to see if any feedback has been left. Which is why I did the alternate by having a calculated field in the user table.


yea i noticed that after using this a few times, dont mind me while i hang my head in shame ;p


what about the "receive PM notification on new feedback"

also can i set so certain mods can edit feedback? maybe by user id

eoc_Jason 08-10-2004 02:14 AM

Most users pay very close attention to their rating once they have a couple, however I might implement an option PM notification with a reminder they need to rate that person if they haven't already.

As for allowing only certain mods to edit feedback, you will have to edit one of the tratings templates to change who sees the "edit" links, and also the traderratings.php file for who has permissions.

Quote:

Originally Posted by Keyser S?ze
what about the "receive PM notification on new feedback"

also can i set so certain mods can edit feedback? maybe by user id


oldfan 08-10-2004 05:33 PM

GREAT Add-on !!
I love to see a top 10/master feedback page.
I'm willing to throw some cash your way for it and I'm sure many others would too :)

Spinball 08-11-2004 12:00 PM

Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.

lifesourcerec 08-11-2004 12:54 PM

Quote:

Originally Posted by oldfan
GREAT Add-on !!
I love to see a top 10/master feedback page.
I'm willing to throw some cash your way for it and I'm sure many others would too :)

I'm willing to pitch in.

lifesourcerec 08-11-2004 12:55 PM

Quote:

Originally Posted by Spinball
Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.

When I upgraded to v3.0.3 from v3.0.1, I didn't have to do anything.

oldfan 08-11-2004 01:56 PM

Quote:

Originally Posted by lifesourcerec
I'm willing to pitch in.

See there two :)
eoc_Jason you got paypal?

eoc_Jason 08-11-2004 03:16 PM

Yes, one of the changes in this most recent version was the switch from a date field type to the int field type. The dates had to be regenerated in a new column, and the old column dropped, and indexes updated.

Open up the upgrade_traderratings.php file and look at the very very bottom. The script died at the part where it says:

PHP Code:

$DB_site->query("ALTER TABLE ".TABLE_PREFIX."user_rate_trade DROP INDEX rateduser_2"); 

The easiest thing to do would be to run the four SQL commands after it (assuming you do not have the rateduser_3 index) manually. Like in PHPMyAdmin, or I think you can run SQL from the vB control panel (I've never tried it that way though).

That's the reason all your dates are messed up, it's still trying to read the old date column and process it in the new format. If you still have people using the trader ratings script though, the dates will be missing for any new info that is submitted between the time you tried to update and now. If you have some PHP/MySQL skills then you might want to re-do just "Step 3" in the upgrade, but you will have to drop the datetmp column, and also might want to remove the drop's for the indexes which don't exist... ;)

oldfan - Check the first post, there is a paypal donation link. ;)

Quote:

Originally Posted by Spinball
Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.


oldfan 08-11-2004 04:08 PM

Quote:

oldfan - Check the first post, there is a paypal donation link
Go have a beer on me now :)
Lets hope ALOT more people will help to inspire you too :)

oldfan 08-12-2004 01:44 PM

Anyone else going to pitchin?

Martaigne 08-12-2004 04:56 PM

Installed, works great on the first try!

Spinball 08-14-2004 06:46 AM

Thanks for your help, Jason. Have a drink on me. Paypal clicked.

eoc_Jason 08-14-2004 04:29 PM

Glad you got it updated... ;)

the wiz 08-17-2004 01:29 AM

Having a problem, I left feedback for someone and I selected POSITIVE and it set it as neutral. I left feedback again and selected positive again and it did the same thing. I checked and it did the same when he left me feedback.

http://www.dsites.net/vb/traderratings.php?u=1

Why is it doing this?

oldfan 08-17-2004 03:09 AM

no word on a top 10 list? ;)

lifesourcerec 08-21-2004 10:24 PM

Why is it that some people can't see the hack. Log out and logging in work for some, but not others.

the wiz 08-21-2004 11:02 PM

Quote:

Originally Posted by the wiz
Having a problem, I left feedback for someone and I selected POSITIVE and it set it as neutral. I left feedback again and selected positive again and it did the same thing. I checked and it did the same when he left me feedback.

http://www.dsites.net/vb/traderratings.php?u=1

Why is it doing this?

Can anyone help me?

Mephisteus 08-24-2004 09:42 AM

I think I have seen this somewhere before, ebay maybe :) Cool hack, have no use for it, but its cool :)

eoc_Jason 08-26-2004 06:53 PM

I'm working on the stats page right now actually. Version 1.2.0 should be released hopefully this weekend. Thus far there haven't been any changes to the current templates, everything is new additions.

Quote:

Originally Posted by oldfan
no word on a top 10 list? ;)


oldfan 08-27-2004 12:29 AM

Quote:

Originally Posted by eoc_Jason
I'm working on the stats page right now actually. Version 1.2.0 should be released hopefully this weekend. Thus far there haven't been any changes to the current templates, everything is new additions.

sounds great, I can't wait to test it out :banana:

integra99 08-27-2004 01:37 AM

Quote:

Originally Posted by eoc_Jason
I'm working on the stats page right now actually. Version 1.2.0 should be released hopefully this weekend. Thus far there haven't been any changes to the current templates, everything is new additions.

What kind of changes can we expect?

eoc_Jason 08-30-2004 05:55 PM

You can preview the stats page on my site here: http://forums.extremeoverclocking.co...erratings.php?

I'm still struggling to create some *useful* tables. Obviously the "Top Rated Members" was the main highlight. The "Feedback Left For Others" as you can see mirrors the "Top Rated Members" table pretty closely. :( The "Feedback Received/Given Past Month" also seem to mirror each other closely. I'm thinking of removing those two because they just aren't that useful.

I thought about having 3 tables, listing the top buyers/sellers/traders, but even that data is semi-iffy. There's the issue of choosing the numbers by how that user rates, or by how other rate that user.

I also thought about creating a "wall of shame", listing buyers with a negative feedback score. Generally though I've noticed that once a person hits -1/-2 they don't visit the forum any more... hehe.

I dunno, any ideas / suggestions for the stats page would be greatly appreciated. There's a fine line though in what can and can't be displayed, also the amount of processing required to display some of the data.

One thing you can't see but I have added is an automated PM notification. After user A rates user B a Private Message is sent automatically letting user B know they have been rated by user A. (The PM also looks like it came from user A, so they can rate / contact them easier).

I also modified the memberlist template, to display the trader rating score next to members. This only required a simple template edit, no files. But it makes the "search" feature on the stats page a little easier to use. ;)

EDIT - Almost forgot, also made some code changes in the PHP file. Just a few cleanup things. I added a flag to where you can "close" the trader rating pages while you work on them, and only admins can view when closed.

oldfan 08-31-2004 02:30 AM

that works for me!!
I don't see it needing much more than what you have there.
Maybe adding worst rating would be a good idea, kinda like a bad trader list.
Besides that, it looks great!
Where can I get my copy :)

Ted S 08-31-2004 02:45 AM

Jason, thanks for the hard work. Has any headway been made to verrifying or at least preventing abuse (i.e. the ability to restrict users to leaving feedback only if they have X posts or have been registered for X time)? Thanks again!

eoc_Jason 08-31-2004 03:15 AM

oldfan - There has been some debate on the actual usefulness of a "bad traders" list on the stats page. Generally after a person reaches -1 (on their first deal) they are no longer seen or heard from. :(

Ted S - You can modify the templates & PHP file quite easily to restrict based on whatever criteria you want. For instance, my FS/WTB forum is only visible by a certain user group, which that user group is auto-promoted when a person reaches 100 posts. So basically I modified my templates and files to only show ratings for people in that group, and only that group is allowed to rate people. I believe I included some basic instructions in one of the text files.

Anyhow, I'm going to be out of town tomorrow. Hopefully I can button things up and get it packaged together on Wednesday. There's not as many features as I would have liked to incorporate, but it's better than nothing right now... ;)

Freezerator 08-31-2004 05:35 AM

Looks great. This stats are also perfect, maybe an option to view all members, page per page.

Ted S 08-31-2004 04:43 PM

eoc_Jason,
Good point! I've been using some simple template mods to require a min post count which seems to have improved the quality of the system. I actually just integrated photopost classifieds so now I get to figure out how to add this to that ;)

the wiz 08-31-2004 05:02 PM

So no one knows why my board is doning this?

eoc_Jason 09-01-2004 04:20 PM

Well, that's kind of why there is the memberlist built into vB, and also the member search function. ;) Just listing people with ratings wouldn't bee too helpful, for instance, my forum has over 400 people rated... at 20 per page that's over 20 pages (and growing)...

Quote:

Originally Posted by Freezerator
Looks great. This stats are also perfect, maybe an option to view all members, page per page.


eoc_Jason 09-01-2004 04:22 PM

If you installed it without modifying anything then it should work perfectly... Did you make any template changes, or modifications to the php file?

Quote:

Originally Posted by the wiz
So no one knows why my board is doning this?


the wiz 09-01-2004 04:26 PM

Quote:

Originally Posted by eoc_Jason
If you installed it without modifying anything then it should work perfectly... Did you make any template changes, or modifications to the php file?

I installed an extra style since i first installed the hack. I ran the upgrade thing after I found out about the problem (when me and another user went to exchange feedback) but it didn't fix the problem.

eoc_Jason 09-01-2004 10:52 PM

Ran what upgrade thing? You will have to be more specific. If you don't have any real data in the system, you might want to consider manually removing the templates/tables/phrases and re-installing the hack from scratch. It's really hard to diagnose these kind of problems without being able to see how everything is configured.

On another note, I was thinking about adding little stars, reflecting certain groups of positive scores (like eBay does). It really doesn't serve much of a purpose though.

Anyhow, I'm still working on the stats page, I still don't have it how I like it. That's basically the holdup for v1.2.0

Polo 09-02-2004 12:34 AM

Will install this later on ;)


All times are GMT. The time now is 01:44 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.02691 seconds
  • Memory Usage 1,852KB
  • 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
  • (1)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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