-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathchoose_final_3_offers.php
141 lines (117 loc) · 6.46 KB
/
choose_final_3_offers.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
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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
<?php include('Connections/settings.php'); ?>
<?php include("includes/sessionInfo.php") ?>
<?php include("includes/functions.php") ?>
<?php include("facebook/facebook.php") ?>
<?php include("twitter/twitteroauth.php") ?>
<?php include("includes/shorturl.php") ?>
<?php include("includes/langfile.php") ?>
<?php include("includes/langs.php") ?>
<?php
switch ($lang){
case 'en':
$MailSubject = '%item1 has selected the final teams he will negotiate with.';
$MailMessage = '%item1 has selected the following citys in which he will negotiate with %item2. He will make a final decesion as early as 24 hours from now.';
break;
case 'fr':
$MailSubject = '%item1 has selected the final teams he will negotiate with.';
$MailMessage = '%item1 has selected the following citys in which he will negotiate with %item2. He will make a final decesion as early as 24 hours from now.';
break;
}
//facebook application
$facebook = new Facebook(array(
'appId' => APP_ID,
'secret' => APP_SECRET,
'cookie' => true,
));
if($_SESSION['U_Admin']!=1){
$updateGoTo = "login.php";
header(sprintf("Location: %s", $updateGoTo));
}
$PID_GetPlayer = "1";
if (isset($_POST['player'])) {
$PID_GetPlayer = (get_magic_quotes_gpc()) ? $_POST['player'] : addslashes($_POST['player']);
}
$GetType = "player";
if (isset($_POST['type'])) {
$GetType = (get_magic_quotes_gpc()) ? $_POST['type'] : addslashes($_POST['type']);
}
if($GetType == "goalie"){
$query_GetPlayer = sprintf("SELECT Name FROM goalies WHERE Number=%s", $PID_GetPlayer);
$GetPlayer = mysql_query($query_GetPlayer, $connection) or die(mysql_error());
$row_GetPlayer = mysql_fetch_assoc($GetPlayer);
$ContractType="Goalie Offer Sheet";
$ContractSigned="Goalie Offer Sheet Final";
$ContractSigned1="Goalie Signed";
} else {
$query_GetPlayer = sprintf("SELECT Name FROM players WHERE Number=%s", $PID_GetPlayer);
$GetPlayer = mysql_query($query_GetPlayer, $connection) or die(mysql_error());
$row_GetPlayer = mysql_fetch_assoc($GetPlayer);
$ContractType="Offer Sheet";
$ContractSigned="Offer Sheet Final";
$ContractSigned1="Signed";
}
$url = $_SESSION['DomainName'].'/ufa-free-agents_decide.php';
$query_GetStatus= sprintf("SELECT (O.Salary1 + O.Salary2 + O.Salary3 + O.Salary4 + O.Salary5 + O.Salary6 + O.Salary7 + O.Salary8 + O.Salary9 + O.Salary10 + O.bonus + (O.NoTrade * 1000000)) as TotalOffer, O.Type, O.DateCreated, O.PR_ID, O.Team, T.City FROM playerscontractoffers AS O, proteam AS T WHERE O.Player='%s' AND O.Type='%s' AND O.Team=T.Number Order By TotalOffer desc limit 0,3",$PID_GetPlayer, $ContractType);
$GetStatus = mysql_query($query_GetStatus, $connection) or die(mysql_error());
$row_GetStatus = mysql_fetch_assoc($GetStatus);
$totalRows_GetStatus = mysql_num_rows($GetStatus);
if($totalRows_GetStatus > 1){
$TeamOfferList = "0";
$TeamOfferListName = "";
do {
$TeamOfferList = $TeamOfferList.",".$row_GetStatus['PR_ID'];
$TeamOfferListName = $TeamOfferListName.",".$row_GetStatus['City'];
} while ($row_GetStatus = mysql_fetch_assoc($GetStatus));
mysql_free_result($GetStatus);
$query_GetEmails = sprintf("SELECT proteam.Number, proteam.Email, proteam.EmailAlert, proteam.post_approvals, proteam.access_token, proteam.oauth_uid, proteam.oauth_provider FROM playerscontractoffers, proteam WHERE playerscontractoffers.Player = '%s' AND proteam.Number=playerscontractoffers.Team GROUP BY proteam.Number", $PID_GetPlayer);
$GetEmails = mysql_query($query_GetEmails, $connection) or die(mysql_error());
$row_GetEmails = mysql_fetch_assoc($GetEmails);
$tmpTxtItems = array("%item1");
$updatedTxtItems = array(addslashes($row_GetPlayer['Name']));
$MailSubject = str_replace($tmpTxtItems, $updatedTxtItems, $MailSubject);
$tmpTxtItems = array("%item1", "%item2");
$updatedTxtItems = array(addslashes($row_GetPlayer['Name']), $TeamOfferListName);
$MailMessage = str_replace($tmpTxtItems, $updatedTxtItems, $MailMessage);
do {
$MailMessage = "<strong>".$MailSubject."</strong><br>".$MailMessage;
$insertSQL = sprintf("INSERT INTO teamhistory(Season_ID, Value, Team, DateCreated, Viewed) values (%s,%s,%s,%s,'False')",
GetSQLValueString($_SESSION['current_Season'], "text"),
GetSQLValueString($MailMessage, "text"),
GetSQLValueString($row_GetEmails['Number'], "text"),
GetSQLValueString(strftime('%Y-%m-%d %H:%M:%S', strtotime('now')), "date"));
$Result0 = mysql_query($insertSQL, $connection) or die(mysql_error());
} while ($row_GetEmails = mysql_fetch_assoc($GetEmails));
$updateSQL = "UPDATE playerscontractoffers SET Type='".$ContractSigned."', DateCreated='".strftime('%Y-%m-%d %H:%M:%S', strtotime('now'))."' WHERE Type='".$ContractType."' AND Player=".$PID_GetPlayer;
$Result1 = mysql_query($updateSQL, $connection) or die(mysql_error());
$deleteSQL = "DELETE FROM playerscontractoffers WHERE Player='".addslashes($PID_GetPlayer)."' AND PR_ID NOT IN (".$TeamOfferList.")";
$Result1 = mysql_query($deleteSQL, $connection) or die(mysql_error());
if($row_GetEmails['oauth_provider']=='facebook' && $row_GetEmails['post_approvals']=='True'){
$post = array(
'access_token' => $row_GetEmails['access_token'],
'link' => $url,
'picture' => $_SESSION['DomainName'].'/image/common/Facebook-share-icon.png',
'name' => $_SESSION['SiteName'],
'message' => $MailSubject,
'description' => $MailMessage
);
//and make the request
try {
$res = $facebook->api('/'.$row_GetEmails['oauth_uid'].'/feed', 'POST', $post);
} catch (FacebookApiException $e) {}
} else if($row_GetEmails['oauth_provider']=='twitter' && $row_GetEmails['post_approvals']=='True'){
$tinyURL = ShortUrl::create($url,'tinyurl');
$MailMessage = $MailSubject." - ".$tinyURL;
/* Get user access tokens out of the session. */
$access_token = explode(",", $row_GetEmails['access_token']);
$twitter_connection = new TwitterOAuth(TWITTER_CONSUMER_KEY, TWITTER_CONSUMER_SECRET, $access_token[0], $access_token[1]);
$response = $twitter_connection->post('statuses/update', array('status' => substr($MailMessage, 0, 140)));
}
//$removeGoTo = "ufa-free-agents_w_offer.php";
//header(sprintf("Location: %s", $removeGoTo));
} else {
$updateSQL = "UPDATE playerscontractoffers SET Type='".$ContractSigned1."', DateCreated='".strftime('%Y-%m-%d %H:%M:%S', strtotime('now'))."' WHERE Type='".$ContractType."' AND Player=".$PID_GetPlayer;
$Result1 = mysql_query($updateSQL, $connection) or die(mysql_error());
//$removeGoTo = "sign_offer.php?player=".$PID_GetPlayer."&type=".$GetType;
//header(sprintf("Location: %s", $removeGoTo));
}
?>