Places (Events + Business integrated) Mod Support - part 4

~~~~~~~~~~~~~~~~~~~~~~~

$fields = mysql_list_fields($db['db'], "modzzz_listing_main"); 

$columns = mysql_num_fields($fields);

for ($i = 0; $i < $columns; $i++) {

    $field_array[] = mysql_field_name($fields, $i);

}

if (!in_array('location_id', $field_array)) {

db_res("ALTER TABLE `modzzz_listing_main` 

ADD `location_id` int(10) NOT NULL default '0'

");

}

if (!in_array('location_type', $field_array)) {

db_res("ALTER TABLE `modzzz_listing_main` 

ADD `location_type` varchar(255) NOT NULL default '' 

");

}

$GLOBALS['MySQL']->oParams->clearCache();

echo "SUCCESSFULLY UPDATED DATABASE ..... <br /><br />";

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~

$fields = mysql_list_fields($db['db'], "modzzz_lodging_main"); 

$columns = mysql_num_fields($fields);

for ($i = 0; $i < $columns; $i++) {

    $field_array[] = mysql_field_name($fields, $i);

}

if (!in_array('location_id', $field_array)) {

db_res("ALTER TABLE `modzzz_lodging_main` 

ADD `location_id` int(10) NOT NULL default '0' 

");

}

echo "SUCCESSFULLY UPDATED DATABASE ..... <br /><br />";

~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~

$fields = mysql_list_fields($db['db'], "modzzz_lodging_main"); 

$columns = mysql_num_fields($fields);

for ($i = 0; $i < $columns; $i++) {

    $field_array[] = mysql_field_name($fields, $i);

}

if (!in_array('location_id', $field_array)) {

db_res("ALTER TABLE `modzzz_lodging_main` 

ADD `location_id` int(10) NOT NULL default '0' 

");

}

echo "SUCCESSFULLY UPDATED DATABASE ..... <br /><br />";

~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In Places Admin, both

Integrate with Business Listing module

and

Integrate with Lodging module Are checked.