phpBB.de

Code: Alles auswählen

					if ( $action == 'insert' )
					{
						$sql_field = '';
						$sql_value = '';
						while ( list($auth_type, $value) = @each($update_acl_status[$forum_id]) )
						{
							$sql_field .= ( ( $sql_field != '' ) ? ', ' : '' ) . $auth_type;
							$sql_value .= ( ( $sql_value != '' ) ? ', ' : '' ) . $value;
						}
						$sql_field .= ( ( $sql_field != '' ) ? ', ' : '' ) . 'auth_mod';
						$sql_value .= ( ( $sql_value != '' ) ? ', ' : '' ) . ( ( !isset($update_mod_status[$forum_id]) ) ? 0 : $update_mod_status[$forum_id]);

						$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (forum_id, group_id, $sql_field) 
							VALUES ($forum_id, $group_id, $sql_value)";
					}
					else
					{
						$sql_values = '';
						while ( list($auth_type, $value) = @each($update_acl_status[$forum_id]) )
						{
							$sql_values .= ( ( $sql_values != '' ) ? ', ' : '' ) . $auth_type . ' = ' . $value;
						}
						$sql_values .= ( ( $sql_values != '' ) ? ', ' : '' ) . 'auth_mod = ' . ( ( !isset($update_mod_status[$forum_id]) ) ? 0 : $update_mod_status[$forum_id]);

						$sql = "UPDATE " . AUTH_ACCESS_TABLE . " 
							SET $sql_values 
							WHERE group_id = $group_id 
								AND forum_id = $forum_id";
					}
					if( !($result = $db->sql_query($sql)) )
					{
						message_die(GENERAL_ERROR, "Couldn't update private forum permissions", "", __LINE__, __FILE__, $sql);
					}

Code: Alles auswählen

$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce)
VALUES ('1', '1', '1', '1', '1', '0', '0', '0');

Code: Alles auswählen

Couldn't update auth access

DEBUG MODE

SQL Error : 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 '; WHERE group_id = 21' at line 2

INSERT INTO phpbb_auth_access (auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce) VALUES ('1', '1', '1', '1', '1', '0', '0', '0'); WHERE group_id = 21

Line : 438
File : admin_forums.php

Code: Alles auswählen

$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce)
VALUES ('1', '1', '1', '1', '1', '0', '0', '0');
WHERE group_id = $variable";

Code: Alles auswählen

[...]
VALUES ('1', '1', '1', '1', '1', '0', '0', '0')";

Code: Alles auswählen

$sql = "UPDATE " . AUTH_ACCESS_TABLE . " (auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_pollcreate, auth_attachments, auth_mod)
VALUES (1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0);
WHERE group_id = $new_group_id"; 

Code: Alles auswählen

Couldn't update auth access

DEBUG MODE

SQL Error : 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 '(auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_de

UPDATE phpbb_auth_access (auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_pollcreate, auth_attachments, auth_mod) VALUES (1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0); WHERE group_id = 3

Line : 439
File : admin_forums.php

Code: Alles auswählen

$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_pollcreate, auth_attachments, auth_mod) 
VALUES (1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0)
WHERE group_id = $new_group_id";