$lon = (double) $wpt['lon'];
$type = (string) $cache->type;
$typeId = DB::queryFirstField("SELECT id FROM type WHERE type=%s LIMIT 1", $type);
$difficulty = (int) $cache->difficulty;
$terrain = (int) $cache->terrain;
$country = (string) $cache->country;
$url = (string) $wpt->url;
foreach ($cache->logs->log as $log) {
$gc = (string) $wpt->name;
$name = (string) $cache->name;
$username = (string) $log->finder;
$logtext = (string) $log->text;
$logType = (string) $log->type;
$logDate = substr((string) $log->date, 0, 10);
if ($inserted == 0) {
DB::insertIgnore('user', array('username' => $username));
$inserted = 1;
$userId = DB::queryFirstField("SELECT id FROM user WHERE username=%s LIMIT 1", $username);
$logIds = DB::queryFirstColumn("SELECT log.id FROM image, log WHERE image.log = log.id AND log.user = %i", $userId);
foreach ($logIds as $logId) {
DB::delete('image', "log=%i", $logId);
}
DB::delete('log', "user=%i", $userId);
}
DB::insertUpdate('geocache', array('gc' => $gc, 'name' => $name, 'type' => $typeId, 'lat' => $lat, 'lon' => $lon, 'difficulty' => $difficulty, 'terrain' => $terrain, 'country' => $country, 'url' => $url));
$geocacheId = DB::queryFirstField("SELECT id FROM geocache WHERE gc = %s LIMIT 1", $gc);
$logTypeId = DB::queryFirstField("SELECT id FROM logtype WHERE type = %s LIMIT 1", $logType);
DB::insert('log', array('user' => $userId, 'geocache' => $geocacheId, 'created' => $logDate, 'type' => $logTypeId, 'log' => $logtext));
}
$finds++;
}
<?php
require_once 'general.php';
require_once 'connection.php';
require_once 'logger.php';
require_once 'checkLogin.php';
if (isset($_GET['addUser'])) {
DB::insertUpdate('user', array('username' => $_GET['addUser']));
DB::insertIgnore('feed', array('user' => DB::queryFirstField("SELECT id FROM user WHERE username = %s", getSessionUser()), 'feeduser' => DB::queryFirstField("SELECT id FROM user WHERE username = %s", $_GET['addUser'])));
} else {
if (isset($_GET['removeUser'])) {
$user = DB::queryFirstField("SELECT id FROM user WHERE username = %s", getSessionUser());
$feedUser = DB::queryFirstField("SELECT id FROM user WHERE username = %s", $_GET['removeUser']);
DB::delete('feed', 'user=%s AND feeduser='******'components/head.html';
printBodyTag();
showNavigation();
?>
<div class="panel-body">
<div class='panel panel-info'>
<div class='panel-heading'>Add user to feed and index</div>
<div class='panel-body'>
<form class="form-inline">
<div class="form-group">
<input class="form-control" name="addUser" placeholder="Username">
function test_6_insert_ignore()
{
DB::insertIgnore('accounts', array('id' => 1, 'username' => 'gonesoon', 'password' => 'something', 'age' => 61, 'height' => 199.194));
}
<?php
require '../../boot.php';
require '../../session.php';
if (!isset($session) || $session->auth == "") {
Common::Error(401, 'json');
}
$config = Config::get('evaluasi');
$req = Request::all();
$data = $req['d'];
for ($i = 0; $i < count($data); $i++) {
$data[$i]['renstra'] = $config->renstra;
$dt = DB::insertIgnore('tabel_renstra', $data[$i]);
$da = DB::insertIgnore('indikator_anggaran_renstra', ['renstra' => $config->renstra, 'kd_kegiatan' => $data[$i]['kd_urusan'] . $data[$i]['kd_bidang'] . $data[$i]['kd_program'] . $data[$i]['kd_kegiatan'], 'kd_unit' => $data[$i]['kd_unit'], 'kd_subunit' => $data[$i]['kd_sub_unit']]);
}
if ($dt) {
$hasil = ["success" => true, "message" => "Data berhasil dimasukkan"];
} else {
$hasil = ["success" => false, "message" => "Data gagal dimasukkan"];
}
echo json_encode($hasil);
exit;
