Drumsy - Yeah, that happened to one other peson, because the indexes were missing beforehand.

You will need to manually run the following SQL statements to complete the upgrade:

Actually I just commented out those lines and refreshed the screen. Seems to have worked! :thumbup:

commented out? I hope you mean the code above the alter table lines I posted previously? You have to let it drop the old userdate table and rename the new one because of how time is stored and utilized in the new version.

Correct. I commented everything from the lines dropping those columns and above. All of the additions went through successfully.

HI

I just installed the trader rating hack, when I try to go to traderratings.php

I get this message

I made all the changes per instructions

This user has not registered and therefore does not have a profile to view.

Please advise

I fixed the first problem


he second problem I am having is the rating is above the forum post, how do I get it below the usertitle

please see this example

http://www.celebratingfathers.com/bo...hread.php?t=23

Move the traderratings code in your postbit to below the usertitle variable....

Okay, last night I couldn't sleep so I pondered on the part of making verified deals, and conceptually here's what I have come up with:

1. In your forum's FS/WTB section, whenever a user makes a new thread, the first post has an additional buton somewhere. Not sure of the name yet, maybe "Deal" or "Buy/Sell" or whatever...

2. Anyhow, people can reply to the thread as usual, however when someone agrees to purchase/sell said item, they click on the button in the first post. This does two things. First - it closes the thread and prepends the thread title with "SOLD -". Second - It creates a relationship between the user who clicked the button, and the person who posted the thread.

(Maybe have an intermediary page that confirms that they do indend to purchase/sell said item and must check a box before confirming.)

3. It will send a PM to both people, just as notification of the transaction. Also in each member's trader ratings page it will have a "pending transactions" link.

4. Under the pending transactions page it lists people who they have done the steps above. If neither person has rated each other, there will be a "cancel" button, however both parties much cancel for it to actually take place, then the original thread will automatically be reopend and title changed back. If one person rates the other, then neither can cancel the deal. They will also have a preset amount of time to rate the other person before the opportunity is lost.

5. The old rating still will still be in place, however they will be considered "unverified" deals. With the steps mentioned above, they will be considered "verified" deals, since there is a link back, they clicked the link with the knowledge of engaging in the transaction, etc...



Overall this shouldn't be too difficult to implement, and I think will enhance this hack a lot. Please give your feedback & suggestions as it's easier to make changes before I start writing/changing any code... ;)

I love it except for one minor detail that may create problems.

Say for example someone does in fact clicks the button and then decides they don't want to purchase the item. What will take place? I mean like eBay :) for example once you use Buy It Now, technically the same deal, if someone doesn't pay, they force being left negative feedback and the seller has to re-list or re-post the item.

So with this, are we making the buy/sell relationship that strict whereas the person buying will in turn have no choice after they hit the button and confirm, and they must purchase or have no choice but recieve negative feedback.

My main point is how strict in fact the button will be. I love the idea of after clicking the button it closes the thread and PMs both users but I just don't want people to be forced into deals as a result of clicking the button.

I guess actually maybe it won't matter and this whole post was meaningless because as long as you can be clear with how it will work to your forum members, it shouldn't be that much of a problem.

Ok nevermind. I decided to skip reading #4 and #5 and decided to just start typing without reading your whole post :)

That actually makes it alot better with those options and doesn't necessarily lock them into a deal.