$mcommunew['cname'] = empty($mcommunew['cname']) ? '' : trim(strip_tags($mcommunew['cname']));
empty($mcommunew['cname']) && amessage('inputcommuname', M_REFERER);
$sqlstr = "cname='{$mcommunew['cname']}'";
foreach ($mcommu as $k => $v) {
if (!in_array($k, array('cuid', 'cname', 'issystem', 'uconfig'))) {
$sqlstr .= ",{$k}='" . addslashes($v) . "'";
}
}
$db->query("INSERT INTO {$tblprefix}mcommus SET {$sqlstr}");
$cuid = $db->insert_id();
updatecache('mcommus');
adminlog(lang('copymcomitem'));
amessage('mcommucopyfinish', "?entry=mcommus&action=mcommudetail&cuid={$cuid}");
}
} elseif ($action == 'mcommudetail' && $cuid) {
$mcommu = fetch_one($cuid);
empty($mcommu) && amessage('chooseitem');
if (!submitcheck('bmcommudetail')) {
tabheader(lang('memcomitset'), 'mcommudetail', "?entry=mcommus&action=mcommudetail&cuid={$cuid}", 2, 0, 0, 1);
trbasic(lang('item_type'), '', $cclassarr[$mcommu['cclass']], '');
trbasic(lang('item_name'), 'mcommunew[cname]', $mcommu['cname']);
if (!empty($mcommu['usetting'])) {
$str = '';
foreach ($mcommu['usetting'] as $k => $v) {
$str .= $k . '=' . $v . "\n";
}
$mcommu['usetting'] = $str;
unset($str);
}
include M_ROOT . './include/mcommus/' . $mcommu['cclass'] . '.php';
tabfooter('bmcommudetail', lang('modify'));
*/
tabheader(lang('spltemadmin'), '', '', '7');
trcategory(array(lang('sn'), lang('splangcname'), lang('type'), lang('detail')));
$sn = 0;
foreach ($splangs as $slid => $splang) {
if (empty($ftype) || $ftype == $splang['type']) {
$sn++;
echo "<tr class=\"txt\">" . "<td class=\"txtC w40\">{$sn}</td>\n" . "<td class=\"txtL\">" . $splang['cname'] . "</td>\n" . "<td class=\"txtC w120\">" . $types[$splang['type']] . "</td>\n" . "<td class=\"txtC w40\"><a href=\"?entry=splangs&action=splangdetail&slid={$slid}\">" . lang('edit') . "</a></td></tr>\n";
}
}
tabfooter();
a_guide('splangsedit');
}
} elseif ($action == 'splangdetail' && $slid) {
$forward = empty($forward) ? M_REFERER : $forward;
$splang = fetch_one($slid);
if (!submitcheck('bsplangdetail')) {
tabheader(lang('splangset'), 'splangsdetail', '?entry=splangs&action=splangdetail&slid=' . $slid . '&forward=' . urlencode($forward));
trbasic(lang('splangcname'), '', $splang['cname'], '');
trbasic(lang('splangtype'), '', $types[$splang['type']], '');
trbasic(lang('splangcontent'), 'splangnew[content]', $splang['content'], 'btextarea');
tabfooter('bsplangdetail');
a_guide('splangdetail');
} else {
if (empty($splangnew['content'])) {
amessage('datamissing', M_REFERER);
}
$db->query("UPDATE {$tblprefix}splangs SET content='{$splangnew['content']}' WHERE slid='{$slid}'");
updatecache('splangs');
adminlog(lang('detaimodifysplang'));
amessage('splmodfin', $forward);
} else {
$app->flash('error', "CAPTCHA incorrect. Please try again.");
}
$app->redirect($app->urlFor('faucet'));
})->name('claim');
$app->post("/cashout", $checkaddress($app, true), function () use($app) {
global $cashout;
$address = $app->view()->getData('address');
$balance_query = sql_query("SELECT balance FROM balances WHERE email='{$address}'");
if ($balance_query->num_rows) {
$balance = fetch_one($balance_query);
if ($balance >= $cashout) {
sql_query("UPDATE balances SET balance = balance - {$balance} WHERE email='{$address}'");
// race attacks check
$balance_query = sql_query("SELECT balance FROM balances WHERE email='{$address}'");
$balancecheck = fetch_one($balance_query);
if ($balancecheck >= 0) {
try {
sendMoney($address, $balance);
$app->flash('sentamount', true);
} catch (NoCashException $e) {
$app->flash('error', "The site does not have enough coins to pay out! No balance deducted.");
sql_query("UPDATE balances SET balance = balance + {$balance} WHERE email='{$address}'");
} catch (Exception $e) {
$response = $e->getMessage();
$app->flash('error', "An error has occured - {$response}");
sql_query("UPDATE balances SET balance = balance + {$balance} WHERE email='{$address}'");
}
}
} else {
$app->flash('error', "Amount is too small");
$murlnew['cname'] = empty($murlnew['cname']) ? '' : trim(strip_tags($murlnew['cname']));
empty($murlnew['cname']) && amessage('tagdatamiss', M_REFERER);
$sqlstr = "cname='{$murlnew['cname']}'";
foreach ($murl as $k => $v) {
if (!in_array($k, array('muid', 'cname', 'issys', 'vieworder', 'url'))) {
$sqlstr .= ",{$k}='" . addslashes($murl[$k]) . "'";
}
}
$db->query("INSERT INTO {$tblprefix}murls SET {$sqlstr}");
$muid = $db->insert_id();
updatecache('murls');
adminlog(lang('copy_url_item'));
amessage('urlcopyfinish', "?entry=murls&action=murldetail&muid={$muid}");
}
} elseif ($action == 'murldetail' && $muid) {
$murl = fetch_one($muid);
empty($murl) && amessage('choosemurl');
if (!submitcheck('bmurldetail')) {
tabheader(lang('murl_item_set'), 'murldetail', "?entry=murls&action=murldetail&muid={$muid}");
trbasic(lang('murl_name'), 'murlnew[cname]', $murl['cname']);
trbasic(lang('murl_remark'), 'murlnew[remark]', $murl['remark'], 'btext');
trbasic(lang('murl_type'), '', $uclassarr[$murl['uclass']], '');
include M_ROOT . './include/murls/' . $murl['uclass'] . '.php';
tabfooter('bmurldetail', lang('modify'));
a_guide('murldetail');
} else {
$murlnew['cname'] = empty($murlnew['cname']) ? $murl['cname'] : $murlnew['cname'];
$submitmode = true;
include M_ROOT . './include/murls/' . $murl['uclass'] . '.php';
$murlnew['tplname'] = empty($murlnew['tplname']) ? '' : trim(strip_tags($murlnew['tplname']));
$murlnew['onlyview'] = empty($murlnew['onlyview']) ? 0 : 1;
function fetch_one($id)
{
global $config;
$sequence = fetch_sequence($id);
//print_r($sequence);
}
if (0) {
$id = 'DQ502910';
$id = 'AY273103';
$id = 'FJ559180';
//$id = 'DQ502910';
//$id = 'DQ095127';
//$id = 'HQ918317';
$id = 'AY967993';
$id = 'EU220392';
$id = 'HM407788';
$id = 'AY014968';
$id = 20153277;
$id = 537783611;
$id = 13559894;
$id = 574587242;
fetch_one($id);
}
// test
if (0) {
$ids = array('DQ502910');
$ids = array('AY273103');
$ids = array('FJ559180');
$hits = fetch_sequences($ids);
print_r($hits);
}
$inmurlnew['cname'] = empty($inmurlnew['cname']) ? '' : trim(strip_tags($inmurlnew['cname']));
empty($inmurlnew['cname']) && amessage('tagdatamiss', M_REFERER);
$sqlstr = "cname='{$inmurlnew['cname']}'";
foreach ($inmurl as $k => $v) {
if (!in_array($k, array('imuid', 'cname', 'issys', 'vieworder', 'url'))) {
$sqlstr .= ",{$k}='" . addslashes($inmurl[$k]) . "'";
}
}
$db->query("INSERT INTO {$tblprefix}inmurls SET {$sqlstr}");
$imuid = $db->insert_id();
updatecache('inmurls');
adminlog(lang('copy_url_item'));
amessage('urlcopyfinish', "?entry=inmurls&action=inmurldetail&imuid={$imuid}");
}
} elseif ($action == 'inmurldetail' && $imuid) {
$inmurl = fetch_one($imuid);
empty($inmurl) && amessage('chooseinmurl');
if (!submitcheck('binmurldetail')) {
tabheader(lang('inmurl_item_set'), 'inmurldetail', "?entry=inmurls&action=inmurldetail&imuid={$imuid}");
trbasic(lang('inmurl_name'), 'inmurlnew[cname]', $inmurl['cname']);
trbasic(lang('inmurl_remark'), 'inmurlnew[remark]', $inmurl['remark'], 'btext');
trbasic(lang('inmurl_type'), '', $uclassarr[$inmurl['uclass']], '');
include M_ROOT . './include/inmurls/' . $inmurl['uclass'] . '.php';
tabfooter('binmurldetail', lang('modify'));
a_guide('inmurldetail');
} else {
$inmurlnew['cname'] = empty($inmurlnew['cname']) ? $inmurl['cname'] : $inmurlnew['cname'];
$submitmode = true;
include M_ROOT . './include/inmurls/' . $inmurl['uclass'] . '.php';
$inmurlnew['tplname'] = empty($inmurlnew['tplname']) ? '' : trim(strip_tags($inmurlnew['tplname']));
$inmurlnew['onlyview'] = empty($inmurlnew['onlyview']) ? 0 : 1;
$inurlnew['cname'] = empty($inurlnew['cname']) ? '' : trim(strip_tags($inurlnew['cname']));
empty($inurlnew['cname']) && amessage('tagdatamiss', M_REFERER);
$sqlstr = "cname='{$inurlnew['cname']}'";
foreach ($inurl as $k => $v) {
if (!in_array($k, array('iuid', 'cname', 'issys', 'vieworder', 'url'))) {
$sqlstr .= ",{$k}='" . addslashes($inurl[$k]) . "'";
}
}
$db->query("INSERT INTO {$tblprefix}inurls SET {$sqlstr}");
$iuid = $db->insert_id();
updatecache('inurls');
adminlog(lang('copy_url_item'));
amessage('urlcopyfinish', "?entry=inurls&action=inurldetail&iuid={$iuid}");
}
} elseif ($action == 'inurldetail' && $iuid) {
$inurl = fetch_one($iuid);
empty($inurl) && amessage('chooseinurl');
if (!submitcheck('binurldetail')) {
tabheader(lang('inurl_item_set'), 'inurldetail', "?entry=inurls&action=inurldetail&iuid={$iuid}");
trbasic(lang('inurl_name'), 'inurlnew[cname]', $inurl['cname']);
trbasic(lang('inurl_remark'), 'inurlnew[remark]', $inurl['remark'], 'btext');
trbasic(lang('inurl_type'), '', $uclassarr[$inurl['uclass']], '');
include M_ROOT . './include/inurls/' . $inurl['uclass'] . '.php';
tabfooter('binurldetail', lang('modify'));
a_guide('inurldetail');
} else {
$inurlnew['cname'] = empty($inurlnew['cname']) ? $inurl['cname'] : $inurlnew['cname'];
$submitmode = true;
include M_ROOT . './include/inurls/' . $inurl['uclass'] . '.php';
$inurlnew['tplname'] = empty($inurlnew['tplname']) ? '' : trim(strip_tags($inurlnew['tplname']));
$inurlnew['onlyview'] = empty($inurlnew['onlyview']) ? 0 : 1;
function getserverbalance($force = false)
{
global $apiKey, $guid, $rpchost;
if (!$force) {
// we store the server balance in sql with a spec address called 'SERVERBALANCE'
$balance_sql = "SELECT balance FROM balances WHERE email='SERVERBALANCE' ";
$balance_sql .= "AND totalbalance > " . (time() - 1800) . ";";
$balance_query = sql_query($balance_sql);
if ($balance_query->num_rows) {
$balance = fetch_one($balance_query);
return $balance;
}
}
try {
if (!empty($apiKey)) {
$balance = getCoinbaseBalance();
} elseif (!empty($guid)) {
$balance = getBlockchainBalance();
} elseif (!empty($rpchost)) {
$balance = getBitcoindBalance();
} else {
$balance = -1;
}
$date = time();
$insert_sql = "INSERT INTO balances(balance, totalbalance, email, referredby) ";
$insert_sql .= "VALUES({$balance}, '{$date}', 'SERVERBALANCE', 0) ON DUPLICATE KEY ";
$insert_sql .= "UPDATE balance = {$balance}, totalbalance = '{$date}';";
sql_query($insert_sql);
return $balance;
} catch (Exception $e) {
return 0;
}
}
}
foreach ($cotypes as $k => $cotype) {
if (!empty($sitemapnew['setting']['cosource' . $k]) && empty($sitemapnew['setting']['ccids' . $k])) {
amessage('confirmselect' . $cotype['cname'] . lang('coclass'), '?entry=sitemaps&action=sitemapdetail&ename=' . $ename);
}
}
$sitemapnew['available'] = empty($sitemapnew['available']) ? 0 : 1;
$sitemapnew['setting']['life'] = max(0, intval($sitemapnew['setting']['life']));
$sitemapnew['setting']['indays'] = max(0, intval($sitemapnew['setting']['indays']));
$sitemapnew['setting'] = addslashes(serialize($sitemapnew['setting']));
$db->query("UPDATE {$tblprefix}sitemaps SET \n\t\t\t\t\tavailable='{$sitemapnew['available']}',\n\t\t\t\t\tsetting='{$sitemapnew['setting']}'\n\t\t\t\t\tWHERE ename='{$ename}'");
updatecache('sitemaps');
amessage('sitsetfin', '?entry=sitemaps&action=sitemapdetail&ename=' . $ename);
}
} elseif ($action == 'sitemapcreate' && $ename) {
$sitemap = fetch_one($ename);
empty($sitemap) && amessage('choosesite', '?entry=sitemaps&action=sitemapsedit');
empty($sitemap['available']) && amessage('sitemapclo', '?entry=sitemaps&action=sitemapsedit');
if ($sitemap['ename'] == 'baidu') {
$chids = array();
foreach ($channels as $chid => $channel) {
$channel['baidu'] && ($chids[] = $chid);
}
empty($chids) && amessage('nobaidunews', '?entry=sitemaps&action=sitemapsedit');
}
$cachefile = M_ROOT . $sitemap['xml_url'];
include_once M_ROOT . './include/sitemap.inc.php';
str2file($datastr, $cachefile);
amessage('sitcrefin', '?entry=sitemaps&action=sitemapsedit');
}
function fetch_arr()
$aurlnew['cname'] = empty($aurlnew['cname']) ? '' : trim(strip_tags($aurlnew['cname']));
empty($aurlnew['cname']) && amessage('tagdatamiss', M_REFERER);
$sqlstr = "cname='{$aurlnew['cname']}'";
foreach ($aurl as $k => $v) {
if (!in_array($k, array('auid', 'cname', 'issys', 'vieworder', 'url'))) {
$sqlstr .= ",{$k}='" . addslashes($aurl[$k]) . "'";
}
}
$db->query("INSERT INTO {$tblprefix}aurls SET {$sqlstr}");
$auid = $db->insert_id();
updatecache('aurls');
adminlog(lang('copy_url_item'));
amessage('urlcopyfinish', "?entry=aurls&action=aurldetail&auid={$auid}");
}
} elseif ($action == 'aurldetail' && $auid) {
$aurl = fetch_one($auid);
empty($aurl) && amessage('chooseaurl');
if (!submitcheck('baurldetail')) {
tabheader(lang('aurl_item_set'), 'aurldetail', "?entry=aurls&action=aurldetail&auid={$auid}");
trbasic(lang('aurl_name'), 'aurlnew[cname]', $aurl['cname']);
trbasic(lang('aurl_remark'), 'aurlnew[remark]', $aurl['remark'], 'btext');
trbasic(lang('aurl_type'), '', $uclassarr[$aurl['uclass']], '');
include M_ROOT . './include/aurls/' . $aurl['uclass'] . '.php';
tabfooter('baurldetail', lang('modify'));
a_guide('aurldetail');
} else {
$aurlnew['cname'] = empty($aurlnew['cname']) ? $aurl['cname'] : $aurlnew['cname'];
$submitmode = true;
include M_ROOT . './include/aurls/' . $aurl['uclass'] . '.php';
$aurlnew['tplname'] = empty($aurlnew['tplname']) ? '' : trim(strip_tags($aurlnew['tplname']));
$aurlnew['onlyview'] = empty($aurlnew['onlyview']) ? 0 : 1;
$temparr = explode('=', str_replace(array("\r", "\n"), '', $v));
if (!isset($temparr[1]) || !($temparr[0] = trim($temparr[0]))) {
continue;
}
$communew['usetting'][$temparr[0]] = trim($temparr[1]);
}
unset($temps, $temparr);
}
$communew['usetting'] = !empty($communew['usetting']) ? addslashes(serialize($communew['usetting'])) : '';
$db->query("UPDATE {$tblprefix}commus SET \n\t\t\t\t\tallowance='{$communew['allowance']}',\n\t\t\t\t\tsetting='{$communew['setting']}',\n\t\t\t\t\tusetting='{$communew['usetting']}',\n\t\t\t\t\tucadd='{$communew['ucadd']}',\n\t\t\t\t\tucvote='{$communew['ucvote']}',\n\t\t\t\t\tuadetail='{$communew['uadetail']}',\n\t\t\t\t\tumdetail='{$communew['umdetail']}',\n\t\t\t\t\tfunc='{$communew['func']}'\n\t\t\t\t\tWHERE cuid='{$cuid}'");
updatecache('commus');
adminlog(lang('detail_modify_citem'));
amessage('itemmodifyfinish', axaction(6, "?entry=commus&action=commusedit{$param_suffix}"));
}
} elseif ($action == 'commulink' && $cuid) {
if (!($commu = fetch_one($cuid))) {
amessage('chooseitem');
}
tabheader(lang('pick_url_style') . '-' . $commu['cname']);
trbasic(lang('item_type'), '', $cclassarr[$commu['cclass']], '');
@(include M_ROOT . './include/commus/' . $commu['cclass'] . '.php');
tabfooter();
}
function fetch_arr()
{
global $db, $tblprefix;
$commus = array();
$query = $db->query("SELECT * FROM {$tblprefix}commus WHERE isbk='0' ORDER BY issystem DESC,cuid ASC");
while ($commu = $db->fetch_array($query)) {
if ($commu['setting'] && is_array($setting = unserialize($commu['setting']))) {
$commu['setting'] = $setting;
