banner.jpg
Web Development and Tools Powered by WebSellerTM

 

Home

Tips
  Umlauts/UTF-8
  Normalization
  OemToAnsi
  MySQL Import
  Site Search
  City Desk
  DynDNS
  MXLookup
  SPAM

SDT

Support
  Downloads
  Contact Us

Impressum

German

RSS Feed

Site search:

Web Search

Made with CityDesk


Configuration file


SqlDBU is driven by setup file sqldbu.ini. It has been developed as an Add On for the WebSeller ONLINE Shop (Standard Edition, Open Source and Professional Release) but it can be customized to support every MySQL Database with it's tables and relations by editing the mentioned setup file. Layout and content of each column can be customized by defining  appropriate sections, e.g. [DEMO.CHANGED]. Without any definition column demo.CHANGED will be displayed like follows:

Default look of Column CHANGED

It contains time and date of the last change in Unix time format (long integer), which can be changed for a better and more descriptive layout differently for
Browse and Form View like follows:

[DEMO.CHANGED]
CAPTION=Last Change
BROWSEVIEW=<!---(FROM_UNIXTIME(-CHANGED-))--->
FORMVIEW=<input type="text" value="<!---(FROM_UNIXTIME(-CHANGED-))--->"

Now these values can be recognized as date/time information much more likely.

Customized look of column CHANGED

 

CAPTION can be substituted by ENG and GER in order to support more then one languages, e.g English and German:   

[DEMO.CHANGED]
ENG=Last Change
GER=Letzte Änderung
BROWSEVIEW=<!---(FROM_UNIXTIME(-CHANGED-))--->
FORMVIEW=<input type="text" value="<!---(FROM_UNIXTIME(-CHANGED-))--->"

Note: ENG and GER are determined by value admin.LANGUAGE. In other words the current language is a property (column) of table admin, which contains all user data like LOGIN, LAST, FIRST, EMAIL PASSWORD etc. LANGUAGE is defined as ENUM( 'ger', 'eng' ) and can be extended by other languages too. 

Back