File: SqlFuncProc/SqlFunc/sqlsrv_get_users.sql

Recommend this page to a friend!
  Classes of Andras Toth   Call Me   SqlFuncProc/SqlFunc/sqlsrv_get_users.sql   Download  
File: SqlFuncProc/SqlFunc/sqlsrv_get_users.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Call Me
Establish video chat communications between users
Author: By
Last change: MSSQL Server Database support

add new sql scripts for mssql support,
modified some function in SqlFuncProc php for automatic database
selection,
add links for download pages
Date: 2 years ago
Size: 261 bytes
 

Contents

Class file image Download 
SELECT [id], [name], [email], [pass], [peer_id], CONVERT(VARCHAR(MAX), [img], 3) COLLATE SQL_Latin1_General_CP1_CS_AS AS [img], [updated] FROM [callme_users] 
WHERE ([name] LIKE ? OR [email] LIKE ?) AND [pass] LIKE ? AND [id] <>  ? 
ORDER BY [name], [updated] ;