public function convert($manual = 0, $amount = 0)
{
require_once BT_ROOT . '/private/includes/traffic/lifetime.php';
//check amount first, so we dont overwrite the amount already in there.
if ($amount) {
$this->payout = $amount;
}
$this->lead_manual = $manual;
$this->lead = 1;
$this->lead_time = time();
$this->lifetime = getClickLifetimeInterval(time() - $this->time);
//save lifetime interval
$this->useRuleSet("pixel");
return $this->save();
}
<?php
require_once __DIR__ . '/../includes/connect.php';
require_once BT_ROOT . '/private/includes/traffic/lifetime.php';
$sql = "select click_id,(lead_time - time) as lifetime from bt_s_clicks where (lead=1) and (lead_time > time) and (lead_time > 0) and (lifetime = 0) limit %s, %s";
$cnt = DB::getVar("select count(*) from bt_s_clicks where (lead=1) and (lead_time > time) and (lead_time > 0) and (lifetime = 0)");
$cursor = 0;
$page = 200;
while ($rows = DB::getRows(sprintf($sql, $cursor, $page))) {
foreach ($rows as $row) {
$time = $row['lifetime'];
$id = $row['click_id'];
DB::query("update bt_s_clicks set lifetime='" . DB::quote(getClickLifetimeInterval($time)) . "' where click_id='" . $id . "'");
}
$cursor += $page;
}
printf("%d Links processed\n", $cnt);
