extern  "C" {
  double ist_price_ip(UDF_INIT *initid, UDF_ARGS *args,
                            char*result, unsigned long *res_length, 
                            char *null_value, char *error);      
} 

my_bool ist_price_ip_init(UDF_INIT *initid, UDF_ARGS *args, char* message)      {                             
  if((args->arg_count >  1 ) || (args->arg_type[ 0 ] != REAL_RESULT))
  {
    strcpy(message, "Wrong arguments to ist_price_ip!" );
    return( 1 );
  }
  MYSQL *conn;
  conn = mysql_init(NULL);
  if(!conn)
    return( 1 );
  if(!mysql_real_connect(conn, HOST_NAME, USER_NAME, 
                                USER_PASSWORD, DB_NAME,  0 ,NULL, 0 )) 
      return( 1 );
  if(mysql_select_db(conn,DB_NAME))
      return( 1 ); 
  initid->max_length =  8 ;
  initid->decimals =  2 ;
  initid->ptr = (char*)conn;
    return  0 ;          
}
double ist_price_ip(UDF_INIT *initid, UDF_ARGS *args, char *result,
                         unsigned long *res_length, char *null_value, char *error)
{
  MYSQL* conn = (MYSQL*)initid->ptr;
  MYSQL_RES* myresult;
  MYSQL_ROW row;
  double dTemp;
  string query =  "SELECT fkey FROM ClientDB.TLogin WHERE flogin='mad'" ;
  mysql_query(conn,query.c_str());
  myresult = mysql_store_result(conn);
  if(row = mysql_fetch_row(myresult))
  {
    dTemp = static_cast<double>(atoi(row[ 0 ]));
  }
  mysql_free_result(myresult);
  return (dTemp);
}                                                                                                              

void ist_price_ip_deinit(UDF_INIT *initid)
{
  mysql_close((MYSQL*)initid->ptr);
}