/
qa-eql-admin.php
149 lines (128 loc) · 5.5 KB
/
qa-eql-admin.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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<?php
/*
Question2Answer (c) Gideon Greenspan
http://www.question2answer.org/
Expandable Question Lists Plugin by Bruno Vandekerkhove © 2015
*/
class qa_eql_admin {
// Default admin options
function option_default($option) {
switch($option) {
case 'qa_eql_enabled':
case 'qa_eql_homepage':
case 'qa_eql_button':
case 'qa_eql_bcomments':
case 'qa_eql_bedits':
case 'qa_homepage_separate':
return false;
case 'qa_eql_include':
case 'qa_eql_banswers':
return true;
case 'qa_homepage_url':
return 'home';
default:
return null;
}
}
// Initialise queries
function init_queries( $tableslc ) {
$tbl1 = qa_db_add_table_prefix('homepage');
if ( in_array($tbl1, $tableslc)) {
return null;
}
return "CREATE TABLE IF NOT EXISTS ^homepage (
`questionid` int(10) unsigned NOT NULL,
`childid` int(10) unsigned,
`updated` datetime NOT NULL,
PRIMARY KEY (questionid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8";
}
// Allow template
function allow_template($template) {
return ($template!='admin');
}
// Create admin form
function admin_form(&$qa_content) {
// Prepare errors
$pagelength_error = '';
// Process form input
$ok = null;
if (qa_clicked('qa_eql_save')) {
// Save options
qa_opt('qa_eql_enabled',(bool)qa_post_text('qa_eql_enabled'));
qa_opt('qa_eql_homepage',(bool)qa_post_text('qa_eql_homepage'));
qa_opt('qa_eql_button',(bool)qa_post_text('qa_eql_button'));
qa_opt('qa_eql_include',(bool)qa_post_text('qa_eql_include'));
qa_opt('qa_homepage_url',qa_post_text('qa_homepage_url'));
qa_opt('qa_homepage_separate',(bool)qa_post_text('qa_homepage_separate'));
$ok = qa_lang('admin/options_saved');
}
else if (qa_clicked('qa_eql_reset')) {
// Reset options
qa_opt('qa_eql_enabled',$this->option_default('qa_eql_enabled'));
qa_opt('qa_eql_homepage',$this->option_default('qa_eql_homepage'));
qa_opt('qa_eql_button',$this->option_default('qa_eql_button'));
qa_opt('qa_eql_include',$this->option_default('qa_eql_include'));
qa_opt('qa_homepage_url',$this->option_default('qa_homepage_url'));
qa_opt('qa_homepage_separate',$this->option_default('qa_homepage_separate'));
$ok = qa_lang('admin/options_reset');
}
// Sync database (if admin wants so or if it is appropriate given the new settings)
if (qa_clicked('qa_eql_calchomepage')) {
$this->sync();
$ok = 'Database sync\'d!';
}
// Create the form for display
$fields = array();
$fields[] = array( 'label' => 'Make question links expandable','tags' => 'name="qa_eql_enabled" onchange="if (this.checked) $(\'.eql-checks\').show();else $(\'.eql-checks\').hide();"',
'value' => qa_opt('qa_eql_enabled'),'type' => 'checkbox',);
$fields[] = array( 'type' => 'custom',
'label' => '<span class="qa-form-tall-label eql-checks"'.(qa_opt('qa_eql_enabled') ? '' : ' style="display:none;"').'>
<h3>Additional options</h3>
<label><input name="qa_eql_include" type="checkbox" class="qa-form-tall-checkbox"'.(qa_opt('qa_eql_include') ? ' checked=""' : '').'>Include jquery.ias.min.js</label>
<small>(Uncheck this if you already use Infinite AJAX Scroll on this website).</small>
<br><br><br>
<label><input name="qa_eql_homepage" type="checkbox" onchange="if (this.checked) $(\'.eql-hchecks\').show();else $(\'.eql-hchecks\').hide();"
class="qa-form-tall-checkbox"'.(qa_opt('qa_eql_homepage') ? ' checked=""' : '').'>Make the homepage expandable too</label>
<br><br>
<span class="qa-form-tall-label eql-hchecks"'.(qa_opt('qa_eql_enabled') && qa_opt('qa_eql_homepage') ? '' : ' style="display:none;"').'>
<h3>Homepage options</h3>
<small>Use the button below to keep the homepage in sync (this may take a while on large fora).
If this is the first time you make the homepage expandable, you\'ll have to sync first.</small><br><br>
<label><input name="qa_homepage_separate" type="checkbox" class="qa-form-tall-checkbox"'.(qa_opt('qa_homepage_separate') ? ' checked=""' : '').'>Use a custom homepage</label>
<br><br>
Custom homepage URL : <input name="qa_homepage_url" type="text" class="qa-form-tall-text" value="'.qa_opt('qa_homepage_url').'" onclick="this.select();">
</span>
</span>',);
return array(
'ok' => ($ok && !isset($error)) ? $ok : null,
'fields' => $fields,
'buttons' => array(
array('label' => 'Save', 'tags' => 'NAME="qa_eql_save"',),
array('label' => 'Sync homepage', 'tags' => 'NAME="qa_eql_calchomepage"',),
array('label' => 'Reset', 'tags' => 'NAME="qa_eql_reset"',),
),
);
}
// Calculate the homepage by adding all relevant posts to the ^homepage table
function sync() {
qa_db_query_sub('REPLACE INTO ^homepage SELECT postid, NULL, created FROM ^posts WHERE type = "Q"'); // First log all the questions
$query = ' SELECT
question.postid,
Answers.postid AS answerid,
Answers.date AS answerid
FROM ^posts question
INNER JOIN
(
SELECT
parentid,
postid,
MAX(created) AS date
FROM ^posts
WHERE `type` = "A"
GROUP BY postid
) AS Answers ON Answers.parentid = question.postid
WHERE question.type = "Q"';
qa_db_query_sub('REPLACE INTO ^homepage '.$query); // Now the answers (more queries are necessary if you want to include comments, too)
}
}