| 383 |
time_t last_login_dt; |
time_t last_login_dt; |
| 384 |
|
|
| 385 |
snprintf(sql, sizeof(sql), |
snprintf(sql, sizeof(sql), |
| 386 |
"SELECT life, UNIX_TIMESTAMP(last_login_dt), user_timezone " |
"SELECT life, UNIX_TIMESTAMP(last_login_dt), user_timezone, exp, nickname " |
| 387 |
"FROM user_pubinfo WHERE UID = %d", |
"FROM user_pubinfo WHERE UID = %d", |
| 388 |
BBS_uid); |
BBS_uid); |
| 389 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 403 |
|
|
| 404 |
strncpy(BBS_user_tz, row[2], sizeof(BBS_user_tz) - 1); |
strncpy(BBS_user_tz, row[2], sizeof(BBS_user_tz) - 1); |
| 405 |
BBS_user_tz[sizeof(BBS_user_tz) - 1] = '\0'; |
BBS_user_tz[sizeof(BBS_user_tz) - 1] = '\0'; |
| 406 |
|
|
| 407 |
|
BBS_user_exp = atoi(row[3]); |
| 408 |
|
|
| 409 |
|
strncpy(BBS_nickname, row[4], sizeof(BBS_nickname)); |
| 410 |
|
BBS_nickname[sizeof(BBS_nickname) - 1] = '\0'; |
| 411 |
} |
} |
| 412 |
else |
else |
| 413 |
{ |
{ |
| 443 |
strncpy(BBS_username, "guest", sizeof(BBS_username) - 1); |
strncpy(BBS_username, "guest", sizeof(BBS_username) - 1); |
| 444 |
BBS_username[sizeof(BBS_username) - 1] = '\0'; |
BBS_username[sizeof(BBS_username) - 1] = '\0'; |
| 445 |
|
|
| 446 |
|
BBS_user_exp = 0; |
| 447 |
|
|
| 448 |
|
strncpy(BBS_nickname, "Guest", sizeof(BBS_nickname)); |
| 449 |
|
BBS_nickname[sizeof(BBS_nickname) - 1] = '\0'; |
| 450 |
|
|
| 451 |
if (load_priv(db, &BBS_priv, 0) != 0) |
if (load_priv(db, &BBS_priv, 0) != 0) |
| 452 |
{ |
{ |
| 453 |
return -1; |
return -1; |