This is a partial functional change list only. alter table `pypro710_contact` add webpage_name varchar(120) deprecation of user notify table and scripts define("TABLEUSERNOTIFY", "pypro710_user_notify"); // removed register_result.php - modified quick_submit - modified manage_import_handler.php - modified settings_form.php - modified define("TABLELISTINGNOTIFY", "pypro710_listing_notify"); // removed loginResult.php - modified /results/active_index.php - modified columns /results/active_index_form.php - modified columns recent.php - changed order by added spam challenge to site visitor contact form directory/includes/image_display_function.php --- to check that the file exists first --- group delete - start function for listings. Here is the layout: ./sitewide/js/form_funcs.js ./sitewide/classes/c_phpyellow.php ./directory/admin/admin_group_delete.php ./directory/admin/admin_nav.php ./directory/admin/images/buttons/32x32/group_delete.gif The delete process functions as follows: 1. matching TABLECUSTOMER table entries are deleted 2. contact.imagecompany file deleted if exists 3. all TABLECATEGORY listings with matching fkcustomerid are deleted 4. listing.image2 file deleted if exists 5. listing.image3 file deleted if exists 6. listing.pdf deleted if exists 7. listing.audio file deleted if exists 8. listing.powerpoint file deleted if exists --- group delete - end managers/manager_result.php fixed $this_expires line 521 alter table pypro710_listing change status status enum('pending','approved','expired', 'archived') default 'pending' alter table pypro710_listing change rank rank tinyint(1) unsigned not null default 0 Changes to this version 7.20 File Action account_form.php changed javascript validation /ezseo/ new SEO tool /modules/notify/ deprecated admin/admin_nav.php removed link to /modules/notify/ /modules/seo/ new, tool for point and click SEO management util.php added BUILD date constant /admin/settings_form.php ditto /admin/settings.php ditto Changes to this version 7.14 File Action /admin/fix_zipcode_zeros_issue.php new, tool for padding zipcode data field with correct leading zeros managers/manager_result.php removed archiving, all listings are now directly renewed to preserve click history /result/search_keyword.php fixed link to search_advanced.php /docs/faq_customer.php expanded managers/manager.php fixed bug in count of total archived records /managers/mailer/ support for sending custom email to business owner index.php new mail_config.php new manager_goal_controls.php updated public_html/sitewide/classes/ updated /admin/settings_form.php added support for internet banner ad prices prices_banners.php descriptive page, integrated with settings above home.php integrated with internet banner ads index.php ditto recent.php ditto /templates/right.php ditto /templates/left.php ditto Changes to this version 7.12 File Action removed extra_* data fields /admin/admin_geocoder.php new, automatic lat/lon creation /admin/admin_mailer.php new sales/webmaster email tool directory/modules/keyword/statistics/ all files in folder updated for new conditional include on line 1 advertise.php new: highlight all products and services available website.php new prices_banners.php new /modules/payment/prices_banners_form.php new fullpage.php added city /templates/single_line.php downgraded bronze look and feel Entire backend /categories management replaced including forms, scripts and some images. Changes to this version 7.10 ALTER TABLE p7_listing ADD neighborhoods varchar(80) First development code release of version 7.10. Consolidates all version 7.x edits. Changes to this version 7.07 File Action 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