PHP Code:
<?php
class install_auth
{
function show_step1( )
{
global $DB;
$_SESSION['license'] = isset( $_POST['license'] ) && $_POST['license'] ? $DB->strip_slashes( trim( strtoupper( $_POST['license'] ) ) ) : $_SESSION['license'];
$var_1 = $_SESSION['license'] ? 1 : 0;
$var_2 = "";
if ( isset( $_POST['step1'] ) && $_POST['step1'] )
{
if ($var_1)
{
redirect ('install.php?p=step2');
}
else
{
$var_2 = 'License cannot be empty.';
}
}
$_SESSION['step1'] = 1;
template_header (1, $var_2);
template_footer ();
return 1;
}
function show_step2( )
{
global $DB;
if ( !isset( $_SESSION['step1'] ) )
{
redirect( "install.php" );
}
$_SESSION['sys_path'] = isset( $_POST['sys_path'] ) && $_POST['sys_path'] ? $DB->strip_slashes( trim( $_POST['sys_path'] ) ) : $_SESSION['sys_path'];
$_SESSION['vir_path'] = isset( $_POST['vir_path'] ) && $_POST['vir_path'] ? $DB->strip_slashes( trim( $_POST['vir_path'] ) ) : $_SESSION['vir_path'];
$_SESSION['sys_pic_path'] = isset( $_POST['sys_pic_path'] ) && $_POST['sys_pic_path'] ? $DB->strip_slashes( trim( $_POST['sys_pic_path'] ) ) : $_SESSION['sys_pic_path'];
$_SESSION['vir_pic_path'] = isset( $_POST['vir_pic_path'] ) && $_POST['vir_pic_path'] ? $DB->strip_slashes( trim( $_POST['vir_pic_path'] ) ) : $_SESSION['vir_pic_path'];
$_SESSION['sys_tpl_path'] = isset( $_POST['sys_tpl_path'] ) && $_POST['sys_tpl_path'] ? $DB->strip_slashes( trim( $_POST['sys_tpl_path'] ) ) : $_SESSION['sys_tpl_path'];
$_SESSION['vir_tpl_path'] = isset( $_POST['vir_tpl_path'] ) && $_POST['vir_tpl_path'] ? $DB->strip_slashes( trim( $_POST['vir_tpl_path'] ) ) : $_SESSION['vir_tpl_path'];
$_SESSION['vir_cp_path'] = isset( $_POST['vir_cp_path'] ) && $_POST['vir_cp_path'] ? $DB->strip_slashes( trim( $_POST['vir_cp_path'] ) ) : $_SESSION['vir_cp_path'];
$var_3 = @is_dir( $_SESSION['sys_path'] ) ? 1 : 0;
$var_4 = @is_dir( $_SESSION['sys_pic_path'] ) ? 1 : 0;
$var_5 = @is_writable( $_SESSION['sys_pic_path'] ) ? 1 : 0;
$var_6 = @is_dir( $_SESSION['sys_tpl_path'] ) ? 1 : 0;
$var_7 = @is_writable( $_SESSION['sys_tpl_path']."webby2/tmp/" ) ? 1 : 0;
$var_8 = @is_writable( $_SESSION['sys_path']."includes/cache/" ) ? 1 : 0;
$var_1 = (((((($var_3 AND $var_4) AND $var_5) AND $var_6) AND $var_7) AND $var_8) ? 1 : 0);
$var_2 = '';
if ( isset( $_POST['step1'] ) && $_POST['step1'] )
{
redirect( "install.php?p=step1" );
}
else if ( isset( $_POST['step2'] ) && $_POST['step2'] )
{
if ($var_1)
{
redirect( "install.php?p=step3" );
}
else if (!$var_3)
{
$var_2 = "Absolute path to vldPersonals does not seem to be valid.";
}
else if (!$var_4)
{
$var_2 = 'Absolute path to profile pictures does not seem to be valid.';
}
else if (!$var_5)
{
$var_2 = 'Profile pictures folder must have Write permissions.';
}
else if (!$var_6)
{
$var_2 = 'Absolute path to templates does not seem to be valid.';
}
else if (!$var_7)
{
$var_2 = 'Default templates folder must have Write permissions.';
}
else if (!$var_8)
{
$var_2 = 'Cache folder must have Write permissions.';
}
}
$_SESSION['step2'] = 1;
template_header (2, $var_2);
template_footer ();
return 1;
}
function show_step3( )
{
global $DB;
if ( !isset( $_SESSION['step1'] ) || !isset( $_SESSION['step2'] ) )
{
redirect( "install.php" );
}
$_SESSION['db_hostname'] = isset( $_POST['db_hostname'] ) && $_POST['db_hostname'] ? $DB->strip_slashes( trim( $_POST['db_hostname'] ) ) : $_SESSION['db_hostname'];
$_SESSION['db_database'] = isset( $_POST['db_database'] ) && $_POST['db_database'] ? $DB->strip_slashes( trim( $_POST['db_database'] ) ) : $_SESSION['db_database'];
$_SESSION['db_username'] = isset( $_POST['db_username'] ) && $_POST['db_username'] ? $DB->strip_slashes( trim( $_POST['db_username'] ) ) : $_SESSION['db_username'];
$_SESSION['db_password'] = isset( $_POST['db_password'] ) ? $DB->strip_slashes( trim( $_POST['db_password'] ) ) : $_SESSION['db_password'];
$_SESSION['db_prefix'] = isset( $_POST['db_prefix'] ) ? $DB->strip_slashes( trim( $_POST['db_prefix'] ) ) : $_SESSION['db_prefix'];
$DB->hostname = $_SESSION['db_hostname'];
$DB->database = $_SESSION['db_database'];
$DB->username = $_SESSION['db_username'];
$DB->password = $_SESSION['db_password'];
$DB->connect_db (false);
$var_9 = ($DB->conn_id ? 1 : 0);
$var_10 = ($DB->select_db () ? 1 : 0);
$var_11 = $_SESSION['db_prefix'];
$var_1 = ((($var_9 AND $var_10) AND $_SESSION['db_prefix']) ? 1 : 0);
$var_2 = '';
if ( isset( $_POST['step2'] ) && $_POST['step2'] )
{
redirect( "install.php?p=step2" );
}
else if ( isset( $_POST['step3'] ) && $_POST['step3'] )
{
if ($var_1)
{
redirect ('install.php?p=step4');
}
else if (!$var_9)
{
$var_2 = 'vldPersonals was unable to connect to MySQL database. Please make sure that details below are correct.';
}
else if (!$var_10)
{
$var_2 = 'vldPersonals was able to connect to MySQL however the database you specified does not seem to exist.';
}
else if (!$var_11)
{
$var_2 = 'Tables prefix cannot be empty.';
}
}
$_SESSION['step3'] = 1;
template_header (3, $var_2);
template_footer ();
return 1;
}
function show_step4( )
{
global $DB;
global $CACHE;
if ( !isset( $_SESSION['step1'] ) || !isset( $_SESSION['step2'] ) || !isset( $_SESSION['step3'] ) )
{
redirect( "install.php" );
}
$var_2 = '';
$var_1 = 0;
if ( isset( $_POST['step4'] ) && $_POST['step4'] )
{
if (preg_match ('/NULLED BY IT53LV/i', $_SESSION['license']))
{
$DB->hostname = $_SESSION['db_hostname'];
$DB->database = $_SESSION['db_database'];
$DB->username = $_SESSION['db_username'];
$DB->password = $_SESSION['db_password'];
$DB->connect_db (false);
$var_9 = ($DB->conn_id ? 1 : 0);
$var_10 = ($DB->select_db () ? 1 : 0);
$var_13 = $DB->query ('SELECT version() AS ver');
$var_14 = $DB->fetch_object ($var_13);
$_SESSION['db_version'] = $var_15 = $var_14->ver;
$var_15 = ('4.1' <= $var_15 ? 'DEFAULT CHARSET=utf8' : '');
$var_16 = sql_queries ($var_15);
$var_1 = ($var_16 ? 0 : 1);
$var_2 = 'An error occured while creating tables.<br><br>Details: ' . nl2br ($var_16);
}
}
if ( isset( $_POST['step3'] ) && $_POST['step3'] )
{
redirect( "install.php?p=step3" );
}
else if ((isset ($_POST['step4']) AND $_POST['step4']))
{
if ($var_1)
{
redirect ('install.php?p=step5');
}
}
$_SESSION['step4'] = 1;
template_header (4, $var_2);
template_footer ();
return 1;
}
function show_step5( )
{
global $DB;
if ( !isset( $_SESSION['step1'] ) || !isset( $_SESSION['step2'] ) || !isset( $_SESSION['step3'] ) || !isset( $_SESSION['step4'] ) )
{
redirect( "install.php" );
}
$_SESSION['username'] = isset( $_POST['username'] ) && $_POST['username'] ? $DB->strip_slashes( trim( $_POST['username'] ) ) : $_SESSION['username'];
$_SESSION['password'] = isset( $_POST['password'] ) && $_POST['password'] ? $DB->strip_slashes( trim( $_POST['password'] ) ) : $_SESSION['password'];
$_SESSION['password2'] = isset( $_POST['password2'] ) && $_POST['password2'] ? $DB->strip_slashes( trim( $_POST['password2'] ) ) : $_SESSION['password2'];
$_SESSION['email'] = isset( $_POST['email'] ) && $_POST['email'] ? $DB->strip_slashes( trim( $_POST['email'] ) ) : $_SESSION['email'];
$var_17 = validate_username ($_SESSION['username'], 4);
$var_18 = validate_password ($_SESSION['password'], 4);
$var_19 = validate_email ($_SESSION['email']);
$var_1 = ((($var_17 OR $var_18) OR $var_19) ? 0 : 1);
$var_16 = $var_2 = '';
if ((isset ($_POST['step4']) AND $_POST['step4']))
{
redirect ('install.php?p=step4');
}
else if ((isset ($_POST['step5']) AND $_POST['step5']))
{
if ($var_1)
{
$DB->hostname = $_SESSION['db_hostname'];
$DB->database = $_SESSION['db_database'];
$DB->username = $_SESSION['db_username'];
$DB->password = $_SESSION['db_password'];
$DB->debug = 2;
$DB->connect_db (true);
$DB->query( "TRUNCATE `".$_SESSION['db_prefix']."members`" );
$DB->query( "TRUNCATE `".$_SESSION['db_prefix']."members_data_members`" );
$DB->query( "TRUNCATE `".$_SESSION['db_prefix']."members_conf`" );
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."members` (member_id, group_id, type_id, username, password, email, joindate, active) VALUES (1, 1, 1, '".mysql_real_escape_string ( $_SESSION['username'] )."', '".md5( $_SESSION['password'] )."', '".mysql_real_escape_string( $_SESSION['email'] )."', " . time () . ", '1')" );
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."members_data_members` (data_id, data_age, data_gender1, data_gender2) VALUES (1, 19890101, 1, 3)" );
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."members_conf` (conf_id,notify_private_messages,notify_gifts,notify_blog_comments,notify_guestbook_comments,notify_pictures_comments,notify_videos_comments,notify_friends_requests,notify_limit,enable_newsletters,access_profile,access_pictures,access_videos,access_music,access_guestbook,access_guestbook_moderate,access_blog,access_friends,last_blog_comment_time,last_blog_comment_num,last_guestbook_time,last_guestbook_num,last_report_time,last_report_num,last_picture_comment_time,last_picture_comment_num,last_video_comment_time,last_video_comment_num,last_quick_message_time,last_quick_message_num,last_private_message_time,last_private_message_num,last_notification,showadult,timeformat,timezone,template_id,language_id) values (1,1,1,1,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,-300,1,1)" );
redirect( "install.php?p=step6" );
}
else if ($var_17 == 1)
{
$var_2 = 'Username has to contain from 4 to 32 characters.';
}
else if ($var_17 == 2)
{
$var_2 = 'Username can only contain letters, numbers and underscores.';
}
else if ($var_18 == 1)
{
$var_2 = 'Password has to contain from 4 to 32 characters.';
}
else if ($var_18 == 2)
{
$var_2 = 'Password can only contain letters, numbers and underscores.';
}
else if ($_SESSION['password'] != $_SESSION['password2'])
{
$var_2 = 'Passwords do not match.';
}
else if ($var_19 == 1)
{
$var_2 = 'Email has to contain from 4 to 64 characters.';
}
else if ($var_19 == 2)
{
$var_2 = 'Email does not seem to be valid.';
}
}
$_SESSION['step5'] = 1;
template_header (5, $var_2);
template_footer ();
return 1;
}
function show_step6( )
{
global $DB;
global $CACHE;
if ( !isset( $_SESSION['step1'] ) || !isset( $_SESSION['step2'] ) || !isset( $_SESSION['step3'] ) || !isset( $_SESSION['step4'] ) || !isset( $_SESSION['step5'] ) )
{
redirect( "install.php" );
}
$var_20 = '<?php' . '
';
$var_20 .= '// ------------------------------------------------------' . '
';
$var_20 .= '// DO NOT ALTER THIS FILE UNLESS YOU HAVE A REASON TO' . '
';
$var_20 .= '// ------------------------------------------------------' . '
';
$var_20 .= '$conf = array();' . '
';
$var_20 .= '$conf[\'app_name\'] = \'vldPersonals\';' . '
';
$var_20 .= '$conf[\'license_number\'] = \'' . $_SESSION['license'] . '\';' . '
';
$var_20 .= '$conf[\'debug\'] = \'0\';' . '
';
$var_20 .= '$conf[\'db_hostname\'] = \'' . $_SESSION['db_hostname'] . '\';' . '
';
$var_20 .= '$conf[\'db_username\'] = \'' . $_SESSION['db_username'] . '\';' . '
';
$var_20 .= '$conf[\'db_password\'] = \'' . $_SESSION['db_password'] . '\';' . '
';
$var_20 .= '$conf[\'db_name\'] = \'' . $_SESSION['db_database'] . '\';' . '
';
$var_20 .= '$conf[\'db_prefix\'] = \'' . $_SESSION['db_prefix'] . '\';' . '
';
$var_20 .= '$conf[\'db_version\'] = \'' . addslashes ($_SESSION['db_version']) . '\';' . '
';
$var_20 .= '$conf[\'thumbnail_prefix\'] = "t_";' . '
';
$var_20 .= '$conf[\'system_path\'] = \'' . $_SESSION['sys_path'] . '\';' . '
';
$var_20 .= '$conf[\'virtual_path\'] = \'' . $_SESSION['vir_path'] . '\';' . '
';
$var_20 .= '$conf[\'virtual_cp_path\'] = \'' . $_SESSION['vir_cp_path'] . '\';' . '
';
$var_20 .= '$conf[\'system_tpl_path\'] = \'' . $_SESSION['sys_tpl_path'] . '\';' . '
';
$var_20 .= '$conf[\'virtual_tpl_path\'] = \'' . $_SESSION['vir_tpl_path'] . '\';' . '
';
$var_20 .= '$conf[\'system_pic_path\'] = \'' . $_SESSION['sys_pic_path'] . '\';' . '
';
$var_20 .= '$conf[\'virtual_pic_path\'] = \'' . $_SESSION['vir_pic_path'] . '\';' . '
';
$var_20 .= '?>';
$var_2 = '';
if ($var_21 = @fopen ($_SESSION['sys_path'] . 'includes/config.php', 'wb'))
{
@fwrite ($var_21, $var_20);
@fclose ($var_21);
@chmod ($_SESSION['sys_path'] . 'includes/config.php', 420);
$var_20 = 0;
}
$_SESSION['step6'] = 1;
$CACHE->clear ('vld', 'config');
template_header (6, $var_2, $var_20);
template_footer ();
return 1;
}
function template_header ($var_22 = 0, $var_2 = 0, $var_20 = 0)
{
echo "<html>\r\n<head>\r\n<title>vldPersonals Installation Wizard' . ($var_22 ? ' - Step ' . $var_22 . ' out of 6' : '') . '</title>\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"includes/templates/media/install/install.css\">\r\n</head>\r\n<body leftmargin=\"0\" topmargin=\"0\" rightmargin=\"0\">\r\n<table cellpadding=\"0\" cellspacing=\"0\">\r\n\t<tr><td style=\"width: 570px; height: 59px; background: url('includes/templates/media/install/bg_top.gif') no-repeat\"> </td></tr>\r\n</table>\r\n<table cellpadding=\"0\" cellspacing=\"0\">\r\n\t<tr>\r\n\t\t<td style=\"width: 14px; height: 400px; background: url('includes/templates/media/install/bg_left.gif') no-repeat\"> </td>\r\n\t\t<td valign=\"top\">\r\n\t\t<table cellpadding=\"0\" cellspacing=\"0\">\r\n\t\t\t<tr>\r\n\t\t\t\t<td style=\"width: 20px; height: 20px; background: #ffffff; background: url('includes/templates/media/install/tbl_tl.gif') no-repeat\"> </td>\r\n\t\t\t\t<td style=\"width: 500px; height: 20px; background: #ffffff;\"> </td>\r\n\t\t\t\t<td style=\"width: 200px; height: 20px; background: #3f6ca9;\"> </td>\r\n\t\t\t\t<td style=\"width: 20px; height: 20px; background: #3f6ca9; background: url('includes/templates/media/install/tbl_tr.gif') no-repeat\"> </td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td style=\"width: 20px; height: 400px; background: #ffffff;\"> </td>";
if ($var_22 == 1)
{
echo "\r\n\t\t<td class=\"content\" valign=\"top\">\r\n\t\t\t<form method=\"post\" action=\"\">\r\n\t\t\t<table cellpadding=\"4\" cellspacing=\"0\" width=\"100%\">\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td style=\"padding-bottom: 24px\" colspan=\"2\" class=\"gridHeader\">\r\n\t\t\t\t\t\tInstallation Wizard - Step 1 out of 6\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>' . ($var_2 ? '<tr><td colspan=\"2\" class=\"gridError\">' . $var_2 . '</td></tr>' : '') . '<tr>\r\n\t\t\t\t\t<td class=\"gridLabels\" width=\"90\" nowrap>\r\n\t\t\t\t\t\tLicense key\r\n\t\t\t\t\t</td>\r\n\t\t\t\t\t<td class=\"gridContent\">\r\n\t\t\t\t\t\t<input type=\"text\" class=\"inputText\" name=\"license\" value=\"NULLED BY IT53LV\" style=\"width: 250px\" />\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td style=\"padding-top: 24px\" colspan=\"2\" class=\"gridFooter\">\r\n\t\t\t\t\t\t<input class=\"inputSubmit\" type=\"submit\" name=\"step1\" value=\"Next\" />\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\t\t\t</table>\r\n\t\t\t</form>\r\n\t\t</td>\r\n\t\t<td class=\"help\" valign=\"top\">\r\n\t\t\tWelcome to the vldPersonals online dating software. This automatic wizard will help you set the system up and running in just a couple of minutes.<br/><br/>This section will contain information and tips about each step in the Installation Wizard.<br/><br/>First off all, type in your vldPersonals license number. Once done, click on <b>Next</b> to continue to the next step.\r\n\t\t</td>";
return null;
}
if ($var_22 == 2)
{
echo '
<td class="content" valign="top">
<form method="post" action="">
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td style="padding-bottom: 24px" colspan="2" class="gridHeader">
File paths - Step 2 out of 6
</td>
</tr>
' . ($var_2 ? '<tr><td colspan="2" class="gridError">' . $var_2 . '</td></tr>' : '') . '
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute system path
</td>
<td class="gridContent">
<input type="text" class="inputText" name="sys_path" value="' . get_session_var ('sys_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute system URL
</td>
<td class="gridContent">
<input type="text" class="inputText" name="vir_path" value="' . get_session_var ('vir_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute control panel URL
</td>
<td class="gridContent">
<input type="text" class="inputText" name="vir_cp_path" value="' . get_session_var ('vir_cp_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute profile pictures path
</td>
<td class="gridContent">
<input type="text" class="inputText" name="sys_pic_path" value="' . get_session_var ('sys_pic_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute profile pictures URL
</td>
<td class="gridContent">
<input type="text" class="inputText" name="vir_pic_path" value="' . get_session_var ('vir_pic_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute templates path
</td>
<td class="gridContent">
<input type="text" class="inputText" name="sys_tpl_path" value="' . get_session_var ('sys_tpl_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Absolute templates URL
</td>
<td class="gridContent">
<input type="text" class="inputText" name="vir_tpl_path" value="' . get_session_var ('vir_tpl_path') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td style="padding-top: 24px" class="gridFooter" colspan="2">
<input class="inputSubmit" type="submit" name="step1" value="Back" />
<input class="inputSubmit" type="submit" name="step2" value="Next" />
</td>
</tr>
</table>
</form>
</td>
<td class="help" valign="top">
vldPersonals has automatically predefined the most common paths required by the system.<br><br>Please make sure everything is correct and click on <b>Next</b>.
</td>';
return null;
}
if ($var_22 == 3)
{
echo '
<td class="content" valign="top">
<form method="post" action="">
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td style="padding-bottom: 24px" colspan="2" class="gridHeader">
Database settings - Step 3 out of 6
</td>
</tr>
' . ($var_2 ? '<tr><td colspan="2" class="gridError">' . $var_2 . '</td></tr>' : '') . '
<tr>
<td class="gridLabels" width="200" nowrap>
Database hostname
</td>
<td class="gridContent">
<input type="text" class="inputText" name="db_hostname" value="' . get_session_var ('db_hostname') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Database name
</td>
<td class="gridContent">
<input type="text" class="inputText" name="db_database" value="' . get_session_var ('db_database') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Database username
</td>
<td class="gridContent">
<input type="text" class="inputText" name="db_username" value="' . get_session_var ('db_username') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Database password
</td>
<td class="gridContent">
<input type="text" class="inputText" name="db_password" value="' . get_session_var ('db_password') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td class="gridLabels" width="200" nowrap>
Tables prefix
</td>
<td class="gridContent">
<input type="text" class="inputText" name="db_prefix" value="' . get_session_var ('db_prefix') . '" style="width: 250px" />
</td>
</tr>
<tr>
<td style="padding-top: 24px" class="gridFooter" colspan="2">
<input class="inputSubmit" type="submit" name="step2" value="Back" />
<input class="inputSubmit" type="submit" name="step3" value="Next" />
</td>
</tr>
</table>
</form>
</td>
<td class="help" valign="top">
Specify your MySQL settings here.<br><br>Please note that the database for vldPersonals must be created prior to this step. If you have not created one yet, do so now.<br><br>You are also required to have ALTER and DROP permissions on the database tables in order to fully experience all vldPersonals features.
</td>';
return null;
}
if ($var_22 == 4)
{
echo '
<td class="content" valign="top">
<form method="post" action="">
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td style="padding-bottom: 24px" colspan="2" class="gridHeader">
Database settings - Step 4 out of 6
</td>
</tr>
' . ($var_2 ? '<tr><td colspan="2" class="gridError">' . $var_2 . '</td></tr>' : '') . '
<tr>
<td colspan="2" class="gridContent">
vldPersonals will now attempt to create all required tables and populate them with data.<br><br>Please note that if the database you have specified in the previous step contains any tables with the same names vldPersonals uses, they WILL be overwritten!<br><br>If this is the first time you are installing vldPersonals, there should be no conflicts. If you are reinstalling vldPersonals, make sure that you have backed up all your data before continuing.<br><br>Click on <b>Next</b> to continue.
</td>
</tr>
<tr>
<td style="padding-top: 24px" class="gridFooter" colspan="2">
<input class="inputSubmit" type="submit" name="step3" value="Back" />
<input class="inputSubmit" type="submit" name="step4" value="Next" />
</td>
</tr>
</table>
</form>
</td>
<td class="help" valign="top">
At this step vldPersonals will attempt to create all required tables and populate them with data.<br><br>Should something go wrong, go back to the Database Settings step and make sure everything is correct.
</td>';
return null;
}
if ($var_22 == 5)
{
echo '
<td class="content" valign="top">
<form method="post" action="">
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td style="padding-bottom: 24px" colspan="2" class="gridHeader">
Administrator account - Step 5 out of 6
</td>
</tr>
' . ($var_2 ? '<tr><td colspan="2" class="gridError">' . $var_2 . '</td></tr>' : '') . '
<tr>
<td class="gridLabels" width="120" nowrap>
Username
</td>
<td class="gridContent">
<input type="text" class="inputText" name="username" value="' . get_session_var ('username') . '" style="width: 300px" maxlength="32" />
</td>
</tr>
<tr>
<td class="gridLabels" width="120" nowrap>
Password
</td>
<td class="gridContent">
<input type="text" class="inputText" name="password" value="' . get_session_var ('password') . '" style="width: 300px" maxlength="32" />
</td>
</tr>
<tr>
<td class="gridLabels" width="120" nowrap>
Confirm password
</td>
<td class="gridContent">
<input type="text" class="inputText" name="password2" value="' . get_session_var ('password2') . '" style="width: 300px" maxlength="32" />
</td>
</tr>
<tr>
<td class="gridLabels" width="120" nowrap>
Email
</td>
<td class="gridContent">
<input type="text" class="inputText" name="email" value="' . get_session_var ('email') . '" style="width: 300px" maxlength="64" />
</td>
</tr>
<tr>
<td style="padding-top: 24px" class="gridFooter" colspan="2">
<input class="inputSubmit" type="submit" name="step4" value="Back" />
<input class="inputSubmit" type="submit" name="step5" value="Next" />
</td>
</tr>
</table>
</form>
</td>
<td class="help" valign="top">
Setup an administrator account for yourself. This will allow you to manage the website.
</td>';
return null;
}
if ($var_22 == 6)
{
echo '
<td class="content" valign="top">
<form method="post" action="">
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td style="padding-bottom: 24px" colspan="2" class="gridHeader">
Done
</td>
</tr>
' . ($var_2 ? '<tr><td colspan="2" class="gridError">' . $var_2 . '</td></tr>' : '') . '
<tr>
<td class="gridLabels" width="170" nowrap>
<b>Administrator username:</b>
</td>
<td class="gridContent">
' . get_session_var ('username') . '
</td>
</tr>
<tr>
<td class="gridLabels" width="170" nowrap>
<b>Administrator password:</b>
</td>
<td class="gridContent">
' . get_session_var ('password') . '
</td>
</tr>
<tr>
<td style="padding-top: 24px" class="gridContent" colspan="2">
Using your FTP program, please delete the file called <b>install.php</b> from your server. Leaving it on your server presents a security risk.
</td>
</tr>
' . ($var_20 ? '
<tr>
<td style="padding-top: 24px" class="gridContent" colspan="2">
Please save the content of the text area below into <b>config.php</b>. You can find it in the <b>includes</b> folder.
</td>
</tr>
<tr>
<td class="gridContent" colspan="2">
<textarea name="config" cols="30" rows="5" style="width: 480px; height: 120px;" class="inputTextarea">' . htmlentities ($var_20) . '</textarea>
</td>
</tr>
' : '') . '
<tr>
<td style="padding-top: 24px" class="gridFooter" colspan="2">
<a target="_blank" href="' . get_session_var ('vir_cp_path') . '">Click here to access your control panel</a> | <a target="_blank" href="' . get_session_var ('vir_path') . '">Click here to view your website</a>
</td>
</tr>
<tr>
<td class="gridFooter" colspan="2">
Please bookmark the links above.
</td>
</tr>
</table>
</form>
</td>
<td class="help" valign="top">
vldPersonals setup has finished. The system should now be configured and ready for use.<br><br>Write down the username and password so you do not forget them!<br><br>Also bookmark two links on the left side as those are where your website is located along with the administration panel.
</td>';
}
}
function template_footer ()
{
echo '
<td style="width: 20px; height: 400px; background: #3f6ca9;"> </td>
</tr>
<tr>
<td style="width: 20px; height: 20px; background: #ffffff; background: url(\'includes/templates/media/install/tbl_bl.gif\') no-repeat"> </td>
<td style="width: 500px; height: 20px; background: #ffffff;"> </td>
<td style="width: 200px; height: 20px; background: #3f6ca9;"> </td>
<td style="width: 20px; height: 20px; background: #3f6ca9; background: url(\'includes/templates/media/install/tbl_br.gif\') no-repeat"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>';
}
function get_session_var ($var_23)
{
return (isset ($_SESSION[$var_23]) ? htmlentities ($_SESSION[$var_23]) : '');
}
function sql_queries ($var_15)
{
global $DB;
if (!mysql_errno ())
{
$DB->query ('DROP TABLE IF EXISTS `' . $_SESSION['db_prefix'] . 'albums`');
}
if (!mysql_errno ())
{
$DB->query("CREATE TABLE `".$_SESSION['db_prefix']."albums` (\r\n\t\t`album_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`description` varchar(255) NOT NULL default '',\r\n\t\t`filename` varchar(32) NOT NULL default '',\r\n\t\t`password` VARCHAR(20) NOT NULL DEFAULT '',\r\n\t\t`adult` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`dateadded` int(10) unsigned NOT NULL default '0',\r\n\t\t`dateupdated` int(10) unsigned NOT NULL default '0',\r\n\t\t`totalapictures` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalipictures` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`accesslevel` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`album_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."audios`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."audios` (\r\n\t\t`audio_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`filename` varchar(32) NOT NULL default '',\r\n\t\t`description` varchar(255) default '',\r\n\t\t`dateadded` int(10) unsigned NOT NULL default '0',\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`name` varchar(64) NOT NULL default '',\r\n\t\t`totalvotes` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalscore` int(6) unsigned NOT NULL default '0',\r\n\t\t`rated` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`audio_id`),\r\n\t\tKEY `member_id` (`member_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."blocked`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."blocked` (\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`blocked_id` int(9) unsigned NOT NULL default '0',\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `blocked_id` (`blocked_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."blocked_countries`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."blocked_countries` (\r\n\t\t`country_id` char(2) NOT NULL default '',\r\n\t\t`name` varchar(128) NOT NULL default '',\r\n\t\t`noaccess` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`nomessages` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`nocomments` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`country_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."blocked_ips`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."blocked_ips` (\r\n\t\t`country_id` char(2) NOT NULL default '',\r\n\t\t`ipaddress1` int(11) NOT NULL default '0',\r\n\t\t`ipaddress2` int(11) NOT NULL default '0',\r\n\t\tKEY `country_id` (`country_id`),\r\n\t\tKEY `ipaddress1` (`ipaddress1`),\r\n\t\tKEY `ipaddress2` (`ipaddress2`)\r\n\t $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."blogs`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."blogs` (\r\n\t\t`entry_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`title` varchar(128) NOT NULL default '',\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(10) unsigned NOT NULL default '0',\r\n\t\t`picture` char(32) NOT NULL default '',\r\n\t\t`comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`totalcomments` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalviews` int(9) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`entry_id`),\r\n\t\tKEY `member_id` (`member_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."blogs_comments`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."blogs_comments` (\r\n\t\t`comment_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`entry_id` int(9) unsigned NOT NULL,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`poster_id` int(9) unsigned NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(9) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`comment_id`),\r\n\t\tKEY `entry_id` (`entry_id`),\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `poster_id` (`poster_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."categories`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."categories` (\r\n\t `category_id` int(6) unsigned NOT NULL auto_increment,\r\n\t `type_id` smallint(4) unsigned NOT NULL default '0',\r\n\t `name_english` varchar(128) NOT NULL default '',\r\n\t PRIMARY KEY (`category_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."categories` values (1, 1, 'General')" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."chats`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."chats` (\r\n\t\t`message_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`mid1` int(9) unsigned NOT NULL default '0',\r\n\t\t`mid2` int(9) unsigned NOT NULL default '0',\r\n\t\t`username` varchar(32) NOT NULL default '',\r\n\t\t`body` text NOT NULL,\r\n\t\t`timeposted` int(10) unsigned NOT NULL,\r\n\t\t`unread` tinyint(1) unsigned NOT NULL default '1',\r\n\t\tPRIMARY KEY (`message_id`),\r\n\t\tKEY `mid1` (`mid1`),\r\n\t\tKEY `mid2` (`mid2`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."chats_blocks`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."chats_blocks` (\r\n\t\t`member_id1` int(9) unsigned NOT NULL,\r\n\t\t`member_id2` int(9) unsigned NOT NULL,\r\n\t\t`expirydate` int(10) unsigned NOT NULL,\r\n\t\tKEY `member_id1` (`member_id1`),\r\n\t\tKEY `member_id2` (`member_id2`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."countries`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."countries` (\r\n\t\t`cc_code` char(2) NOT NULL,\r\n\t\t`cc_name` varchar(64) NOT NULL,\r\n\t\tPRIMARY KEY (`cc_code`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."countries`\r\n\t\tvalues ('AD','Andorra'),('AE','United Arab Emirates'),('AF','Afghanistan'),('AG','Antigua and Barbuda'),('AI','Anguilla'),('AL','Albania'),('AM','Armenia'),('AN','Netherlands Antilles'),('AO','Angola'),('AQ','Antarctica'),('AR','Argentina'),('AS','American Samoa'),('AT','Austria'),('AU','Australia'),('AW','Aruba'),('AZ','Azerbaijan'),('BA','Bosnia and Herzegovina'),('BB','Barbados'),('BD','Bangladesh'),('BE','Belgium'),('BF','Burkina Faso'),('BG','Bulgaria'),('BH','Bahrain'),('BI','Burundi'),('BJ','Benin'),('BM','Bermuda'),('BN','Brunei Darussalam'),('BO','Bolivia'),('BR','Brazil'),('BS','Bahamas'),('BT','Bhutan'),('BV','Bouvet Island'),('BW','Botswana'),('BY','Belarus'),('BZ','Belize'),('CA','Canada'),('CC','Cocos (Keeling) Islands'),('CF','Central African Republic'),('CG','Congo'),('CH','Switzerland'),('CI','Cote DIvoire (Ivory Coast)'),('CK','Cook Islands'),('CL','Chile'),('CM','Cameroon'),('CN','China'),('CO','Colombia'),('CR','Costa Rica'),('CS','Czechoslovakia (former)'),('CU','Cuba'),('CV','Cape Verde'),('CX','Christmas Island'),('CY','Cyprus'),('CZ','Czech Republic'),('DE','Germany'),('DJ','Djibouti'),('DK','Denmark'),('DM','Dominica'),('DO','Dominican Republic'),('DZ','Algeria'),('EC','Ecuador'),('EE','Estonia'),('EG','Egypt'),('EH','Western Sahara'),('ER','Eritrea'),('ES','Spain'),('ET','Ethiopia'),('FI','Finland'),('FJ','Fiji'),('FK','Falkland Islands (Malvinas)'),('FM','Micronesia'),('FO','Faroe Islands'),('FR','France'),('FX','France, Metropolitan'),('GA','Gabon'),('GB','Great Britain (UK)'),('GD','Grenada'),('GE','Georgia'),('GF','French Guiana'),('GH','Ghana'),('GI','Gibraltar'),('GL','Greenland'),('GM','Gambia'),('GN','Guinea'),('GP','Guadeloupe'),('GQ','Equatorial Guinea'),('GR','Greece'),('GS','S. Georgia and S. Sandwich Isls.'),('GT','Guatemala'),('GU','Guam'),('GW','Guinea-Bissau'),('GY','Guyana'),('HK','Hong Kong'),('HM','Heard and McDonald Islands'),('HN','Honduras'),('HR','Croatia (Hrvatska)'),('HT','Haiti'),('HU','Hungary'),('ID','Indonesia'),('IE','Ireland'),('IL','Israel'),('IN','India'),('IO','British Indian Ocean Territory'),('IQ','Iraq'),('IR','Iran'),('IS','Iceland'),('IT','Italy'),('JM','Jamaica'),('JO','Jordan'),('JP','Japan'),('KE','Kenya'),('KG','Kyrgyzstan'),('KH','Cambodia'),('KI','Kiribati'),('KM','Comoros'),('KN','Saint Kitts and Nevis'),('KP','Korea (North)'),('KR','Korea (South)'),('KW','Kuwait'),('KY','Cayman Islands'),('KZ','Kazakhstan'),('LA','Laos'),('LB','Lebanon'),('LC','Saint Lucia'),('LI','Liechtenstein'),('LK','Sri Lanka'),('LR','Liberia'),('LS','Lesotho'),('LT','Lithuania'),('LU','Luxembourg'),('LV','Latvia'),('LY','Libya'),('MA','Morocco'),('MC','Monaco'),('MD','Moldova'),('MG','Madagascar'),('MH','Marshall Islands'),('MK','Macedonia'),('ML','Mali'),('MM','Myanmar'),('MN','Mongolia'),('MO','Macau'),('MP','Northern Mariana Islands'),('MQ','Martinique'),('MR','Mauritania'),('MS','Montserrat'),('MT','Malta'),('MU','Mauritius'),('MV','Maldives'),('MW','Malawi'),('MX','Mexico'),('MY','Malaysia'),('MZ','Mozambique'),('NA','Namibia'),('NC','New Caledonia'),('NE','Niger'),('NF','Norfolk Island'),('NG','Nigeria'),('NI','Nicaragua'),('NL','Netherlands'),('NO','Norway'),('NP','Nepal'),('NR','Nauru'),('NT','Neutral Zone'),('NU','Niue'),('NZ','New Zealand (Aotearoa)'),('OM','Oman'),('PA','Panama'),('PE','Peru'),('PF','French Polynesia'),('PG','Papua New Guinea'),('PH','Philippines'),('PK','Pakistan'),('PL','Poland'),('PM','St. Pierre and Miquelon'),('PN','Pitcairn'),('PR','Puerto Rico'),('PT','Portugal'),('PW','Palau'),('PY','Paraguay'),('QA','Qatar'),('RE','Reunion'),('RO','Romania'),('RU','Russian Federation'),('RW','Rwanda'),('SA','Saudi Arabia'),('SB','Solomon Islands'),('SC','Seychelles'),('SD','Sudan'),('SE','Sweden'),('SG','Singapore'),('SH','St. Helena'),('SI','Slovenia'),('SJ','Svalbard and Jan Mayen Islands'),('SK','Slovak Republic'),('SL','Sierra Leone'),('SM','San Marino'),('SN','Senegal'),('SO','Somalia'),('SR','Suriname'),('ST','Sao Tome and Principe'),('SU','USSR (former)'),('SV','El Salvador'),('SY','Syria'),('SZ','Swaziland'),('TC','Turks and Caicos Islands'),('TD','Chad'),('TF','French Southern Territories'),('TG','Togo'),('TH','Thailand'),('TJ','Tajikistan'),('TK','Tokelau'),('TM','Turkmenistan'),('TN','Tunisia'),('TO','Tonga'),('TP','East Timor'),('TR','Turkey'),('TT','Trinidad and Tobago'),('TV','Tuvalu'),('TW','Taiwan'),('TZ','Tanzania'),('UA','Ukraine'),('UG','Uganda'),('UK','United Kingdom'),('UM','US Minor Outlying Islands'),('US','United States'),('UY','Uruguay'),('UZ','Uzbekistan'),('VA','Vatican City State (Holy See)'),('VC','Saint Vincent and the Grenadines'),('VE','Venezuela'),('VG','Virgin Islands (British)'),('VI','Virgin Islands (U.S.)'),('VN','Viet Nam'),('VU','Vanuatu'),('WF','Wallis and Futuna Islands'),('WS','Samoa'),('YE','Yemen'),('YT','Mayotte'),('YU','Yugoslavia'),('ZA','South Africa'),('ZM','Zambia'),('ZR','Zaire'),('ZW','Zimbabwe')\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."email_templates`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."email_templates` (\r\n\t `template_id` tinyint(3) unsigned NOT NULL auto_increment,\r\n\t `group_id` tinyint(3) unsigned NOT NULL default '0',\r\n\t `label` varchar(64) NOT NULL default '',\r\n\t `subject_english` varchar(255) NOT NULL default '',\r\n\t `body_english` text NOT NULL,\r\n\t `body_html_english` text NOT NULL,\r\n\t `orderid` tinyint(3) unsigned NOT NULL default '0',\r\n\t PRIMARY KEY (`template_id`),\r\n\t KEY `group_id` (`group_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."email_templates`(`template_id`,`group_id`,`label`,`subject_english`,`body_english`,`orderid`,`body_html_english`) values\r\n\t\t(1,1,'member_activation_instructions','Activate your account','Hello {username},\n\nYour username is {username}\nYour password is {password}\n\nActivate your account at {activation_link}\n\nThank you\n\n{website}',1,'Hello {username},<br />\n<br />\nYour username is {username}<br />\nYour password is {password}<br />\n<br />\nActivate your account at {activation_link}<br />\n<br />\nThank you<br />\n<br />\n{website}'),\r\n\t\t(2,1,'validated_member_notify','Your membership account has been activated','Hello {username},\n\nThanks for joining {website}',4,'Hello {username},<br />\n<br />\nThanks for joining {website}'),\r\n\t\t(3,1,'declined_member_notify','Your membership account has been declined','Hello {username},\n\nYour membership account has been declined.\n\nThank you,\n\n{website}',5,'Hello {username},<br />\n<br />\nYour membership account has been declined.<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(4,1,'admin_notify_registration','Notification of member registration','New user has signed up\n\nUsername {username}\nUsername {username}\nPassword {password}\nEmail {email}\n\nActivate user at {activation_link}\nDecline user at {decline_link}',6,'New user has signed up<br />\n<br />\nUsername {username}<br />\nUsername {username}<br />\nPassword {password}<br />\nEmail {email}<br />\n<br />\nActivate user at {activation_link}<br />\nDecline user at {decline_link}'),\r\n\t\t(5,2,'lost_password_instructions','Login information','Hello {username},\n\nTo reset your password follow the link below\n\n{reset_link}\n\nThank you,\n{website}',7,'Hello {username},<br />\n<br />\nTo reset your password follow the link below<br />\n<br />\n{reset_link}<br />\n<br />\nThank you,<br />\n{website}'),\r\n\t\t(6,2,'reset_password_notify','New login information','Hello {username},\n\nYour new password is {password}.\n\nYou can change it in your profile if you like.\n\nThank you,\n\n{website}',8,'Hello {username},<br />\n<br />\nYour new password is {password}.<br />\n<br />\nYou can change it in your profile if you like.<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(7,1,'friend_notify','Somebody wants to add you as friend','Hello {username},\n\n{from_username} wants to add you as a friend.\n\nFollow the link below to see the request:\n{friends_link}\n\nThank you,\n\n{website}',10,'Hello {username},<br />\n<br />\n{from_username} wants to add you as a friend.<br />\n<br />\nFollow the link below to see the request:<br />\n{friends_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(8,1,'message_notify','You received a new message','Hello {username},\n\n{from_username} has just sent you a private message.\n\nFollow the link below to read it:\n{message_link}\n\nThank you,\n\n{website}',9,'Hello {username},<br />\n<br />\n{from_username} has just sent you a private message.<br />\n<br />\nFollow the link below to read it:<br />\n{message_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(9,1,'blog_comment_notify','New blog comment','Hello {username},\n\n{from_username} has just commented on your blog entry.\n\nFollow the link below to read it:\n{blog_link}\n\nThank you,\n\n{website}',11,'Hello {username},<br />\n<br />\n{from_username} has just commented on your blog entry.<br />\n<br />\nFollow the link below to read it:<br />\n{blog_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(10,1,'guestbook_comment_notify','New guestbook comment','Hello {username},\n\n{from_username} has just signed your guestbook.\n\nFollow the link below to read it:\n{guestbook_link}\n\nThank you,\n\n{website}',12,'Hello {username},<br />\n<br />\n{from_username} has just signed your guestbook.<br />\n<br />\nFollow the link below to read it:<br />\n{guestbook_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(11,1,'member_activation_reminder','Activation reminder','Hello {username},\n\nWe noticed that you did not activate your account yet.\n\nActivate your account at {activation_link}\n\nThank you,\n\n{website}',2,'Hello {username},<br />\n<br />\nWe noticed that you did not activate your account yet.<br />\n<br />\nActivate your account at {activation_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(12,1,'member_expiration_reminder','Expiration reminder','Hello {username},\n\nWe noticed that your paid membership expires soon. Don\\'t forget to renew it to keep all the benefits of paid members.\n\nThank you,\n\n{website}',3,'Hello {username},<br />\n<br />\nWe noticed that your paid membership expires soon. Don\\'t forget to renew it to keep all the benefits of paid members.<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(13,1,'picture_comment_notify','New picture comment','Hello {username},\n\n{from_username} has just commented on your picture.\n\nFollow the link below to read it:\n{picture_link}\n\nThank you,\n\n{website}',13,'Hello {username},<br />\n<br />\n{from_username} has just commented on your picture.<br />\n<br />\nFollow the link below to read it:<br />\n{picture_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(14,1,'video_comment_notify','New video comment','Hello {username},\n\n{from_username} has just commented on your video.\n\nFollow the link below to read it:\n{video_link}\n\nThank you,\n\n{website}',14,'Hello {username},<br />\n<br />\n{from_username} has just commented on your video.<br />\n<br />\nFollow the link below to read it:<br />\n{video_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(15,1,'happy_bday_notify','Happy birthday','Hello {username},\n\nJust wanted to wish you a happy birthday!\n\nThank you,\n\n{website}',15,'Hello {username},<br />\n<br />\nJust wanted to wish you a happy birthday!<br />\n<br />\nThank you,<br />\n<br />\n{website}'),\r\n\t\t(16,1,'gift_notify','You received a gift','Hello {username},\n\n{from_username} has just sent you a gift.\n\nFollow the link below to see it:\n{gift_link}\n\nThank you,\n\n{website}',16,'Hello {username},<br />\n<br />\n{from_username} has just sent you a gift.<br />\n<br />\nFollow the link below to see it:<br />\n{gift_link}<br />\n<br />\nThank you,<br />\n<br />\n{website}');" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events` (\r\n\t\t`event_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`name` varchar(255) NOT NULL,\r\n\t\t`dateadded` int(10) unsigned NOT NULL default '0',\r\n\t\t`startdate` int(10) unsigned NOT NULL,\r\n\t\t`enddate` int(10) unsigned NOT NULL,\r\n\t\t`maxguests` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalguests` smallint(5) unsigned NOT NULL,\r\n\t\t`comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`totalcomments` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`picture` varchar(32) NOT NULL default '',\r\n\t\t`picture_active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`totalapictures` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalipictures` smallint(5) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`event_id`),\r\n\t\tKEY `member_id` (`member_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_data`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_data` (\r\n\t\t`data_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`data_place` varchar(128) NOT NULL,\r\n\t\t`data_summary` text NOT NULL,\r\n\t\t`data_description` text NOT NULL,\r\n\t\tUNIQUE KEY `data_id` (`data_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_comments`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_comments` (\r\n\t\t`comment_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`event_id` int(9) unsigned NOT NULL,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`poster_id` int(9) unsigned NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(9) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`comment_id`),\r\n\t\tKEY `event_id` (`event_id`),\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `poster_id` (`poster_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_fields`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_fields` (\r\n\t\t`field_id` smallint(4) unsigned NOT NULL auto_increment,\r\n\t\t`label` varchar(32) NOT NULL default '',\r\n\t\t`name_english` varchar(255) NOT NULL default '',\r\n\t\t`type` varchar(12) NOT NULL default '',\r\n\t\t`default_value` varchar(255) NOT NULL default '',\r\n\t\t`maxlength` varchar(5) NOT NULL default '',\r\n\t\t`width` varchar(5) NOT NULL default '',\r\n\t\t`height` varchar(5) NOT NULL default '',\r\n\t\t`required` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_search` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_search_multi` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`orderid` int(4) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`field_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."events_fields`(`field_id`,`label`,`name_english`,`type`,`default_value`,`maxlength`,`width`,`height`,`required`,`orderid`) values (1,'place','Location','text','','128','200px','','1',1)" );
}
if ( !mysql_errno( ) )
{
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."events_fields`(`field_id`,`label`,`name_english`,`type`,`default_value`,`maxlength`,`width`,`height`,`required`,`orderid`) values (2,'summary','Summary','textarea','','400','100%','80px','1',2)" );
}
if ( !mysql_errno( ) )
{
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."events_fields`(`field_id`,`label`,`name_english`,`type`,`default_value`,`maxlength`,`width`,`height`,`required`,`orderid`) values (3,'description','Description','textarea','','1500','100%','100px','0',3)" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_fields_items`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_fields_items` (\r\n\t\t`item_id` int(6) unsigned NOT NULL auto_increment,\r\n\t\t`field_id` smallint(4) unsigned NOT NULL,\r\n\t\t`value_english` varchar(255) NOT NULL,\r\n\t\t`orderid` int(6) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`item_id`),\r\n\t\tKEY `field_id` (`field_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_guests`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_guests` (\r\n\t\t`event_id` int(10) unsigned NOT NULL,\r\n\t\t`guest_id` int(10) unsigned NOT NULL,\r\n\t\tKEY `event_id` (`event_id`),\r\n\t\tKEY `guest_id` (`guest_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_items`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_items` (\r\n\t\t`data_id` int(9) unsigned NOT NULL,\r\n\t\t`field_id` smallint(4) unsigned NOT NULL,\r\n\t\t`item_id` int(6) unsigned NOT NULL,\r\n\t\tKEY `data_id` (`data_id`),\r\n\t\tKEY `field_id` (`field_id`),\r\n\t\tKEY `item_id` (`item_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."events_pictures`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."events_pictures` (\r\n\t\t`picture_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`event_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`filename` varchar(32) NOT NULL,\r\n\t\t`description` varchar(255) NOT NULL default '',\r\n\t\t`dateadded` int(10) unsigned NOT NULL default '0',\r\n\t\t`rated` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`totalvotes` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalscore` int(6) unsigned NOT NULL default '0',\r\n\t\t`active` tinyint(1) NOT NULL default '1',\r\n\t\t`primarypic` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`picture_id`),\r\n\t\tKEY `event_id` (`event_id`),\r\n\t\tKEY `member_id` (`member_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."extensions`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."extensions` (\r\n\t `extension_id` int(3) unsigned NOT NULL auto_increment,\r\n\t `name` varchar(32) NOT NULL default '',\r\n\t `label` varchar(32) NOT NULL default '',\r\n\t PRIMARY KEY (`extension_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."favorites`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."favorites` (\r\n\t `member_id` int(9) unsigned NOT NULL default '0',\r\n\t `favorite_id` int(9) unsigned NOT NULL default '0',\r\n\t KEY `member_id` (`member_id`),\r\n\t KEY `favorite_id` (`favorite_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."fields`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."fields` (\r\n\t\t`field_id` int(4) unsigned NOT NULL auto_increment,\r\n\t\t`group_id` tinyint(3) unsigned NOT NULL default '0',\r\n\t\t`type_id` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`label` varchar(32) NOT NULL default '',\r\n\t\t`search_label` varchar(32) NOT NULL default '',\r\n\t\t`name_english` varchar(255) NOT NULL,\r\n\t\t`type` varchar(12) NOT NULL default '',\r\n\t\t`default_value` varchar(255) NOT NULL default '',\r\n\t\t`maxlength` varchar(5) NOT NULL default '',\r\n\t\t`width` varchar(5) NOT NULL default '',\r\n\t\t`height` varchar(5) NOT NULL default '',\r\n\t\t`required` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_registration` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_search` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_search_range` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_a_search` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_browse` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_a_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_s_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_p_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_matchmaker` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_search_multi` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`orderid` int(4) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`field_id`),\r\n\t\tKEY `group_id` (`group_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."fields`(`field_id`,`group_id`,`type_id`,`label`,`name_english`,`type`,`default_value`,`maxlength`,`width`,`height`,`required`,`in_registration`,`in_search`,`in_a_search`,`in_browse`,`in_a_profile`,`in_s_profile`,`in_p_profile`,`orderid`,`search_label`)\r\n\t\tvalues (1,1,'1','gender1','I am','combo','1','','','','1','1','1','1','1','1','0','1',1,'gender2'),\r\n\t\t(2,1,'1','gender2','Seeking a','combo','3','','','','1','1','1','1','1','1','0','1',2,'gender1'),\r\n\t\t(3,1,'1','age','Age','birthday','30','','','','1','1','1','1','1','1','0','1',3,''),\r\n\t\t(4,1,'1','country','Country','combo','5','','','','1','1','1','1','1','1','0','1',4,''),\r\n\t\t(5,1,'1','city','City','text','','64','150px','','1','1','1','1','1','1','0','1',5,''),\r\n\t\t(7,2,'1','bodytype','Body type','combo','','','','','0','0','0','0','0','1','0','1',1,''),\r\n\t\t(8,2,'1','height','Height','combo','','','','','0','0','0','0','0','1','0','1',2,''),\r\n\t\t(9,2,'1','eyes','Eyes','combo','','','','','0','0','0','0','0','1','0','1',3,''),\r\n\t\t(10,2,'1','hair','Hair','combo','','','','','0','0','0','0','0','1','0','1',3,''),\r\n\t\t(11,2,'1','ethnicity','Ethnicity','combo','','','','','0','0','0','0','0','1','0','1',4,''),\r\n\t\t(12,3,'1','maritialstatus','Marital Status','combo','','','','','0','0','0','0','0','1','0','1',5,''),\r\n\t\t(13,3,'1','havekids','Have Kids','combo','','','','','0','0','0','0','0','1','0','1',6,''),\r\n\t\t(14,3,'1','wantkids','Want (more) kids','combo','','','','','0','0','0','0','0','1','0','1',7,''),\r\n\t\t(15,4,'1','education','Education','combo','','','','','0','0','0','0','0','1','0','1',1,''),\r\n\t\t(16,4,'1','employment','Employment Status','combo','','','','','0','0','0','0','0','1','0','1',2,''),\r\n\t\t(17,4,'1','occupation','Occupation','combo','','','','','0','0','0','0','0','1','0','1',3,''),\r\n\t\t(18,4,'1','income','Income','combo','','','','','0','0','0','0','0','1','0','1',3,''),\r\n\t\t(19,5,'1','smoking','Smoking','combo','','','','','0','0','0','1','0','1','0','1',1,''),\r\n\t\t(20,5,'1','drinking','Drinking','combo','','','','','0','0','0','1','0','1','0','1',2,''),\r\n\t\t(21,5,'1','livingsituation','Living Situation','checkbox','','','','','0','0','0','1','0','1','0','1',3,''),\r\n\t\t(22,5,'1','socialsettings','Social Setting','checkbox','','','','','0','0','0','1','0','1','0','1',4,''),\r\n\t\t(23,5,'1','tvwatching','TV Watching','checkbox','','','','','0','0','0','1','0','1','0','1',5,''),\r\n\t\t(24,5,'1','languages','Languages','checkbox','','','','','0','0','0','0','0','1','0','1',6,''),\r\n\t\t(25,6,'1','religion','Religion','combo','','','','','0','0','0','0','0','1','0','1',1,''),\r\n\t\t(26,6,'1','attendservices','Attend Services','combo','','','','','0','0','0','0','0','1','0','1',2,''),\r\n\t\t(27,6,'1','politicalviews','Political Views','combo','','','','','0','0','0','0','0','1','0','1',3,''),\r\n\t\t(28,6,'1','senseofhumor','Sense of Humor','checkbox','','','','','0','0','0','0','0','1','0','1',4,''),\r\n\t\t(29,6,'1','interests','Interests','checkbox','','','','','0','0','0','0','0','1','0','1',5,''),\r\n\t\t(30,6,'1','inmyownwords','In my own words','textarea','','','100%','120px','0','0','0','0','0','1','0','1',6,'')\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_matchmaker='1' WHERE label='gender1' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_matchmaker='1' WHERE label='gender2' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_matchmaker='1' WHERE label='country' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_matchmaker='1' WHERE label='city' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_matchmaker='1' WHERE label='interests' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_search_multi='1' WHERE label='smoking' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields` SET in_search_multi='1' WHERE label='drinking' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."fields_groups`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."fields_groups` (\r\n\t\t`group_id` int(3) unsigned NOT NULL auto_increment,\r\n\t\t`type_id` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`label` varchar(32) NOT NULL default '',\r\n\t\t`name_english` varchar(255) NOT NULL default '',\r\n\t\t`in_registration` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_search` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_a_search` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_browse` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_a_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_s_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_p_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`in_matchmaker` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`orderid` int(3) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`group_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."fields_groups`(`group_id`,`type_id`,`label`,`name_english`,`in_registration`,`in_search`,`in_a_search`,`in_browse`,`in_a_profile`,`in_s_profile`,`in_p_profile`,`orderid`) values\r\n\t\t(1,'1','general','General','1','1','1','1','1','0','1',1),\r\n\t\t(2,'1','appearance','Appearance','0','0','0','0','1','0','1',2),\r\n\t\t(3,'1','home_family','Home and Family\n','0','0','0','0','1','0','1',4),\r\n\t\t(4,'1','professional_life','Professional Life\n','0','0','0','0','1','0','1',5),\r\n\t\t(5,'1','lifestyle','Lifestyle','0','0','1','0','1','0','1',3),\r\n\t\t(6,'1','personal','Personal','0','0','0','0','1','0','1',6)\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields_groups` SET in_matchmaker='1' WHERE label='general' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "UPDATE `".$_SESSION['db_prefix']."fields_groups` SET in_matchmaker='1' WHERE label='personal' LIMIT 1" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."fields_items`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."fields_items` (\r\n\t\t`item_id` int(6) unsigned NOT NULL auto_increment,\r\n\t\t`field_id` smallint(4) unsigned NOT NULL,\r\n\t\t`value_english` varchar(255) NOT NULL,\r\n\t\t`orderid` int(6) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`item_id`),\r\n\t\tKEY `field_id` (`field_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."fields_items`(`item_id`,`field_id`,`value_english`,`orderid`) values (1,1,'Man',1),(2,1,'Woman',2),(3,2,'Woman',1),(4,2,'Man',2),(5,4,'Canada',1),(6,4,'United States',2),(7,4,'Afghanistan',3),(8,4,'Albania',4),(9,4,'Algeria',5),(10,4,'American Samoa',6),(11,4,'Andorra',7),(12,4,'Angola',8),(13,4,'Anguilla',9),(14,4,'Antarctica',10),(15,4,'Antigua and Barbuda',11),(16,4,'Argentina',12),(17,4,'Armenia',13),(18,4,'Aruba',14),(19,4,'Australia',15),(20,4,'Austria',16),(21,4,'Azerbaijan',17),(22,4,'Bahamas',18),(23,4,'Bahrain',19),(24,4,'Bangladesh',20),(25,4,'Barbados',21),(26,4,'Belarus',22),(27,4,'Belgium',23),(28,4,'Belize',24),(29,4,'Benin',25),(30,4,'Bermuda',26),(31,4,'Bhutan',27),(32,4,'Bolivia',28),(33,4,'Bosnia/Herzegowina',29),(34,4,'Botswana',30),(35,4,'Bouvet Island',31),(36,4,'Brazil',32),(37,4,'British Ind. Ocean',33),(38,4,'Brunei Darussalam',34),(39,4,'Bulgaria',35),(40,4,'Burkina Faso',36),(41,4,'Burundi',37),(42,4,'Cambodia',38),(43,4,'Cameroon',39),(44,4,'Cape Verde',40),(45,4,'Cayman Islands',41),(46,4,'Central African Rep.',42),(47,4,'Chad',43),(48,4,'Chile',44),(49,4,'China',45),(50,4,'Christmas Island',46),(51,4,'Cocoa (Keeling) Is.',47),(52,4,'Colombia',48),(53,4,'Comoros',49),(54,4,'Congo',50),(55,4,'Cook Islands',51),(56,4,'Costa Rica',52),(57,4,'Cote Divoire',53),(58,4,'Croatia',54),(59,4,'Cuba',55),(60,4,'Cyprus',56),(61,4,'Czech Republic',57),(62,4,'Denmark',58),(63,4,'Djibouti',59),(64,4,'Dominica',60),(65,4,'Dominican Republic',61),(66,4,'East Timor',62),(67,4,'Ecuador',63),(68,4,'Egypt',64),(69,4,'El Salvador',65),(70,4,'Equatorial Guinea',66),(71,4,'Eritrea',67),(72,4,'Estonia',68),(73,4,'Ethiopia',69),(74,4,'Falkland Islands',70),(75,4,'Faroe Islands',71),(76,4,'Fiji',72),(77,4,'Finland',73),(78,4,'France',74),(79,4,'Gabon',75),(80,4,'Gambia',76),(81,4,'Georgia',77),(82,4,'Germany',78),(83,4,'Ghana',79),(84,4,'Gibraltar',80),(85,4,'Greece',81),(86,4,'Greenland',82),(87,4,'Grenada',83),\r\n\t(88,4,'Guadeloupe',84),(89,4,'Guam',85),(90,4,'Guatemala',86),(91,4,'Guinea',87),(92,4,'Guinea-Bissau',88),(93,4,'Guyana',89),(94,4,'Haiti',90),(95,4,'Honduras',91),(96,4,'Hong Kong',92),(97,4,'Hungary',93),(98,4,'Iceland',94),(99,4,'India',95),(100,4,'Indonesia',96),(101,4,'Iran',97),(102,4,'Iraq',98),(103,4,'Ireland',99),(104,4,'Israel',100),(105,4,'Italy',101),(106,4,'Jamaica',102),(107,4,'Japan',103),(108,4,'Jordan',104),(109,4,'Kazakhstan',105),(110,4,'Kenya',106),(111,4,'Kiribati',107),(112,4,'Korea',108),(113,4,'Kuwait',109),(114,4,'Kyrgyzstan',110),(115,4,'Lao',111),(116,4,'Latvia',112),(117,4,'Lebanon',113),(118,4,'Lesotho',114),(119,4,'Liberia',115),(120,4,'Liechtenstein',116),(121,4,'Lithuania',117),(122,4,'Luxembourg',118),(123,4,'Macau',119),(124,4,'Macedonia',120),(125,4,'Madagascar',121),(126,4,'Malawi',122),(127,4,'Malaysia',123),(128,4,'Maldives',124),(129,4,'Mali',125),(130,4,'Malta',126),(131,4,'Marshall Islands',127),(132,4,'Martinique',128),(133,4,'Mauritania',129),(134,4,'Mauritius',130),(135,4,'Mayotte',131),(136,4,'Mexico',132),(137,4,'Micronesia',133),(138,4,'Moldova',134),(139,4,'Monaco',135),(140,4,'Mongolia',136),(141,4,'Montserrat',137),(142,4,'Morocco',138),(143,4,'Mozambique',139),(144,4,'Myanmar',140),(145,4,'Namibia',141),(146,4,'Nauru',142),(147,4,'Nepal',143),(148,4,'Netherlands',144),(149,4,'New Caledonia',145),(150,4,'New Zealand',146),(151,4,'Nicaragua',147),(152,4,'Niger',148),(153,4,'Nigeria',149),(154,4,'Niue',150),(155,4,'Norfolk Island',151),(156,4,'Norway',152),(157,4,'Oman',153),(158,4,'Pakistan',154),(159,4,'Palau',155),(160,4,'Panama',156),(161,4,'Papua New Guinea',157),(162,4,'Paraguay',158),(163,4,'Peru',159),(164,4,'Philippines',160),(165,4,'Pitcairn',161),(166,4,'Poland',162),(167,4,'Portugal',163),(168,4,'Puerto Rico',164),(169,4,'Qatar',165),(170,4,'Reunion',166),(171,4,'Romania',167),(172,4,'Russia',168),(173,4,'Rwanda',169),(174,4,'Saint Lucia',170),(175,4,'Samoa',171),(176,4,'San Marino',172),(177,4,'Saudi Arabia',173),(178,4,'Senegal',174),\r\n\t(179,4,'Seychelles',175),(180,4,'Sierra Leone',176),(181,4,'Singapore',177),(182,4,'Slovakia',178),(183,4,'Solomon Islands',179),(184,4,'Somalia',180),(185,4,'South Africa',181),(186,4,'Spain',182),(187,4,'Sri Lanka',183),(188,4,'St. Helena',184),(189,4,'Sudan',185),(190,4,'Suriname',186),(191,4,'Swaziland',187),(192,4,'Sweden',188),(193,4,'Switzerland',189),(194,4,'Syria',190),(195,4,'Taiwan',191),(196,4,'Tajikistan',192),(197,4,'Tanzania',193),(198,4,'Thailand',194),(199,4,'Togo',195),(200,4,'Tokelau',196),(201,4,'Tonga',197),(202,4,'Trinidad and Tobago',198),(203,4,'Tunisia',199),(204,4,'Turkey',200),(205,4,'Turkmenistan',201),(206,4,'Tuvalu',202),(207,4,'Uganda',203),(208,4,'Ukraine',204),(209,4,'United Arab Emirates',205),(210,4,'United Kingdom',206),(211,4,'Uruguay',207),(212,4,'Uzbekistan',208),(213,4,'Vanuatu',209),(214,4,'Vatican',210),(215,4,'Venezuela',211),(216,4,'Viet Nam',212),(217,4,'Virgin Islands',213),(218,4,'Western Sahara',214),(219,4,'Yeman',215),(220,4,'Yugoslavia',216),(221,4,'Zaire',217),(222,4,'Zambia',218),(223,4,'Zimbabwe',219),(224,7,'Slim',1),(225,7,'Slender',2),(226,7,'Average',3),(227,7,'Athletic',4),(228,7,'Fit',5),(229,7,'Thick',6),(230,7,'A few extra pounds',7),(231,7,'Large',8),(232,7,'Voluptuous',9),(233,8,'4\\' 8\"',1),(234,8,'4\\' 9\"',2),(235,8,'4\\' 10\"',3),(236,8,'4\\' 11\"',4),(237,8,'5\\' 0\"',5),(238,8,'5\\' 1\"',6),(239,8,'5\\' 2\"',7),(240,8,'5\\' 3\"',8),(241,8,'5\\' 4\"',9),(242,8,'5\\' 5\"',10),(243,8,'5\\' 6\"',11),(244,8,'5\\' 7\"',12),(245,8,'5\\' 8\"',13),(246,8,'5\\' 9\"',14),(247,8,'5\\' 10\"',15),(248,8,'5\\' 11\"',16),(249,8,'6\\' 0\"',17),(250,8,'6\\' 1\"',18),(251,8,'6\\' 2\"',19),(252,8,'6\\' 3\"',20),(253,8,'6\\' 4\"',21),(254,8,'6\\' 5\"',22),(255,8,'6\\' 6\"',23),(256,8,'6\\' 7\"',24),(257,8,'6\\' 8\"',25),(258,9,'Black',1),(259,9,'Blue',2),(260,9,'Brown',3),(261,9,'Gray',4),(262,9,'Green',5),(263,9,'Hazel',6),(264,10,'Auburn',1),(265,10,'Black',2),(266,10,'Blonde',3),(267,10,'Light Brown',4),(268,10,'Dark Brown',5),(269,10,'Red',6),(270,10,'White/gray',7),\r\n\t(271,10,'Bald',8),(272,10,'A little gray',9),(273,11,'African American (black)',1),(274,11,'Asian',2),(275,11,'Caucasian (white)',3),(276,11,'East Indian',4),(277,11,'Hispanic/Latino',5),(278,11,'Middle Eastern',6),(279,11,'Native American',7),(280,11,'Pacific Islander',8),(281,11,'Inter-racial',9),(282,11,'Other',10),(283,12,'Single / Never married',1),(284,12,'Divorced',2),(285,12,'Widowed',3),(286,12,'Separated',4),(287,13,'No',1),(288,13,'Yes - at home full-time',2),(289,13,'Yes - at home part-time',3),(290,13,'Yes - but not at home',4),(291,14,'No',1),(292,14,'Yes',2),(293,14,'Not sure',3),(294,15,'Some High School',1),(295,15,'High School Grad',2),(296,15,'Some College',3),(297,15,'College Grad',4),(298,15,'Post-Graduate',5),(299,16,'Full-time',1),(300,16,'Part-time',2),(301,16,'Homemaker',3),(302,16,'Retired',4),(303,16,'Self-employed',5),(304,16,'Student',6),(305,16,'Unemployed',7),(306,16,'Work at home',8),(307,17,'Artistic / Musical / Writer',1),(308,17,'Banking / Financial Services / Real Estate',2),(309,17,'Clerical / Administrative',3),(310,17,'Computer related / Hardware',4),(311,17,'Construction / Craftsman',5),(312,17,'Education / Academic Research',6),(313,17,'Entertainment / Media',7),(314,17,'Executive / Management',8),(315,17,'Hospitality / Travel',9),(316,17,'Legal Services',10),(317,17,'Manufacturing / Distributions',11),(318,17,'Medical / Health Services',12),(319,17,'Politics / Government / Military',13),(320,17,'Sales / Marketing',14),(321,17,'Technical / Science / Engineering',15),(322,17,'Transportation',16),(323,17,'Food Service',17),(324,17,'Other',18),(325,18,'Less than \$24,999',1),(326,18,'\$25,000 to \$34,999',2),(327,18,'\$35,000 to \$49,999',3),(328,18,'\$50,000 to \$74,999',4),(329,18,'\$75,000 to \$99,999',5),(330,18,'\$100,000 to \$149,999',6),(331,18,'More than \$150,000',7),(332,19,'No',1),(333,19,'Socially',2),(334,19,'Daily',3),(335,21,'Alone',1),(336,21,'With kids',2),(337,21,'With parents',3),(338,21,'With pets',4),(339,21,'With roommate(s)',5),\r\n\t(340,21,'Friends visit often',6),(341,21,'There is a party every night',7),(342,22,'The life of the party',1),(343,22,'Somewhat shy',2),(344,22,'Home Body',3),(345,22,'Social Butterfly',4),(346,22,'Side kick',5),(347,22,'Flirt',6),(348,22,'Better in small groups',7),(349,22,'Comic Relief',8),(350,23,'Couch Potato',1),(351,23,'Reality show addict',2),(352,23,'News Junkie',3),(353,23,'Sports Nut',4),(354,23,'Sitcoms',5),(355,23,'Dramas',6),(356,23,'Movies',7),(357,23,'Soaps, soaps, soaps',8),(358,23,'Documentaries',9),(359,23,'Channel Hopper',10),(360,23,'I don\\'t own a TV',11),(361,23,'TiVo is my best friend',12),(362,24,'English',1),(363,24,'French',2),(364,24,'German',3),(365,24,'Italian',4),(366,24,'Spanish',5),(367,24,'Portuguese',6),(368,24,'Dutch',7),(369,24,'Chinese',8),(370,24,'Japanese',9),(371,24,'Arabic',10),(372,24,'Russian',11),(373,24,'Hebrew',12),(374,24,'Hindi',13),(375,24,'Tagalog',14),(376,24,'Urdu',15),(377,25,'Buddhist / Taoist',1),(378,25,'Christian',2),(379,25,'Hindu',3),(380,25,'Jewish',4),(381,25,'Islam',5),(382,25,'None/Agnostic',6),(383,25,'Christian / Protestant',7),(384,25,'Christian / Catholic',8),(385,25,'Atheist',9),(386,25,'Christian / LDS',10),(387,25,'Christian / Other',11),(388,25,'Not Religious',12),(389,25,'Spiritual but not religious',13),(390,25,'Scientology',14),(391,25,'Other',15),(392,26,'More than once a week',1),(393,26,'Weekly',2),(394,26,'Monthly',3),(395,26,'Only on holidays',4),(396,26,'Rarely',5),(397,26,'Never',6),(398,27,'Very conservative',1),(399,27,'Conservative',2),(400,27,'Middle of the road',3),(401,27,'Liberal',4),(402,27,'Very liberal',5),(403,27,'Not political',6),(404,28,'Friendly',1),(405,28,'Clever / Quick Witted',2),(406,28,'Dry / Sarcastic',3),(407,28,'Campy / Cheesy',4),(408,28,'Goofy',5),(409,28,'Slapstick',6),(410,28,'Obscure',7),(411,28,'Raunchy',8),(412,28,'Other',9),(413,29,'Arts',1),(414,29,'Community Service',2),(415,29,'Dancing',3),(416,29,'Dining',4),(417,29,'Family',5),(418,29,'Movies',6),(419,29,'Listening to Music',7),\r\n\t(420,29,'Photography',8),(421,29,'Reading',9),(422,29,'Religion',10),(423,29,'Watching Sports',11),(424,29,'Theater',12),(425,29,'Travel',13),(426,29,'Cooking',14),(427,29,'Computers / Internet',15),(428,29,'Gaming',16),(429,29,'Television',17),(430,29,'Gardening',18),(431,29,'Crafts',19),(432,29,'Playing Music',20),(433,29,'Playing Sports',21),(434,29,'Health / Fitness',22),(435,20,'Daily',3),(436,20,'Socially',2),(437,20,'No',1)" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."fields_types`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."fields_types` (\r\n\t\t`type_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t\t`label` varchar(20) NOT NULL,\r\n\t\t`name_english` varchar(255) NOT NULL default '',\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\tPRIMARY KEY (`type_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."fields_types`(`type_id`,`label`,`name_english`) values\r\n\t\t(1,'members','Members')\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."files`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."files` (\r\n\t `file_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t `name` varchar(255) NOT NULL default '',\r\n\t `fname` varchar(32) NOT NULL default '',\r\n\t `uploaddate` int(10) unsigned NOT NULL default '0',\r\n\t PRIMARY KEY (`file_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."friends`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."friends` (\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`friend_id` int(9) unsigned NOT NULL,\r\n\t\t`request_date` int(10) unsigned NOT NULL,\r\n\t\t`pending` tinyint(1) unsigned NOT NULL,\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `friend_id` (`friend_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."gifts`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."gifts` (\r\n\t\t`gift_id` int(6) unsigned NOT NULL auto_increment,\r\n\t\t`filename` varchar(32) NOT NULL,\r\n\t\t`name` varchar(255) NOT NULL,\r\n\t\t`credits` smallint(5) unsigned NOT NULL,\r\n\t\t`orderid` smallint(5) unsigned NOT NULL,\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\tPRIMARY KEY (`gift_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "INSERT INTO `".$_SESSION['db_prefix']."gifts` (filename, name, orderid) VALUES\r\n\t\t('agent.png', 'Agent', 1),\r\n\t\t('bomb.png', 'Bomb', 2),\r\n\t\t('coffee.png', 'Coffee', 3),\r\n\t\t('cookie.png', 'Cookie', 4),\r\n\t\t('diamond.png', 'Diamond', 5),\r\n\t\t('games.png', 'Games', 6),\r\n\t\t('heart.png', 'Heart', 7),\r\n\t\t('help.png', 'Help', 8),\r\n\t\t('poker.png', 'Poker', 9),\r\n\t\t('tux.png', 'Tux', 10)\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."guestbooks`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."guestbooks` (\r\n\t `entry_id` int(9) unsigned NOT NULL auto_increment,\r\n\t `member_id` int(9) unsigned NOT NULL,\r\n\t `poster_id` int(9) unsigned NOT NULL,\r\n\t `postdate` int(10) unsigned NOT NULL,\r\n\t `body` text NOT NULL,\r\n\t `active` tinyint(1) unsigned NOT NULL default '1',\r\n\t PRIMARY KEY (`entry_id`),\r\n\t KEY `member_id` (`member_id`),\r\n\t KEY `poster_id` (`poster_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."ip2c`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."ip2c` (\r\n\t\t`ip_from` bigint(20) NOT NULL,\r\n\t\t`ip_to` bigint(20) NOT NULL,\r\n\t\t`cc_code` char(2) NOT NULL,\r\n\t\tKEY `ip_from` (`ip_from`),\r\n\t\tKEY `ip_to` (`ip_to`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."languages`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."languages` (\r\n\t `language_id` int(3) unsigned NOT NULL auto_increment,\r\n\t `name` varchar(32) NOT NULL default '',\r\n\t `label` varchar(32) NOT NULL default '',\r\n\t PRIMARY KEY (`language_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."languages`(`language_id`,`name`,`label`) values (1,'English','english')" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."members`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."members` (\r\n\t\t`member_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`group_id` int(4) unsigned NOT NULL default '0',\r\n\t\t`type_id` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`username` varchar(32) NOT NULL default '',\r\n\t\t`password` varchar(32) NOT NULL default '',\r\n\t\t`email` varchar(64) NOT NULL default '',\r\n\t\t`joindate` int(10) unsigned NOT NULL default '0',\r\n\t\t`lastvisit` int(10) unsigned NOT NULL default '0',\r\n\t\t`totalvisits` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalalbums` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalavideos` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalivideos` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalaaudio` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totaliaudio` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalblocked` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalfavorites` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalafriends` int(7) unsigned NOT NULL default '0',\r\n\t\t`totalifriends` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalvisitors` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalaguestbooks` int(7) unsigned NOT NULL default '0',\r\n\t\t`totaliguestbooks` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalimessages` int(6) NOT NULL default '0',\r\n\t\t`totalsmessages` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`newmessages` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`totaligifts` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalsgifts` int(6) unsigned NOT NULL default '0',\r\n\t\t`newgifts` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`totalblogs` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`totalevents` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`expirationdate` int(10) unsigned NOT NULL default '0',\r\n\t\t`picture` varchar(32) NOT NULL default '',\r\n\t\t`picture_active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`picture_adult` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`picture_date` int(10) unsigned NOT NULL default '0',\r\n\t\t`statusonline` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`featured` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`ipaddress` varchar(16) NOT NULL default '127.0.0.1',\r\n\t\t`totalssearches` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`totalvotes` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalscore` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalcredits` int(6) unsigned NOT NULL default '0',\r\n\t\t`album_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`totalviews` int(9) unsigned NOT NULL default '0',\r\n\t\t`completepct` tinyint(2) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`member_id`),\r\n\t\tKEY `group_id` (`group_id`),\r\n\t\tKEY `username` (`username`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."members_conf`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."members_conf` (\r\n\t\t`conf_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`notify_private_messages` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_gifts` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_blog_comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_guestbook_comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_pictures_comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_videos_comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_friends_requests` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`notify_limit` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`enable_newsletters` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`access_profile` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_pictures` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_videos` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_music` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_guestbook` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_guestbook_moderate` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_blog` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_friends` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_gifts` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`access_chat` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`last_blog_comment_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_blog_comment_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_guestbook_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_guestbook_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_report_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_report_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_picture_comment_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_picture_comment_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_video_comment_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_video_comment_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_quick_message_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_quick_message_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_private_message_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_private_message_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_gift_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_gift_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`last_event_comment_time` int(10) unsigned NOT NULL default '0',\r\n\t\t`last_event_comment_num` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`sound_notify` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`rated` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`last_notification` int(10) unsigned NOT NULL default '0',\r\n\t\t`showadult` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`timeformat` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`timezone` smallint(3) NOT NULL default '0',\r\n\t\t`template_id` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`language_id` tinyint(1) unsigned NOT NULL default '1',\r\n\t\tPRIMARY KEY (`conf_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."members_data_members`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."members_data_members` (\r\n\t\t`data_id` int(9) unsigned NOT NULL,\r\n\t\t`data_gender1` tinyint(2) unsigned NOT NULL,\r\n\t\t`data_gender2` tinyint(2) unsigned NOT NULL,\r\n\t\t`data_age` int(8) unsigned NOT NULL,\r\n\t\t`data_country` tinyint(3) unsigned NOT NULL,\r\n\t\t`data_city` varchar(64) NOT NULL,\r\n\t\t`data_bodytype` tinyint(3) unsigned NOT NULL,\r\n\t\t`data_height` smallint(3) unsigned NOT NULL,\r\n\t\t`data_eyes` smallint(3) unsigned NOT NULL,\r\n\t\t`data_hair` smallint(3) unsigned NOT NULL,\r\n\t\t`data_ethnicity` smallint(3) unsigned NOT NULL,\r\n\t\t`data_maritialstatus` smallint(3) unsigned NOT NULL,\r\n\t\t`data_havekids` smallint(3) unsigned NOT NULL,\r\n\t\t`data_wantkids` smallint(3) unsigned NOT NULL,\r\n\t\t`data_education` smallint(3) unsigned NOT NULL,\r\n\t\t`data_employment` smallint(3) unsigned NOT NULL,\r\n\t\t`data_occupation` smallint(3) unsigned NOT NULL,\r\n\t\t`data_income` smallint(3) unsigned NOT NULL,\r\n\t\t`data_smoking` smallint(3) unsigned NOT NULL,\r\n\t\t`data_drinking` smallint(3) unsigned NOT NULL,\r\n\t\t`data_religion` smallint(3) unsigned NOT NULL,\r\n\t\t`data_attendservices` smallint(3) unsigned NOT NULL,\r\n\t\t`data_politicalviews` smallint(3) unsigned NOT NULL,\r\n\t\t`data_inmyownwords` text,\r\n\t\tUNIQUE KEY `data_id` (`data_id`),\r\n\t\tKEY `data_gender1` (`data_gender1`),\r\n\t\tKEY `data_gender2` (`data_gender2`),\r\n\t\tKEY `data_age` (`data_age`),\r\n\t\tKEY `data_city` (`data_city`),\r\n\t\tKEY `data_country` (`data_country`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."members_groups`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."members_groups` (\r\n\t\t`group_id` smallint(4) unsigned NOT NULL auto_increment,\r\n\t\t`name` varchar(64) NOT NULL default '',\r\n\t\t`permissions` text NOT NULL,\r\n\t\t`orderid` tinyint(4) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`group_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."members_groups`(`group_id`,`name`,`permissions`,`orderid`) values\r\n\t\t(1,'Admins','a:196:{s:9:\"can_login\";s:1:\"1\";s:15:\"can_view_online\";s:1:\"1\";s:16:\"can_view_offline\";s:1:\"1\";s:19:\"can_search_profiles\";s:1:\"1\";s:19:\"can_advanced_search\";s:1:\"1\";s:12:\"search_delay\";s:1:\"0\";s:17:\"can_save_searches\";s:2:\"30\";s:20:\"can_browse_group_ids\";s:5:\"1,5,2\";s:18:\"can_view_group_ids\";s:5:\"1,5,2\";s:16:\"can_rate_members\";s:1:\"1\";s:20:\"can_edit_own_profile\";s:1:\"1\";s:21:\"can_edit_all_profiles\";s:1:\"1\";s:20:\"apply_profile_filter\";s:1:\"0\";s:23:\"can_delete_all_profiles\";s:1:\"1\";s:19:\"can_upgrade_account\";s:1:\"1\";s:27:\"can_change_privacy_settings\";s:1:\"1\";s:22:\"can_cancel_own_account\";s:1:\"1\";s:14:\"can_add_albums\";s:2:\"50\";s:19:\"can_password_albums\";s:1:\"1\";s:16:\"can_add_pictures\";s:3:\"100\";s:21:\"can_view_own_pictures\";s:1:\"1\";s:21:\"can_view_all_pictures\";s:1:\"1\";s:21:\"can_view_adult_images\";s:1:\"1\";s:21:\"can_edit_own_pictures\";s:1:\"1\";s:21:\"can_edit_all_pictures\";s:1:\"1\";s:24:\"can_approve_own_pictures\";s:1:\"1\";s:24:\"can_approve_all_pictures\";s:1:\"1\";s:23:\"can_delete_own_pictures\";s:1:\"1\";s:23:\"can_delete_all_pictures\";s:1:\"1\";s:17:\"can_rate_pictures\";s:1:\"1\";s:30:\"can_post_own_pictures_comments\";s:1:\"1\";s:30:\"can_post_all_pictures_comments\";s:1:\"1\";s:31:\"can_add_pictures_comments_delay\";s:2:\"50\";s:30:\"can_view_own_pictures_comments\";s:1:\"1\";s:30:\"can_view_all_pictures_comments\";s:1:\"1\";s:30:\"can_edit_own_pictures_comments\";s:1:\"1\";s:30:\"can_edit_all_pictures_comments\";s:1:\"1\";s:32:\"can_delete_own_pictures_comments\";s:1:\"1\";s:32:\"can_delete_all_pictures_comments\";s:1:\"1\";s:14:\"can_add_videos\";s:2:\"50\";s:19:\"can_view_own_videos\";s:1:\"1\";s:19:\"can_view_all_videos\";s:1:\"1\";s:21:\"can_view_adult_videos\";s:1:\"1\";s:19:\"can_edit_own_videos\";s:1:\"1\";s:19:\"can_edit_all_videos\";s:1:\"1\";s:22:\"can_approve_own_videos\";s:1:\"1\";s:22:\"can_approve_all_videos\";s:1:\"1\";s:21:\"can_delete_own_videos\";s:1:\"1\";s:21:\"can_delete_all_videos\";s:1:\"1\";s:15:\"can_rate_videos\";s:1:\"1\";s:28:\"can_post_own_videos_comments\";s:1:\"1\";s:28:\"can_post_all_videos_comments\";s:1:\"1\";s:29:\"can_add_videos_comments_delay\";s:2:\"50\";s:28:\"can_view_own_videos_comments\";s:1:\"1\";s:28:\"can_view_all_videos_comments\";s:1:\"1\";s:28:\"can_edit_own_videos_comments\";s:1:\"1\";s:28:\"can_edit_all_videos_comments\";s:1:\"1\";s:30:\"can_delete_own_videos_comments\";s:1:\"1\";s:30:\"can_delete_all_videos_comments\";s:1:\"1\";s:13:\"can_add_audio\";s:2:\"50\";s:18:\"can_view_own_audio\";s:1:\"1\";s:18:\"can_view_all_audio\";s:1:\"1\";s:18:\"can_edit_own_audio\";s:1:\"1\";s:18:\"can_edit_all_audio\";s:1:\"1\";s:21:\"can_approve_own_audio\";s:1:\"1\";s:21:\"can_approve_all_audio\";s:1:\"1\";s:20:\"can_delete_own_audio\";s:1:\"1\";s:20:\"can_delete_all_audio\";s:1:\"1\";s:15:\"can_rate_audios\";s:1:\"1\";s:14:\"can_add_events\";s:2:\"50\";s:17:\"credits_add_event\";s:1:\"0\";s:15:\"can_join_events\";s:1:\"1\";s:16:\"can_leave_events\";s:1:\"1\";s:19:\"can_view_own_events\";s:1:\"1\";s:19:\"can_view_all_events\";s:1:\"1\";s:19:\"can_edit_own_events\";s:1:\"1\";s:19:\"can_edit_all_events\";s:1:\"1\";s:21:\"can_delete_own_events\";s:1:\"1\";s:21:\"can_delete_all_events\";s:1:\"1\";s:28:\"can_delete_own_events_guests\";s:1:\"1\";s:28:\"can_delete_all_events_guests\";s:1:\"1\";s:17:\"can_search_events\";s:1:\"1\";s:19:\"events_search_delay\";s:1:\"0\";s:28:\"can_post_own_events_comments\";s:1:\"1\";s:28:\"can_post_all_events_comments\";s:1:\"1\";s:29:\"can_add_events_comments_delay\";s:2:\"50\";s:28:\"can_view_own_events_comments\";s:1:\"1\";s:28:\"can_view_all_events_comments\";s:1:\"1\";s:28:\"can_edit_own_events_comments\";s:1:\"1\";s:28:\"can_edit_all_events_comments\";s:1:\"1\";s:30:\"can_delete_own_events_comments\";s:1:\"1\";s:30:\"can_delete_all_events_comments\";s:1:\"1\";s:23:\"can_add_events_pictures\";s:2:\"50\";s:28:\"can_view_own_events_pictures\";s:1:\"1\";s:28:\"can_view_all_events_pictures\";s:1:\"1\";s:28:\"can_edit_own_events_pictures\";s:1:\"1\";s:28:\"can_edit_all_events_pictures\";s:1:\"1\";s:31:\"can_approve_own_events_pictures\";s:1:\"1\";s:31:\"can_approve_all_events_pictures\";s:1:\"1\";s:30:\"can_delete_own_events_pictures\";s:1:\"1\";s:30:\"can_delete_all_events_pictures\";s:1:\"1\";s:23:\"can_send_quick_messages\";s:1:\"1\";s:17:\"can_send_messages\";s:5:\"1,5,2\";s:18:\"can_reply_messages\";s:5:\"1,5,2\";s:15:\"credits_send_pm\";s:1:\"0\";s:16:\"credits_send_qpm\";s:1:\"0\";s:23:\"can_send_messages_delay\";s:3:\"100\";s:11:\"maxmessages\";s:3:\"500\";s:17:\"apply_word_filter\";s:1:\"1\";s:21:\"can_read_own_messages\";s:1:\"1\";s:21:\"can_read_all_messages\";s:1:\"1\";s:23:\"can_delete_own_messages\";s:1:\"1\";s:23:\"can_delete_all_messages\";s:1:\"1\";s:8:\"can_chat\";s:1:\"1\";s:17:\"can_send_feedback\";s:1:\"1\";s:14:\"can_send_gifts\";s:5:\"1,5,2\";s:20:\"can_send_gifts_delay\";s:2:\"50\";s:14:\"can_view_gifts\";s:1:\"1\";s:16:\"can_delete_gifts\";s:1:\"1\";s:13:\"can_add_blogs\";s:1:\"1\";s:17:\"can_view_own_blog\";s:1:\"1\";s:18:\"can_view_all_blogs\";s:1:\"1\";s:18:\"can_edit_own_blogs\";s:1:\"1\";s:18:\"can_edit_all_blogs\";s:1:\"1\";s:19:\"can_delete_own_blog\";s:1:\"1\";s:19:\"can_delete_all_blog\";s:1:\"1\";s:27:\"can_post_own_blogs_comments\";s:1:\"1\";s:27:\"can_post_all_blogs_comments\";s:1:\"1\";s:27:\"can_add_blog_comments_delay\";s:2:\"50\";s:27:\"can_view_own_blogs_comments\";s:1:\"1\";s:27:\"can_view_all_blogs_comments\";s:1:\"1\";s:27:\"can_edit_own_blogs_comments\";s:1:\"1\";s:27:\"can_edit_all_blogs_comments\";s:1:\"1\";s:29:\"can_delete_own_blogs_comments\";s:1:\"1\";s:29:\"can_delete_all_blogs_comments\";s:1:\"1\";s:23:\"can_post_own_guestbooks\";s:1:\"1\";s:23:\"can_post_all_guestbooks\";s:1:\"1\";s:25:\"can_sign_guestbooks_delay\";s:2:\"50\";s:22:\"can_view_own_guestbook\";s:1:\"1\";s:23:\"can_view_all_guestbooks\";s:1:\"1\";s:25:\"can_approve_own_guestbook\";s:1:\"1\";s:26:\"can_approve_all_guestbooks\";s:1:\"1\";s:24:\"can_delete_own_guestbook\";s:1:\"1\";s:25:\"can_delete_all_guestbooks\";s:1:\"1\";s:17:\"can_add_favorites\";s:3:\"200\";s:22:\"can_view_own_favorites\";s:1:\"1\";s:22:\"can_view_all_favorites\";s:1:\"1\";s:24:\"can_delete_own_favorites\";s:1:\"1\";s:24:\"can_delete_all_favorites\";s:1:\"1\";s:17:\"can_view_own_fans\";s:1:\"1\";s:15:\"can_add_friends\";s:3:\"200\";s:20:\"can_view_own_friends\";s:1:\"1\";s:20:\"can_view_all_friends\";s:1:\"1\";s:22:\"can_delete_own_friends\";s:1:\"1\";s:22:\"can_delete_all_friends\";s:1:\"1\";s:14:\"can_tellfriend\";s:1:\"1\";s:21:\"can_view_own_visitors\";s:2:\"20\";s:21:\"can_view_all_visitors\";s:1:\"1\";s:17:\"can_refer_members\";s:1:\"1\";s:18:\"can_refer_upgrades\";s:1:\"0\";s:22:\"can_view_own_referrals\";s:1:\"1\";s:22:\"can_view_all_referrals\";s:1:\"1\";s:24:\"can_delete_all_referrals\";s:1:\"1\";s:17:\"can_block_members\";s:1:\"1\";s:19:\"can_unblock_members\";s:1:\"1\";s:23:\"can_unblock_all_members\";s:1:\"1\";s:18:\"can_submit_reports\";s:1:\"1\";s:24:\"can_submit_reports_delay\";s:2:\"50\";s:19:\"can_change_template\";s:1:\"1\";s:19:\"can_change_language\";s:1:\"1\";s:16:\"can_view_banners\";s:1:\"1\";s:13:\"can_access_cp\";s:1:\"1\";s:18:\"can_manage_members\";s:1:\"1\";s:18:\"can_export_members\";s:1:\"1\";s:19:\"can_manage_packages\";s:1:\"1\";s:17:\"can_manage_orders\";s:1:\"1\";s:24:\"can_send_member_messages\";s:1:\"1\";s:20:\"can_send_mass_emails\";s:1:\"1\";s:22:\"can_send_mass_messages\";s:1:\"1\";s:23:\"can_manage_custom_pages\";s:1:\"1\";s:15:\"can_manage_news\";s:1:\"1\";s:16:\"can_manage_polls\";s:1:\"1\";s:18:\"can_manage_reports\";s:1:\"1\";s:18:\"can_manage_banners\";s:1:\"1\";s:16:\"can_manage_stats\";s:1:\"1\";s:18:\"can_manage_backups\";s:1:\"1\";s:16:\"can_manage_files\";s:1:\"1\";s:21:\"can_manage_extensions\";s:1:\"1\";s:19:\"can_manage_settings\";s:1:\"1\";s:26:\"can_manage_email_templates\";s:1:\"1\";s:20:\"can_manage_languages\";s:1:\"1\";s:20:\"can_manage_templates\";s:1:\"1\";s:24:\"can_manage_quickmessages\";s:1:\"1\";s:25:\"can_manage_members_groups\";s:1:\"1\";s:25:\"can_manage_members_fields\";s:1:\"1\";s:24:\"can_manage_events_fields\";s:1:\"1\";}',0),\r\n\t\t(2,'Regular members','a:196:{s:9:\"can_login\";s:1:\"1\";s:15:\"can_view_online\";s:1:\"1\";s:16:\"can_view_offline\";s:1:\"0\";s:19:\"can_search_profiles\";s:1:\"1\";s:19:\"can_advanced_search\";s:1:\"1\";s:12:\"search_delay\";s:1:\"8\";s:17:\"can_save_searches\";s:2:\"10\";s:20:\"can_browse_group_ids\";s:5:\"1,5,2\";s:18:\"can_view_group_ids\";s:5:\"1,5,2\";s:16:\"can_rate_members\";s:1:\"1\";s:20:\"can_edit_own_profile\";s:1:\"1\";s:21:\"can_edit_all_profiles\";s:1:\"0\";s:20:\"apply_profile_filter\";s:1:\"1\";s:23:\"can_delete_all_profiles\";s:1:\"0\";s:19:\"can_upgrade_account\";s:1:\"1\";s:27:\"can_change_privacy_settings\";s:1:\"1\";s:22:\"can_cancel_own_account\";s:1:\"1\";s:14:\"can_add_albums\";s:2:\"25\";s:19:\"can_password_albums\";s:1:\"1\";s:16:\"can_add_pictures\";s:2:\"50\";s:21:\"can_view_own_pictures\";s:1:\"1\";s:21:\"can_view_all_pictures\";s:1:\"1\";s:21:\"can_view_adult_images\";s:1:\"1\";s:21:\"can_edit_own_pictures\";s:1:\"1\";s:21:\"can_edit_all_pictures\";s:1:\"0\";s:24:\"can_approve_own_pictures\";s:1:\"1\";s:24:\"can_approve_all_pictures\";s:1:\"0\";s:23:\"can_delete_own_pictures\";s:1:\"1\";s:23:\"can_delete_all_pictures\";s:1:\"0\";s:17:\"can_rate_pictures\";s:1:\"1\";s:30:\"can_post_own_pictures_comments\";s:1:\"1\";s:30:\"can_post_all_pictures_comments\";s:1:\"1\";s:31:\"can_add_pictures_comments_delay\";s:2:\"20\";s:30:\"can_view_own_pictures_comments\";s:1:\"1\";s:30:\"can_view_all_pictures_comments\";s:1:\"1\";s:30:\"can_edit_own_pictures_comments\";s:1:\"0\";s:30:\"can_edit_all_pictures_comments\";s:1:\"0\";s:32:\"can_delete_own_pictures_comments\";s:1:\"1\";s:32:\"can_delete_all_pictures_comments\";s:1:\"0\";s:14:\"can_add_videos\";s:2:\"25\";s:19:\"can_view_own_videos\";s:1:\"1\";s:19:\"can_view_all_videos\";s:1:\"1\";s:21:\"can_view_adult_videos\";s:1:\"1\";s:19:\"can_edit_own_videos\";s:1:\"1\";s:19:\"can_edit_all_videos\";s:1:\"0\";s:22:\"can_approve_own_videos\";s:1:\"1\";s:22:\"can_approve_all_videos\";s:1:\"0\";s:21:\"can_delete_own_videos\";s:1:\"1\";s:21:\"can_delete_all_videos\";s:1:\"0\";s:15:\"can_rate_videos\";s:1:\"1\";s:28:\"can_post_own_videos_comments\";s:1:\"1\";s:28:\"can_post_all_videos_comments\";s:1:\"1\";s:29:\"can_add_videos_comments_delay\";s:2:\"20\";s:28:\"can_view_own_videos_comments\";s:1:\"1\";s:28:\"can_view_all_videos_comments\";s:1:\"1\";s:28:\"can_edit_own_videos_comments\";s:1:\"0\";s:28:\"can_edit_all_videos_comments\";s:1:\"0\";s:30:\"can_delete_own_videos_comments\";s:1:\"1\";s:30:\"can_delete_all_videos_comments\";s:1:\"0\";s:13:\"can_add_audio\";s:2:\"25\";s:18:\"can_view_own_audio\";s:1:\"1\";s:18:\"can_view_all_audio\";s:1:\"1\";s:18:\"can_edit_own_audio\";s:1:\"1\";s:18:\"can_edit_all_audio\";s:1:\"0\";s:21:\"can_approve_own_audio\";s:1:\"1\";s:21:\"can_approve_all_audio\";s:1:\"0\";s:20:\"can_delete_own_audio\";s:1:\"1\";s:20:\"can_delete_all_audio\";s:1:\"0\";s:15:\"can_rate_audios\";s:1:\"1\";s:14:\"can_add_events\";s:2:\"25\";s:17:\"credits_add_event\";s:1:\"0\";s:15:\"can_join_events\";s:1:\"1\";s:16:\"can_leave_events\";s:1:\"1\";s:19:\"can_view_own_events\";s:1:\"1\";s:19:\"can_view_all_events\";s:1:\"1\";s:19:\"can_edit_own_events\";s:1:\"1\";s:19:\"can_edit_all_events\";s:1:\"0\";s:21:\"can_delete_own_events\";s:1:\"1\";s:21:\"can_delete_all_events\";s:1:\"0\";s:28:\"can_delete_own_events_guests\";s:1:\"1\";s:28:\"can_delete_all_events_guests\";s:1:\"0\";s:17:\"can_search_events\";s:1:\"1\";s:19:\"events_search_delay\";s:1:\"5\";s:28:\"can_post_own_events_comments\";s:1:\"1\";s:28:\"can_post_all_events_comments\";s:1:\"1\";s:29:\"can_add_events_comments_delay\";s:2:\"20\";s:28:\"can_view_own_events_comments\";s:1:\"1\";s:28:\"can_view_all_events_comments\";s:1:\"1\";s:28:\"can_edit_own_events_comments\";s:1:\"1\";s:28:\"can_edit_all_events_comments\";s:1:\"0\";s:30:\"can_delete_own_events_comments\";s:1:\"1\";s:30:\"can_delete_all_events_comments\";s:1:\"0\";s:23:\"can_add_events_pictures\";s:2:\"25\";s:28:\"can_view_own_events_pictures\";s:1:\"1\";s:28:\"can_view_all_events_pictures\";s:1:\"1\";s:28:\"can_edit_own_events_pictures\";s:1:\"1\";s:28:\"can_edit_all_events_pictures\";s:1:\"0\";s:31:\"can_approve_own_events_pictures\";s:1:\"1\";s:31:\"can_approve_all_events_pictures\";s:1:\"0\";s:30:\"can_delete_own_events_pictures\";s:1:\"1\";s:30:\"can_delete_all_events_pictures\";s:1:\"0\";s:23:\"can_send_quick_messages\";s:1:\"1\";s:17:\"can_send_messages\";s:1:\"1\";s:18:\"can_reply_messages\";s:1:\"1\";s:15:\"credits_send_pm\";s:1:\"0\";s:16:\"credits_send_qpm\";s:1:\"0\";s:23:\"can_send_messages_delay\";s:2:\"20\";s:11:\"maxmessages\";s:3:\"250\";s:17:\"apply_word_filter\";s:1:\"1\";s:21:\"can_read_own_messages\";s:1:\"1\";s:21:\"can_read_all_messages\";s:1:\"0\";s:23:\"can_delete_own_messages\";s:1:\"1\";s:23:\"can_delete_all_messages\";s:1:\"0\";s:8:\"can_chat\";s:1:\"1\";s:17:\"can_send_feedback\";s:1:\"1\";s:14:\"can_send_gifts\";s:5:\"1,5,2\";s:20:\"can_send_gifts_delay\";s:2:\"20\";s:14:\"can_view_gifts\";s:1:\"1\";s:16:\"can_delete_gifts\";s:1:\"1\";s:13:\"can_add_blogs\";s:1:\"1\";s:17:\"can_view_own_blog\";s:1:\"1\";s:18:\"can_view_all_blogs\";s:1:\"1\";s:18:\"can_edit_own_blogs\";s:1:\"1\";s:18:\"can_edit_all_blogs\";s:1:\"0\";s:19:\"can_delete_own_blog\";s:1:\"1\";s:19:\"can_delete_all_blog\";s:1:\"0\";s:27:\"can_post_own_blogs_comments\";s:1:\"1\";s:27:\"can_post_all_blogs_comments\";s:1:\"1\";s:27:\"can_add_blog_comments_delay\";s:2:\"20\";s:27:\"can_view_own_blogs_comments\";s:1:\"1\";s:27:\"can_view_all_blogs_comments\";s:1:\"1\";s:27:\"can_edit_own_blogs_comments\";s:1:\"0\";s:27:\"can_edit_all_blogs_comments\";s:1:\"0\";s:29:\"can_delete_own_blogs_comments\";s:1:\"1\";s:29:\"can_delete_all_blogs_comments\";s:1:\"0\";s:23:\"can_post_own_guestbooks\";s:1:\"1\";s:23:\"can_post_all_guestbooks\";s:1:\"1\";s:25:\"can_sign_guestbooks_delay\";s:2:\"20\";s:22:\"can_view_own_guestbook\";s:1:\"1\";s:23:\"can_view_all_guestbooks\";s:1:\"1\";s:25:\"can_approve_own_guestbook\";s:1:\"1\";s:26:\"can_approve_all_guestbooks\";s:1:\"0\";s:24:\"can_delete_own_guestbook\";s:1:\"1\";s:25:\"can_delete_all_guestbooks\";s:1:\"0\";s:17:\"can_add_favorites\";s:2:\"50\";s:22:\"can_view_own_favorites\";s:1:\"1\";s:22:\"can_view_all_favorites\";s:1:\"0\";s:24:\"can_delete_own_favorites\";s:1:\"1\";s:24:\"can_delete_all_favorites\";s:1:\"0\";s:17:\"can_view_own_fans\";s:1:\"1\";s:15:\"can_add_friends\";s:2:\"50\";s:20:\"can_view_own_friends\";s:1:\"1\";s:20:\"can_view_all_friends\";s:1:\"1\";s:22:\"can_delete_own_friends\";s:1:\"1\";s:22:\"can_delete_all_friends\";s:1:\"0\";s:14:\"can_tellfriend\";s:1:\"1\";s:21:\"can_view_own_visitors\";s:2:\"10\";s:21:\"can_view_all_visitors\";s:1:\"0\";s:17:\"can_refer_members\";s:1:\"1\";s:18:\"can_refer_upgrades\";s:1:\"1\";s:22:\"can_view_own_referrals\";s:1:\"1\";s:22:\"can_view_all_referrals\";s:1:\"0\";s:24:\"can_delete_all_referrals\";s:1:\"0\";s:17:\"can_block_members\";s:1:\"1\";s:19:\"can_unblock_members\";s:1:\"1\";s:23:\"can_unblock_all_members\";s:1:\"0\";s:18:\"can_submit_reports\";s:1:\"1\";s:24:\"can_submit_reports_delay\";s:2:\"20\";s:19:\"can_change_template\";s:1:\"1\";s:19:\"can_change_language\";s:1:\"1\";s:16:\"can_view_banners\";s:1:\"1\";s:13:\"can_access_cp\";s:1:\"0\";s:18:\"can_manage_members\";s:1:\"0\";s:18:\"can_export_members\";s:1:\"0\";s:19:\"can_manage_packages\";s:1:\"0\";s:17:\"can_manage_orders\";s:1:\"0\";s:24:\"can_send_member_messages\";s:1:\"0\";s:20:\"can_send_mass_emails\";s:1:\"0\";s:22:\"can_send_mass_messages\";s:1:\"0\";s:23:\"can_manage_custom_pages\";s:1:\"0\";s:15:\"can_manage_news\";s:1:\"0\";s:16:\"can_manage_polls\";s:1:\"0\";s:18:\"can_manage_reports\";s:1:\"0\";s:18:\"can_manage_banners\";s:1:\"0\";s:16:\"can_manage_stats\";s:1:\"0\";s:18:\"can_manage_backups\";s:1:\"0\";s:16:\"can_manage_files\";s:1:\"0\";s:21:\"can_manage_extensions\";s:1:\"0\";s:19:\"can_manage_settings\";s:1:\"0\";s:26:\"can_manage_email_templates\";s:1:\"0\";s:20:\"can_manage_languages\";s:1:\"0\";s:20:\"can_manage_templates\";s:1:\"0\";s:24:\"can_manage_quickmessages\";s:1:\"0\";s:25:\"can_manage_members_groups\";s:1:\"0\";s:25:\"can_manage_members_fields\";s:1:\"0\";s:24:\"can_manage_events_fields\";s:1:\"0\";}',0),\r\n\t\t(3,'Guests','a:196:{s:9:\"can_login\";s:1:\"0\";s:15:\"can_view_online\";s:1:\"1\";s:16:\"can_view_offline\";s:1:\"0\";s:19:\"can_search_profiles\";s:1:\"1\";s:19:\"can_advanced_search\";s:1:\"1\";s:12:\"search_delay\";s:2:\"10\";s:17:\"can_save_searches\";s:1:\"0\";s:20:\"can_browse_group_ids\";s:5:\"1,5,2\";s:18:\"can_view_group_ids\";s:5:\"1,5,2\";s:16:\"can_rate_members\";s:1:\"1\";s:20:\"can_edit_own_profile\";s:1:\"0\";s:21:\"can_edit_all_profiles\";s:1:\"0\";s:20:\"apply_profile_filter\";s:1:\"0\";s:23:\"can_delete_all_profiles\";s:1:\"0\";s:19:\"can_upgrade_account\";s:1:\"0\";s:27:\"can_change_privacy_settings\";s:1:\"0\";s:22:\"can_cancel_own_account\";s:1:\"0\";s:14:\"can_add_albums\";s:1:\"0\";s:19:\"can_password_albums\";s:1:\"0\";s:16:\"can_add_pictures\";s:1:\"0\";s:21:\"can_view_own_pictures\";s:1:\"0\";s:21:\"can_view_all_pictures\";s:1:\"1\";s:21:\"can_view_adult_images\";s:1:\"0\";s:21:\"can_edit_own_pictures\";s:1:\"0\";s:21:\"can_edit_all_pictures\";s:1:\"0\";s:24:\"can_approve_own_pictures\";s:1:\"0\";s:24:\"can_approve_all_pictures\";s:1:\"0\";s:23:\"can_delete_own_pictures\";s:1:\"0\";s:23:\"can_delete_all_pictures\";s:1:\"0\";s:17:\"can_rate_pictures\";s:1:\"1\";s:30:\"can_post_own_pictures_comments\";s:1:\"0\";s:30:\"can_post_all_pictures_comments\";s:1:\"0\";s:31:\"can_add_pictures_comments_delay\";s:1:\"0\";s:30:\"can_view_own_pictures_comments\";s:1:\"0\";s:30:\"can_view_all_pictures_comments\";s:1:\"1\";s:30:\"can_edit_own_pictures_comments\";s:1:\"0\";s:30:\"can_edit_all_pictures_comments\";s:1:\"0\";s:32:\"can_delete_own_pictures_comments\";s:1:\"0\";s:32:\"can_delete_all_pictures_comments\";s:1:\"0\";s:14:\"can_add_videos\";s:1:\"0\";s:19:\"can_view_own_videos\";s:1:\"0\";s:19:\"can_view_all_videos\";s:1:\"1\";s:21:\"can_view_adult_videos\";s:1:\"0\";s:19:\"can_edit_own_videos\";s:1:\"0\";s:19:\"can_edit_all_videos\";s:1:\"0\";s:22:\"can_approve_own_videos\";s:1:\"0\";s:22:\"can_approve_all_videos\";s:1:\"0\";s:21:\"can_delete_own_videos\";s:1:\"0\";s:21:\"can_delete_all_videos\";s:1:\"0\";s:15:\"can_rate_videos\";s:1:\"1\";s:28:\"can_post_own_videos_comments\";s:1:\"0\";s:28:\"can_post_all_videos_comments\";s:1:\"0\";s:29:\"can_add_videos_comments_delay\";s:1:\"0\";s:28:\"can_view_own_videos_comments\";s:1:\"0\";s:28:\"can_view_all_videos_comments\";s:1:\"1\";s:28:\"can_edit_own_videos_comments\";s:1:\"0\";s:28:\"can_edit_all_videos_comments\";s:1:\"0\";s:30:\"can_delete_own_videos_comments\";s:1:\"0\";s:30:\"can_delete_all_videos_comments\";s:1:\"0\";s:13:\"can_add_audio\";s:1:\"0\";s:18:\"can_view_own_audio\";s:1:\"0\";s:18:\"can_view_all_audio\";s:1:\"1\";s:18:\"can_edit_own_audio\";s:1:\"0\";s:18:\"can_edit_all_audio\";s:1:\"0\";s:21:\"can_approve_own_audio\";s:1:\"0\";s:21:\"can_approve_all_audio\";s:1:\"0\";s:20:\"can_delete_own_audio\";s:1:\"0\";s:20:\"can_delete_all_audio\";s:1:\"0\";s:15:\"can_rate_audios\";s:1:\"1\";s:14:\"can_add_events\";s:1:\"0\";s:17:\"credits_add_event\";s:1:\"0\";s:15:\"can_join_events\";s:1:\"0\";s:16:\"can_leave_events\";s:1:\"0\";s:19:\"can_view_own_events\";s:1:\"0\";s:19:\"can_view_all_events\";s:1:\"1\";s:19:\"can_edit_own_events\";s:1:\"0\";s:19:\"can_edit_all_events\";s:1:\"0\";s:21:\"can_delete_own_events\";s:1:\"0\";s:21:\"can_delete_all_events\";s:1:\"0\";s:28:\"can_delete_own_events_guests\";s:1:\"0\";s:28:\"can_delete_all_events_guests\";s:1:\"0\";s:17:\"can_search_events\";s:1:\"1\";s:19:\"events_search_delay\";s:2:\"10\";s:28:\"can_post_own_events_comments\";s:1:\"0\";s:28:\"can_post_all_events_comments\";s:1:\"0\";s:29:\"can_add_events_comments_delay\";s:1:\"0\";s:28:\"can_view_own_events_comments\";s:1:\"0\";s:28:\"can_view_all_events_comments\";s:1:\"1\";s:28:\"can_edit_own_events_comments\";s:1:\"0\";s:28:\"can_edit_all_events_comments\";s:1:\"0\";s:30:\"can_delete_own_events_comments\";s:1:\"0\";s:30:\"can_delete_all_events_comments\";s:1:\"0\";s:23:\"can_add_events_pictures\";s:1:\"0\";s:28:\"can_view_own_events_pictures\";s:1:\"0\";s:28:\"can_view_all_events_pictures\";s:1:\"1\";s:28:\"can_edit_own_events_pictures\";s:1:\"0\";s:28:\"can_edit_all_events_pictures\";s:1:\"0\";s:31:\"can_approve_own_events_pictures\";s:1:\"0\";s:31:\"can_approve_all_events_pictures\";s:1:\"0\";s:30:\"can_delete_own_events_pictures\";s:1:\"0\";s:30:\"can_delete_all_events_pictures\";s:1:\"0\";s:23:\"can_send_quick_messages\";s:1:\"0\";s:17:\"can_send_messages\";s:0:\"\";s:18:\"can_reply_messages\";s:0:\"\";s:15:\"credits_send_pm\";s:1:\"0\";s:16:\"credits_send_qpm\";s:1:\"0\";s:23:\"can_send_messages_delay\";s:1:\"0\";s:11:\"maxmessages\";s:1:\"0\";s:17:\"apply_word_filter\";s:1:\"0\";s:21:\"can_read_own_messages\";s:1:\"0\";s:21:\"can_read_all_messages\";s:1:\"0\";s:23:\"can_delete_own_messages\";s:1:\"0\";s:23:\"can_delete_all_messages\";s:1:\"0\";s:8:\"can_chat\";s:1:\"0\";s:17:\"can_send_feedback\";s:1:\"1\";s:14:\"can_send_gifts\";s:0:\"\";s:20:\"can_send_gifts_delay\";s:1:\"0\";s:14:\"can_view_gifts\";s:1:\"1\";s:16:\"can_delete_gifts\";s:1:\"0\";s:13:\"can_add_blogs\";s:1:\"0\";s:17:\"can_view_own_blog\";s:1:\"0\";s:18:\"can_view_all_blogs\";s:1:\"1\";s:18:\"can_edit_own_blogs\";s:1:\"0\";s:18:\"can_edit_all_blogs\";s:1:\"0\";s:19:\"can_delete_own_blog\";s:1:\"0\";s:19:\"can_delete_all_blog\";s:1:\"0\";s:27:\"can_post_own_blogs_comments\";s:1:\"0\";s:27:\"can_post_all_blogs_comments\";s:1:\"0\";s:27:\"can_add_blog_comments_delay\";s:1:\"0\";s:27:\"can_view_own_blogs_comments\";s:1:\"0\";s:27:\"can_view_all_blogs_comments\";s:1:\"1\";s:27:\"can_edit_own_blogs_comments\";s:1:\"0\";s:27:\"can_edit_all_blogs_comments\";s:1:\"0\";s:29:\"can_delete_own_blogs_comments\";s:1:\"0\";s:29:\"can_delete_all_blogs_comments\";s:1:\"0\";s:23:\"can_post_own_guestbooks\";s:1:\"0\";s:23:\"can_post_all_guestbooks\";s:1:\"0\";s:25:\"can_sign_guestbooks_delay\";s:1:\"0\";s:22:\"can_view_own_guestbook\";s:1:\"0\";s:23:\"can_view_all_guestbooks\";s:1:\"1\";s:25:\"can_approve_own_guestbook\";s:1:\"0\";s:26:\"can_approve_all_guestbooks\";s:1:\"0\";s:24:\"can_delete_own_guestbook\";s:1:\"0\";s:25:\"can_delete_all_guestbooks\";s:1:\"0\";s:17:\"can_add_favorites\";s:1:\"0\";s:22:\"can_view_own_favorites\";s:1:\"0\";s:22:\"can_view_all_favorites\";s:1:\"0\";s:24:\"can_delete_own_favorites\";s:1:\"0\";s:24:\"can_delete_all_favorites\";s:1:\"0\";s:17:\"can_view_own_fans\";s:1:\"0\";s:15:\"can_add_friends\";s:1:\"0\";s:20:\"can_view_own_friends\";s:1:\"0\";s:20:\"can_view_all_friends\";s:1:\"1\";s:22:\"can_delete_own_friends\";s:1:\"0\";s:22:\"can_delete_all_friends\";s:1:\"0\";s:14:\"can_tellfriend\";s:1:\"1\";s:21:\"can_view_own_visitors\";s:1:\"0\";s:21:\"can_view_all_visitors\";s:1:\"0\";s:17:\"can_refer_members\";s:1:\"0\";s:18:\"can_refer_upgrades\";s:1:\"0\";s:22:\"can_view_own_referrals\";s:1:\"0\";s:22:\"can_view_all_referrals\";s:1:\"0\";s:24:\"can_delete_all_referrals\";s:1:\"0\";s:17:\"can_block_members\";s:1:\"0\";s:19:\"can_unblock_members\";s:1:\"0\";s:23:\"can_unblock_all_members\";s:1:\"0\";s:18:\"can_submit_reports\";s:1:\"0\";s:24:\"can_submit_reports_delay\";s:1:\"0\";s:19:\"can_change_template\";s:1:\"1\";s:19:\"can_change_language\";s:1:\"1\";s:16:\"can_view_banners\";s:1:\"1\";s:13:\"can_access_cp\";s:1:\"0\";s:18:\"can_manage_members\";s:1:\"0\";s:18:\"can_export_members\";s:1:\"0\";s:19:\"can_manage_packages\";s:1:\"0\";s:17:\"can_manage_orders\";s:1:\"0\";s:24:\"can_send_member_messages\";s:1:\"0\";s:20:\"can_send_mass_emails\";s:1:\"0\";s:22:\"can_send_mass_messages\";s:1:\"0\";s:23:\"can_manage_custom_pages\";s:1:\"0\";s:15:\"can_manage_news\";s:1:\"0\";s:16:\"can_manage_polls\";s:1:\"0\";s:18:\"can_manage_reports\";s:1:\"0\";s:18:\"can_manage_banners\";s:1:\"0\";s:16:\"can_manage_stats\";s:1:\"0\";s:18:\"can_manage_backups\";s:1:\"0\";s:16:\"can_manage_files\";s:1:\"0\";s:21:\"can_manage_extensions\";s:1:\"0\";s:19:\"can_manage_settings\";s:1:\"0\";s:26:\"can_manage_email_templates\";s:1:\"0\";s:20:\"can_manage_languages\";s:1:\"0\";s:20:\"can_manage_templates\";s:1:\"0\";s:24:\"can_manage_quickmessages\";s:1:\"0\";s:25:\"can_manage_members_groups\";s:1:\"0\";s:25:\"can_manage_members_fields\";s:1:\"0\";s:24:\"can_manage_events_fields\";s:1:\"0\";}',0),\r\n\t\t(4,'Pending members','a:196:{s:9:\"can_login\";s:1:\"0\";s:15:\"can_view_online\";s:1:\"0\";s:16:\"can_view_offline\";s:1:\"0\";s:19:\"can_search_profiles\";s:1:\"0\";s:19:\"can_advanced_search\";s:1:\"0\";s:12:\"search_delay\";s:1:\"0\";s:17:\"can_save_searches\";s:1:\"0\";s:20:\"can_browse_group_ids\";s:0:\"\";s:18:\"can_view_group_ids\";s:0:\"\";s:16:\"can_rate_members\";s:1:\"0\";s:20:\"can_edit_own_profile\";s:1:\"0\";s:21:\"can_edit_all_profiles\";s:1:\"0\";s:20:\"apply_profile_filter\";s:1:\"0\";s:23:\"can_delete_all_profiles\";s:1:\"0\";s:19:\"can_upgrade_account\";s:1:\"0\";s:27:\"can_change_privacy_settings\";s:1:\"0\";s:22:\"can_cancel_own_account\";s:1:\"0\";s:14:\"can_add_albums\";s:1:\"0\";s:19:\"can_password_albums\";s:1:\"0\";s:16:\"can_add_pictures\";s:1:\"0\";s:21:\"can_view_own_pictures\";s:1:\"0\";s:21:\"can_view_all_pictures\";s:1:\"0\";s:21:\"can_view_adult_images\";s:1:\"0\";s:21:\"can_edit_own_pictures\";s:1:\"0\";s:21:\"can_edit_all_pictures\";s:1:\"0\";s:24:\"can_approve_own_pictures\";s:1:\"0\";s:24:\"can_approve_all_pictures\";s:1:\"0\";s:23:\"can_delete_own_pictures\";s:1:\"0\";s:23:\"can_delete_all_pictures\";s:1:\"0\";s:17:\"can_rate_pictures\";s:1:\"0\";s:30:\"can_post_own_pictures_comments\";s:1:\"0\";s:30:\"can_post_all_pictures_comments\";s:1:\"0\";s:31:\"can_add_pictures_comments_delay\";s:1:\"0\";s:30:\"can_view_own_pictures_comments\";s:1:\"0\";s:30:\"can_view_all_pictures_comments\";s:1:\"0\";s:30:\"can_edit_own_pictures_comments\";s:1:\"0\";s:30:\"can_edit_all_pictures_comments\";s:1:\"0\";s:32:\"can_delete_own_pictures_comments\";s:1:\"0\";s:32:\"can_delete_all_pictures_comments\";s:1:\"0\";s:14:\"can_add_videos\";s:1:\"0\";s:19:\"can_view_own_videos\";s:1:\"0\";s:19:\"can_view_all_videos\";s:1:\"0\";s:21:\"can_view_adult_videos\";s:1:\"0\";s:19:\"can_edit_own_videos\";s:1:\"0\";s:19:\"can_edit_all_videos\";s:1:\"0\";s:22:\"can_approve_own_videos\";s:1:\"0\";s:22:\"can_approve_all_videos\";s:1:\"0\";s:21:\"can_delete_own_videos\";s:1:\"0\";s:21:\"can_delete_all_videos\";s:1:\"0\";s:15:\"can_rate_videos\";s:1:\"0\";s:28:\"can_post_own_videos_comments\";s:1:\"0\";s:28:\"can_post_all_videos_comments\";s:1:\"0\";s:29:\"can_add_videos_comments_delay\";s:1:\"0\";s:28:\"can_view_own_videos_comments\";s:1:\"0\";s:28:\"can_view_all_videos_comments\";s:1:\"0\";s:28:\"can_edit_own_videos_comments\";s:1:\"0\";s:28:\"can_edit_all_videos_comments\";s:1:\"0\";s:30:\"can_delete_own_videos_comments\";s:1:\"0\";s:30:\"can_delete_all_videos_comments\";s:1:\"0\";s:13:\"can_add_audio\";s:1:\"0\";s:18:\"can_view_own_audio\";s:1:\"0\";s:18:\"can_view_all_audio\";s:1:\"0\";s:18:\"can_edit_own_audio\";s:1:\"0\";s:18:\"can_edit_all_audio\";s:1:\"0\";s:21:\"can_approve_own_audio\";s:1:\"0\";s:21:\"can_approve_all_audio\";s:1:\"0\";s:20:\"can_delete_own_audio\";s:1:\"0\";s:20:\"can_delete_all_audio\";s:1:\"0\";s:15:\"can_rate_audios\";s:1:\"0\";s:14:\"can_add_events\";s:1:\"0\";s:17:\"credits_add_event\";s:1:\"0\";s:15:\"can_join_events\";s:1:\"0\";s:16:\"can_leave_events\";s:1:\"0\";s:19:\"can_view_own_events\";s:1:\"0\";s:19:\"can_view_all_events\";s:1:\"0\";s:19:\"can_edit_own_events\";s:1:\"0\";s:19:\"can_edit_all_events\";s:1:\"0\";s:21:\"can_delete_own_events\";s:1:\"0\";s:21:\"can_delete_all_events\";s:1:\"0\";s:28:\"can_delete_own_events_guests\";s:1:\"0\";s:28:\"can_delete_all_events_guests\";s:1:\"0\";s:17:\"can_search_events\";s:1:\"0\";s:19:\"events_search_delay\";s:1:\"0\";s:28:\"can_post_own_events_comments\";s:1:\"0\";s:28:\"can_post_all_events_comments\";s:1:\"0\";s:29:\"can_add_events_comments_delay\";s:1:\"0\";s:28:\"can_view_own_events_comments\";s:1:\"0\";s:28:\"can_view_all_events_comments\";s:1:\"0\";s:28:\"can_edit_own_events_comments\";s:1:\"0\";s:28:\"can_edit_all_events_comments\";s:1:\"0\";s:30:\"can_delete_own_events_comments\";s:1:\"0\";s:30:\"can_delete_all_events_comments\";s:1:\"0\";s:23:\"can_add_events_pictures\";s:1:\"0\";s:28:\"can_view_own_events_pictures\";s:1:\"0\";s:28:\"can_view_all_events_pictures\";s:1:\"0\";s:28:\"can_edit_own_events_pictures\";s:1:\"0\";s:28:\"can_edit_all_events_pictures\";s:1:\"0\";s:31:\"can_approve_own_events_pictures\";s:1:\"0\";s:31:\"can_approve_all_events_pictures\";s:1:\"0\";s:30:\"can_delete_own_events_pictures\";s:1:\"0\";s:30:\"can_delete_all_events_pictures\";s:1:\"0\";s:23:\"can_send_quick_messages\";s:1:\"0\";s:17:\"can_send_messages\";s:0:\"\";s:18:\"can_reply_messages\";s:0:\"\";s:15:\"credits_send_pm\";s:1:\"0\";s:16:\"credits_send_qpm\";s:1:\"0\";s:23:\"can_send_messages_delay\";s:1:\"0\";s:11:\"maxmessages\";s:1:\"0\";s:17:\"apply_word_filter\";s:1:\"0\";s:21:\"can_read_own_messages\";s:1:\"0\";s:21:\"can_read_all_messages\";s:1:\"0\";s:23:\"can_delete_own_messages\";s:1:\"0\";s:23:\"can_delete_all_messages\";s:1:\"0\";s:8:\"can_chat\";s:1:\"0\";s:17:\"can_send_feedback\";s:1:\"0\";s:14:\"can_send_gifts\";s:0:\"\";s:20:\"can_send_gifts_delay\";s:1:\"0\";s:14:\"can_view_gifts\";s:1:\"0\";s:16:\"can_delete_gifts\";s:1:\"0\";s:13:\"can_add_blogs\";s:1:\"0\";s:17:\"can_view_own_blog\";s:1:\"0\";s:18:\"can_view_all_blogs\";s:1:\"0\";s:18:\"can_edit_own_blogs\";s:1:\"0\";s:18:\"can_edit_all_blogs\";s:1:\"0\";s:19:\"can_delete_own_blog\";s:1:\"0\";s:19:\"can_delete_all_blog\";s:1:\"0\";s:27:\"can_post_own_blogs_comments\";s:1:\"0\";s:27:\"can_post_all_blogs_comments\";s:1:\"0\";s:27:\"can_add_blog_comments_delay\";s:1:\"0\";s:27:\"can_view_own_blogs_comments\";s:1:\"0\";s:27:\"can_view_all_blogs_comments\";s:1:\"0\";s:27:\"can_edit_own_blogs_comments\";s:1:\"0\";s:27:\"can_edit_all_blogs_comments\";s:1:\"0\";s:29:\"can_delete_own_blogs_comments\";s:1:\"0\";s:29:\"can_delete_all_blogs_comments\";s:1:\"0\";s:23:\"can_post_own_guestbooks\";s:1:\"0\";s:23:\"can_post_all_guestbooks\";s:1:\"0\";s:25:\"can_sign_guestbooks_delay\";s:1:\"0\";s:22:\"can_view_own_guestbook\";s:1:\"0\";s:23:\"can_view_all_guestbooks\";s:1:\"0\";s:25:\"can_approve_own_guestbook\";s:1:\"0\";s:26:\"can_approve_all_guestbooks\";s:1:\"0\";s:24:\"can_delete_own_guestbook\";s:1:\"0\";s:25:\"can_delete_all_guestbooks\";s:1:\"0\";s:17:\"can_add_favorites\";s:1:\"0\";s:22:\"can_view_own_favorites\";s:1:\"0\";s:22:\"can_view_all_favorites\";s:1:\"0\";s:24:\"can_delete_own_favorites\";s:1:\"0\";s:24:\"can_delete_all_favorites\";s:1:\"0\";s:17:\"can_view_own_fans\";s:1:\"0\";s:15:\"can_add_friends\";s:1:\"0\";s:20:\"can_view_own_friends\";s:1:\"0\";s:20:\"can_view_all_friends\";s:1:\"0\";s:22:\"can_delete_own_friends\";s:1:\"0\";s:22:\"can_delete_all_friends\";s:1:\"0\";s:14:\"can_tellfriend\";s:1:\"0\";s:21:\"can_view_own_visitors\";s:1:\"0\";s:21:\"can_view_all_visitors\";s:1:\"0\";s:17:\"can_refer_members\";s:1:\"0\";s:18:\"can_refer_upgrades\";s:1:\"0\";s:22:\"can_view_own_referrals\";s:1:\"0\";s:22:\"can_view_all_referrals\";s:1:\"0\";s:24:\"can_delete_all_referrals\";s:1:\"0\";s:17:\"can_block_members\";s:1:\"0\";s:19:\"can_unblock_members\";s:1:\"0\";s:23:\"can_unblock_all_members\";s:1:\"0\";s:18:\"can_submit_reports\";s:1:\"0\";s:24:\"can_submit_reports_delay\";s:1:\"0\";s:19:\"can_change_template\";s:1:\"0\";s:19:\"can_change_language\";s:1:\"0\";s:16:\"can_view_banners\";s:1:\"0\";s:13:\"can_access_cp\";s:1:\"0\";s:18:\"can_manage_members\";s:1:\"0\";s:18:\"can_export_members\";s:1:\"0\";s:19:\"can_manage_packages\";s:1:\"0\";s:17:\"can_manage_orders\";s:1:\"0\";s:24:\"can_send_member_messages\";s:1:\"0\";s:20:\"can_send_mass_emails\";s:1:\"0\";s:22:\"can_send_mass_messages\";s:1:\"0\";s:23:\"can_manage_custom_pages\";s:1:\"0\";s:15:\"can_manage_news\";s:1:\"0\";s:16:\"can_manage_polls\";s:1:\"0\";s:18:\"can_manage_reports\";s:1:\"0\";s:18:\"can_manage_banners\";s:1:\"0\";s:16:\"can_manage_stats\";s:1:\"0\";s:18:\"can_manage_backups\";s:1:\"0\";s:16:\"can_manage_files\";s:1:\"0\";s:21:\"can_manage_extensions\";s:1:\"0\";s:19:\"can_manage_settings\";s:1:\"0\";s:26:\"can_manage_email_templates\";s:1:\"0\";s:20:\"can_manage_languages\";s:1:\"0\";s:20:\"can_manage_templates\";s:1:\"0\";s:24:\"can_manage_quickmessages\";s:1:\"0\";s:25:\"can_manage_members_groups\";s:1:\"0\";s:25:\"can_manage_members_fields\";s:1:\"0\";s:24:\"can_manage_events_fields\";s:1:\"0\";}',0),\r\n\t\t(5,'Paid members','a:196:{s:9:\"can_login\";s:1:\"1\";s:15:\"can_view_online\";s:1:\"1\";s:16:\"can_view_offline\";s:1:\"0\";s:19:\"can_search_profiles\";s:1:\"1\";s:19:\"can_advanced_search\";s:1:\"1\";s:12:\"search_delay\";s:1:\"4\";s:17:\"can_save_searches\";s:2:\"30\";s:20:\"can_browse_group_ids\";s:5:\"1,5,2\";s:18:\"can_view_group_ids\";s:5:\"1,5,2\";s:16:\"can_rate_members\";s:1:\"1\";s:20:\"can_edit_own_profile\";s:1:\"1\";s:21:\"can_edit_all_profiles\";s:1:\"0\";s:20:\"apply_profile_filter\";s:1:\"1\";s:23:\"can_delete_all_profiles\";s:1:\"0\";s:19:\"can_upgrade_account\";s:1:\"1\";s:27:\"can_change_privacy_settings\";s:1:\"1\";s:22:\"can_cancel_own_account\";s:1:\"1\";s:14:\"can_add_albums\";s:2:\"50\";s:19:\"can_password_albums\";s:1:\"1\";s:16:\"can_add_pictures\";s:3:\"100\";s:21:\"can_view_own_pictures\";s:1:\"1\";s:21:\"can_view_all_pictures\";s:1:\"1\";s:21:\"can_view_adult_images\";s:1:\"1\";s:21:\"can_edit_own_pictures\";s:1:\"1\";s:21:\"can_edit_all_pictures\";s:1:\"0\";s:24:\"can_approve_own_pictures\";s:1:\"1\";s:24:\"can_approve_all_pictures\";s:1:\"0\";s:23:\"can_delete_own_pictures\";s:1:\"1\";s:23:\"can_delete_all_pictures\";s:1:\"0\";s:17:\"can_rate_pictures\";s:1:\"1\";s:30:\"can_post_own_pictures_comments\";s:1:\"1\";s:30:\"can_post_all_pictures_comments\";s:1:\"1\";s:31:\"can_add_pictures_comments_delay\";s:2:\"50\";s:30:\"can_view_own_pictures_comments\";s:1:\"1\";s:30:\"can_view_all_pictures_comments\";s:1:\"1\";s:30:\"can_edit_own_pictures_comments\";s:1:\"0\";s:30:\"can_edit_all_pictures_comments\";s:1:\"0\";s:32:\"can_delete_own_pictures_comments\";s:1:\"1\";s:32:\"can_delete_all_pictures_comments\";s:1:\"0\";s:14:\"can_add_videos\";s:2:\"50\";s:19:\"can_view_own_videos\";s:1:\"1\";s:19:\"can_view_all_videos\";s:1:\"1\";s:21:\"can_view_adult_videos\";s:1:\"1\";s:19:\"can_edit_own_videos\";s:1:\"1\";s:19:\"can_edit_all_videos\";s:1:\"0\";s:22:\"can_approve_own_videos\";s:1:\"1\";s:22:\"can_approve_all_videos\";s:1:\"0\";s:21:\"can_delete_own_videos\";s:1:\"1\";s:21:\"can_delete_all_videos\";s:1:\"0\";s:15:\"can_rate_videos\";s:1:\"1\";s:28:\"can_post_own_videos_comments\";s:1:\"1\";s:28:\"can_post_all_videos_comments\";s:1:\"1\";s:29:\"can_add_videos_comments_delay\";s:2:\"50\";s:28:\"can_view_own_videos_comments\";s:1:\"1\";s:28:\"can_view_all_videos_comments\";s:1:\"1\";s:28:\"can_edit_own_videos_comments\";s:1:\"0\";s:28:\"can_edit_all_videos_comments\";s:1:\"0\";s:30:\"can_delete_own_videos_comments\";s:1:\"1\";s:30:\"can_delete_all_videos_comments\";s:1:\"0\";s:13:\"can_add_audio\";s:2:\"50\";s:18:\"can_view_own_audio\";s:1:\"1\";s:18:\"can_view_all_audio\";s:1:\"1\";s:18:\"can_edit_own_audio\";s:1:\"1\";s:18:\"can_edit_all_audio\";s:1:\"0\";s:21:\"can_approve_own_audio\";s:1:\"1\";s:21:\"can_approve_all_audio\";s:1:\"0\";s:20:\"can_delete_own_audio\";s:1:\"1\";s:20:\"can_delete_all_audio\";s:1:\"0\";s:15:\"can_rate_audios\";s:1:\"1\";s:14:\"can_add_events\";s:2:\"50\";s:17:\"credits_add_event\";s:1:\"0\";s:15:\"can_join_events\";s:1:\"1\";s:16:\"can_leave_events\";s:1:\"1\";s:19:\"can_view_own_events\";s:1:\"1\";s:19:\"can_view_all_events\";s:1:\"1\";s:19:\"can_edit_own_events\";s:1:\"1\";s:19:\"can_edit_all_events\";s:1:\"0\";s:21:\"can_delete_own_events\";s:1:\"1\";s:21:\"can_delete_all_events\";s:1:\"0\";s:28:\"can_delete_own_events_guests\";s:1:\"1\";s:28:\"can_delete_all_events_guests\";s:1:\"0\";s:17:\"can_search_events\";s:1:\"1\";s:19:\"events_search_delay\";s:1:\"5\";s:28:\"can_post_own_events_comments\";s:1:\"1\";s:28:\"can_post_all_events_comments\";s:1:\"1\";s:29:\"can_add_events_comments_delay\";s:2:\"50\";s:28:\"can_view_own_events_comments\";s:1:\"1\";s:28:\"can_view_all_events_comments\";s:1:\"1\";s:28:\"can_edit_own_events_comments\";s:1:\"1\";s:28:\"can_edit_all_events_comments\";s:1:\"0\";s:30:\"can_delete_own_events_comments\";s:1:\"1\";s:30:\"can_delete_all_events_comments\";s:1:\"0\";s:23:\"can_add_events_pictures\";s:2:\"50\";s:28:\"can_view_own_events_pictures\";s:1:\"1\";s:28:\"can_view_all_events_pictures\";s:1:\"1\";s:28:\"can_edit_own_events_pictures\";s:1:\"1\";s:28:\"can_edit_all_events_pictures\";s:1:\"0\";s:31:\"can_approve_own_events_pictures\";s:1:\"1\";s:31:\"can_approve_all_events_pictures\";s:1:\"0\";s:30:\"can_delete_own_events_pictures\";s:1:\"1\";s:30:\"can_delete_all_events_pictures\";s:1:\"0\";s:23:\"can_send_quick_messages\";s:1:\"1\";s:17:\"can_send_messages\";s:1:\"1\";s:18:\"can_reply_messages\";s:1:\"1\";s:15:\"credits_send_pm\";s:1:\"0\";s:16:\"credits_send_qpm\";s:1:\"0\";s:23:\"can_send_messages_delay\";s:2:\"50\";s:11:\"maxmessages\";s:3:\"500\";s:17:\"apply_word_filter\";s:1:\"1\";s:21:\"can_read_own_messages\";s:1:\"1\";s:21:\"can_read_all_messages\";s:1:\"0\";s:23:\"can_delete_own_messages\";s:1:\"1\";s:23:\"can_delete_all_messages\";s:1:\"0\";s:8:\"can_chat\";s:1:\"1\";s:17:\"can_send_feedback\";s:1:\"1\";s:14:\"can_send_gifts\";s:5:\"1,5,2\";s:20:\"can_send_gifts_delay\";s:2:\"50\";s:14:\"can_view_gifts\";s:1:\"1\";s:16:\"can_delete_gifts\";s:1:\"1\";s:13:\"can_add_blogs\";s:1:\"1\";s:17:\"can_view_own_blog\";s:1:\"1\";s:18:\"can_view_all_blogs\";s:1:\"1\";s:18:\"can_edit_own_blogs\";s:1:\"1\";s:18:\"can_edit_all_blogs\";s:1:\"0\";s:19:\"can_delete_own_blog\";s:1:\"1\";s:19:\"can_delete_all_blog\";s:1:\"0\";s:27:\"can_post_own_blogs_comments\";s:1:\"1\";s:27:\"can_post_all_blogs_comments\";s:1:\"1\";s:27:\"can_add_blog_comments_delay\";s:2:\"50\";s:27:\"can_view_own_blogs_comments\";s:1:\"1\";s:27:\"can_view_all_blogs_comments\";s:1:\"1\";s:27:\"can_edit_own_blogs_comments\";s:1:\"0\";s:27:\"can_edit_all_blogs_comments\";s:1:\"0\";s:29:\"can_delete_own_blogs_comments\";s:1:\"1\";s:29:\"can_delete_all_blogs_comments\";s:1:\"0\";s:23:\"can_post_own_guestbooks\";s:1:\"1\";s:23:\"can_post_all_guestbooks\";s:1:\"1\";s:25:\"can_sign_guestbooks_delay\";s:2:\"50\";s:22:\"can_view_own_guestbook\";s:1:\"1\";s:23:\"can_view_all_guestbooks\";s:1:\"1\";s:25:\"can_approve_own_guestbook\";s:1:\"1\";s:26:\"can_approve_all_guestbooks\";s:1:\"0\";s:24:\"can_delete_own_guestbook\";s:1:\"1\";s:25:\"can_delete_all_guestbooks\";s:1:\"0\";s:17:\"can_add_favorites\";s:3:\"100\";s:22:\"can_view_own_favorites\";s:1:\"1\";s:22:\"can_view_all_favorites\";s:1:\"0\";s:24:\"can_delete_own_favorites\";s:1:\"1\";s:24:\"can_delete_all_favorites\";s:1:\"0\";s:17:\"can_view_own_fans\";s:1:\"1\";s:15:\"can_add_friends\";s:3:\"100\";s:20:\"can_view_own_friends\";s:1:\"1\";s:20:\"can_view_all_friends\";s:1:\"1\";s:22:\"can_delete_own_friends\";s:1:\"1\";s:22:\"can_delete_all_friends\";s:1:\"0\";s:14:\"can_tellfriend\";s:1:\"1\";s:21:\"can_view_own_visitors\";s:2:\"50\";s:21:\"can_view_all_visitors\";s:1:\"0\";s:17:\"can_refer_members\";s:1:\"1\";s:18:\"can_refer_upgrades\";s:1:\"1\";s:22:\"can_view_own_referrals\";s:1:\"1\";s:22:\"can_view_all_referrals\";s:1:\"0\";s:24:\"can_delete_all_referrals\";s:1:\"0\";s:17:\"can_block_members\";s:1:\"1\";s:19:\"can_unblock_members\";s:1:\"1\";s:23:\"can_unblock_all_members\";s:1:\"0\";s:18:\"can_submit_reports\";s:1:\"1\";s:24:\"can_submit_reports_delay\";s:2:\"50\";s:19:\"can_change_template\";s:1:\"1\";s:19:\"can_change_language\";s:1:\"1\";s:16:\"can_view_banners\";s:1:\"1\";s:13:\"can_access_cp\";s:1:\"0\";s:18:\"can_manage_members\";s:1:\"0\";s:18:\"can_export_members\";s:1:\"0\";s:19:\"can_manage_packages\";s:1:\"0\";s:17:\"can_manage_orders\";s:1:\"0\";s:24:\"can_send_member_messages\";s:1:\"0\";s:20:\"can_send_mass_emails\";s:1:\"0\";s:22:\"can_send_mass_messages\";s:1:\"0\";s:23:\"can_manage_custom_pages\";s:1:\"0\";s:15:\"can_manage_news\";s:1:\"0\";s:16:\"can_manage_polls\";s:1:\"0\";s:18:\"can_manage_reports\";s:1:\"0\";s:18:\"can_manage_banners\";s:1:\"0\";s:16:\"can_manage_stats\";s:1:\"0\";s:18:\"can_manage_backups\";s:1:\"0\";s:16:\"can_manage_files\";s:1:\"0\";s:21:\"can_manage_extensions\";s:1:\"0\";s:19:\"can_manage_settings\";s:1:\"0\";s:26:\"can_manage_email_templates\";s:1:\"0\";s:20:\"can_manage_languages\";s:1:\"0\";s:20:\"can_manage_templates\";s:1:\"0\";s:24:\"can_manage_quickmessages\";s:1:\"0\";s:25:\"can_manage_members_groups\";s:1:\"0\";s:25:\"can_manage_members_fields\";s:1:\"0\";s:24:\"can_manage_events_fields\";s:1:\"0\";}',0),\r\n\t\t(6,'Canceled members','a:196:{s:9:\"can_login\";s:1:\"0\";s:15:\"can_view_online\";s:1:\"0\";s:16:\"can_view_offline\";s:1:\"0\";s:19:\"can_search_profiles\";s:1:\"0\";s:19:\"can_advanced_search\";s:1:\"0\";s:12:\"search_delay\";s:1:\"0\";s:17:\"can_save_searches\";s:1:\"0\";s:20:\"can_browse_group_ids\";s:0:\"\";s:18:\"can_view_group_ids\";s:0:\"\";s:16:\"can_rate_members\";s:1:\"0\";s:20:\"can_edit_own_profile\";s:1:\"0\";s:21:\"can_edit_all_profiles\";s:1:\"0\";s:20:\"apply_profile_filter\";s:1:\"0\";s:23:\"can_delete_all_profiles\";s:1:\"0\";s:19:\"can_upgrade_account\";s:1:\"0\";s:27:\"can_change_privacy_settings\";s:1:\"0\";s:22:\"can_cancel_own_account\";s:1:\"0\";s:14:\"can_add_albums\";s:1:\"0\";s:19:\"can_password_albums\";s:1:\"0\";s:16:\"can_add_pictures\";s:1:\"0\";s:21:\"can_view_own_pictures\";s:1:\"0\";s:21:\"can_view_all_pictures\";s:1:\"0\";s:21:\"can_view_adult_images\";s:1:\"0\";s:21:\"can_edit_own_pictures\";s:1:\"0\";s:21:\"can_edit_all_pictures\";s:1:\"0\";s:24:\"can_approve_own_pictures\";s:1:\"0\";s:24:\"can_approve_all_pictures\";s:1:\"0\";s:23:\"can_delete_own_pictures\";s:1:\"0\";s:23:\"can_delete_all_pictures\";s:1:\"0\";s:17:\"can_rate_pictures\";s:1:\"0\";s:30:\"can_post_own_pictures_comments\";s:1:\"0\";s:30:\"can_post_all_pictures_comments\";s:1:\"0\";s:31:\"can_add_pictures_comments_delay\";s:1:\"0\";s:30:\"can_view_own_pictures_comments\";s:1:\"0\";s:30:\"can_view_all_pictures_comments\";s:1:\"0\";s:30:\"can_edit_own_pictures_comments\";s:1:\"0\";s:30:\"can_edit_all_pictures_comments\";s:1:\"0\";s:32:\"can_delete_own_pictures_comments\";s:1:\"0\";s:32:\"can_delete_all_pictures_comments\";s:1:\"0\";s:14:\"can_add_videos\";s:1:\"0\";s:19:\"can_view_own_videos\";s:1:\"0\";s:19:\"can_view_all_videos\";s:1:\"0\";s:21:\"can_view_adult_videos\";s:1:\"0\";s:19:\"can_edit_own_videos\";s:1:\"0\";s:19:\"can_edit_all_videos\";s:1:\"0\";s:22:\"can_approve_own_videos\";s:1:\"0\";s:22:\"can_approve_all_videos\";s:1:\"0\";s:21:\"can_delete_own_videos\";s:1:\"0\";s:21:\"can_delete_all_videos\";s:1:\"0\";s:15:\"can_rate_videos\";s:1:\"0\";s:28:\"can_post_own_videos_comments\";s:1:\"0\";s:28:\"can_post_all_videos_comments\";s:1:\"0\";s:29:\"can_add_videos_comments_delay\";s:1:\"0\";s:28:\"can_view_own_videos_comments\";s:1:\"0\";s:28:\"can_view_all_videos_comments\";s:1:\"0\";s:28:\"can_edit_own_videos_comments\";s:1:\"0\";s:28:\"can_edit_all_videos_comments\";s:1:\"0\";s:30:\"can_delete_own_videos_comments\";s:1:\"0\";s:30:\"can_delete_all_videos_comments\";s:1:\"0\";s:13:\"can_add_audio\";s:1:\"0\";s:18:\"can_view_own_audio\";s:1:\"0\";s:18:\"can_view_all_audio\";s:1:\"0\";s:18:\"can_edit_own_audio\";s:1:\"0\";s:18:\"can_edit_all_audio\";s:1:\"0\";s:21:\"can_approve_own_audio\";s:1:\"0\";s:21:\"can_approve_all_audio\";s:1:\"0\";s:20:\"can_delete_own_audio\";s:1:\"0\";s:20:\"can_delete_all_audio\";s:1:\"0\";s:15:\"can_rate_audios\";s:1:\"0\";s:14:\"can_add_events\";s:1:\"0\";s:17:\"credits_add_event\";s:1:\"0\";s:15:\"can_join_events\";s:1:\"0\";s:16:\"can_leave_events\";s:1:\"0\";s:19:\"can_view_own_events\";s:1:\"0\";s:19:\"can_view_all_events\";s:1:\"0\";s:19:\"can_edit_own_events\";s:1:\"0\";s:19:\"can_edit_all_events\";s:1:\"0\";s:21:\"can_delete_own_events\";s:1:\"0\";s:21:\"can_delete_all_events\";s:1:\"0\";s:28:\"can_delete_own_events_guests\";s:1:\"0\";s:28:\"can_delete_all_events_guests\";s:1:\"0\";s:17:\"can_search_events\";s:1:\"0\";s:19:\"events_search_delay\";s:1:\"0\";s:28:\"can_post_own_events_comments\";s:1:\"0\";s:28:\"can_post_all_events_comments\";s:1:\"0\";s:29:\"can_add_events_comments_delay\";s:1:\"0\";s:28:\"can_view_own_events_comments\";s:1:\"0\";s:28:\"can_view_all_events_comments\";s:1:\"0\";s:28:\"can_edit_own_events_comments\";s:1:\"0\";s:28:\"can_edit_all_events_comments\";s:1:\"0\";s:30:\"can_delete_own_events_comments\";s:1:\"0\";s:30:\"can_delete_all_events_comments\";s:1:\"0\";s:23:\"can_add_events_pictures\";s:1:\"0\";s:28:\"can_view_own_events_pictures\";s:1:\"0\";s:28:\"can_view_all_events_pictures\";s:1:\"0\";s:28:\"can_edit_own_events_pictures\";s:1:\"0\";s:28:\"can_edit_all_events_pictures\";s:1:\"0\";s:31:\"can_approve_own_events_pictures\";s:1:\"0\";s:31:\"can_approve_all_events_pictures\";s:1:\"0\";s:30:\"can_delete_own_events_pictures\";s:1:\"0\";s:30:\"can_delete_all_events_pictures\";s:1:\"0\";s:23:\"can_send_quick_messages\";s:1:\"0\";s:17:\"can_send_messages\";s:0:\"\";s:18:\"can_reply_messages\";s:0:\"\";s:15:\"credits_send_pm\";s:1:\"0\";s:16:\"credits_send_qpm\";s:1:\"0\";s:23:\"can_send_messages_delay\";s:1:\"0\";s:11:\"maxmessages\";s:1:\"0\";s:17:\"apply_word_filter\";s:1:\"0\";s:21:\"can_read_own_messages\";s:1:\"0\";s:21:\"can_read_all_messages\";s:1:\"0\";s:23:\"can_delete_own_messages\";s:1:\"0\";s:23:\"can_delete_all_messages\";s:1:\"0\";s:8:\"can_chat\";s:1:\"0\";s:17:\"can_send_feedback\";s:1:\"0\";s:14:\"can_send_gifts\";s:0:\"\";s:20:\"can_send_gifts_delay\";s:1:\"0\";s:14:\"can_view_gifts\";s:1:\"0\";s:16:\"can_delete_gifts\";s:1:\"0\";s:13:\"can_add_blogs\";s:1:\"0\";s:17:\"can_view_own_blog\";s:1:\"0\";s:18:\"can_view_all_blogs\";s:1:\"0\";s:18:\"can_edit_own_blogs\";s:1:\"0\";s:18:\"can_edit_all_blogs\";s:1:\"0\";s:19:\"can_delete_own_blog\";s:1:\"0\";s:19:\"can_delete_all_blog\";s:1:\"0\";s:27:\"can_post_own_blogs_comments\";s:1:\"0\";s:27:\"can_post_all_blogs_comments\";s:1:\"0\";s:27:\"can_add_blog_comments_delay\";s:1:\"0\";s:27:\"can_view_own_blogs_comments\";s:1:\"0\";s:27:\"can_view_all_blogs_comments\";s:1:\"0\";s:27:\"can_edit_own_blogs_comments\";s:1:\"0\";s:27:\"can_edit_all_blogs_comments\";s:1:\"0\";s:29:\"can_delete_own_blogs_comments\";s:1:\"0\";s:29:\"can_delete_all_blogs_comments\";s:1:\"0\";s:23:\"can_post_own_guestbooks\";s:1:\"0\";s:23:\"can_post_all_guestbooks\";s:1:\"0\";s:25:\"can_sign_guestbooks_delay\";s:1:\"0\";s:22:\"can_view_own_guestbook\";s:1:\"0\";s:23:\"can_view_all_guestbooks\";s:1:\"0\";s:25:\"can_approve_own_guestbook\";s:1:\"0\";s:26:\"can_approve_all_guestbooks\";s:1:\"0\";s:24:\"can_delete_own_guestbook\";s:1:\"0\";s:25:\"can_delete_all_guestbooks\";s:1:\"0\";s:17:\"can_add_favorites\";s:1:\"0\";s:22:\"can_view_own_favorites\";s:1:\"0\";s:22:\"can_view_all_favorites\";s:1:\"0\";s:24:\"can_delete_own_favorites\";s:1:\"0\";s:24:\"can_delete_all_favorites\";s:1:\"0\";s:17:\"can_view_own_fans\";s:1:\"0\";s:15:\"can_add_friends\";s:1:\"0\";s:20:\"can_view_own_friends\";s:1:\"0\";s:20:\"can_view_all_friends\";s:1:\"0\";s:22:\"can_delete_own_friends\";s:1:\"0\";s:22:\"can_delete_all_friends\";s:1:\"0\";s:14:\"can_tellfriend\";s:1:\"0\";s:21:\"can_view_own_visitors\";s:1:\"0\";s:21:\"can_view_all_visitors\";s:1:\"0\";s:17:\"can_refer_members\";s:1:\"0\";s:18:\"can_refer_upgrades\";s:1:\"0\";s:22:\"can_view_own_referrals\";s:1:\"0\";s:22:\"can_view_all_referrals\";s:1:\"0\";s:24:\"can_delete_all_referrals\";s:1:\"0\";s:17:\"can_block_members\";s:1:\"0\";s:19:\"can_unblock_members\";s:1:\"0\";s:23:\"can_unblock_all_members\";s:1:\"0\";s:18:\"can_submit_reports\";s:1:\"0\";s:24:\"can_submit_reports_delay\";s:1:\"0\";s:19:\"can_change_template\";s:1:\"0\";s:19:\"can_change_language\";s:1:\"0\";s:16:\"can_view_banners\";s:1:\"0\";s:13:\"can_access_cp\";s:1:\"0\";s:18:\"can_manage_members\";s:1:\"0\";s:18:\"can_export_members\";s:1:\"0\";s:19:\"can_manage_packages\";s:1:\"0\";s:17:\"can_manage_orders\";s:1:\"0\";s:24:\"can_send_member_messages\";s:1:\"0\";s:20:\"can_send_mass_emails\";s:1:\"0\";s:22:\"can_send_mass_messages\";s:1:\"0\";s:23:\"can_manage_custom_pages\";s:1:\"0\";s:15:\"can_manage_news\";s:1:\"0\";s:16:\"can_manage_polls\";s:1:\"0\";s:18:\"can_manage_reports\";s:1:\"0\";s:18:\"can_manage_banners\";s:1:\"0\";s:16:\"can_manage_stats\";s:1:\"0\";s:18:\"can_manage_backups\";s:1:\"0\";s:16:\"can_manage_files\";s:1:\"0\";s:21:\"can_manage_extensions\";s:1:\"0\";s:19:\"can_manage_settings\";s:1:\"0\";s:26:\"can_manage_email_templates\";s:1:\"0\";s:20:\"can_manage_languages\";s:1:\"0\";s:20:\"can_manage_templates\";s:1:\"0\";s:24:\"can_manage_quickmessages\";s:1:\"0\";s:25:\"can_manage_members_groups\";s:1:\"0\";s:25:\"can_manage_members_fields\";s:1:\"0\";s:24:\"can_manage_events_fields\";s:1:\"0\";}',0)\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."members_items`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."members_items` (\r\n\t\t`data_id` int(9) unsigned NOT NULL,\r\n\t\t`field_id` smallint(4) unsigned NOT NULL,\r\n\t\t`item_id` int(6) unsigned NOT NULL,\r\n\t\tKEY `data_id` (`data_id`),\r\n\t\tKEY `field_id` (`field_id`),\r\n\t\tKEY `item_id` (`item_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."messages`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."messages` (\r\n\t\t`message_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`member_id1` int(9) unsigned NOT NULL default '0',\r\n\t\t`member_id2` int(9) unsigned NOT NULL default '0',\r\n\t\t`senddate` int(10) unsigned NOT NULL default '0',\r\n\t\t`subject` varchar(255) NOT NULL default '',\r\n\t\t`body` text NOT NULL,\r\n\t\t`new` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`delete1` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`delete2` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`quickmsg` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`message_id`),\r\n\t\tKEY `member_id1` (`member_id1`),\r\n\t\tKEY `member_id2` (`member_id2`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."messages_gifts`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."messages_gifts` (\r\n\t\t`message_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`gift_id` int(6) unsigned NOT NULL,\r\n\t\t`member_id1` int(9) unsigned NOT NULL,\r\n\t\t`member_id2` int(9) unsigned NOT NULL,\r\n\t\t`senddate` int(10) unsigned NOT NULL,\r\n\t\t`new` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`message` text NOT NULL,\r\n\t\t`private` tinyint(1) unsigned NOT NULL,\r\n\t\t`delete1` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`delete2` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`message_id`),\r\n\t\tKEY `member_id1` (`member_id1`),\r\n\t\tKEY `member_id2` (`member_id2`),\r\n\t\tKEY `gift_id` (`gift_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."news`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."news` (\r\n\t\t`news_id` int(10) unsigned NOT NULL auto_increment,\r\n\t\t`title` varchar(255) NOT NULL,\r\n\t\t`body` text,\r\n\t\t`meta_description` varchar(255) NOT NULL,\r\n\t\t`meta_keywords` varchar(255) NOT NULL,\r\n\t\t`postdate` int(10) unsigned NOT NULL,\r\n\t\t`picture` varchar(32) NOT NULL,\r\n\t\t`comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`totalcomments` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`totalviews` int(9) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`news_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."news_comments`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."news_comments` (\r\n\t\t`comment_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`news_id` int(9) unsigned NOT NULL,\r\n\t\t`poster_id` int(9) unsigned NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(9) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`comment_id`),\r\n\t\tKEY `news_id` (`news_id`),\r\n\t\tKEY `poster_id` (`poster_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."newsletters`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."newsletters` (\r\n\t\t`newsletter_id` int(6) unsigned NOT NULL auto_increment,\r\n\t\t`to_subscribers` tinyint(1) unsigned NOT NULL,\r\n\t\t`to_group` smallint(5) unsigned NOT NULL,\r\n\t\t`to_profile` smallint(5) unsigned NOT NULL,\r\n\t\t`to_username` varchar(32) NOT NULL,\r\n\t\t`to_fields` text NOT NULL,\r\n\t\t`to_items` text NOT NULL,\r\n\t\t`subject` varchar(255) NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`totalsent` int(9) unsigned NOT NULL,\r\n\t\t`last_id` int(9) unsigned NOT NULL,\r\n\t\t`nl_type` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`pending` tinyint(3) unsigned NOT NULL default '0',\r\n\t\t`sentdate` int(10) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`newsletter_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."newsletters_templates`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."newsletters_templates` (\r\n\t\t`template_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t\t`name` varchar(255) NOT NULL,\r\n\t\t`subject` varchar(255) NOT NULL default '',\r\n\t\t`body` text NOT NULL,\r\n\t\tPRIMARY KEY (`template_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."notifications`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."notifications` (\r\n\t\t`notification_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned default NULL,\r\n\t\t`poster_id` int(9) unsigned default NULL,\r\n\t\t`content_id` int(9) unsigned default NULL,\r\n\t\t`item_id` int(9) unsigned default NULL,\r\n\t\t`type` varchar(64) NOT NULL,\r\n\t\t`postdate` int(10) unsigned default NULL,\r\n\t\t`new` tinyint(1) NOT NULL default '1',\r\n\t\tPRIMARY KEY (`notification_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."pages`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."pages` (\r\n\t\t`page_id` smallint(4) unsigned NOT NULL auto_increment,\r\n\t\t`group_id` smallint(4) unsigned NOT NULL,\r\n\t\t`label` varchar(32) NOT NULL default '',\r\n\t\t`name_english` varchar(255) NOT NULL default '',\r\n\t\t`page_english` text NOT NULL,\r\n\t\t`meta_description_english` varchar(255) NOT NULL,\r\n\t\t`meta_keywords_english` varchar(255) NOT NULL,\r\n\t\t`template` varchar(128) NOT NULL default '',\r\n\t\t`visibility` varchar(255) NOT NULL default '',\r\n\t\t`totalviews` int(9) unsigned NOT NULL default '0',\r\n\t\t`customtag` varchar(255) NOT NULL,\r\n\t\t`comments` tinyint(1) NOT NULL default '0',\r\n\t\t`totalcomments` smallint(5) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`page_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."pages`(`page_id`,`group_id`,`label`,`name_english`,`page_english`,`template`,`visibility`,`customtag`,`comments`) values\r\n\t(1,1,'tos','Terms of service','Edit this page in the control panel and insert your terms of service here.','','','footer','0'),\r\n\t(2,1,'noaccess','No access','You are not allowed to access this page.','','','','0'),\r\n\t(3,1,'offline','Offline','Website is currenly offline. Please come back later.','','','','0'),\r\n\t(4,1,'homepage_welcome','Welcome to our community','Edit this paragraph in the control panel under *content - manage pages - general - welcome*','','0','0','0')" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."pages_comments`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."pages_comments` (\r\n\t\t`comment_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`page_id` int(9) unsigned NOT NULL,\r\n\t\t`poster_id` int(9) unsigned NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(9) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`comment_id`),\r\n\t\tKEY `page_id` (`page_id`),\r\n\t\tKEY `poster_id` (`poster_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."pages_groups`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."pages_groups` (\r\n\t\t`group_id` smallint(4) unsigned NOT NULL auto_increment,\r\n\t\t`label` varchar(32) default NULL,\r\n\t\t`name` varchar(128) default NULL,\r\n\t\tPRIMARY KEY (`group_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."pages_groups`(`group_id`,`label`,`name`) values\r\n\t\t(1,'general','General')\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."payment_gateways`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."payment_gateways` (\r\n\t\t`gateway_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t\t`name` varchar(128) NOT NULL,\r\n\t\t`label` varchar(32) NOT NULL,\r\n\t\t`settings` text NOT NULL,\r\n\t\t`active` tinyint(1) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`gateway_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."payment_gateways`(`name`,`label`,`settings`,`active`) values\r\n\t\t('Authorize.net','authorizenet','a:3:{s:19:\"enable_authorizenet\";s:1:\"0\";s:18:\"authorize_login_id\";s:0:\"\";s:18:\"authorize_trans_id\";s:0:\"\";}',0),\r\n\t\t('PayPal','paypal','a:3:{s:13:\"enable_paypal\";s:1:\"1\";s:12:\"paypal_email\";s:17:\"email@website.com\";s:15:\"paypal_currency\";s:3:\"USD\";}',1)\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."pictures`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."pictures` (\r\n\t\t`picture_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`album_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`filename` varchar(32) NOT NULL,\r\n\t\t`description` varchar(255) NOT NULL default '',\r\n\t\t`adult` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`dateadded` int(10) unsigned NOT NULL default '0',\r\n\t\t`rated` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`totalvotes` int(6) unsigned NOT NULL default '0',\r\n\t\t`totalscore` int(6) unsigned NOT NULL default '0',\r\n\t\t`active` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`comments` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t`totalcomments` smallint(4) unsigned NOT NULL default '0',\r\n\t\t`albumcover` tinyint(1) unsigned NOT NULL default '0',\r\n\t\t`totalviews` int(9) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`picture_id`),\r\n\t\tKEY `member_id` (`member_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."pictures_comments`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."pictures_comments` (\r\n\t\t`comment_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`album_id` int(9) unsigned NOT NULL,\r\n\t\t`picture_id` int(9) unsigned NOT NULL,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`poster_id` int(9) unsigned NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(9) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`comment_id`),\r\n\t\tKEY `picture_id` (`picture_id`),\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `poster_id` (`poster_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."polls`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."polls` (\r\n\t\t`poll_id` int(8) unsigned NOT NULL auto_increment,\r\n\t\t`label` varchar(32) NOT NULL,\r\n\t\t`question` varchar(255) NOT NULL,\r\n\t\t`answers` text NOT NULL,\r\n\t\t`totalvotes` int(8) unsigned NOT NULL,\r\n\t\t`postdate` int(10) unsigned NOT NULL,\r\n\t\t`active` tinyint(1) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`poll_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."quickmessages`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."quickmessages` (\r\n\t\t`message_id` int(5) unsigned NOT NULL auto_increment,\r\n\t\t`subject` varchar(128) NOT NULL default '',\r\n\t\t`body` text NOT NULL,\r\n\t\t`template` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`message_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."quickmessages`(`message_id`,`subject`,`body`,`template`) values\r\n\t\t(1,'wink wink','Wink ;) Wanna chat sometime?',0),\r\n\t\t(2,'kiss for you','Muahz cutie!',0),\r\n\t\t(3,'Hey there','Hey there,\n\nJust wanted to let you know that I like your profile and was hoping we could get to know each other better. Check out my profile and write back if you are interested!\n\nHope to hear from you soon.',1)\r\n\t" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."reports`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."reports` (\r\n\t `report_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t `reporter_id` int(9) unsigned NOT NULL,\r\n\t `type` varchar(16) NOT NULL,\r\n\t `reason` varchar(64) NOT NULL,\r\n\t `member_id` int(9) unsigned NOT NULL,\r\n\t `content_id` int(9) unsigned NOT NULL,\r\n\t `reportdate` int(10) unsigned NOT NULL,\r\n\t PRIMARY KEY (`report_id`),\r\n\t KEY `reporter_id` (`reporter_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."requests`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."requests` (\r\n\t\t`request_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`sesshash` varchar(32) NOT NULL,\r\n\t\t`type` varchar(64) NOT NULL,\r\n\t\t`val` varchar(255) NOT NULL,\r\n\t\t`requestdate` int(10) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`request_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."search_queries`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."search_queries` (\r\n\t\t`session_id` varchar(32) NOT NULL default '',\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`type_id` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`searchtime` int(10) unsigned NOT NULL default '0',\r\n\t\t`query_fields` text NOT NULL,\r\n\t\t`query_items` text NOT NULL,\r\n\t\t`query_values` text NOT NULL,\r\n\t\t`query_orderby` varchar(20) NOT NULL default '',\r\n\t\t`query_direction` varchar(5) NOT NULL default '',\r\n\t\t`totalresults` int(6) unsigned NOT NULL default '0',\r\n\t\t`display_type` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`session_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."search_saved`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."search_saved` (\r\n\t\t`search_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`type_id` smallint(5) unsigned NOT NULL default '0',\r\n\t\t`search_hash` varchar(32) NOT NULL default '',\r\n\t\t`search_title` varchar(128) NOT NULL default '',\r\n\t\t`search_fields` text NOT NULL,\r\n\t\t`search_items` text NOT NULL,\r\n\t\t`search_orderby` varchar(20) NOT NULL default '',\r\n\t\t`search_direction` varchar(5) NOT NULL default '',\r\n\t\t`searchdate` int(10) unsigned NOT NULL default '0',\r\n\t\t`display_type` tinyint(1) unsigned NOT NULL default '0',\r\n\t\tPRIMARY KEY (`search_id`),\r\n\t\tKEY `member_id` (`member_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."settings`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."settings` (\r\n\t `setting_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t `type` varchar(12) NOT NULL default '',\r\n\t `label` varchar(40) NOT NULL default '',\r\n\t `val` text NOT NULL,\r\n\t `orderid` int(4) unsigned NOT NULL default '0',\r\n\t `group_id` varchar(32) NOT NULL,\r\n\t `subgroup_id` varchar(32) NOT NULL,\r\n\t PRIMARY KEY (`setting_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."settings_subgroups`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."settings_subgroups` (\r\n\t\t`subgroup_id` tinyint(3) unsigned NOT NULL auto_increment,\r\n\t\t`group_id` varchar(128) NOT NULL,\r\n\t\t`label` varchar(128) NOT NULL,\r\n\t\t`orderid` tinyint(3) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`subgroup_id`),\r\n\t\tKEY `subgroup_id` (`subgroup_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."settings_groups`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."settings_groups` (\r\n\t `group_id` tinyint(3) unsigned NOT NULL auto_increment,\r\n\t `label` varchar(128) NOT NULL default '',\r\n\t `orderid` smallint(3) unsigned NOT NULL default '0',\r\n\t PRIMARY KEY (`group_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."templates`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."templates` (\r\n\t `template_id` int(3) unsigned NOT NULL auto_increment,\r\n\t `name` varchar(32) NOT NULL default '',\r\n\t `label` varchar(32) NOT NULL default '',\r\n\t PRIMARY KEY (`template_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."templates`(`template_id`,`name`,`label`) values (1,'Webby2','webby2')" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."uszipcodes`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."uszipcodes` (\r\n\t `zip` int(5) NOT NULL default '0',\r\n\t `latitude` decimal(10,6) NOT NULL default '0.000000',\r\n\t `longitude` decimal(10,6) NOT NULL default '0.000000',\r\n\t PRIMARY KEY (`zip`),\r\n\t KEY `latitude` (`latitude`),\r\n\t KEY `longitude` (`longitude`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."videos`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."videos` (\r\n\t `video_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t `member_id` int(9) unsigned NOT NULL,\r\n\t `category_id` int(6) unsigned NOT NULL,\r\n\t `filename` varchar(32) NOT NULL default '',\r\n\t `preview` varchar(32) default '',\r\n\t `description` varchar(255) default '',\r\n\t `dateadded` int(10) unsigned NOT NULL default '0',\r\n\t `adult` tinyint(1) unsigned NOT NULL default '0',\r\n\t `active` tinyint(1) unsigned NOT NULL default '1',\r\n\t `totalvotes` int(6) unsigned NOT NULL default '0',\r\n\t `totalscore` int(6) unsigned NOT NULL default '0',\r\n\t `rated` tinyint(1) unsigned NOT NULL default '0',\r\n\t `comments` tinyint(1) NOT NULL default '1',\r\n\t `totalcomments` smallint(4) unsigned NOT NULL,\r\n\t `totalviews` int(9) unsigned NOT NULL default '0',\r\n\t `streaming` tinyint(1) unsigned NOT NULL default '0',\r\n\t `encode_job_id` int(10) unsigned NOT NULL default '0',\r\n\t `notes` varchar(255) default '',\r\n\t PRIMARY KEY (`video_id`),\r\n\t KEY `member_id` (`member_id`),\r\n\t KEY `category_id` (`category_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."videos_comments`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."videos_comments` (\r\n\t\t`comment_id` bigint(12) unsigned NOT NULL auto_increment,\r\n\t\t`video_id` int(9) unsigned NOT NULL,\r\n\t\t`member_id` int(9) unsigned NOT NULL,\r\n\t\t`poster_id` int(9) unsigned NOT NULL,\r\n\t\t`body` text NOT NULL,\r\n\t\t`postdate` int(9) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`comment_id`),\r\n\t\tKEY `video_id` (`video_id`),\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `poster_id` (`poster_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."visitors`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."visitors` (\r\n\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`visitor_id` int(9) unsigned NOT NULL default '0',\r\n\t\t`visitdate` int(10) unsigned NOT NULL default '0',\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `visitor_id` (`visitor_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."votes`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."votes` (\r\n\t\t`type` varchar(64) NOT NULL,\r\n\t\t`member_id` int(10) unsigned NOT NULL,\r\n\t\t`voter_id` int(10) unsigned NOT NULL,\r\n\t\t`content_id` int(10) unsigned NOT NULL,\r\n\t\t`ipaddress` varchar(15) NOT NULL,\r\n\t\t`postdate` int(10) unsigned NOT NULL,\r\n\t\t`vote` tinyint(3) unsigned NOT NULL,\r\n\t\tKEY `member_id` (`member_id`),\r\n\t\tKEY `content_id` (`content_id`),\r\n\t\tKEY `ipaddress` (`ipaddress`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."smilies`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."smilies` (\r\n\t\t`smiley_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t\t`shortcut` varchar(16) NOT NULL,\r\n\t\t`filename` varchar(32) NOT NULL,\r\n\t\t`name` varchar(255) NOT NULL,\r\n\t\t`orderid` smallint(5) unsigned NOT NULL,\r\n\t\tPRIMARY KEY (`smiley_id`)\r\n\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."smilies`(`smiley_id`,`shortcut`,`filename`,`name`,`orderid`) values\r\n\t\t(1,':)','smile.png','Smile',1),\r\n\t\t(2,':D','happy.png','Happy',2),\r\n\t\t(3,':O','surprised.png','Surprised',3),\r\n\t\t(4,':P','tongue.png','Tongue',4),\r\n\t\t(5,';)','wink.png','Wink',5),\r\n\t\t(6,':(','sad.png','Sad',6)" );
}
if ( strtoupper( substr( $_SESSION['license'], 0, 1 ) ) == "C" )
{
if ( !mysql_errno( ) )
{
$DB->query( "ALTER TABLE `".$_SESSION['db_prefix']."members` ADD referral_id INT(9) unsigned NOT NULL default 0" );
}
if ( !mysql_errno( ) )
{
$DB->query( "ALTER TABLE `".$_SESSION['db_prefix']."members` ADD totalreferrals smallint(4) unsigned NOT NULL default 0" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."banners`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."banners` (\r\n\t\t\t`banner_id` smallint(4) unsigned NOT NULL auto_increment,\r\n\t\t\t`group_id` tinyint(3) unsigned NOT NULL,\r\n\t\t\t`label` varchar(32) NOT NULL,\r\n\t\t\t`name` varchar(128) NOT NULL,\r\n\t\t\t`banner` text,\r\n\t\t\t`views` int(9) unsigned NOT NULL,\r\n\t\t\t`clicks` int(9) unsigned NOT NULL,\r\n\t\t\t`active` tinyint(1) unsigned NOT NULL,\r\n\t\t\tPRIMARY KEY (`banner_id`),\r\n\t\t\tKEY `group_id` (`group_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."banners_groups`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."banners_groups` (\r\n\t\t\t`group_id` tinyint(3) unsigned NOT NULL auto_increment,\r\n\t\t\t`label` varchar(32) NOT NULL,\r\n\t\t\t`name` varchar(128) NOT NULL,\r\n\t\t\t`visibility` varchar(255) NOT NULL,\r\n\t\t\tPRIMARY KEY (`group_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."banners_groups` (`group_id`,`label`,`name`) values (1,'sidebar','Sidebar')" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."banners_groups` (`group_id`,`label`,`name`) values (2,'header','Header')" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."orders`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."orders` (\r\n\t\t\t`order_id` int(9) unsigned NOT NULL auto_increment,\r\n\t\t\t`package_id` smallint(5) unsigned NOT NULL default '0',\r\n\t\t\t`member_id` int(9) unsigned NOT NULL default '0',\r\n\t\t\t`txn_id` varchar(255) NOT NULL,\r\n\t\t\t`paymentdate` int(10) NOT NULL,\r\n\t\t\t`amount` double(8,2) unsigned NOT NULL default '0.00',\r\n\t\t\t`term` smallint(4) unsigned NOT NULL default '0',\r\n\t\t\t`termtype` tinyint(1) unsigned NOT NULL,\r\n\t\t\t`credits` smallint(5) unsigned NOT NULL,\r\n\t\t\tPRIMARY KEY (`order_id`),\r\n\t\t\tKEY `member_id` (`member_id`)\r\n\t\t) $var_15" );
}
if ( !mysql_errno( ) )
{
$DB->query( "DROP TABLE IF EXISTS `".$_SESSION['db_prefix']."packages`" );
}
if ( !mysql_errno( ) )
{
$DB->query( "CREATE TABLE `".$_SESSION['db_prefix']."packages` (\r\n\t\t\t`package_id` smallint(5) unsigned NOT NULL auto_increment,\r\n\t\t\t`type_id` smallint(5) unsigned NOT NULL,\r\n\t\t\t`name` varchar(255) NOT NULL default '',\r\n\t\t\t`price` double(8,2) unsigned NOT NULL default '0.00',\r\n\t\t\t`term` smallint(4) NOT NULL default '0',\r\n\t\t\t`termtype` tinyint(1) unsigned NOT NULL,\r\n\t\t\t`credits` smallint(5) unsigned NOT NULL,\r\n\t\t\t`description` text NOT NULL,\r\n\t\t\t`nl` tinyint(1) unsigned NOT NULL,\r\n\t\t\t`recurring` tinyint(1) unsigned NOT NULL default '1',\r\n\t\t\t`group_id` smallint(5) NOT NULL,\r\n\t\t\t`orderid` smallint(5) unsigned NOT NULL default '0',\r\n\t\t\tPRIMARY KEY (`package_id`)\r\n\t\t) "$var_15"" );
}
if ( !mysql_errno( ) )
{
$DB->query( "insert into `".$_SESSION['db_prefix']."packages`(`package_id`,`name`,`price`,`term`,`termtype`,`description`,`nl`,`recurring`,`group_id`,`orderid`) values\r\n\t\t\t(1,'\$10 for 1 month',10.00,1,'2','Upgrade now and enjoy double limits of regular members for a whole month!','1','0',5,1),\r\n\t\t\t(2,'\$100 for 1 year',100.00,1,'3','Upgrade now and enjoy double limits of regular members for a whole year!','1','0',5,2)" );
}
}
$var_24 = array(
array( "type" => "boolean", "label" => "app_online", "value" => "1", "order" => 1, "group" => "general", "subgroup" => "general" ),
array( "type" => "text", "label" => "app_title", "value" => "My site", "order" => 2, "group" => "general", "subgroup" => "general" ),
array( "type" => "text", "label" => "app_description", "value" => "My site - Online community", "order" => 3, "group" => "general", "subgroup" => "general" ),
array( "type" => "text", "label" => "app_keywords", "value" => "dating, soulmate, friends, singles, love", "order" => 4, "group" => "general", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "fancy_urls", "value" => "0", "order" => 6, "group" => "general", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "fancy_homepages", "value" => "0", "order" => 7, "group" => "general", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "lockout_password", "value" => "1", "order" => 1, "group" => "security", "subgroup" => "general" ),
array( "type" => "number", "label" => "lockout_tries", "value" => "5", "order" => 2, "group" => "security", "subgroup" => "general" ),
array( "type" => "number", "label" => "lockout_time", "value" => "10", "order" => 3, "group" => "security", "subgroup" => "general" ),
array( "type" => "combo", "label" => "lostpass_username_email", "value" => "both", "order" => 4, "group" => "security", "subgroup" => "general" ),
array( "type" => "number", "label" => "user_timeout", "value" => "3", "order" => 5, "group" => "security", "subgroup" => "general" ),
array( "type" => "textarea", "label" => "banned_ips", "value" => "", "order" => 1, "group" => "security", "subgroup" => "banned" ),
array(
"type" => "textarea",
"label" => "banned_emails",
"value" => "@"."mytrashmail.com\\n"."@"."spamhole.com",
"order" => 2,
"group" => "security",
"subgroup" => "banned"
),
array( "type" => "textarea", "label" => "banned_usernames", "value" => "admin\\nwebmaster", "order" => 3, "group" => "security", "subgroup" => "banned" ),
array( "type" => "boolean", "label" => "allow_registration", "value" => "1", "order" => 1, "group" => "registration", "subgroup" => "general" ),
array( "type" => "combo", "label" => "activation_type", "value" => "2", "order" => 2, "group" => "registration", "subgroup" => "general" ),
array( "type" => "number", "label" => "min_username_length", "value" => "4", "order" => 3, "group" => "registration", "subgroup" => "general" ),
array( "type" => "number", "label" => "min_password_length", "value" => "4", "order" => 4, "group" => "registration", "subgroup" => "general" ),
array( "type" => "number", "label" => "min_age", "value" => "18", "order" => 5, "group" => "registration", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "registration_tos", "value" => "1", "order" => 6, "group" => "registration", "subgroup" => "general" ),
array( "type" => "number", "label" => "registration_delay", "value" => "12", "order" => 7, "group" => "registration", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "registration_captcha", "value" => "1", "order" => 8, "group" => "registration", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_registration_photo", "value" => "1", "order" => 9, "group" => "registration", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "require_registration_photo", "value" => "0", "order" => 10, "group" => "registration", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "member_notify_registration", "value" => "1", "order" => 1, "group" => "registration", "subgroup" => "notifications" ),
array( "type" => "boolean", "label" => "admin_notify_registration", "value" => "0", "order" => 2, "group" => "registration", "subgroup" => "notifications" ),
array( "type" => "boolean", "label" => "def_notify_daily_limit", "value" => "0", "order" => 1, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_private_messages", "value" => "1", "order" => 2, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_gifts", "value" => "1", "order" => 3, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_blog_comments", "value" => "1", "order" => 4, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_guestbook_comments", "value" => "1", "order" => 5, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_moderate_guestbooks", "value" => "0", "order" => 6, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_pictures_comments", "value" => "1", "order" => 7, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_videos_comments", "value" => "1", "order" => 8, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_notify_friends_requests", "value" => "1", "order" => 9, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "def_enable_newsletters", "value" => "1", "order" => 10, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "boolean", "label" => "default_adult_pictures", "value" => "0", "order" => 11, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "text", "label" => "default_album_name", "value" => "Default", "order" => 12, "group" => "registration", "subgroup" => "defaults" ),
array( "type" => "custom", "label" => "default_profile_type", "value" => "1", "order" => 1, "group" => "registration", "subgroup" => "groups" ),
array( "type" => "custom", "label" => "pending_member_group", "value" => "4", "order" => 2, "group" => "registration", "subgroup" => "groups" ),
array( "type" => "custom", "label" => "guest_member_group", "value" => "3", "order" => 3, "group" => "registration", "subgroup" => "groups" ),
array( "type" => "custom", "label" => "regular_member_group", "value" => "2", "order" => 4, "group" => "registration", "subgroup" => "groups" ),
array( "type" => "combo", "label" => "canceled_member_group", "value" => "6", "order" => 5, "group" => "registration", "subgroup" => "groups" ),
array( "type" => "combo", "label" => "trial_member_group", "value" => "5", "order" => 1, "group" => "registration", "subgroup" => "trials" ),
array( "type" => "number", "label" => "trial_member_length", "value" => "0", "order" => 2, "group" => "registration", "subgroup" => "trials" ),
array( "type" => "text", "label" => "def_favorites_ids", "value" => "", "order" => 1, "group" => "registration", "subgroup" => "welcome" ),
array( "type" => "text", "label" => "def_signee_id", "value" => "", "order" => 2, "group" => "registration", "subgroup" => "welcome" ),
array( "type" => "text", "label" => "def_welcome_msg_subject", "value" => "", "order" => 3, "group" => "registration", "subgroup" => "welcome" ),
array( "type" => "textarea", "label" => "def_welcome_msg_body", "value" => "", "order" => 4, "group" => "registration", "subgroup" => "welcome" ),
array( "type" => "textarea", "label" => "def_welcome_guestbook", "value" => "", "order" => 5, "group" => "registration", "subgroup" => "welcome" ),
array( "type" => "email", "label" => "admin_email", "value" => "email@website.com", "order" => 1, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "return_email_name", "value" => "webmaster", "order" => 2, "group" => "email", "subgroup" => "general" ),
array( "type" => "email", "label" => "return_email", "value" => "email@website.com", "order" => 3, "group" => "email", "subgroup" => "general" ),
array( "type" => "number", "label" => "emails_per_batch", "value" => "100", "order" => 4, "group" => "email", "subgroup" => "general" ),
array( "type" => "number", "label" => "delay_per_batch", "value" => "5", "order" => 5, "group" => "email", "subgroup" => "general" ),
array( "type" => "combo", "label" => "mail_type", "value" => "mail", "order" => 6, "group" => "email", "subgroup" => "general" ),
array( "type" => "combo", "label" => "html_emails", "value" => "1", "order" => 7, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "smtp_hostname", "value" => "", "order" => 8, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "smtp_port", "value" => "", "order" => 9, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "smtp_username", "value" => "", "order" => 10, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "smtp_password", "value" => "", "order" => 11, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "email_logo_path", "value" => "", "order" => 12, "group" => "email", "subgroup" => "general" ),
array( "type" => "text", "label" => "cron_sesshash", "value" => "very_secret_word", "order" => 1, "group" => "automation", "subgroup" => "general" ),
array( "type" => "text", "label" => "cron_notify_email", "value" => "", "order" => 2, "group" => "automation", "subgroup" => "general" ),
array( "type" => "number", "label" => "send_expiration_notify", "value" => "5", "order" => 3, "group" => "automation", "subgroup" => "general" ),
array( "type" => "number", "label" => "send_activation_notify", "value" => "3", "order" => 4, "group" => "automation", "subgroup" => "general" ),
array( "type" => "number", "label" => "remove_unactivated_accounts", "value" => "7", "order" => 5, "group" => "automation", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "send_birthday_wishes", "value" => "1", "order" => 6, "group" => "automation", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "send_daily_reports", "value" => "1", "order" => 7, "group" => "automation", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_private_messages", "value" => "1", "order" => 1, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_gifts", "value" => "1", "order" => 2, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_blog_comments", "value" => "1", "order" => 3, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_guestbook_comments", "value" => "1", "order" => 4, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_pictures_comments", "value" => "1", "order" => 5, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_videos_comments", "value" => "1", "order" => 6, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_notify_friends_requests", "value" => "1", "order" => 7, "group" => "notifications", "subgroup" => "general" ),
array( "type" => "custom", "label" => "language_id", "value" => "1", "order" => 1, "group" => "localization", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "override_language", "value" => "0", "order" => 2, "group" => "localization", "subgroup" => "general" ),
array( "type" => "custom", "label" => "timezone", "value" => "-300", "order" => 3, "group" => "localization", "subgroup" => "general" ),
array( "type" => "custom", "label" => "timeformat", "value" => "1", "order" => 4, "group" => "localization", "subgroup" => "general" ),
array( "type" => "custom", "label" => "template_id", "value" => "1", "order" => 1, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "override_template", "value" => "1", "order" => 2, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "combo", "label" => "cp_theme", "value" => "rainbow", "order" => 3, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "help_icons", "value" => "1", "order" => 4, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "combo", "label" => "help_icons_type", "value" => "1", "order" => 5, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "dashboard_newsfeed", "value" => "1", "order" => 6, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_poweredby_link", "value" => "1", "order" => 7, "group" => "looknfeel", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_audio", "value" => "1", "order" => 1, "group" => "audio", "subgroup" => "general" ),
array( "type" => "number", "label" => "max_audio_size", "value" => "6", "order" => 2, "group" => "audio", "subgroup" => "general" ),
array( "type" => "text", "label" => "audio_extensions", "value" => "mp3", "order" => 3, "group" => "audio", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownaudio_per_page", "value" => "6", "order" => 4, "group" => "audio", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_audio_rating", "value" => "1", "order" => 5, "group" => "audio", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_audio_reports", "value" => "1", "order" => 6, "group" => "audio", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_pictures", "value" => "1", "order" => 1, "group" => "image", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownpictures_per_page", "value" => "6", "order" => 2, "group" => "image", "subgroup" => "general" ),
array( "type" => "number", "label" => "pictures_per_page", "value" => "24", "order" => 3, "group" => "image", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "adult_images", "value" => "1", "order" => 4, "group" => "image", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_picture_rating", "value" => "1", "order" => 5, "group" => "image", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_picture_reports", "value" => "1", "order" => 6, "group" => "image", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_global_pictures_page", "value" => "1", "order" => 7, "group" => "image", "subgroup" => "general" ),
array( "type" => "number", "label" => "globalpictures_per_page", "value" => "24", "order" => 8, "group" => "image", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownalbums_per_page", "value" => "6", "order" => 1, "group" => "image", "subgroup" => "albums" ),
array( "type" => "number", "label" => "albums_per_page", "value" => "6", "order" => 2, "group" => "image", "subgroup" => "albums" ),
array( "type" => "boolean", "label" => "enable_password_albums", "value" => "1", "order" => 3, "group" => "image", "subgroup" => "albums" ),
array( "type" => "boolean", "label" => "enable_old_style_pictures", "value" => "0", "order" => 4, "group" => "image", "subgroup" => "albums" ),
array( "type" => "boolean", "label" => "resize_image", "value" => "1", "order" => 1, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "max_image_size", "value" => "1000", "order" => 2, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "min_image_width", "value" => "190", "order" => 3, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "min_image_height", "value" => "100", "order" => 4, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "image_width", "value" => "600", "order" => 5, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "image_height", "value" => "600", "order" => 6, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "thumbnails", "value" => "1", "order" => 1, "group" => "image", "subgroup" => "thumbnails" ),
array( "type" => "number", "label" => "thumbnail_width", "value" => "100", "order" => 2, "group" => "image", "subgroup" => "thumbnails" ),
array( "type" => "number", "label" => "thumbnail_height", "value" => "100", "order" => 3, "group" => "image", "subgroup" => "thumbnails" ),
array( "type" => "boolean", "label" => "cut_images", "value" => "1", "order" => 4, "group" => "image", "subgroup" => "thumbnails" ),
array( "type" => "boolean", "label" => "enable_picture_comments", "value" => "1", "order" => 1, "group" => "image", "subgroup" => "comments" ),
array( "type" => "number", "label" => "pictures_comment_max_length", "value" => "500", "order" => 2, "group" => "image", "subgroup" => "comments" ),
array( "type" => "number", "label" => "pictures_comments_per_page", "value" => "10", "order" => 3, "group" => "image", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "pictures_comments_captcha", "value" => "1", "order" => 4, "group" => "image", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_picture_comments_reports", "value" => "1", "order" => 5, "group" => "image", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_hotornot_page", "value" => "1", "order" => 1, "group" => "image", "subgroup" => "hotornot" ),
array( "type" => "textarea", "label" => "hotornot_fields", "value" => "members=gender,age,country", "order" => 2, "group" => "image", "subgroup" => "hotornot" ),
array( "type" => "number", "label" => "max_photo_size", "value" => "1000", "order" => 1, "group" => "photo", "subgroup" => "general" ),
array( "type" => "number", "label" => "min_photo_width", "value" => "100", "order" => 2, "group" => "photo", "subgroup" => "general" ),
array( "type" => "number", "label" => "min_photo_height", "value" => "100", "order" => 3, "group" => "photo", "subgroup" => "general" ),
array( "type" => "number", "label" => "thumbnail_photo_width", "value" => "100", "order" => 4, "group" => "photo", "subgroup" => "general" ),
array( "type" => "number", "label" => "thumbnail_photo_height", "value" => "100", "order" => 5, "group" => "photo", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "cut_photos", "value" => "1", "order" => 6, "group" => "photo", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_videos", "value" => "1", "order" => 1, "group" => "videos", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_videos_categories", "value" => "1", "order" => 2, "group" => "videos", "subgroup" => "general" ),
array( "type" => "number", "label" => "max_video_size", "value" => "30", "order" => 3, "group" => "videos", "subgroup" => "general" ),
array( "type" => "text", "label" => "video_extensions", "value" => "avi,mpg,mpeg,wmv,flv", "order" => 4, "group" => "videos", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownvideos_per_page", "value" => "6", "order" => 5, "group" => "videos", "subgroup" => "general" ),
array( "type" => "number", "label" => "videos_per_page", "value" => "24", "order" => 6, "group" => "videos", "subgroup" => "general" ),
array( "type" => "number", "label" => "video_width", "value" => "480", "order" => 7, "group" => "videos", "subgroup" => "general" ),
array( "type" => "number", "label" => "video_height", "value" => "360", "order" => 8, "group" => "videos", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "adult_videos", "value" => "1", "order" => 9, "group" => "videos", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_video_rating", "value" => "1", "order" => 10, "group" => "videos", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_video_reports", "value" => "1", "order" => 11, "group" => "videos", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_global_videos_page", "value" => "1", "order" => 12, "group" => "videos", "subgroup" => "general" ),
array( "type" => "number", "label" => "globalvideos_per_page", "value" => "24", "order" => 13, "group" => "videos", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_ffmpeg", "value" => "0", "order" => 1, "group" => "videos", "subgroup" => "ffmpeg" ),
array( "type" => "text", "label" => "ffmpeg_path", "value" => "/usr/local/bin/ffmpeg", "order" => 2, "group" => "videos", "subgroup" => "ffmpeg" ),
array( "type" => "boolean", "label" => "enable_encodercloud", "value" => "0", "order" => 1, "group" => "videos", "subgroup" => "encodercloud" ),
array( "type" => "boolean", "label" => "encodercloud_ssl", "value" => "0", "order" => 2, "group" => "videos", "subgroup" => "encodercloud" ),
array( "type" => "text", "label" => "encodercloud_api", "value" => "", "order" => 3, "group" => "videos", "subgroup" => "encodercloud" ),
array( "type" => "number", "label" => "encodercloud_profile", "value" => "0", "order" => 4, "group" => "videos", "subgroup" => "encodercloud" ),
array( "type" => "text", "label" => "encodercloud_download_path", "value" => "", "order" => 5, "group" => "videos", "subgroup" => "encodercloud" ),
array( "type" => "text", "label" => "encodercloud_upload_path", "value" => "", "order" => 6, "group" => "videos", "subgroup" => "encodercloud" ),
array( "type" => "boolean", "label" => "enable_video_comments", "value" => "1", "order" => 1, "group" => "videos", "subgroup" => "comments" ),
array( "type" => "number", "label" => "videos_comment_max_length", "value" => "500", "order" => 2, "group" => "videos", "subgroup" => "comments" ),
array( "type" => "number", "label" => "videos_comments_per_page", "value" => "10", "order" => 3, "group" => "videos", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "videos_comments_captcha", "value" => "1", "order" => 4, "group" => "videos", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_video_comments_reports", "value" => "1", "order" => 5, "group" => "videos", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_chat", "value" => "1", "order" => 1, "group" => "chat", "subgroup" => "general" ),
array( "type" => "number", "label" => "chat_check_sec", "value" => "5", "order" => 4, "group" => "chat", "subgroup" => "general" ),
array( "type" => "number", "label" => "chat_cleanup", "value" => "2", "order" => 5, "group" => "chat", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "chat_enable_smilies", "value" => "1", "order" => 7, "group" => "chat", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "chat_enable_sound", "value" => "1", "order" => 8, "group" => "chat", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_blogs", "value" => "1", "order" => 1, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "number", "label" => "blog_max_length", "value" => "15000", "order" => 2, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "number", "label" => "blogs_max_image_size", "value" => "1000", "order" => 3, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownblog_entries_per_page", "value" => "6", "order" => 4, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "number", "label" => "blog_entries_per_page", "value" => "6", "order" => 5, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_blog_reports", "value" => "1", "order" => 6, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_global_blogs_page", "value" => "1", "order" => 7, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "number", "label" => "globalblogs_entries_per_page", "value" => "10", "order" => 8, "group" => "blogs", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "blogs_resize_originals", "value" => "1", "order" => 1, "group" => "blogs", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "blogs_original_width", "value" => "600", "order" => 2, "group" => "blogs", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "blogs_original_height", "value" => "600", "order" => 3, "group" => "blogs", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "blogs_resize_thumbnails", "value" => "1", "order" => 4, "group" => "blogs", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "blogs_thumbnail_width", "value" => "100", "order" => 5, "group" => "blogs", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "blogs_thumbnail_height", "value" => "100", "order" => 6, "group" => "blogs", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "blog_comment_max_length", "value" => "500", "order" => 1, "group" => "blogs", "subgroup" => "comments" ),
array( "type" => "number", "label" => "blogs_comments_per_page", "value" => "10", "order" => 2, "group" => "blogs", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "blogs_comments_captcha", "value" => "1", "order" => 3, "group" => "blogs", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_blog_comments_reports", "value" => "1", "order" => 4, "group" => "blogs", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_blog_feed", "value" => "1", "order" => 1, "group" => "blogs", "subgroup" => "rss" ),
array( "type" => "number", "label" => "blog_entries_per_feed", "value" => "10", "order" => 2, "group" => "blogs", "subgroup" => "rss" ),
array( "type" => "boolean", "label" => "enable_guestbooks", "value" => "1", "order" => 1, "group" => "guestbooks", "subgroup" => "general" ),
array( "type" => "number", "label" => "guestbook_max_length", "value" => "500", "order" => 2, "group" => "guestbooks", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "guestbooks_captcha", "value" => "1", "order" => 3, "group" => "guestbooks", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownguestbook_entries_per_page", "value" => "6", "order" => 4, "group" => "guestbooks", "subgroup" => "general" ),
array( "type" => "number", "label" => "guestbook_entries_per_page", "value" => "6", "order" => 5, "group" => "guestbooks", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_guestbook_reports", "value" => "1", "order" => 6, "group" => "guestbooks", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_guestbook_feed", "value" => "1", "order" => 1, "group" => "guestbooks", "subgroup" => "rss" ),
array( "type" => "number", "label" => "guestbook_entries_per_feed", "value" => "15", "order" => 2, "group" => "guestbooks", "subgroup" => "rss" ),
array( "type" => "boolean", "label" => "enable_messaging", "value" => "1", "order" => 1, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "number", "label" => "max_message_chars", "value" => "750", "order" => 2, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_word_filter", "value" => "1", "order" => 3, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "textarea", "label" => "filtered_words", "value" => "word1\\nword2\\nword3", "order" => 4, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "text", "label" => "filtered_words_replacement", "value" => "****", "order" => 5, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "number", "label" => "messages_per_page", "value" => "15", "order" => 6, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_message_reports", "value" => "1", "order" => 7, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "pm_enable_smilies", "value" => "1", "order" => 8, "group" => "messaging", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_friends", "value" => "1", "order" => 1, "group" => "friends", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_gifts", "value" => "1", "order" => 1, "group" => "gifts", "subgroup" => "general" ),
array( "type" => "number", "label" => "own_gifts_per_page", "value" => "15", "order" => 2, "group" => "gifts", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_gifts_message", "value" => "1", "order" => 3, "group" => "gifts", "subgroup" => "general" ),
array( "type" => "number", "label" => "friends_request_expiration", "value" => "1", "order" => 2, "group" => "friends", "subgroup" => "general" ),
array( "type" => "number", "label" => "friends_per_page", "value" => "6", "order" => 3, "group" => "friends", "subgroup" => "general" ),
array( "type" => "number", "label" => "friends_online_threshold", "value" => "1", "order" => 4, "group" => "friends", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_favorites", "value" => "1", "order" => 1, "group" => "favorites", "subgroup" => "general" ),
array( "type" => "number", "label" => "favorites_per_page", "value" => "6", "order" => 2, "group" => "favorites", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_fans", "value" => "1", "order" => 3, "group" => "favorites", "subgroup" => "general" ),
array( "type" => "number", "label" => "favorites_online_threshold", "value" => "1", "order" => 4, "group" => "favorites", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_visitors", "value" => "1", "order" => 1, "group" => "visitors", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_unique_visitors", "value" => "1", "order" => 2, "group" => "visitors", "subgroup" => "general" ),
array( "type" => "number", "label" => "visitors_per_page", "value" => "6", "order" => 3, "group" => "visitors", "subgroup" => "general" ),
array( "type" => "number", "label" => "visitors_store_time", "value" => "24", "order" => 4, "group" => "visitors", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_blocked_members", "value" => "1", "order" => 1, "group" => "blocked", "subgroup" => "general" ),
array( "type" => "number", "label" => "blocked_per_page", "value" => "6", "order" => 2, "group" => "blocked", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_events", "value" => "1", "order" => 1, "group" => "events", "subgroup" => "general" ),
array( "type" => "number", "label" => "events_per_page", "value" => "6", "order" => 2, "group" => "events", "subgroup" => "general" ),
array( "type" => "number", "label" => "ownevents_per_page", "value" => "6", "order" => 3, "group" => "events", "subgroup" => "general" ),
array( "type" => "number", "label" => "calendar_events_per_day", "value" => "4", "order" => 4, "group" => "events", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "calendar_show_bdays", "value" => "1", "order" => 5, "group" => "events", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_event_max_guests", "value" => "1", "order" => 6, "group" => "events", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_event_name_search", "value" => "1", "order" => 7, "group" => "events", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_event_pictures", "value" => "1", "order" => 1, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_max_image_size", "value" => "1000", "order" => 2, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_min_image_width", "value" => "100", "order" => 3, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_min_image_height", "value" => "100", "order" => 4, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "events_resize_image", "value" => "1", "order" => 5, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_image_width", "value" => "600", "order" => 6, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_image_height", "value" => "600", "order" => 7, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_ownpictures_per_page", "value" => "6", "order" => 9, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "events_pictures_per_page", "value" => "24", "order" => 10, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "events_thumbnails", "value" => "1", "order" => 1, "group" => "events", "subgroup" => "thumbnails" ),
array( "type" => "number", "label" => "events_thumbnail_width", "value" => "100", "order" => 2, "group" => "events", "subgroup" => "thumbnails" ),
array( "type" => "number", "label" => "events_thumbnail_height", "value" => "100", "order" => 3, "group" => "events", "subgroup" => "thumbnails" ),
array( "type" => "boolean", "label" => "events_cut_images", "value" => "1", "order" => 4, "group" => "events", "subgroup" => "thumbnails" ),
array( "type" => "boolean", "label" => "enable_event_comments", "value" => "1", "order" => 1, "group" => "events", "subgroup" => "comments" ),
array( "type" => "number", "label" => "events_comment_max_length", "value" => "500", "order" => 2, "group" => "events", "subgroup" => "comments" ),
array( "type" => "number", "label" => "events_comments_per_page", "value" => "10", "order" => 3, "group" => "events", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "events_comments_captcha", "value" => "1", "order" => 4, "group" => "events", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_events_feed", "value" => "1", "order" => 1, "group" => "events", "subgroup" => "rss" ),
array( "type" => "number", "label" => "events_per_feed", "value" => "15", "order" => 2, "group" => "events", "subgroup" => "rss" ),
array( "type" => "boolean", "label" => "show_online", "value" => "1", "order" => 1, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_profile_reports", "value" => "1", "order" => 2, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_member_rating", "value" => "1", "order" => 3, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "deactivate_on_update", "value" => "0", "order" => 4, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_flash_uploader", "value" => "1", "order" => 5, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_bbcode", "value" => "1", "order" => 1, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_pms", "value" => "1", "order" => 2, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_blogs", "value" => "1", "order" => 3, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_albums", "value" => "1", "order" => 4, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_pictures", "value" => "1", "order" => 5, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_videos", "value" => "1", "order" => 6, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_comments", "value" => "1", "order" => 7, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_customfields", "value" => "1", "order" => 8, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_guestbooks", "value" => "1", "order" => 9, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "bbcode_autolinking", "value" => "1", "order" => 10, "group" => "bbcode", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "is_news", "value" => "1", "order" => 1, "group" => "news", "subgroup" => "general" ),
array( "type" => "number", "label" => "news_per_page", "value" => "6", "order" => 2, "group" => "news", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_news_comments", "value" => "1", "order" => 1, "group" => "news", "subgroup" => "comments" ),
array( "type" => "number", "label" => "news_comment_max_length", "value" => "500", "order" => 2, "group" => "news", "subgroup" => "comments" ),
array( "type" => "number", "label" => "news_comments_per_page", "value" => "10", "order" => 3, "group" => "news", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "news_comments_captcha", "value" => "1", "order" => 4, "group" => "news", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "enable_news_comments_reports", "value" => "1", "order" => 5, "group" => "news", "subgroup" => "comments" ),
array( "type" => "number", "label" => "news_max_image_size", "value" => "1000", "order" => 1, "group" => "news", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "news_image_width", "value" => "100", "order" => 2, "group" => "news", "subgroup" => "pictures" ),
array( "type" => "number", "label" => "news_image_height", "value" => "100", "order" => 3, "group" => "news", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "news_image_cut", "value" => "1", "order" => 4, "group" => "news", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "enable_news_feed", "value" => "1", "order" => 1, "group" => "news", "subgroup" => "rss" ),
array( "type" => "number", "label" => "news_per_feed", "value" => "15", "order" => 2, "group" => "news", "subgroup" => "rss" ),
array( "type" => "boolean", "label" => "enable_polls", "value" => "1", "order" => 1, "group" => "polls", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "polls_guests_access", "value" => "1", "order" => 2, "group" => "polls", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "polls_display_results", "value" => "1", "order" => 3, "group" => "polls", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_reports", "value" => "1", "order" => 1, "group" => "reports", "subgroup" => "general" ),
array( "type" => "textarea", "label" => "reports_items", "value" => "Sexually explicit\\nMature content\\nTerms of use violation\\nGraphic violence\\nHate speech", "order" => 2, "group" => "reports", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_saved_searches", "value" => "1", "order" => 1, "group" => "search", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "search_username", "value" => "0", "order" => 2, "group" => "search", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "search_online", "value" => "1", "order" => 3, "group" => "search", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "search_uszip", "value" => "0", "order" => 4, "group" => "search", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_matchmaker", "value" => "1", "order" => 5, "group" => "search", "subgroup" => "general" ),
array( "type" => "number", "label" => "profiles_per_page", "value" => "6", "order" => 6, "group" => "search", "subgroup" => "general" ),
array( "type" => "number", "label" => "profiles_per_gallery", "value" => "24", "order" => 7, "group" => "search", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_search_feed", "value" => "1", "order" => 1, "group" => "search", "subgroup" => "rss" ),
array( "type" => "number", "label" => "profiles_per_feed", "value" => "10", "order" => 2, "group" => "search", "subgroup" => "rss" ),
array( "type" => "boolean", "label" => "enable_feedback", "value" => "1", "order" => 1, "group" => "feedback", "subgroup" => "general" ),
array( "type" => "email", "label" => "feedback_email", "value" => "email@website.com", "order" => 2, "group" => "feedback", "subgroup" => "general" ),
array( "type" => "textarea", "label" => "feedback_subjects", "value" => "Suggestions\\nAdvertising\\nReport abuse\\nSuccess story\\nTechnical issue\\nOther question", "order" => 3, "group" => "feedback", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "feedback_captcha", "value" => "1", "order" => 4, "group" => "feedback", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_openinviter", "value" => "0", "order" => 1, "group" => "tellfriend", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_tellfriend", "value" => "1", "order" => 2, "group" => "tellfriend", "subgroup" => "general" ),
array( "type" => "number", "label" => "tellfriend_friends", "value" => "3", "order" => 3, "group" => "tellfriend", "subgroup" => "general" ),
array( "type" => "text", "label" => "tell_friend_subj", "value" => "Check this website out", "order" => 4, "group" => "tellfriend", "subgroup" => "general" ),
array( "type" => "textarea", "label" => "tell_friend_body", "value" => "Hey {name},\\n\\nCheck out this website I found:\\n{referral_link}\\n\\nCheers", "order" => 5, "group" => "tellfriend", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "tellfriend_captcha", "value" => "1", "order" => 6, "group" => "tellfriend", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_page_comments", "value" => "1", "order" => 1, "group" => "pages", "subgroup" => "comments" ),
array( "type" => "number", "label" => "pages_comment_max_length", "value" => "500", "order" => 2, "group" => "pages", "subgroup" => "comments" ),
array( "type" => "number", "label" => "pages_comments_per_page", "value" => "10", "order" => 3, "group" => "pages", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "pages_comments_captcha", "value" => "1", "order" => 4, "group" => "pages", "subgroup" => "comments" ),
array( "type" => "boolean", "label" => "module_phpbb2_enabled", "value" => "0", "order" => 1, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb2_path", "value" => "forum/", "order" => 2, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb2_table_prefix", "value" => "phpbb_", "order" => 4, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb2_host", "value" => "", "order" => 5, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb2_db", "value" => "", "order" => 6, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb2_user", "value" => "", "order" => 7, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb2_pass", "value" => "", "order" => 8, "group" => "module_phpbb2", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "module_phpbb3_enabled", "value" => "0", "order" => 1, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb3_path", "value" => "forum/", "order" => 2, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb3_table_prefix", "value" => "phpbb_", "order" => 4, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb3_host", "value" => "", "order" => 5, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb3_db", "value" => "", "order" => 6, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb3_user", "value" => "", "order" => 7, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_phpbb3_pass", "value" => "", "order" => 8, "group" => "module_phpbb3", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "module_punbb_enabled", "value" => "0", "order" => 1, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_punbb_path", "value" => "forum/", "order" => 2, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_punbb_table_prefix", "value" => "punbb_", "order" => 4, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_punbb_host", "value" => "", "order" => 5, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_punbb_db", "value" => "", "order" => 6, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_punbb_user", "value" => "", "order" => 7, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_punbb_pass", "value" => "", "order" => 8, "group" => "module_punbb", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "module_vbulletin3_enabled", "value" => "0", "order" => 1, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vbulletin3_path", "value" => "forum/", "order" => 2, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vbulletin3_table_prefix", "value" => "vb3_", "order" => 4, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vbulletin3_host", "value" => "", "order" => 5, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vbulletin3_db", "value" => "", "order" => 6, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vbulletin3_user", "value" => "", "order" => 7, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vbulletin3_pass", "value" => "", "order" => 8, "group" => "module_vbulletin3", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "module_vanilla_enabled", "value" => "0", "order" => 1, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vanilla_path", "value" => "forum/", "order" => 2, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vanilla_table_prefix", "value" => "f_", "order" => 4, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vanilla_host", "value" => "", "order" => 5, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vanilla_db", "value" => "", "order" => 6, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vanilla_user", "value" => "", "order" => 7, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "text", "label" => "module_vanilla_pass", "value" => "", "order" => 8, "group" => "module_vanilla", "subgroup" => "general" ),
array( "type" => "system", "label" => "app_version", "value" => "2.6", "order" => 0, "group" => "system", "subgroup" => "system" ),
array( "type" => "system", "label" => "cron_lastrun", "value" => "", "order" => 0, "group" => "system", "subgroup" => "system" )
);
$var_25 = array(
array( "group_id" => "general", "label" => "general", "order" => 1 ),
array( "group_id" => "security", "label" => "general", "order" => 1 ),
array( "group_id" => "security", "label" => "banned", "order" => 2 ),
array( "group_id" => "registration", "label" => "general", "order" => 1 ),
array( "group_id" => "registration", "label" => "notifications", "order" => 2 ),
array( "group_id" => "registration", "label" => "defaults", "order" => 3 ),
array( "group_id" => "registration", "label" => "groups", "order" => 4 ),
array( "group_id" => "registration", "label" => "trials", "order" => 5 ),
array( "group_id" => "registration", "label" => "welcome", "order" => 6 ),
array( "group_id" => "email", "label" => "general", "order" => 1 ),
array( "group_id" => "automation", "label" => "general", "order" => 1 ),
array( "group_id" => "notifications", "label" => "general", "order" => 1 ),
array( "group_id" => "localization", "label" => "general", "order" => 1 ),
array( "group_id" => "looknfeel", "label" => "general", "order" => 1 ),
array( "group_id" => "audio", "label" => "general", "order" => 1 ),
array( "group_id" => "image", "label" => "general", "order" => 1 ),
array( "group_id" => "image", "label" => "albums", "order" => 2 ),
array( "group_id" => "image", "label" => "pictures", "order" => 3 ),
array( "group_id" => "image", "label" => "thumbnails", "order" => 4 ),
array( "group_id" => "image", "label" => "comments", "order" => 5 ),
array( "group_id" => "image", "label" => "hotornot", "order" => 6 ),
array( "group_id" => "photo", "label" => "general", "order" => 1 ),
array( "group_id" => "videos", "label" => "general", "order" => 1 ),
array( "group_id" => "videos", "label" => "ffmpeg", "order" => 2 ),
array( "group_id" => "videos", "label" => "encodercloud", "order" => 3 ),
array( "group_id" => "videos", "label" => "comments", "order" => 4 ),
array( "group_id" => "chat", "label" => "general", "order" => 1 ),
array( "group_id" => "blogs", "label" => "general", "order" => 1 ),
array( "group_id" => "blogs", "label" => "pictures", "order" => 2 ),
array( "group_id" => "blogs", "label" => "comments", "order" => 3 ),
array( "group_id" => "blogs", "label" => "rss", "order" => 4 ),
array( "group_id" => "guestbooks", "label" => "general", "order" => 1 ),
array( "group_id" => "guestbooks", "label" => "rss", "order" => 2 ),
array( "group_id" => "messaging", "label" => "general", "order" => 1 ),
array( "group_id" => "friends", "label" => "general", "order" => 1 ),
array( "group_id" => "favorites", "label" => "general", "order" => 1 ),
array( "group_id" => "visitors", "label" => "general", "order" => 1 ),
array( "group_id" => "blocked", "label" => "general", "order" => 1 ),
array( "group_id" => "events", "label" => "general", "order" => 1 ),
array( "group_id" => "events", "label" => "pictures", "order" => 2 ),
array( "group_id" => "events", "label" => "thumbnails", "order" => 3 ),
array( "group_id" => "events", "label" => "comments", "order" => 4 ),
array( "group_id" => "events", "label" => "rss", "order" => 5 ),
array( "group_id" => "profiles", "label" => "general", "order" => 1 ),
array( "group_id" => "news", "label" => "general", "order" => 1 ),
array( "group_id" => "news", "label" => "comments", "order" => 2 ),
array( "group_id" => "news", "label" => "pictures", "order" => 3 ),
array( "group_id" => "news", "label" => "rss", "order" => 4 ),
array( "group_id" => "polls", "label" => "general", "order" => 1 ),
array( "group_id" => "reports", "label" => "general", "order" => 1 ),
array( "group_id" => "search", "label" => "general", "order" => 1 ),
array( "group_id" => "search", "label" => "rss", "order" => 2 ),
array( "group_id" => "feedback", "label" => "general", "order" => 1 ),
array( "group_id" => "tellfriend", "label" => "general", "order" => 1 ),
array( "group_id" => "module_phpbb2", "label" => "general", "order" => 1 ),
array( "group_id" => "module_phpbb3", "label" => "general", "order" => 1 ),
array( "group_id" => "module_punbb", "label" => "general", "order" => 1 ),
array( "group_id" => "module_vbulletin3", "label" => "general", "order" => 1 ),
array( "group_id" => "module_vanilla", "label" => "general", "order" => 1 ),
array( "group_id" => "pages", "label" => "comments", "order" => 1 ),
array( "group_id" => "bbcode", "label" => "general", "order" => 1 ),
array( "group_id" => "gifts", "label" => "general", "order" => 1 )
);
$var_26 = array( "general" => 1, "security" => 2, "registration" => 3, "email" => 6, "automation" => 7, "notifications" => 8, "localization" => 9, "looknfeel" => 10, "audio" => 30, "image" => 31, "photo" => 32, "videos" => 33, "chat" => 34, "blogs" => 35, "guestbooks" => 36, "messaging" => 37, "gifts" => 38, "friends" => 39, "favorites" => 40, "visitors" => 41, "blocked" => 42, "events" => 43, "profiles" => 44, "bbcode" => 45, "news" => 60, "polls" => 62, "reports" => 63, "search" => 64, "feedback" => 65, "tellfriend" => 66, "pages" => 67, "module_phpbb2" => 90, "module_phpbb3" => 91, "module_punbb" => 92, "module_vbulletin3" => 93, "module_vanilla" => 94 );
foreach ($var_24 as $var_27)
{
$DB->query( "insert into `".$_SESSION['db_prefix']."settings` (`type`,`label`,`val`,`orderid`,`group_id`,`subgroup_id`) values ('".$var_27['type']."','".$var_27['label']."','".str_replace( "\\\\n", "\\n", mysql_real_escape_string( $var_27['value'] ) )."',".$var_27['order'].",'".$var_27['group']."','".$var_27['subgroup']."')" );
}
foreach ($var_25 as $var_28)
{
$DB->query( "insert into `".$_SESSION['db_prefix']."settings_subgroups` (`group_id`,`label`,`orderid`) values ('".$var_28['group_id']."','".$var_28['label']."',".$var_28['order'].")" );
}
foreach ($var_26 as $var_29 => $var_30)
{
$DB->query( "insert into `".$_SESSION['db_prefix']."settings_groups`(`label`,`orderid`) values ('$var_30','$var_30')" );
}
$var_24 = array(
array( "type" => "boolean", "label" => "enable_upgrades", "value" => "1", "order" => 6, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_credits", "value" => "1", "order" => 7, "group" => "profiles", "subgroup" => "general" ),
array( "type" => "number", "label" => "trial_member_credits", "value" => "0", "order" => 3, "group" => "registration", "subgroup" => "trials" ),
array( "type" => "boolean", "label" => "enable_referals", "value" => "1", "order" => 1, "group" => "referals", "subgroup" => "general" ),
array( "type" => "number", "label" => "referals_upgrade_members", "value" => "10", "order" => 2, "group" => "referals", "subgroup" => "general" ),
array( "type" => "custom", "label" => "referals_member_group", "value" => "5", "order" => 3, "group" => "referals", "subgroup" => "general" ),
array( "type" => "number", "label" => "referals_upgrade_length", "value" => "30", "order" => 4, "group" => "referals", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "enable_banners", "value" => "1", "order" => 1, "group" => "banners", "subgroup" => "general" ),
array( "type" => "boolean", "label" => "events_enable_sm_watermark", "value" => "1", "order" => 5, "group" => "events", "subgroup" => "thumbnails" ),
array( "type" => "boolean", "label" => "events_enable_lg_watermark", "value" => "1", "order" => 8, "group" => "events", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "enable_sm_watermark", "value" => "1", "order" => 5, "group" => "image", "subgroup" => "thumbnails" ),
array( "type" => "boolean", "label" => "enable_lg_watermark", "value" => "1", "order" => 7, "group" => "image", "subgroup" => "pictures" ),
array( "type" => "boolean", "label" => "enable_photo_watermark", "value" => "1", "order" => 7, "group" => "photo", "subgroup" => "general" )
);
$var_25 = array (array ('group_id' => 'referals', 'label' => 'general', 'order' => 1), array ('group_id' => 'upgrades', 'label' => 'general', 'order' => 1), array ('group_id' => 'banners', 'label' => 'general', 'order' => 1));
$var_26 = array ('referals' => 4, 'upgrades' => 5, 'banners' => 61);
foreach ($var_24 as $var_27)
{
$DB->query ('insert into `' . $_SESSION['db_prefix'] . 'settings` (`type`,`label`,`val`,`orderid`,`group_id`,`subgroup_id`) values (\'' . $var_27['type'] . '\',\'' . $var_27['label'] . '\',\'' . str_replace ('\\\\n', '\\n', mysql_real_escape_string ($var_27['value'])) . '\',' . $var_27['order'] . ',\'' . $var_27['group'] . '\',\'' . $var_27['subgroup'] . '\')');
}
foreach ($var_25 as $var_28)
{
$DB->query ('insert into `' . $_SESSION['db_prefix'] . 'settings_subgroups` (`group_id`,`label`,`orderid`) values (\'' . $var_28['group_id'] . '\',\'' . $var_28['label'] . '\',' . $var_28['order'] . ')');
}
foreach ($var_26 as $var_29 => $var_30)
{
$DB->query ('insert into `' . $_SESSION['db_prefix'] . ('' . 'settings_groups`(`label`,`orderid`) values (\'' . $var_29 . '\',\'' . $var_30 . '\')'));
}
if ( mysql_errno() )
{
return mysql_error( );
}
return 0;
}
session_start( );
if ( PHP_VERSION < 5.3 )
{
@set_magic_quotes_runtime( 0 );
}
if ( function_exists( "set_time_limit" ) == 1 && ini_get( "safe_mode" ) == 0 )
{
@set_time_limit( 0 );
}
define( "SYS_PATH", str_replace( "\\", "/", dirname( realpath( "install.php" ) ) )."/" );
$_SESSION['license'] = isset( $_SESSION['license'] ) && $_SESSION['license'] ? $_SESSION['license'] : "";
$_SESSION['sys_path'] = isset( $_SESSION['sys_path'] ) && $_SESSION['sys_path'] ? $_SESSION['sys_path'] : str_replace( "\\", "/", dirname( realpath( "install.php" ) ) );
$_SESSION['vir_path'] = isset( $_SESSION['vir_path'] ) && $_SESSION['vir_path'] ? $_SESSION['vir_path'] : "http://".$_SERVER['HTTP_HOST'].str_replace( "\\", "/", dirname( $_SERVER['PHP_SELF'] ) );
$_SESSION['sys_path'] .= substr( $_SESSION['sys_path'], 0 - 1 ) != "/" ? "/" : "";
$_SESSION['vir_path'] .= substr( $_SESSION['vir_path'], 0 - 1 ) != "/" ? "/" : "";
$_SESSION['sys_pic_path'] = isset( $_SESSION['sys_pic_path'] ) && $_SESSION['sys_pic_path'] ? $_SESSION['sys_pic_path'] : $_SESSION['sys_path']."media/uploads/";
$_SESSION['vir_pic_path'] = isset( $_SESSION['vir_pic_path'] ) && $_SESSION['vir_pic_path'] ? $_SESSION['vir_pic_path'] : $_SESSION['vir_path']."media/uploads/";
$_SESSION['sys_tpl_path'] = isset( $_SESSION['sys_tpl_path'] ) && $_SESSION['sys_tpl_path'] ? $_SESSION['sys_tpl_path'] : $_SESSION['sys_path']."templates/";
$_SESSION['vir_tpl_path'] = isset( $_SESSION['vir_tpl_path'] ) && $_SESSION['vir_tpl_path'] ? $_SESSION['vir_tpl_path'] : $_SESSION['vir_path']."templates/";
$_SESSION['vir_cp_path'] = isset( $_SESSION['vir_cp_path'] ) && $_SESSION['vir_cp_path'] ? $_SESSION['vir_cp_path'] : $_SESSION['vir_path']."cp/";
$_SESSION['sys_pic_path'] .= substr( $_SESSION['sys_pic_path'], 0 - 1 ) != "/" ? "/" : "";
$_SESSION['vir_pic_path'] .= substr( $_SESSION['vir_pic_path'], 0 - 1 ) != "/" ? "/" : "";
$_SESSION['sys_tpl_path'] .= substr( $_SESSION['sys_tpl_path'], 0 - 1 ) != "/" ? "/" : "";
$_SESSION['vir_tpl_path'] .= substr( $_SESSION['vir_tpl_path'], 0 - 1 ) != "/" ? "/" : "";
$_SESSION['vir_cp_path'] .= substr( $_SESSION['vir_cp_path'], 0 - 1 ) != "/" ? "/" : "";
define( "VIR_PATH", $_SESSION['vir_path'] );
define( "VIR_CP_PATH", $_SESSION['vir_cp_path'] );
define( "SYS_LICENSE", $_SESSION['license'] );
$_SESSION['db_hostname'] = isset( $_SESSION['db_hostname'] ) && $_SESSION['db_hostname'] ? $_SESSION['db_hostname'] : "localhost";
$_SESSION['db_database'] = isset( $_SESSION['db_database'] ) && $_SESSION['db_database'] ? $_SESSION['db_database'] : "vldpersonals";
$_SESSION['db_username'] = isset( $_SESSION['db_username'] ) && $_SESSION['db_username'] ? $_SESSION['db_username'] : "root";
$_SESSION['db_password'] = isset( $_SESSION['db_password'] ) && $_SESSION['db_password'] ? $_SESSION['db_password'] : "";
$_SESSION['db_prefix'] = isset( $_SESSION['db_prefix'] ) && $_SESSION['db_prefix'] ? $_SESSION['db_prefix'] : "vld_";
$_SESSION['db_version'] = isset( $_SESSION['db_version'] ) && $_SESSION['db_version'] ? $_SESSION['db_version'] : "";
$_SESSION['username'] = isset( $_SESSION['username'] ) && $_SESSION['username'] ? $_SESSION['username'] : "";
$_SESSION['password'] = isset( $_SESSION['password'] ) && $_SESSION['password'] ? $_SESSION['password'] : "";
$_SESSION['password2'] = isset( $_SESSION['password2'] ) && $_SESSION['password2'] ? $_SESSION['password2'] : "";
$_SESSION['email'] = isset( $_SESSION['email'] ) && $_SESSION['email'] ? $_SESSION['email'] : "";
$conf = array( "db_hostname" => "", "db_username" => "", "db_password" => "", "db_name" => "", "db_prefix" => "", "debug" => 0 );
require( SYS_PATH."includes/core/core.mysql.php" );
include( SYS_PATH."includes/core/core.cache.php" );
require( SYS_PATH."includes/fns/fns.misc.php" );
require( SYS_PATH."includes/fns/fns.validate.php" );
if ( @is_file( SYS_PATH."includes/config.php" ) && 0 < filesize( SYS_PATH."includes/config.php" ) && ( !isset( $_GET['p'] ) || isset( $_GET['p'] ) && $_GET['p'] != "step6" ) )
{
exit( "There already appears to be an installed instance of vldPersonals.<br/><br/>If you absolutely want to install or reinstall this program you must locate the file called <b>config.php</b> and delete its contents." );
}
else
{
$p = isset( $_GET['p'] ) ? trim( $_GET['p'] ) : "";
switch ( $p )
{
case "step2" :
show_step2( );
break;
case "step3" :
show_step3( );
break;
case "step4" :
show_step4( );
break;
case "step5" :
show_step5( );
break;
case "step6" :
}
show_step6( );
break;
show_step1( );
break;
}
if ( $DB->conn_id )
{
$DB->disconnect_db( );
}
?>
6th July 2011, 23:15
hove to resolve pharse error ?
