0)
$result = $row["last_id"];
return $result;
}
function GetRow($query) {
global $link;
if (empty($link)) {
$link = Connect();
}
$result = mysqli_query($link, $query);
$row = array();
if ($result) {
$row = mysqli_fetch_assoc($result);
mysqli_free_result($result);
}
return $row;
}
function GetRows($query) {
global $link;
if (empty($link)) {
$link = Connect();
}
$result = mysqli_query($link, $query);
$rows = array();
if ($result) {
while($row = mysqli_fetch_assoc($result)) {
$rows[] = $row;
}
mysqli_free_result($result);
}
return $rows;
}
function Insert($table_name, $data) {
reset($data);
while(list($mezo, $ertek) = each($data))
$items[$mezo] = "$mezo='{$ertek}'";
$script = "insert into $table_name set " . join(", ", $items);
// print "
Insert:" . $script . "
";
RunScript($script);
return GetLastInsertId();
}
function RunScript($script) {
global $link;
if (empty($link)) {
$link = Connect();
}
mysqli_query($link, $script);
}
function RunSelect($query) {
// print "
RunSelect:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function Update($script) {
global $link;
if (empty($link)) {
$link = Connect();
}
mysqli_query($link, $script);
return mysqli_affected_rows($link);
}
// Scripts
function CloseRagacsList($datum) {
$script = "update ragacslists set lezarva = Now() where lezarva is null and ragasztas_datum = '$datum'";
// print "
CloseRagacsList:" . $script . "
";
return Update($script);
}
function OpenRagacsList($datum) {
$script = "update ragacslists set lezarva = null where lezarva is not null and ragasztas_datum = '$datum'";
// print "
OpenRagacsList:" . $script . "
";
return Update($script);
}
function DeleteRagacsList($datum) {
$script = "delete from ragacslists where (lezarva is null or lezarva = 0) and uploadedphoto = 0 and ragasztas_datum = '$datum'";
// print "
CloseRagacsList:" . $script . "
";
errorlog($script);
return Delete($script);
}
function DeleteKampany($kampanyId, $datum) {
$script = "delete from ragacslists where (lezarva is null or lezarva = 0) and kampany_id = $kampanyId and ragasztas_datum = '$datum'";
// print "
DeleteKampany:" . $script . "
";
errorlog($script);
return Delete($script);
}
function CloseKampany($kampanyId, $datum) {
$script = "update ragacslists set lezarva = Now() where lezarva is null and kampany_id = $kampanyId and ragasztas_datum = '$datum'";
// print "
CloseKampany:" . $script . "
";
return Update($script);
}
function OpenKampany($kampanyId, $datum) {
$script = "update ragacslists set lezarva = null where lezarva is not null and kampany_id = $kampanyId and ragasztas_datum = '$datum'";
// print "
OpenKampany:" . $script . "
";
return Update($script);
}
function DeleteDailyEmail($dailyEmailId) {
$script = "delete from dailyemails where dailyemail_id = $dailyEmailId";
// print "
DeleteDailyEmail:" . $script . "
";
return Delete($script);
}
function DeleteFelulet($feluletId) {
$script = "delete from ragacslists where ragacslist_id = $feluletId";
// print "
DeleteFelulet:" . $script . "
";
errorlog($script);
return Delete($script);
}
function DeleteRagasztoAdminSelectedUserByRAdminUserId($id) {
$script = "delete from ragasztoadminusers where radminuser_id = $id and user_id != 1";
// print "
DeleteRagasztoAdminSelectedUserByRAdminUserId:" . $script . "
";
return Delete($script);
}
function DeleteRagasztoAdminSelectedUser($id) {
$script = "delete from ragasztoadminusers where ragasztoadminuser_id = $id";
// print "
DeleteRagasztoAdminSelectedUser:" . $script . "
";
return Delete($script);
}
function DeleteUser($userId) {
$script = "delete from users where user_id = $userId";
// print "
DeleteUser:" . $script . "
";
return Delete($script);
}
function GetCegek() {
$query = "select * from ceg where ceg_id > 0 order by nev";
// print "
GetCegek:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetLocalCegek() {
$query = "select * from ceg where ceg_id > 0 and local_ceg = 1 order by nev";
// print "
GetLocalCegek:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetClientData($cegId) {
$query = "select * from ceg where ceg_id = $cegId";
// print "
GetClientData:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetCegIdByName($nev) {
$nev = strtolower($nev);
$query = "select ceg_id from ceg where lower(nev) = '$nev'";
// print "
GetCegIdByName:" . $query . "
";
$row = GetRow($query);
$cegId = 0;
if (is_array($row) && isset($row["ceg_id"]))
$cegId = $row["ceg_id"];
return $cegId;
}
function GetDailyEmails() {
$query = "select * from dailyemails";
// print "
GetDailyEmails:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetDailyEmailByCegId($cegId) {
$query = "select * from dailyemails where ceg_id = $cegId";
// print "
GetDailyEmailByCegId:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetAllFelulet() {
$query = "select * from ragacslists order by ragacslist_id";
// print "
GetAllFelulet:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetFelulet($id) {
$query = "select rl.*, v.varos from ragacslists rl left join varos v on (rl.varos_id = v.varos_id) where rl.ragacslist_id = $id";
// print "
GetFelulet:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetFeluletekByKampanyId($kampany_id) {
$query = "select rl.*, v.varos from ragacslists rl left join varos v on (rl.varos_id = v.varos_id) where rl.kampany_id = $kampany_id";
// print "
GetFeluletekByKampanyId:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetFeluletekByRagasztasDatum($datum) {
$query = "select * from ragacslists where (lezarva is null or lezarva = 0) and uploadedphoto = 0 and ragasztas_datum = '$datum'";
// print "
GetFeluletekByRagasztasDatum:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetFeluletekByUser($user_id) {
$query = "select * from ragacslists where user_id = $user_id order by ragasztas_datum";
// print "
GetFeluletekByUser:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetFeluletDbByUser($userId) {
$query = "select count(*) as db from ragacslists where user_id = $userId";
// print "
GetFeluletDbByUser:" . $query . "
";
$row = GetRow($query);
return $row["db"];
}
function GetFeluletDbIsNeedPhotoByUser($userId) {
$query = "select count(*) as db from ragacslists where isneedphoto = 1 and uploadedphoto = 0 and user_id = $userId";
// print "
GetFeluletDbIsNeedPhotoByUser:" . $query . "
";
$row = GetRow($query);
return $row["db"];
}
function GetFeluletek($kezdodatum, $vegsodatum, $userId, $isAdmin, $varosId, $kampanyId, $feluletKod = "", $searchFeluletKodCenter = 0, $surfaceId = 0, $closed = false, $isNeedPhoto = 0, $fkezdodatum = "", $fvegsodatum = "", $uploadedPhoto = "", $cegId = 0, $plakatNev = "", $surfaceType = 0) {
$surface = "";
if ($surfaceId == 1)
$surface = " and rl.uploadedphoto > 0";
else if ($surfaceId == 2)
$surface = " and rl.uploadedphoto = 0";
if ($isNeedPhoto == 1)
$surface .= " and rl.isneedphoto = 1";
if ($plakatNev != "")
$surface .= " and rl.plakat like '$plakatNev%%'";
if ($surfaceType == 1)
$surface .= " and (rl.felulettipus = 'CLP' or rl.felulettipus = 'CIT')";
else if ($surfaceType == 2)
$surface .= " and rl.felulettipus != 'CLP' and rl.felulettipus != 'CIT'";
/* if ($fkezdodatum != "")
$surface .= " and rl.lastuploadedphoto_datum >= '$fkezdodatum 00:00:00'";
if ($fvegsodatum != "")
$surface .= " and rl.lastuploadedphoto_datum <= '$fvegsodatum 23:59:59'";*/
if ($uploadedPhoto != "" && is_numeric($uploadedPhoto))
$surface .= " and rl.uploadedphoto = $uploadedPhoto";
if ($cegId > 0)
$surface .= " and rl.ceg_id = $cegId";
$query = sprintf("select rl.*, u.name as ragaszto, v.varos from users u, ragacslists rl left join varos v on (rl.varos_id = v.varos_id)
where rl.ragasztas_datum >= '$kezdodatum'
and rl.ragasztas_datum <= '$vegsodatum'
and u.user_id = rl.user_id $surface
and rl.plakat not like '%%ÁTFUTÓ%%' and rl.plakat not like '%%ATFUTO%%'
%s %s %s %s %s %s order by rl.felulet_kod",
$searchFeluletKodCenter ? " and substr(rl.felulet_kod, " . SEARCH_FELULETKOD_FROM . ", " . SEARCH_FELULETKOD_LENGTH . ") like '$feluletKod%'" : " and rl.felulet_kod like '$feluletKod%'",
empty($varosId) ? "" : " and rl.varos_id = $varosId",
(($userId > 1 and $isAdmin == 0) or ($userId > 1 and $isAdmin == 1)) ? " and rl.user_id = $userId" : "",
($isAdmin == 2) ? " and (rl.user_id = $userId or rl.user_id in (Select user_id from ragasztoadminusers where radminuser_id = $userId))" : "",
empty($kampanyId) ? "" : " and rl.kampany_id like '$kampanyId%'",
empty($closed) ? "" : " and (rl.lezarva is null or rl.lezarva = 0 or rl.lezarva >= date(sysdate()))");
// errorlog("GetFeluletek: " . $query);
// print "
GetFeluletek:" . $query . "
";
$rows = GetRows($query);
if ($surfaceId == 3) { // csak a javito fotokat tartalmazo feluletek kellenek
$rows_ = array();
foreach($rows as $row) {
$kampanyId = $row["kampany_id"];
$feluletKod = $row["felulet_kod"];
$ragacsDatum = $row["ragasztas_datum"];
$folder = PHOTO_DIRECTORY . date("Y", strtotime($ragacsDatum)) . "/" . date("m", strtotime($ragacsDatum)) . "/" . $kampanyId . "/" . date("Y.m.d.", strtotime($ragacsDatum));
if (file_exists($folder)) {
$files = scandir($folder);
for ($i = 0; $i < count($files); $i++) {
if (strpos($files[$i], $feluletKod) !== false && strpos($files[$i], "_J.") !== false) {
if (!isFeluletExists($rows_, $row))
$rows_[] = $row;
}
}
}
}
$rows = $rows_;
}
return $rows;
}
function GetFeluletByFeluletKodRagasztasiDatum($feluletKod, $ragasztasDatum) {
$query = "Select * from ragacslists where trim(felulet_kod) = '$feluletKod' and ragasztas_datum = '$ragasztasDatum' and lezarva is null";
$row = GetRow($query);
// print "
GetFeluletByFeluletKodRagasztasiDatum:" . $query . "
";
return $row;
}
function GetFeluletBySajatKodRagasztasiDatum($sajatKod, $ragasztasDatum) {
$query = "Select * from ragacslists where trim(sajat_kod) = '$sajatKod' and ragasztas_datum = '$ragasztasDatum' and lezarva is null";
$row = GetRow($query);
// print "
GetFeluletBySajatKodRagasztasiDatum:" . $query . "
";
return $row;
}
function GetFeluletCegId($ragasztasDatum, $feluletKod) {
$query = "Select ceg_id from ragacslists where trim(felulet_kod) = '$feluletKod' and ragasztas_datum = '$ragasztasDatum' and lezarva is null";
$row = GetRow($query);
// print "
GetFeluletCegId:" . $query . "
";
return $row["ceg_id"];
}
function GetFeluletCegIdByFeluletId($feluletId) {
$query = "Select ceg_id from ragacslists where ragacslist_id = $feluletId";
$row = GetRow($query);
// print "
GetFeluletCegIdByFeluletId:" . $query . "
";
return $row["ceg_id"];
}
function GetFeluletId($feluletKod, $ragasztasDatum) {
$query = "Select ragacslist_id from ragacslists where trim(felulet_kod) = '$feluletKod' and ragasztas_datum = '$ragasztasDatum' and lezarva is null";
$row = GetRow($query);
// print "
GetFeluletId:" . $query . "
";
return $row["ragacslist_id"];
}
function GetFeluletKod($id) {
$query = "select felulet_kod from ragacslists where ragacslist_id = $id";
// print "
GetFeluletKod:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetJobToClients() {
$query = "select * from jobtoclients where feltoltes_datum is null and probak_szama <= 900";
// print "
GetJobToClients:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetJobToClientsDb($ragacslistId) {
$query = "select count(*) as db from jobtoclients where ragacslist_id = $ragacslistId and feltoltes_datum is null";
// print "
GetJobToClientsDb:" . $query . "
";
$row = GetRow($query);
return $row["db"];
}
function GetJobToServer() {
$query = "select * from jobtoserver where feltoltes_datum is null";
// print "
GetJobToServer:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
// feluletek szama, amihez van kep feltoltve
function GetFeluletDbByKampanyIdDatum($kampanyId, $datum) {
$query = "select count(*) as db from ragacslists where (lezarva is null or lezarva = 0) and kampany_id = $kampanyId and ragasztas_datum = '$datum' and uploadedphoto > 0";
// print "
GetFeluletDbByKampanyIdDatum:" . $query . "
";
$row = GetRow($query);
return $row["db"];
}
function GetRagasztoAdminUsers($userId) {
$query = "select * from ragasztoadminusers where radminuser_id = $userId";
// print "
GetRagasztoAdminUsers:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetRagasztoUsers() {
$query = "select user_id, name, username, isadmin, isdisabled from users where (isadmin = 0 or isadmin = 2) and isdisabled = 0 order by name";
// print "
GetRagasztoUsers:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetRagasztasDatumIntervallum($userId) {
$query = sprintf("select min(ragasztas_datum) as datefrom, max(ragasztas_datum) as dateto from ragacslists
where lezarva is null %s",
empty($userId) ? "" : " and user_id = $userId");
// print "
GetRagasztasDatumIntervallum:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetUploadedPhotoDb($ragacsDatum) {
$query = "select sum(uploadedphoto) as db FROM ragacslists where ragasztas_datum = '$ragacsDatum' and lezarva is null or lezarva = 0";
// print "
GetUploadedPhotoDb:" . $query . "
";
$row = GetRow($query);
return $row["db"];
}
function GetUser($userId) {
$query = "select * from users where user_id = $userId";
// print "
GetUser:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetUserByLogin($username, $password) {
$query = "select user_id, name, username, isadmin, isdisabled from users
where username = '$username' and password = '$password' and isdisabled = 0";
// print "
GetUserByLogin:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetUserByName($name) {
$query = "select user_id, name, username, isadmin, isdisabled from users
where name = '$name'";
// print "
GetUserByName:" . $query . "
";
$row = GetRow($query);
return $row;
}
function GetUsersByRagasztoAdmin($userId) {
$query = "select u.user_id, u.name, (Select 1 from ragasztoadminusers r where r.radminuser_id = $userId and r.user_id = u.user_id) as selected from users u where user_id = 1 || isadmin = 0 order by u.name";
// print "
GetUsersByRagasztoAdmin:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetUsersByRagasztasDatum($datum) {
$query = sprintf("select distinct user_id from ragacslists where ragasztas_datum = '$datum' and lezarva is null or lezarva = 0");
// print "
GetUsersByRagasztasDatum:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetUserPassword($userId) {
$query = "select password from users where user_id = $userId";
// print "
GetUserPassword:" . $query . "
";
$row = GetRow($query);
return $row["password"];
}
function GetUsers() {
$query = "select user_id, name, username, password, isadmin, isdisabled from users order by name";
// print "
GetUsers:" . $query . "
";
// errorlog("GetUsers: " . $query);
$rows = GetRows($query);
return $rows;
}
function GetUserVarosok($userId) {
$query = "Select distinct v.* from varos v, ragacslists rl where v.varos_id = rl.varos_id and rl.user_id = $userId";
// print "
GetUserVarosok:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function GetVarosId($varos) {
$varosId = 0;
$query = "select varos_id from varos where varos = '$varos'";
// print "
GetVarosId:" . $query . "
";
$row = GetRow($query);
if (isset($row["varos_id"]) && $row["varos_id"] != null)
$varosId = $row["varos_id"];
return $varosId;
}
function GetVarosok() {
$query = "select * from varos order by varos";
// print "
GetVaros:" . $query . "
";
$rows = GetRows($query);
return $rows;
}
function InsertDailyEmails($cegId, $subject, $body) {
$script = "insert into dailyemails set ceg_id = $cegId, subject = '$subject', body = '$body'";
// print "
InsertDailyEmails:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function InsertJobToClients($ragacslistId) {
$script = "insert into jobtoclients set ragacslist_id = $ragacslistId, letrehozas_datum = Now()";
// print "
InsertJobToClients:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function InsertJobToServer($fileName, $feluletKod = "", $kampanyId = 0, $datum = "") {
$script = "insert into jobtoserver set filename = '$fileName', felulet_kod = '$feluletKod', kampany_id = $kampanyId, ragasztas_datum = '$datum', letrehozas_datum = Now()";
// print "
InsertJobToServer:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function InsertUser($name, $username, $password, $isAdmin, $isDisabled) {
$options = ['cost' => HASH_OPTIONS_COST, 'salt' => HASH_OPTIONS_SALT];
$password = password_hash($password, PASSWORD_BCRYPT, $options);
$script = "insert into users set name = '$name', username = '$username', password = '$password', isadmin = $isAdmin, isdisabled = $isDisabled";
RunScript($script);
return GetLastInsertId();
}
function InsertRagacsList($feluletKod, $sajatKod, $feluletTipus, $kampanyId, $kampanyNev, $varosId, $feluletCim, $plakat, $isNeedPhoto, $userId, $ragasztasDatum, $cegId) {
$script = "insert into ragacslists set ceg_id = $cegId, felulet_kod = '$feluletKod', sajat_kod = '$sajatKod', felulettipus = '$feluletTipus', kampany_id = $kampanyId, kampany_nev = '$kampanyNev', varos_id = $varosId, felulet_cim = '$feluletCim', plakat = '$plakat', isneedphoto = $isNeedPhoto, user_id = $userId, ragasztas_datum = '$ragasztasDatum', uploadedphoto = 0";
// print "
InsertRagacsList:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function InsertRagacsListBackup($feluletId, $cegId, $feluletKod, $sajatKod, $feluletTipus, $kampanyId, $kampanyNev, $varosId, $feluletCim, $plakat, $userId, $ragasztasDatum, $lezarva, $lastuploadedphotoDatum, $uploadedPhoto, $isNeedPhoto, $kihelyezesiFotoDatumok = "", $javitoFotoDatumok = "") {
$script = "insert into ragacslists_backup set ragacslist_id = $feluletId, ceg_id = $cegId, felulet_kod = '$feluletKod', sajat_kod = '$sajatKod', felulettipus = '$feluletTipus', kampany_id = $kampanyId, kampany_nev = '$kampanyNev', varos_id = $varosId, felulet_cim = '$feluletCim', plakat = '$plakat', user_id = $userId, ragasztas_datum = '$ragasztasDatum', lezarva = " . (is_null($lezarva) ? 'NULL' : '$lezarva') . ", lastuploadedphoto_datum = " . (is_null($lastuploadedphotoDatum) ? 'NULL' : '$lastuploadedphotoDatum') . ", uploadedphoto = $uploadedPhoto, isneedphoto = $isNeedPhoto, kihelyezesi_foto_datumok = '$kihelyezesiFotoDatumok', javito_foto_datumok = '$javitoFotoDatumok', backup_datum = NOW()";
// print "
InsertRagacsListBackup:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function InsertRagasztoAdminUser($ragasztoAdminUserId, $userId) {
$script = "insert into ragasztoadminusers set radminuser_id = $ragasztoAdminUserId, user_id = $userId";
// print "
InsertRagasztoAdminUser:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function InsertVaros($varos) {
$script = "insert into varos set varos = '$varos'";
RunScript($script);
return GetLastInsertId();
}
function ModifyPlakatName($kampanyId, $oldPlakatName, $newPlakatName) {
$script = "update ragacslists set plakat = '$newPlakatName' where kampany_id = $kampanyId and plakat = '$oldPlakatName'";
// print "
ModifyPlakatName:" . $script . "
";
return Update($script);
}
function SetRagasztoAdminUsers($id, $selectedUsers) {
$presentSelectedUsers = GetRagasztoAdminUsers($id);
// ha az osszes ki van jelolve, akkor a tobbit toroljuk es felvesszuk az 1-et
$allUsers = false;
foreach($selectedUsers as $userId) {
if ($userId == 1)
$allUsers = true;
}
if ($allUsers) {
DeleteRagasztoAdminSelectedUserByRAdminUserId($id);
$isExist = false;
foreach($presentSelectedUsers as $user) {
if ($user["user_id"] == 1)
$isExist = true;
}
if (!$isExist) // nincs benne, felvesszuk
InsertRagasztoAdminUser($id, 1);
} else {
foreach($presentSelectedUsers as $user) {
if (!in_array($user["user_id"], $selectedUsers)) { // ha nincs benne, toroljuk
DeleteRagasztoAdminSelectedUser($user["ragasztoadminuser_id"]);
}
}
foreach($selectedUsers as $userId) {
$isExist = false;
foreach($presentSelectedUsers as $user) {
if ($user["user_id"] == $userId)
$isExist = true;
}
if (!$isExist) { // nincs benne, hozzaadjuk
InsertRagasztoAdminUser($id, $userId);
}
}
}
}
function UpdateDailyEmails($cegId, $body) {
$script = "update dailyemails set body = '$body' where ceg_id = $cegId";
// print "
UpdateDailyEmails:" . $script . "
";
errorlog($script);
RunScript($script);
return GetLastInsertId();
}
function UpdateJobToClients($jobToClientId, $ret) {
if ($ret == 1)
$script = "update jobtoclients set feltoltes_datum = Now(), probak_szama = probak_szama+1 where jobtoclient_id = $jobToClientId";
else
$script = "update jobtoclients set probak_szama = probak_szama+1 where jobtoclient_id = $jobToClientId";
// print "
UpdateJobToClients:" . $script . "
";
return Update($script);
}
function UpdateJobToServer($jobToServerId, $ret) {
if ($ret)
$script = "update jobtoserver set feltoltes_datum = Now(), probak_szama = probak_szama+1 where jobtoserver_id = $jobToServerId";
else
$script = "update jobtoserver set probak_szama = probak_szama+1 where jobtoserver_id = $jobToServerId";
// print "
UpdateJobToServer:" . $script . "
";
return Update($script);
}
function UpdatePhotoDates($feluletId, $kihelyezesiFotoDatumok, $javitoFotoDatumok) {
$script = "update ragacslists set kihelyezesi_foto_datumok = '$kihelyezesiFotoDatumok', javito_foto_datumok = '$javitoFotoDatumok' where ragacslist_id = $feluletId";
// print "
UpdatePhotoDates:" . $script . "
";
errorlog($script);
return Update($script);
}
function UpdateRagacsList($feluletId, $feluletTipus, $kampanyId, $kampanyNev, $varosId, $feluletCim, $plakat, $isNeedPhoto, $userId) {
if (SERVER_SIDE)
$script = "update ragacslists set felulettipus = '$feluletTipus', kampany_id = $kampanyId, kampany_nev = '$kampanyNev', varos_id = $varosId, felulet_cim = '$feluletCim', isneedphoto = $isNeedPhoto where ragacslist_id = $feluletId";
else
$script = "update ragacslists set felulettipus = '$feluletTipus', kampany_id = $kampanyId, kampany_nev = '$kampanyNev', varos_id = $varosId, felulet_cim = '$feluletCim', plakat = '$plakat', isneedphoto = $isNeedPhoto, user_id = $userId where ragacslist_id = $feluletId";
// print "
UpdateRagacsList:" . $script . "
";
errorlog($script);
return Update($script);
}
function UpdateRagacsList2($feluletId, $plakat, $userId) {
$script = "update ragacslists set plakat = '$plakat', user_id = $userId where ragacslist_id = $feluletId and lezarva is null";
// print "
UpdateRagacsList2:" . $script . "
";
errorlog($script);
return Update($script);
}
function UpdateUploadedPhoto($feluletId, $db) {
if ($db > 0)
$script = "update ragacslists set uploadedphoto = $db, lastuploadedphoto_datum = Now() where ragacslist_id = $feluletId";
else
$script = "update ragacslists set uploadedphoto = $db, lastuploadedphoto_datum = null where ragacslist_id = $feluletId";
// print "
UpdateUploadedPhoto:" . $script . "
";
errorlog($script);
return Update($script);
}
function UpdateUploadedPhoto2($feluletId, $db, $lastUploadedPhotoDatum) {
if ($db > 0)
$script = "update ragacslists set uploadedphoto = $db, lastuploadedphoto_datum = '$lastUploadedPhotoDatum' where ragacslist_id = $feluletId";
else
$script = "update ragacslists set uploadedphoto = $db, lastuploadedphoto_datum = null where ragacslist_id = $feluletId";
// print "
UpdateUploadedPhoto2:" . $script . "
";
errorlog($script);
return Update($script);
}
function UpdateUploadedPhoto3($feluletKod, $kampanyId, $ragacsDatum, $lastUploadedPhotoDatum, $uploadedPhoto, $kihelyezesiFotoDatumok = "", $javitoFotoDatumok = "") {
$ret = 0;
if ($uploadedPhoto > 0) {
if ($lastUploadedPhotoDatum == "")
$script = "update ragacslists set uploadedphoto = $uploadedPhoto, kihelyezesi_foto_datumok = '$kihelyezesiFotoDatumok', javito_foto_datumok = '$javitoFotoDatumok', lastuploadedphoto_datum = Now() where (felulet_kod = '$feluletKod' or sajat_kod = '$feluletKod') and kampany_id = $kampanyId and ragasztas_datum = '$ragacsDatum'";
else
$script = "update ragacslists set uploadedphoto = $uploadedPhoto, kihelyezesi_foto_datumok = '$kihelyezesiFotoDatumok', javito_foto_datumok = '$javitoFotoDatumok', lastuploadedphoto_datum = '$lastUploadedPhotoDatum' where (felulet_kod = '$feluletKod' or sajat_kod = '$feluletKod') and kampany_id = $kampanyId and ragasztas_datum = '$ragacsDatum'";
} else {
$script = "update ragacslists set uploadedphoto = $uploadedPhoto, kihelyezesi_foto_datumok = '', javito_foto_datumok = '', lastuploadedphoto_datum = null where (felulet_kod = '$feluletKod' or sajat_kod = '$feluletKod') and kampany_id = $kampanyId and ragasztas_datum = '$ragacsDatum'";
}
// print "
UpdateUploadedPhoto3:" . $script . "
";
errorlog($script);
$ret = Update($script);
if ($ret == 0) {
$query = "Select count(*) as db from ragacslists where (felulet_kod = '$feluletKod' or sajat_kod = '$feluletKod') and kampany_id = $kampanyId and ragasztas_datum = '$ragacsDatum'";
$row = GetRow($query);
$ret = $row["db"];
}
return $ret;
}
function UpdateUser($userId, $name, $username, $password, $isAdmin, $isDisabled) {
$script = "update users set name = '$name', username = '$username', password = '$password', isadmin = $isAdmin, isdisabled = $isDisabled where user_id = $userId";
// print "
UpdateUser:" . $script . "
";
return Update($script);
}
function UpdateUserPassword($userId, $password) {
$script = "update users set password = '$password' where user_id = $userId";
// print "
UpdateUserPassword:" . $script . "
";
return Update($script);
}
?>