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

A.I. BOT · Post by **A.I. BOT** » Thu Mar 27, 2008 4:01 pm

@Acc3L: You bug for Sat Mar 22, 2008 is fixed.
@gawaindc: It wont find clans that you are the leader or co-leader of. For the uploading of tickets... make a folder in your phpBB root called uploads and chmod this folder to 777 or something; try it then. Your manage tournament error is fixed, thanks to fetzer. Your mass PM error is also fixed.
@fetzer: Thanks for the manage tournament fix and the matches fix

.

ZIP Updated.

- Unexpected error '[', fixed.
- Manage tournaments bug, fixed (fetzer).
- Mass PM error, fixed.
- Matches, fixed (fetzer).
- Other misc. things.

Thanks for the replies and reports everyone

.

ecollins · Post by **ecollins** » Thu Mar 27, 2008 5:38 pm

I have worked hard trying to debug install and get this script working.

Here is where I am stuck.
Full image: https://camo.phpbb.com/655b92dbaa3aef766e2a31c2b892a071bf8e6f45/687474703a2f2f6d757465636c616e2e636f6d2f696d616765732f726976616c732e6a7067

Here is the code from that line: Line 40 is the error on rivals.php

Code: Select all

36. // Start the page outputs.
37. $http_vars	= http_vars ( );
38.
39. page_header ( );
40. include ( $phpbb_root_path . 'rivals/' . $http_vars[ 'action' ] . '.' . $phpEx );
41. page_footer ( );
41. ?>

If I could get some assistance it would be appreciated. I followed the install instructions to a tee, and all files are that are suppose to be in the rivals/ are located in there.

I have noticed that I think there is something wrong with the line 40 I just dont know what.

If I replace line 40 with

Code: Select all

include ('rivals/acp.php');

I actually get to the screen where you can add, edit, change stuff only it will not allow you to do anything.

So this is where i am.

A.I. BOT · Post by **A.I. BOT** » Thu Mar 27, 2008 5:55 pm

If you fallowed the instructions you should get links at the top of your header page of your theme and be able to click them (Create a Clan, Ladders, Rivals ACP, Clan CP & Tournaments).

Replacing that with rivals/acp.php is a bad idea

. Check to make sure you did actually make the changes, AND refresh your templates! in the phpBB ACP. It should show up then.

Thanks.

ecollins · Post by **ecollins** » Thu Mar 27, 2008 6:07 pm

yep you are right when I deactivated and reactivated the themes it worked.

(might wanna throw that in the bottom of the install page)

Thanks for the great mod, I am jut testing it on an empty board.

Benely · Post by **Benely** » Thu Mar 27, 2008 6:55 pm

Hey AI Bot, still ahving rpoblems with the Tournament report.

Also I'm working on setting this mod up to work in my environment, and theres a few thing sI need to know.

Is there a direct way of me knowing what clan a member is stright awway, as I want to dispaly the clan name in the members profile.

A.I. BOT · Post by **A.I. BOT** » Thu Mar 27, 2008 7:09 pm

What problems are you having in reporting?

To see what clan or clans a member is apart of...

Code: Select all

// Initilize the includes and variables needed.
include ( $phpbb_root_path . 'rivals/classes/class_clan.' . $phpEx );
define ( 'CLANMEMBERS_TABLE', $table_prefix . 'rivals_clanmembers' );
$clan	= new clan ( );

// Get the clans the user is apart of...
$sql	= 'SELECT * FROM ' . CLANMEMBERS_TABLE . ' WHERE member_userid = ' . $user->data[ 'user_id' ] . ' AND member_status = 1';
$result	= $db->sql_query ( $sql );

while ( $row = $db->sql_fetchrow ( $result ) )
{
	// Now, provide a template loop to display the clans.
	$template->assign_block_vars ( 'block_clans', array (
		'U_CLANNAME' => append_sid ( 'rivals.php?action=clan_profile&clan_id=' . $row[ 'member_clan' ] ),
		'S_CLANNAME' => $clan->data ( 'clan_name', $row[ 'member_clan' ] ) )
	);
}

For the template...

Code: Select all

<!-- BEGIN block_clans -->
<a href="{block_clans.U_CLANNAME}">{block_clans.S_CLANNAME}</a><br />
<!-- END block_clans -->

That will list the clans the user is apart of with links the clan's profile. If you would like, once your done your modification, you could share a howto for others

, but thats up to you.

Thanks.

Benely · Post by **Benely** » Thu Mar 27, 2008 8:36 pm

I shall do but I've modifed everything quite alot, because I've set up a feature in which you have to pay using the credits syetm to enter a tournament

But I'll share my Gamertag, Flag and soon to be this modification

Benely · Post by **Benely** » Thu Mar 27, 2008 9:24 pm

General Error
SQL ERROR [ mysql4 ]

Table 'benalec_phpbb.CLANS_TABLE' doesn't exist [1146]

SQL

SELECT * FROM CLANS_TABLE WHERE clan_id = 38

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: rivals/classes/class_clan.php
LINE: 60
CALL: dbal_mysql->sql_query()

FILE: rivals/classes/class_clan.php
LINE: 41
CALL: clan->data()

FILE: memberlist.php
LINE: 598
CALL: clan->clan()

Get that when I sue your code in the memberlists file

A.I. BOT · Post by **A.I. BOT** » Thu Mar 27, 2008 9:31 pm

Change

Code: Select all

// Initilize the includes and variables needed.
include ( $phpbb_root_path . 'rivals/classes/class_clan.' . $phpEx );
define ( 'CLANMEMBERS_TABLE', $table_prefix . 'rivals_clanmembers' );
$clan   = new clan ( );

To

Code: Select all

// Initilize the includes and variables needed.
define ( 'CLANMEMBERS_TABLE', $table_prefix . 'rivals_clanmembers' );
define ( 'CLANS_TABLE', $table_prefix . 'rivals_clans' );
include ( $phpbb_root_path . 'rivals/classes/class_clan.' . $phpEx );
$clan   = new clan ( );

Thanks.

Benely · Post by **Benely** » Thu Mar 27, 2008 9:36 pm

General Error
SQL ERROR [ mysql4 ]

Table 'benalec_phpbb.CLANLADDERS_TABLE' doesn't exist [1146]

SQL

SELECT * FROM CLANLADDERS_TABLE WHERE clan_id = 38

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: rivals/classes/class_clan.php
LINE: 65
CALL: dbal_mysql->sql_query()

FILE: rivals/classes/class_clan.php
LINE: 41
CALL: clan->data()

FILE: memberlist.php
LINE: 600
CALL: clan->clan()

Thats the error I get using the stuff you jsut said change.

I just opened the class_clans.php file and I changed:

// Get the clan's information.
$sql = 'SELECT * FROM ' . CLANS_TABLE . ' WHERE clan_id = ' . $type;
$result = $db->sql_query ( $sql );
$row = $db->sql_fetchrow ( $result );

// Get the clan's ladders.
$sql_2 = 'SELECT * FROM ' . CLANLADDERS_TABLE . ' WHERE clan_id = ' . $type;
$result_2 = $db->sql_query ( $sql_2 );

to

// Get the clan's information.
$sql = 'SELECT * FROM phpbb_rivals_clans WHERE clan_id = ' . $type;
$result = $db->sql_query ( $sql );
$row = $db->sql_fetchrow ( $result );

// Get the clan's ladders.
$sql_2 = 'SELECT * FROM phpbb_rivals_clanladders WHERE clan_id = ' . $type;
$result_2 = $db->sql_query ( $sql_2 );

The error was gone but the clan didn't display...

Acc3L · Post by **Acc3L** » Thu Mar 27, 2008 11:02 pm

When setting Win or Lose in Manage Tournaments i get

General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb_rivals_treports (report_id, report_tournament, clan_1, clan_2, clan_r1, clan_r2, report_time, clan_1id) VALUES (NULL, 4, "For The Lose", "", "win", "", NOW(), 1)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: rivals/ccp_tournaments.php
LINE: 52
CALL: dbal_mysql->sql_query()

FILE: rivals.php
LINE: 40
CALL: include('rivals/ccp_tournaments.php')

ecollins · Post by **ecollins** » Fri Mar 28, 2008 12:29 am

There is an error in rivals/acp_edittournaments.php

Code: Select all

		// Yes, delete the tournament.
		$sql	= 'DELETE FROM ' . TOURNAMENTS_TABLE . ' WHERE tournament_id = ' . $http_vars[ 'tournament_id' ];
		$db->sql_query ( $sql );

		// Delete the clans from the tournament.
		$sql	= 'DELETE FROM ' . TCLANS_TABLE . ' WHERE clan_tournament = ' . http_vars[ 'tournament_id' ];
		$db->sql_query ( $sql );

The $ is missing in front of http_vars on line 28...

should be this

Code: Select all

		// Yes, delete the tournament.
		$sql	= 'DELETE FROM ' . TOURNAMENTS_TABLE . ' WHERE tournament_id = ' . $http_vars[ 'tournament_id' ];
		$db->sql_query ( $sql );

		// Delete the clans from the tournament.
		$sql	= 'DELETE FROM ' . TCLANS_TABLE . ' WHERE clan_tournament = ' . $http_vars[ 'tournament_id' ];
		$db->sql_query ( $sql );

ecollins · Post by **ecollins** » Fri Mar 28, 2008 12:51 am

The image I submitted above about error on line 40 of rivals.php seems to still be a problem, it is resulting in all the errors shown above.

Jackanape · Post by **Jackanape** » Fri Mar 28, 2008 3:56 am

Still no demo?

I'd love to take a closer look at this before committing to test this on my dev board...I can't be the only one. i'm sure you'd get a lot more bug reports if people had a chance to peek at it first...

Acc3L · Post by **Acc3L** » Fri Mar 28, 2008 10:35 am

Here is my test board. http://dota.id.lv
Don't fuck it

advertisements