A6gkP0hH

1---------------------------------------------------------------------------------------------------------------------------------
2Meter no Utils
3--------------------------------------------------------------------------------------------------------------------------------
4public String getPhoneID(){
5 			//get android unique id
6            final TelephonyManager tm = (TelephonyManager) getBaseContext().getSystemService(this.TELEPHONY_SERVICE);
7
8            final String tmDevice, tmSerial, androidId;
9            tmDevice = "" + tm.getDeviceId();
10            tmSerial = "" + tm.getSimSerialNumber();
11            androidId = "" + android.provider.Settings.Secure.getString(getContentResolver(), android.provider.Settings.Secure.ANDROID_ID);
12
13            UUID deviceUuid = new UUID(androidId.hashCode(), ((long)tmDevice.hashCode() << 32) | tmSerial.hashCode());
14            return deviceUuid.toString();
15}
16
17---------------------------------------------------------------------------------------------------------------------------------
18Meter na db 
19--------------------------------------------------------------------------------------------------------------------------------
20
21CREATE TABLE IF NOT EXISTS phonesIDParent (
22   email VARCHAR(100),
23   phone_id VARCHAR(100) PRIMARY KEY,
24   phone_name VARCHAR(100),
25);
26
27CREATE TABLE IF NOT EXISTS phonesIDChild (
28   email VARCHAR(100),
29   phone_id VARCHAR(100) PRIMARY KEY,
30   phone_name VARCHAR(100),
31);
32
33---------------------------------------------------------------------------------------------------------------------------------
34Meter no connector 
35--------------------------------------------------------------------------------------------------------------------------------
36
37	public String queryPhoneId(String email, String phoneID) {
38		try {
39			ResultSet rs = query("SELECT * FROM phonesIDParent WHERE email='"+ email + "' AND phone_id='"+phoneID+"';");
40			if (rs.next()){
41				return "legal";
42			}
43			rs = query("SELECT * FROM phonesIDChild WHERE email='"+ email + "' AND phone_id='"+phoneID+"';");
44			if (rs.next()){
45				return "child";
46			}
47			return "new";
48		}catch (SQLException e) {
49			System.err.print("No Query");
50			return false;
51		}
52	}