| Help | ||
|
table |
|
inl_cats |
|
inl_config |
|
inl_custom |
|
inl_email |
|
inl_lc |
|
inl_links |
|
inl_reviews |
|
inl_search_log |
|
inl_users |
|
inl_votes |
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
cat_id |
int(11) |
|
No |
|
auto_increment |
|
cat_name |
varchar(255) |
|
Yes |
|
|
|
cat_desc |
mediumtext |
|
Yes |
|
|
|
cat_user |
int(11) |
|
No |
0 |
|
|
cat_sub |
int(11) |
|
No |
0 |
|
|
cat_perm |
tinyint(4) |
|
No |
0 |
|
|
cat_pend |
tinyint(4) |
|
No |
0 |
|
|
cat_vis |
tinyint(4) |
|
No |
0 |
|
|
cat_links |
int(11) |
|
No |
0 |
|
|
cat_cats |
int(11) |
|
No |
0 |
|
|
cat_date |
int(11) |
|
No |
0 |
|
|
cat_pick |
int(11) |
|
No |
0 |
|
|
cat_image |
varchar(255) |
|
Yes |
|
|
|
cat_cust |
int(11) |
|
No |
0 |
|
|
meta_keywords |
text |
|
Yes |
|
|
|
meta_desc |
text |
|
Yes |
|
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
name |
varchar(255) |
|
No |
|
|
|
value |
varchar(255) |
|
No |
|
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
cust_id |
int(11) |
|
No |
0 |
auto_increment |
|
cust1 |
varchar(255) |
|
Yes |
|
|
|
cust2 |
varchar(255) |
|
Yes |
|
|
|
cust3 |
varchar(255) |
|
Yes |
|
|
|
cust4 |
text |
|
Yes |
|
|
|
cust5 |
text |
|
Yes |
|
|
|
cust6 |
text |
|
Yes |
|
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
email_id |
int(10) |
UNSIGNED |
No |
0 |
auto_increment |
|
email_subject |
varchar(255) |
|
Yes |
|
|
|
email_body |
text |
|
Yes |
|
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
link_id |
int(11) |
|
No |
0 |
|
|
cat_id |
int(11) |
|
No |
0 |
|
|
link_pend |
tinyint(4) |
|
No |
0 |
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
link_id |
int(11) |
UNSIGNED |
No |
|
auto_increment |
|
link_name |
varchar(254) |
|
No |
|
|
|
link_desc |
text |
|
No |
|
|
|
link_url |
varchar(254) |
|
No |
|
|
|
link_date |
int(11) |
|
No |
0 |
|
|
link_user |
int(11) |
|
No |
0 |
|
|
link_hits |
int(11) |
|
No |
0 |
|
|
link_votes |
int(11) |
|
No |
0 |
|
|
link_rating |
decimal(6,4) |
|
No |
0.0000 |
|
|
link_pick |
tinyint(2) |
|
No |
0 |
|
|
link_vis |
tinyint(2) |
|
No |
0 |
|
|
link_image |
varchar(254) |
|
Yes |
|
|
|
link_cust |
int(11) |
|
Yes |
|
|
|
link_numrevs |
int(11) |
|
No |
0 |
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
rev_id |
int(11) |
|
No |
|
auto_increment |
|
rev_link |
int(11) |
|
No |
0 |
|
|
rev_user |
int(11) |
|
No |
0 |
|
|
rev_text |
text |
|
Yes |
|
|
|
rev_date |
int(11) |
|
No |
0 |
|
|
rev_pend |
tinyint(4) |
|
No |
0 |
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
log_id |
int(11) |
UNSIGNED |
No |
0 |
auto_increment |
|
log_type |
tinyint(2) |
|
No |
0 |
|
|
log_date |
int(11) |
|
No |
0 |
|
|
log_search |
tinyint(2) |
|
No |
0 |
|
|
log_keyword |
varchar(255) |
|
No |
|
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
user_id |
int(11) |
|
No |
|
auto_increment |
|
user_name |
varchar(20) |
|
No |
|
|
|
user_pass |
varchar(50) |
|
Yes |
|
|
|
first |
varchar(50) |
|
No |
|
|
|
last |
varchar(50) |
|
No |
|
|
|
|
varchar(255) |
|
No |
|
|
|
user_perm |
tinyint(4) |
|
No |
0 |
|
|
user_date |
int(11) |
|
No |
0 |
|
|
user_cust |
int(11) |
|
No |
0 |
|
|
user_status |
tinyint(2) |
|
No |
0 |
|
|
user_pend |
tinyint(4) |
|
No |
0 |
|
|
user_ses |
int(11) |
|
No |
0 |
|
|
Field |
Type |
Attributes |
Null |
Default |
Extra |
|
stamp |
int(11) |
|
No |
0 |
|
|
vote_ip |
varchar(16) |
|
No |
|
|
|
vote_link |
int(11) |
|
No |
0 |
|
|
name |
value |
|
language |
english |
|
filedir |
/$filedir / |
|
cols |
2 |
|
datefmt |
m-d-Y |
|
lim |
15 |
|
sitename |
In-Link 2! |
|
lc1 |
|
|
lc2 |
|
|
lc3 |
|
|
lc4 |
|
|
lc5 |
|
|
lc6 |
|
|
server |
$server |
|
filepath |
/$urldir/ |
|
cc1 |
|
|
cc2 |
|
|
cc3 |
|
|
cc4 |
|
|
cc5 |
|
|
cc6 |
|
|
uc6 |
|
|
uc5 |
|
|
uc4 |
|
|
uc3 |
|
|
uc2 |
|
|
uc1 |
|
|
cat_order |
cat_name |
|
cat_sort |
asc |
|
cat_new |
5 |
|
link_order |
link_name |
|
link_sort |
asc |
|
link_pop |
15 |
|
link_top |
6 |
|
link_new |
2 |
|
email_perm |
11111111111111 |
|
db_version |
$version |
|
keya |
|
|
theme |
default |
|
reg_code |
$reg_code |
|
first_name |
$first |
|
last_name |
$last |
|
rating_expiration |
10 |
|
review_expiration |
10 |
|
rate_perm |
3 |
|
review_perm |
8 |
|
suggest_cat_perm |
7 |
|
ses_exp |
36000 |
|
default_image |
images/default.gif |
|
default_meta_keywords |
meta keywords go here |
|
default_meta_desc |
meta description does here |
|
force_pick |
1 |
|
use_pick_tpl |
1 |
|
review_sort |
desc |
|
root_link_perm |
7 |
|
user_perm |
2 |
|
review_order |
rev_date |
|
keyb |
|
![]()