![]() |
Quote:
|
Quote:
|
Just do like he said...
Post 20 is the code Post 21 is a slight fix of the code (had somehting named wrong) Post 24 is responsible for making the above screenshot have the rankid visible for an overview Obviously you didn't do 24 right...but if you did 20/21, then you should be able to hit the edit button to the right of the rank and see a rank order section. See screenshot below. http://www.azurebloodfire.com/member...t/rank_id2.jpg |
Quote:
there's no way you can share your working ranks.php ? with possible edits to protect sensitive information ? again thanks... |
ranks.php for vBulletin 3.8.0 Release Candidate 2
(I still need to update to the latest vBulletin) Code:
<?php Also noticed something. My version is a working version. I haven't had any issues with it. However, there appears to be a typo. Any know if it is truly one or if it's intended? This occurs in a couple places: Code:
'display' => TYPE_UINT, --------------- Added [DATE]1245598267[/DATE] at [TIME]1245598267[/TIME] --------------- Quote:
As for the database, this is how mine looks on the ranks table. I just added another field with these values: http://www.azurebloodfire.com/member...t/rank_id3.jpg Hope that helps. |
sweet.... THANKS, it works now.
|
I've been working on this for several hours now trying to figure out why I get the following error. I've looked up the error code 1064 and there was some reference to 'order' as a reserved word in some versions of MySQL but I dont think 'rankorder' would cause that problem. Plus more ppl would be having the problem.
I've gone over my php code changes several times in ranks and functions_ranks to make sure it's right. Can anyone see what the problem might be? I saw some reference to the CHARSET setting but I tried different settings with no help. It's not real intuitive considering my db tables appear to default to MyISAM DEFAULT latin1_swedish_ci. Not sure why it would be swedish. I'm in the US. I digress, I'm not trying to get a MySQL lesson, just sayin. Thanks for any help. The rankorder column shows up just fine in admincp. I get this error when I try to change the rankorder on a badge. Here's the error: Quote:
|
If you take a look at the error query, you'll see you are missing commas between a couple of the values. So, go back to the instructions and copy the query exactly - with the commas - and it should work.
|
I've learned that whenever I get a syntax error for line X (9 in your example), the error is usually at the end of the previous line...8.
Line 8: display = 0 compare that to line 7 since it's basically the same, and you can see it's missing a comma. I don't think you need a comma after "rankorder = 1" though. Commas are separating all the values...not the WHERE statement. |
You guys rock! That fixed it.
I def did post 21 but obviously messed it up. Thanks again! |
I am using 4.1.2
I have completed all the steps and everything is working fine in the AdminCP the field shows up and even orders them by rank in the AdminCP and the values are going into the sql database from the new fields. However in the Forums the ranks are not ordering correctly based upon these values. I'm guessing this is the code build_ranks() function in includes/functions_ranks.php which I have re-modified several times. Yes I am rebuilding the ranks each time ,but it still seems to be ordering them the default way. After trying to solve this for awhile now I decided to post. Could something have changed in the 4.x code? Any help on this would be greatly appreciated. |
It would be best to ask in the 4.x forum. This forum is strictly for VB 3.x discussion and mixing in 4.x code will only confuse people looking for help in the future.
|
Yeah, I would start a new thread in the vB4, post exactly what you did (you can reference this thread with a link) and then ask for help.
|
Thank you, I wasn't sure if I should make a new thread in the 4.x section. For reference it was working just takes 2hrs for each change to register it's working on the forums.
|
Excellent tutorial :). Thanks for helping to solve the user-ranks sorting headache.
|
I have this mod completed and working on my localhost installation but every time I upload to the online server I get "The service is unavailable."
Please help, I have been looking for this mod for a really long time now. |
Sorry, I know this thread is old but thank you so much for the code! I'm not technical AT ALL but your instructions were super easy to follow and everything works just as it should.
|
I seriously can't believe this is still not part of the default vBulletin installation, it's been over 4 years!
|
So does this work with v4 of vB? I've searched the v4 forums for anything to do with ranks and did not find anything.
|
I suspect it would work in VB4. Main thing to check is if the "Find" code is the same in VB4, it probably is.
Don't forget to add the rankorder field to the database. |
assume that this would all need to be redone in the case of an upgrade?? say you do all this extra code and then upgrade from 4.1 to 4.2 ... all this will be replaced and have to be reworked??
|
Yes you will need to redo it in case of an upgrade. Although it is unlikely the ranks.php file changes much, if at all, between versions - so you can check first but likely get away with using the same file in various 4.x versions.
|
Thanks...
Any chance of someone offering us "less than newbies" instructions on exactly how to create the new field in the ranks table manually? --------------- Added [DATE]1387153203[/DATE] at [TIME]1387153203[/TIME] --------------- Scratch that... I just dove in on it and it seems to be working just fine. I love this community. |
Amazing Thread. Thanks for the information
|
This should work in 4.2.2 but no changes make.. still the prorder order.. someone has any ideas?
|
All times are GMT. The time now is 01:34 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|