Why does the script URL link have two /forums in it?

I think I've got some bits of code I need to track down, the problem seems to occur when there is action=showpost in the query string...

Well, if there was a way to make "URL" mandatory, that would be nice. To have a forum to post the agreement, then when the transaction is completed, make them post the URL to that thread or it won't go through. If you use the "check database for dupe IPs" and screen your users, then this may be perfect.

Yes, a top x (feedback) page would be nice. That would get people moving (buying, selling, trading).

Great hack!

I have one question. Is there any way to limit the possibility to leave the feedback to a specific usergroup?

On my site, I have registered vendors that sell their products and I want only them to be rated.

Thanks!

- Alex
www.i-club.com

1. option to make URL mandatory
2. A limit to how many times an URL and be entered (one for seller, one for buyer).
3. Ability to add (Positive, Neutral, Negative) on Postbits.

Hi eoc_Jason!

I'd love to install this hack because we recently had some problems with "black sheeps" in out marketplace forum.

But I actually think, that this hack cannot work without some kind of verification system that determines, whether two users are allowed to vote for each other, or not.


My suggestion to easily achieve this is:
Two users have agreed to do some trading in a thread. Now, they can open a "rating ticket". Only if both users accept this voting ticket, they know that the other person is seriously interested in this trade! (So, if one doesn't answer yout ticket request, you don't send the item, or you don't pay until he accepted the ticket).
A ticket can be opened by every user ... but only if a ticket has been accepted by two users, these two users can actually vote for each other.
If there's no ticket, no (fun-)voting can be done.

Technically, we woult require another mysql-table with 4 fields: 'user1', 'user2', 'confirmed', 'finished'. When opening a ticket, user 1 writes his username and the name of the other user into a form, which eventually creates a new line in the mysql-table, containing the id's of both users.
Now, user 2 has to accept this ticket by pressing some button and thus setting 'confirmed' to yes.
If users want to rate each other, a query needs to be performed in order to check if there is a valid (i.e. 'confirmed') ticket available.
After the voting is done, 'finished' is set to 'yes' and the ticket is invalid now.



Something like that. :)
How do you think about this? :bunny:

This will definately be Hack of the Year :)

Hmm... So many new features, and so many changes, I think I might have to re-write this one from the ground up (but make it backwards compatible with existing data), to allow for all the new features you guys want and allow all the options to be user-set in the AdminCP (since I know some people will want certain ones whereas others wont).

Sorry it took me a while to reply, I was unable to access vB.org for a couple days (anyone else have that problem?). Also I've been very ill lately so I've mostly just been resting.

Once I recover to a state where I'm semi-aware of whats going on around me and I can sit down and take a look at all the feature requests and what will be necessary to meet these requests I will post with more info.

IF you want to use my website as a testing basis your more then welcome. The website is quite large and if it works on a site this big then it will work anywhere. I saw your name registered, glad to have yeah on board eoc Jason.

Let me know

I'm already looking forward to this! :)
Hope you'll find my "voting-ticket-system" worth to be applied.
I think this would in fact solve the missing security issues in this absolutely gread hack. :bandit:

That ticket idea would be good, but it is going to confuse a lot of people.

Yeah, I was thinking that or a way to list the positive, negative, neutral in postbit.

Can you give me the code for that? Instead of being in profile, I want to just have a separate page where I can make a "Leave Feedback" button.

1. In the next version there will be post/neu/neg feedback totals available on the postbits page with no added queries.

2. The "ticket" idea might be doable... I think more of a "make an offer" button would be better, opening up a window that would be sort of like a PM to the thread creater (seller) which the person can fill out info like the item they want to buy and the price. Then the seller can either accept the offer or reject it, and optionally close the thread (sometimes people post multiple items, so it's not always feasable to close a thread).

However, something like this would require some hacking with the PM code, adminCP (possibly), threadview, and who knows what else... I'm up to the task, but it is starting to stray from the simple hack that I intended it to be.

Anyhow, I've been swamped at work this week and when I come home I've been having to do a lot with my own website, and this weekend I will be going out of town. So it looks like v1.2 will be at least a couple weeks (if not more) down the road. I am going to try and incorporate as many features as possible that everyone has suggested (without over complicating the whole thing).

I will try to work on that bug asap with the random DB errors, I'm sorry I haven't had a chance to look at it sooner.

I really like the idea of a separate page where one can view feedbck and leave feedback as well. Nice.

Stealing from ebay, another easy addition would be possibly adding the "member since: XX/XX/XXXX" line to the feedback view, just so it would raise eyebrows easier if you see a guy with lots of positives, and he just joined. This info is located elsewhere in the forum, but just makes it easier to view in one spot with the feedback.

Or, stealing yet again, a small icon next to the trader rating in the postbit to show the levels of positive feedback without even clicking it. White star under 10 positives, blue star over 10 positives, Gold star after 100+, etc.

All should be fairly easy to impliment.

If you need any graphics, let me know, that's my thang. :)

Thank you for the hack!

I followed the instructions for version 1.11 and username in postbit is not there anymore. I do have the Lesanes hack in there. There is more stuff missing I guess.... ??

Atomic Fireball - I've been considering making the whole feedback page & feedback submission into one custom page instead of the popup window & profile page. I think this would eliminate confusion and also reduce code hacking on other files. I suppose it really wouldn't be that hard to allow for either choice, I'll be sure to include that in the next release.

Speaking of which, as for the next release guys, I can't give you any ETA since I've been so tied up with other things, perhaps since I have a 3 day weekend coming up I can sit down and work on it some. :)

Sweet, thanks for the update jason.

I'm looking forward to the next release.

Also a possibility, but I think it's even more complicated then my version. :)

You basically need one new table, some new templates and one IF-ELSE-clause in order to check if there's a record in the table. :)
(OK, a few more things, but that's just the basis).

Has it an itegration with PayPal? What would be great, like the hack Mist is working on...

I don't understand the need / requirement for this... Some of these suggestions are getting way beyond the simple scope of my original hack (which read the first post to understand why I created it). If you are looking for something with a much more powerful system, I suggest you look into either vBay, or vBTrader.

Yeah, it does have a lot of possibilities. My only suggestion is to make it more secure (making like to post mandatory, making it to a way that that link can be only used twice, etc.). It does seem a lot of people trying to re-create Ebay.

I think I found the solution to the random errors that were popping up saying user.ratetradetotal doesn't exist. If you change the SQL query in the showthread.php (step 3 in the install.txt file), instead of tacking on ",ratetradetotal" to one of the left joins, add the ",ratetradetotal" to the end of the SELECT line, and you *shouldn't* get any more errors...

This info will be corrected in the next version when I ge a chance to release it.

I'm getting this:

You are going to have to be more specific on what you doing... All I get out of that is functions.php gives an error on line 1, which doesn't tell diddley....

For some reason I cant get $post_usertraderatings to show up in the postbit. I have a skin I'm using....anyone know what I might try?

excellent hack...much thanks! i implemented it on my site at
http://www.jdmcivic.com/forums

thanks again! i've been looking for a hack just like this.

jay

Do you have any way for me to view all feedback ever left for all users? I don't mind a raw .php file by itself but just to browse while I'm perfecting how I want to use this? Thanks.

This is fantastic! Nice work, and a very easy install.

Most of my users are not very internet savvy and I would like to add a button to the bottom of each post by the pm, e-mail, www etc buttons for something like "leave feedback" then when they click that I would like it to take them to the users profile with the url of that thread already inserted into the url section of the feedback submittal.

If anyone could help me do that let me know. I just don't know how to get it to put the previous url in the feedback box, maybe it is not possible.

Never-the-less great hack!

Did you just want a "feedback" button? If so, will this one I'm attaching work for you?

I'm willing to help out on the graphics end of things if anyone needs it. Since this hack is still part of the user profile, it will essentially just go to the Profile page.

I heard Jason is going to rework this hack to make it a separate feedback page (not a pop-up style). So we may just want to wait for the new version.

In any event, I hope this graphic helps. Enjoy.

Thanks, and yes the button will help. For now I will just add that.

what about v2/0?
"somebody" promised to make it:)

There will be a v2.0, which will contain some new features, bug fixes, and various changes... However it will probably be the last one since I'm focusing more on a "heavier-duty" solution for the whole FS/WTB thing...

Sweet. I'm looking forward to it! Thanks, Jason!

Can't wait for V2.0! What do you plan for the "heavy duty" thing?

Hi,
Great hack.

Could someone tell me where I can change the words "Trader Rating" in the post bit.
For the life of me I can't find it!

I know it's comming from $post_usertraderatings but can't find the text, I just want to change the wording.

cheers.

hello...i am kinda dumb and new to this vbb thing...
could you please kindly explain to me what is
-----------------------------------------------------------------
2. Execute the following SQL Queries (Can be done in PHPMyAdmin):
-----------------------------------------------------------------

CREATE TABLE user_rate_trade (
userrateid INT(10) unsigned NOT NULL auto_increment,
rateduser INT(10) unsigned DEFAULT '0' NOT NULL,
userid INT(10) unsigned DEFAULT '0' NOT NULL,
userrating SMALLINT(6) DEFAULT '0' NOT NULL,
userbuysell TINYINT(1) DEFAULT '0' NOT NULL,
userdate DATE DEFAULT '0000-00-00' NOT NULL,
usercomments VARCHAR(80) NOT NULL,
userurl VARCHAR(255) NOT NULL,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
);

ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;

-----------------------------------------------------------------
// END Queries
-----------------------------------------------------------------

does that mean i have to get telnet software connected to my database and key in all the commands (or simply copy and paste?) i tried copy and paste, but endless errors show up and my database screwed...please...teach me how to get your hack installed in my site...thanx

run PHPMyAdmin then select your vB database then select SQL
now paste the code below but do not include the ending semi colon ; from the code above
now click go and the PHPMyAdmin will run the commands and create the table.
now do the same with the second query

thank you stu...
but what is phpmyadmin? a program i have to download?
seriously, i am learning everything from scratch now...
please help, thanks!

phpmyadmin is a "visualizer" for your MySQL database. It allows you to navigate the database in a Graphical User Interface and run queries, insert things, etc., all without having to do things in command-line format.

The ISP that hosts your forum should be able to set this up for you. There's also a hack here that allows you to run simple queries from the vBulletin ACP I think. Although, I've never used it.

Hope this info helps.