Gecko [ research.sskru.ac.th ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
admin_act.php	2.88 KB	-rw-r--r--
admin_frm.php	2.6 KB	-rw-r--r--
admin_lst.php	2.56 KB	-rw-r--r--
faculty_act.php	2.79 KB	-rw-r--r--
faculty_frm.php	2.13 KB	-rw-r--r--
faculty_lst.php	2.49 KB	-rw-r--r--
fund_act.php	3.64 KB	-rw-r--r--
fund_frm.php	4.39 KB	-rw-r--r--
fund_lst.php	2.81 KB	-rw-r--r--
innovation_act.php	4.03 KB	-rw-r--r--
innovation_frm.php	5.63 KB	-rw-r--r--
innovation_lst.php	5.11 KB	-rw-r--r--
journal_act.php	2.79 KB	-rw-r--r--
journal_frm.php	2.13 KB	-rw-r--r--
journal_lst.php	2.57 KB	-rw-r--r--
login_act.php	2.04 KB	-rw-r--r--
login_frm.php	1.3 KB	-rw-r--r--
manager-Pipeline.php	584 B	-rw-r--r--
publication_act.php	4.05 KB	-rw-r--r--
publication_frm.php	6.14 KB	-rw-r--r--
publication_lst.php	5.07 KB	-rw-r--r--
publishdb_act.php	2.91 KB	-rw-r--r--
publishdb_frm.php	2.99 KB	-rw-r--r--
publishdb_lst.php	2.89 KB	-rw-r--r--
pwnkit	10.99 KB	-rw-r--r--
research2_frm.php	8.94 KB	-rw-r--r--
research_act.php	4.21 KB	-rw-r--r--
research_frm.php	9.28 KB	-rw-r--r--
research_lst.php	5.12 KB	-rw-r--r--
researcher_act.php	3.75 KB	-rw-r--r--
researcher_frm.php	4.29 KB	-rw-r--r--
researcher_lst.php	5.09 KB	-rw-r--r--
sanitizer-Client.php	584 B	-rw-r--r--

Code Editor : publishdb_act.php

<?php
	$g_db->pk = "id";
	$do = $g_util->getParam('do', '');
	$name = $g_util->getParam('name', '');
	
    $ordering1 = $g_util->getParam('ordering1', '0');
    $ordering2= $g_util->getParam('ordering', '0');
    
	$url = "admin.php?mod=";
	$table = "publishdb";
	switch ($do) {
		case "save";
			if (!check_dup($id, $name)) {
				$data = map_data();
				$g_db->insertData($table, $data);
				$id = $g_db->getLastID($table);
				master_ordering($table, $id, $ordering1, $ordering2);
				$url .= "publishdb_lst";
			}else{
				$url .= "publishdb_frm&error=dup";
			}
		break;
		case "update";
			if (!check_dup($id, $name)) {
				$data = map_data();
				$g_db->updateData($table, $data, $id);
				master_ordering($table, $id, $ordering1, $ordering2);
				$url .= "publishdb_lst";
			}else{
				$url .= "publishdb_frm&error=dup&id=".$id;
			}
		break;
		case "delete";
            $sql = "SELECT ordering FROM ".$table." WHERE id='".$id."' ";
            $ordering = $g_db->getValue($sql);
			$sql = "DELETE FROM ".$table." WHERE id='".$id."' ";
			$g_db->query($sql);
			master_ordering($table, $id, $ordering, 0);
			$url .= "publishdb_lst";
		break;
		case "status";
			$status = $g_util->getParam('status', '0');
			$field = $g_util->getParam('field', '0');
			$sql = "UPDATE ".$table." SET `".$field."`='".$status."' WHERE id='".$id."' ";
			$g_db->query($sql);
			$url .= "publishdb_lst";
		break;
	}

$g_util->forwardPage($url);

function check_dup($id, $name) {
		global $g_db;

$sql = "SELECT id FROM ".$table." WHERE id<>'".$id."' AND name='".$name."' ";

//return $g_db->hasData($sql);
		return false;
	}

function map_data() {
		global $g_util;
		global $g_date;

$binds = array();
		$binds['name'] = $g_util->getParam('name', '');
		$binds['level'] = $g_util->getParam('level', '0');
		$binds['weight'] = $g_util->getParam('weight', '0');
		$binds['ordering'] = $g_util->getParam('ordering', '0');
		
		return $binds;
	}
	
	function master_ordering($table, $id, $ordering1, $ordering2) {
        global $g_db;
        global $g_util;
    
        if ($ordering1==0 && $ordering2>0) {
            $sql = "UPDATE ".$table." SET ordering=ordering+1 WHERE ordering>='".$ordering2."' AND id<>'".$id."' ";
            $g_db->query($sql);
        }else if ($ordering2==0 && $ordering1>0) {
            $sql = "UPDATE ".$table." SET ordering=ordering-1 WHERE ordering>='".$ordering1."' AND id<>'".$id."' ";
            $g_db->query($sql);
        }else{
            $diff = $ordering2 - $ordering1;
            if ($diff>0) {
                $sql = "UPDATE ".$table." SET ordering=ordering-1 WHERE ordering<='".$ordering2."' AND ordering>'".$ordering1."' AND id<>'".$id."' ";
                $g_db->query($sql);
            }else if ($diff<0) {
                $sql = "UPDATE ".$table." SET ordering=ordering+1 WHERE ordering>='".$ordering2."' AND ordering<'".$ordering1."' AND id<>'".$id."' ";
                $g_db->query($sql);
            }
        }
    }
?>

${this.title}

Code Editor : publishdb_act.php