Mercurial > hg > freeDiameter

comparison extensions/app_sip/app_sip.h @ 468:d20317e74a41

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
App_SIP: changed query length thanks to Julien Pichon contribution
author Alexandre Westfahl <awestfahl@freediameter.net>
date Mon, 02 Aug 2010 18:09:44 +0900
parents f38bff0bf3e9
children 95a784729cac
comparison
equal deleted inserted replaced
467:13443bde26ba 468:d20317e74a41
150 //Suscriber Locator 150 //Suscriber Locator
151 int app_sip_SL_LIR_cb( struct msg ** msg, struct avp * paramavp, struct session * sess, enum disp_action * act); 151 int app_sip_SL_LIR_cb( struct msg ** msg, struct avp * paramavp, struct session * sess, enum disp_action * act);
152 //int app_sip_SL_SAR_cb( struct msg ** msg, struct avp * paramavp, struct session * sess, enum disp_action * act); 152 //int app_sip_SL_SAR_cb( struct msg ** msg, struct avp * paramavp, struct session * sess, enum disp_action * act);
153 153
154 #define SQL_GETPASSWORD "SELECT `password` FROM ds_users WHERE `username` ='%s'" 154 #define SQL_GETPASSWORD "SELECT `password` FROM ds_users WHERE `username` ='%s'"
155 #define SQL_GETPASSWORD_LEN 52 155 #define SQL_GETPASSWORD_LEN sizeof(SQL_GETPASSWORD)-2
156 156
157 //username by SIP-AOR 157 //username by SIP-AOR
158 #define SQL_GETUSERNAME "SELECT `username` FROM ds_users, ds_sip_aor WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_user` = `ds_users`.`id_user`" 158 #define SQL_GETUSERNAME "SELECT `username` FROM ds_users, ds_sip_aor WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_user` = `ds_users`.`id_user`"
159 #define SQL_GETUSERNAME_LEN 113 159 #define SQL_GETUSERNAME_LEN sizeof(SQL_GETUSERNAME)-2
160 160
161 //sip server uri by username 161 //sip server uri by username
162 #define SQL_GETSIPURI "SELECT `sip_server_uri` FROM ds_users WHERE `username` ='%s'" 162 #define SQL_GETSIPURI "SELECT `sip_server_uri` FROM ds_users WHERE `username` ='%s'"
163 #define SQL_GETSIPURI_LEN 60 163 #define SQL_GETSIPURI_LEN sizeof(SQL_GETSIPURI)-2
164 164
165 //sip server uri by SIP-AOR 165 //sip server uri by SIP-AOR
166 #define SQL_GETSIPSERURI "SELECT `ds_sip_aor`.`sip_server_uri` FROM ds_users, ds_sip_aor WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_user` = `ds_users`.`id_user`" 166 #define SQL_GETSIPSERURI "SELECT `ds_sip_aor`.`sip_server_uri` FROM ds_users, ds_sip_aor WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_user` = `ds_users`.`id_user`"
167 #define SQL_GETSIPSERURI_LEN 132 167 #define SQL_GETSIPSERURI_LEN sizeof(SQL_GETSIPSERURI)-2
168 168
169 //sip capabilities for a SIP-AOR 169 //sip capabilities for a SIP-AOR
170 #define SQL_GETSIPSERCAP "SELECT `compulsory`,`id_service` FROM ds_user_services, ds_sip_aor WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_user` = `ds_user_services`.`id_user`" 170 #define SQL_GETSIPSERCAP "SELECT `compulsory`,`id_service` FROM ds_user_services, ds_sip_aor WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_user` = `ds_user_services`.`id_user`"
171 #define SQL_GETSIPSERCAP_LEN 144 171 #define SQL_GETSIPSERCAP_LEN sizeof(SQL_GETSIPSERCAP)-2
172 172
173 //user data for a user data supported 173 //user data for a user data supported
174 #define SQL_GETSIPDATA "SELECT `label_type`,`data` FROM ds_sip_aor, ds_user_data, ds_data_types WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_sip_aor` = `ds_user_data`.`id_sip_aor` AND `ds_data_types`.`id_data_type`=`ds_user_data`.`id_data_type`" 174 #define SQL_GETSIPDATA "SELECT `label_type`,`data` FROM ds_sip_aor, ds_user_data, ds_data_types WHERE `sip_aor` ='%s' AND `ds_sip_aor`.`id_sip_aor` = `ds_user_data`.`id_sip_aor` AND `ds_data_types`.`id_data_type`=`ds_user_data`.`id_data_type`"
175 #define SQL_GETSIPDATA_LEN 216 175 #define SQL_GETSIPDATA_LEN sizeof(SQL_GETSIPDATA)-2
176 176
177 #define SQL_GETDIAMURI "SELECT `sipserver_uri` FROM ds_sip_aor_map WHERE `sip_aor` ='%s'" 177 #define SQL_GETDIAMURI "SELECT `sipserver_uri` FROM ds_sip_aor_map WHERE `sip_aor` ='%s'"
178 #define SQL_GETDIAMURI_LEN 61 178 #define SQL_GETDIAMURI_LEN sizeof(SQL_GETDIAMURI)-2
179 179
180 //networks for this user 180 //networks for this user
181 #define SQL_GETUSERNET "SELECT `label_network` FROM ds_users, ds_user_networks, ds_networks WHERE `ds_users`.`username` ='%s' AND `ds_user_networks`.`id_user` = `ds_users`.`id_user` AND `ds_user_networks`.`id_network` = `ds_networks`.`id_network`" 181 #define SQL_GETUSERNET "SELECT `label_network` FROM ds_users, ds_user_networks, ds_networks WHERE `ds_users`.`username` ='%s' AND `ds_user_networks`.`id_user` = `ds_users`.`id_user` AND `ds_user_networks`.`id_network` = `ds_networks`.`id_network`"
182 #define SQL_GETUSERNET_LEN 220 182 #define SQL_GETUSERNET_LEN sizeof(SQL_GETUSERNET)-2
183 183
184 #define SQL_SETSIPURI "UPDATE ds_users SET `temp_sip_server_uri`='%s' WHERE `username` ='%s'" 184 #define SQL_SETSIPURI "UPDATE ds_users SET `temp_sip_server_uri`='%s' WHERE `username` ='%s'"
185 #define SQL_SETSIPURI_LEN 65 185 #define SQL_SETSIPURI_LEN sizeof(SQL_SETSIPURI)-4
186 186
187 //TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO 187 //TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO
188 #define SQL_RMSIPURI "UPDATE ds_users SET `temp_sip_server_uri`='', `sip_server_uri`='' WHERE `id_user` ='%s'" 188 #define SQL_RMSIPURI "UPDATE ds_users SET `temp_sip_server_uri`='', `sip_server_uri`='' WHERE `id_user` ='%s'"
189 #define SQL_RMSIPURI_LEN 65 189 #define SQL_RMSIPURI_LEN sizeof(SQL_RMSIPURI)-2
190 //TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO 190 //TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO
191 191
192 #define SQL_SETREALSIPURI "UPDATE ds_users SET `sip_server_uri`='%s' WHERE `username` ='%s'" 192 #define SQL_SETREALSIPURI "UPDATE ds_users SET `sip_server_uri`='%s' WHERE `username` ='%s'"
193 #define SQL_SETREALSIPURI_LEN 65 193 #define SQL_SETREALSIPURI_LEN sizeof(SQL_SETREALSIPURI)-4
194 194
195 #define SQL_SETFLAG "UPDATE ds_users SET `authentication_pending`=1 WHERE `username` ='%s'" 195 #define SQL_SETFLAG "UPDATE ds_users SET `authentication_pending`=1 WHERE `username` ='%s'"
196 #define SQL_SETFLAG_LEN 67 196 #define SQL_SETFLAG_LEN sizeof(SQL_SETFLAG)-2
197 197
198 #define SQL_CLEARFLAG "UPDATE ds_users SET `authentication_pending`=0, `registrated`=1 WHERE `username` ='%s'" 198 #define SQL_CLEARFLAG "UPDATE ds_users SET `authentication_pending`=0, `registrated`=1 WHERE `username` ='%s'"
199 #define SQL_CLEARFLAG_LEN 84 199 #define SQL_CLEARFLAG_LEN sizeof(SQL_CLEARFLAG)-2
200 200
201 #define SQL_GETSIPAOR "SELECT `sip_aor` FROM `ds_sip_aor`, `ds_users` WHERE `ds_sip_aor`.`id_user` = `ds_users`.`id_user` AND `ds_users`.`username` = '%s'" 201 #define SQL_GETSIPAOR "SELECT `sip_aor` FROM `ds_sip_aor`, `ds_users` WHERE `ds_sip_aor`.`id_user` = `ds_users`.`id_user` AND `ds_users`.`username` = '%s'"
202 #define SQL_GETSIPAOR_LEN 131 202 #define SQL_GETSIPAOR_LEN sizeof(SQL_GETSIPAOR)-2
203 203
204 //#define SQL_CLEARFLAG "UPDATE ds_users SET `authentication_pending`=0 WHERE `username` ='%s'" 204 //#define SQL_CLEARFLAG "UPDATE ds_users SET `authentication_pending`=0 WHERE `username` ='%s'"
205 //#define SQL_CLEARFLAG_LEN 67 205 //#define SQL_CLEARFLAG_LEN 67
206 206
207 extern struct session_handler * ds_sess_hdl; 207 extern struct session_handler * ds_sess_hdl;
"Welcome to our mercurial repository"