-
Notifications
You must be signed in to change notification settings - Fork 0
/
getSession.php
50 lines (43 loc) · 2.22 KB
/
getSession.php
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
<?php
$config = parse_ini_file('config.ini', true);
$dbConfig = $config['db'];
$twitterData = [];
ini_set('session.cookie_domain', '.'.$config['root']['domain']);
session_start();
$conn = new mysqli($dbConfig['host'], $dbConfig['user'], $dbConfig['pass'], $dbConfig['name']);
if($conn->connect_error) die('Connection failed: '.$conn->connect_error);
$twitterData['access'] = (String) $conn->real_escape_string($_SESSION['twitteraccess']);
$twitterData['secret'] = (String) $conn->real_escape_string($_SESSION['twittersecret']);
$twitterData['id'] = (Int) $conn->real_escape_string($_SESSION['twitterdata']['id']);
$twitterData['email'] = (String) $conn->real_escape_string($_SESSION['twitterdata']['email']);
$osu_id = (Int) $conn->real_escape_string($_SESSION['osudata']['id']);
$osu_mode = (Int) $conn->real_escape_string($_SESSION['osudata']['mode_code']);
$noti_type = (String) $conn->real_escape_string($_SESSION['noti_type']);
$web_ip = (String) $conn->real_escape_string($_SESSION['osudata']['ip']);
$cf_ip = (String) $conn->real_escape_string($_SESSION['osudata']['cf']);
$timenow = date("Y-m-d\_H:i:s", time());
$sql = 'SELECT * FROM `'.$dbConfig['table'].'` WHERE `osu_id` LIKE '.$osu_id.';';
$result = $conn->query($sql);
$sqlarray = $result->fetch_array(MYSQLI_ASSOC);
if(!is_null($sqlarray)) {
$pattern = '/(....)-(..)-(..)_(..):(..):(..)/';
$replacement = '${1}년 ${2}월 ${3}일 ${4}시 ${5}분 ${6}초';
$regexed_date = preg_replace($pattern, $replacement, $sqlarray['date']);
echo 'already registered, ' . $regexed_date;
exit;
}
$sql_osu_columes = 'osu_id`, `osu_mode';
$sql_osu_insert = $osu_id.'`, `'.$osu_mode;
$sql_twitter_columes = 'twitter_id`, `twitter_access_token`, `twitter_access_secret`, `twitter_email';
$sql_twitter_insert = $twitterData['id'].'`, `'.$twitterData['access'].'`, `'.$twitterData['secret'].'`, `'.$twitterData['email'];
$sql = 'INSERT INTO `'.$dbConfig['table'].'` (
`number`,
`date`,
`noti_type`,
`'.$sql_osu_columes.'`, `'.$sql_twitter_columes.'`, `web_ip`, `cf_ip`, `passed`)
VALUES (NULL, NULL, "'.$noti_type.'", `'.$sql_osu_insert.'`, `'.$sql_twitter_insert.'`, `'.$web_ip.'`, `'.$cf_ip.'`, NULL);';
if ($conn->query($sql)) {
echo 'registered';
} else {
echo 'register error: ' . $conn->error . $sql;
}