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)

GsxrTony 07-28-2003 06:28 PM

A piece of code that only allows you to have voting access after say 150 posts would be nice. This way you dont have trolls coming on and screwing with people.

GsxrTony 07-28-2003 06:48 PM

I keep trying to run the query in the txt file but I keep getting an error.

Quote:

Error
SQL-query :

CREATE TABLE user_rate (
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,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
)

MySQL said:


create command denied to user: '*********@***.******.' for table 'user_rate'
Any ideas guys

MoneyTec.Com 08-27-2003 03:08 PM

Can some post a screen shot of this users ratings? I'm looking for the one http://www.trade2win.co.uk/boards/sh...2929#post42929 uses, Is this it?

corsacrazy 10-24-2003 09:35 PM

IM THE ADMIN BUT I CANT EVEN CHOOSE WHO I WANT TO BE RATED FROM ACP i want to disable for certain users via check box !!

datainternet 10-27-2003 04:22 PM

Is it possible to see who has votet??? I saw this on a Board. When you click on the Vote-Count-Link you see who has votet.

Gio Takahashi 10-29-2003 11:35 PM

Installed th is works without a flaw, was afraid seeing how long its been since updated.

Rampag33 11-03-2003 05:21 PM

*** installed on vb232 works perfectly

How do you display the number instead of the stars?
like say you rating avarage is 4.23243 how do you display that?

Also can someone make a top 10 page for for this hacc?

BlackxRam 11-24-2003 05:18 PM

I instaled this hack now i get this error whenever i try to UPDATE my Threads

Code:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE thread SET lastpost=1064683357,replycount=10,postusername='mikediggy', postuserid='1570', lastposter='julez',attach= WHERE threadid=9587
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 'WHERE threadid=9587' at line 1

mysql error number: 1064

Date: Monday 24th of November 2003 02:14:44 PM
Script: http://forums.mogusland.com/admin/misc.php
Referer: http://forums.mogusland.com/admin/misc.php?s=


SgtSling 02-05-2004 02:28 PM

how can I make a hyperlink from postbit to pop-up window that let user to rate others like UBB board.

SgtSling 02-09-2004 09:53 PM

Quote:

Originally Posted by Nam
I have a question, how can I make a hyperlink from the rating word to pop-up window that let user to rate other like UBB board.

The only way to rate is click profile, which not too many people know, so by making the hyperlink from rating , it would be very nice. The pop up window should contains rating option only, not other information like profile and such.

Please help Exchange or anybody that knows, I've been playing around with with getinfouser_rating but couldn't figure it out.

Here is my original file:
PHP Code:

<tr>
 <
td

bgcolor
="#13486D"><normalfont><b>Rating:</b></normalfont><br><img src="images/$userratingalt="$rateuser[ratenum] Votes"><br><smallfont>$wholink</smallfont></td>
 <
td bgcolor="#13486D"> <table cellspacing="0" border="0" nowrap>
  <
form action="userrate.php" method="get">
    <
tr>
      <
td>
        <
select name="userrate"
        
onchange="window.location=('userrate.php?s=$session[sessionhash]&rateuser=$userid&userrate='+this.options[this.selectedIndex].value)">
          <
option value="-1" selected>Rate this user:</option>
          <
option value="5">Super Power</option>
          <
option value="4">Strong Power</option>
          <
option value="3">Normal Power</option>
          <
option value="2">Weak Power</option>
          <
option value="1">No Power</option>
        </
select>
        <
input type="image" src="images/go.gif" border="0" align="absbottom"><smallfont>&nbsp;(Last Power Rating: <b>$oldrating[old]</b>)</smallfont>
        </
td>
    </
tr>
  </
form>
</
table> </td>
</
tr

I have tried to change to:

PHP Code:

<tr>
<
td
bgcolor
="#13486D"><normalfont><b><a href="userrate.php?s=$session[sessionhash]&action=show&rateuser">Rating</a>:</b></normalfont><br><img src="images/$userratingalt="$rateuser[ratenum] Votes"><br><smallfont>$wholink</smallfont></td>
 <
td bgcolor="#13486D"> <table cellspacing="0" border="0" nowrap>
  <
form action="userrate.php" method="get">
    <
tr>
      <
td>
        <
select name="userrate"
        
onchange="window.location=('userrate.php?s=$session[sessionhash]&rateuser=$userid&userrate='+this.options[this.selectedIndex].value)">
          <
option value="-1" selected>Rate this user:</option>
          <
option value="5">Super Power</option>
          <
option value="4">Strong Power</option>
          <
option value="3">Normal Power</option>
          <
option value="2">Weak Power</option>
          <
option value="1">No Power</option>
        </
select>
        <
input type="image" src="images/go.gif" border="0" align="absbottom"><smallfont>&nbsp;(Last Power Rating: <b>$oldrating[old]</b>)</smallfont>
        </
td>
    </
tr>
  </
form>
</
table> </td>
</
tr

Basically I've added the line <a href="userrate.php?s=$session[sessionhash]&action=show&rateuser">Rating</a> to make the word rating become hyperlink, but that doesn't work, anybody can help?

Did anyone ever figure that out?


All times are GMT. The time now is 08:04 AM.

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.01285 seconds
  • Memory Usage 1,795KB
  • 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_code_printable
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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