function popular($skin_dir = 'basic', $pop_cnt = 7, $date_cnt = 3)
{
global $config, $g5;
if (!$skin_dir) {
$skin_dir = 'basic';
}
$date_gap = date("Y-m-d", G5_SERVER_TIME - $date_cnt * 86400);
$sql = " select pp_word, count(*) as cnt from {$g5['popular_table']} where pp_date between '{$date_gap}' and '" . G5_TIME_YMD . "' group by pp_word order by cnt desc, pp_word limit 0, {$pop_cnt} ";
$result = sql_query($sql);
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$list[$i] = $row;
// 스크립트등의 실행금지
$list[$i]['pp_word'] = get_text($list[$i]['pp_word']);
}
ob_start();
if (G5_IS_MOBILE) {
$popular_skin_path = G5_MOBILE_PATH . '/' . G5_SKIN_DIR . '/popular/' . $skin_dir;
$popular_skin_url = G5_MOBILE_URL . '/' . G5_SKIN_DIR . '/popular/' . $skin_dir;
} else {
$popular_skin_path = G5_SKIN_PATH . '/popular/' . $skin_dir;
$popular_skin_url = G5_SKIN_URL . '/popular/' . $skin_dir;
}
include_once $popular_skin_path . '/popular.skin.php';
$content = ob_get_contents();
ob_end_clean();
return $content;
}
function sql_fetch($sql, $error = G5_DISPLAY_SQL_ERROR)
{
$result = sql_query($sql, $error);
//$row = @sql_fetch_array($result) or die("<p>$sql<p>" . mysql_errno() . " : " . mysql_error() . "<p>error file : $_SERVER['SCRIPT_NAME']");
$row = sql_fetch_array($result);
return $row;
}
function latest($skin_dir = "", $bo_table, $rows = 10, $subject_len = 40, $options = "")
{
global $g4;
if ($skin_dir) {
$GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g4['path']}/skin/latest/{$skin_dir}";
} else {
$GLOBALS['latest_skin_path'] = $latest_skin_path = "{$g4['path']}/skin/latest/basic";
}
$list = array();
$sql = " select * from {$g4['board_table']} where bo_table = '{$bo_table}'";
$board = sql_fetch($sql);
$tmp_write_table = $g4['write_prefix'] . $bo_table;
// 게시판 테이블 전체이름
$sql = " select * from {$tmp_write_table} where wr_is_comment = 0 order by wr_num limit 0, {$rows} ";
//explain($sql);
$result = sql_query($sql);
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);
}
ob_start();
include "{$latest_skin_path}/latest.skin.php";
$content = ob_get_contents();
ob_end_clean();
return $content;
}
function checksuspended()
{
testremote();
$db_a = tDataConnect();
$m_conn = mDataConnect();
$query_local = "select * from suspendedtoday";
$query_remote = "select * from " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.suspendedtoday";
$query = "select * from suspendedlist";
if ($_SESSION["standalone"] == 1) {
if ($_SESSION["remoteDBMS"] == "mssql") {
$result = mssql_query($query_local, $db_a);
} else {
$result = mysql_query($query, $db_a);
}
} else {
if ($_SESSION["remoteDBMS"] == "mssql") {
$result = sql_query($query_remote, $db_a);
} else {
$result = mysql_query($query, $m_conn);
}
}
$num_rows = sql_fetch_array($result);
if ($num_rows == 0) {
return 0;
} else {
return 1;
}
sql_close($db_a);
}
public static function getFromCache($cacheid)
{
$rs = sql("SELECT latitude, longitude FROM caches WHERE cache_id = &1", $cacheid);
$r = sql_fetch_array($rs);
mysql_free_result($rs);
return new Coordinate_Coordinate($r['latitude'], $r['longitude']);
}
function object_list()
{
global $dbi;
$eventsResult = sql_query('SELECT id, version, typactive, typdesc, ttypeliga.mgroup_id FROM ttypeliga LEFT JOIN tmessagegroup ON ttypeliga.mgroup_id = tmessagegroup.mgroup_id', $dbi);
# Table header
$ret = '<table id="eventtable"><tr>';
$ret = $ret . '<td class="thead">Id</td>';
$ret = $ret . '<td class="thead">Version</td>';
$ret = $ret . '<td class="thead">Active</td>';
$ret = $ret . '<td class="thead">Description</td>';
$ret = $ret . '<td class="thead">Message group id</td>';
$ret = $ret . '<td class="thead">Edit</td>';
$ret = $ret . '<td class="thead">Delete</td>';
while (list($id, $version, $typactive, $typdesc, $mgroup_id) = sql_fetch_row($eventsResult, $dbi)) {
$ret = $ret . '<tr>';
$ret = $ret . '<td>' . $id . '</td>';
$ret = $ret . '<td>' . $version . '</td>';
$ret = $ret . '<td>' . ($typactive == 1 ? 'Ja' : 'Nein') . '</td>';
$ret = $ret . '<td>' . $typdesc . '</td>';
$mgroup_result = sql_query('SELECT mgroupname FROM tmessagegroup WHERE mgroup_id = ' . $mgroup_id, $dbi);
$mgroup_name = sql_fetch_array($mgroup_result, $dbi);
$ret = $ret . '<td>' . $mgroup_name[0] . '</td>';
$ret = $ret . '<td><img src="images/edit24.png" style="cursor: pointer;" onclick="window.location.href = \'admin_liga_types.php?op=edit&id=' . $id . '\'" /></td>';
$ret = $ret . '<td align="center"><img src="images/del_icon.png" style="cursor: pointer;" onclick="window.location.href = \'admin_liga_types.php?op=delete&id=' . $id . '\'" /></td>';
$ret = $ret . '</tr>';
}
return $ret . '</table>';
}
function listposts(){
global $db;
$locality=GETSTR('locality');
if(!$locality){echo json_encode(array("success"=>"false"));}
$query="select * from artworks where locality='$locality' order by likes desc";
$rs=sql_query($query, $db);
if(!$rs){echo json_encode(array("success:false"));die();}
$data=array();
while($myrow=sql_fetch_array($rs)){
array_push($data, array(
"artworkid"=>$myrow['artworkid']+0,
"createdate"=>$myrow['createdate']+0,
"userid"=>$myrow['userid'],
"price"=>$myrow['price']+0,
"likes"=>$myrow['likes']+0,
"geolat"=>$myrow['geolat']+0,
"geolong"=>$myrow['geolong']+0,
"image"=>$myrow['image'],
"onsale"=>$myrow['onsale']+0,
"title"=>$myrow['title'],
"locality"=>$myrow['locality']
));
}
$stats=array("itemcount"=>sql_affected_rows($db,$rs));
$response=array("data"=>$data, "stats"=>$stats);
echo json_encode($response);
}
function t($message, $style, $resource_name, $line, $plural = '', $count = 1, $lang = null)
{
global $opt, $locale;
// $locale is for lib1 compatibility
if ($message == '') {
return '';
}
if ($plural != '' && $count != 1) {
$message = $plural;
}
$search = $this->prepare_text($message);
$loc = isset($opt['template']['locale']) ? $opt['template']['locale'] : $locale;
if (!$lang || $lang == $loc) {
$trans = gettext($search);
} else {
// do not use sql_value(), as this is also used from lib1
$rs = sql("SELECT IFNULL(`sys_trans_text`.`text`, '&3')\n\t\t\t FROM `sys_trans` \n\t\t\t LEFT JOIN `sys_trans_text` ON `sys_trans`.`id`=`sys_trans_text`.`trans_id` AND `sys_trans_text`.`lang`='&1'\n\t\t\t\t\t\t\t\t\tWHERE `sys_trans`.`text`='&2' LIMIT 1", $lang, $search, $message);
if ($r = sql_fetch_array($rs)) {
$trans = $r[0];
} else {
$trans = '';
}
sql_free_result($rs);
}
// safe w/o mb because asc(%) < 128
if (strpos($trans, "%") >= 0) {
$trans = $this->v($trans);
}
return $trans;
}
public function getCacheNote($userid, $cacheid)
{
$rs = sql("SELECT id, latitude, longitude, description FROM coordinates WHERE user_id = &1 AND cache_id = &2 AND type = &3", $userid, $cacheid, Coordinate_Type::UserNote);
$ret = $this->recordToArray(sql_fetch_array($rs));
mysql_free_result($rs);
return $ret;
}
function CheckThrottle()
{
global $opt, $tpl;
$ip_string = $_SERVER['REMOTE_ADDR'];
$ip_blocks = mb_split('\\.', $ip_string);
$ip_numeric = $ip_blocks[3] + $ip_blocks[2] * 256 + $ip_blocks[1] * 65536 + $ip_blocks[0] * 16777216;
sql('CREATE TABLE IF NOT EXISTS &tmpdb.`sys_accesslog`
(`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `ip` INT UNSIGNED NOT NULL,
`access_time` TIMESTAMP NOT NULL, INDEX (`access_time`), INDEX (`ip`)) ENGINE = MEMORY');
$rsStaus = sql("SHOW STATUS LIKE 'Threads_connected'");
$rStatus = sql_fetch_array($rsStaus);
sql_free_result($rsStaus);
if ($rStatus) {
if ($rStatus[1] > $opt['db']['throttle_connection_count']) {
$access_count = sql_value("SELECT COUNT(*) FROM &tmpdb.`sys_accesslog` WHERE ip ='&1'", 0, $ip_numeric);
if ($access_count > $opt['db']['throttle_access_count']) {
$tpl->error(ERROR_THROOTLE);
}
}
}
// remove old entries every 100st call
if (mt_rand(0, 100) == 50) {
sql("DELETE FROM &tmpdb.`sys_accesslog` WHERE `access_time`<CURRENT_TIMESTAMP()-'&2'", $ip_numeric, $opt['db']['throttle_access_time']);
}
sql("INSERT INTO &tmpdb.`sys_accesslog` (`ip`, `access_time`) VALUES ('&1', CURRENT_TIMESTAMP())", $ip_numeric);
}
function suspendorder()
{
testremote();
$query_a = "select emp_no, trans_no from localtemptrans";
$db_a = tDataConnect();
$result_a = sql_query($query_a, $db_a);
$row_a = sql_fetch_array($result_a);
$cashier_no = substr("000" . $row_a["emp_no"], -2);
$trans_no = substr("0000" . $row_a["trans_no"], -4);
if ($_SESSION["standalone"] == 0) {
if ($_SESSION["remoteDBMS"] == "mssql") {
$query = "insert " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.suspended select * from localtemptrans";
$result = sql_query($query, $db_a);
} else {
$query = "insert suspended select * from localtemptrans";
$result = sql_query($query, $db_a);
if (uploadtable("suspended") == 1) {
cleartemptrans();
}
}
} else {
$query = "insert suspended select * from localtemptrans";
$result = sql_query($query, $db_a);
}
$_SESSION["plainmsg"] = "transaction suspended";
$_SESSION["msg"] = 2;
receipt("suspended");
$recall_line = $_SESSION["standalone"] . " " . $_SESSION["laneno"] . " " . $cashier_no . " " . $trans_no;
gohome();
sql_close($db_a);
}
function check_user_level($user_id)
{
if (!$user_id) {
throw new UnexpectedValueException();
}
$r = sql_fetch_array(sql_query("SELECT user_rating10, user_level, user_shown_level FROM users WHERE user_id={$user_id} LIMIT 1"));
$next_level = $r['user_level'];
if (!$next_level) {
throw new Exception();
}
$last_shown_level = $r['user_shown_level'];
if ($next_level > $last_shown_level) {
return $next_level;
}
while (true) {
$points_for_next_level = get_rating4level($next_level);
if (floor($r['user_rating10'] / 10) >= $points_for_next_level) {
$next_level++;
continue;
}
break;
}
$next_level--;
if ($next_level == $r['user_level']) {
return 0;
}
return $next_level;
}
/**
*
* 연혁 출력
*
* @param string $his_id
* @param string $skin_dir
* @return string $content
*/
function history($his_id, $skin_dir = '', $group = null)
{
global $g5;
$sql = "select * from `{$g5['history_master_table']}` where his_id = '{$his_id}'";
$history = sql_fetch($sql);
if (!$skin_dir) {
$skin_dir = $history['his_skin'];
}
$history_skin_path = get_skin_path('history', $skin_dir);
$history_skin_url = get_skin_url('history', $skin_dir);
$sortable = "order by his_item_year " . $history['his_sort'] . ', his_item_month ' . $history['his_sort'] . ', his_item_day ' . $history['his_sort'];
$histories = array();
$group_histories = array();
for ($i = $history['his_start_year'], $y = $history['his_end_year']; $i <= $history['his_end_year'], $y >= $history['his_start_year']; $i++, $y--) {
$history_item = array();
$conditions = array("his_item_disable = ''", "his_id = '{$his_id}'");
if (!is_null($group)) {
$conditions['group'] = "his_group_id = '{$group}'";
}
if ($history['his_sort'] == 'asc') {
$item_year = $i;
} else {
$item_year = $y;
}
$conditions[] = "his_item_year = '{$item_year}'";
$condition = count($conditions) > 0 ? 'where ' . implode(' and ', $conditions) : '';
$sql = "select * from `{$g5['history_item_table']}` {$condition} {$sortable}";
$result = sql_query($sql);
while ($item = sql_fetch_array($result)) {
switch ($history['his_output_type']) {
case 'a':
$item['date'] = $item['his_item_year'] . '.' . $item['his_item_month'] . '.' . $item['his_item_day'];
break;
case 'y':
$item['date'] = '';
break;
case 'm':
$item['date'] = $item['his_item_month'];
break;
case 'd':
$item['date'] = $item['his_item_month'] . '.' . $item['his_item_day'];
break;
case 'i':
$item['date'] = $item['his_item_date'];
break;
}
$history_item[] = $item;
$all_history_item[] = $item;
}
$histories[$item_year] = $history_item;
}
$histories = array_filter($histories);
ob_start();
include $history_skin_path . '/history.skin.php';
$content = ob_get_contents();
ob_end_clean();
return $content;
}
function get_npas($cache_id)
{
$rsNPA = sql("SELECT `npa_areas`.`name` AS `npaName`, `npa_types`.`name` AS `npaTypeName`\n\t FROM `cache_npa_areas`\n\t INNER JOIN `npa_areas` ON `cache_npa_areas`.`npa_id`=`npa_areas`.`id`\n\t INNER JOIN `npa_types` ON `npa_areas`.`type_id`=`npa_types`.`id`\n\t WHERE `cache_npa_areas`.`cache_id`='&1'\n\t GROUP BY `npa_areas`.`type_id`, `npa_areas`.`name`\n\t ORDER BY `npa_types`.`ordinal` ASC", $cache_id);
$npas = array();
while ($rNPA = sql_fetch_array($rsNPA)) {
$npas[] = $rNPA;
}
sql_free_result($rsNPA);
return $npas;
}
public function getChildWps($cacheid)
{
$rs = sql("SELECT id, cache_id, subtype, latitude, longitude, description FROM coordinates WHERE cache_id = &1 AND type = &2", $cacheid, Coordinate_Type::ChildWaypoint);
$ret = array();
while ($r = sql_fetch_array($rs)) {
$ret[] = $this->recordToArray($r);
}
mysql_free_result($rs);
return $ret;
}
function eb_banner($loccd)
{
global $g5, $theme, $eb, $member;
$link_path = G5_DATA_URL . '/banner/';
if (!$member['mb_level']) {
$member['mb_level'] = 1;
}
// 배너위치로 등록된 배너 불러오기
$sql = "select * from {$g5['eyoom_banner']} where bn_view_level <= '{$member['mb_level']}' and bn_theme='{$theme}' and bn_location = '" . $loccd . "' and bn_state = '1' order by bn_regdt desc";
$result = sql_query($sql, false);
$this_date = date('Ymd');
for ($i = 0; $row = sql_fetch_array($result); $i++) {
if ($row['bn_period'] == '2') {
if ($this_date >= $row['bn_start'] && $this_date <= $row['bn_end']) {
$banner[$i][$row['bn_no']] = $row;
} else {
continue;
}
} else {
$banner[$i][$row['bn_no']] = $row;
}
}
$max_num = count($banner) - 1;
mt_srand((double) microtime() * 1000000);
$num = mt_rand(0, $max_num);
$bn = $banner[$num];
$bn_no = key($bn);
$data = $banner[$num][$bn_no];
unset($banner);
if ($data) {
if ($data['bn_type'] == 'intra') {
$img = $data['bn_img'];
$data['image'] = $link_path . $theme . '/' . $img;
if ($data['bn_link'] == '') {
$data['bn_link'] = 'nolink';
}
$data['tag_img'] = '<img class="img-responsive full-width" src="' . $data['image'] . '" align="absmiddle">';
if ($data['bn_link'] != '' && $data['bn_link'] != 'nolink') {
$tocken = $eb->encrypt_md5($bn_no . "||" . $_SERVER['REMOTE_ADDR'] . "||" . $data['bn_link']);
$data['html'] = '<a id="banner_' . $data['bn_no'] . '" href="' . G5_BBS_URL . '/banner.php?tocken=' . $tocken . '" target="' . $data['bn_target'] . '">';
$data['html'] .= $data['tag_img'];
$data['html'] .= '</a>';
} else {
$data['html'] = $data['tag_img'];
}
} else {
if ($data['bn_type'] == 'extra') {
$data['html'] = stripslashes($data['bn_code']);
}
}
$banner[] = $data;
}
sql_query("update {$g5['eyoom_banner']} set bn_exposed = bn_exposed + 1 where bn_no = '{$bn_no}'");
return $banner;
}
function search_output()
{
global $sqldebug;
/*
cacheid
name
latitude
longitude
type
size
difficulty
terrain
username
waypoint
*/
$sql = '
SELECT
&searchtmp.`cache_id` `cacheid`,
&searchtmp.`longitude`,
&searchtmp.`latitude`,
`caches`.`name`,
`caches`.`wp_oc`,
`caches`.`terrain`,
`caches`.`difficulty`,
`cache_type`.`short` `typedesc`,
`cache_size`.`name` `sizedesc`,
`user`.`username`
FROM
&searchtmp,
`caches`,
`cache_type`,
`cache_size`,
`user`
WHERE
&searchtmp.`cache_id`=`caches`.`cache_id` AND
&searchtmp.`type`=`cache_type`.`id` AND
&searchtmp.`size`=`cache_size`.`id` AND
&searchtmp.`user_id`=`user`.`user_id`';
$rs = sql_slave($sql, $sqldebug);
while ($r = sql_fetch_array($rs)) {
$lat = sprintf('%07d', $r['latitude'] * 100000);
$lon = sprintf('%07d', $r['longitude'] * 100000);
$name = convert_string($r['name']);
$username = convert_string($r['username']);
$type = convert_string($r['typedesc']);
$size = convert_string($r['sizedesc']);
$difficulty = sprintf('%01.1f', $r['difficulty'] / 2);
$terrain = sprintf('%01.1f', $r['terrain'] / 2);
$cacheid = convert_string($r['wp_oc']);
$line = "{$name} by {$username}, {$type}, {$size}, {$cacheid}";
$record = pack("CLllA*x", 2, 1 + 4 + 4 + 4 + strlen($line) + 1, (int) $lon, (int) $lat, $line);
append_output($record);
}
mysql_free_result($rs);
}
function run()
{
$rsPublish = sql("SELECT `cache_id`, `user_id` FROM `caches` WHERE `status`=5 AND NOT ISNULL(`date_activate`) AND `date_activate`<=NOW()");
while ($rPublish = sql_fetch_array($rsPublish)) {
$userid = $rPublish['user_id'];
$cacheid = $rPublish['cache_id'];
// update cache status to active
sql("UPDATE `caches` SET `status`=1, `date_activate`=NULL WHERE `cache_id`='&1'", $cacheid);
}
sql_free_result($rsPublish);
}
/**
* purpose: NEW request speichern - status creation, sowie erzeugen der dummyobj childtabellen
* params: vid,request formular
* returns: unique req_id
* rem: we pass the vid from the form, enabling the Admin to change it
*/
function _saverequest($req_type, $v_id)
{
global $dbi, $usertoken;
if (!$req_type > 0) {
debug('Error :: Request Type not set ...');
return;
}
if (!$v_id > 0) {
debug('Error :: Verein not set ...');
return;
}
$rkey = 'r' . time();
$d = getdate();
$rtdate = $d['year'] . '-' . $d['mon'] . '-' . $d['mday'];
if (is_array($usertoken)) {
$uid = $usertoken['id'];
} else {
die('E1');
}
/*
* create request with STATUS=CREATE, using the param: v_id instead of the usertoken ...
*/
$qry = 'insert into wfrequest(wfrequest_id,reqdate,user_id,verein_id,wfrequesttype_id,wfstate_id,rkey)' . ' values(0,\'' . $rtdate . '\',' . $usertoken['id'] . ',' . $v_id . ',' . $req_type . ',1,\'' . $rkey . '\')';
#debug($qry);
$prec = sql_query($qry, $dbi);
# get ID
$p = sql_query('select R.*,T.wftablename wfobject from wfrequest R,wfrequesttype T where R.wfrequesttype_id=T.wfrequesttype_id and rkey=\'' . $rkey . '\'', $dbi);
$ret = sql_fetch_array($p, $dbi);
if (sizeof($ret) < 2) {
die('<h3>Error creating initial request object</h3>');
}
// create child records ...
switch ($ret['wfobject']) {
case 'wflineup':
$qry = 'INSERT INTO wflineup(wflineup_id,wfrequest_id,rkey) VALUES (0,' . $ret['wfrequest_id'] . ',\'' . $rkey . '\')';
$p = sql_query($qry, $dbi);
break;
case 'wfplayer':
$qry = 'INSERT INTO wfplayer(wfplayer_id,wfrequest_id,rkey) VALUES (0,' . $ret['wfrequest_id'] . ',\'' . $rkey . '\')';
$p = sql_query($qry, $dbi);
break;
case 'wfteam':
// create empty wfteam
$qry = 'INSERT INTO wfteam(wfteam_id,wfrequest_id,rkey) VALUES (0,' . $ret['wfrequest_id'] . ',\'' . $rkey . '\')';
$p = sql_query($qry, $dbi);
break;
case 'wfmessage':
// create empty wfmessage
$qry = 'INSERT INTO wfmessage(wfmessage_id,wfrequest_id,rkey) VALUES (0,' . $ret['wfrequest_id'] . ',\'' . $rkey . '\')';
$p = sql_query($qry, $dbi);
break;
}
return $ret['wfrequest_id'];
}
public function outputFeed()
{
header('Content-type: application/rss+xml; charset="utf-8"');
$content = $this->getRssHeader();
$rs = $this->feed_data->getItems();
while ($r = sql_fetch_array($rs)) {
$content .= $this->getItemLine($r);
}
mysql_free_result($rs);
$content .= "\n </channel>\n</rss>";
echo $content;
}
function auth_UsernameFromID($userid)
{
//select the right user
$rs = sql("SELECT `username` FROM `user` WHERE `user_id`='&1'", $userid);
if (mysql_num_rows($rs) > 0) {
$record = sql_fetch_array($rs);
return $record['username'];
} else {
//user not exists
return false;
}
}
function couponcode($upc)
{
$man_id = substr($upc, 3, 5);
$fam = substr($upc, 8, 3);
$val = substr($upc, -2);
$db = pDataConnect();
$query = "select * from couponcodes where code = '" . $val . "'";
$result = sql_query($query, $db);
$num_rows = sql_num_rows($result);
if ($num_rows == 0) {
boxMsg("coupon type unknown<br>please enter coupon<br>manually");
} else {
$row = sql_fetch_array($result);
$value = $row["Value"];
$qty = $row["Qty"];
if ($fam == "992") {
$value = truncate2($value);
$_SESSION["couponupc"] = $upc;
$_SESSION["couponamt"] = $value;
maindisplay("coupondeptsearch.php");
} else {
sql_close($db);
$fam = substr($fam, 0, 2);
$query = "select " . "max(unitPrice) as total, " . "max(department) as department, " . "sum(ItemQtty) as qty, " . "sum(case when trans_status = 'C' then -1 else quantity end) as couponqtty " . "from localtemptrans where substring(upc, 4, 5) = '" . $man_id . "' " . "group by substring(upc, 4, 5)";
$db = tDataConnect();
$result = sql_query($query, $db);
$num_rows = sql_num_rows($result);
if ($num_rows > 0) {
$row = sql_fetch_array($result);
if ($row["couponqtty"] < 1) {
boxMsg("Coupon already applied<BR>for this item");
} else {
$dept = $row["department"];
$act_qty = $row["qty"];
if ($qty <= $act_qty) {
if ($value == 0) {
$value = -1 * $row["total"];
}
$value = truncate2($value);
addcoupon($upc, $dept, $value);
lastpage();
} else {
boxMsg("coupon requires " . $qty . "items<BR>there are only " . $act_qty . " item(s)<BR>in this transaction");
}
}
} else {
boxMsg("product not found<BR>in transaction");
}
// sql_close($db);
}
}
}
function admin_getpaypaltransactions($currency = false, $from = false, $to = false)
{
$qu = sql_exec("select xid,min(time) as time," . "subtract_money('',sum_money(change)) as change " . "from transaction_log where " . "xid in (select xid from transaction_log where " . "(account like 'anon-deposits:%' or " . "account like 'deposits:%' or " . "account like 'subscription-payments:%' or " . "account like 'withdrawals:%')" . ($currency === false ? "" : " and change like '%" . sql_escape($currency) . "'") . ($from === false ? "" : " and time >= " . intval($from)) . ($to === false ? "" : " and time < " . intval($to)) . ") and (account like 'anon-deposits:%' or " . "account like 'deposits:%' or " . "account='paypal-fee' or " . "account like 'subscription-payments:%' or " . "account like 'withdrawals:%') " . "group by xid order by xid");
if ($qu === false) {
return private_dberr();
}
$transactions = array();
for ($i = 0; $i < sql_numrows($qu); $i++) {
$row = sql_fetch_array($qu, $i);
$transactions[intval($row["xid"])] = array("xid" => intval($row["xid"]), "time" => intval($row["time"]), "change" => "{$row['change']}");
}
return array(0, $transactions);
}
function nexttransno()
{
$next_trans_no = 1;
$db = pDataConnect();
sql_query("update globalvalues set transno = transno + 1", $db);
$result = sql_query("select transno from globalvalues", $db);
$num_rows = sql_num_rows($result);
if ($num_rows != 0) {
$row = sql_fetch_array($result);
$next_trans_no = $row["transno"];
}
sql_close($db);
}
public function run()
{
global $login;
$rsPublish = sql("SELECT `cache_id`, `user_id`\n FROM `caches`\n WHERE `status`=5\n AND NOT ISNULL(`date_activate`)\n AND `date_activate`<=NOW()");
while ($rPublish = sql_fetch_array($rsPublish)) {
$userid = $rPublish['user_id'];
$cacheid = $rPublish['cache_id'];
// update cache status to active
sql("SET @STATUS_CHANGE_USER_ID='&1'", $login->userid);
sql("UPDATE `caches` SET `status`=1, `date_activate`=NULL WHERE `cache_id`='&1'", $cacheid);
}
sql_free_result($rsPublish);
}
function __construct($nUserId = ID_NEW)
{
$this->nUserId = $nUserId + 0;
if ($nUserId == ID_NEW) {
$rs = sqll('SELECT `id`, `name`, `default_value`, `check_regex`, `option_order`, 0 AS `option_visible`, `internal_use`, `default_value` AS `option_value`
FROM `profile_options`');
} else {
$rs = sqll("SELECT `p`.`id`, `p`.`name`, `p`.`default_value`, `p`.`check_regex`, `p`.`option_order`, IFNULL(`u`.`option_visible`, 0) AS `option_visible`, `p`.`internal_use`, IFNULL(`u`.`option_value`, `p`.`default_value`) AS `option_value`\r\n\t\t\t\t\t\tFROM `profile_options` AS `p`\r\n\t\t\t\t\t\tLEFT JOIN `user_options` AS `u` ON `p`.`id`=`u`.`option_id` AND (`u`.`user_id` IS NULL OR `u`.`user_id`='&1')\r\n\t\t\t\t\tUNION \r\n\t\t\t\t\t\tSELECT `u`.`option_id` AS `id`, `p`.`name`, `p`.`default_value`, `p`.`check_regex`, `p`.`option_order`, `u`.`option_visible`, `p`.`internal_use`, IFNULL(`u`.`option_value`, `p`.`default_value`) AS `option_value`\r\n\t\t\t\t\t\tFROM `user_options` AS `u`\r\n\t\t\t\t\t\tLEFT JOIN `profile_options` AS `p` ON `p`.`id`=`u`.`option_id`\r\n\t\t\t\t\t\tWHERE `u`.`user_id`='&1'", $this->nUserId);
}
while ($record = sql_fetch_array($rs)) {
$this->nOptions[$record['id']] = $record;
}
sql_free_result($rs);
}
function getbyKEY($keyval)
{
// tested OK
// retrieve data and put into associative array
if (sizeof($this->appkeyfield) > 1) {
if (strlen($keyval) > 0) {
$sSQL = 'select * from ' . $this->dataTable . ' WHERE ' . $this->appkeyfield . '=\'' . $keyval . '\'';
$rec = sql_query($sSQL, $this->DB);
$this->aDATA = sql_fetch_array($rec, $this->DB);
}
} else {
$this->pError = 'No appkey defined';
}
}
function landkreisFromLocid($locid)
{
global $dblink;
if (!is_numeric($locid)) {
return '';
}
$locid = $locid + 0;
$rs = sql("SELECT `rb`.`text_val` `regierungsbezirk` FROM `geodb_textdata` `ct`, `geodb_textdata` `rb`, `geodb_hierarchies` `hr` WHERE `ct`.`loc_id`=`hr`.`loc_id` AND `hr`.`id_lvl5`=`rb`.`loc_id` AND `ct`.`text_type`=500100000 AND `rb`.`text_type`=500100000 AND `ct`.`loc_id`='&1' AND `hr`.`id_lvl5`!=0", $locid);
if ($r = sql_fetch_array($rs)) {
return $r['regierungsbezirk'];
} else {
return 0;
}
}
function clubCard($intItemNum)
{
$query = "select * from localtemptrans where trans_id = " . $intItemNum;
$connection = tDataConnect();
$result = sql_query($query, $connection);
$row = sql_fetch_array($result);
$num_rows = sql_num_rows($result);
if ($num_rows > 0) {
$strUPC = $row["upc"];
$strDescription = $row["description"];
$dblVolSpecial = $row["VolSpecial"];
$dblquantity = -0.5 * $row["quantity"];
$dblTotal = truncate2(-1 * 0.5 * $row["total"]);
// invoked truncate2 rounding function to fix half-penny errors apbw 3/7/05
$strCardNo = $_SESSION["memberID"];
$dblDiscount = $row["discount"];
$dblmemDiscount = $row["memDiscount"];
$intDiscountable = $row["discountable"];
$dblUnitPrice = $row["unitPrice"];
$intScale = nullwrap($row["scale"]);
if ($row["foodstamp"] != 0) {
$intFoodStamp = 1;
} else {
$intFoodStamp = 0;
}
$intdiscounttype = nullwrap($row["discounttype"]);
if ($row["voided"] == 20) {
boxMsg("Discount already taken");
} elseif ($row["trans_type"] == "T" or $row["trans_status"] == "D" or $row["trans_status"] == "V" or $row["trans_status"] == "C") {
boxMsg("Item cannot be discounted");
} elseif (strncasecmp($strDescription, "Club Card", 9) == 0) {
//----- edited by abpw 2/15/05 -----
boxMsg("Item cannot be discounted");
} elseif ($_SESSION["tenderTotal"] < 0 and $intFoodStamp == 1 and -1 * $dblTotal > $_SESSION["fsEligible"]) {
boxMsg("Item already paid for");
} elseif ($_SESSION["tenderTotal"] < 0 and -1 * $dblTotal > $_SESSION["runningTotal"] - $_SESSION["taxTotal"]) {
boxMsg("Item already paid for");
} else {
// --- added partial item desc to club card description - apbw 2/15/05 ---
addItem($strUPC, "Club Card: " . substr($strDescription, 0, 19), "I", "", "J", $row["department"], $dblquantity, $dblUnitPrice, $dblTotal, 0.5 * $row["regPrice"], $intScale, $row["tax"], $intFoodStamp, $dblDiscount, $dblmemDiscount, $intDiscountable, $intdiscounttype, $dblquantity, $row["volDiscType"], $row["volume"], $dblVolSpecial, 0, 0, 0);
$update = "update localtemptrans set voided = 20 where trans_id = " . $intItemNum;
$connection = tDataConnect();
sql_query($update, $connection);
$_SESSION["TTLflag"] = 0;
$_SESSION["TTLRequested"] = 0;
lastpage();
}
}
}
function setDrawerKickLater()
{
// this more complex version can be modified to kick the drawer under whatever circumstances the FE Mgr sees fit
// it currently kicks the drawer *only* for cash in & out
$db = tDataConnect();
$query = "select * from localtemptrans where trans_subtype = 'CA' and total <> 0";
$result = sql_query($query, $db);
$num_rows = sql_num_rows($result);
$row = sql_fetch_array($result);
if ($num_rows != 0) {
$_SESSION["kick"] = 1;
} else {
$_SESSION["kick"] = 0;
}
}
