vBulletin Mods

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

IR15H 03 Oct 2010 12:21

Hi, had a quick check of the last few pages and don't think this has been reported before;

I'm getting a DB error when trying to view "free agents" on v4.2.3b with vB 4.0.7.
Quote:

Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT *
FROM vb_tmnt_teams
WHERE teamid IN ();

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 ')' at line 3
Error Number : 1064
Request Date : Sunday, October 3rd 2010 @ 08:16:29 AM
Error Date : Sunday, October 3rd 2010 @ 08:16:29 AM
Script : http://localhost/forum/competitions....freeagent&id=1
Referrer : http://localhost/forum/competitions.php?do=freeagents
IP Address : 192.168.1.2
Username : Dan
Classname : vB_Database
MySQL Version : 5.1.33-community-log
Other than that looking pretty nice!

WingnutWN 04 Oct 2010 01:18

Nice, suggestion for a future update - when creating the team, can you have it send out PM's to all the players you want?

bananalive 04 Oct 2010 12:07

1 Attachment(s)
Quote:

Originally Posted by IR15H (Post 2106295)
Hi, had a quick check of the last few pages and don't think this has been reported before;

I'm getting a DB error when trying to view "free agents" on v4.2.3b with vB 4.0.7.


Other than that looking pretty nice!

Upload attached file to forum directory, fix will be included in future releases

bananalive 04 Oct 2010 12:08

Quote:

Originally Posted by champendk (Post 2105946)
Thanks..

Is it posible to change tournaments so that scores are reported by users... It very high ón the wish list

It is something i am looking into.

FireflyP2C 04 Oct 2010 21:43

One important thing we have found missing is the ability for admins to delete challenges. Admins should be able to view all challenges and amend them as they see fit.

Also both teams should be allowed to delete accepted challenges if they both agree. Admins should also have these priviledges.

bananalive 04 Oct 2010 22:50

Quote:

Originally Posted by FireflyP2C (Post 2106813)
One important thing we have found missing is the ability for admins to delete challenges. Admins should be able to view all challenges and amend them as they see fit.

Also both teams should be allowed to delete accepted challenges if they both agree. Admins should also have these priviledges.

Admins can currently view all challenges. As of v4.2.4 admins will be able to delete challenges.

FireflyP2C 04 Oct 2010 22:52

Ok thanks.

champendk 04 Oct 2010 23:46

Bump

Ladder:
One more very impotent thing is to be able to set a certain time for when 2 teams can do a rematch. Normaly its set for 24 hours to secure that no one cheats. If this is not added people can play 10 times a day against a "fake" team to reach the playoff/final or whatever...

Tournament:
Add the abillity to add a date on top/bottom of each round in the tournement bracket. This could indicate when a match should be played within, if you dont want a one day tournament.

See link for example:

http://mw2.ps3.consolegaming.eu/tournaments.php?id=73

FireflyP2C 05 Oct 2010 10:41

Ok running a beta ladder to get feedback from our users. This is what we have so far.

Ticket system. A button to send a PM to a certain staff of staff members responsible for that ladder. Possibily linked to the dispute feature.

Eligibility icon. Players should have to wait 24 hours before being able to play in a match.

Admin lock team. Ability to lock a team so no other player can join. This is to prevent ringers.

Admin delete challenges.

Players delete accepted challenges if both team leader confirm.

FireflyP2C 05 Oct 2010 10:46

On a side nite, as Admin I cant view any challenges other than those regarding my own team. Any else having this problem?

ti07shadow 06 Oct 2010 23:08

umm how do I advance teams on the team tournament bracket? and dont say click the arrow. WHAT ARROW!?!?!?

And yes I gave myself all Permissions for my group including moderation permissions


https://www.vbulletin.org/forum/external/2010/10/35.png

champendk 07 Oct 2010 05:55

Upload the file from the post above, where he answer the same question :-)

http://www.vbulletin.org/forum/showp...&postcount=418

FireflyP2C 07 Oct 2010 15:43

Found a small bug.

When i goto a ladder through the different catergories I get this

http://www.play2compete.com/forums/l...p?do=view&id=7

where the Rules link displayed correctly

but if I click ladder list i get this

http://www.play2compete.com/forums/ladders.php

where the Rules link displays as text instead of a link

Any ideas how to fix this?

bananalive 07 Oct 2010 20:07

Quote:

Originally Posted by FireflyP2C (Post 2107715)
Found a small bug.

When i goto a ladder through the different catergories I get this

http://www.play2compete.com/forums/l...p?do=view&id=7

where the Rules link displayed correctly

but if I click ladder list i get this

http://www.play2compete.com/forums/ladders.php

where the Rules link displays as text instead of a link

Any ideas how to fix this?

There was a bug with the category description, displaying a ladder description instead (fixed in next version).

All links (and all other bb code) gets removed from ladders description on ladders list so that it stays tidy.

bananalive 07 Oct 2010 20:19

In next version (beta released tomorrow) new challenges will have date/time field, which links into timezones.

Team profile pages will have a new tab for upcoming challenges.

A new limit on challenging same player in same ladder is being introduced. Setting controlled in admincp options.

You can also change how ladders are ranked in admincp options.

For tournaments losing player can now report their lose, progressing their opponent to next round. (Single elimination tournaments only)

There will also some other minor changes/fixes.


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

Powered by vBulletin® Version 3.8.14
Copyright © 2023, 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.