forked from delpino73/Blue-Smiley-Organizer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
show-database-fields.php
112 lines (66 loc) · 4.44 KB
/
show-database-fields.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
require 'class.base.php';
require 'class.html.php';
$base_instance=new base();
$html_instance=new html();
$userid=$base_instance->get_userid();
if (!empty($_GET['category_id'])) { $category_id=(int)$_GET['category_id']; } else { exit; }
# get checkbox fields
$all_text='<table border=1 cellspacing=0 cellpadding=10 bgcolor="#ffffff" class="pastel"><tr><td><strong>Checkbox Fields</strong> <a href="add-database-checkbox-field.php?category_id='.$category_id.'">[Add New]</a><br><br>';
$data=$base_instance->get_data("SELECT * FROM {$base_instance->entity['DATABASE']['CHECKBOX_FIELDS']} WHERE category_id='$category_id' AND user='$userid'");
$all_text.='<table border=1 cellspacing=0 cellpadding=2 bgcolor="#ffffff" class="pastel">';
for ($index=1; $index <= sizeof($data); $index++) {
$ID=$data[$index]->ID;
$title=$data[$index]->title;
$all_text.='<tr><td bgcolor="#dedede"><b>'.$title.'</b></td>
<td><a href="edit-database-checkbox-field.php?checkbox_field_id='.$ID.'">[Edit]</a></td>
<td><a href="javascript:void(window.open(\'delete-database-checkbox-field.php?checkbox_field_id='.$ID.'\',\'\',\'width=450,height=200,top=100,left=100\'))">[Delete Field]</a></td><td><a href="delete-database-checkbox-field-items.php?checkbox_field_id='.$ID.'">[Delete Field Items]</a></td></tr>';
}
$all_text.='</table></td></tr></table><p>';
# get select fields
$all_text.='<table border=1 cellspacing=0 cellpadding=10 bgcolor="#ffffff" class="pastel"><tr><td>';
$all_text.='<strong>Select Fields</strong> <a href="add-database-select-field.php?category_id='.$category_id.'">[Add New]</a><br><br>';
$data=$base_instance->get_data("SELECT * FROM {$base_instance->entity['DATABASE']['SELECT_FIELDS']} WHERE category_id='$category_id' AND user='$userid'");
$all_text.='<table border=1 cellspacing=0 cellpadding=2 bgcolor="#ffffff" class="pastel">';
for ($index=1; $index <= sizeof($data); $index++) {
$ID=$data[$index]->ID;
$title=$data[$index]->title;
$all_text.='<tr><td bgcolor="#dedede"><b>'.$title.'</b></td>
<td><a href="edit-database-select-field.php?select_field_id='.$ID.'">[Edit]</a></td>
<td><a href="javascript:void(window.open(\'delete-database-select-field.php?select_field_id='.$ID.'\',\'\',\'width=450,height=200,top=100,left=100\'))">[Delete Field]</a></td><td><a href="delete-database-select-field-items.php?select_field_id='.$ID.'">[Delete Field Items]</a></td></tr>';
}
$all_text.='</table></td></tr></table><p>';
# get number fields
$all_text.='<table border=1 cellspacing=0 cellpadding=10 bgcolor="#ffffff" class="pastel"><tr><td>';
$all_text.='<strong>Number Fields</strong> <a href="add-database-number-field.php?category_id='.$category_id.'">[Add New]</a><br><br>';
$data=$base_instance->get_data("SELECT * FROM {$base_instance->entity['DATABASE']['NUMBER_FIELDS']} WHERE category_id='$category_id' AND user='$userid'");
$all_text.='<table border=1 cellspacing=0 cellpadding=2 bgcolor="#ffffff" class="pastel">';
for ($index=1; $index <= sizeof($data); $index++) {
$ID=$data[$index]->ID;
$title=$data[$index]->title;
$all_text.='<tr><td bgcolor="#dedede"><b>'.$title.'</b></td>
<td><a href="edit-database-number-field.php?number_field_id='.$ID.'">[Edit]</a></td>
<td><a href="javascript:void(window.open(\'delete-database-number-field.php?number_field_id='.$ID.'\',\'\',\'width=450,height=200,top=100,left=100\'))">[Delete]</a></td></tr>';
}
$all_text.='</table></td></tr></table><p>';
# get text fields
$all_text.='<table border=1 cellspacing=0 cellpadding=10 bgcolor="#ffffff" class="pastel"><tr><td>';
$all_text.='<strong>Text Fields</strong> <a href="add-database-text-field.php?category_id='.$category_id.'">[Add New]</a><br><br>';
$data=$base_instance->get_data("SELECT * FROM {$base_instance->entity['DATABASE']['TEXT_FIELDS']} WHERE category_id='$category_id' AND user='$userid'");
$all_text.='<table border=1 cellspacing=0 cellpadding=2 bgcolor="#ffffff" class="pastel">';
for ($index=1; $index <= sizeof($data); $index++) {
$ID=$data[$index]->ID;
$title=$data[$index]->title;
$all_text.='<tr><td bgcolor="#dedede"><b>'.$title.'</b></td>
<td><a href="edit-database-text-field.php?text_field_id='.$ID.'">[Edit]</a></td>
<td><a href="javascript:void(window.open(\'delete-database-text-field.php?text_field_id='.$ID.'\',\'\',\'width=450,height=200,top=100,left=100\'))">[Delete]</a></td></tr>';
}
$all_text.='</table></td></tr></table><p>';
$html_instance->add_parameter(
array(
'HEADER'=>'Edit Fields',
'TEXT_CENTER'=>"$all_text",
'BACK'=>1
));
$html_instance->process();
?>