private
void
saveWinner
(
GAWinner
winner
,
String
player
)
{
Connect
con
=
null
;
PreparedStatement
st
=
null
;
try
{
con
=
L2DatabaseFactory
.
get
(
)
;
st
=
con
.
prepareStatement
(
"REPLACE INTO ga_winners (ga_id,winner_display_name,winner_userId,winner_username,prize_received,place,received_to) VALUES (?,?,?,?,?,?,?)"
)
;
st
.
setInt
(
1
,
winner
.
GA_ID
)
;
st
.
setString
(
2
,
winner
.
displayName
)
;
st
.
setLong
(
3
,
winner
.
userId
)
;
st
.
setString
(
4
,
winner
.
username
)
;
st
.
setInt
(
5
,
winner
.
received
?
1
:
0
)
;
st
.
setInt
(
6
,
winner
.
place
)
;
st
.
setString
(
7
,
player
)
;
st
.
execute
(
)
;
}
catch
(
Exception
e
)
{
_log
.
warning
(
"could not save GA Winner:"
+
e
)
;
e
.
printStackTrace
(
)
;
}
finally
{
Close
.
CS
(
con
,
st
)
;
}
}