Code: Select all
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
define('POST_GLOBAL_ANNOUNCE', 3);
#
#-----[ AFTER, ADD ]------------------------------------------
#
define('POST_SPECIAL', 4);
#
#-----[ FIND ]------------------------------------------
#
define('AUTH_ATTACH', 11);
#
#-----[ AFTER, ADD ]------------------------------------------
#
define('AUTH_SPECIAL', 12);
Code: Select all
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
define('POST_SPECIAL', 4);
#
#-----[ AFTER, ADD ]------------------------------------------
#
define('POST_ANOTHER', 5);
#
#-----[ FIND ]------------------------------------------
#
define('AUTH_SPECIAL', 12);
#
#-----[ AFTER, ADD ]------------------------------------------
#
define('AUTH_ANOTHER', 13);
Code: Select all
#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
$order_sql = ( !isset($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";
#
#-----[ IN-LINE FIND ]------------------------------------------
#
f.auth_delete,
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
f.auth_sticky,
Code: Select all
#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
$order_sql = ( !isset($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";
#
#-----[ IN-LINE FIND ]------------------------------------------
#
f.auth_delete,
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
f.auth_special,
Code: Select all
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD auth_special tinyint(1) NOT NULL";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD auth_special tinyint(2) NOT NULL";
Code: Select all
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD auth_special tinyint(1) NOT NULL";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD auth_special tinyint(2) NOT NULL";
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD auth_another tinyint(1) NOT NULL";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD auth_another tinyint(2) NOT NULL";
Code: Select all
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD auth_another tinyint(1) NOT NULL";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD auth_another tinyint(2) NOT NULL";
Code: Select all
auth_special
GPHemsley wrote: *THIS MOD HAS BEEN SUBMITTED TO THE DATABASE*
Code: Select all
#
#-----[ SQL ]------------------------------------------
# Change the prefix "phpbb_" to whatever your prefix is
#
ALTER TABLE phpbb_auth_access ADD auth_special tinyint(1) NOT NULL;
ALTER TABLE phpbb_forums ADD auth_special tinyint(2) NOT NULL;
GPHemsley wrote: *bump*
I just wanted to make sure this stayed on the first page.... Many people may need this.