Changeset 468:d20317e74a41 in freeDiameter
- Timestamp:
- Aug 2, 2010, 6:09:44 PM (14 years ago)
- Branch:
- default
- Phase:
- public
- Location:
- extensions/app_sip
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/app_sip/TODO
r427 r468 35 35 *********************************************************************************************************/ 36 36 37 Diameter-SIP implementation is still under development. 37 38 38 39 TODO List … … 40 41 * when getting results from mysql, check lenght 41 42 * sort capabilities in LIR/LIA 42 * remove warnings in SIP plugin for gateway43 43 * make functions for database access in MAR/MAA 44 44 * order diamsip.h because it's becoming a mess ^^ … … 49 49 * add mutex on mysql writing 50 50 * check multithreading of mysql! 51 * get destination host in database for RTR and PPR 51 52 52 53 -
extensions/app_sip/app_sip.h
r440 r468 153 153 154 154 #define SQL_GETPASSWORD "SELECT `password` FROM ds_users WHERE `username` ='%s'" 155 #define SQL_GETPASSWORD_LEN 52155 #define SQL_GETPASSWORD_LEN sizeof(SQL_GETPASSWORD)-2 156 156 157 157 //username by SIP-AOR 158 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 113159 #define SQL_GETUSERNAME_LEN sizeof(SQL_GETUSERNAME)-2 160 160 161 161 //sip server uri by username 162 162 #define SQL_GETSIPURI "SELECT `sip_server_uri` FROM ds_users WHERE `username` ='%s'" 163 #define SQL_GETSIPURI_LEN 60163 #define SQL_GETSIPURI_LEN sizeof(SQL_GETSIPURI)-2 164 164 165 165 //sip server uri by SIP-AOR 166 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 132167 #define SQL_GETSIPSERURI_LEN sizeof(SQL_GETSIPSERURI)-2 168 168 169 169 //sip capabilities for a SIP-AOR 170 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 144171 #define SQL_GETSIPSERCAP_LEN sizeof(SQL_GETSIPSERCAP)-2 172 172 173 173 //user data for a user data supported 174 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 216175 #define SQL_GETSIPDATA_LEN sizeof(SQL_GETSIPDATA)-2 176 176 177 177 #define SQL_GETDIAMURI "SELECT `sipserver_uri` FROM ds_sip_aor_map WHERE `sip_aor` ='%s'" 178 #define SQL_GETDIAMURI_LEN 61178 #define SQL_GETDIAMURI_LEN sizeof(SQL_GETDIAMURI)-2 179 179 180 180 //networks for this user 181 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 220182 #define SQL_GETUSERNET_LEN sizeof(SQL_GETUSERNET)-2 183 183 184 184 #define SQL_SETSIPURI "UPDATE ds_users SET `temp_sip_server_uri`='%s' WHERE `username` ='%s'" 185 #define SQL_SETSIPURI_LEN 65185 #define SQL_SETSIPURI_LEN sizeof(SQL_SETSIPURI)-4 186 186 187 187 //TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO 188 188 #define SQL_RMSIPURI "UPDATE ds_users SET `temp_sip_server_uri`='', `sip_server_uri`='' WHERE `id_user` ='%s'" 189 #define SQL_RMSIPURI_LEN 65189 #define SQL_RMSIPURI_LEN sizeof(SQL_RMSIPURI)-2 190 190 //TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO TODO 191 191 192 192 #define SQL_SETREALSIPURI "UPDATE ds_users SET `sip_server_uri`='%s' WHERE `username` ='%s'" 193 #define SQL_SETREALSIPURI_LEN 65193 #define SQL_SETREALSIPURI_LEN sizeof(SQL_SETREALSIPURI)-4 194 194 195 195 #define SQL_SETFLAG "UPDATE ds_users SET `authentication_pending`=1 WHERE `username` ='%s'" 196 #define SQL_SETFLAG_LEN 67196 #define SQL_SETFLAG_LEN sizeof(SQL_SETFLAG)-2 197 197 198 198 #define SQL_CLEARFLAG "UPDATE ds_users SET `authentication_pending`=0, `registrated`=1 WHERE `username` ='%s'" 199 #define SQL_CLEARFLAG_LEN 84199 #define SQL_CLEARFLAG_LEN sizeof(SQL_CLEARFLAG)-2 200 200 201 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 131202 #define SQL_GETSIPAOR_LEN sizeof(SQL_GETSIPAOR)-2 203 203 204 204 //#define SQL_CLEARFLAG "UPDATE ds_users SET `authentication_pending`=0 WHERE `username` ='%s'"
Note: See TracChangeset
for help on using the changeset viewer.