This is a partial functional change list only. Changes to this version 7.08 File Action /results/active_index.php new drill down search /results/active_index_form.php new search form Changes to this version 7.07 File Action /admin/settings_form.php new SPAM challenge and answer. Question and answer can be changed by webmaster. define("SPAM_CHALLENGE", "What number is the sum of 1 + 1 ?"); define("SPAM_ANSWER", "2"); register_form.php ditto register_result.php ditto ALTER TABLE p7_listing ADD neighborhood varchar(80) /install/installTables.php files affected by neighborhood data field addition register_result.php generic_addslashes.php generic_stripslashes.php /admin/settings_form.php loginResult.php /templates/listing_edit_form.php /templates/listing_add_form.php ALTER TABLE p7_listing CHANGE listing_start listing_start date NOT NULL default '0000-00-00' ALTER TABLE p7_listing CHANGE listing_end listing_end date NOT NULL default '0000-00-00' /managers/manager_result.php added load ckey, Listing Expiration reports /admin/admin_nav.php support for Listing Expiration reports admin/images/buttons/32x32/clock.png new, for Listing Expiration reports /managers/load_ckey_form.php new Changes to this version 7.05 File Action /sitewide/contact/message_priority_form.php updated fullpage.php updated: totally new generic_stripslashes.php updated for google latitude and longitude and SERVICE PLUS news.php updated with usa dailynewspagers and tv links CURRENCY_CODE partly replaces CURRENCYSYMBOL /admin/settings_form.php /modules/payment/gateway/paypal/ updated /modules/payment/buy.php ditto /modules/payment/checkout.php ditto /modules/payment/data_out.php ditto listing_cards.php ditto listing_features.php ditto listing_how_to_improve.php ditto // New Listing Expiration tool - start /admin/images/buttons/32x32/clock.png new /admin/admin_nav.php updated /managers/manager_result.php updated /managers/create_expiration_report_form.php new // New Listing Expiration tool - end /results/compare.php new /templates/universal_display.php updated for Compare tool /admin/settings_form.php ditto /results/search4needles.php ditto SQL ALTER TABLE alter table py6_listing change status status enum('pending','approved','expired','archived') default 'pending' /managers/manager_goal_controls.php added 'archived' to status options led_image.php ditto // Service Plus - start /admin/settings_form.php added define("SERVICE_PLUS", "on"); admin/admin_nav.php cosmetic register_random_letters.php new register_result.php new /templates/nav.php added welcome and categories plus loginResult.php ditto /categories/categories_plus_form.php new retrieve_listing_for_categories_plus.php new /categories/categories/categories2.php new /categories/categories/categories3.php new /categories/categories/categories4.php new /categories/categories/categories5.php new /categories/categories/categories6.php new /categories/categories/categories7.php new SQL ALTER TABLE alter table py6_listing add category2 varchar(80); alter table py6_listing add category3 varchar(80); alter table py6_listing add category4 varchar(80); alter table py6_listing add category5 varchar(80); alter table py6_listing add category6 varchar(80); alter table py6_listing add category7 varchar(80); // Categories Plus - end Changes to this version 6.42 File Action /install/install_permissions.php updated /admin/settings_form.php define("TABLE_KEYWORD_SOURCE", "keyword_source"); /admin/settings_form.php define("TABLE_KEYWORD_OPPORTUNITY", "keyword_opportunity"); define("TABLE_KEYWORD_SOURCE", "keyword_source" ); define("TABLE_KEYWORD_OPPORTUNITY", "keyword_nomatch" ); /modules/keyword/ new, for match and opportunity words CREATE TABLE keyword_nomatch ( id mediumint(9) unsigned NOT NULL auto_increment primary key, keyword varchar(40) default NULL, hitdate date NOT NULL default '0000-00-00', hitstamp timestamp(14), KEY sourceidx (keyword(12)) ); CREATE TABLE keyword_source ( id mediumint(9) unsigned NOT NULL auto_increment primary key, keyword varchar(40) default NULL, hitdate date NOT NULL default '0000-00-00', hitstamp timestamp(14), KEY sourceidx (keyword(12)) ); ALTER TABLE py6_listing ADD glat decimal(8,6); ALTER TABLE py6_listing ADD glon decimal(9,6); ALTER TABLE py6_listing ADD gzoom int(2) unsigned default 12 /templates/nav.php loginResult.php supports user edit of latitude longitude and zoom modules/map/google/findlatlong.php help page for finding lat long. not yet implemented on front end util.php added define("EMAIL_URL", "http://phpyellow.com/email_switch.php"); generic_stripslashes.php updated for new keyword data fields generic_addslashes.php ditto /templates/universal_display.php ditto search_keyword.php ditto, also updated to run with a faster query search_keyword_form.php ditto loginResult.php ditto /templates/nav.php ditto /images/buttons/32x32/keywords.gif ditto /results/no_match.php ditto ALTER TABLE py6_listing ADD keyword varchar( 40 ); ALTER TABLE py6_listing ADD keyword2 varchar( 40 ); ALTER TABLE py6_listing ADD keyword3 varchar( 40 ); ALTER TABLE py6_listing ADD keyword4 varchar( 40 ); ALTER TABLE py6_listing ADD keyword5 varchar( 40 ) /admin/optimize_tables.php new /admin/images/buttons/32x32/wrench.gif new /admin/admin_nav.php updated with Optimize Tables /templates/universal_display.php flash video links into new /userdata/video.php fullpage.php removed website click links, removed flash movie search_default.php added search by state and category search_state_category_form.php new search_list.php updated to include search by state and category /images/buttons/satellite_16x16.gif added, when clicked launches google map page /templates/universal_display.php updated to show satellite image and google map link /admin/settings.php added input area for google_map_key /modules/flash_flv_player/ new /images/buttons/32x32/video_16x16.gif new fullpage.php updated for Flash player util.php removed $MEDIA_ALLOWED images_upload.php added support for .flv // flash video player upgrade - end fullpage.php changed handling for website clickthru modules/statistics/click_w.php updated with newer click handling /templates/universal_display.php removed logo hyperlink ALTER TABLE `p4_click_website` ADD `ckey` INT( 9 ) UNSIGNED NULL AFTER `ip` ; /managers/confirm_delete.php moved confirm button higher for higher resolutions sql alter table py6_listing add neighborhood varchar(80); Changes to this version 6.30 File Action admin/settings_form.php replaces edit configuration /admin/settings.php replaces edit_configuration_action.php listing_features.php updated for new settings script listing_cards.php ditto /modules/payment/checkout.php ditto /admin/edit_configuration_action.php replaced by settings.php and settings_form.php /modules/payment/paymentMethodsList.php updated /modules/payment/checkout.php updated /modules/payment/buy.php updated all /install/ folder files minor updates including new category list and elimination of v3x data migration support /modules/easysql/describe.php new admin/admin_nav.php updated /modules/easysql/describe_tables.php new QuickSearch categories complete review, update and docs for phpYellow QuickSearchTM categories search4needles.php used in more scripts search_text_links_form.php new /css/generic.css various in-page formatting moved to css class objects for ease of edit admin/admin.php new conditional features plus old revisions quick_submit_form.php updated, removed dynamic repopulating form objects docs/categories.php new index_all_categories.php updated $querystring encoding includes/image_display_function.php new, for image resizing templates/universal_display.php updated to use imagecompany resizing top15_numbers.php renamed from original top15.php, displays city and category numbers top15_no_numbers.php new, does not show data numbers, for sparsely populated directories search_subindex.php new, to handle top15 cities subindexing webmaster dashboard updated navigation most /docs/ files complete documentation review and update /css/generic.css updated index.php updated search_keyword_form.php cosmetic, removed text: Keyword search_live_keyword_city_form.php new search4needles.php new back_next_search4needles.php new /templates/left.php, right.php updated /templates/universal_display.php added class selector for bizcard_title count_total_listings.php new /images/corners/ changed to gray color search_pinpoint_b_form.php cosmetic search_pinpoint_c_form.php cosmetic search_default.php added Live search search_newest_members.php changed to display newest 7 search_list.php updated search_default.php updated Changes to this version 6.21 File Action search_description_form.php new search_description.php new back_next_description.php new search_list.php updated search_advanced.php updated search_lens_form.php new search_lens.php new back_next_lens.php new Changes to this version 6.20 File Action fullpage.php changed look and feel of powerpoint, video, pdf all frontend files added support for .ico as seen in Firefox generic_addslashes.php strip_tags() added to all db inserted variables quick_submit_form.php added email capability quick_submit.php ditto generic_addslashes.php ALLOWHTML revised generic_stripslashes.php ALLOWHTML revised loginForm.php username requirement reduced to 2 characters register_result.php updated register_form.php updated Changes to this version 6.10 File Action /templates/header.php fixed broken search_advanced.php link /admin/edit_configuration_form.php fixed broken mwp link /admin/paging_class.php updated for php5 /css/generic.css class='form_color' added all search forms encapsuled in universal expandable editable colored forms most front end pages introduced left center and right COLUMN_WIDTH constants util.php ditto register_random_letters.php new, introduces random letter check to avoid spam bots register_result.php modified for random letter check to avoid spam bots register_form.php ditto /modules/zipcode/search_zipcode.php automatic shuffle of listings, by rank then random /search_result.php automatic shuffle of listings by rank then random /search_keyword.php automatic shuffle of listings by rank then random search_list.php changed variable name for citycategory and categorycity search_advanced.php ditto listing_features.php text updated images_upload.php added support for 'mp3','wmv','mp4','mpg','avi','mov' images_view.php ditto Changes to this version 6.08 File Action generic_addslashes.php added logic to handle single and double quotes in the description listing_cards.php added link to more ... which links to listing_features_index.php listing_features_index.php new search_411_form.php new /images/background/411.gif new modules/coupons/coupon_freebies.php updated to suppress display of bronze coupons // changes made to effect enforcement of listing by category, listing type and state - start /payment/enforce_maximum_listings.php new /payment/position_full.php new /admin/manager_result.php updated /images/buttons/upgrade_listings.jpg updated /templates/listing_edit_form.php removed category edit accountForm.php removed stateprov edit, renamed to account_form.php account_form.php see above /docs/database.php more info added // changes made to effect enforcement of listing by category, listing type and state - end === changes to statistics handling - start Special note: the new feature of tracking hits on fullpage ckey is in replacement of the tracking of hits on the variable $website. The purpose is to keep more customers on your website. fullpage.php modified to track hits on fullpage ckey, not website loginResult.php ditto util.php ditto /templates/universal_display.php ditto /templates/nav.php ditto /admin/edit_configuration_form.php ditto /admin/edit_configuration_action.phpditto /install/installTables.php ditto /statistics/ click_ckey.php new retrieve_statistics_listings.php new statistics_ckey_hits.php new === changes to statistics handling - end invite.php new, replaces tell a friend search_advanced.php new search_list.php new search_pinpoint.php new 2 step search script search_pinpoint_a_form.php ditto search_pinpoint_b_form.php ditto /docs/customize.php updated email_notify.php stripped backslashes and single quotes from description sent in email register_result.php added handling for listing_start == $todaysDate /admin/quick_submit.php ditto loginResult.php ditto loginResult.php convert " to " in description field register_result.php no longer allows spaces in username, alows only one email address loginResult.php ditto Changes made to this version: 6.05 File Action util.php improved image restrictions images_upload.php ditto images_view.php ditto images_picker.php ditto loginResult.php ditto /admin/quick_submit.php shorter, more automatic fields /admin/quick_submit_form.php ditto /templates/left.php new links /admin/edit_configuration_action.php $news_host_domain updated, new image and file restrictions added /admin/adminOnly.php @include("../util.php"); // enables /broadcast use /managers/find.php new /managers/manager_result.php /managers/button_find.jpg search_smart_browse.php updated search_hyper.php updated search_default.php new, handles default search form search_result.php updated to handle alphbetical search searchDefault.php deprecated loginResult.php line 183 fix basename function correction search_alphabetical_form.php new - search for business alphabetically search_result.php updated for alpha search Changes made to this version: 6.04 File Action loginResult.php username length checking added when updated /templates/footer.php added proprietary marquee tag admin/information_center.php hotscripts vote update admin/information_center.php NEWS_HOST_DOMAIN added to RSS links /modules/feedback/ new contact form Database changes resulted in move to 6.x status. Log of changes made in version 5.35 File Action faq_customer.php new Log of changes made in version 5.34 File Action searchDefault.php added more searches /modules/evaluate/ added support for ebay like clone feedback admin/edit_configuration_action.php ditto managers/manager.php added customerid to display search_result.php added case for 'City' loginResult.php update for if login fail loginForm.php added javascript data validation registerForm.php ditto /managers/manager_result.php fixed bad link to calculate_expiry.php line #331 search_keyword_form.php new, for multi-field search search_keyword.php ditto search.php updated with new Keyword search search_keyword_back_next.php ditto /modules/payment/buy.php udpated with new price calculation, uses divisor, not multiplication in order to get better rounded sums /install/ added sql for table coupons create and insert /modules/coupons/ new /templates/nav.php conditional display of new coupon button /loginResult.php added support for coupons /templates/header.php widened default header image to 780 pixels /templates/universal_display.php new, replaces bronze, silver, gold and sponsor.php includes coupon support /managers/manager_result.php updated Log of changes made in version 5.33 File Action loginResult.php cosmetic images_errors.php removed version compare to enable image dimension enforcement images_upload.php ditto /templates/search_needle_in_haystack removed LIKE match zipcode managers/manager.php one click webmaster access to edit recent listings register.php capable of transparently supporting banip if banip module is purchased login.php ditto contactus.php ditto password.php ditto /admin/admin_nav.php updated to conditionally include button link to [optional] banip module /templates/advertise_here.php updated /admin/advertise_here_webmaster.php new /templates/gold.php, sponsor.php added website2 and website3 hyperlinks to search display templates manager_result.php fixed display when no matches exist with Hyper Manage /templates/header.php resize image width /css/generic.css new class listing_background sj_uk.php Isle of Wight spelling corrected Log of changes made in version 5.31 File Action /modules/brochure/index.php NEW Post biz from client control panel NEW /templates/nav.php NEW client control panel buttons /images/buttons/* ditto /admin/admin_nav.php NEW admin panel buttons /admin/images/buttons/* ditto images_choose_listing.php NEW LED status indicator lights for manager and client control panel managers/manager.php ditto loginResult.php ditto retrieve_customer_listings.php ditto proUpgradeMyListing.php ditto index_specific_category.php NEW, builds an index pick list, filtered by programmable category edit_configuration_form.php modified, updated search default, used by 'Edit Configuration' to assign a default search searchDefault.php ditto back_next.php modified to accept $_POST['category'] by default, then $_REQUEST['category'] Log of changes made in version 5.30 File Action search_result.php modified look and feel formatting to allow display of /templates/left and right.php search_heading.php ditto /templates/left.php and right.php removed table code for improved display /templates/left.php added INSTALLPATH to all links password.php security upgrade password_form.php new Log of changes made in version 5.29 File Action modules/payment/buy.php added support for one month listings modules/payment/duration.php ditto Log of changes made in version 5.28 File Action /modules/payment/gateways/paypal/ replaced one-time payment system with recurring subscription based system /images/icons/* updated all icons to transparent gifs /templates/header.php ditto /admin/guide/index.php updated /admin/admin_nav.php removed INSTALL_DIR replaced with relative uri manage_accounts_action.php renamed form actions from PHP_SELF to filename manage_accounts_display.php ditto search_needle_in_haystack.php changed Go button to .gif format go.gif /docs/payment.php added more detail Log of changes made in version 5.27 File Action /mwp/mwp_personal.php added INSTALLPATH to image links /templates/header.php added text links underneath icons /templates/left.php added image /templates/right.php centered content index.php changed left and right columns to class="favcolor" search_result_LITE.php new admin_nav.php unspecified other miscellaneous cosmetic changes Log of changes made in version 5.26 Limited release only. Log of changes made in version 5.25 File Action /docs/payment.php more info search_needle_in_haystack.php added ad_title search_hyper.php added ad_title to lower list register_form.php increased data size to maxlength 640 characters /templates/listing_add_form.php ditto /templates/listing_edit_form.php ditto functions.php deprecated manager/calculate_expiry.php moved to ./ register_result.php updated calculation of expiry date with ./calculate_expiry.php loginResult.php ditto /manager/manager_result.php ditto /payment/data_in.php ditto docs/configure.php new documentation for listing expiry date calculation /manager/ folder renamed to /managers/ along with impacted files because of conflict with Tomcat default installation folder name /modules/gateways/paypal/pro_paypal_variables.php included paypal builder number bn id hidden input Log of changes made to version 5.24 File Action /admin/guide/index.php new, Site Administrators Guide /admin/admin.php updated /admin/admin_nav.php updated with new buttons and refreshed links /admin/phpinfo.php removed security /templates/advertise_here.php updated bookmark feature /modules/bookmark/* new search_detail.php updated for conditional bookmark Log of changes made to version 5.23 File Action sendFeedbackForm.php variable userComments changed to user_comments (dependency child: loginResult.php) admin/admin_nav.php changed Send Notifications link to absolute URL admin/index.php new, redirects to admin login admin/edit_configuration_form.php automated INSTALL_DIR, will auto-calculate during setup generic_stripslashes.php added support for preserving description field line breaks if ALLOWHTML is turned off generic_addslashes.php ditto register_result.php ditto loginResult.php ditto util-dist.php default INSTALL_DIR initialized to NULL templates/advertise_here.php new search_by_bizlist.php added ORDER BY organization ASC with full table join index.php re-enabled flash movie templates/header.php footer.php pointed home link to index.php other miscellaneous changes to look and feel