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
79
80
81
82
83
84
|
<?php
require_once("../inc/db.inc");
require_once("../inc/util.inc");
db_init();
function parse_num($xml, $tag) {
$x = parse_element($xml, $tag);
if (!$x) return 0;
return $x;
}
function parse_boolint($xml, $tag) {
$x = parse_bool($xml, $tag);
if ($x) return 1;
return 0;
}
function make_user($user) {
$prefs = $user->global_prefs;
$run_on_batteries = parse_boolint($prefs, "run_on_batteries");
$run_if_user_active = parse_boolint($prefs, "run_if_user_active");
$start_hour = parse_num($prefs, "<start_hour>");
$end_hour = parse_num($prefs, "<end_hour>");
$net_start_hour = parse_num($prefs, "<net_start_hour>");
$net_end_hour = parse_num($prefs, "<net_end_hour>");
$leave_apps_in_memory = parse_boolint($prefs, "leave_apps_in_memory");
$confirm_before_connecting = parse_boolint($prefs, "confirm_before_connecting");
$hangup_if_dialed = parse_boolint($prefs, "hangup_if_dialed");
$work_buf_min_days = parse_num($prefs, "<work_buf_min_days>");
$max_cpus = parse_num($prefs, "<max_cpus>");
$cpu_scheduling_period_minutes = parse_num($prefs, "<cpu_scheduling_period_minutes>");
$disk_interval = parse_num($prefs, "<disk_interval>");
$disk_max_used_gb = parse_num($prefs, "<disk_max_used_gb>");
$disk_max_used_pct = parse_num($prefs, "<disk_max_used_pct>");
$disk_min_free_gb = parse_num($prefs, "<disk_min_free_gb>");
$vm_max_used_pct = parse_num($prefs, "<vm_max_used_pct>");
$idle_time_to_run = parse_num($prefs, "<idle_time_to_run>");
$max_bytes_sec_up = parse_num($prefs, "<max_bytes_sec_up>");
$max_bytes_sec_down = parse_num($prefs, "<max_bytes_sec_down>");
$query = "insert into puser values
($user->id,
$user->create_time,
'$user->email_addr',
'$user->country',
$user->total_credit,
'$user->venue',
$run_on_batteries,
$run_if_user_active,
$start_hour,
$end_hour,
$net_start_hour,
$net_end_hour,
$leave_apps_in_memory,
$confirm_before_connecting,
$hangup_if_dialed,
$work_buf_min_days,
$max_cpus,
$cpu_scheduling_period_minutes,
$disk_interval,
$disk_max_used_gb,
$disk_max_used_pct,
$disk_min_free_gb,
$vm_max_used_pct,
$idle_time_to_run,
$max_bytes_sec_up,
$max_bytes_sec_down)
";
$retval = mysql_query($query);
if (!$retval) {
echo mysql_error();
}
}
set_time_limit(0);
$result = mysql_query("select * from user where total_credit > 0");
while ($user = mysql_fetch_object($result)) {
make_user($user);
}
?>
|
