vb.org Archive
Page 8 of 9 « First 67 8 9
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)
-   -   Multiple ranking System (https://vborg.vbsupport.ru/showthread.php?t=32063)

AZone 01-17-2003 03:48 PM
I tryed search files, but i'm not PHP specialist, so I need to know - where can I change it?

Thank you anyway.

TheRaven57 03-29-2003 02:53 AM
Quote:
Database error in vBulletin 2.2.1:

Invalid SQL: Select rankdetail.title from rankdetail where rankdetail.minposts <= 0 and rankdetail.rankid = ORDER BY rankdetail.minposts DESC LIMIT 1 mysql error: You have an error in your SQL syntax near 'ORDER BY rankdetail.minposts DESC LIMIT 1' at line 1
Did anybody ever discover a fix for this?

TheRaven57 03-29-2003 10:26 PM
Nevermind, I fixed the problem :) . Basically the error is in the admin/misc.php file. There you were intructed to replace a db query with:

PHP Code:
$getprofilefield=$DB_site->query_first("SELECT profilefieldid from profilefield where 1 and title = 
'Ranksystem' LIMIT 0, 1");
$gettitle=$DB_site->query_first("Select rankdetail.title from user left join userfield on user.userid = 
userfield.userid left join rankdetail on rankdetail.rankid = userfield.field" . $getprofilefield[profilefieldid] . 
" where user.userid= $userid and rankdetail.minposts <= user.posts ORDER BY rankdetail.minposts DESC LIMIT 1"); 
The error is here:
PHP Code:
userfield.field 
"userfield.field" doesn't exist, the fields are given numbers. Depending on the field number for the Rank Category ID for your indivudual board, you enter that instead. (ie. If the column where your members choose the rank category they want to use is "field6" in your database then your code should read "userfield.field6"). I hope this helps out some of you with this problem. Besides that, great hack!

Sadie Frost 04-27-2003 01:46 AM
I have the same error but it's not being fixed by adding the field number...anyone have any suggestions?

http://www.lotr-boards.com
username and password = test

Edit: Okay, figured out that it was because I set editable by user to no in phpmyadmin. I still dont' want it to show up though...any suggestions on that?

SirSteve 05-05-2003 04:15 AM
Quote:
03-11-02 at 02:06 PM Zamora said this in Post #24
OK, this should handle the viewing-"bug".

Go into member.php

find


before this statement, insert




This is all, after uploading your member.php, you should see the Jedi Knight instead of the 1
have fun!

I just reinstalled this hack on 2.3.0 (upgraded) and I cannot get this part to work but everything else seems to be...

obiwan8472 05-20-2003 10:09 PM
same problem as last post.
It just displays '1' in the Edit Profile. :(
Anyone know a fix?

Thanx

Kaelon 07-24-2003 04:30 PM
Has anyone gotten this to work with vB 2.3.0?

Kaelon 07-25-2003 03:21 PM
Tested and tried - though some features work, this hack is largely unusable because of a sharp disconnect between the ranksystem select mechanism and the database. I could find no easy way to reconcile it.

Sovereign 06-22-2004 06:36 PM
Does anyone have a rankset thing for 3.0.x?

John Crichton 07-19-2004 05:14 PM
Really Need this for verson 3... anyone..

if I knew how to write a hack Id do it my self :P


All times are GMT. The time now is 03:30 AM.
Page 8 of 9 « First 67 8 9
Show 40 post(s) from this thread on one page

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.01230 seconds
  • Memory Usage 1,740KB
  • 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
  • (2)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
  • (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