vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - Forum Tournaments & Ladders (https://vborg.vbsupport.ru/showthread.php?t=189375)

OneShot 11-01-2008 03:47 PM

I get the following error when clicking on the link "Team Challenges"

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM tmnt_ladder_games WHERE (u IN () OR u2 IN ()) AND finished = 0 AND accepted != -1 AND pot = 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 ') OR u2 IN ()) AND finished = 0 AND accepted != -1 AND pot = 1' at line 1
Error Number  : 1064
Request Date  : Saturday, November 1st 2008 @ 12:42:35 PM
Error Date    : Saturday, November 1st 2008 @ 12:42:36 PM
Script        : http://www.commanders-academy.com/forum/competitions.php?do=ladderteamchallenges
Referrer      : http://www.commanders-academy.com/forum/competitions.php
IP Address    : 82.113.121.16
Username      : OneShot
Classname    : vB_Database
MySQL Version : 5.0.51a-community


bananalive 11-01-2008 03:53 PM

Quote:

Originally Posted by gamerscms (Post 1657189)
Thanks for the new update banana, i will try it now and report any bugs :)

Will this update effect any current tournaments in progress?

No
Quote:

Originally Posted by gamerscms (Post 1657189)
Also you may want to remove:
Note: New Releases have temporarily been suspended see this post.

may discourage users from downloading just thought i would let you know.

thanks again for this great hack.

(Woops thanks)

Koidl 11-01-2008 03:53 PM

i still cant creat tournaments after trying to add i end on a white screen any fix for this now ?

gamerscms 11-01-2008 03:57 PM

Thanks banana for confirming my questions :)

bananalive 11-01-2008 03:58 PM

Quote:

Originally Posted by OneShot (Post 1657197)
I get the following error when clicking on the link "Team Challenges"

I'll release update shortly to fix this.

gamerscms 11-01-2008 04:07 PM

Ok all imported and working fine, cant see any issue's with the hack great work.

bananalive 11-01-2008 04:15 PM

Quote:

Originally Posted by bananalive (Post 1657211)
I'll release update shortly to fix this.

Re-uploaded vB_Competitions 2.6.1 .zip. Just re-upload the competitions.php if you are currently running 2.6.1

Revvin 11-01-2008 04:15 PM

Ladder appears to be working but when i create a tournament I get the following error:

Code:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 77824 bytes) in /home/revvin/public_html/vbtest/includes/class_dm_user.php on line 2480
It fails to create the tournament but still automatically makes the announcement post in my tournaments announcement forum. This happened in v2.5.8 and v2.6.1

gamerscms 11-01-2008 04:17 PM

Quote:

Originally Posted by Revvin (Post 1657235)
Ladder appears to be working but when i create a tournament I get the following error:

Code:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 77824 bytes) in /home/revvin/public_html/vbtest/includes/class_dm_user.php on line 2480
It fails to create the tournament but still automatically makes the announcement post in my tournaments announcement forum. This happened in v2.5.8 and v2.6.1

That error is not a error with the hack that is a server issue, you need to increase your MB edit your PHP.ini file to allow more if unsure contact your host.

Revvin 11-01-2008 04:21 PM

Thanks, will go and hit him now :up: Just seemed odd that earlier versions the tournaments worked fine

WNxWakko 11-01-2008 04:21 PM

Quote:

Originally Posted by bananalive (Post 1655949)
Your missing a column 'uod' which should have been created in version 2.5.2

I never got that update. I must have missed it. I would have grabbed the latest you had available at the time. Shouldnt updates following that also add that column? How do I get this added now?

gamerscms 11-01-2008 04:31 PM

Just thought i would point out when updating your team name it does not update on the tournament brackets that are in progress.

bananalive 11-01-2008 04:33 PM

1 Attachment(s)
Quote:

Originally Posted by WNxWakko (Post 1657242)
I never got that update. I must have missed it. I would have grabbed the latest you had available at the time. Shouldnt updates following that also add that column? How do I get this added now?

Yes it should.

Upload attached file as product and it should work.

WNxWakko 11-01-2008 04:36 PM

When I try and import that file you just attached I get this,

XML Error: Mismatched tag at Line 19

bananalive 11-01-2008 04:51 PM

1 Attachment(s)
Quote:

Originally Posted by WNxWakko (Post 1657253)
When I try and import that file you just attached I get this,

XML Error: Mismatched tag at Line 19

sorry i forgot to close <codes>

WNxWakko 11-01-2008 05:08 PM

Thanks that imported with no issue. I will have my testers do their thing.

djlotus 11-01-2008 07:35 PM

Quote:

Originally Posted by djlotus (Post 1656153)
Discovered an error when challenging someon on the ladder. If the use has a ">" or "<" in thier name, it returns and error saying the PM was not sent because user "xxxx" could not be found. For example, my username is "[>F<]djlotus", here is the error presented to someone who tries to challenge me on the ladder:

"You have successfully challenged this player. However, there was error(s) PM'ing your opponent.
The following users were not found:
[&gt
F&lt
]djlotus"

I receive the challenge, and it displays on the challeges page, however the PM is not sent.

Any ideas on w to work around this?

icekola 11-01-2008 11:48 PM

Very impressive bananalive. Quick question tho, I can promote a co-leader as leader but I can't demote him? is that a bug or not an option? Can it be added in a future version?

Also, It would be nice for a master admin to be able to admin all of it as oposed to only team leaders can admin their challenges, teams, and wutnot.

Again, I am loving this mod. Great work.

WNxWakko 11-02-2008 03:24 AM

just to note the fix worked.

I was wondering, is there a who's online feature in this? I remember reading a post about it but ive not seen that feature. Have you considering adding that and if its already there, how do I get it to work?

rob01 11-02-2008 05:28 AM

i mean this

Page generated in 0.17683 seconds with 47 queries (2 queries for uncached templates) [Server Loads: 2.37 2.42 : 2.18]
Uncached templates: gifts_list_member_nogifts (1)
Uncached templates: tmnt_profile (10)

this part -> Uncached templates: tmnt_profile (10) :(

Toupsx 11-02-2008 10:23 AM

When trying to install the new product for 2.6.1... It goes to
Importing Product, Please Wait...

[:]
and never goes. Just sits there with the page being done.. which of course means mine doesn't work now because of sql errors because it didn't finish installing..

Any reason this is happening?

SpiderFive 11-02-2008 05:37 PM

hi this hack use also competitions.php

https://vborg.vbsupport.ru/showthrea...100150&page=15

bananalive 11-02-2008 05:58 PM

Quote:

Originally Posted by icekola (Post 1657556)
Very impressive bananalive. Quick question tho, I can promote a co-leader as leader but I can't demote him? is that a bug or not an option? Can it be added in a future version?

Also, It would be nice for a master admin to be able to admin all of it as oposed to only team leaders can admin their challenges, teams, and wutnot.

Again, I am loving this mod. Great work.

Its currently not an option.
Quote:

Originally Posted by WNxWakko (Post 1657641)
just to note the fix worked.

I was wondering, is there a who's online feature in this? I remember reading a post about it but ive not seen that feature. Have you considering adding that and if its already there, how do I get it to work?

Yes, it only displays that user is viewing the modification not specific page of mod.
Quote:

Originally Posted by rob01 (Post 1657668)
i mean this

Page generated in 0.17683 seconds with 47 queries (2 queries for uncached templates) [Server Loads: 2.37 2.42 : 2.18]
Uncached templates: gifts_list_member_nogifts (1)
Uncached templates: tmnt_profile (10)

this part -> Uncached templates: tmnt_profile (10) :(

Have you updated to latest version?
Quote:

Originally Posted by Toupsx (Post 1657758)
When trying to install the new product for 2.6.1... It goes to
Importing Product, Please Wait...

[:]
and never goes. Just sits there with the page being done.. which of course means mine doesn't work now because of sql errors because it didn't finish installing..

Any reason this is happening?

Hmm, I cannot think why that would occur, might have been due to server timing out.
Quote:

Originally Posted by SpiderFive (Post 1657996)
hi this hack use also competitions.php

https://vborg.vbsupport.ru/showthrea...100150&page=15

Never noticed that modification before. Save competitions.php with new name and open product file and competitions.php and find and replace all instances of 'competitions.php'

Toupsx 11-02-2008 07:03 PM

Quote:

Originally Posted by bananalive (Post 1658008)
Hmm, I cannot think why that would occur, might have been due to server timing out.


Well.. what should I do now? I can't update to the new one apparently. .and can't install back to the old one.. and it doesn't work right now because of trying to update..

WNxWakko 11-02-2008 08:37 PM

Regarding who is online. I mean a bit that shows at the top of the competition mod showing the users viewing.

Stifmeister2 11-02-2008 09:29 PM

I still have version 2.2.1. My tournament is over now and I'm ready to upgrade. But I'm still afraid that I'l lose my current tourbeys or some database errors, since many people have posted about them...

Can you quarantee that I will not lose my old tourneys?

gamerscms 11-03-2008 12:53 AM

Quote:

Originally Posted by Stifmeister2 (Post 1658139)
I still have version 2.2.1. My tournament is over now and I'm ready to upgrade. But I'm still afraid that I'l lose my current tourbeys or some database errors, since many people have posted about them...


Can you quarantee that I will not lose my old tourneys?

You will not lose any info i have ongoing tournaments and they are still all there after the upgrade to the new version.

jdelator 11-03-2008 05:57 AM

So I searched through this thread and I am not quite certain on this.

Is tournaments just for tournaments and compeitions just for ladders? Or what is the difference between the two?

bananalive 11-03-2008 07:28 AM

Quote:

Originally Posted by Toupsx (Post 1658047)
Well.. what should I do now? I can't update to the new one apparently. .and can't install back to the old one.. and it doesn't work right now because of trying to update..

Use product-errorfix2008.xml to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Quote:

Originally Posted by WNxWakko (Post 1658110)
Regarding who is online. I mean a bit that shows at the top of the competition mod showing the users viewing.

Oh no sorry.
Quote:

Originally Posted by jdelator (Post 1658345)
So I searched through this thread and I am not quite certain on this.

Is tournaments just for tournaments and competitions just for ladders? Or what is the difference between the two?

Sorry https://vborg.vbsupport.ru/external/2010/10/8.gif vB_Competitions 2.6.1 .zip contains both tournaments and ladders. (The other file was just an old version)

p33r 11-03-2008 07:57 AM

I got to say this mod is simply awesome. We are currently using most of the features and are very happy. Diffrent categories for tournaments and ladders would be a pretty nice feature. Keep up the good work.

EHSkaRMa 11-03-2008 09:31 AM

I finally got the old version uninstalled completely. Ive installed the new version, and everything was working great. Now, when I click teams list, I get this db error:


Code:

Invalid SQL:
SELECT COUNT(*) AS countrows FROM vbtmnt_teams WHERE payment_status='Completed' AND item_number='Donation';

MySQL Error  : Unknown column 'payment_status' in 'where clause'
Error Number  : 1054


I guess its conflicting with my donation system. Why would it call on that?
Any help?

Shop 11-03-2008 11:10 AM

So we need to uninstall the old version and install 2.6.1? Do we need to delete all the ladders and tournaments in progress? I'm confused ...

bananalive 11-03-2008 11:54 AM

Quote:

Originally Posted by EHSkaRMa (Post 1658413)
I finally got the old version uninstalled completely. Ive installed the new version, and everything was working great. Now, when I click teams list, I get this db error:

Code:

Invalid SQL:
SELECT COUNT(*) AS countrows FROM vbtmnt_teams WHERE payment_status='Completed' AND item_number='Donation';

MySQL Error  : Unknown column 'payment_status' in 'where clause'
Error Number  : 1054


I guess its conflicting with my donation system. Why would it call on that?
Any help?

I'm not sure why its doing that. What donation modification are you using?
Quote:

Originally Posted by Shop (Post 1658489)
So we need to uninstall the old version and install 2.6.1? Do we need to delete all the ladders and tournaments in progress? I'm confused ...

No and no. Download archive and follow readme.txt

gamerscms 11-03-2008 01:53 PM

This mod is working perfect on our site just hitting the semi finals of a COD4 2v2 tournament.

Will we see an invite system added at a later date?

thanks again banana for your great work so far, you have saved us a lot of money in getting a custom script made.

OcR Envy 11-03-2008 02:12 PM

Quote:

invite system
Eye, still waiting on some kind of invite system/notification system. Also I'd still really like to see a way for people to report wins/loses.

p33r 11-03-2008 02:35 PM

Another idea: Teams should fullfill a social role, maybe aproach it like a Social Group? With comment's and discussions. Would be the perfect place to have important strategy meetings! Anyways, some kind of comment/discussion function on the Team pages would be nice.

(would help if it was limited to the team and mods/admins, so you could keep your important strategy for your team)

EHSkaRMa 11-03-2008 02:51 PM

[QUOTE=bananalive;1658508]I'm not sure why its doing that. What donation modification are you using?


AWCoding- Donation System LITE

https://vborg.vbsupport.ru/misc.php?...cthelp&pid=DSL


This is the one I use. Thanks for any help

bananalive 11-03-2008 05:25 PM

Quote:

Originally Posted by EHSkaRMa (Post 1658600)
Quote:

Originally Posted by bananalive (Post 1658508)
I'm not sure why its doing that. What donation modification are you using?

AWCoding- Donation System LITE

https://vborg.vbsupport.ru/misc.php?...cthelp&pid=DSL

This is the one I use. Thanks for any help

Have a go at this... it should hopefully disable Donation System for whole of tournament & ladders modification.

Open plugin 'DSL-Parse Modules'
Find...
PHP Code:

if (substr(THIS_SCRIPT,-6,6)!="verify" && !defined(IN_MKP) && substr(THIS_SCRIPT,0,4)!="dyna"

Replace With...
PHP Code:

if (substr(THIS_SCRIPT,-6,6)!="verify" && !defined(IN_MKP) && substr(THIS_SCRIPT,0,4)!="dyna" && THIS_SCRIPT!="tournament2008"


bananalive 11-03-2008 05:45 PM

v2.6.2 Just Releases...

- Fixed LMS tournament minor bug
- Added ajax edit score for LMS tournament (double click on score to edit it and click away to save it)
- Special Usergroups can add Forum Members to Any Team without confirmation from team leader or the forum member

XShava 11-03-2008 06:13 PM

Quote:

Originally Posted by bananalive (Post 1658757)
v2.6.2 Just Releases...

- Fixed LMS tournament minor bug
- Added ajax edit score for LMS tournament (double click on score to edit it and click away to save it)
- Special Usergroups can add Forum Members to Any Team without confirmation from team leader or the forum member

Instal and gets error in Team page when clik team name.

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/competitions.php on line 2987


All times are GMT. The time now is 12:21 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.02306 seconds
  • Memory Usage 1,861KB
  • 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
  • (5)bbcode_code_printable
  • (2)bbcode_php_printable
  • (25)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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