lbbs/src/database.c

/***************************************************************************
                                                 database.c  -  description
                                                         -------------------
        begin                : Mon Oct 11 2004
        copyright            : (C) 2004 by Leaflet
        email                : leaflet@leafok.com
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#include "common.h"
#include "log.h"
#include <mysql.h>
#include <stdio.h>

MYSQL *
db_open()
{
        MYSQL *db;
        char sql[1024];

        db = mysql_init(NULL);
        if (db == NULL)
        {
                log_error("mysql_init() failed\n");
                return NULL;
        }

        db = mysql_real_connect(db, DB_host, DB_username, DB_password, DB_database,
                                                        0, NULL, 0);
        if (db == NULL)
        {
                log_error("mysql_connect() failed\n");
                return NULL;
        }

        if (mysql_set_character_set(db, "gb2312") != 0)
        {
                log_error("Set character set failed\n");
                return NULL;
        }

        sprintf(sql,
                "SET time_zone = '%s'",
                DB_timezone);

        if (mysql_query(db, sql) != 0)
        {
                log_error("Set timezone failed\n");
                return NULL;
        }

        return db;
}
1	sysadm	1.1	/***************************************************************************
2	sysadm	1.7	database.c - description
3			-------------------
4			begin : Mon Oct 11 2004
5			copyright : (C) 2004 by Leaflet
6			email : leaflet@leafok.com
7	sysadm	1.1	***************************************************************************/
8
9			/***************************************************************************
10			* *
11			* This program is free software; you can redistribute it and/or modify *
12			* it under the terms of the GNU General Public License as published by *
13			* the Free Software Foundation; either version 2 of the License, or *
14			* (at your option) any later version. *
15			* *
16			***************************************************************************/
17
18			#include "common.h"
19	sysadm	1.9	#include "log.h"
20	sysadm	1.3	#include <mysql.h>
21			#include <stdio.h>
22	sysadm	1.1
23			MYSQL *
24	sysadm	1.7	db_open()
25	sysadm	1.1	{
26	sysadm	1.7	MYSQL *db;
27	sysadm	1.8	char sql[1024];
28	sysadm	1.5
29	sysadm	1.7	db = mysql_init(NULL);
30			if (db == NULL)
31			{
32			log_error("mysql_init() failed\n");
33			return NULL;
34			}
35
36			db = mysql_real_connect(db, DB_host, DB_username, DB_password, DB_database,
37			0, NULL, 0);
38			if (db == NULL)
39			{
40			log_error("mysql_connect() failed\n");
41			return NULL;
42			}
43
44	sysadm	1.8	if (mysql_set_character_set(db, "gb2312") != 0)
45	sysadm	1.7	{
46	sysadm	1.8	log_error("Set character set failed\n");
47	sysadm	1.7	return NULL;
48			}
49
50	sysadm	1.8	sprintf(sql,
51			"SET time_zone = '%s'",
52			DB_timezone);
53
54			if (mysql_query(db, sql) != 0)
55	sysadm	1.7	{
56	sysadm	1.8	log_error("Set timezone failed\n");
57	sysadm	1.7	return NULL;
58			}
59	sysadm	1.6
60	sysadm	1.7	return db;
61	sysadm	1.1	}
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1