vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   User Ratings (https://vborg.vbsupport.ru/showthread.php?t=31749)

Nam 11-23-2001 06:37 PM

I'm sorry, I'm a newbie so I don't really get what you were saying. Where can put the line:

elseif ($action==rate){
eval("dooutput(\"".gettemplate('rateoption')."\"); ");
}

you told me to? what line number, under or above what in userrate.php?

Then I will have to createa template call rateoption ? What should I put HTML code in it then :confused: .

Help me whenever you have time, I'd appreciate it.

nafae 11-23-2001 09:27 PM

Works like a charm. There were a few suggestions I had that would be cool in another version or an update...

1)Ability to specify little images, ribbons or something (im using a ribbon system) instead of just text. IE: under input field you enter the number you want,
then it automatically displayes that number of images.

2)Show the "Rating:" under the users avatar and other info. That way he can "show off" his rating to other users :)


IF this is possible or easy to add that would be purty cool to have :D

SiXXGuNNZ 12-01-2001 08:15 PM

Quote:

Database error in vBulletin 2.2.0:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,style.title as styletitle
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid,ratetotal,ratenum,allowrat e
LEFT JOIN style on (user.styleid = style.styleid)
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '3019'

mysql error: Table 'forum.ratetotal' doesn't exist

mysql error number: 1146
this is what is bothering me --> mysql error: Table 'forum.ratetotal' doesn't exist

I have a "forum.user.ratetotal" tho

Dark Blaze 12-02-2001 08:53 AM

Great hack :)

Btw, trilOByte how can I make the forums look like yours for the XP, EXP, etc voting screenshot? But have it also show like your carma screenshot?

Thank you,

212rikanmofo 12-03-2001 12:39 AM

can someone help me install this mod please, i dont have phpmyadmin, im stuck at this part, please help me someone... =(

trilOByte 12-03-2001 06:35 AM

Dark Blaze, you need to use custom bar graphics that match the stats hack in order to get the same effect. I've attached the ones I made for you to DL. Just upload them to your server and overwrite the default ones.

212rikanmofo, do you have a "cpanel" or something similar provided by your webhost? If you've got php on your server (obviously must for vB) and admin acess to your domain, you should have some sort of admin panel, which will likely have PHPMyAdmin in there as a link.

trilOByte 12-03-2001 06:37 AM

Sorry Dark Blaze, forgot the attachment, here ya go...

Dark Blaze 12-03-2001 03:55 PM

Quote:

Originally posted by 212rikanmofo
can someone help me install this mod please, i dont have phpmyadmin, im stuck at this part, please help me someone... =(
212rikanmofo, as trilOByte specified, you would require a cpanel and most likely would have phpMyAdmin on your server provided by your webhost, since you have vBulletin installed.

Thus, having php support on your server, you will only need administrators access to your domain, and some sort of an Admin Panel, which will most likely have phpMyAdmin installed. If you have Administrator Access on your server, you will be able to upload the files and then run the appropriate scripts or do the required actions to install this modification/hack.

I hope this helps :)

Dark Blaze 12-03-2001 03:55 PM

Quote:

Originally posted by trilOByte
Dark Blaze, you need to use custom bar graphics that match the stats hack in order to get the same effect. I've attached the ones I made for you to DL. Just upload them to your server and overwrite the default ones.

212rikanmofo, do you have a "cpanel" or something similar provided by your webhost? If you've got php on your server (obviously must for vB) and admin acess to your domain, you should have some sort of admin panel, which will likely have PHPMyAdmin in there as a link.

Thank you very much trilOByte, I appreciate it :)

Dark Blaze 12-03-2001 03:55 PM

Quote:

Originally posted by trilOByte
Sorry Dark Blaze, forgot the attachment, here ya go...
That's ok, at least you noticed that you forgot it and attached it to your reply. Thanks once again :)

Lionel 12-24-2001 01:31 PM

The hack works fine. However I am not clear on how to use who_rated. It does not appear anywhere. Isn't that supposed to give a list of who rated a specific user?

trilOByte 12-24-2001 09:49 PM

The number of votes cast under the bar graphic, turns into an active link with a java popup, after 3 votes or more have been cast.

SirSteve 01-01-2002 06:31 PM

I would like to see this sort of thing but in a feedback style. Like in a classifieds section or a trading section... people could leave feedback about one another... know what I mean?

philliplewisuk 01-01-2002 08:05 PM

When i try and rate someone i get the error

You did not specify a valid user!

Hoffi 01-03-2002 08:21 AM

Hi,

I modified the Hack, so you can remove your rateing, if you decide not to rate any user. Till now you only can change how you rated.

And another little mod: The order in the Popup-Windows Who-rated is now by the NickName, no longer by ID.

changed files: userrate.php
changed templates: getuserinfo_rating

German version in avaible in www.exchange-board.org

Floris 01-03-2002 11:19 AM

Hi

I have a own license on vBB and I have entered my name in the customer boxes (3 input fields, and in top i entered my registration name: xiphoid > vbulletin.com) but i can't see the screenshot !

What am I missing ..

mvigod 01-10-2002 04:20 AM

Just change the url part from vbulletin.com to vbulletin.org

mvigod 01-11-2002 04:23 PM

Does anyone have a demo of this? Tried Trilobytes but don't have a test user account.

Also, does this allow one to add comments as part of feedback or just the rating only?

Erwin 01-12-2002 04:31 AM

[QUOTE]Originally posted by philliplewisuk
When i try and rate someone i get the error

You did not specify a valid user!

Erwin 01-12-2002 08:09 AM

I have removed the hack and installed it twice, with the same outcome. It might be interfering with some of my other hacks, most likely the gender hack, or the mood hack. What do you think? It's not a big problem, since the rating is counted, so I have just changed that error template to say "Vote counted, click back to return to profile" or something like that.

But it would be interesting to know if anyone else besides us two have this problem.

Erwin 01-12-2002 07:15 PM

Aha!

I figured out the problem!

You do NOT need to press the Go button to rate a member. (How stupid of me).

Just choose a rating from the drop down menu, and wait - the rating will go and you will be redirected to the correct page.

The Go button appears to be redundant (but possibly needed in older browsers).

For me, what I did was in:
getuserinfo_rating

I removed:
<input type="image" src="vbimages/go.gif" border="0" align="absbottom">

to prevent other users from clicking Go.

I manage to insert the rating bar in my postbit too, so people can be rated from the postbit.

Great hack!!! :)

Shenlong 01-13-2002 08:27 PM

NICEHACK!

great works fine, anyway

CAN SOMEONE TELL ME HOW tril0byte did that awesome karma work? plz :)

Erwin 01-14-2002 02:48 AM

How do you stop members from voting for themselves?

This is happening with my forums. Members can change their last rating by voting for themselves.

Shenlong 01-19-2002 03:37 AM

I got a question though, I still dont understand how to incorporate the image, I dont understand what he said on the 1st page, can someone make the walkthrough a little more thorough, i DLed tril0bytes imagepack and just dont know how to make it work

trilOByte 01-20-2002 07:04 AM

Quote:

Originally posted by Shenlong
I got a question though, I still dont understand how to incorporate the image, I dont understand what he said on the 1st page, can someone make the walkthrough a little more thorough, i DLed tril0bytes imagepack and just dont know how to make it work
You ftp'd the original images to the specified folder right? Well, providing the original hack works, the new images (with the same file names) are just ftp'd to the same location, to overwrite the originals - they then show up on your BB in place of the originals.

Or, are you having dificulty getting the hack to work in the first place? In that case, post what you've done and how far you'ce got. I'll see if I can help ;)

Have you...

1. executed the new SQL query?

2. Hacked
  • showthread.php
  • admin/functions.php
  • member.php
...then re-uploaded to the propper directoreies ins ascII?

3. Added the following new templates...
  • error_invaliduserrating
  • error_norate
  • error_notallowed
  • error_nousertorate
  • getuserinfo_rating
  • redirect_userrate_add
  • postbit_userrating
  • whorateduser
  • whorateduserbit
Note: In the instructions, it shows all the above templates with colons after the name - do not add the colon to the template name.

4. Did you edit the following templates...
  • find
  • modifyoptions
  • showthread
  • postbit

My advice, restore your original files and then go through the hack again, methodically, use a pen and paper to cross of a printed copy of the instructions if necessary.

Lionel 01-20-2002 11:02 PM

I installed that hack anf it worked fine. However I also installed the hidden post hack. While trying to hide a post, I got a mysql error in showthread.php

mysql error: Table 'databasename.ratetotal' doesn't exist

while investigating, I found the problem was at

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,ratetotal,ratenum,allowrat e
---------------------------------------------------------------------------------
I reverted it back by removing that line:
,ratetotal,ratenum,allowrate
and hidepost worked.
Looks like that rate user is still working. My question is: what is the importance of that line?
Notice that the error did not say databasename.user.ratetotal (which exists in table user as per installed but the error is seeinf ratetotal as a table, not a field).

How can I correct this? I am on 2.21

Thanks

Lionel 01-20-2002 11:48 PM

Quote:

Originally posted by SiXXGuNNZ


this is what is bothering me --> mysql error: Table 'forum.ratetotal' doesn't exist

I have a "forum.user.ratetotal" tho

I have exactly the same problem. See one post above.

Shenlong 01-21-2002 05:18 AM

i dont got phpmyADMIN and dont wanna install it, not good with mySQL stuff, is there anyway u can make an install file or sumtin?

squawell 01-23-2002 07:12 PM

i have one problem?

why am i only can rate user in profile page can't rate in post

am i miss something in postbit or.....

hope somebody help me~~

neal 03-03-2002 09:56 PM

Works like a charm, thank you

Bat-Man 03-07-2002 03:26 PM

Quote:

Originally posted by EXCHANGE
For example you could add sth. like this to userrate.php:

PHP Code:

elseif ($action==rate){
   eval(
"dooutput(\"".gettemplate('rateoption')."\");");


This would call the template rateoption where you could place your HTML code.

Sorry I don't have time at the moment to do kind of an addon, this is just an idea how it could work.




Quote:

Originally posted by Nam
I'm sorry, I'm a newbie so I don't really get what you were saying. Where can put the line:

elseif ($action==rate){
eval("dooutput(\"".gettemplate('rateoption')."\"); ");
}

you told me to? what line number, under or above what in userrate.php?

Then I will have to createa template call rateoption ? What should I put HTML code in it then :confused: .

Help me whenever you have time, I'd appreciate it.


I too would really like to know where to add this line to the userrate.php

Thanks in advance.

lowlight 03-08-2002 03:27 AM

Just a small issue to note... When using the /forum/online.php, if someone is rating someone else, it reports "UNKNOWN LOCATION" and the URL... You could update this hack to display the correct location, that would be great :)

Gamingforce 03-12-2002 07:55 AM

People on my message board were suggesting that those who have ratings disabled for themselves shouldn't be able to vote for anyone else. Does anyone want to work on this modification? =)

Gamingforce 03-12-2002 08:42 AM

Lol, you can't rely on others to do the work for you. Gotta do it yourself :(.

Here it is guys. Use the attached userrate.php file.

Make sure you create a new template "error_notallowedtorate" and put "You are not allowed to rate this user if others cannot rate you" or something like that. Enjoy.

freehtml 03-17-2002 01:12 PM

I had installed it and somehow the hyperlink to open the javascript window does not occur and on eof my member somehow does not display the Rating under his post

freehtml 03-17-2002 01:26 PM

Quote:

Originally posted by squawell
i have one problem?

why am i only can rate user in profile page can't rate in post

am i miss something in postbit or.....

hope somebody help me~~

I seems to have this problem too. I am using vb 2.2.4

Erwin 03-20-2002 05:03 AM

Quote:

Originally posted by Gamingforce
Lol, you can't rely on others to do the work for you. Gotta do it yourself :(.

Here it is guys. Use the attached userrate.php file.

Make sure you create a new template "error_notallowedtorate" and put "You are not allowed to rate this user if others cannot rate you" or something like that. Enjoy.

Thanks! Nice addition! :)

mewgood 03-24-2002 10:01 PM

does this work for 2.2.2?

Erwin 03-25-2002 01:32 AM

Quote:

Originally posted by mewgood
does this work for 2.2.2?
Yes.

mvigod 03-25-2002 02:32 AM

There are still no user comments from other users like ebay on this hack, right? Only votes?


All times are GMT. The time now is 02:25 PM.

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.01408 seconds
  • Memory Usage 1,832KB
  • 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
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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