From ef2ebfc6da2dac054af7dfe206bf1ea9906435ea Mon Sep 17 00:00:00 2001 From: skotlex Date: Tue, 12 Sep 2006 21:30:03 +0000 Subject: - Improved sql-query to check if name already exists when creating new chars. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8727 54d463be-8e91-2dee-dedb-b68131a5f0ec --- src/char_sql/char.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/char_sql/char.c b/src/char_sql/char.c index cb0ebba89..2ffc16e9b 100644 --- a/src/char_sql/char.c +++ b/src/char_sql/char.c @@ -1390,7 +1390,7 @@ int make_new_char_sql(int fd, unsigned char *dat) { // fd, dat[30], dat, dat[24], dat[25], dat[26], dat[27], dat[28], dat[29], dat[33], dat[31]); //Check Name (already in use?) - sprintf(tmp_sql, "SELECT `name` FROM `%s` WHERE `name` = '%s'",char_db, t_name); + sprintf(tmp_sql, "SELECT 1 FROM `%s` WHERE `name` = '%s'",char_db, t_name); if (mysql_query(&mysql_handle, tmp_sql)) { ShowSQL("DB error - %s\n",mysql_error(&mysql_handle)); ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql); -- cgit v1.2.3-70-g09d2