Custom Realestate Webcatalog System | 0x8 Projects

Project: kkbkk / Thailandhomesearch
Owner: Serena Property Co., Ltd. Production URL: www.serena.co.th \| www.kkbkk.com Project URL: http://src.0x8.in.th/Static/Projects/eqs/kkbkk/ths_new/do Status: *idle*

Overview

Completly Database Driven Real-estate-Agent System
Webbased, to manage and control all propertys, find most public items
and most interested property type and location based on groups, Price and user Activity.

Features

easy to manage (no pc,net or html knowledge needed)
easy to update (no grafic knowledge or software needed)
searchengine friendly links
for better pageranks
fulltext search-engine (customers)
Browseing by requirements and features
features and Pictures Database
No files or grafix at webspace
pictures autoresizing
and storage in SQL Database (keep origials)
tracking-System for search requests and search types
tracking for search zero-matches
including to Microsoft Sharepoint-Systems
pageview and picture access-counter
(statistic reasons and visible in admin-mode)
search query statistics ..
with "Human Readable reason output"
backofficesearch for "zero matches"
MS Sharepoint integration (MS Sharepoint example)

Minimum Requirements

Apache 1.3.8
imagemagic 4
php4.3
mysql 3.1

Changelog

26 Mar 2008 Minor bugfixes .. visible issues
link for "original Picture" on detail pages

24 Mar 2008 alter and hiding of "garage-data"

23 Mar 2008 Cleanup of Detailpages
Fixed calculations for currencys
export currency-settings to ~/currency.php

Feb 2008 Localizing with GEO-Database
Visitors become redirected to host near the location.
primary and management host: http://www.serena.co.th/

Jan 2008 Splithosting on 3 Servers on hosts: serenaproperty.com, kkbkk.com, serena.co.th

Version ?? ~~There where a few changes from a 3rd party coder ... where is no track avaiable~~

Version 0.33++ - url-switchover to kkbkk.com
(all service urls and direct links hardcoded to kkbkk.com)
- faster Picture resizing at CA-2
- splitting database and automatic backups
- logfile analytics

Version 0.33 - show defaultpicture as first if loading show.php
- stats.php updated to virtualhost urls
- added Defailt picture value
- show default pictures in search results (thumbnail)

Version 0.32 - directly InQuery while browsing objects
- sql change: ths_log varchar(254) -> TEXT
(search strings are longer as expected)
- Spelling Corrections
- bugfix find.phpsearch range 20k-40k

Version 0.31 - autocalculated serchmatches in stats.php
- log.php (sows off WHAT the ppl searching for)
- tracking for zero-matches
- including to SPS system eqsbkk-office

Version 0.30 - tracking-System for search requests and search types
- some Spelling Corrections

Version 0.26 - Logtable to track useractions (like serchrequests)
- version-Number only visible if logged in
- zero search-results apologize-page (find.php)
- changed insert by using agend
- insert field "hits" in ths_obj (hitcounting)
- insert statistics part in show.php
- if admin-loggedin .. he will notice it (colorchange) ;-)
- bugfix: Updatetime/user update in propedit.php

Version 0.25.1 - major Bugfixes
adding saleprice-field
adding editpages
agend update (variable propertytypes)

Version 0.25 - HUGE Performance benefit by grep-binary data
- bugfix: implode(): Bad arguments. find.php on line 46 by empty search.
- Pulldown AND input field for Locationchoice (agent)
- change to Checkboxes in find.php (for count of bedrooms)
- small grafix and rendering tweaks (showup pix)
- rearrange tablestructure

Version 0.24 - change find.php to : type AND bedrooms AND Budget AND
(bts OR mrt OR expressway) AND (location OR location)
- Add New Objects By Wizzard
- re"fine" searchsystem

Version 0.23.1+ (EXTREM BETA) - Showing access-pix after admin-login
- some spelling corrections
- selectable "bedrooms" in find.php
automatic provide real aviable values
- better view for the admin-menu
- ingrease db-performance .. (need to update to MySQL 4 anyway)

Version 0.23 (EXTREM BETA) (version-jump because too much junk deleted ;-))
- Icon-feature in "Key features list" (realy nonsense ;-) i know)
allow to define a "icon" to show in the Aviable features list
instead of the "checked-icon"
- database Cleanup
Delete all the old crap
- backup mechanism for db-entrys (not running yet)

Version 0.21 (EXTREM BETA) - fulltext search-engine (searches in `description`,`title`,`adress`,`city`,`location`)
- parted search (features and locations)
Features hardcoded in cnt/find.php)
- directmatch Redirection
- completly own management system
- variable contentdesign
- new databasestructure
- pageview and picture access-counter (statistic reasons and visible in admin-mode) (later)
- picture storage in database (nothing at filesystem)
- automatic resizing in 2 subsizes and storage of the original picture in SQL database

ALL Documentation and brainstorming at:
http://sps.office.eqsbkk.com/Thailand-Home-Search/ (only from EQ-Intranet)