From 42b6ac3b64682fa3d1bccf0cebc5f2645ddd082d Mon Sep 17 00:00:00 2001 From: markster Date: Mon, 26 Apr 2004 05:08:30 +0000 Subject: Clean up SQL queries (bug #1479) git-svn-id: http://svn.digium.com/svn/asterisk/trunk@2766 f38db490-d61c-443f-a65b-d21fe96a405b --- channels/chan_iax.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'channels/chan_iax.c') 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))) { -- cgit v1.2.3