Page 4 of 52

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

Posted: Sat Aug 11, 2007 1:46 pm
by NetBoss
could someone help me omg :(

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

Posted: Sat Aug 11, 2007 2:59 pm
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.

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

Posted: Sat Aug 11, 2007 3:12 pm
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)

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

Posted: Sun Aug 12, 2007 3:48 pm
by NetBoss
oh my god cant one help me.. this mod is now bugged on forums :(

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

Posted: Sun Aug 12, 2007 8:35 pm
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

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

Posted: Sun Aug 12, 2007 9:28 pm
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

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

Posted: Sun Aug 12, 2007 9:42 pm
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?

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

Posted: Mon Aug 13, 2007 12:43 am
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

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

Posted: Mon Aug 13, 2007 1:28 am
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

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

Posted: Mon Aug 13, 2007 7:15 am
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:

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

Posted: Mon Aug 13, 2007 6:42 pm
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.

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

Posted: Tue Aug 14, 2007 7:41 am
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

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

Posted: Tue Aug 14, 2007 6:08 pm
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.

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

Posted: Tue Aug 14, 2007 10:18 pm
by Smokeydogg
works now thanks

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

Posted: Wed Aug 15, 2007 12:25 am
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