vb.org Archive - Major Additions - ibProArcade

Hi MrZeropage

Any news on the players being able to join a tournament instead of the admin having to post in there forum to get people to say they want to play the tournament.

Would be nice to have it where the admin makes the tournament and the players then click join tournament.
This would make it easyer to have more tournaments on your arcade.

I might try and include this into the vbleague system so the vbleagu will be able to have arcade tournaments too.

Those "open Tournaments" Users can join in and (based on permission) create them is planned for the next Release.

If you want some Integration in vbLeague just tell Details via PM so we can coordinate things :)

ceech

01-21-2006 04:27 PM

first of all, thanks to mrzeropage for your work.

just upgraded and i'm not sure if i did something wrong.
i went to the tournament mode and created a tournament between two users. After clicking on confirm and matching the two users to "match 1", I get a message stating that the tournament was created, but immediately after that I get the following error.

Quote:

mySQL query error: SELECT userid, username FROM user WHERE userid IN() ORDER BY userid

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 ') ORDER BY userid' at line 1
mySQL error code:
Date: Saturday 21st of January 2006 12:38:54 PM

however, when i go to the tournament page, I see that the tournament was created and the tournament works.

MrZeropage

01-21-2006 04:54 PM

Ok, to get things sorted as I was sure that damn nasty little bug was fixed and it does not show up on my two test-sites:

What exactly do you enter/click/select in the previous page in Tournament-Creation ?

Maybe you can give me AdminCP- and FTP-Access to reproduce that on your site and try to finally fix it :) If so, please contact me via PM, thx!

WNxWakko

01-21-2006 05:08 PM

What bugs or fixes or changes were done in this latest update?

MrZeropage

01-21-2006 05:09 PM

ceech

01-21-2006 05:34 PM

mrzeropage, i just pmed you.
as for what i did exactly for tournament creation
1) login to my website nustudios.com with administrator access
2) clicked "Arcade" in navbar
3) clicked "Arcade ModCP"
4) clicked "Tournament" on the left menu
5) In the Create a New Tournament section, game is Asteriod, players is 2, and I clicked Create.
6) For player 1 userID , I entered "1". For player 2 userID, I entered "2", then I clicked get users.
7) For both users, I choose "match 1" and clicked "confirm".

*** The next immediate page I see is that the tournament is created and the page will be redirected. However, after 3 seconds or so, the page displayed the error.

Quote:

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned

mySQL query error: SELECT userid, username FROM user WHERE userid IN() ORDER BY userid

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 ') ORDER BY userid' at line 1
mySQL error code:
Date: Saturday 21st of January 2006 02:32:47 PM

We apologise for any inconvenience

MrZeropage

01-21-2006 06:30 PM

Ok, please create the Tournament in the AdminCP -> Tournaments ...

Then this error-message should not appear. As it was reported in AdminCP I missed to do the same fix for the ModCP, sorry
If everything is fine within the AdminCP I will port the fix to the ModCP :)

The Notorious

01-21-2006 06:45 PM

Nice job MrZeropage, I'm gonna update my arcade asap!

Enclave

01-21-2006 07:11 PM

Quote:

Originally Posted by MrZeropage

it runs fine under the admincp, so maybe you can post the fix for the ModCP.

Thanks for the update, nice job!!!

The Notorious

01-21-2006 07:25 PM

Just updated with no problems. We'll see how it goes. Keep up with the good work.

All times are GMT. The time now is 12:55 AM.

Page 133 of 758

133

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07620 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (7)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: