Regular Credits

[Tanix]

I'd like to give members credits on a regular basis. How could I do that?

Example: Pay membergroup x the sum of 5 credits every day. Pay membergroup y the sum of 10 credits every month.

[feeble]

if you know cron jobs, should be fairly simple

[Tanix]

Forgotten I'd posted that. Thanks, feeble. I'd actually worked out the cron job side of things - using Daniel's code from the bank interest calculation and his guide on setting cron jobs:

Code: [Select]

<?php

//File: dosalaries.php - Pays salaries to members
//MUST SET UP A CRON JOB FOR THIS TO WORK

if(!isset($_SERVER["HTTP_HOST"])) {

include("../../SSI.php");

$salary = $modSettings['salary'];
db_query("UPDATE {$db_prefix}members
  SET moneyBank = moneyBank + {$salary}", __FILE__, __LINE__);

echo "Salary paid on ".date("d/m/Y h:i:s A");
}
?>
What I haven't figured out yet is how to work out different salary payments for different membergroups. PHP learner here.

[feeble]

you could do something like

Code: [Select]

db_query("UPDATE {$db_prefix}members
  SET moneyBank = moneyBank + {$salary} WHERE ID_GROUP = '1' ", __FILE__, __LINE__);
does not take in additionalGroups field but its a start.

[Daniel15]

What I haven't figured out yet is how to work out different salary payments for different membergroups.

A slightly ugly solution, but usable nontheless:

Code: (php) [Select]

<?php

//File: dosalaries.php - Pays salaries to members
//MUST SET UP A CRON JOB FOR THIS TO WORK

if (isset($_SERVER["HTTP_HOST"]))
die('Grrrrrrr...');

include('SSI.php');
$salaries = array(
// array(group ID, amount of credits to add)
array(1, 10),
array(2, 20),
);

foreach ($salaries as $salary)
{
$salary[0] = (int) $salary[0];
$salary[1] = (float) $salary[1];
db_query("UPDATE {$db_prefix}members
SET moneyBank = moneyBank + {$salary[1]}
WHERE ID_GROUP = {$salary[0]}", __FILE__, __LINE__);
}

echo 'Salary paid on ' . date("d/m/Y h:i:s A");
?>

I haven't tested that, but it should work