Changeset 262

User picture

Author: Mighty Gorgon

(2011/04/10 10:58) 11 months ago

Added a couple of features to forms management, and started to comply with latest MySQL 5.5.5 defaults which (InnoDB instead of MyISAM)

Affected files

Updated ip/trunk/includes/class_form.php Download diff

261262
465
				if (!empty($v['number_format']))
465
				if (!empty($v['number_format']))
466
				{
466
				{
467
					$v['number_format']['decimals'] = isset($v['number_format']['decimals']) ? $v['number_format']['decimals'] : (isset($lang['NUMBER_FORMAT_DECIMALS']) ?
$lang['NUMBER_FORMAT_DECIMALS'] : 0);
467
					$v['number_format']['decimals'] = isset($v['number_format']['decimals']) ? $v['number_format']['decimals'] : (isset($lang['NUMBER_FORMAT_DECIMALS']) ?
$lang['NUMBER_FORMAT_DECIMALS'] : 0);
468
					$v['number_format']['decimals_sep'] = !empty($v['number_format']['decimals_sep']) ? $v['number_format']['decimals_sep'] :
(isset($lang['NUMBER_FORMAT_DECIMALS_SEP']) ? $lang['NUMBER_FORMAT_DECIMALS'] : ',');
468
					$v['number_format']['decimals_sep'] = !empty($v['number_format']['decimals_sep']) ? $v['number_format']['decimals_sep'] : (isset($lang['NUMBER_FORMAT_DECIMALS_SEP']) ? $lang['NUMBER_FORMAT_DECIMALS_SEP'] : ',');
469
					$v['number_format']['thousands_sep'] = !empty($v['number_format']['thousands_sep']) ? $v['number_format']['thousands_sep'] : (isset($lang['NUMBER_FORMAT_THOUSANDS_SEP']) ? $lang['NUMBER_FORMAT_DECIMALS'] : '.');
469
					$v['number_format']['thousands_sep'] = !empty($v['number_format']['thousands_sep']) ? $v['number_format']['thousands_sep'] : (isset($lang['NUMBER_FORMAT_THOUSANDS_SEP']) ? $lang['NUMBER_FORMAT_THOUSANDS_SEP'] : '.');
470
					$value = number_format($inputs_array[$k], $v['number_format']['decimals'], $v['number_format']['decimals_sep'], $v['number_format']['thousands_sep']);
470
					$value = number_format($inputs_array[$k], $v['number_format']['decimals'], $v['number_format']['decimals_sep'], $v['number_format']['thousands_sep']);
471
				}
471
				}
472
472
...
...
518
				{
518
				{
519
					$value = '<a href="' . append_sid($inputs_array[$k]) . '"><img src="' . append_sid('posted_img_thumbnail.' . PHP_EXT . '?pic_id=' .
urlencode($inputs_array[$k]) . (isset($v['thumbnail_size']) ? ('&amp;thumbnail_size=' . intval($v['thumbnail_size'])) : '')) . '" alt=""
/></a>';
519
					$value = '<a href="' . append_sid($inputs_array[$k]) . '"><img src="' . append_sid('posted_img_thumbnail.' . PHP_EXT . '?pic_id=' .
urlencode($inputs_array[$k]) . (isset($v['thumbnail_size']) ? ('&amp;thumbnail_size=' . intval($v['thumbnail_size'])) : '')) . '" alt=""
/></a>';
520
				}
520
				}
521
522
				if (!empty($v['display_func']) && function_exists($v['display_func']))
523
				{
524
					$value = $v['display_func']($inputs_array[$k]);
525
				}
521
				// SPECIAL PROCESSING - END
526
				// SPECIAL PROCESSING - END
522
527
523
				$class = (empty($class) || ($class == $theme['td_class2'])) ? $theme['td_class1'] : $theme['td_class2'];
528
				$class = (empty($class) || ($class == $theme['td_class2'])) ? $theme['td_class1'] : $theme['td_class2'];

Updated ip/trunk/includes/class_plugins.php Download diff

261262
56
			{
56
			{
57
				if (!empty($plugin_install_data[$version]['sql']))
57
				if (!empty($plugin_install_data[$version]['sql']))
58
				{
58
				{
59
					// We need to force this because in MySQL 5.5.5 the new default DB Engine is InnoDB, not MyISAM any more
60
					$sql_engine = "SET storage_engine=MYISAM";
61
					$db->sql_return_on_error(true);
62
					$db->sql_query($sql_engine);
63
					$db->sql_return_on_error(false);
64
59
					foreach ($plugin_install_data[$version]['sql'] as $sql_statement)
65
					foreach ($plugin_install_data[$version]['sql'] as $sql_statement)
60
					{
66
					{
61
						$error = array();
67
						$error = array();

Updated ip/trunk/install/schemas/db_update_000.sql Download diff

261262
1
SET storage_engine=MYISAM;
2
1
########################################
3
########################################
2
##              BUILD 000             ##
4
##              BUILD 000             ##
3
########################################
5
########################################

Updated ip/trunk/install/schemas/db_update_054.sql Download diff

261262
1
SET storage_engine=MYISAM;
2
1
########################################
3
########################################
2
##              BUILD 054             ##
4
##              BUILD 054             ##
3
########################################
5
########################################

Updated ip/trunk/install/schemas/mysql_schema.sql Download diff

261262
1
SET storage_engine=MYISAM;
2
1
## `phpbb_acronyms`
3
## `phpbb_acronyms`
2
4
3
CREATE TABLE `phpbb_acronyms` (
5
CREATE TABLE `phpbb_acronyms` (

Updated ip/trunk/install/schemas/sql_update_ip.php Download diff

261262
74
	case '131770': $current_ip_version = '1.3.17.70'; break;
74
	case '131770': $current_ip_version = '1.3.17.70'; break;
75
}
75
}
76
76
77
// We need to force this because in MySQL 5.5.5 the new default DB Engine is InnoDB, not MyISAM any more
78
$sql[] = "SET storage_engine=MYISAM";
79
77
// Icy Phoenix Part...
80
// Icy Phoenix Part...
78
if (substr($mode, 0, 6) == 'update')
81
if (substr($mode, 0, 6) == 'update')
79
{
82
{

Updated ip/trunk/templates/default/blocks/top_posters_block.tpl Download diff

261262
12
<br />
12
<br />
13
<!-- ELSE -->
13
<!-- ELSE -->
14
<!-- BEGIN topposter -->
14
<!-- BEGIN topposter -->
15
<div style="float:right;">[<b><a href="{topposter.U_VIEWPOSTS}" class="gensmall">{topposter.POSTS}</a></b>]</div>{topposter.USERNAME}&nbsp;<br />
15
<div style="float: right;">[<b><a href="{topposter.U_VIEWPOSTS}" class="gensmall">{topposter.POSTS}</a></b>]</div>{topposter.USERNAME}&nbsp;<br clear="all" />
16
<!-- END topposter -->
16
<!-- END topposter -->
17
<!-- ENDIF -->
17
<!-- ENDIF -->