event_neonserv_quit.c

   1
   2 static void neonserv_event_quit(struct UserNode *user, char *reason) {
   3     MYSQL_RES *res;
   4     MYSQL_ROW chanuserrow;
   5     struct ChanUser *chanuser;
   6     if((user->flags & USERFLAG_ISAUTHED)) {
   7         for(chanuser = getUserChannels(user, NULL); chanuser; chanuser = getUserChannels(user, chanuser)) {
   8             printf_mysql_query("SELECT `chanuser_id` FROM `chanusers` LEFT JOIN `users` ON `chanuser_uid` = `user_id` LEFT JOIN `channels` ON `chanuser_cid` = `channel_id` WHERE `channel_name` = '%s' AND `user_user` = '%s'", escape_string(chanuser->chan->name), escape_string(user->auth));
   9             res = mysql_use();
  10             if((chanuserrow = mysql_fetch_row(res)) != NULL)
  11                 printf_mysql_query("UPDATE `chanusers` SET `chanuser_seen` = UNIX_TIMESTAMP() WHERE `chanuser_id` = '%s'", chanuserrow[0]);
  12         }
  13     }
  14 }