/[LeafOK_CVS]/lbbs/src/database.c
ViewVC logotype

Diff of /lbbs/src/database.c

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.8 by sysadm, Mon Apr 28 12:45:57 2025 UTC Revision 1.11 by sysadm, Sun May 4 14:54:55 2025 UTC
# Line 16  Line 16 
16   ***************************************************************************/   ***************************************************************************/
17    
18  #include "common.h"  #include "common.h"
19    #include "database.h"
20    #include "log.h"
21  #include <mysql.h>  #include <mysql.h>
22  #include <stdio.h>  #include <stdio.h>
23    
24  MYSQL *  // Global declaration for database
25  db_open()  char DB_host[256];
26    char DB_username[50];
27    char DB_password[50];
28    char DB_database[50];
29    char DB_timezone[50];
30    
31    MYSQL *db_open()
32  {  {
33          MYSQL *db;          MYSQL *db;
34          char sql[1024];          char sql[SQL_BUFFER_LEN];
35    
36          db = mysql_init(NULL);          db = mysql_init(NULL);
37          if (db == NULL)          if (db == NULL)
# Line 47  db_open() Line 55  db_open()
55          }          }
56    
57          sprintf(sql,          sprintf(sql,
58                  "SET time_zone = '%s'",                          "SET time_zone = '%s'",
59                  DB_timezone);                          DB_timezone);
60    
61          if (mysql_query(db, sql) != 0)          if (mysql_query(db, sql) != 0)
62          {          {

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1