Frage zum Group Rank Hack

Bender3k · Beitrag von **Bender3k** » 21.06.2003 15:32

Moin Moin!

Habe mir den Group Rank Hack 1.0.3 installiert.

Bekomme folgende Fehlermeldung:

Parse error: parse error in admin_ranks.php on line 221

Hier ein Auszug meiner admin_ranks.php

// ADDED ', rank_group = $group' BY Group Rank Hack
				WHERE rank_id = $rank_id";

			$message = $lang['Rank_updated'];
		}
		else
		{
			$sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image, rank_group)
				VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "')";, $group
// ADDED ', rank_group' ', $group' BY Group Rank Hack

			$message = $lang['Rank_added'];
		}
		
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, "Couldn't update/insert into ranks table", "", __LINE__, __FILE__, $sql);
		}

		$message .= "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href=\"" . append_sid("admin_ranks.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

		message_die(GENERAL_MESSAGE, $message);

	}
	else if( $mode == "delete" )
	{
		//
		// Ok, they want to delete their rank
		//
		
		if( isset($HTTP_POST_VARS['id']) || isset($HTTP_GET_VARS['id']) )
		{
			$rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : intval($HTTP_GET_VARS['id']);
		}
		else
		{
			$rank_id = 0;
		}
		
		if( $rank_id )
		{
			$sql = "DELETE FROM " . RANKS_TABLE . "
				WHERE rank_id = $rank_id";
			
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Couldn't delete rank data", "", __LINE__, __FILE__, $sql);
			}
			
			$sql = "UPDATE " . USERS_TABLE . " 
				SET user_rank = 0 
				WHERE user_rank = $rank_id";

			if( !$result = $db->sql_query($sql) ) 
			{
				message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql);
			}

			$message = $lang['Rank_removed'] . "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href=\"" . append_sid("admin_ranks.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

			message_die(GENERAL_MESSAGE, $message);

		}
		else
		{
			message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
		}
	}
	else
	{
		//
		// They didn't feel like giving us any information. Oh, too bad, we'll just display the
		// list then...
		//
		$template->set_filenames(array(
			"body" => "admin/ranks_list_body.tpl")
		);
		
		$sql = "SELECT r.*, g.group_name
			FROM " . RANKS_TABLE . " r
				LEFT JOIN " . GROUPS_TABLE . " g ON g.group_id = r.rank_group
			ORDER BY r.rank_special DESC, rank_group ASC, r.rank_min ASC"; // ADDED 'r.' AND ', g.group_name' AND 'r LEFT JOIN " . GROUPS_TABLE . " g ON g.group_id = r.rank_group' AND 'rank_group ASC, ' BY Group Rank Hack
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, "Couldn't obtain ranks data", "", __LINE__, __FILE__, $sql);
		}
		
		$rank_rows = $db->sql_fetchrowset($result);
		$rank_count = count($rank_rows);
		
		$template->assign_vars(array(
			"L_RANKS_TITLE" => $lang['Ranks_title'],
			"L_RANKS_TEXT" => $lang['Ranks_explain'],
			"L_RANK" => $lang['Rank_title'],
			"L_RANK_MINIMUM" => $lang['Rank_minimum'],
			"L_SPECIAL_RANK" => $lang['Special_rank'],
			"L_EDIT" => $lang['Edit'],
			"L_DELETE" => $lang['Delete'],
			"L_ADD_RANK" => $lang['Add_new_rank'],
			"L_ACTION" => $lang['Action'],
			
			"S_RANKS_ACTION" => append_sid("admin_ranks.$phpEx"))
		);
		
		for( $i = 0; $i < $rank_count; $i++)
		{
			$rank = $rank_rows[$i]['rank_title'];
			$special_rank = $rank_rows[$i]['rank_special'];
			$rank_id = $rank_rows[$i]['rank_id'];
			$rank_min = $rank_rows[$i]['rank_min'];

			if($special_rank)
			{
				$rank_min = $rank_max = "-";
			}
			
			$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
			$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
	
			$template->assign_block_vars("ranks", array(
				"ROW_COLOR" => "#" . $row_color,
				"ROW_CLASS" => $row_class,
				"RANK" => $rank,
				"RANK_MIN" => $rank_min,

				"SPECIAL_RANK" => ( $special_rank == 1 ) ? $lang['Yes'] : $lang['No'],

				"U_RANK_EDIT" => append_sid("admin_ranks.$phpEx?mode=edit&id=$rank_id"),
				"U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&id=$rank_id"))
			);
		}
	}
}
else
{
	//
	// Show the default page
	//
	$template->set_filenames(array(
		"body" => "admin/ranks_list_body.tpl")
	);
	
	$sql = "SELECT * FROM " . RANKS_TABLE . "
		ORDER BY rank_min ASC, rank_special ASC";
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, "Couldn't obtain ranks data", "", __LINE__, __FILE__, $sql);
	}
	$rank_count = $db->sql_numrows($result);

	$rank_rows = $db->sql_fetchrowset($result);
	
	$template->assign_vars(array(
		"L_RANKS_TITLE" => $lang['Ranks_title'],
		"L_RANKS_TEXT" => $lang['Ranks_explain'],
		"L_RANK" => $lang['Rank_title'],
		"L_RANK_MINIMUM" => $lang['Rank_minimum'],
		"L_SPECIAL_RANK" => $lang['Group_Rank_special'], // ADDED 'Group_' BY Group Rank Hack
		"L_EDIT" => $lang['Edit'],
		"L_DELETE" => $lang['Delete'],
		"L_ADD_RANK" => $lang['Add_new_rank'],
		"L_ACTION" => $lang['Action'],
		
		"S_RANKS_ACTION" => append_sid("admin_ranks.$phpEx"))
	);
	
	for($i = 0; $i < $rank_count; $i++)
	{
		$rank = $rank_rows[$i]['rank_title'];
		$special_rank = $rank_rows[$i]['rank_special'];
		$rank_id = $rank_rows[$i]['rank_id'];
		$rank_min = $rank_rows[$i]['rank_min'];
		
		if( $special_rank == 1 )
		{
			$rank_min = $rank_max = "-";
		}

		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
		$rank_is_special = ( $special_rank ) ? $lang['Yes'] : ( $rank_rows[$i]['rank_group'] > 0 ? $rank_rows[$i]['group_name'] : $lang['No'] );   // ADDED BY Group Rank Hack

			"SPECIAL_RANK" => $rank_is_special, //  REPLACED '( $special_rank == 1 ) ? $lang['Yes'] : $lang['No']' WITH '$rank_is_special' BY Group Rank Hack
		
		$template->assign_block_vars("ranks", array(
			"ROW_COLOR" => "#" . $row_color,
			"ROW_CLASS" => $row_class,
			"RANK" => $rank,
			"SPECIAL_RANK" => $rank_is_special,
			"RANK_MIN" => $rank_min,

			"U_RANK_EDIT" => append_sid("admin_ranks.$phpEx?mode=edit&id=$rank_id"),
			"U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&id=$rank_id"))
		);
	}
}

$template->pparse("body");

include('./page_footer_admin.'.$phpEx);

?>

Kann mir ja jemadn bei weiter helfen ???

MFG

Bender3k

Beitrag von **Acid** » 21.06.2003 20:31

..überprüfe nochma die Änderungen an der admin_ranks.php. Du hast an einigen Stellen diverse Code danach anstatt davor eingefügt oder umgekehrt.

Beitrag von **saerdnaer** » 22.06.2003 10:54

// ADDED ', rank_group = $group' BY Group Rank Hack
WHERE rank_id = $rank_id";

$message = $lang['Rank_updated'];
}
else
{
$sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image, rank_group)
VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "')";, $group
// ADDED ', rank_group' ', $group' BY Group Rank Hack

das blaue sollte nach dem rotem sein und das grüne vor dem gelben...

du solltest den mod mal gründlicher einbauen...

ah

Bender3k · Beitrag von **Bender3k** » 22.06.2003 12:52

Thx euch beiden!

Hab den Mod bei ner Flasche Weinbrand eingefügt...

Ist wohl irgendwas schief gelaufen.

Nun läuft wieder alles!

1000send Dank.

MFG

Bender3k

Bender3k · Beitrag von **Bender3k** » 22.06.2003 13:47

Moin!

Ich nochmal. Habe noch einen Fehler drin, und bekomm den auch nicht raus.

Könnte mir nochmal jemand helfen ?

Fehler tritt auf, wenn ich im Adminbereich unter Ränge was ändere und absenden will...

Hier der Fehler:

Couldn't update/insert into ranks table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'WHERE rank_id = 2' at line 3

UPDATE phpbb_ranks SET rank_title = '...trinkt zum ersten mal...', rank_special = 0, rank_min = 1, rank_image = 'images/raenge/1.gif', rank_group = WHERE rank_id = 2

Line : 228
File : /data/members/paid/r/-/r-a-p-p-e-l.de/htdocs/www/phpBB2/admin/admin_ranks.php

und heir nochmal ein Auzug meiner admin_ranks.php

Code: Alles auswählen

			$sql = "UPDATE " . RANKS_TABLE . "
				SET rank_title = '" . str_replace("\'", "''", $rank_title) . "', rank_special = $special_rank, rank_min = $min_posts, rank_image = '" . str_replace("\'", "''", $rank_image) . "', rank_group = $group
				WHERE rank_id = $rank_id";
// ADDED ', rank_group = $group' BY Group Rank Hack
			$message = $lang['Rank_updated'];
		}
		else
		{
			$sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image, rank_group)
				VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "', $group)";
// ADDED ', rank_group' ', $group' BY Group Rank Hack

			$message = $lang['Rank_added'];
		}
		
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, "Couldn't update/insert into ranks table", "", __LINE__, __FILE__, $sql);
		}

		$message .= "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href=\"" . append_sid("admin_ranks.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

		message_die(GENERAL_MESSAGE, $message);

Bin für jeden Tip dankbar.

MFG

Bender3k

Beitrag von **Acid** » 22.06.2003 14:07

..funktioniert das Erstellen neuer Ränge ?
Poste ma einen Link zu ´ner txt Version deiner admin_ranks.php .

Bender3k · Beitrag von **Bender3k** » 22.06.2003 18:50

Moin Moin!

Ich nochmal. Also neue Ränge kann ich auch nicht mehr erstellen... kommt der gleiche Fehler.

Hab hier mal die Admin_Ranks.txt hochgeladen

http://www.r-a-p-p-e-l.de/Privat/admin_ranks.txt

Bin für jeden Tip und jede Hilfe dankbar.

MFG

Bender3k

Beitrag von **Acid** » 22.06.2003 21:59

Code: Alles auswählen

#
#-----[ FIND ]------------------------------------------
#
		$special_rank = ( $HTTP_POST_VARS['special_rank'] == 1 ) ? TRUE : 0;
#
#-----[ AFTER, ADD ]------------------------------------------
#
		$group = ( $HTTP_POST_VARS['group'] > 0 ) ? intval($HTTP_POST_VARS['group']) : 0; // ADDED BY Group Rank Hack

Bender3k · Beitrag von **Bender3k** » 22.06.2003 23:11

Thx

Acid!

Funzt wieder alles perfekt!

1000send dank!

MFG

Bender3k