OsCommerce member directory

Our website ([login to view URL]) is a membership based association of purebred dog breeders, rescuers and responsible pet owners based in Australia. We have a need for a directory of our breeder and rescue members where they can say a few words about themselves, show a photo or two of their dogs and provide contact details. Each member’s page will be template based, with basic information extracted from existing fields of the customers table. First and last names, email address, state etc etc. will be automatically entered into the appropriate area of the template. Each member must be able to choose whether or not to be included in this directory while applying for membership at catalog/create_account.php. This choice can then be altered in their own catalog/[login to view URL] page. A simple “yes” or “no” choice must be provided. I will add this option to both pages prior to the work on the new directory being commenced. The successful bidder will then have to incorporate the choice into the search function of the directory and show only members that have opted in. (See attached flowchart) In addition, each member’s page must be able to be updated/added to by the members themselves (Through a link in their catalog/[login to view URL] page) to add additional information and photos. Obviously this “update” page must be closed to all but the member. Any area of the template already populated from the customers table can be altered by existing facilities to edit this information in catalog/[login to view URL] so there is no need to allow for this facility. Only additional information/photos need to be catered for. A limit on the number of characters and size/number of photos can be imposed so as not to break the template. The template itself however, must look “finished” with or without any additional information from the member. The editing function that our members use to edit their listing must be WYSIWYG and have the means to upload photos from their hard drive. I am investigating the contribution “tinyMCE Anywhere” ([login to view URL],4852) and if this helps I will install this contribution. Or discuss alternatives. Furthermore, from time to time our members will want to announce via their listing that puppies are available and/or a rescue dog or mature age retired breeding dog is available for adoption. We will have to accommodate this need, possibly via an icon(s) that can be activated by the individual member. An excellent example of the type of directory envisioned can be seen at [login to view URL] We are looking for the same basic functions…not a carbon copy. Our site uses Member_Approval_v1.6 ([login to view URL],2062) This creates a field in the customers table called member_level. Default value is 0 which equals “Not Approved”. We can change this to 1 (= approved) in admin. The member is unable to log in until this is done. As the information for each members page of the new directory is automatically in the database upon application and before approval, it is important that the page itself is not made public unless the value in the field member_level in table_customers = 1 It might be advantageous to offer two or three different templates to accommodate specific needs of rescuers vs. breeders. Our site uses SPPC 4.1.6 ([login to view URL],716) to group our members into categories. It does this via another field in table_customers called group_id. Specific values have been allocated for breeder members, rescue members and breeder/rescue members. I would like to listen to suggestions and discuss options on how best to accommodate this requirement with the successful bidder. I have attached a flow chart to better illustrate the various requirements better. One of the most time consuming tasks in this project is the opening page. Just typing out almost 200 dog breeds is laborious. Fortunately, the basic structure has been done and can be viewed at [login to view URL] . I will forward the catalog and catalog/includes/languages/english/ versions to the successful bidder. I have put a preferential budget on this project of $US100. But if this is not realistic, I invite feedback. I therefore have listed it as $100 to $300 99% of this project does not require modifications to existing OsC pages. A link in catalog/[login to view URL] and another link to the opening page of the directory is all that comes to mind. It should be a free standing module. I will provide FTP access to a test site so you needn’t worry about working on a live site, and I will run any SQL scripts you request. Lastly, I would like to follow existing OsC guidelines as I have become quite comfortable with editing OsC pages and would like to be able to do the same with this project. At a future time we would like to add the facility for our members to create and edit their own personal pages, linked from their directory listing. This is “Wish-List” material right now but having a eye to future expansion at this point may assist us when the time comes.