bgui/bugs/bugs_msql.php

   1 <?
   2 /*
   3  * bugs_msql.php
   4  *
   5  * @(#) $Header$
   6  *
   7  */
   8
   9 class bugs_msql_class
  10 {
  11         var $database_hostname="";
  12         var $database_connection=0;
  13
  14         Function Connect($database_name)
  15         {
  16                 global $bugs_database_host,$bugs_debug;
  17
  18                 if($this->database_connection!=0)
  19                 {
  20                         $bugs_debug("The connection to the bugs database is already established!\n");
  21                         return(0);
  22                 }
  23                 if(($this->database_connection=msql_pconnect($this->database_hostname))<=0)
  24                 {
  25                         $bugs_debug("It was not possible to connect to the bugs database! (".msql_error().")\n");
  26                         return(0);
  27                 }
  28                 msql_select_db($database_name,$this->database_connection);
  29                 return($this->database_connection);
  30         }
  31
  32         Function Query($query)
  33         {
  34                 global $bugs_debug;
  35
  36                 if($this->database_connection<=0)
  37                         $bugs_debug("The connection to the bugs database is not yet established!\n");
  38                 return(msql_query($query,$this->database_connection));
  39         }
  40
  41         Function Error()
  42         {
  43                 return(msql_error());
  44         }
  45
  46         Function CreateDatabase($name)
  47         {
  48                 if($this->database_connection==0)
  49                 {
  50                         if($this->database_hostname=="")
  51                                 $link=msql_Connect();
  52                         else
  53                                 $link=msql_Connect($this->database_hostname);
  54                         if($link==0)
  55                                 return(0);
  56                 }
  57                 else
  58                         $link=$this->database_connection;
  59                 $success=msql_create_db($name,$link);
  60                 if($this->database_connection==0)
  61                         msql_Close($link);
  62                 return($success);
  63         }
  64
  65         Function Close()
  66         {
  67                 if($this->database_connection!=0)
  68                 {
  69                         msql_Close($this->database_connection);
  70                         $this->database_connection=0;
  71                 }
  72         }
  73
  74         Function SeparateDateTime()
  75         {
  76                 return(1);
  77         }
  78
  79         Function DateFormat()
  80         {
  81                 return("d-M-Y");
  82         }
  83
  84         Function ScanDate($date)
  85         {
  86                 $scanned_date["day"]=strtok($date,"-");
  87                 $scanned_date["month"]=strtok("-");
  88                 $scanned_date["year"]=strtok(" ");
  89                 return($scanned_date);
  90         }
  91         Function TextFieldsNeedLength()
  92         {
  93                 return(1);
  94         }
  95
  96         Function SupportAutoIncrement()
  97         {
  98                 return(0);
  99         }
 100
 101         Function SupportSequences()
 102         {
 103                 return(0);
 104         }
 105
 106         Function NumberOfRows($result)
 107         {
 108                 return(msql_num_rows($result));
 109         }
 110
 111         Function FreeResult($result)
 112         {
 113                 return(msql_free_result($result));
 114         }
 115
 116         Function FetchNextRow($result)
 117         {
 118                 return(msql_fetch_row($result));
 119         }
 120
 121         Function NumberOfFields($result)
 122         {
 123                 return(msql_num_fields($result));
 124         }
 125
 126         Function FetchNextField($result)
 127         {
 128                 return(msql_fetch_field($result));
 129         }
 130
 131         Function FetchArray($result)
 132         {
 133                 return(msql_fetch_array($result));
 134         }
 135
 136         Function FetchResult($result,$row,$field)
 137         {
 138                 return(msql_result($result,$row,$field));
 139         }
 140 };
 141
 142 ?>