business cron

[benlakaz]

Please assist me with this cron.. What part should I edit to reduce the daily profit of the business... thanks

 

<?php
include "config.php";
global $_CONFIG;
if($_GET['code'] != $_CONFIG['code']) { die(""); }
define("MONO_ON", 1);
require "class/class_db_{$_CONFIG['driver']}.php";
$db=new database;
$db->configure($_CONFIG['hostname'],
$_CONFIG['username'],
$_CONFIG['password'],
$_CONFIG['database'],
$_CONFIG['persistent']);
$db->connect();
$c=$db->connection_id;
$set=array();
$settq=$db->query("SELECT * FROM settings");
while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
include "global_func.php";
$select_businesses = mysql_query("SELECT * FROM `businesses` LEFT JOIN `businesses_classes` ON (`classId` = `busClass`) ORDER BY `busId` ASC");
while($bs = mysql_fetch_assoc($select_businesses))
{
  $amount = mysql_num_rows(mysql_query(sprintf("SELECT * FROM `businesses_members` WHERE `bmembBusiness` = '%u'", $bs['busId'])));
  $new_customers = ((($bs['classCost'] / 7000) * ($amount + 1) + rand(-12, 9)) / 2);
  $new_profit = (($new_customers + rand(-4, 8)) * ((($bs['classCost'] / 2500) * rand(2, 8)) / 10) * ($amount + 1));
 mysql_query(sprintf("UPDATE `businesses` SET `busYCust` = `busCust`, `busYProfit` = `busProfit`, `busCust` = '%d', `busProfit` = '%d', `busCash` = '%d' WHERE `busId` = '%u'", $new_customers, $new_profit, ($new_profit + $bs['busCash']), $bs['busId'])) OR die('Cron not run');
  $fetch_members = mysql_query(sprintf("SELECT * FROM `businesses_members` LEFT JOIN `users` ON (`userid` = `bmembMember`) LEFT JOIN `businesses_ranks` ON (`rankId` = `bmembRank`) WHERE `bmembBusiness` = '%u'", $bs['busId']));
  while($fm = mysql_fetch_assoc($fetch_members))
   {
     $fetch_stat = array(
      'strength' => 'strength',
      'intel' => 'IQ',
      'labour' => 'labour'
     );
     mysql_query(sprintf("UPDATE `users` SET `money` = `money` + '%d' WHERE `userid` = '%u'", $fm['bmembCash'], $fm['userid']));
     mysql_query(sprintf("UPDATE `userstats` SET `{$fetch_stat[$fm['rankPrim']]}` = `{$fetch_stat[$fm['rankPrim']]}` + '%.6f', `{$fetch_stat[$fm['rankSec']]}` = `{$fetch_stat[$fm['rankSec']]}` + '%.6f' WHERE (`userid` = '%u')", $fm['rankPGain'], $fm['rankSGain'], $fm['userid']));
     if($bs['busCash'] < $fm['bmembCash'])
      {
        $text = "Member ID {$fm['bmembMember']} was not paid their \$".number_format($fm['bmembCash'])." due to lack of funds.";
        mysql_query(sprintf("INSERT INTO `businesses_alerts` (`alertId`, `alertBusiness`, `alertText`, `alertTime`) VALUES ('NULL', '%u', '%s', '%d')", $bs['busId'], $text, time()));
        mysql_query(sprintf("UPDATE `businesses` SET `busDebt` = `busDebt` + '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId']));
      }
     else
      {
        mysql_query(sprintf("UPDATE `businesses` SET `busCash` = `busCash` - '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId']));
      }
   }
  if($bs['busDebt'] > $bs['classCost'])
   {
     $send_event = mysql_query(sprintf("SELECT `bmembMember` FROM WHERE `bmembBusiness` = '%u' ORDER BY `bmembId` DESC", $bs['busId']));
     while($se = mysql_fetch_assoc($send_event))
      {
        $text = "The {$bs['busName']} business went bankrupt\, all members have been discharged.";
        insert_event($se['bmembMember'], $text);
      }
     mysql_query(sprintf("DELETE FROM `businesses_members` WHERE (`bmembBusiness` = '%u')", $bs['busId']));
     mysql_query(sprintf("DELETE FROM `businesses` WHERE (`busId` = '%u')", $bs['busId']));
   }
}
?>

[chicka]

Re: business cron

this is how I have mine set and its good for the economy in my game.

$new_customers = (((($bs['classCost'] / 50) * ($amount + 1) + rand(-25, 6)) / 2)/500);

$new_profit = ((($new_customers + rand(0, 8)) * ((($bs['classCost'] / 80) * rand(2, 8)) / 10) * ($amount + 1))/1000);