[ABD] Sportsbook - Ultimate Soccer

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
bin2003
Registered User
Posts: 27
Joined: Thu Nov 11, 2010 6:56 am

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by bin2003 »

$tring wrote: I might have found the problem. Do you still have soccersuite mod installed?

[OPEN]

styles/prosilver_se/theme/stylesheet.css

[FIND AND REMOVE]

Code: Select all

/* Soccersuite mod */
@import url("mods/soccersuite/content.css");
@import url("mods/soccersuite/forms.css");
@import url("mods/soccersuite/colours.css");
/* end Soccersuite Mod */
Refresh template, cache and imageset.

$
Hi $tring,

I installed soccersuite before.
Yes, I didn't uninstall it fully!

Now it shows fine ;)
Thanks
User avatar
$tring
Registered User
Posts: 233
Joined: Thu Mar 31, 2011 11:30 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by $tring »

I'm currently coding some updates to the leaderboard system, so if some of you guys could go to the demo board and make some predictions for this weekend's fixtures under your own accounts, it would really help out.

$
dmbthestoned
Registered User
Posts: 25
Joined: Thu Aug 21, 2008 5:34 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by dmbthestoned »

Hello, first off i'd like to that you for the hardwork on this mod. What I have read/seen, it appears to be amazing! However, I am having a problem while installing. My board is 3.09. I used "Auto Mod" via the ACP to attempt to install this Mod. I get an error message :

One or more install actions failed. Please review the actions below, make any adjustments and retry. You may continue with the installation even though some of the actions failed. This is not recommended and may cause your board to not function correctly.


This is the only part that showed a red error.
root/install_sportsbook012.php install_sportsbook013.php Error


Any ideas or am I missing something obvious? Thankyou for the time.
User avatar
$tring
Registered User
Posts: 233
Joined: Thu Mar 31, 2011 11:30 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by $tring »

dmbthestoned wrote:Hello, first off i'd like to that you for the hardwork on this mod. What I have read/seen, it appears to be amazing! However, I am having a problem while installing. My board is 3.09. I used "Auto Mod" via the ACP to attempt to install this Mod. I get an error message :

One or more install actions failed. Please review the actions below, make any adjustments and retry. You may continue with the installation even though some of the actions failed. This is not recommended and may cause your board to not function correctly.


This is the only part that showed a red error.
root/install_sportsbook012.php install_sportsbook013.php Error


Any ideas or am I missing something obvious? Thankyou for the time.
I haven't tested on automod. That error is telling you the install instructions are wrong, which they are. The install file is currently install_sportsbook023.php

Are you able to manually install the mod? If not, I can provide updated install instructions for you, but not straight away.

$
dmbthestoned
Registered User
Posts: 25
Joined: Thu Aug 21, 2008 5:34 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by dmbthestoned »

$tring wrote:
dmbthestoned wrote:Hello, first off i'd like to that you for the hardwork on this mod. What I have read/seen, it appears to be amazing! However, I am having a problem while installing. My board is 3.09. I used "Auto Mod" via the ACP to attempt to install this Mod. I get an error message :

One or more install actions failed. Please review the actions below, make any adjustments and retry. You may continue with the installation even though some of the actions failed. This is not recommended and may cause your board to not function correctly.


This is the only part that showed a red error.
root/install_sportsbook012.php install_sportsbook013.php Error


Any ideas or am I missing something obvious? Thankyou for the time.
I haven't tested on automod. That error is telling you the install instructions are wrong, which they are. The install file is currently install_sportsbook023.php

Are you able to manually install the mod? If not, I can provide updated install instructions for you, but not straight away.

$

I was able to manually install it and everything worked perfect! Thankyou so much for the quick reply and great mod!
dmbthestoned
Registered User
Posts: 25
Joined: Thu Aug 21, 2008 5:34 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by dmbthestoned »

Encountered an issue, I tried to create a league and got this in return:
General Error
SQL ERROR [ mysql4 ]

Field 'league_id' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_sportsbook_leagues (league_name) VALUES ('test')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal_mysql->sql_error()

FILE: includes/sportsbook/acp/leagues.php
LINE: 40
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_sportsbook.php
LINE: 67
CALL: include('includes/sportsbook/acp/leagues.php')

FILE: includes/functions_module.php
LINE: 507
CALL: acp_sportsbook->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
User avatar
$tring
Registered User
Posts: 233
Joined: Thu Mar 31, 2011 11:30 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by $tring »

dmbthestoned wrote:Encountered an issue, I tried to create a league and got this in return:
General Error
SQL ERROR [ mysql4 ]

Field 'league_id' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_sportsbook_leagues (league_name) VALUES ('test')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal_mysql->sql_error()

FILE: includes/sportsbook/acp/leagues.php
LINE: 40
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_sportsbook.php
LINE: 67
CALL: include('includes/sportsbook/acp/leagues.php')

FILE: includes/functions_module.php
LINE: 507
CALL: acp_sportsbook->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Hi,

Sorry for the late reply, I was on my way out last night. The automod error you encountered was due to a typo in the install instructions. I'm glad you managed to install manually.

The default value error you have encountered has only been reported by one other person, and it seems to be due to clean installs. I'll get this debugged later.

In the meantime, your current error can be resolved by running the following query via phpMyAdmin:

Code: Select all

ALTER TABLE  `phpbb_sportsbook_leagues` CHANGE  `league_id`  `league_id` MEDIUMINT( 8 ) NOT NULL DEFAULT NULL AUTO_INCREMENT;

ALTER TABLE  `phpbb_sportsbook_teams` CHANGE  `team_id`  `team_id` MEDIUMINT( 8 ) NOT NULL DEFAULT NULL AUTO_INCREMENT;
Could you please post back and confirm that your Sportsbook functions with no errors after that database update?

Thanks
$
Markus89
Registered User
Posts: 4
Joined: Wed Aug 17, 2011 9:13 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by Markus89 »

This mod is just fantastic!
I would like to know if you have already inserted the 1-X-2 choice rather than the exact result.
If I may suggest an idea, (and if it is not too difficult) it would be nice to also include the ability to choose goals/no goals or under/over.

thanks for the work you are making!

sorry for my english :)
martinec
Registered User
Posts: 21
Joined: Sun Aug 07, 2011 7:13 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by martinec »

Hi $tring,

I found an issue with Sportsbook. I don't know how, but one user got his predictions inserted twice in database.

If you check the following snapshot of database content, you will see for fixture id from 11 to 20, we have two records :

Image
User avatar
$tring
Registered User
Posts: 233
Joined: Thu Mar 31, 2011 11:30 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by $tring »

martinec wrote:Hi $tring,

I found an issue with Sportsbook. I don't know how, but one user got his predictions inserted twice in database.

If you check the following snapshot of database content, you will see for fixture id from 11 to 20, we have two records :

Image
Hmm. That's strange. Is he seeing his predictions show twice on the fixtures page?

It may be just a freak double submit. Don't worry if his leaderboard points get messed up, just delete the duplicate instances and recalculate your leaderboard via the ACP.

I'll have a look at this

Thanks
$
User avatar
$tring
Registered User
Posts: 233
Joined: Thu Mar 31, 2011 11:30 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by $tring »

Markus89 wrote:This mod is just fantastic!
I would like to know if you have already inserted the 1-X-2 choice rather than the exact result.
If I may suggest an idea, (and if it is not too difficult) it would be nice to also include the ability to choose goals/no goals or under/over.

thanks for the work you are making!

sorry for my english :)
Hi,

1-x-2 has not been added as yet. The mod is feature frozen at the moment, but these ideas will be added in the future.

Thanks
$
martinec
Registered User
Posts: 21
Joined: Sun Aug 07, 2011 7:13 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by martinec »

Yes, the predictions appear twice on the fixture page.

I just did as you said and it's ok.

Thanks.
martinec
Registered User
Posts: 21
Joined: Sun Aug 07, 2011 7:13 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by martinec »

Hi $tring,

Another question : there is a player called "Anonymous" in the leaderboard.

And this is not a real user, but he managed to insert predictions.

What I believe is that somebody logged in, filled predictions, and somehow lost the session. Then he validated the predictions, and it was inserted as Anonymous.

Martin
User avatar
$tring
Registered User
Posts: 233
Joined: Thu Mar 31, 2011 11:30 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by $tring »

martinec wrote:Hi $tring,

Another question : there is a player called "Anonymous" in the leaderboard.

And this is not a real user, but he managed to insert predictions.

What I believe is that somebody logged in, filled predictions, and somehow lost the session. Then he validated the predictions, and it was inserted as Anonymous.

Martin
Hi Martin,

What user id is showing for the anonymous user?
martinec
Registered User
Posts: 21
Joined: Sun Aug 07, 2011 7:13 pm

Re: [BETA] phpBB Sportsbook Lite (sports prediction system)

Post by martinec »

user id = 1
Locked

Return to “[3.0.x] Abandoned MODs”