Multilanguage Windows application to manage the products of your OsCommerce virtual store from your desktop computer.
Great addon to OsC. Should continue on!
Modified the opm_BitBtn_UploadSelectFileClick procedure in askupload.pas to create the opmT_OpenPictureDialog object inside a TRY EXCEPT block. Modified function FNopm_CheckLanguage in dataman.pas to enclose the TStringList creation inside a TRY EXCEPT block. Reorganized the Image tab options in the Configuration window (config.pas and config.dfm) to include new watermarking options. The new options are Watermarking enable/disable, Watermark blend level, and Watermark image file. Added supporting code to config.pas. This is part of the fix of Bug #273. Updated FreeImage interface unit (freeimage.pas) to support the following FreeImage functions: FreeImage_ConvertToGreyscale, FreeImage_GetChannel, FreeImage_SetChannel, FreeImage_Invert, FreeImage_Composite and FreeImage_AdjustBrightness. This is part of the fix of Bug #273. Added new function FNopm_WatermarkImage2 to imageman.pas unit, to add a watermark to a given image file. This is part of the fix of Bug #273. Added supporting code to oscpmdata.pas, main.pas and pedit.pas units to support the new watermarking options. This is part of the fix of Bug #273.
Modified all waiting loops that use GetTickCount, so we detect now if GetTickCount overflows and its value is wrapped to zero. This would happen in the computer have a 49.7 days uptime. This fix prevents a 49-days loop if the waiting loop is running while the Windows counter is wrapped. This is part of the fix of Bug #322. Modified values of the default connections timeouts and retries for the HTTP connections (opmC_Def_HTTPConnWait, opmC_Def_ModConnRetries, opmC_Def_HTTPConnRetries) in oscpmdata.pas so retries are 2 and timeout to 5 seconds (from 5 and 15, respectively). Changed opmC_WebScriptOKCode to MVOSCPM1_NOERROR and opmC_WebScriptERRORCode to MVOSCPM1_ERROR in oscpmdata.pas. Added constant opmC_DefErrorDataLen to oscpmdata.pas which declares the lenght of the extract from the returned data to report when an error is detected. This is to be able to show the raw error messages from the server-side script. Added ImageURL field to opmR_Category, opmR_SingleCategory and opmR_Manufacturer record types. Increased the server-side script version number from 0.9.5 to 0.9.6. Added opm_ok_string variable (set to MVOSCPM1_NOERROR) and opm_error_string variable (set to MVOSCPM1_ERROR) in oscpmdata.pas; to be used for the returned headers and error messages. Modified all messages to use these variables. Modified the DBQUERY operation code block in server-side script (oscpm1_upload.php) to check for errors in the recordset returned by opm_FNExec_Query and return an error message or the recordset to the client. Previously, if an error was detected, the OK header was sent anyway and the client assumed the data was correct. Modified opm_FNExec_Query function in server-side script (oscpm1_upload.php) to check for errors in the SQL query. If an error was detected, the returned data was not a recordset, but the error message from the MySQL server. Added function fopm_dberror to server-side script (oscpm1_upload.php) to retrieve the latest error message and code number from the MySQL server. To be used when reporting in opm_FNExec_Query. Modified FNopm_FullRemoteError function in network.pas to return an extract from of given lenght from the global opmG_HTTPClient_TransactLog variable, to try to report the raw error message in the HTTP stream. Also, added the 2200 type error message (SQL query error). Also, modified the function to report the error number if the error is unknown. Modified FNopm_WebDB_Query function in network.pas to handle the error conditions from FNopm_Unserial_DBQuery or the server-side script. Modified FNopm_Unserial_DBQuery function in network.pas to check the count of record-start and record-end tags. If the count are not equal, the data is assumed to be corrupted. Modified all calls to FNopm_FullRemoteError to include the new second parameter in main.pas, pedit.pas and currencyman.pas. Modified PRopm_LoadCategoryList, PRopm_LoadManufacturerList, PRopm_LoadLanguageList, PRopm_LoadProductListByCat, PRopm_LoadTaxList, PRopm_LoadConfigList to check for the return-code of FNopm_WebDB_Query and report any error condition to the user. Previously, any error condition was silently ignored. Updated German translation with files by Dennis Lehnen (lehnen NOSPAM gebrauchte-kinderkleidung.de). Updated all translation files with new (untranslated) strings.
Added option to server-side script (oscpm1_upload.php) to store the SQL recordsets to in the log file (opm_enable_recordsetlog). Added code to server-side script for iterative hashing of the authentication credentials hashing the previously resulting hash with the salt (default to 100 cycles) for key stregthening. This is part of the fix of Bug #301. Increased the server-side script version number from 0.9.2 to 0.9.5. Added detection of missing timestamp to the server-side script. Changed the record-level integrity checksum in the recordsets returned by the server-side script. Previously we used a CRC32 checksum, not we use a MD5 hash. (The reason was that CRC32 in PHP doesn't return the same result in 32 and 64-bits platforms. Added FNopm_TimeStamp function to dataman.pas to create a timestamp which includes milliseconds. To be used to create timestamps for the server-side queries. Added FNopm_HashCredentials function to network.pas to hash and salt iteratively the authentication credentials (default to 100 cycles) for key stregthening. This is part of the fix of Bug #301. Added some missing error codes and messages to FNopm_FullRemoteError function in network.pas.. Added corruption-detection to FNopm_Unserial_DBQuery function in network.pas. Each record is checked for integrity using the MD5 hashing received with each record. If the integrity fails for one record, the whole recordset is deleted and an error result code is returned. Added code to FNopm_WebDB_Query in network.pas to handle the corruption-detected result code. Added the name of the store to the header of printed reports (main.pas). Updated German translation with files by Dennis Lehnen (lehnen NOSPAM gebrauchte-kinderkleidung.de). Updated all translation files with new (untranslated) strings. Modify server-side script to return "OSCSTANDARD" with the CAPA operation. Modify the About window (about.pas) to display the name of the currently connected store along with the capabilities listing. Fixed the Configuration window (config.dfm), correcting the hint of the opm_SpinEdit_ConfigHTTPConnRetries control. Added data structures to oscpmdata.pas to support the loading of the osCommerce store configuration options (opmR_Config record, opmT_ConfigList array, opmG_ConfigList and opm_TotalConfig). Added variable opmG_CurrentStoreName to oscpmdata.pas to store the currently connected osCommerce store name. This is part of the fix of Bug #95. Modified PRopm_RenderCategoryDisplay procedure in main.pas to set the first node label to the name of the current store. This is part of the fix of Bug #95. Added PRopm_LoadConfigList procedure to main.pas to load the configuration options of the osCommerce store into the opmG_ConfigList array. Added call to this function in opm_MenuItem_ConnectClick, opm_MenuItem_RefreshCategoriesClick, opm_ComboBox_DisplayLangSelect procedures. Fixed opm_MenuItem_ConnectClick procedure to set the OSCSTANDARD capability. Updated German translation with files by Dennis Lehnen (lehnen NOSPAM gebrauchte-kinderkleidung.de). Updated Spanish translation. Updated doc/license.txt file to add notes about new linked packages and removing obsoleted comments. (The body is still the same GNU GPL license).
Increased the script version number from 0.8.9 to 0.9.0. Minor spelling errors fixed. Added TABLES operation to retrieve the available database tables. This is part of the fix of Bug #344. Deleted the last tab of the Configuration windows (Database tables) as it is no longer needed (now the application retrieves automatically the tables names). Deleted all supporting code for the controls in that tab. This is part of the fix of Bug #344. Modified the About window (about.dfm and about.pas) so that the frame where the capabilities detected in the current store are displayed, now it is a scrollable memo field containing both the capabilities codes and the list of detected database table names. This is part of the fix of Bug #344. Modified oscpmdata.pas to have a new list for the database tables in the current connection (opmG_DBTableList). Other minor fixes. Added FNopm_LoadTableNames function to main.pas to load the database table names from the server-side script. Added a call to this function from procedure opm_MenuItem_ConnectClick in main.pas, just after the CAPA operation request. Added code to clear the database list at opm_MenuItem_DisconnectClick and PRopm_ResetServerVars procedures. Deleted obsolete code that supported the previous manually-configured database table names. This is part of the fix of Bug #344. Added Hungarian translation provided by Bojer Tibor (lecroix NOSPAM freemail.hu). Added Polish translation provided by Wojtek Kokot (verner NOSPAM op.pl). Added Romanian translation provided by Adrian Gramescu (adrian.gramescu NOSPAM smartexpres.ro). Updated Russian translation files by Shmelev N. Nikolai (aerograf NOSPAM rambler.ru). Increased the server-side script version number from 0.9.0 to 0.9.2. Added low-level database functions (fopm_dbconnect, fopm_dbquery, fopm_dbfetchrow, fopm_dblastid) to the server-side script, so that now we provide compatibility with ZenCart again (as we now don't depend on the functions from osCommerce or ZenCart). This functions are from our PHP development library. Disabled the inclusion of the osCommerce database functions (includes/functions/database.php) as we provide our own. This is part of the fix of Bug #336. Added ZenCart detection to CAPA operation in the server-side script. Now unused but we may use it later to provide ZenCart-specific support. Deleted unused table constants to the TABLE operation code in the server-side script. Fixed wrong URL for the homepage in the About windows (about.pas). Also, added code to show ZenCart detected when using a ZenCart store. Added code to main.pas and oscpmdata.pas to support the detection of ZenCart stores.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?