public function edit() { if (!$_POST['submit']) { $id = intval($_GET['id']); if ($id) { $data = $this->mdata('pages')->where("id={$id}")->get(); $this->view['data'] = $data; } $this->editor_header(); $this->editor('content', $data['content'], 'content_txtkey_', $data['content_txtkey_'], 'article_desc'); $this->editor_uploadbutton('image', $data['image'], 'article_img'); $this->view('pages/edit.html'); } else { if (!$_POST['title']) { $this->error('title_null'); } $data = array('title_key_' => trim($_POST['title_key_']), 'title' => trim($_POST['title']), 'urlkey' => to_url(trim($_POST['urlkey'])), 'content_txtkey_' => trim($_POST['content_txtkey_']), 'content' => $_POST['content'], 'sort_order' => intval($_POST['sort_order']), 'image' => trim($_POST['image']), 'meta_title_key_' => $_POST['meta_title_key_'], 'meta_title' => trim($_POST['meta_title']), 'meta_keywords_txtkey_' => $_POST['meta_keywords_txtkey_'], 'meta_keywords' => trim($_POST['meta_keywords']), 'meta_description_txtkey_' => $_POST['meta_description_txtkey_'], 'meta_description' => trim($_POST['meta_description'])); if ($_POST['id']) { $id = intval($_POST['id']); $this->mdata('pages')->where("id={$id}")->save($data); } else { $id = $this->mdata('pages')->add($data); } $this->model('urlkey')->set_page($id, $data['urlkey']); $this->ok('edit_success', url('pages/index')); } }
public function addcate() { $catelist = $this->model('goodscate')->getlist(); if (!$_POST['submit']) { if ($_GET['id']) { $id = intval($_GET['id']); $data = $this->mdata('goods_cate')->where("id={$id}")->get(); } else { $data = array(); } $this->editor_header(); $this->editor('description', $data['description'], 'description_txtkey_', $data['description_txtkey_'], 'article_desc'); $this->editor_uploadbutton('image', $data['image'], 'goods_cate'); $this->view['data'] = $data; $this->view['title'] = lang('edit_category'); $this->view['catelist'] = $catelist; $this->view('goodscate/addcate.html'); } else { if (!$_POST['name']) { $this->error('name_null'); } //if image is not uploaded $image = trim($_POST['image']); $image = $this->model('image')->check_img($image, 'goods_cate'); $data = array('pid' => intval($_POST['pid']), 'name_key_' => trim($_POST['name_key_']), 'name' => trim($_POST['name']), 'description_txtkey_' => $_POST['description_txtkey_'], 'description' => $_POST['description'], 'meta_title_key_' => $_POST['meta_title_key_'], 'meta_title' => trim($_POST['meta_title']), 'meta_keywords_txtkey_' => $_POST['meta_keywords_txtkey_'], 'meta_keywords' => trim($_POST['meta_keywords']), 'meta_description_txtkey_' => $_POST['meta_description_txtkey_'], 'meta_description' => trim($_POST['meta_description']), 'urlkey' => to_url(trim($_POST['urlkey'])), 'image' => $image, 'sort_order' => intval($_POST['sort_order'])); if ($_POST['id']) { $cate_id = intval($_POST['id']); $this->mdata('goods_cate')->where("id={$cate_id}")->save($data); } else { $cate_id = $this->mdata('goods_cate')->add($data); } $this->model('urlkey')->set_goodscate($cate_id, $data['urlkey']); $this->ok('edit_success', url('goodscate/index')); } }
public function write_url() { return "/movie/" . $this->id . "/" . to_url($this->title); }
$src = src_expand($src); } $query = "\n SELECT\n source_id,\n is_unused(source_id) AS unused,\n get_source_text(source_id) AS src_txt,\n source_date\n FROM\n sources\n WHERE\n source_text SIMILAR TO '%{$src}%'\n "; if ($scope != 0) { $query .= "\n AND\n part_type = {$scope}\n "; } if ($yr && $diff) { $query .= "\n AND\n EXTRACT(YEAR FROM source_date)\n BETWEEN {$yr} - {$diff} AND {$yr} + {$diff}\n "; } if ($yr && !$diff) { $query .= "\n AND\n EXTRACT(YEAR FROM source_date) = {$yr}\n "; } $query .= "\n ORDER BY\n source_date\n "; $handle = pg_query($query); echo "<table>\n"; while ($row = pg_fetch_assoc($handle)) { $id = $row['source_id']; echo '<tr>'; echo td_numeric(square_brace(to_url('./source_manager.php', array('node' => $id), $id))); if ($row['unused'] == 't') { echo td(span_type(square_brace(italic($row['source_date'])) . ' ' . $row['src_txt'], 'faded')); } else { echo td(square_brace(italic($row['source_date'])) . ' ' . $row['src_txt']); } echo "</tr>\n"; } echo "</table>\n"; echo '<p>' . pg_num_rows($handle) . ' treff.</p>'; } echo "</div>\n"; include "./footer.php";
function list_mentioned($node, $hotlink = 0) { global $app_path, $_edit, $_delete; echo "<ol>\n"; $handle = pg_query("\n SELECT\n per_id,\n get_role(role_fk) AS rolle,\n person_fk,\n get_surety(surety_fk) AS surety,\n s_name,\n link_expand(sl_note) AS note\n FROM\n source_linkage\n WHERE\n source_fk = {$node}\n ORDER BY\n role_fk,\n per_id\n "); while ($row = pg_fetch_assoc($handle)) { echo '<li>' . $row['rolle'] . ': '; echo '«' . $row['s_name'] . '»'; if ($row['person_fk']) { echo conc(curly_brace($row['surety'])) . conc(linked_name($row['person_fk'], "{$app_path}/family.php")); } if (has_parents($row['person_fk'])) { echo conc(child_of($row['person_fk'])); } if ($row['note']) { echo ': ' . $row['note']; } if ($hotlink) { echo conc(paren(to_url("{$app_path}/forms/linkage_edit.php", array('node' => $node, 'id' => $row['per_id']), $_edit) . ' / ' . to_url("{$app_path}/forms/linkage_delete.php", array('node' => $node, 'id' => $row['per_id']), $_delete))); } echo "</li>\n"; } if ($hotlink) { echo '<li>' . to_url("{$app_path}/forms/linkage_add.php", array('node' => $node), "Legg til lenke") . "</li>\n"; } echo "</ol>\n"; }
pg_query("\n DELETE FROM relations\n WHERE relation_id = {$relid_s}\n "); } // transfer remaining relations pg_query("\n UPDATE relations\n SET child_fk = {$target}\n WHERE child_fk = {$source}\n "); pg_query("\n UPDATE relations\n SET parent_fk = {$target}\n WHERE parent_fk = {$source}\n "); // update source_linkage pg_query("\n UPDATE source_linkage\n SET person_fk = {$target}\n WHERE person_fk = {$source}\n "); // insert "event" for source person with a link to target person $event_note = " [p={$target}|ID #{$target}]"; $event = fetch_val("\n INSERT INTO events (\n tag_fk,\n place_fk,\n event_date,\n sort_date,\n event_note\n )\n VALUES (\n 1040,\n 1,\n '000000003000000001',\n '00010101',\n '{$event_note}'\n )\n RETURNING event_id\n "); add_participant($source, $event); pg_query("\n INSERT INTO merged (old_person_fk,new_person_fk)\n VALUES ({$source}, {$target})\n "); set_last_edit($source); set_last_edit($target); pg_query("\n COMMIT\n "); // return to main view of "stripped" person. header("Location: {$app_root}/family.php?person={$source}"); } else { // explain why the merge failed $title = "{$_App_name}: {$_Merge_persons_failed}"; require "./form_header.php"; echo "<h2>{$title}!</h2>\n"; $name_1 = get_name($person_1); $name_2 = get_name($person_2); echo "<p>{$_Cannot_merge} {$name_1} ({$_born} {$bdate_1}), {$_with} {$name_2} ({$_born} {$bdate_2}).<br />\n"; echo "{$_Reason}: {$reason}</p>\n"; echo para(to_url('../family.php', array(person => $person_1), "{$_Return_to} {$person_1} {$name_1}")); echo para(to_url('../family.php', array(person => $person_2), "{$_Return_to} {$person_2} {$name_2}")); echo "</body>\n</html>\n"; } }
function format_link() { global $post; $link_url = get_post_meta($post->ID, 'format_link_url', true); $url = !empty($link_url) ? to_url($link_url) : "#"; echo '<div class="link-content">'; echo '<h2 class="link-text"><a href="' . $url . '" target="_blank">' . get_the_title() . '</a></h2>'; echo '<a href="' . $url . '" target="_blank"><span class="sub-title">' . $url . '</span></a></div>'; }
function show_parent($person, $gender) { // print names and lifespans of parents. // valid $gender values are 1=father, 2=mother global $language, $_Add, $_Insert, $_edit, $_delete, $_Father, $_father, $_Mother, $_mother, $_toolhelp_edit_parent, $_toolhelp_add_parent, $_toolhelp_insert_parent, $_toolhelp_delete_parent; $parent_id = fetch_val("SELECT get_parent({$person}, {$gender})"); $surety = fetch_val("\n SELECT get_lsurety((\n SELECT surety_fk\n FROM relations\n WHERE parent_fk = {$parent_id}\n AND child_fk = {$person}\n ), '{$language}')\n "); if ($gender == 1) { $Parent = $_Father; $parent = $_father; $para = '<p>'; $newline = '<br />'; } else { // $gender == 2 $Parent = $_Mother; $parent = $_mother; $para = ''; $newline = '</p>'; } echo $para . conc(bold($Parent) . ':') . conc(get_name_and_dates('', $parent_id)); if ($parent_id) { echo conc(curly_brace($surety)) . conc(span_type(paren(to_url('./forms/relation_edit.php', array('person' => $person, 'parent' => $parent_id), $_edit, sprintf($_toolhelp_edit_parent, $parent)) . ' / ' . to_url('./forms/relation_delete.php', array('person' => $person, 'parent' => $parent_id), $_delete, sprintf($_toolhelp_delete_parent, $parent))), "hotlink")) . cite(get_relation_id($person, $gender), 'relation', $person); } else { echo conc(span_type(paren(to_url('./forms/person_insert.php', array('person' => $person, 'addparent' => 'true', 'gender' => $gender), "{$_Add} {$parent}", sprintf($_toolhelp_add_parent, $parent)) . ' / ' . to_url('./forms/relation_edit.php', array('person' => $person, 'gender' => $gender), "{$_Insert} {$parent}", sprintf($_toolhelp_insert_parent, $parent))), "hotlink")); } echo "{$newline}\n"; }
function catalog_menu_with_links($parent_id) { $items = catalog_items(0); global $lang_dir; foreach ($items as &$item) { $item->link = "{$lang_dir}catalog/" . to_url(fld_trans($item->title, "eng")); $item->altlink = $item->link; } $o = ""; foreach ($items as &$item) { $item->title = fld_trans($item->title); $o .= "<div class='menuItemDiv level2'><div class=title><a class=menuItem href='{$item->link}' althref='{$item->altlink}'>{$item->title}</a></div></div>"; } return $o; }
function shortcode_jw_partner($atts, $content) { $category_list = isset($atts['partner_category_list']) ? $atts['partner_category_list'] : ''; //$arrow = '<div class="carousel-arrow jw-carrow">'; //$arrow .= '<a class="carousel-prev" href="#"><i class="icon-angle-left"></i></a>'; //$arrow .= '<a class="carousel-next" href="#"><i class="icon-angle-right"></i></a>'; //$arrow .= '</div>'; $output = '<div class="carousel-container">'; $output .= '<div class="jw-carousel-partner list_carousel">'; $output .= '<ul class="jw-carousel">'; $query = array('post_type' => 'jw_partner', 'posts_per_page' => -1); $cats = explode(",", $category_list); $imgwidth = 270; if (!empty($cats[0])) { $query['tax_query'] = array(array('taxonomy' => 'cat_partner', 'terms' => $cats, 'field' => 'id')); } if (!empty($atts['order'])) { switch ($atts['order']) { case "date_asc": $query['orderby'] = 'date'; $query['order'] = 'ASC'; break; case "title_asc": $query['orderby'] = 'title'; $query['order'] = 'ASC'; break; case "title_desc": $query['orderby'] = 'title'; $query['order'] = 'DESC'; break; case "random": $query['orderby'] = 'rand'; break; } } // START - LOOP query_posts($query); while (have_posts()) { the_post(); $imgheight = $atts['image_height']; $output .= '<li>'; if (get_metabox('link') != '') { $output .= '<a href="' . to_url(get_metabox('link')) . '" target="_blank">'; $output .= post_image_show($imgwidth, $imgheight); $output .= '</a>'; } else { $output .= post_image_show($imgwidth, $imgheight); } $output .= '</li>'; } wp_reset_query(); // END - LOOP $output .= '</ul>'; $output .= '<div class="clearfix"></div>'; //$output .= $arrow; $output .= '</div>'; $output .= '</div>'; return $output; }
function get_sidebar_name($p) { $name = get_name($p); $name .= has_descendants($p) ? '+' : ''; return to_url('./pedigree.php', array('person' => $p), $name); }
* Copyright (C) 2011 by Leif B. Kristensen <*****@*****.**> * * All rights reserved. For terms of use, see LICENSE.txt * ***************************************************************************/ // This script is basically a report listing sources of one type. // It is accessed from the Source Part Type Manager via the 'report' link. require "./settings/settings.php"; require "./functions.php"; require_once "./langs/{$language}.php"; $spt = $_GET['spt']; $label = 'label_' . $language; $spt_name = fetch_val("\n SELECT {$label} FROM source_part_types WHERE part_type_id = {$spt}\n"); $title = "{$_All} {$_sources} {$_of} type {$spt_name}"; require "./header.php"; echo "<div class=\"normal\">\n"; echo "<h2>{$title}</h2>\n"; echo "<table>"; $handle = pg_query("\n SELECT\n source_id,\n link_expand(source_text) AS txt,\n source_date,\n ecc(source_id) AS e,\n rcc(source_id) AS r,\n ssc(source_id) AS s,\n usc(source_id) AS u,\n spt.{$label} AS {$label}\n FROM\n sources, source_part_types spt\n WHERE\n spt.part_type_id = sources.part_type\n AND\n spt.part_type_id = {$spt}\n AND\n source_id <> 0\n ORDER BY\n source_date,\n source_text\n"); while ($row = pg_fetch_assoc($handle)) { $id = $row['source_id']; echo '<tr>'; echo td(paren(to_url('source_manager.php', array('node' => $id), $_Select) . ' / ' . to_url('./forms/source_edit.php', array('person' => 0, 'source' => $id), $_Edit))); if ($row['e'] || $row['r'] || $row['s']) { echo td(square_brace(italic($row['source_date'])) . ' ' . $row['txt'] . node_details($row['e'], $row['r'], $row['s'], $row['u'])); } else { // source is unused, print with gray text echo td(span_type(square_brace(italic($row['source_date'])) . conc($row['txt']), "faded")); } echo "</tr>\n"; } echo "</table>\n"; include "./footer.php";
public function editcate() { if (!$_POST['submit']) { $id = intval($_GET['cate_id']); if ($id) { $data = $this->mdata('article_cate')->where("cate_id={$id}")->get(); $this->view['data'] = $data; } $this->editor_header(); $this->editor_uploadbutton('image', $data['image'], 'articlecate_img'); $this->view('article/editcate.html'); } else { if (!$_POST['name']) { $this->error('name_null'); } $data = array('name_key_' => trim($_POST['name_key_']), 'name' => trim($_POST['name']), 'urlkey' => to_url(trim($_POST['urlkey'])), 'image' => trim($_POST['image']), 'sort_order' => intval($_POST['sort_order']), 'status' => intval($_POST['status'])); if ($_POST['cate_id']) { $id = intval($_POST['cate_id']); $this->mdata('article_cate')->where("cate_id={$id}")->save($data); } else { $id = $this->mdata('article_cate')->add($data); } $this->model('urlkey')->set_articlecate($id, $data['urlkey']); $this->ok('edit_success', url('article/cate')); } }
<div class='btn-group'> <a class='btn' href="<?php echo to_url($this->router->class . '/edit/' . $id); ?> " target="_self"> 继续编辑该条信息 </a> <a class='btn btn-info' href="<?php echo $back_url; ?> " target="_self"> 回到列表页 </a> </div> <?php break; default: ?> <a class='btn btn-info' href="<?php echo to_url($this->router->class . '/index/'); ?> " target="_self"> 返回 </a> <?php } // end switch } else { ?> <a class='btn btn-info' href="<?php echo $back_url; ?> " target="_self"> 返回默认 </a> <?php } ?>
public function update() { $group_id = intval($_POST['group_id']); $title = trim($_POST['title']); $title_key_ = $_POST['title_key_']; $urlkey = to_url(trim($_POST['urlkey'])); $sku = trim($_POST['sku']); $cate_id = $_POST['cate_id']; $price = floatval($_POST['price']); $stock = intval($_POST['stock']); $sort_order = intval($_POST['sort_order']); $goods_id = intval($_POST['goods_id']); if (!$title || !$sku) { $this->error('required_null'); } //check sku $row = $this->db->table('goods')->where("sku='{$sku}'")->get(); if ($row && $row['goods_id'] != $goods_id) { $this->error('sku_repeated'); } //if image is not uploaded $image = trim($_POST['image']); $image = $this->model('image')->check_img($image, 'goods_main_img'); $data = array('group_id' => $group_id, 'title' => $title, 'title_key_' => $title_key_, 'urlkey' => $urlkey, 'sku' => $sku, 'price' => $price, 'price_origin' => floatval($_POST['price_origin']), 'weight' => intval($_POST['weight']), 'brief_txtkey_' => $_POST['brief_txtkey_'], 'brief' => trim($_POST['brief']), 'description_txtkey_' => $_POST['description_txtkey_'], 'description' => $_POST['description'], 'meta_title_key_' => $_POST['meta_title_key_'], 'meta_title' => trim($_POST['meta_title']), 'meta_keywords_txtkey_' => $_POST['meta_keywords_txtkey_'], 'meta_keywords' => trim($_POST['meta_keywords']), 'meta_description_txtkey_' => $_POST['meta_description_txtkey_'], 'meta_description' => trim($_POST['meta_description']), 'image' => $image, 'stock' => $stock, 'is_sale' => intval($_POST['is_sale']), 'sort_order' => $sort_order); if ($goods_id > 0) { $this->mdata('goods')->where("goods_id={$goods_id}")->save($data); } else { $data['addtime'] = time(); $goods_id = $this->mdata('goods')->add($data); if ($goods_id < 1) { $this->error('add_error'); } } $this->model('urlkey')->set_goods($goods_id, $data['urlkey']); //category if ($cate_id && is_array($cate_id)) { $this->model('goods')->update_cate($goods_id, $cate_id); } //attribute $attr = $_POST['attr']; $attr_value = $_POST['attr_value']; if ($attr && is_array($attr) && $attr_value && is_array($attr_value)) { $this->db->table('goods_attr')->where("goods_id={$goods_id}")->delete(); foreach ($attr as $aid) { if ($attr_value[$aid]) { foreach ($attr_value[$aid] as $av_id) { $this->db->table('goods_attr')->insert(array('goods_id' => $goods_id, 'attr_id' => $aid, 'av_id' => $av_id)); } } } } //extend $extend = $_POST['extend']; if ($extend && is_array($extend)) { $extend_at = array(); $extendlist = $this->db->table('goods_extend')->where("goods_id={$goods_id}")->getlist(); foreach ($extendlist as $v) { $extend_at[$v['extend_id']] = $v['val']; } foreach ($extend as $extend_id => $v) { if (is_array($v)) { $v = implode(',', $v); } else { //is file $type = $this->model('extend')->get_type($extend_id); if ($type == 5) { $file = $this->model('extend')->get_file($extend_id); if ($file) { $v = $file; } } } $v = trim($v); if (!empty($v)) { if (!$extend_at[$extend_id]) { $this->db->table('goods_extend')->insert(array('goods_id' => $goods_id, 'extend_id' => $extend_id, 'val' => $v)); } elseif ($v != $extend_at[$extend_id]) { $this->db->table('goods_extend')->where("goods_id={$goods_id} and extend_id={$extend_id}")->update(array('val' => $v)); } } else { $type = $this->model('extend')->get_type($extend_id); if ($type == 5) { $this->model('extend')->del_file($goods_id, $extend_id); } $this->db->table('goods_extend')->where("goods_id={$goods_id} and extend_id={$extend_id}")->delete(); } } } //image $imagemore = $_POST['imagemore']; $imagemore_label = $_POST['imagemore_label']; $imagemore_label_key = $_POST['imagemore_label_key']; if ($imagemore && is_array($imagemore)) { $imglist = array(); $list = $this->db->table('goods_image')->where("goods_id={$goods_id}")->getlist(); foreach ($list as $v) { $imglist[] = $v['image']; } $s_arr = array(); foreach ($imagemore as $key => $img) { if (!in_array($img, $imglist)) { $goods_image = array('goods_id' => $goods_id, 'image' => $img, 'label_key_' => $imagemore_label_key[$key], 'label' => $imagemore_label[$key]); $this->mdata('goods_image')->add($goods_image); } else { $goods_image = array('label_key_' => $imagemore_label_key[$key], 'label' => $imagemore_label[$key]); $this->mdata('goods_image')->where("goods_id={$goods_id} and image='{$img}'")->save($goods_image); $s_arr[] = $img; } } $diff_arr = array_diff($imglist, $s_arr); if ($diff_arr) { foreach ($diff_arr as $v) { $this->mdata('goods_image')->where("goods_id={$goods_id} and image='{$v}'")->delete(); } } } //option $op_name_id = $_POST['op_name_id']; $op_name = $_POST['op_name']; $op_name_key = $_POST['op_name_key']; $op_price = $_POST['op_price']; if ($op_name && is_array($op_name) && is_array($op_price)) { $option = array(); $optionlist = $this->mdata('goods_option')->where("goods_id={$goods_id}")->getlist(); if ($optionlist) { foreach ($optionlist as $v) { $op_id = $v['op_id']; $oid = $v['id']; $option[$op_id][$oid] = $v; } } foreach ($op_name as $op_id => $v) { $n = 1; foreach ($v as $k => $name) { $oid = $op_name_id[$op_id][$k]; $name = trim($name); if ($name) { $price = floatval($op_price[$op_id][$k]); $name_key = $op_name_key[$op_id][$k]; if ($option[$op_id][$oid]) { $data = array('name_key_' => $name_key ? $name_key : $option[$op_id][$oid]['name_key_'], 'name' => $name, 'price' => $price, 'sort_order' => $n); $this->mdata('goods_option')->where("id={$oid}")->save($data); unset($option[$op_id][$oid]); } else { $data = array('goods_id' => $goods_id, 'op_id' => $op_id, 'name_key_' => $name_key, 'name' => $name, 'image' => '', 'price' => $price, 'sort_order' => $n); $this->mdata('goods_option')->add($data); } $n++; } } } if ($option) { foreach ($option as $op_id => $val) { if ($val) { foreach ($val as $id => $v) { $this->mdata('goods_option')->where("id={$id}")->delete(); } } } } } //cross sell $cross_sell = $_POST['cross_sell']; if ($cross_sell && is_array($cross_sell)) { $cs_ids = implode(',', $cross_sell); $n = $this->db->table('goods_crosssell')->where("goods_id={$goods_id}")->count(); if ($n > 0) { $this->db->table('goods_crosssell')->where("goods_id={$goods_id}")->update(array('relate_ids' => $cs_ids)); } else { $data = array('goods_id' => $goods_id, 'relate_ids' => $cs_ids); $this->db->table('goods_crosssell')->insert($data); } } $this->ok('edit_success', url('goods/index')); }
/*************************************************************************** * nolink.php * * Yggdrasil: Unidentified people mentioned in sources * * (Part of the experimental source linkage * * * * Copyright (C) 2009-2011 by Leif B. Kristensen <*****@*****.**> * * All rights reserved. For terms of use, see LICENSE.txt * ***************************************************************************/ require "./settings/settings.php"; require_once "./langs/{$language}.php"; require "./functions.php"; $title = 'Uidentifiserte personer'; require "./header.php"; echo "<div class=\"normal\">\n"; echo "<h2>Uidentifiserte personer fra lenking:</h2>\n"; $handle = pg_query("\n SELECT\n s.source_id AS source,\n part_ldesc(s.part_type) AS s_type,\n get_lsurety(l.surety_fk) AS surety,\n get_lrole(l.role_fk) AS rolle,\n l.s_name AS name,\n get_source_text(s.source_id) AS txt,\n link_expand(l.sl_note) AS note\n FROM\n sources s,\n source_linkage l\n WHERE\n l.source_fk = s.source_id\n AND\n l.person_fk IS NULL\n ORDER BY\n s.source_date,\n s.sort_order,\n l.per_id\n"); echo "<ol>\n"; while ($row = pg_fetch_assoc($handle)) { $principal = fetch_val("\n SELECT person_fk FROM source_linkage\n WHERE source_fk = " . $row['source'] . " AND role_fk = 1\n "); echo "<li>" . bold($row['name']) . '<br />' . $row['surety'] . ' ' . $row['rolle'] . ' ved ' . $row['s_type']; if ($principal) { echo ' av ' . linked_name($principal, './family.php'); } echo '. ' . $row['txt']; echo conc(italic($row['note'])); echo conc(paren(to_url('./source_manager.php', array('node' => $row['source']), 'Til kildebehandler'))); echo "</li>\n"; } echo "</ol>\n"; echo "</div>\n"; include "./footer.php";
$id = $row['source_id']; echo '<tr>'; if ($friendly) { echo td(paren(to_url($_SERVER['PHP_SELF'], array('node' => $id), $_Select) . ' / ' . to_url('./forms/source_edit.php', array('person' => 0, 'source' => $id), $_Edit))); echo td_numeric(square_brace($row['sort_order'])); echo td(paren($row[$label])); } else { echo td_numeric(square_brace(to_url($_SERVER['PHP_SELF'], array('node' => $id), $id, $_goto))); echo td_numeric(square_brace($row['sort_order'])); echo td(paren(to_url('./forms/source_edit.php', array('person' => 0, 'source' => $id), $row[$label], $_edit))); } if ($row['e'] || $row['r'] || $row['s']) { echo td(square_brace(italic($row['source_date'])) . ' ' . $row['txt'] . node_details($row['e'], $row['r'], $row['s'], $row['u'])); } else { // source is unused, print with gray text if ($show_delete) { // show link for source deletion echo td(span_type(square_brace(italic($row['source_date'])) . conc($row['txt']), "faded") . conc(paren(to_url('./forms/source_delete.php', array('node' => $self, 'id' => $id), bold($_delete))))); } else { echo td(span_type(square_brace(italic($row['source_date'])) . conc($row['txt']), "faded")); } } echo "</tr>\n"; } echo "</table>\n"; } if ($props['is_leaf'] == "f") { echo para(to_url('./forms/source_add.php', array('node' => $self), $_Add_source)); } echo "</div>\n"; include "./footer.php";