= 1) { /* obtain the types keywords... */ for($i = 0; $i < $rows; $i++) { $typesDescs[$i] = db_result($result, $i, 'type_name'); } } $result= db_query_params("SELECT * FROM skills_data WHERE user_id=$1 ORDER BY finish DESC, start ASC, skills_data_id DESC",array($user_id)); $rows = db_numrows($result); if (!$result || $rows < 1) { echo db_error(); $feedback = 'No skills listed '; echo 'This user has not entered any skills.'; } else { echo ''; /* headings for the columns */ if($allowEdit) { echo ''._('Edit').''. ''._('Delete').''; } echo ''._('Type').''. ''._('Title').''. ''._('Start Date').''. ''._('End Date').''. ''._('Keywords').''. ''; for ($i = 0; $i < $rows; $i++) /* for each entry in the database */ { /* set up some variables to make things easier.... */ $typeID = db_result($result, $i, 'type'); $start = db_result($result, $i, 'start'); $finish = db_result($result, $i, 'finish'); $startY = substr($start, 0, 4); $startM = substr($start, 4, 2); $finishY = substr($finish, 0, 4); $finishM = substr($finish, 4, 2); if($startM > 0 && $startM < 13) { $startStr = date ("M Y", mktime(0,0,0,$startM,1,$startY)); } else { $startStr = $startY; } if (!(isset($finishtM))){ $finishtM=0; } if($finishM > 0 && $finishtM < 13) { $finishStr = date ("M Y", mktime(0,0,0,$finishM,1,$finishY)); } else { $finishStr = $finishY; } /* now print out the row, formatted nicely */ echo 'boxGetAltRowStyle($i+1) . '>'; if($allowEdit) { echo ''; echo ''; } if($typesDescs[$typeID]) { echo ''.$typesDescs[$typeID]."\n"; } else { echo ''.$typeID ."\n"; } echo ''.db_result($result, $i, 'title') ."\n"; echo ''.$startStr."\n"; echo ''.$finishStr."\n"; echo ''.db_result($result, $i, 'keywords') ."\n"; echo ""; } if($allowEdit) { echo ''; echo ''; echo ''; echo ''; } } } function handle_multi_edit($skill_ids = array()) { global $HTML; $result = db_query_params ('SELECT * FROM skills_data WHERE skills_data_id = ANY ($1)', array (db_int_array_to_any_clause ($skill_ids))); $rows = db_numrows($result); if (!$result || $rows < 1) { echo db_error(); } else { $skills=db_query_params("SELECT * FROM skills_data_types WHERE type_id > 0", array()); if (!$skills || db_numrows($skills) < 1) { $feedback .= _('No Such User')._(': ').db_error(); echo '

'._('No Such User').'

'; } $yearArray = array(); for($years = date("Y"); $years >= 1980; $years--) { array_push($yearArray,$years); } $monthArray = array(); $monthArrayVals = array(); for($i = 1; $i <= 12; $i++) { array_push($monthArrayVals,($i<10?"0".$i:$i)); array_push($monthArray,date("M", mktime(0,0,0,$i,1,1980))); } for($i = 0; $i < $rows; $i++) { $start = db_result($result, $i, 'start'); $finish = db_result($result, $i, 'finish'); $startY = substr($start, 0, 4); $startM = substr($start, 4, 2); $finishY = substr($finish, 0, 4); $finishM = substr($finish, 4, 2); echo ''. 'boxGetAltRowStyle($i+1).'>'. ''. ''. 'boxGetAltRowStyle($i+1).'>'; echo '

'.db_result($result, $i,'title').'

'. ''. ''. ''. ''. ''. ''; echo 'boxGetAltRowStyle($i+1).'>'. ''. ''. ''. ''. '
'._('Type').''._('Start Date').''._('End Date').'
'.html_build_select_box($skills, 'type[]',db_result($result, $i,'type') , false, '').''.html_build_select_box_from_arrays($monthArrayVals,$monthArray, 'startM[]', $startM, false, ''). html_build_select_box_from_arrays($yearArray,$yearArray, 'startY[]', $startY, false, '').''.html_build_select_box_from_arrays($monthArrayVals,$monthArray, 'endM[]', $finishM, false, ''). html_build_select_box_from_arrays($yearArray,$yearArray, 'endY[]', $finishY, false, '').'
'. '
'. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. ''. '
'._('Title (max 100 characters)').'
'. '
'._('Keywords (max 255 characters)').'
'; echo '

'; } } } // Local Variables: // mode: php // c-file-style: "bsd" // End: