diff options
author | markster <markster@f38db490-d61c-443f-a65b-d21fe96a405b> | 2004-04-26 05:08:30 +0000 |
---|---|---|
committer | markster <markster@f38db490-d61c-443f-a65b-d21fe96a405b> | 2004-04-26 05:08:30 +0000 |
commit | 42b6ac3b64682fa3d1bccf0cebc5f2645ddd082d (patch) | |
tree | 374b3286ae2b58274731b91fdbb945d259ca9f55 /channels/chan_iax.c | |
parent | 693599e4e3c5d1f205e08353631f14669c16d017 (diff) |
Clean up SQL queries (bug #1479)
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@2766 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'channels/chan_iax.c')
-rwxr-xr-x | channels/chan_iax.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/channels/chan_iax.c b/channels/chan_iax.c index 962c6ea31..af0f81ccb 100755 --- a/channels/chan_iax.c +++ b/channels/chan_iax.c @@ -1558,7 +1558,7 @@ static struct iax_peer *mysql_peer(char *peer) MYSQL_ROW rowval; name = alloca(strlen(peer) * 2 + 1); mysql_real_escape_string(mysql, name, peer, strlen(peer)); - snprintf(query, sizeof(query), "SELECT * FROM iax1friends WHERE name=\"%s\"", name); + snprintf(query, sizeof(query), "SELECT name, secret, context, ipaddr, port, regseconds FROM iax1friends WHERE name=\"%s\"", name); ast_mutex_lock(&mysqllock); mysql_query(mysql, query); if ((result = mysql_store_result(mysql))) { @@ -1626,7 +1626,7 @@ static struct iax_user *mysql_user(char *user) MYSQL_ROW rowval; name = alloca(strlen(user) * 2 + 1); mysql_real_escape_string(mysql, name, user, strlen(user)); - snprintf(query, sizeof(query), "SELECT * FROM iax1friends WHERE name=\"%s\"", name); + snprintf(query, sizeof(query), "SELECT name, secret, context, ipaddr, port, regseconds FROM iax1friends WHERE name=\"%s\"", name); ast_mutex_lock(&mysqllock); mysql_query(mysql, query); if ((result = mysql_store_result(mysql))) { |