/** Prepares player information collected from the database */
private void sql_setupUser() {
userID = user.getUserID();
name = user.getUserName();
// check if registered
String query =
"SELECT fnEnabled, fcIP, fnMID FROM tblDuel2__player WHERE fnUserID = "
+ userID
+ " LIMIT 1";
ResultSet rs = null;
try {
rs = ba.SQLQuery(db, query);
if (rs.next()) {
registered = true;
if (rs.getInt("fnEnabled") == 1) enabled = true;
userIP = rs.getString("fcIP");
userMID = rs.getInt("fnMID");
}
ba.SQLClose(rs);
query = "SELECT fnActive FROM tblDuel2__ban WHERE fnUserID = " + userID + " AND fnActive = 1";
rs = ba.SQLQuery(db, query);
if (rs.next()) banned = true;
} catch (SQLException e) {
bot.debug("[sql_setupUser] Exception when checking if registered: " + name);
e.printStackTrace();
} finally {
ba.SQLClose(rs);
}
}
/**
* Add a single user to the list.
*
* @param user The user to add
*/
private void addUser(UserData user) {
userCnt++;
LayoutInflater inflater = getLayoutInflater();
View userView = inflater.inflate(R.layout.user_profile, list, false);
TextView name = (TextView) userView.findViewById(R.id.user_name);
name.setText(user.getUserName());
TextView age = (TextView) userView.findViewById(R.id.user_age);
age.setText(user.getAge());
TextView city = (TextView) userView.findViewById(R.id.user_city);
city.setText(user.getCity());
TextView stateCountry = (TextView) userView.findViewById(R.id.user_state_country);
stateCountry.setText(user.getState() + ", " + user.getCountry());
Bitmap profilePic = user.getProfilePic();
if (profilePic != null) {
ImageView profile = (ImageView) userView.findViewById(R.id.user_profilepic);
profile.setImageBitmap(profilePic);
}
String note = user.getNote();
if (note != null && note.length() > 0) {
Button noteButton = (Button) userView.findViewById(R.id.btn_note);
noteButton.setVisibility(View.VISIBLE);
noteButton.setOnClickListener(new NoteClicker(note));
}
userView.setOnClickListener(new ProfileClicker(user.getId()));
userView.setTag(user);
list.addView(userView);
}
