<?php if (!isset($__fd3_backend__inc__php)) { $__fd3_backend__inc__php=1;

 include 'db.inc.php';
 include 'util.inc.php';

 /* finds a domain ID based on a domain name: */
 function find_domain ($domainname) {
  $cd=db_make_query('select id from web_domains where domain=%s limit 1',array(
   array('type'=>'string','value'=>$domainname)
  ));
  if ($res=db_next_row($cd)) return $res['id'];
 return NULL; };

 /* returns a domain record (id,web_id,domain,desc) from the ID: */
 function get_domain ($id) {
  $cd=db_q_select('*','web_domains','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds a domain: */
 function set_domain ($id,$webid,$domain,$desc) {
  if ($id==NULL) {
   $cd=db_q_insert('web_domains','web_id,domain,description','%s,%s,%s','',array(
    db_qa_qumk($webid),db_qa_qumk($domain),db_qa_qumk($desc)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update web_domains set web_id=%s, domain=%s, description=%s where id=%s',
   array(
    db_qa_qumk($webid),
    db_qa_qumk($domain),
    db_qa_qumk($desc),
    db_qa_qumk($id),
  ));
  if (db_query($cd)) return $id;
 return NULL; };

 /* deletes a domain: */
 function del_domain ($id) {
  $cd=db_make_query('delete from web_domains where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 /* convenience function to translate a domain into its Web's ID: */
 function domain2web ($domain) { $temp=find_domain($domain);
  if (!empty($temp)) $temp=get_domain($temp); else return NULL;
 return $temp['web_id']; };

 /* returns a Web record (id,dealer_id,desc): */
 function get_web ($id) {
  $cd=db_q_select('*','webs','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 function set_web ($id,$dealer_id,$desc) {
  if ($id==NULL) {
   $cd=db_q_insert('webs','dealer_id,description','%s,%s','',array(
    db_qa_qumk($dealer_id),db_qa_qumk($desc)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update webs set dealer_id=%s, description=%s where id=%s',
   array(
    db_qa_qumk($dealer_id),
    db_qa_qumk($desc),
    db_qa_qumk($id),
  ));
  if (db_query($cd)) return $id;
  //FIXME: need to put case for existing Web
 return NULL; };

 /* deletes a web: */
 function del_web ($id) {
  $cd=db_make_query('delete from webs where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function web2dealer ($web) {
  $temp=get_web($web); if (empty($temp)) return NULL;
 return $temp['dealer_id']; };

 function domain2dealer ($domainname) {
 return web2dealer(domain2web($domainname)); };

 /* returns a dealer record
  *  (id,manning_id,group_id,name,domain,admin_password):
  */
 function get_dealer ($id) {
  $cd=db_q_select('*','dealers','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 function set_dealer ($id,$manning,$group,$name,$domain,$adminpw) {
  if ($id==NULL) {
   $cd=db_q_insert(
    'dealers','manning_id,group_id,name,domain,admin_password','%s,%s,%s,%s,%s',
    '',array(
     db_qa_qumk($manning),db_qa_qumk($group),
     db_qa_qumk($name),db_qa_qumk($domain),db_qa_qumk($adminpw)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update dealers set manning_id=%s, group_id=%s, name=%s, domain=%s, admin_password=%s  where id=%s',
   array(
    db_qa_qumk($manning),
    db_qa_qumk($group),
    db_qa_qumk($name),
    db_qa_qumk($domain),
    db_qa_qumk($adminpw),
    db_qa_qumk($id),
  ));
  if (db_query($cd)) return $id;
  //FIXME: need to put case for existing dealer
 return NULL; };

 /* deletes a dealer: */
 function del_dealer ($id) {
  $cd=db_make_query('delete from dealers where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function dealer2manning ($dealer) {
  $temp=get_dealer($dealer); if (empty($temp)) return NULL;
 return $temp['manning_id']; };

 /* returns a Manning record (id,name,domain,admin_password): */ function
 get_manning ($id) {
  $cd=db_q_select('*','mannings','id=%s','',db_qaa_qumk($id)); if
  ($res=db_next_row($cd)) return $res;
 return NULL; };

 function set_manning ($id,$name,$domain,$adminpw) {
  if ($id==NULL) {
   $cd=db_q_insert('mannings','name,domain,admin_password','%s,%s,%s','',array(
    db_qa_qumk($name),db_qa_qumk($domain),db_qa_qumk($adminpw)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update mannings set name=%s, domain=%s, admin_password=%s where id=%s',
   array(
    db_qa_qumk($name),
    db_qa_qumk($domain),
    db_qa_qumk($adminpw),
    db_qa_qumk($id),
  ));
  if (db_query($cd)) return $id;
  //FIXME: need to put case for existing Manning
 return NULL; };

 /* deletes a manning: */
 function del_manning ($id) {
  $cd=db_make_query('delete from mannings where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 /* returns a page record (id,web_id,filename,parent_id,template_id): */
 function get_page ($id) {
  $cd=db_q_select('*','pages','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 function set_page ($id,$web_id,$filename,$parent_id,$template_id) {
  if ($id==NULL) {
   $cd=db_q_insert('pages','web_id,filename,parent_id,template_id','%s,%s,%s,%s',
    '',array(
     db_qa_qumk($web_id),db_qa_qumk($filename),db_qa_qumk($parent_id),
     db_qa_qumk($template_id)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update pages set web_id=%s, filename=%s, parent_id=%s, template_id=%s where id=%s',
   array(
    db_qa_qumk($web_id),
    db_qa_qumk($filename),
    db_qa_qumk($parent_id),
    db_qa_qumk($template_id),
    db_qa_qumk($id),
  ));
  if (db_query($cd)) return $id;
  //FIXME: need to put case for existing page
 return NULL; };

 /* deletes a page: */
 function del_page ($id) {
  $cd=db_make_query('delete from pages where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function find_page ($web_id,$filename,$parent_id) {
  $cd=db_q_select(
   'id','pages','web_id=%s and filename=%s and parent_id %s %s','',array(
    db_qa_qumk($web_id),
    db_qa_qumk($filename),
    array('type'=>'literal','value'=>($parent_id===NULL?'is':'=')),
    db_qa_qumk($parent_id),
  ));
  if ($res=db_next_row($cd)) return $res['id'];
  //If we can't find the exact page we're looking for, look for a default page:
  $cd=db_q_select(
   'id','pages','web_id=%s and filename is null and parent_id %s %s','',array(
    db_qa_qumk($web_id),
    array('type'=>'literal','value'=>($parent_id===NULL?'is':'=')),
    db_qa_qumk($parent_id),
  ));
  if ($res=db_next_row($cd)) return $res['id'];
 return NULL; };

 function webpath2page ($web_id,$path) {
  if (!is_array($path)) {
   preg_replace('|//|','/',$path);
   preg_replace('|^/|','',$path);
   preg_replace('|/$|','',$path);
   $path=explode('/',$path);
  };
  $parent_id=NULL;
  for ($x=0; $x<count($path); $x++) {
   $component=$path[$x];
   if ($id=find_page($web_id,$component,$parent_id)) $parent_id=$id;
   else { $path_info=array();
    while ($x<count($path)) array_push($path_info,$path[$x++]);
   return array($parent_id,$path_info,$component,$path); };
  };
 return array($id,'',$component,$path); };

 /* returns a template record (id,dealer_id,data): */
 function get_template ($id) {
  $cd=db_q_select('*','templates','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 function set_template ($id,$dealer_id,$data,$contenttype,$templatetype) {
  if ($id==NULL) {
   $cd=db_q_insert('templates','dealer_id,data,contenttype,templatetype','%s,%s,%s,%s','',array(
    db_qa_qumk($dealer_id),db_qa_qumk($data),db_qa_qumk($contenttype),db_qa_qumk($templatetype)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update templates set dealer_id=%s, data=%s, contenttype=%s, templatetype=%s where id=%s',
   array(db_qa_qumk($dealer_id),db_qa_qumk($data),db_qa_qumk($contenttype),db_qa_qumk($templatetype),db_qa_qumk($id))
  );
  if (db_query($cd)) return $id;
 return NULL; };

 /* deletes a template: */
 function del_template ($id) {
  $cd=db_make_query('delete from templates where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function vhostpath2page ($vhost,$path) {
  if ($web=domain2web($vhost)); else return NULL;
 return webpath2page($web,$path); };

 function webpath2template ($web_id,$path) {
  if ($ret=webpath2page($web_id,$path)); else return NULL;
 $page=get_page($ret[0]); return array($page['template_id'],$ret[1],$ret[2],$ret[3]); };

 function vhostpath2template ($vhost,$path) {
  if ($ret=vhostpath2page($vhost,$path)); else return NULL;
 $page=get_page($ret[0]); return array($page['template_id'],$ret[1],$ret[2],$ret[3]); };

 function webpath2templatedata ($web_id,$path) {
  if ($ret=webpath2template($web_id,$path)); else return NULL;
  $tmpl=get_template($ret[0]);
  return array(
   $tmpl['data'],$ret[1],$ret[2],$ret[3],
 $tmpl['contenttype'],$tmpl['templatetype']); };

 function vhostpath2templatedata ($vhost,$path) {
  if ($ret=vhostpath2template($vhost,$path)); else return NULL;
 $tmpl=get_template($ret[0]); return array($tmpl['data'],$ret[1],$ret[2],$ret[3]); };

 /* returns a feed record (id,name,pulling_script,loading_script): */
 function get_feed ($id) {
  $cd=db_q_select('*','feeds','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 function set_feed ($id,$name,$pulling_script,$loading_script) {
  if ($id==NULL) {
   $cd=db_q_insert('feeds','name,pulling_script,loading_script','%s,%s,%s','',array(
    db_qa_qumk($name),db_qa_qumk($pulling_script),db_qa_qumk($loading_script)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_make_query(
   'update feeds set name=%s, pulling_script=%s, loading_script=%s where id=%s',
   array(db_qa_qumk($name),db_qa_qumk($pulling_script),db_qa_qumk($loading_script))
  );
  if (db_query($cd)) return $id;
 return NULL; };

 /* deletes a feed: */
 function del_feed ($id) {
  $cd=db_make_query('delete from feeds where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function get_dealer_feed ($id) {
  $cd=db_q_select('*','dealer_feeds','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds a dealer_feed: */
 function set_dealer_feed ($id,$dealer_id,$feed_id,$id_in_feed,$priority_new,$priority_used) {
  if ($id==NULL) {
   $cd=db_q_insert('dealer_feeds','dealer_id,feed_id,id_in_feed,priority_new,priority_used','%s,%s,%s,%s,%s','',array(
    db_qa_qumk($dealer_id),db_qa_qumk($feed_id),db_qa_qumk($id_in_feed),db_qa_qumk($priority_new),db_qa_qumk($priority_used)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_q_update('dealer_feeds','dealer_id,feed_id,id_in_feed,priority_new,priority_used','%s,%s,%s,%s,%s',$id,'',array(
   db_qa_qumk($dealer_id),db_qa_qumk($feed_id),db_qa_qumk($id_in_feed),db_qa_qumk($priority_new),db_qa_qumk($priority_used)
  ));
  if ($cd) return $id;
 return NULL; };

 /* deletes a dealer_feed: */
 function del_dealer_feed ($id) {
  $cd=db_make_query('delete from dealer_feeds where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function get_vehicle ($id) {
  $cd=db_q_select('*','vehicles','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds a vehicle: */
 function set_vehicle ($id,$vin,$year,$make,$model) {
  if ($id==NULL) {
   $cd=db_q_insert('vehicles','vin,year,make,model','%s,%s,%s,%s','',array(
    db_qa_qumk($vin),db_qa_qumk($year),db_qa_qumk($make),db_qa_qumk($model)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_q_update('vehicles','vin,year,make,model','%s,%s,%s,%s',$id,'',array(
   db_qa_qumk($vin),db_qa_qumk($year),db_qa_qumk($make),db_qa_qumk($model)
  ));
  if ($cd) return $id;
 return NULL; };

 /* deletes a vehicle: */
 function del_vehicle ($id) {
  $cd=db_make_query('delete from vehicles where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function get_inventory ($id) {
  $cd=db_q_select('*','inventory','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds an inventory item: */
 function set_inventory ($id,$dealer_id,$feed_id,$priority,$vehicle_id) {
  if ($id==NULL) {
   $cd=db_q_insert(
    'inventory','dealer_id,feed_id,priority,vehicle_id','%s,%s,%s,%s','',array(
     db_qa_qumk($dealer_id),db_qa_qumk($feed_id),db_qa_qumk($priority),
     db_qa_qumk($vehicle_id),
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_q_update(
   'inventory','dealer_id,feed_id,priority,vehicle_id','%s,%s,%s,%s',$id,'',
   array(
    db_qa_qumk($dealer_id),db_qa_qumk($feed_id),db_qa_qumk($priority),
    db_qa_qumk($vehicle_id),
  ));
  if ($cd) return $id;
 return NULL; };

 /* deletes a inventory: */
 function del_inventory ($id) {
  $cd=db_make_query('delete from inventory where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function get_inventory_images ($id) {
  $cd=db_q_select('*','inventory_images','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds a inventory image: */
 function set_inventory_image ($id,$inventory_id,$dealer_feed_id,$priority,$data) {
  if ($id==NULL) {
   $cd=db_q_insert('inventory_images','inventory_id,dealer_feed_id,priority,data','%s,%s,%s,%s','',array(
    db_qa_qumk($inventory_id),db_qa_qumk($dealer_feed_id),db_qa_qumk($priority),db_qa_qumk($data)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_q_update('inventory_images','inventory_id,dealer_feed_id,priority,data','%s,%s,%s,%s',$id,'',array(
   db_qa_qumk($inventory_id),db_qa_qumk($dealer_feed_id),db_qa_qumk($priority),db_qa_qumk($data),db_qa_qumk($id)
  ));
  if ($cd) return $id;
 return NULL; };

 /* deletes a inventory image: */
 function del_inventory_image ($id) {
  $cd=db_make_query('delete from inventory_images where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function get_inventory_log ($id) {
  $cd=db_q_select('*','inventory_log','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds a inventory log: */
 function set_inventory_log ($id,$queue_timestamp,$proc_timestamp,$dealer_id,$dealer_feed_id,$priority,$action,$oldvehicle_id,$newvehicle_id) {
  if ($id==NULL) {
   $cd=db_q_insert('inventory_log','queue_timestamp,proc_timestamp,dealer_id,dealer_feed_id,priority,action,oldvehicle_id,newvehicle_id','%s,%s,%s,%s,%s,%s,%s,%s','',array(
    db_qa_qumk($queue_timestamp),db_qa_qumk($proc_timestamp),db_qa_qumk($dealer_id),db_qa_qumk($dealer_feed_id),db_qa_qumk($priority),db_qa_qumk($action),db_qa_qumk($oldvehicle_id),db_qa_qumk($newvehicle_id)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_q_update('inventory_log','queue_timestamp,proc_timestamp,dealer_id,dealer_feed_id,priority,action,oldvehicle_id,newvehicle_id','%s,%s,%s,%s,%s,%s,%s,%s',$id,'',array(
   db_qa_qumk($queue_timestamp),db_qa_qumk($proc_timestamp),db_qa_qumk($dealer_id),db_qa_qumk($dealer_feed_id),db_qa_qumk($priority),db_qa_qumk($action),db_qa_qumk($oldvehicle_id),db_qa_qumk($newvehicle_id),db_qa_qumk($id)
  ));
  if ($cd) return $id;
 return NULL; };

 /* deletes a inventory log: */
 function del_inventory_log ($id) {
  $cd=db_make_query('delete from inventory_log where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 function get_inventory_queue ($id) {
  $cd=db_q_select('*','inventory_queue','id=%s','',db_qaa_qumk($id));
  if ($res=db_next_row($cd)) return $res;
 return NULL; };

 /* updates/adds an inventory queue: */
 function set_inventory_queue ($id,$log_id) {
  if ($id==NULL) {
   $cd=db_q_insert(
    'inventory_queue','log_id','%s','',array(
     db_qa_qumk($log_id)
   ));
   if ($cd) return db_insert_id($cd);
  return NULL; };
  $cd=db_q_update(
   'inventory_queue','log_id','%s',$id,'',
   array(
    db_qa_qumk($log_id),
    db_qa_qumk($id),
  ));
  if ($cd) return $id;
 return NULL; };

 /* deletes a inventory_queue: */
 function del_inventory_queue ($id) {
  $cd=db_make_query('delete from inventory_queue where id=%s',db_qaa_qumk($id));
  if (db_query($cd)) return $id;
 return NULL; };

 /* This function attempts to make sense out of the gazillion different types
  *  of users (including all the implicit ones, etc.) in the system.
  * It returns an associative array:
  *  (role,account_id,uid,pass)
  */
 function find_user ($user,$dom) {
  if (empty($user) || empty($dom)) return NULL;
  $cd=db_q_select(
  'id,admin_password','mannings','domain = %s','',db_qaa_qumk($dom));
  if ($cd && (($row=db_next_row($cd))!=NULL))
   if ($user == 'admin') return array(
    'role'=>'manning','account_id'=>$row['id'],'uid'=>0,
    'pass'=>$row['admin_password'],
   ); else return NULL;
  $cd=db_q_select(
  'id,admin_password','dealers','domain = %s','',db_qaa_qumk($dom));
  if ($cd && (($row=db_next_row($cd))!=NULL))
   if ($user == 'admin') return array(
    'role'=>'dealer','account_id'=>$row['id'],'uid'=>0,
    'pass'=>$row['admin_password'],
   ); else return NULL;
 return NULL; };

}; ?>