[ABD] phpBB Soccersuite

[Creomire]

I first thought that i could use this mod for hockey also, but cannot, because the winning team receives 2 points instead of 3...Is tehere any way to fix this quick, because league starts at the end of september...

You can configure how many points a team recieves in the soccersuite control panel. Just click on a league to edit and change the values.

[Creomire]

How do I set this up so that only registered users can view the bookies and not guests?

Check out the soccersuite forum at http://www.olympus.creomire.com for an explanation on how to do this. This will be added as an option in the next release.

[andariell]

Creomire, thanks...I didn't know that...

The more I use this mod, the more I like it...I hope to see some update soon, for begining monthly preview of users, so I can manage forum competitions.

Thanks again, I give your mod 8/10 at the moment.

[andariell]

Just one thing: at hockey if result is DRAW, each team is given 1 point, but they play over time and the winning team is given +1 point. Example:

team 1 VS team 2, result after regular time is 2:2, Team 2 than wins after OT, and receives 2 points - team 1 receives 1 point. How to solve that?

[Creomire]

Just one thing: at hockey if result is DRAW, each team is given 1 point, but they play over time and the winning team is given +1 point. Example:

team 1 VS team 2, result after regular time is 2:2, Team 2 than wins after OT, and receives 2 points - team 1 receives 1 point. How to solve that?

This primarilly a soccer mod. Integration for other sports might require modifications to source code, but these modifications cannot be coded until the software has reached Gold release.

Thanks

[Creomire]

Creomire, thanks...I didn't know that...

The more I use this mod, the more I like it...I hope to see some update soon, for begining monthly preview of users, so I can manage forum competitions.

Thanks again, I give your mod 8/10 at the moment.

Thank you for your interest in this mod. I will try to work some monthly data into the next release, which I expect to make available within maybe 2 weeks time. Of course, it all depends on workload.

[Kami (GER)]

Hi Creomire,

I've just installed the 0.1.0-Version of your Mod. Within this installation I have some problems.

The first one is:

#
#-----[ OPEN ]------------------------------------------
#

styles/prosilver/template/overall_header.html

#
#-----[ FIND ]------------------------------------------
#

<li class="rightside">
<a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}" class="icon-faq">{L_FAQ}</a>&nbsp;

#
#-----[ IN-LINE, FIND ]------------------------------------------
#

<li class="rightside">

I did no changes in the oberall_header.html, concerning that part, but I don't find it. In my file I can only find this:

Code: Select all

			<ul class="linklist rightside">
				<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>

So, do I have to add the code after "<ul class="linklist rightside">" ?

Btw: I'm using phpbb3.0.RC5 and only prosilver style with Language Package "German (Casual Honorifics)"

Another Problem is the SQL-Query:

Code: Select all

 SQL-instruction:

CREATE TABLE `phpbb_soccersuite_config` (
`config_name` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
`config_value` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
PRIMARY KEY ( `config_name` )
)

MySQL reports: 
#1064 - 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 'collate utf8_bin NOT NULL default '',
  `config_value` varchar

So what is the problem? Or was I unable to find it here?

Sorry for quite bad english, and thanks in previous for helping.

Kami (GER)

EDIT:I asked my SQL-problem at phpbb.de, too. There I got following anwer:

The author of the mod didn't think of SQL-databases lower than 4.1.3. (....) the author also did the INSERTs in HEX-Code (...)

They tell me to update my SQL to 4.1.3 or higher, or, what would be the better way I think, to ask the MOD's author, If he could offer a SQL code supporting SQL-Databases lower than 4.1.3.

[Ragman]

Hi Creomire,

I've just installed the 0.1.0-Version of your Mod. Within this installation I have some problems.

The first one is:

So, do I have to add the code after "<ul class="linklist rightside">" ?

Btw: I'm using phpbb3.0.RC5 and only prosilver style with Language Package "German (Casual Honorifics)"

Another Problem is the SQL-Query:

Code: Select all

 SQL-instruction:

CREATE TABLE `phpbb_soccersuite_config` (
`config_name` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
`config_value` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
PRIMARY KEY ( `config_name` )
)

MySQL reports: 
#1064 - 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 'collate utf8_bin NOT NULL default '',
  `config_value` varchar

So what is the problem? Or was I unable to find it here?

Sorry for quite bad english, and thanks in previous for helping.

Kami (GER)

EDIT:I asked my SQL-problem at phpbb.de, too. There I got following anwer:

The author of the mod didn't think of SQL-databases lower than 4.1.3. (....) the author also did the INSERTs in HEX-Code (...)

They tell me to update my SQL to 4.1.3 or higher, or, what would be the better way I think, to ask the MOD's author, If he could offer a SQL code supporting SQL-Databases lower than 4.1.3.

The documentation was written for RC4. So it's a little different in RC5.
However, the answer you're looking for to your first issue is:

Yes. Just add the code after the "<ul class="linklist rightside">"
You'll also need to make a small change to the code itself.
As you can see. In the original, you'll notice that the style class is in the a href section.
In the RC5 the style class is added to the list item e.g. <li class="icon-faq">

So to fix for Soccersuite you'd need to change:

Code: Select all

<!-- IF S_SBOOK_ENABLED --><a href="{U_SPORTSBOOK}" title="{SBOOK_NAME}" class="icon-members">{SBOOK_NAME}</a>&nbsp; <!-- ENDIF -->

to this:

Code: Select all

<!-- IF S_SBOOK_ENABLED --><li class="icon-members"><a href="{U_SPORTSBOOK}" title="{SBOOK_NAME}">{SBOOK_NAME}</a></li>&nbsp; <!-- ENDIF -->

I believe that should fix it for RC5

As for the mysql issue...

What version of mysql are you running?

Not sure if it would work, but try this:

Code: Select all

CREATE TABLE `phpbb_soccersuite_config` (
`config_name` varchar( 255 ) NOT NULL default '',
`config_value` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `config_name` )
)

It worked for me when i tested the table creation.

[Kami (GER)]

Hi,

I'm running SQL 4.0.24 as far as I know.

I think the error, I postet before ist only for the first SQL-Query, so I would have to change all SQL-Queries. Another thing my Database will not support, is the "Insert into" written as HEX-Code ... I don't know if my provider can update the SQL running on the server. Maybe anyone here can help me and give a complete SQL-Instruction for SQL 4.0.24? I don't know anything about SQL ...

Greeting Kami from Germany

[Ragman]

Hi,

I'm running SQL 4.0.24 as far as I know.

I think the error, I postet before ist only for the first SQL-Query, so I would have to change all SQL-Queries. Another thing my Database will not support, is the "Insert into" written as HEX-Code ... I don't know if my provider can update the SQL running on the server. Maybe anyone here can help me and give a complete SQL-Instruction for SQL 4.0.24? I don't know anything about SQL ...

Greeting Kami from Germany

Don't worry about the inserts.

It's quite simple...

For each table created, drop the collate portions.

So your tables get created thus:

Code: Select all

    CREATE TABLE `phpbb_soccersuite_config` (
    `config_name` varchar( 255 ) NOT NULL default '',
    `config_value` varchar( 255 ) NOT NULL default '',
    PRIMARY KEY ( `config_name` )
    );

CREATE TABLE `phpbb_soccersuite_groups` (
  `group_id` mediumint(8) NOT NULL default '0',
  `group_type` tinyint(2) NOT NULL default '-1',
  UNIQUE KEY `group_id` (`group_id`)
);

CREATE TABLE `phpbb_soccersuite_leagues` (
  `league_id` smallint(5) NOT NULL auto_increment,
  `league_name` varchar(30) NOT NULL default '',
  `league_type` tinyint(2) NOT NULL default '0',
  `league_points_win` tinyint(2) NOT NULL default '3',
  `league_points_draw` tinyint(2) NOT NULL default '1',
  PRIMARY KEY  (`league_id`)
);

CREATE TABLE `phpbb_soccersuite_sbook_fixtures` (
  `fixture_id` int(11) NOT NULL auto_increment,
  `league_id` smallint(5) NOT NULL default '0',
  `fixture_type` tinyint(2) NOT NULL default '0',
  `fixture_user_id` mediumint(8) NOT NULL default '0',
  `fixture_time` int(11) NOT NULL default '0',
  `team_id_home` smallint(5) NOT NULL default '0',
  `team_id_away` smallint(5) NOT NULL default '0',
  `fixture_score_home` smallint(5) NOT NULL default '-1',
  `fixture_score_away` smallint(5) NOT NULL default '-1',
  `fixture_process_user_id` mediumint(8) NOT NULL default '-1',
  PRIMARY KEY  (`fixture_id`),
  KEY `league_id` (`league_id`),
  KEY `fixture_type` (`fixture_type`)
);

CREATE TABLE `phpbb_soccersuite_sbook_hth_team_stats` (
  `team_id` smallint(5) NOT NULL default '0',
  `team_points` mediumint(7) NOT NULL default '0',
  `team_gd` mediumint(7) NOT NULL default '0',
  `team_hp` smallint(5) NOT NULL default '0',
  `team_hw` smallint(5) NOT NULL default '0',
  `team_hl` smallint(5) NOT NULL default '0',
  `team_hd` smallint(5) NOT NULL default '0',
  `team_hf` mediumint(7) NOT NULL default '0',
  `team_ha` mediumint(7) NOT NULL default '0',
  `team_ap` smallint(5) NOT NULL default '0',
  `team_aw` smallint(5) NOT NULL default '0',
  `team_al` smallint(5) NOT NULL default '0',
  `team_ad` smallint(5) NOT NULL default '0',
  `team_af` mediumint(7) NOT NULL default '0',
  `team_aa` mediumint(7) NOT NULL default '0',
  UNIQUE KEY `team_id` (`team_id`)
);

CREATE TABLE `phpbb_soccersuite_sbook_user_bets` (
  `user_id` mediumint(8) NOT NULL default '0',
  `fixture_id` mediumint(11) NOT NULL default '0',
  `bet_home_score` tinyint(3) NOT NULL default '0',
  `bet_away_score` tinyint(3) NOT NULL default '0',
  KEY `user_id` (`user_id`)
);

CREATE TABLE `phpbb_soccersuite_sbook_user_stats` (
  `user_id` mediumint(8) NOT NULL default '0',
  `stats_predictions` int(11) NOT NULL default '0',
  `stats_fails` int(11) NOT NULL default '0',
  `stats_results` int(11) NOT NULL default '0',
  `stats_scores` int(11) NOT NULL default '0',
  `stats_points` int(11) NOT NULL default '0',
  `stats_superceded` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
);

CREATE TABLE `phpbb_soccersuite_teams` (
  `team_id` smallint(5) NOT NULL auto_increment,
  `team_name` varchar(30) NOT NULL default '',
  `league_id` smallint(5) NOT NULL default '0',
  PRIMARY KEY  (`team_id`)
);

With the HEX inserts:

Once the config table is created, you simply need to insert the following:

Code: Select all

INSERT INTO `phpbb_soccersuite_config` (config_name, config_value) 
VALUES 
('sbook_enabled', 1),
('sbook_name', 'Sportsbook'),
('sbook_result_points', 3),
('sbook_fixture_time', 54000),
('sbook_fixture_days', 31),
('sbook_time_increments', 15),
('sbook_user_stats_limit', 10),
('sbook_past_fixture_limit', 31536000),
('soccersuite_version', 'ver. 0.1.0'),
('sbook_fail_points_on', 0),
('sbook_fixture_autoclose', 86400);

That will fix it for you.

[Insomniac']

First, thanks for this Mod


2 questions :

- On my forum, it's one of my Moderator which organize all the prognostics. How give him the access to the Soccersuite Control Panel ?

- Just wanna know if a french translation exist ?


Once again : Big Thanks !

[Ragman]

First, thanks for this Mod


2 questions :

- On my forum, it's one of my Moderator which organize all the prognostics. How give him the access to the Soccersuite Control Panel ?

- Just wanna know if a french translation exist ?


Once again : Big Thanks !

There's an option to allow certain users access to the Soccersuite CP inside of the Soccersuite CP. Just go to the Users tab. You can "manager admins" for Soccersuite there.

No idea on the FR transalation. That's something Creomire would have to answer himself.

[Insomniac']

Thanks Ragman for yours answer.

- When I talk about users, in fact, I just speak about one guy and no all a rank. I don't know if it's possible or it's is foretold

- For the translation, the files witch need edition, where are they ?

- And a later thing. With the systeme (see screen) you can see the pronostics of the other members. It's one thing that people do like. Don't know too if it's foretold



I see that you can edit your pronostic. No way to oblige one shot ?


Thanks again.

[karlsemple]

Creomire Small request, might just me but do you think in the language files you could change Click %shere%s to continue. to %sClick here to continue.%s to make the whole phrase click-able, matches the rest of the forum then and makes it better for the hard of sight to notice there is a cliack-able link there

[Kami (GER)]

Hi ragman,

thanks for your help. The installation is complete now, but the problems continue ...

If I click on the Sportsbook-Icon in the Header, or even the Link to the Soccersuite Control Panel, I get the error message "Language file common.php couldn't be opened" I controled the hole install.txt again. I did all adds, also the DIY-Instructions at the end.

By the way another Question: in which file can I find the Sbortsbook-Link-Name to be changed to german?

Grettings Kami