smf rivals

[mo2332]

well cant figure how how to install this.


http://www.gotbase.org/smfrivals.zip?mo ... &page_id=6


the 2nd one

[bad_brain]

check the file /docs/INSTALL
you need to run the sql queries manually, via phpmyadmin for example.
make sure to backup everything, especially the database, before doing anything. the rest should be pretty self-explanatory, simply read the INSTALL file.....

[mo2332]

hmmm this is hard ok im in myphp admin now what plz guide me:)

[mo2332]

sryy for 2 post in row but i need help and b_b is on so yeh

[mo2332]

help '{

[G-Brain]

The INSTALL file should guide you, though I've spotted an error in mo2332-thought.c, please replace

Code: Select all

else {
    whine();
}

by

Code: Select all

else {
    google();
}

It's on line 1337.

[bad_brain]

when in phpmyadmin:
- pick the database
- pick "sql" from the tabs
- copy&paste the sql code from the INSTALL file in the textfield
- run the query


MAKE SURE TO BACKUP THE DATABASE FIRST!
this is done in the "export" tab...check "save as file"...

[mo2332]

Code: Select all

CREATE TABLE `smf_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 `smf_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 default '0',
  PRIMARY KEY  (`clan_id`)
);

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

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

CREATE TABLE `smf_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 `smf_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 `smf_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 `smf_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 `smf_rivals_platforms` (
  `platform_id` int(1) NOT NULL auto_increment,
  `platform_name` text,
  PRIMARY KEY  (`platform_id`)
);

CREATE TABLE `smf_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_read` int(1) NOT NULL default '0',
  `pm_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`pm_id`)
);

CREATE TABLE `smf_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 `smf_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 '0000-00-00 00:00:00',
  PRIMARY KEY  (`report_id`)
);

CREATE TABLE `smf_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`)
);

ALTER TABLE `smf_members` ADD clan_session text;


index.php


	$actionArray = array(

		'rivals' => array ( 'rivals.php', 'rivals' ),

is this the code i run?

[mo2332]

this is the error code i get

SQL query:

CREATE TABLE `smf_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` )
);

MySQL said: Documentation
#1050 - Table 'smf_rivals_clanmembers' already exists

[Big-E]

The INSTALL file should guide you, though I've spotted an error in mo2332-thought.c, please replace

Code: Select all

else {
    whine();
}

by

Code: Select all

else {
    google();
}

It's on line 1337.

Haha nice.

[mo2332]

any one know that error

[Big-E]

any one know that error

Uh, yeah the table already exists in your database - you need to remove it, or simply add the rows manually.

[mo2332]

HMM i make new data base and try

[Big-E]

HMM i make new data base and try

No, you just need to remove the table and re-add it.

[mo2332]

woot[/code]