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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
|
<?php
/*
* open database
*/
function DB_open()
{
global $DB;
if ( $DB = mysql_connect('localhost','dokodb', 'doko') )
mysql_select_db('doko') or die('Could not select database');
else
die (mysql_error());
return;
}
function DB_close()
{
global $DB;
mysql_close($DB);
return;
}
function DB_quote_smart($value)
{
/* Stripslashes */
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
/* Quote if not a number or a numeric string */
if (!is_numeric($value)) {
$value = "'" . mysql_real_escape_string($value) . "'";
}
return $value;
}
function DB_test()
{
$result = mysql_query("SELECT * FROM user");
while($r = mysql_fetch_array($result,MYSQL_NUM))
{
foreach($r as $thing)
echo " $thing ";
echo "<br />\n";
}
return;
}
function DB_get_email_by_name($name)
{
echo "*looking for $name*";
$result = mysql_query("SELECT email FROM user WHERE fullname=".DB_quote_smart($name)."");
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return "";
}
function DB_get_userid_by_name($name)
{
$result = mysql_query("SELECT id FROM user WHERE fullname=".DB_quote_smart($name));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_get_userid_by_passwd($passwd)
{
$result = mysql_query("SELECT id FROM user WHERE password=".DB_quote_smart($passwd));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_get_userid_by_email($email)
{
$result = mysql_query("SELECT id FROM user WHERE email=".DB_quote_smart($email));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_get_handid_by_hash($hash)
{
$result = mysql_query("SELECT id FROM hand WHERE hash=".DB_quote_smart($hash));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_get_userid_by_hash($hash)
{
$result = mysql_query("SELECT user_id FROM hand WHERE hash=".DB_quote_smart($hash));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_get_pos_by_hash($hash)
{
$result = mysql_query("SELECT position FROM hand WHERE hash=".DB_quote_smart($hash));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_get_name_by_hash($hash)
{
$result = mysql_query("SELECT fullname FROM hand LEFT JOIN user ON hand.user_id=user.id WHERE hash=".DB_quote_smart($hash));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return "";
}
function DB_get_status_by_hash($hash)
{
$result = mysql_query("SELECT status FROM hand WHERE hash=".DB_quote_smart($hash));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_set_hand_status_by_hash($hash,$status)
{
mysql_query("UPDATE hand SET status='".$status."' WHERE hash=".DB_quote_smart($hash));
return;
}
function DB_get_gameid_by_hash($hash)
{
$result = mysql_query("SELECT game_id FROM hand WHERE hash=".DB_quote_smart($hash));
$r = mysql_fetch_array($result,MYSQL_NUM);
if($r)
return $r[0];
else
return 0;
}
function DB_cancel_game($hash)
{
$gameid = DB_get_gameid_by_hash($me);
if(!$gameid)
return;
/* get the IDs of all players */
$result = mysql_query("SELECT id FROM hand WHERE game_id=".DB_quote_smart($gameid));
while($r = mysql_fetch_array($result,MYSQL_NUM))
{
$id = $r[0];
$tmp = mysql_query("SELECT id FROM hand_card WHERE hand_id=".DB_quote_smart($id));
$tmp = mysql_fetch_array($tmp,MYSQL_NUM);
mysql_query("DELETE FROM play WHERE hand_card_id=".DB_quote_smart($tmp[0]));
mysql_query("DELETE FROM hand_card WHERE hand_id=".DB_quote_smart($id));
mysql_query("DELETE FROM score WHERE hand_id=".DB_quote_smart($id));
mysql_query("DELETE FROM hand WHERE id=".DB_quote_smart($id));
}
/* delete game */
mysql_query("DELETE FROM user_game_prefs WHERE game_id=".DB_quote_smart($gameid));
mysql_query("DELETE FROM trick WHERE game_id=".DB_quote_smart($gameid));
mysql_query("DELETE FROM game WHERE id=".DB_quote_smart($gameid));
return;
}
function DB_get_hand($me)
{
$cards = array();
$handid = DB_get_handid_by_hash($me);
$result = mysql_query("SELECT card_id FROM hand_card WHERE hand_id=".DB_quote_smart($handid)." and played='false' ");
while($r = mysql_fetch_array($result,MYSQL_NUM))
$cards[]=$r[0];
return $cards;
}
function DB_set_solo_by_hash($me,$solo)
{
mysql_query("UPDATE hand SET solo=".DB_quote_smart($solo)." WHERE hash=".DB_quote_smart($hash));
return;
}
function DB_set_sickness_by_hash($me,$sickness)
{
mysql_query("UPDATE hand SET sickness=".DB_quote_smart($sickness)." WHERE hash=".DB_quote_smart($hash));
return;
}
function DB_get_current_trickid($gameid)
{
$result = mysql_query("SELECT trick.id,MAX(play.sequence) FROM play ".
"LEFT JOIN trick ON play.trick_id=trick.id ".
"WHERE trick.game_id=".DB_quote_smart($gameid)." ".
"GROUP BY trick.id");
while( $r = mysql_fetch_array($result,MYSQL_NUM) )
{
$trickid = $r[0];
$sequence = $r[1];
};
if(!$sequence || $sequence==4)
{
mysql_query("INSERT INTO trick VALUES (NULL,NULL,NULL, ".DB_quote_smart($gameid).")");
$trickid = mysql_insert_id();
$sequence = 1;
}
else
{
$sequence++;
}
return array($trickid,$sequence);
}
function DB_get_max_trickid($gameid)
{
$result = mysql_query("SELECT MAX(id) FROM trick WHERE game_id=".DB_quote_smart($gameid));
$r = mysql_fetch_array($result,MYSQL_NUM) ;
return ($r?$r[0]:NULL);
}
function DB_play_card($trickid,$handcardid,$sequence)
{
mysql_query("INSERT into play VALUES(NULL,NULL,NULL,".DB_quote_smart($trickid).
",".DB_quote_smart($handcardid).",".DB_quote_smart($sequence).")");
return;
}
?>
|
