1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59

<?php
require 'classes/_func.class.php';
$func = new func();
if($_SESSION['user']){
  $user_id = func::clear($_SESSION['user'],'int');
  $time = time();
  $ip = $_SERVER['REMOTE_ADDR'];
  $db->Query("UPDATE users SET last = '{$time}', ip = '{$ip}' WHERE id = '{$user_id}'");
  function stockGen($user_id){
    global $db;
    $db->Query("SELECT * FROM users WHERE id = '{$user_id}'");
    $user_data = $db->FetchArray();
    $db->Query("SELECT * FROM users_conf WHERE user_id = '{$user_id}'");
    $sub_data = $db->FetchArray();
    $data = array_merge($user_data,$sub_data);
    $day = time() - 86400;
    $db->Query("SELECT
      (SELECT ref_1 FROM users_ref WHERE user_id = '{$user_id}') ref_id,
      (SELECT COUNT(*) FROM banner_history WHERE user_id = '{$user_id}') banner_views,
      (SELECT COUNT(*) FROM link_history WHERE user_id = '{$user_id}') link_views,
      (SELECT COUNT(*) FROM users_ref WHERE ref_1 = '$user_id') referals,
      (SELECT time FROM auth WHERE user_id = '{$user_id}' ORDER BY id DESC LIMIT 1) last_auth,
      (SELECT SUM(money) FROM payments WHERE user_id = '{$user_id}' AND status = '2') pay,
      (SELECT SUM(money) FROM inserts WHERE user_id = '{$user_id}' AND status = '2') ins,
      (SELECT SUM(to_ref_1) FROM users_ref WHERE ref_1 = '{$user_id}') from_refs_1,
      (SELECT SUM(to_ref_2) FROM users_ref WHERE ref_2 = '{$user_id}') from_refs_2,
      (SELECT SUM(to_ref_3) FROM users_ref WHERE ref_3 = '{$user_id}') from_refs_3,
      (SELECT to_ref_1 FROM users_ref WHERE user_id = '{$user_id}') to_ref");
    $data += $db->FetchArray();
    $data['from_refs'] = sprintf('%.2f',$data['from_refs_1'] + $data['from_refs_2'] + $data['from_refs_3']);
    $data['all_view'] = intval($data['banner_views']) + intval($data['link_views']);
    $data['all_money'] = 0;/*sprintf('%.2f',(floatval($data['link_money']) + floatval($data['banner_money']) + floatval($data['mails_money'])))*/
    $data['all_money_day'] = 0;/*sprintf('%.2f',(floatval($data['link_money_day']) + floatval($data['banner_money_day']) + floatval($data['mails_money_day'])))*/
    $ref_id = $data['ref_id'];
    if ($ref_id != '0') {
      $db->Query("SELECT login FROM users WHERE id = '{$ref_id}'");
      $data['referer'] = $db->FetchRow();
    }else $data['referer'] = 'Пришел сам';
    $db->Query("SELECT * FROM auth WHERE user_id = '{$user_id}' ORDER BY time DESC LIMIT 10");
    if ($db->NumRows() > 0) {
      $data['auth_history'] = $db->FetchAll();
    }else $data['auth_history'] = '0';
    new gen('account/account',$data);
  }
  if(isset($url[2]) && !empty($url[2])){
    $ctrl = $func->clear($url[2]);
    $file = 'controllers/account/'.$ctrl.'Ctrl.php';
    if(file_exists($file)){
      include $file;
    }else stockGen($user_id);
  }else stockGen($user_id);
}else header('location: /login');

// (SELECT SUM(money) FROM banner_history WHERE user_id = '{$user_id}') banner_money,
// (SELECT SUM(money) FROM link_history WHERE user_id = '{$user_id}') link_money,
// (SELECT SUM(money) FROM mails_history WHERE user_id = '{$user_id}') mails_money,
// (SELECT SUM(money) FROM link_history WHERE user_id = '{$user_id}' AND time > '{$day}') link_money_day,
// (SELECT SUM(money) FROM banner_history WHERE user_id = '{$user_id}' AND time > '{$day}') banner_money_day,
// (SELECT SUM(money) FROM mails_history WHERE user_id = '{$user_id}' AND time > '{$day}') mails_money_day,