<target name="create-package" depends="prepare-new-version,old-version-diffs">

<exec dir="build" command="php -f package.php '${versions}' > logs/package.log" escape="false" />

<exec dir="build" command="php -f build_diff.php '${prevversion}' '${newversion}' > logs/build_diff.log" escape="false" />

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/language new_version/phpBB3/language >

save/save_${prevversion}_to_${newversion}/language/phpbb-${prevversion}_to_${newversion}_language.patch" />

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/styles/subsilver2 new_version/phpBB3/styles/subsilver2 >

save/save_${prevversion}_to_${newversion}/subsilver2/phpbb-${prevversion}_to_${newversion}_subsilver2.patch" />

</target>

<!--

'max_name_chars' => array('lang' => 'USERNAME_LENGTH', 'validate' => 'int:8:180', 'type' => false, 'method' => false, 'explain' => false,),

'max_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int:8:255', 'type' => false, 'method' => false, 'explain' => false,),

'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'text:4:4', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

'new_member_group_default'=> array('lang' => 'NEW_MEMBER_GROUP_DEFAULT', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'min_name_chars' => array('lang' => 'USERNAME_LENGTH', 'validate' => 'int:1', 'type' => 'custom:5:180', 'method' => 'username_length', 'explain' => true),

/**

* Select account activation method

*/

{

global $user, $config;

);

if ($config['email_enable'])

{

}

/**

$ug_id_ary = array_keys($hold_ary);

// Remove users who have group memberships with DENY moderator permissions

'SELECT' => 'a.forum_id, ug.user_id, g.group_id',

'FROM' => array(

'LEFT_JOIN' => array(

array(

'FROM' => array(ACL_ROLES_DATA_TABLE => 'r'),

),

'WHERE' => '(o.auth_option_id = a.auth_option_id OR o.auth_option_id = r.auth_option_id)

AND ' . $db->sql_in_set('ug.user_id', $ug_id_ary) . "

AND ug.user_pending = 0

AND o.auth_option " . $db->sql_like_expression('m_' . $db->any_char),

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

if (is_array($group_id) && sizeof($group_id))

{

// Grab group settings...

'SELECT' => 'a.group_id',

'FROM' => array(

ACL_OPTIONS_TABLE => 'ao',

),

'LEFT_JOIN' => array(

array(

'FROM' => array(ACL_ROLES_DATA_TABLE => 'r'),

),

),

AND ' . $db->sql_in_set('a.group_id', $group_id) . "

AND ao.auth_option IN ('a_', 'm_')",

$result = $db->sql_query($sql);

$groups = array();

$sql_array['SELECT'] .= ', fa.user_id';

}

'SELECT' => $sql_array['SELECT'],

'FROM' => $sql_array['FROM'],

'LEFT_JOIN' => $sql_array['LEFT_JOIN'],

'WHERE' => $sql_where,

'ORDER_BY' => 'f.left_id',

$result = $db->sql_query($sql);

$forum_tracking_info = array();

$mode = 'post_review';

}

'SELECT' => 'u.username, u.user_id, u.user_colour, p.*, z.friend, z.foe',

'FROM' => array(

'LEFT_JOIN' => array(

array(

'FROM' => array(ZEBRA_TABLE => 'z'),

),

'WHERE' => $db->sql_in_set('p.post_id', $post_list) . '

$result = $db->sql_query($sql);

$bbcode_bitfield = '';

if ($total)

{

'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, p.post_attachment, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

'FROM' => array(

REPORTS_REASONS_TABLE => 'rr',

TOPICS_TABLE => 't',

USERS_TABLE => array('u', 'u2'),

),

'LEFT_JOIN' => array(

array(

'FROM' => array(FORUMS_TABLE => 'f'),

),

'WHERE' => 'r.post_id = p.post_id

AND p.poster_id = u2.user_id

AND ' . $db->sql_in_set('p.forum_id', $forum_list),

$result = $db->sql_query_limit($sql, 5);

while ($row = $db->sql_fetchrow($result))

{

include($phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx);

'SELECT' => 'r.report_id, r.report_time, p.msg_id, p.message_subject, p.message_time, p.to_address, p.bcc_address, p.message_attachment, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id',

'FROM' => array(

REPORTS_TABLE => 'r',

REPORTS_REASONS_TABLE => 'rr',

USERS_TABLE => array('u', 'u2'),

),

'WHERE' => 'r.pm_id = p.msg_id

AND r.user_id = u.user_id

AND p.author_id = u2.user_id',

$result = $db->sql_query_limit($sql, 5);

$pm_by_id = $pm_list = array();

// Output listing of friends online

$update_time = $config['load_online_time'] * 60;

'SELECT' => 'u.user_id, u.username, u.username_clean, u.user_colour, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline',

'FROM' => array(

USERS_TABLE => 'u',

),

'LEFT_JOIN' => array(

array(

'FROM' => array(SESSIONS_TABLE => 's'),

),

'WHERE' => 'z.user_id = ' . $user->data['user_id'] . '

'GROUP_BY' => 'z.zebra_id, u.user_id, u.username_clean, u.user_colour, u.username',

'ORDER_BY' => 'u.username_clean ASC',

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

$sql_anounce_array['SELECT'] = $sql_array['SELECT'] . ', f.forum_name';

// Obtain announcements ... removed sort ordering, sort by time in all cases

'SELECT' => $sql_anounce_array['SELECT'],

'FROM' => $sql_array['FROM'],

'LEFT_JOIN' => $sql_anounce_array['LEFT_JOIN'],

AND t.topic_type = ' . POST_GLOBAL . ')',

'ORDER_BY' => 't.topic_time DESC',

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

// We need to grab it because we do reverse ordering sometimes

$max_post_time = 0;

'SELECT' => 'u.*, z.friend, z.foe, p.*',

'FROM' => array(

'LEFT_JOIN' => array(

array(

'FROM' => array(ZEBRA_TABLE => 'z'),

),

'WHERE' => $db->sql_in_set('p.post_id', $post_list) . '

$result = $db->sql_query($sql);

$now = phpbb_gmgetdate(time() + $user->timezone + $user->dst);

<column>user_id</column>

<column>username</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>mass email</value>

<value>mass email</value>

</row>

<row>

<value>2</value>

<value>banned</value>

<value>banned</value>

</row>

<row>

<value>3</value>

<value>not in group</value>

<value>not in group</value>

</row>

</table>

<table name="phpbb_user_group">

<table name="phpbb_users">

<column>user_id</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>barfoo</value>

</row>

<row>

<value>2</value>

<value>foobar</value>

</row>

<row>

<value>3</value>

<value>bertie</value>

</row>

</table>

</dataset>

<table name="phpbb_users">

<column>user_id</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>anonymous</value>

</row>

<row>

<value>3</value>

<value>foo</value>

</row>

<row>

<value>4</value>

<value>bar</value>

</row>

</table>

<table name="phpbb_sessions">

<table name="phpbb_users">

<column>user_id</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>anonymous</value>

</row>

<row>

<value>3</value>

<value>foo</value>

</row>

<row>

<value>4</value>

<value>bar</value>

</row>

</table>

<table name="phpbb_sessions">