[ABD] phpBB Rivals (Clans, Ladders & Tournaments)

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.
User avatar
NetBoss
Registered User
Posts: 38
Joined: Sat Jul 21, 2007 7:26 am
Location: Germany

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by NetBoss »

could someone help me omg :(
http://www.bwinboard.com/gaming - Lookin for cooporate!

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by A.I. BOT »

No need to post about 5 times, I'll see your message when I get online. Things seem to run fine for me except for viewing a ladder -- blank page, which is weird becauseI dont get a blank page on my install ... I'll do a fresh install later tonight and see.

User avatar
NetBoss
Registered User
Posts: 38
Joined: Sat Jul 21, 2007 7:26 am
Location: Germany

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by NetBoss »

sorry for the posts .. it was cuz il get everytime new error:)

thats the new error : http://bwinboard.com/gaming/rivals.php?module=ccp ( mysql error) how to fix this..

it comes when your clicking a clan..


and thats the second error: http://bwinboard.com/gaming/rivals.php? ... platform=1
when you click a ladder

also on tournament page is a mysql error..
ive did all right..

thats the 4th error:
when you try to delete somethin and click on Submit, then comes a blank page i mean not white forums still there but it says only "INFORMATION"


best thanks for your help!

how to fix :(

( a friend of me isntalled it to a new rc 4 forum also, and still same problems)
http://www.bwinboard.com/gaming - Lookin for cooporate!

User avatar
NetBoss
Registered User
Posts: 38
Joined: Sat Jul 21, 2007 7:26 am
Location: Germany

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by NetBoss »

oh my god cant one help me.. this mod is now bugged on forums :(
http://www.bwinboard.com/gaming - Lookin for cooporate!

LadyOfLight
Registered User
Posts: 3
Joined: Fri Jul 13, 2007 2:13 am

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by LadyOfLight »

I got this SQL error. How can I fix this?

Code: Select all

Error
SQL query: 

CREATE TABLE `phpbb_rivals_clans` (

`clan_id` int( 1 ) NOT NULL AUTO_INCREMENT ,
`clan_name` varchar( 25 ) COLLATE latin1_general_ci NOT NULL default '',
`clan_tag` varchar( 5 ) COLLATE latin1_general_ci NOT NULL default '',
`clan_contact` text,
`clan_logo` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`clan_win` int( 1 ) NOT NULL default '0',
`clan_loss` int( 1 ) NOT NULL default '0',
`clan_ties` int( 1 ) NOT NULL default '0',
`clan_ladder` int( 1 ) NOT NULL default '0',
`clan_score` int( 1 ) NOT NULL default '0',
`clan_streak` int( 1 ) NOT NULL default '0',
`clan_owner` int( 1 ) NOT NULL ,
`clan_ownerb` int( 1 ) NOT NULL ,
PRIMARY KEY ( `clan_id` ) 
);



MySQL said:  

#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 latin1_general_ci NOT NULL default '',
  `clan_tag` var

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by A.I. BOT »

LadyOfLight wrote:I got this SQL error. How can I fix this?

Code: Select all

Error
SQL query: 

CREATE TABLE `phpbb_rivals_clans` (

`clan_id` int( 1 ) NOT NULL AUTO_INCREMENT ,
`clan_name` varchar( 25 ) COLLATE latin1_general_ci NOT NULL default '',
`clan_tag` varchar( 5 ) COLLATE latin1_general_ci NOT NULL default '',
`clan_contact` text,
`clan_logo` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`clan_win` int( 1 ) NOT NULL default '0',
`clan_loss` int( 1 ) NOT NULL default '0',
`clan_ties` int( 1 ) NOT NULL default '0',
`clan_ladder` int( 1 ) NOT NULL default '0',
`clan_score` int( 1 ) NOT NULL default '0',
`clan_streak` int( 1 ) NOT NULL default '0',
`clan_owner` int( 1 ) NOT NULL ,
`clan_ownerb` int( 1 ) NOT NULL ,
PRIMARY KEY ( `clan_id` ) 
);



MySQL said:  

#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 latin1_general_ci NOT NULL default '',
  `clan_tag` var

Code: Select all

#
#-----[ SQL ]------------------------------------------
#
# Change phpbb_ prefix if yours is different!

CREATE TABLE `phpbb_rivals_clanmembers` (
  `member_id` int(1) NOT NULL auto_increment,
  `member_userid` int(1) NOT NULL,
  `member_role` text,
  `member_clan` int(1) NOT NULL,
  `member_status` int(1) NOT NULL,
  PRIMARY KEY  (`member_id`)
);

CREATE TABLE `phpbb_rivals_clans` (
  `clan_id` int(1) NOT NULL auto_increment,
  `clan_name` varchar(25) NOT NULL default '',
  `clan_tag` varchar(5) NOT NULL default '',
  `clan_contact` text,
  `clan_logo` varchar(255) NOT NULL default '',
  `clan_win` int(1) NOT NULL default '0',
  `clan_loss` int(1) NOT NULL default '0',
  `clan_ties` int(1) NOT NULL default '0',
  `clan_ladder` int(1) NOT NULL default '0',
  `clan_score` int(1) NOT NULL default '0',
  `clan_streak` int(1) NOT NULL default '0',
  `clan_owner` int(1) NOT NULL,
  `clan_ownerb` int(1) NOT NULL,
  PRIMARY KEY  (`clan_id`)
);

CREATE TABLE `phpbb_rivals_config` (
  `ticket_reciver` text
);

INSERT INTO `phpbb_rivals_config` (`ticket_reciver`) VALUES ('2');

CREATE TABLE `phpbb_rivals_ladders` (
  `ladder_id` int(1) NOT NULL auto_increment,
  `ladder_name` varchar(25) NOT NULL default '',
  `ladder_scoring` int(1) NOT NULL default '0',
  `ladder_desc` text,
  `ladder_rank` int(1) NOT NULL default '0',
  `ladder_rules` text,
  `ladder_rating` int(1) NOT NULL default '0',
  `ladder_order` text,
  `subladder_order` text,
  `ladder_parent` int(1) NOT NULL default '0',
  `ladder_platform` int(1) NOT NULL default '0',
  PRIMARY KEY  (`ladder_id`)
);

CREATE TABLE `phpbb_rivals_matches` (
  `match_id` int(1) NOT NULL auto_increment,
  `match_challenger` int(1) NOT NULL default '0',
  `match_challengee` int(1) NOT NULL default '0',
  `match_status` int(1) NOT NULL default '0',
  `match_time` text,
  `match_extra` text,
  `match_tie` int(1) NOT NULL default '0',
  `match_winner` int(1) NOT NULL default '0',
  `match_looser` int(1) NOT NULL default '0',
  PRIMARY KEY  (`match_id`)
);

CREATE TABLE `phpbb_rivals_modules` (
  `module_id` int(1) NOT NULL auto_increment,
  `module_name` text,
  `module_status` int(1) NOT NULL default '0',
  `module_dep` text,
  PRIMARY KEY  (`module_id`)
);

INSERT INTO `phpbb_rivals_modules` (`module_id`, `module_name`, `module_status`, `module_dep`) VALUES 
(1, 'acp', 1, ''),
(2, 'acpaddladder', 1, ''),
(3, 'acpaddplatform', 1, ''),
(4, 'acpaddsubladder', 1, ''),
(5, 'acpaddtournament', 1, ''),
(6, 'acpeditladders', 1, ''),
(7, 'acpeditplatforms', 1, ''),
(8, 'acpeditsubladders', 1, ''),
(9, 'acpedittournaments', 1, ''),
(10, 'acpreportmatch', 1, ''),
(11, 'acpeditclans', 1, ''),
(12, 'acpaddsponsors', 1, ''),
(13, 'ccp', 1, ''),
(14, 'ccpmatches', 1, ''),
(15, 'ccpclone', 1, ''),
(16, 'ccpmembers', 1, ''),
(17, 'ccpeditclan', 1, ''),
(20, 'ccptournaments', 1, ''),
(19, 'ccpmessages', 1, ''),
(21, 'ladders', 1, ''),
(22, 'laddersview', 1, ''),
(23, 'laddersviewsub', 1, ''),
(24, 'laddersviewclan', 1, ''),
(25, 'tournaments', 1, ''),
(26, 'tournamentsbrackets', 1, ''),
(27, 'tournamentssponsors', 1, ''),
(28, 'tournamentssignup', 1, ''),
(29, 'acpconfigure', 1, ''),
(30, 'ccpticket', 1, ''),
(31, 'ladderscreateclan', 1, '');

CREATE TABLE `phpbb_rivals_platforms` (
  `platform_id` int(1) NOT NULL auto_increment,
  `platform_name` text,
  PRIMARY KEY  (`platform_id`)
);

CREATE TABLE `phpbb_rivals_pms` (
  `pm_id` int(1) NOT NULL auto_increment,
  `pm_to` int(1) NOT NULL,
  `pm_from` int(1) NOT NULL,
  `pm_subject` text,
  `pm_message` text,
  `pm_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`pm_id`)
);

CREATE TABLE `phpbb_rivals_tournaments` (
  `tournament_id` int(1) NOT NULL auto_increment,
  `tournament_name` varchar(25) NOT NULL default '',
  `tournament_brackets` text,
  `tournament_status` int(1) NOT NULL default '0',
  `tournament_type` int(1) NOT NULL default '0',
  `tournament_dbllw` int(1) NOT NULL default '0',
  `tournament_dblww` int(1) NOT NULL default '0',
  `tournament_clans2` text,
  `tournament_state` int(1) NOT NULL default '0',
  `tournament_fclans` text,
  `tournament_clans` text,
  `tournament_winner` int(1) NOT NULL default '0',
  `tournament_info` text,
  `tournament_direction` int(1) NOT NULL default '0',
  `tournament_password` text,
  PRIMARY KEY  (`tournament_id`)
);

CREATE TABLE `phpbb_rivals_treports` (
  `report_id` int(1) NOT NULL auto_increment,
  `report_tournament` int(1) NOT NULL,
  `clan_1` int(1) NOT NULL,
  `clan_2` int(1) NOT NULL,
  `clan_r1` text,
  `clan_r2` text,
  `report_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`report_id`)
);

CREATE TABLE `phpbb_rivals_tsponsors` (
  `sponsor_id` int(1) NOT NULL auto_increment,
  `sponsor_tournament` int(1) NOT NULL,
  `sponsor_name` text,
  `sponsor_url` text,
  `sponsor_image` text,
  `sponsor_desc` text,
  PRIMARY KEY  (`sponsor_id`)
);
That should fix it for you, I'll have updated ZIP soon with fixes, really busy with work atm.

@NetBoss: What are you talking about ... dont be in such a panic, its a BETA, its gonna have it's problems until I fix them.

Thanks

LadyOfLight
Registered User
Posts: 3
Joined: Fri Jul 13, 2007 2:13 am

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by LadyOfLight »

Well that fix one problem now there is another. Thank you for taking the time to fix these and for building such a nice mod.

Code: Select all

Error
SQL query: 

CREATE TABLE `phpbb_rivals_pms` (

`pm_id` int( 1 ) NOT NULL AUTO_INCREMENT ,
`pm_to` int( 1 ) NOT NULL ,
`pm_from` int( 1 ) NOT NULL ,
`pm_subject` text,
`pm_message` text,
`pm_date` timestamp NOT NULL default CURRENT_TIMESTAMP ,
PRIMARY KEY ( `pm_id` ) 
);



MySQL said:  

#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 'CURRENT_TIMESTAMP,
PRIMARY KEY (`pm_id`)
)' at line 7 
Also I was wondering. I converted my phpbb2 forum over to phpbb3. Will I be able to use the sql tables with all of my current tournament/ladder info in this new build for phpbb3?

User avatar
Smokeydogg
Registered User
Posts: 240
Joined: Sat Dec 06, 2003 8:02 am
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by Smokeydogg »

General Error
SQL ERROR [ mysql4 ]

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 'AND member_userid = 2' at line 1 [1064]

SQL

SELECT * FROM phpbb_rivals_clanmembers WHERE member_clan = AND member_userid = 2

BACKTRACE


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

FILE: rivals/modules/mod_laddersviewclan.php
LINE: 100
CALL: dbal_mysql->sql_query()

FILE: rivals/classes/class_module.php(69) : eval()'d code
LINE: 1
CALL: mod_laddersviewclan->mod_laddersviewclan()

FILE: rivals/classes/class_module.php
LINE: 69
CALL: eval()

FILE: rivals/modules/mod_ladders.php
LINE: 38
CALL: module->load_module()

FILE: rivals/classes/class_module.php(69) : eval()'d code
LINE: 1
CALL: mod_ladders->mod_ladders()

FILE: rivals/classes/class_module.php
LINE: 69
CALL: eval()

FILE: rivals.php
LINE: 61
CALL: module->load_module()

i fixed the error with creating a clan but now i get this in the clan cp

User avatar
Smokeydogg
Registered User
Posts: 240
Joined: Sat Dec 06, 2003 8:02 am
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by Smokeydogg »

also when editing ladders and sub ladders you can only edit the last one on the list if you try to edit the others and hit submit nothing happens

User avatar
NetBoss
Registered User
Posts: 38
Joined: Sat Jul 21, 2007 7:26 am
Location: Germany

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by NetBoss »

hmm, could someone please upload his mysql database rival tables, i think im missing them and thats why i got problems.....


best thanks! :geek:
http://www.bwinboard.com/gaming - Lookin for cooporate!

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by A.I. BOT »

@LadyofLight: Strange, works for me ... what mySQL version are you running?
@SmokeyDogg: Ah, thanks ... fixed both errors you reported.

Redownload and replace the modules and their HTML files and you should be set :).
Thanks.

User avatar
Smokeydogg
Registered User
Posts: 240
Joined: Sat Dec 06, 2003 8:02 am
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by Smokeydogg »

i redownloaded the zip file and uploaded all the files over the old ones and i still get the error in clan cp

you fixed the other error though

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by A.I. BOT »

Oh I forgot to include the user table alter ... my bad :P

Code: Select all

ALTER TABLE `phpbb_users` ADD clan_session text;
Thanks, it should be fixed now.

User avatar
Smokeydogg
Registered User
Posts: 240
Joined: Sat Dec 06, 2003 8:02 am
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by Smokeydogg »

works now thanks

User avatar
Smokeydogg
Registered User
Posts: 240
Joined: Sat Dec 06, 2003 8:02 am
Contact:

Re: [BETA] phpBB Rivals (Clans, Ladders, Leagues & Tournaments)

Post by Smokeydogg »

how about lising what ladders and clans people are part of in their profile?

also i found another error

Return to the index page
General Error
SQL ERROR [ mysql4 ]

Table 'smokeydogg_xbox.INVITES_TABLE' doesn't exist [1146]

SQL

INSERT INTO INVITES_TABLE (invite_id, invite_clan, invite_to) VALUES ("NULL", "1", "")

BACKTRACE


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

FILE: rivals/modules/mod_ccpmembers.php
LINE: 169
CALL: dbal_mysql->sql_query()

FILE: rivals/modules/mod_ccpmembers.php
LINE: 28
CALL: mod_ccpmembers->handle_submit()

FILE: rivals/classes/class_module.php(69) : eval()'d code
LINE: 1
CALL: mod_ccpmembers->mod_ccpmembers()

FILE: rivals/classes/class_module.php
LINE: 69
CALL: eval()

FILE: rivals/modules/mod_ccp.php
LINE: 45
CALL: module->load_module()

FILE: rivals/classes/class_module.php(69) : eval()'d code
LINE: 1
CALL: mod_ccp->mod_ccp()

FILE: rivals/classes/class_module.php
LINE: 69
CALL: eval()

FILE: rivals.php
LINE: 61
CALL: module->load_module()

i got this when inviting someone to my clan

Locked

Return to “[3.0.x] Abandoned MODs”