vb.org Archive - Major Additions - Forum Tournaments & Ladders

When I attempt to use the admin submit score feature in ladders I receive the following error: Fatal error: Cannot use object of type mysqli_result as array in /home/content/*/*/*/***/html/forums/ladders.php(1673) : eval()'d code on line 19

s8glive

05-12-2009 11:00 AM

whens a update comming out with all the fixes for this addon?

vash911

05-13-2009 02:50 AM

I get a DB error when I try to swap a player during a tournament

Code:

Database error in vBulletin 3.8.2:



Invalid SQL:

UPDATE tmnt_players SET userid=12, username='Erik Anoa'i' WHERE id=28;



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 'i' WHERE id=28' at line 1

Error Number  : 1064

Request Date  : Wednesday, May 13th 2009 @ 04:48:05 AM

Error Date    : Wednesday, May 13th 2009 @ 04:48:05 AM

Script        : http://www.ocfight.net/tournaments.php?do=swapplayer&id=28

Referrer      : http://www.ocfight.net/tournaments.php?do=swapplayer&id=28

IP Address    : 216.254.74.138

Username      : Admin

Classname     : vB_Database

MySQL Version : 5.0.45-log

bananalive

05-14-2009 10:45 AM

1 Attachment(s)

Quote:

Originally Posted by vash911 (Post 1809834)

I get a DB error when I try to swap a player during a tournament

Code:

Database error in vBulletin 3.8.2:



Invalid SQL:

UPDATE tmnt_players SET userid=12, username='Erik Anoa'i' WHERE id=28;



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 'i' WHERE id=28' at line 1

Error Number  : 1064

Request Date  : Wednesday, May 13th 2009 @ 04:48:05 AM

Error Date    : Wednesday, May 13th 2009 @ 04:48:05 AM

Script        : http://www.ocfight.net/tournaments.php?do=swapplayer&id=28

Referrer      : http://www.ocfight.net/tournaments.php?do=swapplayer&id=28

IP Address    : 216.254.74.138

Username      : Admin

Classname     : vB_Database

MySQL Version : 5.0.45-log

Cheers for reporting this

I will release fixing with this fix included very soon. But fix is also included in attached file.

bananalive

05-14-2009 10:50 AM

1 Attachment(s)

Quote:

Originally Posted by setzersky (Post 1809167)

Try attached file

bananalive

05-14-2009 10:50 AM

Quote:

Originally Posted by uprentiss (Post 1808767)

i went into administrator permissions

i turned the entire tournanment n ladder options to yes

yet when i go to a forum i still cant make a tourney

Try going to tournaments.php?do=add

Booyakan

05-14-2009 07:04 PM

is there an easy way to add code myself to make members have a minimum post count to enter a tournament? or if not, if it could be added i could send a small donation if it's not a big task.

bananalive

05-15-2009 09:18 AM

Quote:

Originally Posted by Booyakan (Post 1810855)

is there an easy way to add code myself to make members have a minimum post count to enter a tournament? or if not, if it could be added i could send a small donation if it's not a big task.

Find in tournaments.php

PHP Code:


		
			
if ($_REQUEST['do'] == 'join')

{

add after

PHP Code:


		
			
if ($vbulletin->userinfo[posts] < 5)

{

print_no_permission();

}

All times are GMT. The time now is 01:05 PM.

Page 178 of 213

178

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02869 seconds Memory Usage 1,746KB 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_code_printable (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (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
Messages: