vb.org Archive - Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack)

Page 13 of 20

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack) (https://vborg.vbsupport.ru/showthread.php?t=52188)

mr.children

06-21-2003 06:34 PM

thank you...but where to find the phpmyadmin thing?
should i look it up in download.com?

Fi_InCogNiTo

06-25-2003 01:05 AM

<a href="https://www.phpmyadmin.net" target="_blank">www.phpmyadmin.net</a>

Logician

06-27-2003 06:32 AM

Why is this step needed?

Quote:

-----------------------------------------------------------------
3. Find in showthread.php (around line 58):
-----------------------------------------------------------------

LEFT JOIN user ON user.userid=post.userid

REPLACE with:

LEFT JOIN user ON user.userid=post.userid,ratetradetotal

-----------------------------------------------------------------
//END showthread.php
-----------------------------------------------------------------

As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;) and all user table fields are already received in the query in part:

PHP Code:


		
			
 user.*

So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI. :)

Les Shaw

07-04-2003 12:13 AM

Hack works well but when I click the trader rating in the thread I get a java script error ?
But no error if I click on it in the profile?

Any one have a fix for me :)

http://www.thecomputermechanics.com/forums/

8ballstudios

07-14-2003 02:48 PM

Jason,

Sorry if someone has already asked this question, I've tried to read all the messages in this thread.

Can this hack work similar to heatware.com? It looks like you have all the same features, the only difference that heatware.com allows users of several different websites to be rated (some of which are not vbulletin forums).

I plan on having a rating system for my forums (vbulletin 2.3.0 hosted), but want to make the rating system available to 4 additional sites as well (some vbulletin hosted, some not). I would do this on a seperate domain (a la heatware), not the same domain as my forums.

Is this possible?

Thanks!

Kevin

PurpleCow

07-30-2003 02:31 PM

Hello,

I am getting this error when i run the alter table query.

When i run this query

Quote:

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

I get the following error :

Quote:

SQL Error 1064
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 '; ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0

I am running on the latest version of mysql, that is almost.

Kindly help me with the right syntax.

Thank you

PurpleCow

07-30-2003 03:00 PM

Okay, sorry, I did a mistake.

I was supposed to run the ALTER Table query seperately, i suppose. I did that now and everything went fine and infact the hack is working fine on my boards now.

Thank you

/me clicks on install now

Imprezer

08-05-2003 05:22 AM

Great hack!

Installed on www.i-club.com

Feel free to use my site as a sample!

The Realist

08-20-2003 06:26 PM

Nice hack M8, well done.

ImportPassion

08-20-2003 06:33 PM

Quote:

06-27-03 at 03:32 AM Logician said this in Post #123
Why is this step needed?

As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;) and all user table fields are already received in the query in part:

PHP Code:

user.*

So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI. :)

ya, i saw that too, i just ignored it. mine has been working fine.

D

All times are GMT. The time now is 09:43 PM.

Page 13 of 20

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01247 seconds Memory Usage 1,747KB 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 (2)bbcode_php_printable (4)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 (10)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
Messages: