现在系统总发邮件给我,说
From bbs@debian.workgroup Thu Oct 18 22:02:03 2007
Return-path: <bbs@debian.workgroup>
Envelope-to: bbs@debian.workgroup
Delivery-date: Thu, 18 Oct 2007 22:02:03 +0800
Received: from bbs by debian.workgroup with local (Exim 4.63)
(envelope-from <bbs@debian.workgroup>)
id 1IiVwp-0000nz-QM
for bbs@debian.workgroup; Thu, 18 Oct 2007 22:02:03 +0800
From: root@debian.workgroup (Cron Daemon)
To: bbs@debian.workgroup
Subject: Cron <bbs@debian> /home/bbs/bin/bonlinelog
Content-Type: text/plain; charset=ANSI_X3.4-1968
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin>
X-Cron-Env: <MAILTO=bbs>
X-Cron-Env: <BBSHOME=/home/bbs>
X-Cron-Env: <HOME=/home/bbs>
X-Cron-Env: <LOGNAME=bbs>
Message-Id: <E1IiVwp-0000nz-QM@debian.workgroup>
Date: Thu, 18 Oct 2007 22:02:03 +0800
No database selected
No database selected
No database selected
No database selected
No database selected
No database selected
No database selected
我看了一下bonlinelog的代码,里面有语句要往bonline表里面插入数据:
int fillbcache(struct boardheader *fptr,int idx,void* arg)
{
int bnum;
struct BoardStatus * bs;
char sql[500];
if (check_see_perm(NULL, fptr)==0 || strlen(fptr->filename) == 0)
return 0;
bnum = getbid(fptr->filename,NULL);
bs = getbstatus(bnum);
sprintf(sql, "INSERT INTO bonline VALUES ( NULL, '%s', '%d', '%d', \"%d-%d-%d\", '%d', '%d' );",
fptr->filename, bs->currentusers, bs->nowid,
t.tm_year+1900, t.tm_mon+1, t.tm_mday, t.tm_hour, t.tm_min/6);
if( mysql_real_query( &s, sql, strlen(sql) ))
printf("%s\n",mysql_error(&s));
return 0;
}
请问大侠,如何在mysql里建表,还有KBS用mysql的话,要建什么名字的数据库?
--
FROM 60.191.126.*