bummer... but the good news is that if you're referring to the 'type' column on 'sf_score_element', it's only 10 records and i can recreate it in a matter of minutes and that table is just sample data anyway. looking around, i think that's all that i think you 'hosed'. PLUS i believe that the data for that column is actually stored in sf_score_element_repeat_type anyway... and it's all still there. that table refers back using the 'parent_id' column if i understand how it works...
the issue now is that that column is hosed up so when i try to add a multi select for one of the elements (like on
http://www.skyrun.com/skyforce/score-elements/form/5/300 for example, select incoming phone and outgoing email as two selections), it gives this error when saving:
Unknown column 'Array' in 'where clause' SQL=DELETE FROM sf_score_element WHERE id = Array AND !(`sf_score_element`.`id`IN (1))
the multiselect logic in v3.1 still needs some work (realizing at the same how how utterly complex it must be).
also seems that every time i edit the 'type' element, (
http://www.skyrun.com/skyforce/admi...on=com_fabrik&view=element&layout=edit&id=203) it tries to change the underlying db to something different. i've seen int(6), int(11) and varchar(255) depending on my settings or something... not sure what. but like i say, i don't think that column is used anyway... in favor of sf_score_element_repeat_type.
so looks like all you 'broke' was the fabrik link between the sf_score_element_repeat_type table 'helper table' and the sf_score_element 'real' table. not sure how to get that back... but i know i've broken it before too... and then all of a sudden, it starts working again... would be nice to have it work all the time to state the obvious.
can you (or rob) help piece this back together and get it working so i can multiselect from the 5 available activity types (iphone, ophone, iemail, oemail, ichat), and then filter based on which ones are selected? that's what i'm ultimately trying to do. be able to, from a url, ask for a list of just the score_elements that are applicable for incoming phone calls (filter for type=iphone as any of the multi-selected items) make sense?