function addCom($nid, $message, $uid)
{
$cid = insertSQL("insert into comments (content,uid,time) values('{$message}',{$uid},now())");
if ($cid) {
insertsql("insert into com_news(cid,nid) values({$cid},{$nid})");
}
return $cid;
}
}
}
if ($blnPaperStatusflg) {
$strValue = $obj["strPaperStatus" . $i];
$strField = "strPaperStatus";
$strWhere = $strWhereBF . "and field_name='" . $strField . "' ";
$result = updateSQL($con, $db, $strClm, $strValue, $strTable, $strWhere);
if ($result == false) {
goto NsSome_ERROR;
}
} else {
$strClm = "db_id, doc_id, field_name, no, type, value";
$strField = "strPaperStatus";
$strTgtVal = $obj["strPaperStatus" . $i];
$strValue = "'{$strDBID}' , '{$strDocID}' , '{$strField}' , 0 , 11 , '{$strTgtVal}'";
$result = insertSQL($con, $db, $strClm, $strValue, $strTable, $strWhere);
if ($result == false) {
goto NsSome_ERROR;
}
}
//*******名前の変更********
$intType = $obj["intType" . $i];
$strCate1 = $obj["strCategory1" . $i];
$strCate2 = $obj["strCategory2" . $i];
$strCate3 = $obj["strCategory3" . $i];
$strDir = $obj["strDir" . $i];
$strValue = $obj["strSubject" . $i];
$strParentID = $obj["strParentID" . $i];
$strField = "strSubject";
$strSQL = "update ns_string set ";
$strSQL = $strSQL . "value='" . $strValue . "' ";
function addGala($gala, $aid)
{
return insertSQL("insert into galaxy(aid,gala) values ({$aid},{$gala})");
}
$nomsIMG = "";
if ($nbreFILE != 0) {
foreach ($tableauIMGx["nomimg"] as &$value) {
$nomsIMG .= "{$value}/";
}
// on concatene les valeurs
$nomsIMG = substr($nomsIMG, 0, -1);
}
//############CONNECTION BBD###############
if (connection($dbb)) {
if ($nomsIMG == "") {
$parametres = array("colonnes" => array("date", "titre", "contenu", "sujet", "auteur", "nomcouverture"), "valeurs" => array($_POST['titre'], $_POST['contenu'], $_POST['sujet'], $_POST['pseudo'], 'default.jpg'));
} else {
$parametres = array("colonnes" => array("date", "titre", "contenu", "sujet", "auteur", "nomcouverture", "nbreIMG", "nomsIMG"), "valeurs" => array($_POST['titre'], $_POST['contenu'], $_POST['sujet'], $_POST['pseudo'], 'default.jpg', $nbreFILE, $nomsIMG));
}
$rep = insertSQL($dbb, 'articles', $parametres);
if ($rep != FALSE) {
if ($nbreFILE != 0) {
for ($i = 0; $i < $nbreFILE; $i++) {
move_uploaded_file($tableauIMGx["tmp_nameimg"][$i], $tableauIMGx["dest_finimg"][$i]);
}
}
header('location: ../index.php');
// puis redirection vers la page de rédaction
} else {
echo "error ma tête";
}
} else {
echo $dbb;
}
} else {
$m['png_status'] = '1';
updateSQL('ppt', $m, "`id`='{$ra[$i]['id']}'");
`rm -fr {$base_dir}/tmp/png/{$ra[$i]['id']}`;
`mkdir {$base_dir}/tmp/png/{$ra[$i]['id']} -p`;
`cp {$base_dir}/OUTPUT/pdf/{$ra[$i]['id']}.pdf {$base_dir}/tmp/png/{$ra[$i]['id']}/{$ra[$i]['id']}.pdf`;
`cd {$base_dir}/tmp/png/{$ra[$i]['id']} && convert {$ra[$i]['id']}.pdf {$ra[$i]['id']}.png`;
$files = glob("{$base_dir}/tmp/png/{$ra[$i]['id']}/*.png");
natcasesort($files);
$files = array_values($files);
deleteSQL("ppt_items", "`ppt_id`='{$ra[$i]['id']}'");
for ($j = 0; $j < count($files); $j++) {
$p = $j + 1;
`cd {$base_dir}/tmp/png/{$ra[$i]['id']} && /usr/bin/pdftotext -f {$p} -l {$p} {$ra[$i]['id']}.pdf {$j}.txt`;
$bn = basename($files[$j]);
$m = array();
$m['ppt_id'] = $ra[$i]['id'];
$m['filename'] = $bn;
$m['page'] = $j + 1;
$m['contents'] = file_get_contents("{$base_dir}/tmp/png/{$ra[$i]['id']}/{$j}.txt");
$m['keyword'] = "";
$m['kind'] = "";
$m['grades'] = "0";
insertSQL("ppt_items", $m);
}
`mkdir {$base_dir}/OUTPUT/png/{$ra[$i]['id']} -p`;
`cp {$base_dir}/tmp/png/{$ra[$i]['id']}/*.png {$base_dir}/OUTPUT/png/{$ra[$i]['id']}/`;
`rm -fr {$base_dir}/tmp/png/{$ra[$i]['id']}`;
$m = array();
$m['png_status'] = '2';
updateSQL('ppt', $m, "`id`='{$ra[$i]['id']}'");
}
function addToLogfile($descr, $cat, $uid = "NULL")
{
$descr = $descr . "<br>IP: " . $_SERVER['REMOTE_ADDR'];
$descr = addslashes($descr);
return insertSQL("insert into actionlog (descr,uid,time,cat) values('{$descr}',{$uid},Now(),'{$cat}')");
}
$m['upload_datetime'] = date('Y-m-d H:i:s');
$m['title'] = "";
$m['keyword'] = "";
$m['author'] = "";
switch ($sn) {
case 'pdf':
//如果傳的是pdf，就不用傳了
$m['pdf_status'] = "2";
break;
default:
$m['pdf_status'] = "0";
break;
}
$m['png_status'] = "0";
$m['text_status'] = "0";
$LAST_ID = insertSQL('ppt', $m);
switch ($sn) {
case 'pdf':
copy("{$base_dir}/upload/{$nfilename}", "{$OUTPUT_PDF}/{$LAST_ID}.pdf");
break;
}
}
?>
<div style="background-color:pink;text-align:center;">
上傳成功<br>
</div>
<br>
<?php
location_replace("admin/maintain.php");
exit;
break;
function addGroup($name, $descr, $title)
{
if (!$name || !$descr) {
echo "db.group:addGroup Fehlender Parameter!";
return;
}
$gid = insertSQL("insert into groups (name, descr, usertitle) values('{$name}','{$descr}','{$title}')");
if (!$gid) {
echo "db.group:addGroup Einfügen fehlgeschlagen!";
return;
}
return $gid;
}
function bot_add($name, $login, $password, $soapurl, $host = "")
{
return insertSQL("\n insert into ircbots (name,login,password,host,soapurl)\n values ('{$name}','{$login}','{$password}','{$host}','{$soapurl}')\n ");
}
$db_selected = mysql_select_db('sample', $link);
if (!$db_selected) {
die('データベース選択失敗です。' . mysql_error());
}
$result = mysql_query('SELECT * FROM boards');
if (!$result) {
die('クエリーが失敗しました。' . mysql_error());
}
$row = mysql_fetch_row($result);
//while ($row = mysql_fetch_assoc($result)) {
// print($row['id']);
// print($row['name']);
//}
$aaa = selectSQL($link, $db_selected, "count(*)", "boards", "id = 1");
$bbb = updateSQL($link, $db_selected, "name", "aiueo", "boards", "id = 1");
$ccc = insertSQL($link, $db_selected, "id", 10, "boards");
function selectSQL($objCon, $selectDB, $strClm, $strTable, $strWhere)
{
$strSql = "select " . $strClm;
$strSql .= " from " . $strTable;
$strSql .= " where " . $strWhere;
//$result = mysql_query('SELECT * FROM boards');
// $result = mysql_query($strSql,$objCon);
$result = mysql_query($strSql);
$row = mysql_fetch_row($result);
return $row;
}
function updateSQL($objCon, $selectDB, $strClm, $strValue, $strTable, $strWhere)
{
$strSql = "update " . $strTable;
$strSql .= " set " . $strClm . "='" . $strValue . "' ";
function miliscan_fleet_add($sid, $fleetnum, $fleet)
{
$logger =& LoggerManager::getLogger("db.scans");
$logger->debug(array("sid" => $sid, "fleetnum" => $fleetnum, "fleet" => $fleet));
Assert::isId($sid);
Assert::isNumeric($fleetnum);
$fid = fleet_add($fleet);
$insert = array("sid" => $sid, "fid" => $fid, "num" => $fleetnum);
if (strlen($fleet['type'])) {
$insert['type'] = "'" . addslashes($fleet['type']) . "'";
}
if (strlen($fleet['dir'])) {
$insert['dir'] = "'" . addslashes($fleet['dir']) . "'";
}
if (strlen($fleet['status'])) {
$insert['status'] = $fleet['status'];
}
if (strlen($fleet['return_flight'])) {
$insert['return_flight'] = $fleet['return_flight'];
}
insertSQL("\n insert into scanmili_fleet (" . join(",", array_keys($insert)) . ")\n values (" . join(",", $insert) . ")\n ");
return $fid;
}
