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') 

More information