Thanks Telkman! But can you tell me where to find/how to edit the user_rate_trade table? It's not a template?

The MySQL database table by that name.

Easiest would be to use phpMyAdmin... depending on your version: Select Database from dropdown > Click table from frame on left > Click change by field in question > Edit length.

If you need to use SQL from the command line or from within the admincp, it would be something along the lines of this, but again check it first as I've not had the opportunity to test:

Well I tried to look thru the 30+ pages here and could not find it, when running the install I get the following:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT templateid FROM template WHERE title = 'tratings_display' AND styleid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Sunday 27th of March 2005 12:51:37 AM
Script: http://www.lawncafe.com/cpadmin/inst...derratings.php
Referer: http://www.lawncafe.com/cpadmin/inst...derratings.php


Any ideas?

We don't have phpMyAdmin installed so I'll have to do it from the command line or the admincp. I guess I'll run that and hope it works. I'll let you know. Thanks for your help Telkman. :)

is there any way of changing where it says traders rating (0)?

i would much rather it in the users profile than just under the podt in a blank area

see screen shot

cheers

awsome hack though ;)

I found a way to fix it

Change the template postbit

First find where you added

###############
<if condition="$post['userid']"><div>Trader Rating: (<a href="traderratings.php?$session[sessionurl]u=$post[userid]">$post[ratetradetotal]</a>)</div></if>
###############

delete it.

Now find

###############
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
<if condition="$post['field2']"><div>$vbphrase[location_perm]: $post[field2]</div></if>
<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
###############

and ADD the following line under it

###############
<if condition="$post['userid']"><div>Trader Rating: (<a href="traderratings.php?$session[sessionurl]u=$post[userid]">$post[ratetradetotal]</a>)</div></if>
###############

thats it..

If you want ill post a tut how to post the trader rating on the userpage.

what does this do mate?

who are you replying to :)

to that..(you)

and if you want i can write a quick tut on how to make the trader rating show up on the memberspage(like trader2.jpg)

nice one cheers mate if you dont mind :) the code you added above worked a treat ;)

How do mods and admins edit users feedback?
Thanks.