joinola/user.php at master · VGAFIB/joinola · GitHub

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
<?php

function gjb_getUserInfo($year, $id)
{
	global $gjb_table_sufix_name;
	global $wpdb;

	$table_name = $wpdb->prefix.$gjb_table_sufix_name;
	return $wpdb->get_results("SELECT * FROM {$table_name} WHERE Year = '{$year}' AND ID = '{$id}'");
}

function gjb_getUserRegistred($year)
{
	global $gjb_table_sufix_name;
	global $wpdb;

	$table_name = $wpdb->prefix.$gjb_table_sufix_name;
	$result = $wpdb->get_results("SELECT count(*) as Num FROM {$table_name} WHERE Year = '{$year}'");
	return intval($result[0]->Num);
}

function gjb_updateUserInfo($year, $id, $info)
{
	global $gjb_table_sufix_name;
	global $wpdb;

	$table_name = $wpdb->prefix.$gjb_table_sufix_name;

	$values['Year'] = $year;
	$values['ID'] = $id;
	$wpdb->update($table_name, $info, $values);
}

?>