phpYellow Pages Developer's Guide

Docs Home | Read Me | FAQ | License | Security | Install | ChangeLog | Customize | Paid Listings
CHANGE LOG

Next Release information, historical version information, and a To Do list and a Wish List are included in this document.

Next Release

These are changes coming in the next release:

File or Action 

no changes to date

Historical Version Information

Version 2.30 Released February 22, 2002

This version sees the introduction of "Get Map" for the Premium edition. The map feature links a customer's record to the Mapquest database, which shows a map of exactly where the customer is located. A bridge has also been built [by Bob] to integrate all phpYellow editions with PWS. $basicListingExpiry is now added to the free Standard edition. Major cosmetic and structural modifications were made throughout the application. Do NOT upgrade to this version unless you are prepared to remake your look and feel on the new pages. Make a backup first. There are too many changes to detail here.

File                        Change
all                         structural and cosmetic changes to most all files
docs/DOCSlicense.html       a return link is now required
oneRecord.php               updated to enable display of the Get Map feature for the Premium edition only
index.php                   major structural, internal changes in how data is displayed with included files
misc. files                 CMS integration for PWS, including update of affected files
db:yareacode varchar(7)     changed database area code field to handle international values
addForm.php                 now handles international area code values
UKcounties.php              added. For use in the UK to replace country select [drop down] list with UK counties
premiumSearchForm.php       added to replace advancedSearchForm.php
advancedSearchForm.php      no longer used, replaced.
indexDynamicListings.php    added to show dynamic indexes for Premium AND Standard editions
featureListing.php          no longer used, replaced by indexDynamicListings.php
various /docs               updated and expanded documentation files
yellow.js                   modified data required by client side javascript to be only email and password, added customization instructions
highlight.php               cosmetics changed
exampleRecord.php           added to show user new listing in example highlight mode
easysql.php                 removed FORMBACKGROUND, no longer used
footer.php                  rewrote CONSTANT usage for NT
header.php                  rewrote CONSTANT usage for NT
premiumPriceChart.php       replaces priceChart.php with display changes
priceChart.php              replaced by premiumPriceChart.php
yellowresult.php            Add Category, Update category modules modified for text concerning images, no real functional change
tellafriend.php             subtle text display changes
goPremium.php               replaces upgrade.php, with minor text modifications "logo" to "image"
upgrade.php                 replaced by goPremium.php
util-dist.php               $basicListingExpiry

Version 2.24 for limited custom installs only

Version 2.24 was released to a limited number of paid customers only who were requiring customization of phpYellow Pages Premium. They were provided with the latest version and then that was customized further.

Version 2.23 Released January 7th, 2002

The Premium version 2.22 is unchanged. This release contains a fix for a bug found in the Standard 2.22 edition only. The premium Edition is NOT affected.

Version 2.22 Released January 1st, 2002

This is a major release with all files affected. Contains significant new features including:

File                         Action
docs/DOCSpaidListings.html   new
adminresult.php              added new premium module
docsInstallNotes.html        updated
exportEmailList.php          new
manageForm.php               updated for new state field 
adminGoalControls.php        modified to post method for going to admin
checkout.php                 removed email from displaying
featureListing.php           ditto
adminViewQueueForm.php       reenabled support for managing queued listings
yellowgoal.php               added support for stealth email to prevent spammers from reaching listers
commentForm.php              ditto
oneRecord.php                removed display of email addresses
countries.php                stopped "*" and "All Countries" from showing in Add
backNextControlsForm.php     added area code
advancedSearchForm.php       changed state input type, added area code for narrow results with modifier
yellow.js                    removed state code
addForm.php                  changed the state field from a select list to a text input type
yellowresult.php             added support for basic listing expiry, modified logo insert and update code
misc documentation           updated miscellaneous documentation files in the /phpYellow/docs folder
advancedSearchForm.php       dec22 fixed bug which was reporting all, rather than nonexpired and aproved listings
adminresult.php              modified to support change of category while using 'Set CKEY Parameters' admin tool
categories.php               stopped the "*" category from being selected in a new listing
util.php                     added support for changing expiration date for basic listings
yellowresult.php             ditto
upgradeForm.php              renamed some variables to integrate with admin and user initiated launches
yellowgoal.php               removed and updated modules
oneRecord.php                added four icons to the standard oneRecord.php display, placed ALL application images into the new /phpYellow/appimage folder, visitors logos will use /phpYellow/userlogo instead.
yellowresult.php             modified highlight module
upgrade.php                  updated content
paymentSpecialMessage.php    added this to make the payment process clear - special message from website owner possible
yellow.js                    eased the level of javascript form object validation for the addForm.php to make things easier for a lister
all /docs files              updated and included new Frequently Asked Questions [FAQ] page
yellowresult.php             Netscape 4.76 backwards compatibility changes
yfrecord.php
featuredListing.php
oneRecord.php
advancedSearchForm.php
index.php
new.php                     added new and newly updated listings page
footer.php                  ditto
header.php                  ditto
adminresult.php             changed sort order for 'Manage Listings' in Admin Center

Version 2.21 Released November 22nd, 2001.

This version sees the introduction of images for the Premium version only. A different image may be shown with every listing. Also, for the free and paid versions popup administration windows are added. Normally shunned by users, the popup has found a home here in administration because it is set to automatically display each message AND automatically close after POPUPTIMEOUT milliseconds. You may change POPUPTIMEOUT in util.php. Payment module and miscellaneous upgrades also exist in this version as detailed below:

File                     Action
adminSetStatusControls.php popup windows for administration - they automatically close after their message is displayed.
admin.php
adminresult.php
adminGoalControls.php


						logo support
addForm.php
adminresult.php
admingoalcontrols.php
adminOneRecord.php
buy.php
featureListing.php
footer.php
highlightRecord.php
loginForm.php
oneRecord.php
util.php
util-dist.php
yellow.js
yellowresult.php


yellowresult.php		payment module upgrade
buy.php
buyForm.php
processPayment.php
checkout.php
paymentInstructions.php
						
						other miscellaneous
installSecurity.php      added button for a 'Launch tips on how to customize' page
netscape.css             changed look and feel
advancedSearchForm.php   changed look and feel - removed some rows to improve Netscape rendering
header.php               changed look and feel - removed style class

Version 2.20

Version 2.20 is a MAJOR release with ALL files affected. Key changes include the introduction of browser detection in both the Standard and Premium versions. The browser detection is linked to serving different .css files for different browsers. More information is available in the online phpYellow Pages Developer's Guide. Also, a brand new installation script really makes installing a breeze - even faster than before! While all files are affected, following are some specific changes:

File			Action
install.html       Wow! Load this file in your browser and your phpYellow installation is as easy as pie.
all page level     added browser detection via javascript with customizable css file invocations in yellow.js
checkout.php       added functionality for optional live phone connect or live web chat during customer purchase of a paid listing
documentation      updated most documentation files contained within the /docs folder
SearchForm         added table formatting Premium version to improve appearance in Netscape browsers
admin.php          minor functionality changes, including direct link to dreamriver mailto for paid customers
login.php          removed dynamic reference to logos
upgrade.php        simple formatting changes
footer.php         modified with 2 links: one link points to the Developer's Guide, the other points to Dreamriver
index.php          added two shockwave Flash movies to the search page
SearchForm         line breaks dynamically expand to accomodate dynamic category numbers
login.php          repointed email note for edit exactly to login.php rather than the default home page for phpYellow Pages
yellow.js          added functionality for optional live chat during customer purchase of a paid listing
checkout.php       changed input box from text to password
buy.php	      added functionality for optional live phone connect or live web chat during customer purchase of a paid listing
tellafriend.php    changed page alignment and minor functionality

Version 2.11

Version 2.11 contains very MINOR code upgrades, along with expanded documentation in the Developer's Guide.

Version 2.10

Version 2.10 is a MAJOR upgrade release for the Premium version. Key new features include Feature Listing! and NEW Index Every Search, along with an expanded payment module for Premium Paid Listings. More details are available on Dreamriver's Fatpipe Digital Download showcase.

The free Standard version saw a couple of code upgrades to enhance cosmetic effect, along with one bug fix for a wrong file invocation - spotted and fixed earlier on the online forum by users :)

Version 2.04

Version 2.04 contains a new tax module intended for use with the payment module.

Version 2.03

Version 2.03 marks the integration of multiple database tables into the standard version. Also, the front end is improved in the standard version with the addition of the new Click By Category feature.

An installation file also appears in version 2.03 which will help upgrade an old installation or swiftly implement a new installation. The same install.php file works for both Standard and Premium versions. This file should be deleted from the web server after use.

A minor upgrade in version 2.03 is implementation wide support for local PC implementation. A default localhost util-dist.php file is included. This enables you to run phpYellow Pages locally, on your own machine, if you also have installed mysql, php and web server software, all freely available.

This version uses "traditional" php code. NO classes or objects are used in this code. This makes it easier for developers, students and beginners to easily change the code to match your needs.

In general, any version upgrade should totally replace existing files, except of course for any database table data.

The Shift at Version 2.0

Version 2.0 marks a significant change in the features, options and code within phpYellow Pages. The version 2.0 PAID features are vastly exanded. This includes a payment system for premium listings, preview of new listings prior to publication, multi-category submissions per each listing, many more table fields and other significant structural and functional changes. An installation script does much of the installation for you, although some configuration and file transfer is required.

Versions 1.2 and lower

The following changes were made to older versions of phpYellow Pages. They are included here for archive reasons - you shouldn't need them as you _should_ be running the latest version of the software.
The following changes have been made to the download package at:

	http://www.dreamriver.com/software/phpyellow/phpYellow.zip

February 27, 2001
Start of Version 1.1 UPGRADE	
Version Change from 1.062 to 1.1

Note: This is a substantive upgrade with many cosmetic and functional changes.

	FILE				ACTION
	yrecord.php3		removed because of code changes
	provinces			added commented out Javascript to require a valid province or state selection. Must be uncommented to work. 
	countries			added javascript to require a valid country selection in add or edit mode
	categories			added javascript to require a valid category selection in Add or Edit mode.
	util-dist.php3		modified for Premium
	many files			cosmetic changes
	ysearchagain.php3	modified for premium version
	yellowresult.php3	modified for premium version
	backNextControlsForm.php3 modified hidden variables
	license.txt			minor changes to license.txt - including phpYellow application name, dates.
	backNextControlsForm.php3	added new form to enhance navigational features for results: Back, Next
	ysearchagain.php3	reformatted
	easysql.php3		fixed double empty line insert so caret focus remains in character 1 location of query textarea box
	yfadmin-record.php3	changed form property method to "get" from "post" to enable Netscape access. Replaced all single quote html entities with double quotes
   	yellowresult.php3   the "Click for next results" incorrectly used category as an argument. It has been changed to "ycategory" - and then replaced by the backNextControlsForm.php3
	
	
	
	
	
December 11, 2000	
Start of Version 1.062 UPGRADE	
Version Change from 1.061 to 1.062 

	Note: this version is a Netscape upgrade version. Netscape users can now access Admin. Also, displayed formatting works somewhat better in Netscape, but worse in IE.

	FILE			ACTION
	header.php3		validation cleanup - brought files closer to meeting strict w3c standards
	admin-login.php3	ditto
	footer.php3		ditto
	admin.php3		phototop anchor fix for Netscape (NS).
	yellow.css		changed th selector properties, added .small class for NS. Added H4 selector.
	yfrecord.php3		changed size to small to look better in NS.
	yellowresult.php3	changed the dynamic search heading on line 234 from th to h4 and added new .css selector for it. This is a NS fix.
END OF VERSION 1.062 UPGRADE	


	
November 19, 2000	
Start of Version 1.061 UPGRADE
Version Change from 1.06 to 1.061

FILE			ACTION
util-dist.php3		added a missing semi colon on about line 25 here: define("SHOWSQL", "no" );<--- semicolon was missing, preventing phpYellow from working. 
util.php3		ditto. util-dist.php3 is the same file as util.php3. "util-dist.php3" is the file that arrives with the distribution files and is renamed util.php3 and uploaded to your server.
END OF Version 1.061 UPGRADE		



	
November 16, 2000	
Start of Version 1.06 UPGRADE
Version Change from 1.051 to 1.06

FILE			ACTION
adminresult.php3    	found and fixed a "$yfphone = $sql->data[9];" omission bug. Caused by commented out code block. Bug affected administration 'Find Record Like' and 'Set-Rank' display of records only. Did NOT affect record database integrity.
dev-mess.php3       	refreshed message
admin.php3		added link to phpFD File Downloader live demo & tour
yellowadd_form.php3	changed categories, provinces and countries to included files for easier customization
yadmin-manage.php3	ditto
ysearchagain.php3	ditto
yellowedit_form.php3	ditto
provinces.php3		added
countries.php3		added
categories.php3		added	
yellowresult.php3	deleted commented out code for $yfphone
admin.php3		the reference to dreamriver website links have been moved to http://dreamriver.com/resources/whois.php & /resources/submit.php
END OF Version 1.06 UPGRADE	

	
November 03, 2000:
START OF VERSION 1.051 UPGRADE
Version Change from 1.05 to 1.051

	FILE			ACTION
	adminresult.php3	upgraded setRank functionality, extended FindARecord to 100 results, refined admin manage result order by
	yfadmin-record.php3	added yfcategory hidden variable, reformatted form
	4 files			added more categories. Affected yellowadd_form, yellowedit_form, yadmin-manage, ysearchagain. Deleted unused categories.
	yellowresult.php3	added 'ORDER BY yps DESC' to display the most recent listing first
END OF VERSION 1.051 UPGRADE	


October 26, 2000:
START OF VERSION 1.05 UPGRADE
Version Change from 1.042 to 1.05

	FILE				ACTION
	adminresult.php3		removed database close functions - also in most files
	util-dist.php3			added multiline commenting as a precaution
	yellowresult.php3		included test for magicquotes and if absent then use of addslashes() for insert and update
	yellowedit_form.php3      in cellular field
	yellowadd_form.php3		ditto
	admin.php3              phpinfo() added to Setup section
	phpinfo.php3			added
	yellowresult.php3		mail() 4th argument use: added mail headers: replyto, from, xmailer - tests great!
	easysql.php3			Re: EasySQL misreported result fix - deferred to future new app release
	all static viewable php re-optimized title, meta tags and first paragraph

How to Upgrade:
1. save a copy of your existing util.php3 file on your local machine
2. create a new directory on your local machine for the new phpYellow files
3. download and extract the new version upgrade files into your new directory
4. Paste your existing util.php3 file into util-dist.php3 : CONSTANTS only, everything above the '/* END OF CONSTANT DECLARATIONS */' line, 
5. Save the new util-dist.php3 as util.php3
6. ftp upload the new directory of files into your existing phpYellow installation, overwriting all existing files.
7. do a test add, edit, search and delete to make sure all is well- see your Admin module for support options
END OF VERSION 1.05 UPGRADE



October 13, 2000:
START OF VERSION 1.042 UPGRADE
Version Change from 1.041 to 1.042

FILE			ACTION

yfadmin-record		consolidated smart controls and formatted appearance
adminresult.php3	sql order by is now in descending order - newest listing is first
yellowresult.php3	added clickable update link in email notification sent to webmaster so you can get to edit new records more easily
admin.php3          	the admin link to changeLog.txt now points to the most recent copy on Dreamriver, not to the aging bundled distribution files
--->                	security.txt, install.txt, readme.txt reviewed and updated
--->                	added addslashes() and stripslashes() as needed to yellowgoal,yellowresult, adminresult.php3
util.php3           	modified function

Installation Note: when replacing util.php3 for this upgrade you only need to:
a) open util-dist.php3 
b) copy all the code starting where it says "// Web enabled version checking" up to and including the end of the file
c) paste the copied code into the corresponding section in util.php3 - essentially everything at the bottom
d) upload util.php3 and all the other files to the server.
END OF VERSION 1.042 UPGRADE



October 11, 2000:
START OF VERSION 1.041 UPGRADE
Version Change from 1.03 to 1.041
Version Note: this version fixes reported bugs of a serious nature in version 1.03. For details see below:

	FILE			ACTION
	adminresult.php3	removed one layer of data validation for user add, edit, delete and Administration Add, Edit and Delete
	yellowresult.php3	ditto, plus removed all quotemeta 
	util-dist.php3		updated the version number, modified the verify() function
	dev-mess.php3		rewrote developers message
END OF VERSION 1.041 UPGRADE



October 10, 2000:
START OF VERSION 1.03 UPGRADE
Version Change from 1.02 to 1.03
Version Note: this version is "mostly cosmetic". There were no reported bugs of a serious nature in version 1.02. See below for details:

	FILE			ACTION
	admin.php3		added "Setup" heading for table column, photo, and new Heading links and #photoTop named anchor
	all with submit buttons	added new .css class selector for colored submit buttons, removed select .css formnav classes in same
	yadmin-manage.php3	added #photoTop named anchor to page
	all viewable php files	upgraded and integrated the title, meta keyword and meta description html elements to improve search engine rankings
	yellow.css		created a new class selector and named it "ivory" - used first on admin.php3
	admin.php3		added a viewable version number under the "Support" heading so you know what version of phpYellow you have - without opening util.php3
	passwordresult.php3	deleted
	yellowgoal.php3		copied password processing into this for improved security, code review and cleanup
	adminresult.php3	code review and cleanup
	yellowresult.php3	code review and cleanup including use of quotemeta()
END OF VERSION 1.03 UPGRADE



September 26, 2000:
START OF VERSION 1.02 UPGRADE
Version Change from 1.01 to 1.02
Version Note: Version 1.02 is an enhancement version. There were no reported bugs in Version 1.01 to date

	FILE			ACTION
	:util-dist.php3		HOSTSERVER constant reset to "" to enable easysql.php3 to test for it
	:easysql.php3 		added
	:admin.php3 		added functionality for easysql including link
	:testdb.php3 		added link to easysql.php3
	:install.txt 		updated for easysql process

September 24, 2000
	FILE			ACTION
	: install.txt		added comments about customization of categories
	: admin.php3		made several cosmetic changes to text 
	: ysearchagain.php3	replaced all double quote marks with single quote marks in field values to assist in category customization, also added php comment to show where customization can start in each of the 4 files ysearchagain, yellowadd_form, yellowedit_form and yadmin-manage.php3
	: yellowadd_form.php3	ditto
	: yellowedit_form.php3	ditto
	: yadmin-manage.php3	ditto
	: admin-login.php3	javascript upgrade to set focus to form on body load
	: password.php3		ditto javascript upgrade
END OF VERSION 1.02 UPGRADE



September 21, 2000
START OF VERSION 1.01 UPGRADE
Version Change from 1.0 to 1.01

a) This version change fixed a results display problem with users searching phpYellow with Netscape browsers.
b) Minor cosmetic facelifts are included.
c) The fix for the delete bug as mentioned in the support forum is included.
d) Files affected: most files have been modified since the last version. A complete upgrade to the latest version is warranted. Complete this upgrade by ftping the newest files to your webserver.

NOTE: To avoid unnecessary work and to avoid overwriting your configuration util.php3 file, open it up and paste in this code block over the existing block:
// Web enabled version checking
define("PRODUCTNAME", "phpYellow"); // DO NOT CHANGE.
define("INSTALLVERSION", "1.01"); // DO NOT CHANGE.
// Reserved for Premium Yellow Service // DO NOT CHANGE.
// END OF CONSTANT DECLARATIONS

The only significant change to the util.php3 file is the version number, used in version checking. The current version number is 1.01 . This simple change in pasting the code block above saves you the time of rewriting the entire util.php3 configuration file on ftp upload. The remaining new files should, of course, also be uploaded.
END OF VERSION 1.01 UPGRADE 




// Preview Release Only - NOT INCLUDED IN ZIP FILE - under evaluation at http://www.dreamriver.com/phpYellow/
Start of Version 1.1 UPGRADE - PREVIEW RELEASE
Version Change from 1.1 to 1.12

	FILE				ACTION
	easysql.php			modified line 204 affected_rows function to use linkidentifier, not result, as changed in php release mysql_affected_rows
	util.php			addition and restructuring of constants to improve paid version
	tellAFriend.php		added
	yellow_edit.php		description field size change
	yellow_add.php		description field size change
	easysql.php			altered table to increase description to varchar(255)
	easysql.php			altered table field to: ycategory varchar(50) to allow larger categories
	yellow.js			suppressed fax, added better error handling
	backupTemplate.php	added NEW backup utility for Premium version
	backup.php			added
	admin.php			updated for new backup
	yellowadd_form.php	updated for multi category adds
	yellowresult.php	updated
	util-Premium.php	updated
	advertise.php		updated
// end of Preview Release changes


TODO LIST

There is nothing on the to do list.


WISH LIST


In your next version please include the listing first ie  then once they click on it, it take them to the deatails area! That way its its make easy to browse all the listing!


Can you custome make a copy of PHP-Yellowpages for me with a review this site feature and a 5 star, 
rate this site feature? if so can it be with a registration for visitors who then would place there 
comment and to be able to rate the site. as far as reviews...it would be e-mailed to the owner of 
the ad so that they can respond to the poster by e-mail. This feature should have cookies so that 
only one post per visitor. give the option of sending another image with a second ad, 


4. Add pager field

Editing:
1. Only display the one that you look for. This is a
special case. Normally, as a business owner, you only
own one or two businesses. However, when I do
database import, I have to assign them all to me.
Therefore I may own thousands of businesses and it
will be a long list to sort through. I have to go to
the back end, and edit it at the table level.

Interface:


3. Highlight the category that has new entries since
the last time (day/week)
4. Display the last time the business was updated (is
it in the lastupdate field of contact?)


Data model:
1. Add a field to records the business

Configuration:
1. business submittion should be on pending until
approved by administrator to prevent from bad entry.
It should be configurable when log in as admin.

Integration:




Is it possible to add more then
1 image to your "yellow page' script?

Ideally we would want to have paid listings
and a way for the client to make coupons
with your system..
like http://rlaj.com/scripts/bizdirectory/biz-dir.html


> 5.  Does it have business review feature?  I want user
> to be able to rate the company's service.


1) Create one function for updating feature listing in the ADMIN Option.

2) Create one table for register visitors (B2C) that want to receive emails campaign.

3) Create one function for sending emails campaign:
Visitors (B2C), Company (B2B).

4) user login cookies


	> What do you think about parsing data from a large yellow pages database like
    > Infousa?  Then adding the results after my results.  

> Offer during the installation process a list of (say 200) possible fields -
> with check box options - that the installer can select/deselect and then it
> writes the category list for them.  Just a thought.
> 
> Also, on the "wish list", I'd really LOVE to see sub-categories!

	Do you foresee a mass e-mail submit feature?? Would be great if the admin
could e-mail all non paying businesses, reminding them of premium options..

  I think it would be great to send out a reminder a
> week or so before ad expiration.

	
	
	subcategories
	possibility to change advertise.php3 and the fieldnames in the emails too?	
	email activation link for new listing submissions
	convert Premium version to Multilingual
	more separation between admin update from user update
	more gateway processor options

	user login cookies 
	database abstraction layer

END OF DOCUMENT

Docs Home | Read Me | FAQ | License | Security | Install | ChangeLog | Customize | Paid Listings

All Pages Copyright©2000,2001,2002 Dreamriver.com. All rights reserved.