2 * nbtscanner -- a tool for scanning large networks for SMB servers.
4 * mysql_interface.c: Interface routines for the MySQL table.
5 * Copyright (C) 2000 Steinar H. Gunderson
7 * Large amounts of code adapted from Samba (http://www.samba.org/)
8 * Copyright (C) Andrew Tridgell 1994-1998, and others.
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 2 of the License, or
13 * (at your option) any later version.
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
20 * You should have received a copy of the GNU General Public License
21 * along with this program; if not, write to the Free Software
22 * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
30 #include "mysql_interface.h"
31 #include "configfile.h"
35 /* veeeery detailed error reporting here ;-) */
36 void init_mysql(char *host, char *username, char *password)
38 if (mysql != NULL) return; /* hack */
40 mysql = mysql_init(NULL);
43 fprintf(stderr, "mysql_init() failed\n");
48 if (mysql_real_connect(mysql, mysql_host, username, password, "nbtscanner",
51 fprintf(stderr, "mysql_real_connect() failed\n");
57 void add_record_mysql(char *ip, char *hostname, char *fileservername, char *groupname,
61 char hname[256], fsname[256], gname[256];
63 mysql_real_escape_string(mysql, hname, hostname, strlen(hostname));
64 mysql_real_escape_string(mysql, fsname, fileservername, strlen(fileservername));
65 mysql_real_escape_string(mysql, gname, groupname, strlen(groupname));
68 "REPLACE INTO nbtscanner.nbtscanner SET ip='%s', hostname='%s', fileservername='%s', groupname='%s', active='y', lastactive=now(), messenger='%c';",
69 ip, hname, fsname, gname, messenger);
71 if (mysql_query(mysql, query) != 0) {
73 fprintf(stderr, "mysql_query(`%s') failed\n", query);
79 void delete_record_mysql(char *ip)
83 "UPDATE nbtscanner.nbtscanner SET ACTIVE='n' WHERE ip='%s';",
86 if (mysql_query(mysql, query) != 0) {
88 fprintf(stderr, "mysql_query(`%s') failed\n", query);
94 void print_all_records_mysql()
97 unsigned long *lengths;
98 unsigned int num_fields;
102 snprintf(query, 512, "SELECT ip,(CASE WHEN fileservername='-unknown-nbtscanner-' THEN hostname ELSE fileservername END),groupname,(fileservername <> '-unknown-nbtscanner-') FROM nbtscanner.nbtscanner WHERE active='y' OR lastactive>DATE_SUB(NOW(), INTERVAL %d SECOND);",
105 if (mysql_query(mysql, query) != 0) {
106 if (verbosity >= 1) {
107 fprintf(stderr, "mysql_query('SELECT ip'...) failed\n");
112 result = mysql_store_result(mysql);
113 if (result == NULL) {
114 if (verbosity >= 1) {
115 fprintf(stderr, "mysql_store_result() failed\n");
120 num_fields = mysql_num_fields(result);
122 MYSQL_ROW row = mysql_fetch_row(result);
123 if (row == NULL) return;
125 lengths = mysql_fetch_lengths(result);
127 for (i = 0; i < num_fields; i++) {
130 /* strip away CR/LFs */
131 for (j = 0; j < lengths[i]; j++) {
132 if (row[i][j] == 0 || row[i][j] == 10 || row[i][j] == 13 || row[i][j] == ',') {
136 printf("%.*s", (int) lengths[i], row[i] ? row[i] : "NULL");
137 if (i != num_fields - 1) printf(",");
145 /* don't care if this fails */
146 mysql_query(mysql, "OPTIMIZE TABLE nbtscanner.nbtscanner;");