1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
<?php
/******************************
* EQdkp
* Copyright 2002-2005
* Licensed under the GNU GPL. See COPYING for full terms.
* ------------------
* stats.php
* Began: Sat December 21 2002
*
* $Id: stats.php 8 2006-05-08 17:15:20Z tsigo $
*
******************************/
define('EQDKP_INC', true);
define('IN_ADMIN', true);
define('DEBUG', false);
$eqdkp_root_path = '/var/www/eqdkp/';
include_once($eqdkp_root_path . "common.php");
$raid_count_60 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date >= unix_timestamp()-60*24*3600');
$raid_count_30 = $db->query_first('SELECT count(*) FROM ' . RAIDS_TABLE . ' WHERE raid_date >= unix_timestamp()-30*24*3600');
$sql = 'SELECT m.member_name FROM R60 ra LEFT JOIN ' . MEMBERS_TABLE . ' m ON m.member_name = ra.member_name WHERE m.member_rank_id = 1 AND ra.raid_count_60/' . $raid_count_60 . ' < 0.05';
if ( !($members_result = $db->query($sql)) )
{
echo mysql_error();
}
$logme = new EQdkp_Admin;
while($row = $db->fetch_record($members_result)) {
echo( "Making $row[0] inactive\n" );
if (count($argv) == 1) {
if ( !$db->query("UPDATE " . MEMBERS_TABLE . " SET member_rank_id = 16 WHERE member_name = '$row[0]'") ) {
message_die('Could not update table');
}
$log_action = array(
'header' => '{L_ACTION_MEMBER_UPDATED}',
'{L_NAME}' => $row[0],
'{L_RANK}' => 'Inactive',
'{L_ADDED_BY}' => 'Asma-bot');
$logme->log_insert(array(
'log_type' => $log_action['header'],
'log_action' => $log_action,
'log_ipaddress' => '127.0.0.1',
'admin_id' => 368) /* that's Asmadeus - use something else? */
);
}
}
$sql = 'SELECT m.member_name FROM ' . MEMBERS_TABLE .' m LEFT JOIN R30 r3 ON r3.member_name = m.member_name LEFT JOIN R60 r6 on r6.member_name = m.member_name WHERE m.member_rank_id = 16 AND raid_count_30 > ' . ($raid_count_30 * 30 / 100) . ' AND raid_count_60 > raid_count_30';
if ( !($members_result = $db->query($sql)) )
{
echo mysql_error();
}
while($row = $db->fetch_record($members_result)) {
echo( "Making $row[0] back to active\n" );
if (count($argv) == 1) {
if ( !$db->query("UPDATE " . MEMBERS_TABLE . " SET member_rank_id = 1 WHERE member_name = '$row[0]'") ) {
message_die('Could not update table');
}
$log_action = array(
'header' => '{L_ACTION_MEMBER_UPDATED}',
'{L_NAME}' => $row[0],
'{L_RANK}' => 'Member',
'{L_ADDED_BY}' => 'Asma-bot');
$logme->log_insert(array(
'log_type' => $log_action['header'],
'log_action' => $log_action,
'log_ipaddress' => '127.0.0.1',
'admin_id' => 368) /* that's Asmadeus - use something else? */
);
}
}
?>
|