[mxbb-commits] mx_phpCA adverts.php, 1.2, 1.3 db_install.php, 1.2, 1.3 db_uninstall.php, 1.2, 1.3 db_upgrade.php, 1.2, 1.3

[OryNider <ory...@us...>]

Update of /cvsroot/mxbb/mx_phpCA
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21483/mx_phpCA

Modified Files:
	adverts.php db_install.php db_uninstall.php db_upgrade.php 
Log Message:
cvs commit test

Index: db_uninstall.php
===================================================================
RCS file: /cvsroot/mxbb/mx_phpCA/db_uninstall.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** db_uninstall.php	8 Feb 2008 23:42:47 -0000	1.2
--- db_uninstall.php	28 Feb 2008 06:26:23 -0000	1.3
***************
*** 13,17 ****
  {
    $mx_root_path = '../../';
!   $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($mx_root_path . 'common.'.$phpEx);
  
--- 13,17 ----
  {
    $mx_root_path = '../../';
!   $phpEx = substr(strrchr(__FILE__, '.'), 1); 
    include($mx_root_path . 'common.'.$phpEx);
  
***************
*** 71,73 ****
  echo '<tr><td class="row1"  align="center"><span class="gen">' . $message . '</span></td></tr>';
  echo '</table>&nbsp;<br />';
! ?>
\ No newline at end of file
--- 71,73 ----
  echo '<tr><td class="row1"  align="center"><span class="gen">' . $message . '</span></td></tr>';
  echo '</table>&nbsp;<br />';
! ?>

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_phpCA/db_upgrade.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** db_upgrade.php	8 Feb 2008 23:42:47 -0000	1.2
--- db_upgrade.php	28 Feb 2008 06:26:23 -0000	1.3
***************
*** 93,95 ****
  echo "</table><br />";
  
! ?>
\ No newline at end of file
--- 93,95 ----
  echo "</table><br />";
  
! ?>

Index: adverts.php
===================================================================
RCS file: /cvsroot/mxbb/mx_phpCA/adverts.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** adverts.php	28 Jan 2008 21:58:51 -0000	1.2
--- adverts.php	28 Feb 2008 06:26:22 -0000	1.3
***************
*** 1,3 ****
! <?
  /**
  *
--- 1,3 ----
! <?php
  /**
  *
***************
*** 26,30 ****
  	// Start session management
  	//
! 	$mx_user->init($user_ip, PAGE_INDEX);
  	//
  	// End session management
--- 26,30 ----
  	// Start session management
  	//
! 	$mx_user->init($user_ip, PAGE_INDEX); 
  	//
  	// End session management
***************
*** 57,63 ****
  	if( is_object($mx_block))
  	{
! 		$is_block = TRUE;
  	}
! 
    	global $images, $mx_images, $postrow;
  }
--- 57,63 ----
  	if( is_object($mx_block))
  	{
! 		$is_block = TRUE;	
  	}
!   
    	global $images, $mx_images, $postrow;
  }
***************
*** 154,158 ****
  	{
  		mx_redirect(append_sid($mx_root_path . "login.php?redirect=" . this_mo_loginurl(), true));
! 	}
  	else
  	{
--- 154,158 ----
  	{
  		mx_redirect(append_sid($mx_root_path . "login.php?redirect=" . this_mo_loginurl(), true));
! 	}	
  	else
  	{
***************
*** 203,211 ****
  }
  
! $template->set_filenames(array('adverts_page' => 'adverts.tpl'));
  
  // SQL for adverts table
! $sql = "SELECT category, sub_category, COUNT(sub_category) AS number
! 		FROM ". ADS_ADVERTS_TABLE ."
  		WHERE expiry_date > $current_time
  		GROUP BY category, sub_category";
--- 203,211 ----
  }
  
! $template->set_filenames(array('adverts_page' => 'adverts.tpl')); 
  
  // SQL for adverts table
! $sql = "SELECT category, sub_category, COUNT(sub_category) AS number 
! 		FROM ". ADS_ADVERTS_TABLE ." 
  		WHERE expiry_date > $current_time
  		GROUP BY category, sub_category";
***************
*** 213,222 ****
  $result = $db->sql_query($sql);
  
! while ($row = $db->sql_fetchrow($result))
  {
  	$sub_category_ar[$row['category'].'_'.$row['sub_category']] = $row['number'];
  }
  
! $sql = 'SELECT *
  		FROM '. ADS_CATEGORIES_TABLE .'
  		ORDER BY cat_category, cat_sub_category ASC';
--- 213,222 ----
  $result = $db->sql_query($sql);
  
! while ($row = $db->sql_fetchrow($result)) 
  {
  	$sub_category_ar[$row['category'].'_'.$row['sub_category']] = $row['number'];
  }
  
! $sql = 'SELECT * 
  		FROM '. ADS_CATEGORIES_TABLE .'
  		ORDER BY cat_category, cat_sub_category ASC';
***************
*** 225,229 ****
  
  
! while ($row = $db->sql_fetchrow($result))
  {
  	$category = $row['cat_category'];
--- 225,229 ----
  
  
! while ($row = $db->sql_fetchrow($result)) 
  {
  	$category = $row['cat_category'];
***************
*** 246,254 ****
  			'CAT_IMG' => $cat_img,
  			'CATEGORY' => "<b><a href='$category_url'>$category</a></b><br>"
! 		));
  		$save_category = $category;
  	}
  
! 	$sub_category_temp = "<a href='".append_sid(this_ads_mxurl("ads_mode=ads_index&category=$u_category&sub_category=$u_sub_category"))."'>$sub_category</a>";
  	$sub_category_img = $mx_images['folder'];
  
--- 246,254 ----
  			'CAT_IMG' => $cat_img,
  			'CATEGORY' => "<b><a href='$category_url'>$category</a></b><br>"
! 		)); 
  		$save_category = $category;
  	}
  
! 	$sub_category_temp = "<a href='".append_sid(this_ads_mxurl("ads_mode=ads_index&category=$u_category&sub_category=$u_sub_category"))."'>$sub_category</a>"; 
  	$sub_category_img = $mx_images['folder'];
  
***************
*** 266,270 ****
  
  /*
! while ($row = $db->sql_fetchrow($result))
  {
  	$category = $row['cat_category'];
--- 266,270 ----
  
  /*
! while ($row = $db->sql_fetchrow($result)) 
  {
  	$category = $row['cat_category'];
***************
*** 278,286 ****
  	{
  		$category_url = append_sid("adverts.$phpEx?category=$u_category");
! 		$template->assign_block_vars('categoryrow', array('CATEGORY' => "<b><a href='$category_url'>$category</a></b><br>"));
  		$save_category = $category;
  	}
  
! 	$sub_category_temp = "<a href='".append_sid("adverts.$phpEx?category=$u_category&sub_category=$u_sub_category")."'>$sub_category</a>";
  
  	if ( $sub_category_ar[$save_category.'_'.$sub_category] )
--- 278,286 ----
  	{
  		$category_url = append_sid("adverts.$phpEx?category=$u_category");
! 		$template->assign_block_vars('categoryrow', array('CATEGORY' => "<b><a href='$category_url'>$category</a></b><br>")); 
  		$save_category = $category;
  	}
  
! 	$sub_category_temp = "<a href='".append_sid("adverts.$phpEx?category=$u_category&sub_category=$u_sub_category")."'>$sub_category</a>"; 
  
  	if ( $sub_category_ar[$save_category.'_'.$sub_category] )
***************
*** 302,311 ****
  	$start = 0;
  }
! 
  // Get the total number of ads
  if ( !empty($inp_category) && !empty($inp_sub_category) )
  {
! 	$sql = "SELECT *
! 		FROM ". ADS_ADVERTS_TABLE ."
  		WHERE expiry_date > $current_time
  		AND category = '$inp_category'
--- 302,311 ----
  	$start = 0;
  }
! 	
  // Get the total number of ads
  if ( !empty($inp_category) && !empty($inp_sub_category) )
  {
! 	$sql = "SELECT * 
! 		FROM ". ADS_ADVERTS_TABLE ." 
  		WHERE expiry_date > $current_time
  		AND category = '$inp_category'
***************
*** 314,324 ****
  else if ( !empty($inp_category) )
  {
! 	$sql = "SELECT *
! 		FROM ". ADS_ADVERTS_TABLE ."
  		WHERE expiry_date > $current_time
  		AND category = '$inp_category'";}
! else
  {
! 	$sql = "SELECT *
  		FROM ". ADS_ADVERTS_TABLE ."
  		WHERE expiry_date > $current_time";
--- 314,324 ----
  else if ( !empty($inp_category) )
  {
! 	$sql = "SELECT * 
! 		FROM ". ADS_ADVERTS_TABLE ." 
  		WHERE expiry_date > $current_time
  		AND category = '$inp_category'";}
! else	
  {
! 	$sql = "SELECT * 
  		FROM ". ADS_ADVERTS_TABLE ."
  		WHERE expiry_date > $current_time";
***************
*** 331,338 ****
  if ( $inp_category and $inp_sub_category )
  {
! 	$sql = "SELECT *
! 			FROM ". ADS_ADVERTS_TABLE ."
! 			WHERE category = '$inp_category'
! 			AND sub_category = '$inp_sub_category'
  			AND expiry_date > $current_time
  			ORDER BY premium_ad_ind DESC, id DESC
--- 331,338 ----
  if ( $inp_category and $inp_sub_category )
  {
! 	$sql = "SELECT * 
! 			FROM ". ADS_ADVERTS_TABLE ." 
! 			WHERE category = '$inp_category' 
! 			AND sub_category = '$inp_sub_category' 
  			AND expiry_date > $current_time
  			ORDER BY premium_ad_ind DESC, id DESC
***************
*** 342,356 ****
  if ( $inp_category )
  {
! 	$sql = "SELECT *
! 			FROM ". ADS_ADVERTS_TABLE ."
! 			WHERE category = '$inp_category'
  			AND expiry_date > $current_time
  			ORDER BY premium_ad_ind DESC, id DESC
  			LIMIT ".$start.", ".$ads_config['ads_per_page'];
  }
! else
  {
! 	$sql = "SELECT *
! 			FROM ". ADS_ADVERTS_TABLE ."
  			WHERE expiry_date > $current_time
  			ORDER BY premium_ad_ind DESC, id DESC
--- 342,356 ----
  if ( $inp_category )
  {
! 	$sql = "SELECT * 
! 			FROM ". ADS_ADVERTS_TABLE ." 
! 			WHERE category = '$inp_category' 
  			AND expiry_date > $current_time
  			ORDER BY premium_ad_ind DESC, id DESC
  			LIMIT ".$start.", ".$ads_config['ads_per_page'];
  }
! else	
  {
! 	$sql = "SELECT * 
! 			FROM ". ADS_ADVERTS_TABLE ." 
  			WHERE expiry_date > $current_time
  			ORDER BY premium_ad_ind DESC, id DESC
***************
*** 362,366 ****
  if ( $db->sql_numrows($result) > 0 )
  {
! 	while ($row = $db->sql_fetchrow($result))
  	{
  		$id = $row['id'];
--- 362,366 ----
  if ( $db->sql_numrows($result) > 0 )
  {
! 	while ($row = $db->sql_fetchrow($result)) 
  	{
  		$id = $row['id'];
***************
*** 368,372 ****
  		$ebay_id = $row['ebay_id'];
  
! 		$profiledata = mx_get_userdata($user_id);
  
  		if ( $user_id != ANONYMOUS )
--- 368,372 ----
  		$ebay_id = $row['ebay_id'];
  
! 		$profiledata = get_userdata($user_id); 
  
  		if ( $user_id != ANONYMOUS )
***************
*** 402,429 ****
  
  		// Count the comments
! 		$sql2 = "SELECT COUNT(comment_id) AS comments_count
! 		      FROM ". ADS_COMMENTS_TABLE ."
!    		   WHERE comment_ad_id = '$id'
! 		      GROUP BY comment_ad_id
! 		      LIMIT 1";
  
! 		$result2 = $db->sql_query($sql2);
! 		$row2 = $db->sql_fetchrow($result2);
  
! 		if ( empty($row2) )
! 		{
! 		   $total_comments = 0;
! 		}
! 		else
! 		{
! 		   $total_comments = $row2['comments_count'];
  		}
! 
  		// Check to see if an image exists for this ad
  		if ( $ads_config['images'] == 1 )
  		{
! 			$sql2 = "SELECT *
  					FROM ". ADS_IMAGES_TABLE ."
! 					WHERE id = '$id'
  					AND img_deleted_ind = 0
  					LIMIT 0,1";
--- 402,429 ----
  
  		// Count the comments
! 		$sql2 = "SELECT COUNT(comment_id) AS comments_count 
! 		      FROM ". ADS_COMMENTS_TABLE ." 
!    		   WHERE comment_ad_id = '$id' 
! 		      GROUP BY comment_ad_id 
! 		      LIMIT 1"; 
  
! 		$result2 = $db->sql_query($sql2); 
! 		$row2 = $db->sql_fetchrow($result2); 
  
! 		if ( empty($row2) ) 
! 		{ 
! 		   $total_comments = 0; 
! 		} 
! 		else 
! 		{ 
! 		   $total_comments = $row2['comments_count']; 
  		}
! 		
  		// Check to see if an image exists for this ad
  		if ( $ads_config['images'] == 1 )
  		{
! 			$sql2 = "SELECT * 
  					FROM ". ADS_IMAGES_TABLE ."
! 					WHERE id = '$id' 
  					AND img_deleted_ind = 0
  					LIMIT 0,1";
***************
*** 431,436 ****
  			//global $ebay_id, $mx_images;
  
! 			$sql3 = "SELECT *
! 					FROM ". ADS_ADVERTS_TABLE ."
  					WHERE ebay_id = '$ebay_id'
  					LIMIT ".$start.", ".$ads_config['ads_per_page'];
--- 431,436 ----
  			//global $ebay_id, $mx_images;
  
! 			$sql3 = "SELECT * 
! 					FROM ". ADS_ADVERTS_TABLE ." 
  					WHERE ebay_id = '$ebay_id'
  					LIMIT ".$start.", ".$ads_config['ads_per_page'];
***************
*** 443,454 ****
  			if ( $db->sql_numrows($result2) > 0 )
  			{
! 				while ($row2 = $db->sql_fetchrow($result2))
  				{
  					$img_url = ADS_IMAGES_PATH ."ad".$id."_img".$row2["img_seq_no"]."_thumb.jpg";
  				}
  			}
! 			elseif ( $db->sql_numrows($result3) > 0 )
  			{
! 				while ($row3 = $db->sql_fetchrow($result3))
  				{
  					$ebay_id = $row3['ebay_id'];
--- 443,454 ----
  			if ( $db->sql_numrows($result2) > 0 )
  			{
! 				while ($row2 = $db->sql_fetchrow($result2)) 
  				{
  					$img_url = ADS_IMAGES_PATH ."ad".$id."_img".$row2["img_seq_no"]."_thumb.jpg";
  				}
  			}
! 			elseif ( $db->sql_numrows($result3) > 0 ) 
  			{
! 				while ($row3 = $db->sql_fetchrow($result3)) 
  				{
  					$ebay_id = $row3['ebay_id'];
***************
*** 463,467 ****
  
  			$template->assign_block_vars('imagerow', array(
! 
  			'U_ADS_ITEM'		=> append_sid(this_ads_mxurl("ads_mode=ads_item&id=".$row['id'])),
  			'U_PROFILE'		=> $profile,
--- 463,467 ----
  
  			$template->assign_block_vars('imagerow', array(
! 		
  			'U_ADS_ITEM'		=> append_sid(this_ads_mxurl("ads_mode=ads_item&id=".$row['id'])),
  			'U_PROFILE'		=> $profile,
***************
*** 477,486 ****
  			'COMMENTS'		=> $total_comments,
  			'IMAGE'			=> ( !empty($img_url) ? $img_url : $mx_images['noimage'] )
! 			));
  		}
  		else
  		{
  			$template->assign_block_vars('noimagerow', array(
! 
  			'U_ADS_ITEM'	=> append_sid(this_ads_mxurl("ads_mode=ads_item&id=".$row['id'])),
  			'U_PROFILE'		=> $profile,
--- 477,486 ----
  			'COMMENTS'		=> $total_comments,
  			'IMAGE'			=> ( !empty($img_url) ? $img_url : $mx_images['noimage'] )
! 			)); 
  		}
  		else
  		{
  			$template->assign_block_vars('noimagerow', array(
! 		
  			'U_ADS_ITEM'	=> append_sid(this_ads_mxurl("ads_mode=ads_item&id=".$row['id'])),
  			'U_PROFILE'		=> $profile,
***************
*** 493,502 ****
  			'PRICE'			=> $row['price'],
  			'VIEWS'			=> $row['views'],
! 			'COMMENTS'		=> $total_comments));
  		}
  	}
  }
  else
! {
  	$template->assign_block_vars('switch_no_items_found',array());
  }
--- 493,502 ----
  			'PRICE'			=> $row['price'],
  			'VIEWS'			=> $row['views'],
! 			'COMMENTS'		=> $total_comments)); 
  		}
  	}
  }
  else
! {	
  	$template->assign_block_vars('switch_no_items_found',array());
  }
***************
*** 537,541 ****
  $page_string = sprintf($lang['Page_of'], ( floor( $start / $ads_config['ads_per_page'] ) + 1 ), ceil( $ads_count / $ads_config['ads_per_page'] ));
  
! $template->assign_vars(array(
  
  	'U_ADS_INDEX' => append_sid(this_ads_mxurl()),
--- 537,541 ----
  $page_string = sprintf($lang['Page_of'], ( floor( $start / $ads_config['ads_per_page'] ) + 1 ), ceil( $ads_count / $ads_config['ads_per_page'] ));
  
! $template->assign_vars(array(	
  
  	'U_ADS_INDEX' => append_sid(this_ads_mxurl()),
***************
*** 547,551 ****
  	'U_RSS2' => append_sid($module_root_path . "adverts." . $phpEx . "?ads_mode=ads_rss2" . '&sid=' . $userdata['session_id']),
  	'IMG_RSS2' => $mx_images['ads_rss2'],
! 
  	'L_CATEGORIES' => $lang['categories'],
  	'L_TITLE' => $lang['title'],
--- 547,551 ----
  	'U_RSS2' => append_sid($module_root_path . "adverts." . $phpEx . "?ads_mode=ads_rss2" . '&sid=' . $userdata['session_id']),
  	'IMG_RSS2' => $mx_images['ads_rss2'],
! 	
  	'L_CATEGORIES' => $lang['categories'],
  	'L_TITLE' => $lang['title'],
***************
*** 564,568 ****
  	'MSG_NEWAD' => $mx_images['msg_newad'],
  	'GOTO_STRING' => $goto_string,
! 	'PAGE_STRING' => $page_string,
  	'POINTER' => $pointer,
  	'POINTER2' => $pointer2,
--- 564,568 ----
  	'MSG_NEWAD' => $mx_images['msg_newad'],
  	'GOTO_STRING' => $goto_string,
! 	'PAGE_STRING' => $page_string, 
  	'POINTER' => $pointer,
  	'POINTER2' => $pointer2,
***************
*** 570,574 ****
  	'SUB_CATEGORY' => stripslashes(str_replace("''", "\'", $inp_sub_category))));
  
! $template->pparse('adverts_page');
  
  if ( !is_object($mx_block))
--- 570,574 ----
  	'SUB_CATEGORY' => stripslashes(str_replace("''", "\'", $inp_sub_category))));
  
! $template->pparse('adverts_page'); 
  
  if ( !is_object($mx_block))
***************
*** 576,580 ****
  	include($mx_root_path . 'includes/page_tail.'.$phpEx);
   }
! 
  // +-------------------------------------------------------------+
  // |    Powered by phpCA Classified Ads 0.5.6 (c) 2006 PeteMan   |
--- 576,580 ----
  	include($mx_root_path . 'includes/page_tail.'.$phpEx);
   }
! 	
  // +-------------------------------------------------------------+
  // |    Powered by phpCA Classified Ads 0.5.6 (c) 2006 PeteMan   |

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_phpCA/db_install.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** db_install.php	8 Feb 2008 23:42:47 -0000	1.2
--- db_install.php	28 Feb 2008 06:26:23 -0000	1.3
***************
*** 124,128 ****
  		last_chase_type char(1) NOT NULL default '',
  		renewal_password int(9) NOT NULL default '0',
! 		PRIMARY KEY (id)
  		) TYPE=MyISAM";
  
--- 124,128 ----
  		last_chase_type char(1) NOT NULL default '',
  		renewal_password int(9) NOT NULL default '0',
! 		PRIMARY KEY (id) 
  		) TYPE=MyISAM";
  
***************
*** 142,146 ****
  		KEY comment_user_id (comment_user_id),
  		KEY comment_user_ip (comment_user_ip),
! 		KEY comment_time (comment_time)
  		) TYPE=MyISAM";
  
--- 142,146 ----
  		KEY comment_user_id (comment_user_id),
  		KEY comment_user_ip (comment_user_ip),
! 		KEY comment_time (comment_time) 
  		) TYPE=MyISAM";
  
***************
*** 229,262 ****
  		notify_version varchar(10),
  		verify_sign varchar(10),
! 		custom mediumint(8),
  		PRIMARY KEY (invoice)
  		) TYPE=MyISAM";
  
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('max_pics', '1024')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('ads_per_page', '5')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('ad_duration_months', '3')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('board_disable', '0')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('config_id', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('default_style', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('first_chase_days', '28')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('large_img_height', '480')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('large_img_width', '640')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('max_ads_per_user', '100')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('max_images_per_ad', '5')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('medium_img_height', '200')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('medium_img_width', '200')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('second_chase_days', '14')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('thumb_img_height', '100')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('thumb_img_width', '100')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('rate_scale', '10')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('comment', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('rate', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('images', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('paid_ads', '0')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('renewals', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('view_level', '-1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('move_level', '2')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('search_level', '0')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('private_trade_ind', '0')";
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('version', '0.5.5')";
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('enable_integration', '1')";
--- 229,262 ----
  		notify_version varchar(10),
  		verify_sign varchar(10),
! 		custom mediumint(8), 
  		PRIMARY KEY (invoice)
  		) TYPE=MyISAM";
  
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('max_pics', '1024')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('ads_per_page', '5')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('ad_duration_months', '3')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('board_disable', '0')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('config_id', '1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('default_style', '1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('first_chase_days', '28')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('large_img_height', '480')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('large_img_width', '640')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('max_ads_per_user', '100')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('max_images_per_ad', '5')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('medium_img_height', '200')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('medium_img_width', '200')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('second_chase_days', '14')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('thumb_img_height', '100')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('thumb_img_width', '100')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('rate_scale', '10')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('comment', '1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('rate', '1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('images', '1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('paid_ads', '0')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('renewals', '1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('view_level', '-1')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('move_level', '2')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('search_level', '0')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('private_trade_ind', '0')"; 
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('version', '0.5.5')";
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('enable_integration', '1')";
***************
*** 264,277 ****
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('index', '6')";
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('ebay_ref', '172425')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('webmasterplan_site', '1382')";
  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('currency_code', 'GBP')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('language_code', 'GB')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('business_email', 'web...@ho...')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('sandbox', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('basic', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('standard', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('photo', '1')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('premium', '1')";
  
  	$sql[] = "UPDATE " . $mx_table_prefix . "module" . "
--- 264,277 ----
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('index', '6')";
  	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('ebay_ref', '172425')";
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_config VALUES ('webmasterplan_site', '1382')"; 
  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('currency_code', 'GBP')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('language_code', 'GB')"; 
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('business_email', 'web...@ho...')";  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('sandbox', '1')";  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('basic', '1')";  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('standard', '1')";  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('photo', '1')";  
! 	$sql[] = "INSERT INTO " . $mx_table_prefix . "ads_paid_ads_config VALUES ('premium', '1')";  
  
  	$sql[] = "UPDATE " . $mx_table_prefix . "module" . "
***************
*** 294,296 ****
  echo "</table><br />";
  
! ?>
\ No newline at end of file
--- 294,296 ----
  echo "</table><br />";
  
! ?>