function trfield($varpre = '', $noeditstr = '', $ftype = '', $typeid = 0)
{
if (empty($this->field['ename']) || empty($this->field['available'])) {
return;
}
$trname = ($this->field['notnull'] ? '*' : '') . $this->field['cname'] . $noeditstr;
$varname = !$varpre ? $this->field['ename'] : $varpre . '[' . $this->field['ename'] . ']';
$oldstr = $this->isadd ? $this->field['vdefault'] : $this->oldvalue;
//多项选择
foreach (array('datatype', 'mode', 'guide', 'min', 'max') as $var) {
${$var} = $this->field[$var];
}
if ($datatype == 'cacc') {
$setting = empty($this->field['innertext']) ? array() : unserialize($this->field['innertext']);
trcacc($trname, $varname, $oldstr, $this->field['length'], @$setting['source'], @$setting['ids'], $mode, $max ? intval($max) : 0, $guide);
} else {
if (in_array($datatype, array('text', 'int', 'float'))) {
$oldstr = mhtmlspecialchars($oldstr);
$datatype = 'text';
} elseif ($datatype == 'select') {
$sourcearr = select_arr($this->field['innertext'], $this->field['fromcode']);
$oldstr = !$mode ? makeoption($sourcearr, $oldstr) : makeradio($varname, $sourcearr, $oldstr);
} elseif ($datatype == 'mselect') {
$sourcearr = select_arr($this->field['innertext'], $this->field['fromcode']);
$oldarr = explode("\t", $oldstr);
$oldstr = !$mode ? multiselect($varname . '[]', $sourcearr, $oldarr) : makecheckbox($varname . '[]', $sourcearr, $oldarr);
} elseif ($datatype == 'multitext') {
$oldstr = mhtmlspecialchars($oldstr);
} elseif ($datatype == 'date') {
$oldstr = $oldstr ? date('Y-m-d', $oldstr) : '';
} elseif ($datatype == 'map') {
!$oldstr && ($oldstr = $this->field['vdefault']);
$min = $this->field['length'];
} elseif ($datatype == 'vote') {
$mode = $ftype;
$max = $min;
$min = $typeid;
}
trspecial($trname, $varname, $oldstr, $datatype, $mode, $guide, $min, $max);
}
$this->make_submitstr($varname);
}
#Parent id'er i saldi;
$shop_kat_id = array();
#De shop id'er der er registreret på kategorierne i saldi;
$x = 0;
# echo "select categories.categories_id,categories.parent_id,categories_description.categories_name from categories,categories_description where categories_description.language_id='$language_id' and categories_description.categories_id=categories.categories_id order by categories.parent_id<br>";
$q = mysql_query("select categories.categories_id,categories.parent_id,categories_description.categories_name from categories,categories_description where categories_description.language_id='{$language_id}' and categories_description.categories_id=categories.categories_id order by categories.parent_id");
while ($r = mysql_fetch_array($q)) {
if (trim($r['categories_name'])) {
$x++;
$categories_id[$x] = $r['categories_id'];
$parent_id[$x] = $r['parent_id'];
$categories_name[$x] = $r['categories_name'];
# echo "$categories_id[$x] $categories_name[$x] $parent_id[$x]<br>";
}
}
$svar = multiselect($s_id, "id,box1,box2,box3 from grupper where art='V_CAT' order by id");
list($fejl, $svar) = explode(chr(9), $svar);
if ($fejl) {
echo "{$fejl} -- {$svar}<br>";
}
if ($fejl) {
return '1' . chr(9) . $svar;
}
echo "<br><br><br><br><br><br>";
$filnavn = "opdat_shop_kat.csv";
$hent = str_replace("../", "", $svar);
$hent = $url . $hent;
$hent = str_replace("/soapserver", "", $hent);
#echo "hent $hent<br>";
#echo "filnavn $filnavn<br>";
$fp1 = fopen($hent, "r");
!$i && ($mlclassstr = fetch_mlclass($k1, $v['configs'][$k1]));
$i++;
}
$cnidsarr[$k] = $v['cname'] . '(' . $type . ')';
echo "<tr class=\"txt\">" . "<td class=\"txtC w30\"><input class=\"checkbox\" type=\"checkbox\" name=\"selectid[]\" value=\"{$k}\"></td>\n" . "<td class=\"txtL\"><input type=\"text\" size=\"25\" maxlength=\"30\" name=\"cnconfigsnew[{$k}][cname]\" value=\"{$v['cname']}\"></td>\n" . "<td class=\"txtL\">{$configstr}</td>\n" . "<td class=\"txtL\">{$mlclassstr}</td>\n" . "<td class=\"txtC w40\"><input type=\"text\" size=\"4\" maxlength=\"4\" name=\"cnconfigsnew[{$k}][vieworder]\" value=\"{$v['vieworder']}\"></td>\n" . "<td class=\"txtC w30\"><a href=\"?entry={$entry}&action=cnconfigdetail&cncid={$k}{$param_suffix}&iscopy=1\" onclick=\"return floatwin('open_cnodes',this)\">" . lang('copy') . "</a></td>\n" . "<td class=\"txtC w30\"><a href=\"?entry={$entry}&action=cnconfigdetail&cncid={$k}{$param_suffix}\" onclick=\"return floatwin('open_cnodes',this)\">" . lang('detail') . "</a></td>\n" . "</tr>\n";
}
tabfooter();
tabheader(lang('operate_item'));
$str = "<input class=\"radio\" type=\"radio\" name=\"arcdeal\" value=\"update\" checked><b>" . lang('updatecnode') . "</b> ";
$str .= "<input class=\"radio\" type=\"radio\" name=\"arcdeal\" value=\"delete\">" . lang('delete') . lang('cncfg') . " ";
trbasic(lang('choose_item'), '', $str, '');
$cnmodearr = array(0 => lang('cnopmode0'), 1 => lang('cnopmode1'), 2 => lang('cnopmode2'));
trbasic("<input class=\"radio\" type=\"radio\" name=\"arcdeal\" value=\"ccid0\"> " . lang('partop') . lang('catalog'), '', multiselect('cnccids0[]', caidsarr($catalogs), array(), '30%') . " <select id=\"cnmode0\" name=\"cnmode0\" style=\"vertical-align: top;\">" . makeoption($cnmodearr) . "</select>", '', lang('agpartop'));
foreach ($cotypes as $k => $v) {
if ($v['sortable']) {
trbasic("<input class=\"radio\" type=\"radio\" name=\"arcdeal\" value=\"ccid{$k}\"> " . lang('partop') . $v['cname'], '', multiselect('cnccids' . $k . '[]', ccidsarr($k), array(), '30%') . " <select id=\"cnmode{$k}\" name=\"cnmode{$k}\" style=\"vertical-align: top;\">" . makeoption($cnmodearr) . "</select>", '', lang('agpartop'));
}
}
tabfooter('bcnconfigs');
a_guide('cnconfigs');
} else {
if (!empty($cnconfigsnew)) {
foreach ($cnconfigsnew as $k => $v) {
$v['cname'] = trim(strip_tags($v['cname']));
!$v['cname'] && ($v['cname'] = $cnconfigs[$k]['cname']);
$v['vieworder'] = max(0, intval($v['vieworder']));
$db->query("UPDATE {$tblprefix}cnconfigs SET cname = '{$v['cname']}',vieworder='{$v['vieworder']}' WHERE cncid='{$k}'", 'SILENT');
}
updatecache('cnconfigs', '', $sid);
}
if (!empty($arcdeal)) {
$postEntry['tags'] = $addedTags;
saveEntry('posts', $post, $postEntry);
foreach ($addedTags as $tag) {
$tagEntry = readEntry('tags', $tag);
$tagEntry['posts'][$post] = $post;
saveEntry('tags', $tag, $tagEntry);
}
deleteEntry('drafts', $draft);
redirect('view.php?post=' . $post);
} else {
$draftEntry = readEntry('drafts', $draft);
$tagOptions = array();
foreach (listEntry('tags') as $tag) {
$tagEntry = readEntry('tags', $tag);
$tagOptions[$tag] = $tagEntry['name'];
}
$out['title'] = $lang['publishPost'] . ': ' . $draftEntry['title'];
$out['content'] .= '<form action="./publish.php?draft=' . $draft . '" method="post">
<p>' . text('title', $draftEntry['title']) . '</p>
<p>' . text('id', substr($draft, 20)) . '</p>
<p>' . textarea('content', clean($draftEntry['content'])) . '</p>
<p>' . select('locked', array('yes' => $lang['yes'], 'no' => $lang['no']), $postEntry['locked'] ? 'yes' : 'no') . '</p>
<p>' . multiselect('tags', $tagOptions, $postEntry['tags']) . '</p>
<p>' . submitAdmin($lang['confirm']) . '</p>
</form>';
$out['content'] .= isPOST('content') ? box(cleanMagic($_POST['content'])) : '';
}
} else {
home();
}
require 'templates/page.php';
templatebox(lang('tagtemplate'), 'mtagnew[template]', empty($mtag['template']) ? '' : $mtag['template'], 10, 110);
trbasic(lang('arr_pre'), 'mtagnew[setting][val]', empty($mtag['setting']['val']) ? 'v' : $mtag['setting']['val'], 'text', lang('agarr_pre'));
trbasic(lang('list_result'), 'mtagnew[setting][limits]', empty($mtag['setting']['limits']) ? 10 : $mtag['setting']['limits']);
tabfooter();
tabheader(lang('filter0_set'));
$nsidsarr = array('0' => lang('current_subsite'), '-2' => lang('nolimitsubsite'), '-1' => lang('msite')) + sidsarr(1);
//为免与现有模板冲突，0为当前子站
trbasic(lang('subsite_attr'), 'mtagnew[setting][nsid]', makeoption($nsidsarr, empty($mtag['setting']['nsid']) ? 0 : $mtag['setting']['nsid']), 'select');
$sourcearr = array('0' => lang('nolimitcatas'), '1' => lang('handpoint'), '2' => lang('activecatas'), '3' => lang('nearofactive'));
sourcemodule(lang('caid_attr') . " <input class=\"checkbox\" type=\"checkbox\" name=\"mtagnew[setting][caidson]\" value=\"1\"" . (empty($mtag['setting']['caidson']) ? "" : " checked") . ">" . lang('include_son'), 'mtagnew[setting][casource]', $sourcearr, empty($mtag['setting']['casource']) ? '0' : $mtag['setting']['casource'], '1', 'mtagnew[setting][caids][]', caidsarr($catalogs), empty($mtag['setting']['caids']) ? array() : explode(',', $mtag['setting']['caids']));
foreach ($cotypes as $k => $cotype) {
sourcemodule(lang('colasslimit') . "-{$cotype['cname']}" . " <input class=\"checkbox\" type=\"checkbox\" name=\"mtagnew[setting][ccidson{$k}]\" value=\"1\"" . (empty($mtag['setting']['ccidson' . $k]) ? "" : " checked") . ">" . lang('include_son'), "mtagnew[setting][cosource{$k}]", $sourcearr, empty($mtag['setting']['cosource' . $k]) ? '0' : $mtag['setting']['cosource' . $k], '1', "mtagnew[setting][ccids{$k}][]", ccidsarr($k), empty($mtag['setting']['ccids' . $k]) ? array() : explode(',', $mtag['setting']['ccids' . $k]));
}
$chsourcearr = array('0' => lang('nolimitchannel'), '1' => lang('active_channel'), '2' => lang('handpoint'));
sourcemodule(lang('chid_attr'), 'mtagnew[setting][chsource]', $chsourcearr, empty($mtag['setting']['chsource']) ? '' : $mtag['setting']['chsource'], '2', 'mtagnew[setting][chids][]', chidsarr(1), !empty($mtag['setting']['chids']) ? explode(',', $mtag['setting']['chids']) : array());
trbasic(lang('no_chid_attr'), '', multiselect('mtagnew[setting][nochids][]', chidsarr(1), !empty($mtag['setting']['nochids']) ? explode(',', $mtag['setting']['nochids']) : array()), '');
tabfooter();
tabheader(lang('member_related') . " <input class=\"checkbox\" type=\"checkbox\" name=\"viewdetail\" value=\"1\" onclick=\"alterview('mcrelated')\">" . lang('view'));
$sourcearr = array('0' => lang('nolimit_coclass'), '1' => lang('active_coclass'));
echo "<tbody id=\"mcrelated\" style=\"display: none;\">";
trbasic(lang('individual_list'), 'mtagnew[setting][space]', empty($mtag['setting']['space']) ? 0 : $mtag['setting']['space'], 'radio');
trbasic(lang('active_uclass'), '', makeradio('mtagnew[setting][ucsource]', $sourcearr, empty($mtag['setting']['ucsource']) ? 0 : $mtag['setting']['ucsource']), '');
echo "</tbody>";
tabfooter();
$orderbyarr = array('' => lang('nosetting'), 'createdate_desc' => lang('createdate_desc'), 'createdate_asc' => lang('createdate_asc'), 'clicks_desc' => lang('clicks_desc1'), 'comments_desc' => lang('comments_desc1'), 'scores_desc' => lang('average_score_desc1'), 'favorites_desc' => lang('favorite_pics_desc1'), 'praises_desc' => lang('praise_pics_desc1'), 'debases_desc' => lang('debase_pics_desc1'), 'orders_desc' => lang('orders_amount_desc1'), 'downs_desc' => lang('download_pics_desc1'), 'plays_desc' => lang('play_pics_desc1'), 'currency_desc' => lang('answer_reward_desc1'));
$orderbyarr1 = array('' => lang('nosetting'), 'mclicks_desc' => lang('month_clicks_desc1'), 'wclicks_desc' => lang('week_clicks_desc1'), 'mcomments_desc' => lang('month_comments_desc1'), 'wcomments_desc' => lang('week_comments_desc1'), 'mfavorites_desc' => lang('m_fav_pics_desc1'), 'wfavorites_desc' => lang('w_fav_pics_desc1'), 'mpraises_desc' => lang('m_praise_pics_desc1'), 'wpraises_desc' => lang('w_praise_pics_desc1'), 'mdebases_desc' => lang('m_debase_pics_desc1'), 'wdebases_desc' => lang('w_debase_pics_desc1'), 'morders_desc' => lang('m_orders_amount_desc1'), 'worders_desc' => lang('w_orders_amount_desc1'), 'mdowns_desc' => lang('m_download_pics_desc1'), 'wdowns_desc' => lang('w_download_pics_desc1'), 'mplays_desc' => lang('m_play_pics_desc1'), 'wplays_desc' => lang('w_play_pics_desc1'));
tabheader(lang('list_order') . " <input class=\"checkbox\" type=\"checkbox\" name=\"viewdetail\" value=\"1\" onclick=\"alterview('ordersetting')\">" . lang('view'));
trbasic(lang('first_order'), 'mtagnew[setting][orderby]', makeoption($orderbyarr, empty($mtag['setting']['orderby']) ? '' : $mtag['setting']['orderby']), 'select');
echo "<tbody id=\"ordersetting\" style=\"display: none;\">";
trbasic(lang('second0_order'), 'mtagnew[setting][orderby1]', makeoption($orderbyarr1, empty($mtag['setting']['orderby1']) ? '' : $mtag['setting']['orderby1']), 'select');
$createurl = " >><a href=\"?entry=liststr&tclass=archives\" target=\"_blank\">" . lang('create_str') . "</a>";
$gmodel = read_cache('gmodel', $gmission['gmid'], '', $sid);
$dvalues = empty($gmission['dvalues']) ? array() : $gmission['dvalues'];
$chid = $gmodel['chid'];
$channel = read_cache('channel', $chid);
$fields = read_cache('fields', $chid);
if (!submitcheck('bgmissionoutput')) {
$a_field = new cls_field();
$mustsarr = array();
foreach ($fields as $k => $v) {
if (in_array($k, array_keys($gmodel['gfields']))) {
$mustsarr[$k] = $v['cname'];
}
}
tabheader('[' . $gmission['cname'] . lang('output_based_setting'), 'gmissionoutput', "?entry=gmissions&action=gmissionoutput&gsid={$gsid}{$param_suffix}", 2, 1, 1);
$submitstr = '';
trbasic(lang('mustfields'), '', multiselect('dvaluesnew[musts][]', $mustsarr, empty($dvalues['musts']) ? array() : explode(',', $dvalues['musts'])), '');
if ($fields['abstract']['available'] && !in_array('abstract', array_keys($gmodel['gfields']))) {
trbasic(lang('auto_abstract'), 'dvaluesnew[autoabstract]', empty($dvalues['autoabstract']) ? 0 : $dvalues['autoabstract'], 'radio');
}
if ($fields['thumb']['available'] && !in_array('thumb', array_keys($gmodel['gfields']))) {
trbasic(lang('auto_thumb'), 'dvaluesnew[autothumb]', empty($dvalues['autothumb']) ? 0 : $dvalues['autothumb'], 'radio');
}
tabfooter();
tabheader('[' . $gmission['cname'] . lang('output_default_value'));
tr_cns('*' . lang('be_catalog'), 'dvaluesnew[caid]', empty($dvalues['caid']) ? 0 : $dvalues['caid'], $sid, 0, $chid, lang('p_choose'));
$submitstr .= makesubmitstr('dvaluesnew[caid]', 1, 'int', 0, 0, 'common');
foreach ($fields as $k => $field) {
if ($field['available'] && !in_array($k, array_keys($gmodel['gfields'])) && !in_array($k, array('abstract', 'thumb'))) {
$a_field->init();
$a_field->field = $field;
$a_field->oldvalue = !isset($dvalues[$k]) ? '' : $dvalues[$k];
}
// si se usa modo transacciones no devuelve el ultimo id.
//echo $cn->lastInsertId() . "\n";
}
function select()
{
global $cn;
try {
$rs = $cn->query("select nombre, email from contacts");
} catch (PDOException $e) {
$cn->rollBack();
echo $e->getMessage();
}
print_r($rs->fetchAll(PDO::FETCH_OBJ));
}
function multiselect()
{
global $cn;
try {
$rs = $cn->query("select * from contacts where id=1;\n\t\tselect * from contacts where id=7;");
} catch (PDOException $e) {
$cn->rollBack();
echo $e->getMessage();
}
do {
print_r($rs->fetchAll(PDO::FETCH_OBJ));
} while ($rs->nextRowset());
}
//$rs = select();
multiselect();
