Mousing over any column name shown in link font will provide more information on the data it contains
There is a window at the bottom of the page where you can entery SQL queries and view the results in a number of formats
| viper_users | |||||
| Field | Type | Null | Key | Default | Extra |
| user_id | mediumint(8) unsigned | NO | PRI | auto_increment | |
| user_type | tinyint(2) | NO | MUL | ||
| group_id | mediumint(8) unsigned | NO | 3 | ||
| user_permissions | mediumtext | NO | |||
| user_perm_from | mediumint(8) unsigned | NO | |||
| user_ip | varchar(40) | NO | |||
| user_regdate | int(11) unsigned | NO | |||
| username | varchar(255) | NO | |||
| username_clean | varchar(255) | NO | UNI | ||
| user_password | varchar(40) | NO | |||
| user_passchg | int(11) unsigned | NO | |||
| user_pass_convert | tinyint(1) unsigned | NO | |||
| user_email | varchar(100) | NO | |||
| user_email_hash | bigint(20) | NO | MUL | ||
| user_birthday | varchar(10) | NO | MUL | ||
| user_lastvisit | int(11) unsigned | NO | |||
| user_lastmark | int(11) unsigned | NO | |||
| user_lastpost_time | int(11) unsigned | NO | |||
| user_lastpage | varchar(200) | NO | |||
| user_last_confirm_key | varchar(10) | NO | |||
| user_last_search | int(11) unsigned | NO | |||
| user_warnings | tinyint(4) | NO | |||
| user_last_warning | int(11) unsigned | NO | |||
| user_login_attempts | tinyint(4) | NO | |||
| user_inactive_reason | tinyint(2) | NO | |||
| user_inactive_time | int(11) unsigned | NO | |||
| user_posts | mediumint(8) unsigned | NO | |||
| user_lang | varchar(30) | NO | |||
| user_timezone | decimal(5,2) | NO | 0.00 | ||
| user_dst | tinyint(1) unsigned | NO | |||
| user_dateformat | varchar(30) | NO | d M Y H:i | ||
| user_style | smallint(4) unsigned | NO | |||
| user_rank | mediumint(8) unsigned | NO | |||
| user_colour | varchar(6) | NO | |||
| user_new_privmsg | int(4) | NO | |||
| user_unread_privmsg | int(4) | NO | |||
| user_last_privmsg | int(11) unsigned | NO | |||
| user_message_rules | tinyint(1) unsigned | NO | |||
| user_full_folder | int(11) | NO | -3 | ||
| user_emailtime | int(11) unsigned | NO | |||
| user_topic_show_days | smallint(4) unsigned | NO | |||
| user_topic_sortby_type | varchar(1) | NO | t | ||
| user_topic_sortby_dir | varchar(1) | NO | d | ||
| user_post_show_days | smallint(4) unsigned | NO | |||
| user_post_sortby_type | varchar(1) | NO | t | ||
| user_post_sortby_dir | varchar(1) | NO | a | ||
| user_notify | tinyint(1) unsigned | NO | |||
| user_notify_pm | tinyint(1) unsigned | NO | 1 | ||
| user_notify_type | tinyint(4) | NO | |||
| user_allow_pm | tinyint(1) unsigned | NO | 1 | ||
| user_allow_viewonline | tinyint(1) unsigned | NO | 1 | ||
| user_allow_viewemail | tinyint(1) unsigned | NO | 1 | ||
| user_allow_massemail | tinyint(1) unsigned | NO | 1 | ||
| user_options | int(11) unsigned | NO | 895 | ||
| user_avatar | varchar(255) | NO | |||
| user_avatar_type | tinyint(2) | NO | |||
| user_avatar_width | smallint(4) unsigned | NO | |||
| user_avatar_height | smallint(4) unsigned | NO | |||
| user_sig | mediumtext | NO | |||
| user_sig_bbcode_uid | varchar(8) | NO | |||
| user_sig_bbcode_bitfield | varchar(255) | NO | |||
| user_from | varchar(100) | NO | |||
| user_icq | varchar(15) | NO | |||
| user_aim | varchar(255) | NO | |||
| user_yim | varchar(255) | NO | |||
| user_msnm | varchar(255) | NO | |||
| user_jabber | varchar(255) | NO | |||
| user_website | varchar(200) | NO | |||
| user_occ | text | NO | |||
| user_interests | text | NO | |||
| user_actkey | varchar(32) | NO | |||
| user_newpasswd | varchar(40) | NO | |||
| user_form_salt | varchar(32) | NO | |||
Note: Only SELECT, SHOW or DESCRIBE queries can be performed, any other command will generate an error
 |
 |
|
|
Main |
Data & Analysis |
Utilities |
Search |
Contact Us |
Help |
Links |
Mailing List |
Cite VIPERdb |
Disclaimer
|
|
