8:00 – 4:00 SR

• Still no admin.
• Need to add checks for http(s):// in the freeform text. If it’s there, open the url, if it’s not then send to GoogleNews
• I think the best way to get the results from the network queries is to take the raw rows from the server and parse them into graphical network data. I will need to add variables for id_index and type (table at least, maybe more)
• Query for all items on a network with labels synthesized from id_index and type name:

  -- get all the items in a network
  select ti.id_index, ti.guid, ti.item_type, ty.name as type_name, CONCAT(ty.name, '_', ti.id_index) as label, ti.text, ti.float_val, ti.link, ti.image
  from tn_network_data dat 
  inner join tn_associations a on dat.assoc_id = a.id_index
  inner join tn_items ti on a.target_id = ti.id_index
  inner join tn_types ty on ty.id_index = ti.item_type
  where dat.network_id = 1
  union
  select si.id_index, si.guid, si.item_type, ty.name as type_name, CONCAT(ty.name, '_', si.id_index) as label, si.text, si.float_val, si.link, si.image
  from tn_network_data dat 
  inner join tn_associations a on dat.assoc_id = a.id_index
  inner join tn_items si on a.source_id = si.id_index
  inner join tn_types ty on ty.id_index = si.item_type
  where dat.network_id = 1;

• Query for all associations on the same network

  -- get all the associations in a network
  select a.id_index, u.login, a.user_id, si.guid as source_guid, a.source_id, ti.guid as target_guid, a.target_id, at.name as assoc_name, a.assoc_type, a.created_on
  from tn_network_data dat 
  inner join tn_associations a on dat.assoc_id = a.id_index
  inner join tn_types at on a.assoc_type = at.id_index
  inner join tn_items si on a.source_id = si.id_index
  inner join tn_items ti on a.target_id = ti.id_index
  inner join tn_users u on a.user_id=u.id_index
  where dat.network_id = 1;

• Ok, let’s see if we can pull this down and parse it!
• Got into some kind of issue trying to use my old (pre ATSBase) login directives. Rebuilding.