vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=238945

generalclev 22 Apr 2011 18:41

Quote:

Originally Posted by bananalive (Post 2187379)
Is that happening for all the teams?

Edit: try importing attached file.

Just uploaded and that has fixed it!

Thanks for your help mate!

Marked as installed

ProFifaLeagues 22 Apr 2011 19:32

Superb work again Thanks!

Bananalive would there be any chance we could get a system for the match finder that would give members a random game to play,So when there is any more then 2 players on a singles ladder looking for games the system would auto match them up.I would be more then happy to Donate any amount needed for your work on this as this mod is becoming a Great!!!

LichtMann 23 Apr 2011 00:43

I have two suggestions for next version:

1. The possibility to add moderators for each competition, not for the whole system.

2. The possibility to edit the Rules for each competition, not for the whole system.

Do you think it will be possible?

hossgher 24 Apr 2011 15:34

hey mate, receiving the following error after upgrading to 4.3.9 from 4.2.6, any idea what i can do?

Quote:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN tmnt_ladders AS leagues
ON (cats.catid = leagues.catid AND leagues.league > 0)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;

MySQL Error : Unknown column 'ladders.league' in 'on clause'
Error Number : 1054
Request Date : Sunday, April 24th 2011 @ 09:27:58 AM
Error Date : Sunday, April 24th 2011 @ 09:27:58 AM
Script : http://www.teamichor.net/tournaments.php
i read earlier that this was fixed in 4.3.8, is there a hotfix that i can apply to 4.3.9? thanks in advance!

bananalive 24 Apr 2011 15:47

1 Attachment(s)
Quote:

Originally Posted by hossgher (Post 2188125)
hey mate, receiving the following error after upgrading to 4.3.9 from 4.2.6, any idea what i can do?



i read earlier that this was fixed in 4.3.8, is there a hotfix that i can apply to 4.3.9? thanks in advance!

You may be missing some columns in your mysql forum database. Did you import the v4.3.9 product file without any errors?

Try importing attached file.

hossgher 24 Apr 2011 16:07

thanks mate it worked a treat, appreciate your prompt reply and love your work!

Gamelobby 25 Apr 2011 18:57

When i go to "League List"
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

It shows ladder categories. (is that the correct way it works.?)


I fully understand Ladders, & Tournaments, but the "Seasons", & "Leagues" are really confusing.


Also i think description should go back up to the title area rather than down beloew in a tab. imo

.

stwan 26 Apr 2011 16:36

Quote:

Originally Posted by bananalive (Post 2187015)
2. Is this just since an upgrade to vbulletin v4.1.3? or did it not show on vbulletin v4.1.2?

Do not know, I've noticed this bug only in 4.1.3

bananalive 27 Apr 2011 15:08

Quote:

Originally Posted by Gamelobby (Post 2188548)
When i go to "League List"
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

It shows ladder categories. (is that the correct way it works.?)

Yes.


Quote:

I fully understand Ladders, & Tournaments, but the "Seasons", & "Leagues" are really confusing.
Seasons - allow you to link ladders/leagues together. So if you run the same ladder each month, then you can contain them all in a seasons group. Then the previous ladders are easier to find. Seasons are completely optional.

Leagues are similar to ladders, apart from players/teams cannot choose how they play, instead they are allocated an opponent.

Quote:

Also i think description should go back up to the title area rather than down beloew in a tab. imo


It's an option in vBulletin Options:
  • Ladder Description as Tab
  • Tournament Description as Tab

ProFifaLeagues 28 Apr 2011 10:19

I have just noticed that some match reports comments dont appear to show up after making them on ladder matches any ideas???

It just says No comments yet...

Daisuke Niwa 28 Apr 2011 19:37

Hey! Heads up, I think I found a potential exploit that would allow for SQL Injection with the username. We encountered this error with a member who likes to use apostrophe's in their username:

Quote:

Invalid SQL:
SELECT COUNT(*) AS countrows FROM tmnt_ladder_players WHERE lid='1' AND (userid='4043' OR username='.:'Xari') AND active=1;

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 'Xari') AND active=1' at line 1

Luckily the user's name wasn't " justanothermember'; DROP TABLE users; -- " or similar.


Is there any way to sanitize the username input without breaking the entire mod?

bananalive 28 Apr 2011 20:36

Quote:

Originally Posted by Daisuke Niwa (Post 2189766)
Hey! Heads up, I think I found a potential exploit that would allow for SQL Injection with the username. We encountered this error with a member who likes to use apostrophe's in their username:




Luckily the user's name wasn't " justanothermember'; DROP TABLE users; -- " or similar.


Is there any way to sanitize the username input without breaking the entire mod?

Fixed in v4.4.0 (attached in first post).

If you still encounter this mysql error, can you pm/email me the page which is causing it, thanks.

bananalive 28 Apr 2011 20:37

Quote:

Originally Posted by rammieone (Post 2189599)
I have just noticed that some match reports comments dont appear to show up after making them on ladder matches any ideas???

It just says No comments yet...

There was a limit on the comment query by mistake, fixed in v4.4.0

ProFifaLeagues 28 Apr 2011 20:41

Thank again Banana :)

ProFifaLeagues 28 Apr 2011 20:51

Updated and thats fixed my issues thank you!!!


All times are GMT. The time now is 15:18.

Powered by vBulletin® Version 3.8.14
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.