reply(getTextBot(), user, "NS_INVALID_CHANNEL_NAME", argv[0]);
return;
}
- printf_mysql_query("SELECT `botid` FROM `bot_channels` LEFT JOIN `bots` ON `bot_channels`.`botid` = `bots`.`id` WHERE `chanid` = '%d' AND `botclass` = '%d'", chan->channel_id, client->botid);
+ printf_mysql_query("SELECT `botid` FROM `bot_channels` LEFT JOIN `bots` ON `bot_channels`.`botid` = `bots`.`id` LEFT JOIN `channels` ON `bot_channels`.`chanid` = `channels`.`channel_id` WHERE `channel_name` = '%s' AND `botclass` = '%d'", escape_string(channel), client->botid);
res = mysql_use();
if ((row = mysql_fetch_row(res)) != NULL) {
reply(getTextBot(), user, "NS_REGISTER_ALREADY", argv[0], client->user->nick);
if(argv[1][0] == '*') {
//we've got an auth
argv[1]++;
- printf_mysql_query("SELECT `user_user` FROM `users` WHERE `user_user` = '%s'", escape_string(argv[0]));
+ printf_mysql_query("SELECT `user_user` FROM `users` WHERE `user_user` = '%s'", escape_string(argv[1]));
res = mysql_use();
if ((row = mysql_fetch_row(res)) != NULL) {
neonserv_cmd_register_async1(client, getTextBot(), user, chan, event, channel, row[0]);