Update On: November 20, 2006, 3:26 pm
List of tables:
- admin_mass_mail
- ads
- ban_ip
- block
- board
- board_view
- buddy
- buddy_add
- chat
- chat_online
- comment
- css
- custom_field
- custom_field2user
- custom_field_option
- event_invite
- events
- favorite
- forum
- forum_reply
- forum_topic
- forum_view
- fun
- group_forum
- group_gallery
- group_invite
- group_main
- group_member
- group_name
- hot_quiz
- html_layout
- invite
- journal
- listing
- listing_main
- main
- memb2perm
- membership
- messenger
- messenger_check
- messenger_id
- module_perm
- online
- online_session
- page
- payment_log
- poll_vote
- polls
- quiz
- quiz_1
- quiz_2
- rating
- sale
- session
- site_session
- site_stats
- staff_perm
- sys_sett
- template
- user
- user_info
- user_rating
1. admin_mass_mail
Extra: PRIMARY KEY(`id`)
Details: Records each mail sent to every member in your site Populated from the Admin Panel => Extra Tools => Mass Email. If used this feature to send a mail to only one member then it will NOT get stored in this table, instead it will be sent like regular mail.
Details: Records each mail sent to every member in your site Populated from the Admin Panel => Extra Tools => Mass Email. If used this feature to send a mail to only one member then it will NOT get stored in this table, instead it will be sent like regular mail.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"subject": varchar(50) NOT NULL default ''
Subject of the mail sent
"text": text NOT NULL
Text of the mail sent
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch
2. ads
Extra: PRIMARY KEY(`id`)
Details: To store the ads displayed through the site Managed from the Admin Panel => Extra Tools => ADS. The Wide Skyscraper is an empty value. Each record is gathered randomly to its position, so if there are several ads for the same position they will come out r
Details: To store the ads displayed through the site Managed from the Admin Panel => Extra Tools => ADS. The Wide Skyscraper is an empty value. Each record is gathered randomly to its position, so if there are several ads for the same position they will come out r
"id": int(11) NOT NULL auto_increment
Gives a unique id to each record
"text": text NOT NULL
Stores the content of the ad, usually it will be html code displaying an image or perhaps some embeded object.
"type": tinytext NOT NULL
The position for the ad, it goes as follows:- Location: Banner - Top Right
- Leaderboard - Footer and Header
- Medium Rectangle - Main Page
- Large Rectangle - Logout Page
- Wide Skyscraper
3. ban_ip
Extra: PRIMARY KEY(`id`)
Details: Insert IP's admins ban from the admin control panel.
Details: Insert IP's admins ban from the admin control panel.
"id": int(10) unsigned NOT NULL auto_increment
Gives a unique id to each record
"ip": varchar(15) NOT NULL default ''
Stores the IP
"atime": datetime NOT NULL default '0000-00-00 00:00:00'
Time the IP was stored
"block_until": datetime NOT NULL default '0000-00-00 00:00:00'
How long we plan to keep the ban on the specific IP
"description": varchar(40) NOT NULL default ''
Describe in detail why the IP was banned.
4. block
Extra: PRIMARY KEY(`id`)
Details: Stores the rules for who cant view who's profile. Gets populated when a user blocks another one from viewing its profile. user2 will not be able to see user1's profile.
Details: Stores the rules for who cant view who's profile. Gets populated when a user blocks another one from viewing its profile. user2 will not be able to see user1's profile.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user1": varchar(25) NOT NULL default ''
User who blocked someone
"user2": varchar(25) NOT NULL default ''
Member who got blocked by "user1"
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch
5. board
Extra: PRIMARY KEY(`id`)
Details: To store each Bulletin Board written in the site. A bulletin in the phpfox script works as a communicate to every member.
Details: To store each Bulletin Board written in the site. A bulletin in the phpfox script works as a communicate to every member.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
Member who posted the bulletin
"title": tinytext NOT NULL
Title of the bulletin
"text": text NOT NULL
Message in the bulletin
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch
6. board_view
Extra: PRIMARY KEY(`id`)
Details: To keep track of who has viewed which bulletin. A user does not view its own Bulletin, so it doesnt get record if userA views a post made by userA. So this table uses the "board"'s id field to set what bulleting got seen.
Details: To keep track of who has viewed which bulletin. A user does not view its own Bulletin, so it doesnt get record if userA views a post made by userA. So this table uses the "board"'s id field to set what bulleting got seen.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
Member who viewed a specific bulletin
"view_id": tinytext NOT NULL
This is the id of the bulletin in the table "board"
7. buddy
Extra: PRIMARY KEY(`id`)
Details: To store who is friends with whom. This table gets populated when a user accepts to be friends with another one. The way this table works is that 'user' is friends with 'buddy' and 'user1' is friends with 'buddy1'.
Details: To store who is friends with whom. This table gets populated when a user accepts to be friends with another one. The way this table works is that 'user' is friends with 'buddy' and 'user1' is friends with 'buddy1'.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
This 'user' has a friend, buddy
"buddy": tinytext NOT NULL
"buddy" is friends with "user"
"user1": tinytext NOT NULL
"user1" has a friend, "buddy1"
"buddy1": tinytext NOT NULL
this record is friends with "user1"
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch
"type": tinytext NOT NULL
NOT USED LONGER
"top_user_buddy": tinyint(4) NOT NULL default '0'
Top friend
"top_buddy_user": tinyint(4) NOT NULL default '0'
Top friend
8. buddy_add
Extra: PRIMARY KEY(`id`)
Details: To store every friend request, this is the step before actually populating the table "buddy".
Details: To store every friend request, this is the step before actually populating the table "buddy".
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
This member requested "friend" to be its friend
"friend": tinytext NOT NULL
"friend" is the one who received the invitation
"time": int(11) NOT NULL default '0'
Seconds since the unix epoch of when the record was added
"ip": tinytext NOT NULL
When available it stores the ip of the requester
"type": tinytext NOT NULL
NOT USED LONGER
9. chat
Extra: PRIMARY KEY(`id`)
Details: This table is the shoutbox, every message posted in the shoutbox gets stored here [or viceversa.
Details: This table is the shoutbox, every message posted in the shoutbox gets stored here [or viceversa.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who posted the message
"text": text NOT NULL
Text of the message
"time": int(11) NOT NULL default '0'
Time in seconds when the action was performed, since unix epoch
"ip": tinytext NOT NULL
When available it stores the ip of the poster
"group_id": tinytext NOT NULL
If its a group shout box message enter the ID.
10. chat_online
Extra: PRIMARY KEY(`id`)
Details: Stores who is online when using the shoutbox chat.
Details: Stores who is online when using the shoutbox chat.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(25) NOT NULL default ''
User connect detail
"time": int(11) NOT NULL default '0'
Time in seconds when the action was performed, since unix epoch
11. comment
Extra: PRIMARY KEY(`id`)
Details: Stores comments made on a member's profile. If HTML is on from the Admin Panel then comments with HTML will be posted as is and inserted exactly the same to the database.
Details: Stores comments made on a member's profile. If HTML is on from the Admin Panel then comments with HTML will be posted as is and inserted exactly the same to the database.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"main": tinytext NOT NULL
If comment entry is a guestbook it enters as GB
"cid": tinytext NOT NULL
If comment entry is not for a guestbook.
"user": tinytext NOT NULL
Member who posted the comment
"gbuser": tinytext NOT NULL
Member who got the post
"title": tinytext NOT NULL
EMPTY
"text": text NOT NULL
What the comment said
"time": int(11) NOT NULL default '0'
Time in seconds when the action was performed, since unix epoch
"ip": tinytext NOT NULL
When available it stores the ip of the poster
"img": tinytext NOT NULL
EMPTY, NOT USED
12. css
Extra: PRIMARY KEY(`id`)
Details: Keeps a record of the current available CSS themes. In table 'user' the field 'css' is directed to the id field in the table CSS, this way it records which theme each user has selected as their own
Details: Keeps a record of the current available CSS themes. In table 'user' the field 'css' is directed to the id field in the table CSS, this way it records which theme each user has selected as their own
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"name": tinytext NOT NULL
Name of each theme, as displayed throughout the site
"file": tinytext NOT NULL
Name of the folder in which to find the code for the theme, for instance if "name" is "Theme1" and all the code is in a folder called "Th1_src" then the path to the theme is: "/inc/css/Th1_src"
"html": tinytext NOT NULL
Future usage. Default is "new".
"default": tinytext NOT NULL
Empty if that theme is not the default one; "1" if it is the default theme
13. custom_field
Extra: PRIMARY KEY(`custom_field_id`)
Details: Stores any custom fields used for the browse section.
Details: Stores any custom fields used for the browse section.
"custom_field_id": tinyint(3) unsigned NOT NULL auto_increment
Gives a unique number to each record
"custom_field_name": varchar(40) NOT NULL default ''
Field title
"custom_field_pos": tinyint(3) unsigned NOT NULL default '0'
Field location
14. custom_field2user
Extra:
Details: Stores any custom fields used for users.
Details: Stores any custom fields used for users.
"user_id": int(10) unsigned NOT NULL default '0'
Users ID
"custom_field_id": tinyint(3) unsigned NOT NULL default '0'
Custom field ID
"custom_option_id": smallint(5) unsigned NOT NULL default '0'
Extra drop down options ID
"user_id_FK":
15. custom_field_option
Extra: PRIMARY KEY(`custom_option_id`)
Details: Extra drop down options for each extra field.
Details: Extra drop down options for each extra field.
"custom_option_id": smallint(5) unsigned NOT NULL auto_increment
Gives a unique number to each record
"custom_field_id": tinyint(3) unsigned NOT NULL default '0'
Main custom ID
"custom_option_name": varchar(40) NOT NULL default ''
Name of the drop down option
"custom_option_is_default": tinyint(1) unsigned NOT NULL default '0'
Default drop down option.
16. event_invite
Extra: PRIMARY KEY(`id`)
Details: Any insert here only happens after an insert in table "event". This table stores the invitations to each event in the site, posted under the "Events" section.. a member can only invite other members who are in its Friend list.
Details: Any insert here only happens after an insert in table "event". This table stores the invitations to each event in the site, posted under the "Events" section.. a member can only invite other members who are in its Friend list.
"id": bigint(20) NOT NULL auto_increment
Gives a unique number to each record
"event_id": bigint(20) NOT NULL default '0'
Links this invite to a unique event by its id, this event comes from the table "event"
"user": varchar(20) NOT NULL default ''
User who got an invitation, or who posted a message
"text": text NOT NULL
If user sets the RSVP to anything with a text then this is that text
"invite": tinyint(1) NOT NULL default '0'
"0" if user has not decided about the invitation "1" if user has accepted the invitation
"2" if user possibly will arrive at the event
"3" if user will not arrive at the event
"time": int(11) NOT NULL default '0'
Seconds from the unix epoch to the moment of insertion
"type": tinyint(1) NOT NULL default '0'
"1" if its a comment on the invite "0" if its anything else
17. events
Extra: PRIMARY KEY(`id`)
Details: This table stores all almost all the information related to an event. Gets populated when a new event is added.
Details: This table stores all almost all the information related to an event. Gets populated when a new event is added.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(40) NOT NULL default ''
User who posted the event
"type": varchar(40) NOT NULL default ''
The category of the event
"title": varchar(40) NOT NULL default ''
Event's title
"email": varchar(40) NOT NULL default ''
Email of the contact person
"private": tinyint(1) NOT NULL default '0'
Tells if the event is private or public. "1" for public, "2" for private
"short": tinytext NOT NULL
short description about the event
"text": text NOT NULL
Description about the event
"month": varchar(2) NOT NULL default ''
Two digit representation of the month
"day": varchar(2) NOT NULL default ''
Two digit representation of the day
"year": varchar(4) NOT NULL default ''
Four digit representation of the yar
"start_time": varchar(12) NOT NULL default ''
12 hour format of the time => "01:00 pm"
"place": varchar(50) NOT NULL default ''
Placed where the event should happen
"address": varchar(50) NOT NULL default ''
Address to get to the event
"city": varchar(30) NOT NULL default ''
City where the event will take place
"state": varchar(20) NOT NULL default ''
State
"zip": varchar(8) NOT NULL default ''
Zip code, 5 digits. [[ this could be set to varchar(8) or should be fixed in the input to allow 8 chars instead of 5]]
"country": varchar(50) NOT NULL default ''
Uses the list of countries found in:inc/txt/country.txt
"time": int(11) NOT NULL default '0'
When the insert actually happened, in seconds since the unix epoch
"views": int(11) NOT NULL default '0'
Every time the event's page is loaded it adds one to this record.
"feature": tinyint(1) NOT NULL default '0'
Boolean value if the event is featured. "0" for no and "1" for yes.
18. favorite
Extra: PRIMARY KEY(`id`)
Details: Records who is in who's favorite list. This table gets populated every time a user adds someone to its favorite list.
Details: Records who is in who's favorite list. This table gets populated every time a user adds someone to its favorite list.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
Member of someone's favorite list
"user1": tinytext NOT NULL
Member who has "user" in its favorite list
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
19. forum
Extra: PRIMARY KEY(`forum_id`)
Details: This table keeps a record of every forum available. Forums in the phpfox script as of version 1.0.9 have only one level.Meaning there are no sub-forums. This is effective only to the default phpfox forum.
Details: This table keeps a record of every forum available. Forums in the phpfox script as of version 1.0.9 have only one level.Meaning there are no sub-forums. This is effective only to the default phpfox forum.
"forum_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(50) NOT NULL default ''
NOT USED
"forum_title": varchar(50) NOT NULL default ''
Forum's title
"forum_info": tinytext NOT NULL
Forum's description
"img": varchar(30) NOT NULL default ''
File name of the image that serves as an avatar, displayed next to the forum name in the front forum section. If the image being uploaded has the exact same name as one already existing in the /images/forum/ folder then an error is triggered and the forum
"total_topics": int(11) NOT NULL default '0'
"total_posts": int(11) NOT NULL default '0'
"last_time": int(11) NOT NULL default '0'
"last_user": varchar(25) NOT NULL default ''
"last_thread": varchar(100) NOT NULL default ''
"last_id": int(11) NOT NULL default '0'
"last_url": int(11) NOT NULL default '0'
20. forum_reply
Extra: PRIMARY KEY(`id`)
Details: This table stores the replies to the topics in table forum_post.
Details: This table stores the replies to the topics in table forum_post.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"fid": int(11) NOT NULL default '0'
Stores the topic's id, the Forum id for so saying. The id of the record in table "forum_post" to which this reply corresponds to
"user": varchar(25) NOT NULL default ''
The member who posted it
"text": text NOT NULL
Message posted
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"type": varchar(3) NOT NULL default ''
Have only seen it as "1"
21. forum_topic
Extra: PRIMARY KEY(`id`)
Details: Holds every topic in the forums. A topic will have replies but it itself does not count as a post but as a topic
Details: Holds every topic in the forums. A topic will have replies but it itself does not count as a post but as a topic
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"type": varchar(30) NOT NULL default ''
This record is linked to the id on the table "forum", for instance if a forum has id "9" then any topic belonging to that forum must have type "9"
"user": varchar(25) NOT NULL default ''
Member who created the topic
"title": varchar(200) NOT NULL default ''
Topic's title
"text": text NOT NULL
Text in the post
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"view": int(11) NOT NULL default '0'
How many times has this topic been read
"update": int(11) NOT NULL default '0'
Same value as "time". It looks to have been intended as a record for when the post got edited.
"rating": decimal(3
NOT USED
"link": varchar(3) NOT NULL default ''
NOT USED
"total_replies": int(11) NOT NULL default '0'
Total replies
"last_time": int(11) NOT NULL default '0'
Last time someone posted
"last_user": varchar(25) NOT NULL default ''
Last user to post
"last_thread": varchar(100) NOT NULL default ''
Last thread title
"last_id": int(11) NOT NULL default '0'
Last threads ID
"last_url": int(11) NOT NULL default '0'
Last threads URL
22. forum_view
Extra: PRIMARY KEY(`id`)
Details: This table stores the first time a member views a topic.
Details: This table stores the first time a member views a topic.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"fid": tinytext NOT NULL
Is the forum id, the topic id as in the table "forum_post"
"user": tinytext NOT NULL
Member who saw the post
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
23. fun
Extra: PRIMARY KEY(`id`)
Details: This table stores the information related to the fun section, videos and games. It changes only when an item has been added from the Admin Panel or removed from the section itself.
Details: This table stores the information related to the fun section, videos and games. It changes only when an item has been added from the Admin Panel or removed from the section itself.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"type": tinytext NOT NULL
It can be either "games" or "video", needs to be set when adding from the Admin Panel
"title": tinytext NOT NULL
Title set from the Admin Panel for each item
"width": tinytext NOT NULL
NOT USED
"height": tinytext NOT NULL
NOT USED
"views": int(11) NOT NULL default '0'
Everytime a user clicks on an item from the fun section this record increases, default is 0 (zero)
"player": tinytext NOT NULL
NOT USED
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"link": text NOT NULL
Address to where the item is stored, must be in internet and can be in your own server
24. group_forum
Extra: PRIMARY KEY(`id`)
Details: This is a somewhat complicated table, it stores the posts and replies of the messages in a group's forum. So the only way to affect this table is by Topics get a one view as default, while replies get zero.
Details: This is a somewhat complicated table, it stores the posts and replies of the messages in a group's forum. So the only way to affect this table is by Topics get a one view as default, while replies get zero.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"group_id": tinytext NOT NULL
This record tells which forum is the post from, and its linked directly to the "id" field from table "group_main"
"reply_id": tinytext NOT NULL
Ok this field here is linked to "group_id" in this same table. Since Topics and Replies are stored in this table then this field tells to which "group_id" the post corresponds. So for example there is a Topic whose "group_id" is 5, any reply to that post
"user": tinytext NOT NULL
Member who posted
"title": tinytext NOT NULL
Title given to the post
"text": text NOT NULL
Message posted
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"type": tinytext NOT NULL
Empty if its a Topic and "reply" if its a reply to a topic
"views": int(11) NOT NULL default '0'
How many times has the post been seen, by default Topics get a starting value of "1" while replies get a "0"
25. group_gallery
Extra: PRIMARY KEY(`id`)
Details: Stores image details posted in the groups.
Details: Stores image details posted in the groups.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"group_id": tinytext NOT NULL
This record tells which forum is the post from, and its linked directly to the "id" field from table "group_main"
"user": tinytext NOT NULL
Users ID
"img": tinytext NOT NULL
Image file location
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"default": tinytext NOT NULL
If the image is the default image of the entire group
"title": tinytext NOT NULL
Title for the image
26. group_invite
Extra: PRIMARY KEY(`id`)
Details: Stores invites sent from users to users in the groups
Details: Stores invites sent from users to users in the groups
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"type_id": tinytext NOT NULL
Type of a certain invite used for the specific group.
"group_id": tinytext NOT NULL
This record tells which forum is the post from, and its linked directly to the "id" field from table "group_main"
"user": tinytext NOT NULL
User id of the inviter
"invite": tinytext NOT NULL
User id of the invite
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
27. group_main
Extra: PRIMARY KEY(`id`)
Details: Main details for each group being added by members.
Details: Main details for each group being added by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who created the group
"title": tinytext NOT NULL
Group main title
"headline": tinytext NOT NULL
Group short headline
"email": tinytext NOT NULL
Contact email for the group
"type": tinytext NOT NULL
Certain type of group
"open_join": tinytext NOT NULL
Show it allow all users to join this group
"hide_group": tinytext NOT NULL
If the group is private or not.
"mem_invite": tinytext NOT NULL
Allow the members to invite other members.
"pub_forum": tinytext NOT NULL
Allow everyone to either view or not view the forums.
"location": tinytext NOT NULL
Main country of the group.
"city": tinytext NOT NULL
Main city where the group is located.
"mem_image": tinytext NOT NULL
Allow users to upload images.
"text": text NOT NULL
Main content for the group.
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"views": int(11) NOT NULL default '0'
How many times has the group been viewed
"edit": int(11) NOT NULL default '0'
When was the last time someone edited the group.
28. group_member
Extra: PRIMARY KEY(`id`)
Details: Stores all the members for each group.
Details: Stores all the members for each group.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"type_id": tinytext NOT NULL
Type of group
"group_id": tinytext NOT NULL
This record tells which forum is the post from, and its linked directly to the "id" field from table "group_main"
"user": tinytext NOT NULL
User of the group
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
29. group_name
Extra: PRIMARY KEY(`id`)
Details: Main details for each group being added by the admins
Details: Main details for each group being added by the admins
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"name": tinytext NOT NULL
Name of the group
30. hot_quiz
Extra: PRIMARY KEY(`id`)
Details: Stores main details for a quiz being added by members.
Details: Stores main details for a quiz being added by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who created the quiz
"title": tinytext NOT NULL
Title of the quiz
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"player": tinytext NOT NULL
Last person to take the quiz
"points": tinytext NOT NULL
Last person to take the quiz we store what they got
"views": int(11) NOT NULL default '0'
How many times the quiz has been viewed
"type": tinytext NOT NULL
If the quiz has already been approved or not.
31. html_layout
Extra: PRIMARY KEY(`id`)
Details: Stores template details.
Details: Stores template details.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"name": tinytext NOT NULL
Name of HTML core layout
"file": tinytext NOT NULL
Location of the actual layout
"default": tinytext NOT NULL
If the layout is the default layout
32. invite
Extra: PRIMARY KEY(`id`)
Details: Stores all the invites a member has invited to the site.
Details: Stores all the invites a member has invited to the site.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who is invting
"email": tinytext NOT NULL
Email of the invited user
"type": tinytext NOT NULL
NOT USED
33. journal
Extra: PRIMARY KEY(`id`)
Details: Stores all the blogs being posted by members.
Details: Stores all the blogs being posted by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who created the blog
"title": tinytext NOT NULL
Title of the blog
"text": text NOT NULL
Main blog content
"time": int(11) NOT NULL default '0'
Time in seconds since the unix epoch to the moment of insertion in the database
"jmood": tinytext NOT NULL
Mood of the person taking the blog
"gcatagory": tinytext NOT NULL
NOT USED
"view": int(11) NOT NULL default '0'
How many times has the blog been viewed
"comment": int(11) NOT NULL default '0'
How many times has the blog been commented on
"dlink": tinytext NOT NULL
NOT USED
"img": tinytext NOT NULL
NOT USED
"ip": tinytext NOT NULL
NOT USED
"rating": decimal(3
NOT USED
34. listing
Extra: PRIMARY KEY(`id`)
Details: Stores all classifieds being posted by members.
Details: Stores all classifieds being posted by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"name": tinytext NOT NULL
Classified name
"num": int(11) NOT NULL default '0'
Order setup
35. listing_main
Extra: PRIMARY KEY(`id`)
Details: Stores classifieds categories created by admins.
Details: Stores classifieds categories created by admins.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"list_id": tinytext NOT NULL
Category ID that connects to "listing"
"user": tinytext NOT NULL
User who created this lising
"title": tinytext NOT NULL
Title of the listing
"text": text NOT NULL
Content of the listing
"location": tinytext NOT NULL
Location of the actual listing
"city": tinytext NOT NULL
City of the actual lising
"time": int(11) NOT NULL default '0'
Time it was created in seconds.
"views": int(11) NOT NULL default '0'
Stores how many times a listing has been viewed
"edit": int(11) NOT NULL default '0'
Last time this listing was edited
"state": tinytext NOT NULL
State of where the listing is located if in the U.S.
36. mail
Extra: PRIMARY KEY(`id`)
Details: Stores all mail being sent to members by members.
Details: Stores all mail being sent to members by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"to": tinytext NOT NULL
User we are sending a message to
"from": tinytext NOT NULL
User who sent a message
"title": tinytext NOT NULL
Title of the message
"text": text NOT NULL
Content of the message
"time": int(11) NOT NULL default '0'
Time the message was sent
"seen": tinytext NOT NULL
Check if the message has been read by the other user
"type": tinytext NOT NULL
Checks what type of message it is
"ip": tinytext NOT NULL
NOT USED
"is_del_sent": tinyint(1) NOT NULL default '0'
If its a sent message
37. main
Extra: PRIMARY KEY(`id`)
Details: Stores details for each image posted to the gallery.
Details: Stores details for each image posted to the gallery.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who added the image
"text": text NOT NULL
Title of the image
"time": int(11) NOT NULL default '0'
Time the image was added
"gcatagory": tinytext NOT NULL
Category of the image- Edited from the admin panel.
"view": int(11) NOT NULL default '0'
How many times it has been viewed.
"votes": int(11) NOT NULL default '0'
Total numbers of votes the image has
"ip": tinytext NOT NULL
NOT USED
"rating": decimal(3
Total rating for the image
"comment": int(11) NOT NULL default '0'
How many comments have been posted for this image
"faceoff": int(11) NOT NULL default '0'
Battle points used from the main battle section
"img": tinytext NOT NULL
Image URL location
"width": tinytext NOT NULL
NOT USED
"height": tinytext NOT NULL
NOT USED
"allow": tinytext NOT NULL
If the image is allowed to be online for other members to see
"feature": tinytext NOT NULL
Feature the image
"is_adult": tinyint(1) unsigned NOT NULL default '0'
If the image is only for "adults" of the site.
"who_view": enum('everyone'
Who can view the image.
38. memb2perm
Extra: PRIMARY KEY(`memb2perm_id`), KEY `Reference_62_FK` (`membership_id`), KEY `Reference_63_FK` (`module_perm_id`)
Details: Membership permissions.
Details: Membership permissions.
"memb2perm_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"membership_id": int(11) NOT NULL default '0'
Special ID of the membership
"module_perm_id": int(11) default NULL
Module permission
"val": varchar(255) default NULL
Access this permission gets.
"memb2perm_id": )
"Reference_62_FK":
39. membership
Extra: PRIMARY KEY(`membership_id`)
Details: Main memberships created by admins
Details: Main memberships created by admins
"membership_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"is_special": tinyint(4) NOT NULL default '0'
If the membership is a new special membership
"img": varchar(100) NOT NULL default ''
Name of the image
"title": varchar(255) NOT NULL default ''
Title of the membership
"descr": text NOT NULL
Info about the membership
"price": decimal(9
Price of the membership if any
"pay_type": enum('onetime'
Payment plan
"max_upload": int(11) NOT NULL default '0'
Max space the membership can use
"max_inbox": int(11) NOT NULL default '0'
Max number of messages in their inbox
"is_internal": tinyint(4) NOT NULL default '0'
"no_ads": tinyint(4) NOT NULL default '0'
Should we allow or not allow ads
"allow_block": tinyint(4) NOT NULL default '0'
Allow user to block other users
"design_tool": tinyint(4) NOT NULL default '0'
Allow the user to use the design tool
"pos": tinyint(4) NOT NULL default '0'
Special ID for only special memberships that were created.
40. messenger
Extra: PRIMARY KEY(`message_id`)
Details: Stores online messages used for the IM.
Details: Stores online messages used for the IM.
"message_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"chat_id": int(11) NOT NULL default '0'
Chat ID we get from the URL
"user_id": int(11) NOT NULL default '0'
User id
"user_name": varchar(64) default NULL
Users name
"message": text latin1_general_ci
Message the user has added
"post_time": datetime default NULL
Time the message was added
"session": int(11) NOT NULL default '0'
NOT USED
41. messenger_check
Extra:
Details: IM messenger check if a user is online.
Details: IM messenger check if a user is online.
"user": varchar(25) NOT NULL default ''
User who is getting a request
"chat_id": int(11) NOT NULL default '0'
Chat that is being requested
42. messenger_id
Extra: PRIMARY KEY(`id`)
Details: IM messenger user id to check who is in the chat.
Details: IM messenger user id to check who is in the chat.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user1": varchar(25) NOT NULL default ''
User that requested the chat
"user2": varchar(25) NOT NULL default ''
The user who received the chat.
"check": tinyint(4) NOT NULL default '0'
If the chat has been checked yet
"count": tinyint(4) NOT NULL default '0'
How many messages in the actual chat
"time": int(11) NOT NULL default '0'
Time the chat started
"seen": char(1) NOT NULL default ''
If the chat message has been seen
43. module_perm
Extra: PRIMARY KEY(`module_perm_id`)
Details: Module permissions for each module.
Details: Module permissions for each module.
"module_perm_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"code": varchar(100) NOT NULL default ''
Module name
"vals": text NOT NULL
Permission for the module
44. online
Extra: PRIMARY KEY(`id`)
Details: Stores who is online.
Details: Stores who is online.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User that is online
"page": tinytext NOT NULL
Page the user is at
"time": int(11) NOT NULL default '0'
Current IP
"ip": tinytext NOT NULL
Users IP
45. online_session
Extra: PRIMARY KEY(`online_session_id`)
Details: Stores who is online with session details.
Details: Stores who is online with session details.
"online_session_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"online_session_detail": varchar(32) NOT NULL default ''
Stores the users MD5 password
"online_session_page": varchar(30) NOT NULL default ''
Page the user is visiting
"online_session_time": int(11) NOT NULL default '0'
Time of the current session
"online_session_login": int(11) NOT NULL default '0'
If the user is logged in
"online_session_user": varchar(25) NOT NULL default ''
Add the username if its a actual member
"online_session_status": varchar(2) NOT NULL default ''
Status of the actual user
"online_session_ip": varchar(20) NOT NULL default ''
IP for the user
"online_session_staff": char(1) NOT NULL default ''
If the user is a staff member
46. page
Extra: PRIMARY KEY(`id`)
Details: Stores the page of where the user is visiting.
Details: Stores the page of where the user is visiting.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User ID
"page": tinytext NOT NULL
module they are viewing
"time": int(11) NOT NULL default '0'
Current time of the entry
47. payment_log
Extra: PRIMARY KEY(`log_id`)
Details: Stores a log of payments being made.
Details: Stores a log of payments being made.
"log_id": mediumint(9) NOT NULL auto_increment
Gives a unique number to each record
"post_data": text NOT NULL
POST data sent back from the gateway
"remote_ip": varchar(20) NOT NULL default ''
IP of the gateway
"processor": enum('metacharge'
Name of the actual gateway
"type": enum('request'
What sort of request is it
"cdate": datetime NOT NULL default '0000-00-00 00:00:00'
Date of the request
48. poll_vote
Extra:
Details: Stores the votes for each poll that a user makes.
Details: Stores the votes for each poll that a user makes.
"id": tinytext NOT NULL
Gives a unique number to each record
"user": tinytext NOT NULL
User who voted
"poll": tinytext NOT NULL
ID of the poll taken
"answer": tinytext NOT NULL
Answer of the poll
"ip": tinytext NOT NULL
NOT USED
49. polls
Extra: PRIMARY KEY(`id`)
Details: Stores all the polls created by members.
Details: Stores all the polls created by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": tinytext NOT NULL
User who created the poll.
"poll": tinytext NOT NULL
Title of the poll
"option": tinytext NOT NULL
All the options for the poll
"time": int(11) NOT NULL default '0'
Time the poll was created
"o1": tinytext NOT NULL
Poll option 1
"o2": tinytext NOT NULL
Poll option 2
"o3": tinytext NOT NULL
Poll option 3
"o4": tinytext NOT NULL
Poll option 4
"a1": int(11) NOT NULL default '0'
Poll Answer 1
"a2": int(11) NOT NULL default '0'
Poll Answer 2
"a3": int(11) NOT NULL default '0'
Poll Answer 3
"a4": int(11) NOT NULL default '0'
Poll Answer 4
"type": tinyint(4) NOT NULL default '0'
If the poll is allowed to be viewed on the site. Used for the admin approval system.
50. quiz
Extra: PRIMARY KEY(`id`)
Details: Stores the main quiz created by members.
Details: Stores the main quiz created by members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"cid": tinytext NOT NULL
Main quiz ID to connect to all the main details
"q1": tinytext NOT NULL
Question for the quiz
"a1": tinytext NOT NULL
Answer 1
"a2": tinytext NOT NULL
Answer 2
"a3": tinytext NOT NULL
Answer 3
"a4": tinytext NOT NULL
Answer 4
"answer": tinytext NOT NULL
Correct answer for the quiz
51. quiz_1
Extra:
Details: Stores the details on what the user added when taking a quiz.
Details: Stores the details on what the user added when taking a quiz.
"id": tinytext NOT NULL
Gives a unique number to each record
"q": tinytext NOT NULL
Quiz question
"a1": tinytext NOT NULL
Answer the user added
52. quiz_2
Extra: PRIMARY KEY(`id`)
Details: Stores the details on what quiz a user is taking.
Details: Stores the details on what quiz a user is taking.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"quizid": tinytext NOT NULL
Main quiz id
"user": tinytext NOT NULL
User who created the quiz
"user1": tinytext NOT NULL
User who took the quiz
"score": tinytext NOT NULL
Latest score
"time": int(11) NOT NULL default '0'
Time the quiz was taken
"seen": tinytext NOT NULL
If someone has viewed the quiz
53. rating
Extra: PRIMARY KEY(`id`)
Details: Any ratings done on the site is stored here.
Details: Any ratings done on the site is stored here.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"main": varchar(10) NOT NULL default ''
Main ID for the gallery
"main2": varchar(10) NOT NULL default ''
NOT USED
"user": varchar(25) NOT NULL default ''
User that rated an image
"rating": decimal(3
Rating the user added
"time": int(11) NOT NULL default '0'
Time of the rating
"ip": varchar(20) NOT NULL default ''
NOT USED
54. sale
Extra: PRIMARY KEY(`sale_id`)
Details: Stores details on when a sale is made by a user.
Details: Stores details on when a sale is made by a user.
"sale_id": mediumint(9) NOT NULL auto_increment
Gives a unique number to each record
"account_id": mediumint(9) NOT NULL default '0'
"membership_id": int(11) NOT NULL default '0'
Members ID
"price": decimal(9
Price of the item
"cdate": datetime NOT NULL default '0000-00-00 00:00:00'
Date it was created
"status": enum('approved'
Status of the sale
55. session
Extra: PRIMARY KEY(`id`)
Details: Stores the session for when a user is viewing another users profile.
Details: Stores the session for when a user is viewing another users profile.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(25) NOT NULL default ''
User that is viewing another user
"viewing": tinytext NOT NULL
The user that user A is viewing.
"time": int(11) NOT NULL default '0'
Time user B was viewed
56. site_session
Extra: PRIMARY KEY(`id`)
Details: Stores the main session for all movement done on the site.
Details: Stores the main session for all movement done on the site.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(25) NOT NULL default ''
User ID
"ip": varchar(20) NOT NULL default ''
IP for the user
"browser": tinytext NOT NULL
Browser the user is using
"host": tinytext NOT NULL
Host of the user
"time": int(11) NOT NULL default '0'
Time the user visited a certain area
"page": tinytext NOT NULL
Page the user visited
"port": varchar(5) NOT NULL default ''
PORT used to visit at
"protocal": varchar(5) NOT NULL default ''
If a GET or POST protocol was used
"refer": tinytext NOT NULL
Refer page if any was used
57. site_stats
Extra: PRIMARY KEY(`id`)
Details: Stores main stats for the site such as how many members a site has.
Details: Stores main stats for the site such as how many members a site has.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"forum_threads": int(11) NOT NULL default '0'
Total forum threads created
"forum_posts": int(11) NOT NULL default '0'
Total forum posts created
"users_total": int(11) NOT NULL default '0'
Total users on the site
58. staff_perm
Extra: PRIMARY KEY(`staff_perm_id`)
Details: Stores the staff permissions.
Details: Stores the staff permissions.
"staff_perm_id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"code": varchar(100) NOT NULL default ''
Special admin panel code for a certain module
"val": tinyint(4) NOT NULL default '0'
Special ID
"sect": varchar(20) default NULL
Section the module is located
59. sys_sett
Extra: PRIMARY KEY(`sett_id`)
Details: Stores the main configuration details.
Details: Stores the main configuration details.
"sett_id": smallint(5) unsigned NOT NULL auto_increment
Gives a unique number to each record
"code": varchar(200) NOT NULL default ''
variable for the setting
"val": text NOT NULL
value of the setting
"settype": enum('text'
type of setting it is
"block": enum('site'
where the setting is located in the admin panel.
"pos": smallint(5) unsigned NOT NULL default '0'
Position of the setting
60. template
Extra: PRIMARY KEY(`id`)
Details: Stores the CSS details for users when they edit their profiles.
Details: Stores the CSS details for users when they edit their profiles.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(25) NOT NULL default ''
User this templates belows to
"bg_color": varchar(12) NOT NULL default ''
Background color
"bg_img": varchar(12) NOT NULL default ''
Background image
"bg_main": varchar(12) NOT NULL default ''
Main background color
"color_main": varchar(12) NOT NULL default ''
Main text color
"link_on": varchar(12) NOT NULL default ''
A hover color
"link_hover": varchar(12) NOT NULL default ''
A:Hover color
"username_bg": varchar(12) NOT NULL default ''
Username background color
"username_color": varchar(12) NOT NULL default ''
Username text color
"top_menu": varchar(12) NOT NULL default ''
Top menu color
"top_text": varchar(12) NOT NULL default ''
Top text color
"mainmenu4": varchar(12) NOT NULL default ''
Main menu color
"mainmenu4_txt": varchar(12) NOT NULL default ''
Main menu text color
"border2": varchar(12) NOT NULL default ''
Main border colors
"border2_txt": varchar(12) NOT NULL default ''
Text color within any main border
"bottom": varchar(12) NOT NULL default ''
Bottom panel color
"bottom_txt": varchar(12) NOT NULL default ''
Bottom panel text color
"nav1_bg": varchar(12) NOT NULL default ''
Contact panel background color
"nav1_a_bg": varchar(12) NOT NULL default ''
Contact panel a color
"nav1_a_txt": varchar(12) NOT NULL default ''
Contact panel a:hover color
"nav1_a2_bg": varchar(12) NOT NULL default ''
Contact panel background color :Hover
"nav1_a2_txt": varchar(12) NOT NULL default ''
Contact panel a color :Hover
"nav2_a_bg": varchar(12) NOT NULL default ''
Contact panel a:hover color :hover
"nav2_a_txt": varchar(12) NOT NULL default ''
Contact panel text color
"nav2_a2_bg": varchar(12) NOT NULL default ''
NOT USED
"nav2_a2_txt": varchar(12) NOT NULL default ''
NOT USED
"nav2_sqr": varchar(12) NOT NULL default ''
Small sqr.
"cmt_bg": varchar(12) NOT NULL default ''
Comment background
"cmt_txt": varchar(12) NOT NULL default ''
Comment text color
"cmt2_bg": varchar(12) NOT NULL default ''
Comment title background
"cmt2_txt": varchar(12) NOT NULL default ''
Comment text color
"menu_bg": varchar(12) NOT NULL default ''
Side menu background
"menu_a": varchar(12) NOT NULL default ''
Side menu background a
"menu_a_txt": varchar(12) NOT NULL default ''
Side menu background a txt
"menu2_a": varchar(12) NOT NULL default ''
Side menu background a
"menu2_a_txt": varchar(12) NOT NULL default ''
Side menu background a txt
"css": text NOT NULL
Extra advanced CSS usage.
61. user
Extra: PRIMARY KEY(`id`), UNIQUE KEY `user` (`user`), KEY `idx_user.feature` (`feature`), KEY `idx_user.login` (`login`), KEY `idx_user.user_online` (`user_online`), KEY `idx_user.verify` (`verify`)
Details: Stores main details for each member.
Details: Stores main details for each member.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"type": tinyint(4) NOT NULL default '0'
Membership status
"user": varchar(25) NOT NULL default ''
User name
"password": varchar(35) NOT NULL default ''
MD5 password for the user
"email": varchar(50) NOT NULL default ''
Email for the user
"gender": varchar(6) NOT NULL default ''
Users gender
"sex": varchar(35) NOT NULL default ''
Use orientation
"age": char(2) NOT NULL default ''
NOT USED
"day": char(2) NOT NULL default ''
Date of birth
"month": char(2) NOT NULL default ''
Month of birth
"year": varchar(4) NOT NULL default ''
Year of birth
"location": varchar(25) NOT NULL default ''
Location of the user
"me": text NOT NULL
About the user
"dating": varchar(35) NOT NULL default ''
Dating info about the user
"job": varchar(35) NOT NULL default ''
Users job
"smoke": varchar(35) NOT NULL default ''
If the user smokes
"drink": varchar(35) NOT NULL default ''
If the user drinks
"signup": int(11) NOT NULL default '0'
Signup date
"signup_ip": varchar(20) NOT NULL default ''
Signup IP
"login": int(11) NOT NULL default '0'
Login date of the user
"login_ip": varchar(20) NOT NULL default ''
Login IP
"rec": varchar(20) NOT NULL default ''
NOT USED
"update": varchar(20) NOT NULL default ''
Time the user update their profile
"religion": varchar(35) NOT NULL default ''
Religion of the user
"turnon": text NOT NULL
Users turn on's
"turnoff": text NOT NULL
Users turn off's
"hobbies": text NOT NULL
Hobbies for the user
"movies": text NOT NULL
Movies the user likes
"music": text NOT NULL
Music the user likes
"books": text NOT NULL
Books the user likes
"headline": text NOT NULL
Headline for the user
"views": int(11) NOT NULL default '0'
How many times has the users profile been viewed
"css": tinytext NOT NULL
Theme ID of what the user is using.
"rateon": char(1) NOT NULL default ''
Rating score the user has from other users
"verify": char(1) NOT NULL default ''
If the user has verified their account, only if the verification system is online.
"verifycode": varchar(20) NOT NULL default ''
Verification code if needed.
"videon": char(1) NOT NULL default ''
Video ID to display video from the music section.
"p_update": varchar(10) NOT NULL default '0'
NOT USED
"img": varchar(10) NOT NULL default ''
NOT USED ANYMORE
"mood": varchar(15) NOT NULL default ''
NOT USED
"music_video": varchar(8) NOT NULL default ''
NOT USED
"not_1": char(1) NOT NULL default ''
Notification check 1
"not_2": char(1) NOT NULL default ''
Notification check 2
"not_3": char(1) NOT NULL default ''
Notification check 3
"not_4": char(1) NOT NULL default ''
Notification check 4
"not_5": char(1) NOT NULL default ''
Notification check 5
"feature": tinyint(1) NOT NULL default '0'
If the user is featured
"html_layout": int(1) NOT NULL default '0'
NOT USED
"state": varchar(20) NOT NULL default ''
U.S. State the user is from
"zip": varchar(20) NOT NULL default '0'
Zip code of the user
"city": varchar(30) NOT NULL default ''
City location
"user_online": tinyint(4) NOT NULL default '0'
If the user is online
"session_id": varchar(50) NOT NULL default ''
Online session ID that connects to the online table
"user_rating": decimal(4
Total user rating
"friends_only": tinyint(4) NOT NULL default '0'
If friends can only view their profile
"friends_comment": tinyint(4) NOT NULL default '0'
If friends are the ones only allowed to comment on their profiles.
"setting_gb_html": tinyint(4) NOT NULL default '0'
Disallow HTML in guestbook entries.
"remember_me": char(1) NOT NULL default ''
If we should remember this user during the login process
"new_pass": varchar(25) NOT NULL default ''
New password if the user has requested a new password
"is_banned": tinyint(1) unsigned NOT NULL default '0'
If the user is banned by an admin
"last_payment": datetime default '0000-00-00 00:00:00'
Last time the user made a payment
"wysiwyg": char(1) NOT NULL default ''
NOT USED
"body_type": varchar(50) NOT NULL default ''
Body type of the user
"total_points": int(11) NOT NULL default '0'
Total points the user has
"php121_user_chatting": int(11) NOT NULL default '0'
PHP121 INTEGRATION NO INFO
"php121_smilies": tinyint(1) NOT NULL default '1'
PHP121 INTEGRATION NO INFO
"php121_level": tinyint(1) NOT NULL default '1'
PHP121 INTEGRATION NO INFO
"php121_showrequest": tinyint(1) NOT NULL default '1'
PHP121 INTEGRATION NO INFO
"php121_beep_newmsg": tinyint(1) NOT NULL default '1'
PHP121 INTEGRATION NO INFO
"php121_focus_newmsg": tinyint(1) NOT NULL default '1'
PHP121 INTEGRATION NO INFO
"php121_auto_email_transcript": tinyint(1) NOT NULL default '0'
PHP121 INTEGRATION NO INFO
"php121_banned": tinyint(1) NOT NULL default '0'
PHP121 INTEGRATION NO INFO
"php121_timezone": tinyint(3) NOT NULL default '0'
PHP121 INTEGRATION NO INFO
"php121_timestamp": tinyint(1) NOT NULL default '1'
PHP121 INTEGRATION NO INFO
"php121_language": varchar(30) NOT NULL default 'English'
PHP121 INTEGRATION NO INFO
"php121_cl_update_key": int(11) NOT NULL default '0'
PHP121 INTEGRATION NO INFO
62. user_info
Extra: PRIMARY KEY(`id`)
Details: Stores main points a user has earned.
Details: Stores main points a user has earned.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"user": varchar(25) NOT NULL default ''
User ID
"total": int(11) NOT NULL default '0'
Total points the user has
"gallery": int(11) NOT NULL default '0'
Total images uploaded
"journal": int(11) NOT NULL default '0'
Total blog posts
"poll": int(11) NOT NULL default '0'
Total polls added
"quiz": int(11) NOT NULL default '0'
Total quiz created
"comment": int(11) NOT NULL default '0'
Total comments added
"forum": int(11) NOT NULL default '0'
Total forum threads/posts added
"viewing": int(11) NOT NULL default '0'
Total times the user has viewed other profiles
"invite": int(11) NOT NULL default '0'
Total invite the user has
63. user_rating
Extra: PRIMARY KEY(`id`)
Details: Stores any ratings for members.
Details: Stores any ratings for members.
"id": int(11) NOT NULL auto_increment
Gives a unique number to each record
"rater": int(11) NOT NULL default '0'
User who is rating
"user": int(11) NOT NULL default '0'
The user we plan to rate
"rating": decimal(3
Actual rating score
