Welcome page
Products
Ozeki 10
SMS
Ozeki NG SMS Gateway
Message Server 6
On-line manual
Introduction
SMS technology
MMS technology
About
Product features
Installation guide
Server
Prerequisites
Installation steps
Product Activation
Server Preferences
Drivers
Plugins
Colour SMS
Database (SQL)
ODBC configuration
Service account
Microsoft-SQL
Backward compatibility
MyODBC driver
Files
HTTP Client
PHP
POP3/SMTP connection
POP3
SMTP
TCP/IP
Appstarter
Autoreply
Tester
User accounts
Upgrade
Server port
Clients
System maintenance
User guide
Developers guide
Case studies
Appendix
Download
Home
Support
How to buy
SMS Wall
IP SMS Gateway
Android SMS
Excel SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Technology
Company


On-line manual:
  Explore all the features in this On-line HTML documentation of Ozeki Message Server 6.

Product guide:
  Download Ozeki Message Server 6 Manual in PDF format. This PDF guide explains all the features of Ozeki Message Server 6.
Ozeki Message Server 6
Microsoft-SQL Microsoft-SQL | MyODBC driver MyODBC driver

SQL PLUGIN BACKWARD COMPATIBILITY

Ozeki Message Server is ready to handle various message types. It uses a different database structure than its predecessor. In order to achieve backward compatibility to the Ozeki SMS Server, in the database plugin you must replace the SQL statements. The replacement can be done on the Database Plugin Configuration Form. On this form you can find the SQL statements, that are written in blue on this webpage. Replace these statements to the statements written in black.

select id,receiver,msg,operator,msgtype from ozekimessageout where status='send'
select id,receiver,msg,operator,'GSMSMS' from ozekismsout where status='send'

update ozekimessageout set status='sent' where id='$id'
update ozekismsout set status='sent' where id='$id'

update ozekimessageout set status='transmitted',senttime='$senttime' where id='$id'
update ozekismsout set status='transmitted',senttime='$senttime' where id='$id'

update ozekimessageout set status='deleted' where id='$id'
update ozekismsout set status='deleted' where id='$id'

update ozekimessageout set status='received',receivedtime='$recvtime' where id='$id'
update ozekismsout set status='received',receivedtime='$recvtime' where id='$id'


insert into ozekimessagein (operator,sender,receiver,msg,senttime,receivedtime,msgtype) values ('$operator',
'$sender','$receiver','$msg','$senttime','$receivedtime','$msgtype')
insert into ozekismsin (operator,sender,receiver,msg,senttime,receivedtime)
values ('$operator','$sender','$receiver','$msg','$senttime','$receivedtime')

Copyright © 2000- - Ozeki Ltd | info@ozeki.hu | Tel: +36 1 371 0150
Home > Products > SMS > Message Server 6 > On-line manual > Installation guide > Server > Plugins > Database (SQL) > Backward compatibility
Legal | Privacy policy | Terms of use
Page: 421 | Login | 3.80.177.176