function registerPybox($id, $slug, $type, $facultative, $title, $content, $args = NULL, $hash = NULL, $graderOptions = NULL)
{
if (is_array($args)) {
$args = json_encode($args);
}
global $wpdb, $lesson_reg_info;
if (isMakingDatabases()) {
if (!userIsAdmin()) {
echo "Error: must be admin to rebuild DB.";
return;
}
$curr_post = get_post($lesson_reg_info['id']);
$table_name = $wpdb->prefix . "pb_problems";
$row = array();
$row['postid'] = $lesson_reg_info['id'];
$row['lesson'] = $lesson_reg_info['index'];
$row['boxid'] = $id;
if ($slug != 'NULL') {
$row['slug'] = $slug;
}
$row['type'] = $type;
$row['facultative'] = $facultative;
$row['url'] = $lesson_reg_info['url'] . '#pybox' . $id;
$row['lang'] = $lesson_reg_info['lang'];
if ($title != NULL) {
if ($lesson_reg_info['index'] >= 0) {
$row['publicname'] = $lesson_reg_info["fullnumber"] . ': ' . $title;
} else {
$row['publicname'] = $title;
}
//e.g., for the console, which is not part of any lesson
}
if ($args != NULL) {
$row['shortcodeArgs'] = $args;
}
if ($hash != NULL) {
$row['hash'] = $hash;
}
if ($graderOptions != NULL) {
$row['graderArgs'] = $graderOptions;
}
$row['content'] = $content;
echo "<br>About to insert problem: " . rowSummary($row);
if (!$GLOBALS['SKIP_DB_REBUILD']) {
echo $wpdb->insert($table_name, $row) != 1 ? '<br>insert bad' : ' insert ok';
}
} else {
if ($hash != NULL) {
$lang = currLang2();
if ($wpdb->get_var("SELECT COUNT(1) from " . $wpdb->prefix . "pb_problems WHERE hash = '{$hash}' AND lang='" . $lang . "'") == 0) {
// hash is important, but not yet registered!
// typically this would occur if we're editing a problem and viewing it before rebuilding db
// if the hash doesn't exist, add it so the grader knows what do to with submissions
global $post;
$row = array('type' => $type, 'postid' => $post->ID, 'boxid' => $id, 'facultative' => $facultative, 'url' => get_page_link($post->ID) . '#pybox' . $id, 'shortcodeArgs' => $args, 'graderArgs' => $graderOptions, 'hash' => $hash, 'lang' => $lang);
if ($slug != 'NULL') {
$row['slug'] = $slug;
}
$wpdb->insert($wpdb->prefix . "pb_problems", $row);
}
}
}
}
function cscircles_makedb_page()
{
echo "<div class='wrap'>\n<h2>Rebuild CS Circles Databases</h2>\n<div>This page will rebuild the lesson database and the problem database. \n(If you're writing your own lessons, it assumes a structure like 99X-lessontitle\non the lesson slugs; contact us for help if needed.)</div>";
if (!array_key_exists('submitted', $_REQUEST)) {
echo "<form method='get' action='admin.php'>\n <input type='hidden' name='page' value='cscircles-makedb'>\n <input type='hidden' name='submitted' value='true'>\n <button class='button-primary' id='submit'>Rebuild Databases</button></form>";
} else {
$out = get_pages();
$lessons = array();
foreach ($out as $page) {
if ($page->post_status != 'publish') {
continue;
}
$s = $page->post_title;
$m = preg_match('/^([0-9]+)([A-Za-z]?)\\: (.*)$/', $s, $matches);
if (class_exists('PLL_Base')) {
global $polylang;
$lang = $polylang->get_post_language($page->ID);
if ($lang != NULL) {
$lang = $lang->slug;
} else {
$lang = substr(get_bloginfo("language"), 0, 2);
}
} else {
// use default language
$lang = currLang2();
}
if ($m >= 1) {
$lessons[] = array('number' => $matches[1] . $matches[2], 'title' => $matches[3], 'major' => $matches[1], 'minor' => $matches[2], 'id' => $page->ID, 'lang' => $lang);
} elseif (class_exists('PLL_Base') && get_page_by_path('console')->ID == pll_get_post($page->ID, 'en') || get_page_by_path('console')->ID == $page->ID) {
$lessons[] = array('id' => $page->ID, 'number' => NULL, 'lang' => $lang);
}
// go through the console page too, mainly to set up the right url in history grids,
// it does not get added to pb_lessons but its contents do get added to pb_problems
}
function cmp($l1, $l2)
{
$c = strcmp($l1['lang'], $l2['lang']);
if ($c != 0) {
if ($l1['lang'] == 'en') {
return -1;
}
// put english first
if ($l2['lang'] == 'en') {
return 1;
}
return $c;
}
if ($l1['number'] == NULL ^ $l2['number'] == NULL) {
return $l1['number'] == NULL ? 1 : -1;
}
$c = $l1['major'] - $l2['major'];
if ($c != 0) {
return $c;
}
return strcmp($l1['minor'], $l2['minor']);
}
usort($lessons, 'cmp');
pyboxlog('[makedb] Rebuilding problem and lesson db', TRUE);
global $wpdb, $SKIP_DB_REBUILD;
$SKIP_DB_REBUILD = false;
// set to true to be diagnostic
$lesson_table_name = $wpdb->prefix . "pb_lessons";
$problem_table_name = $wpdb->prefix . "pb_problems";
if (!$GLOBALS['SKIP_DB_REBUILD']) {
echo '<b>Truncating tables: ';
$wpdb->query("TRUNCATE TABLE {$problem_table_name};");
$wpdb->query("TRUNCATE TABLE {$lesson_table_name};");
echo 'done</b>';
}
$currlang = 'xx';
$i = -1;
$gets = array();
foreach ($lessons as $l) {
echo '<pre>';
if ($currlang != $l['lang']) {
$currlang = $l['lang'];
$i = 0;
}
if ($l['number'] == NULL) {
$index = -1;
} else {
$index = $i;
$i++;
}
$l['ordering'] = $index;
if ($l['number'] != NULL) {
echo 'About to insert lesson: ' . rowSummary($l);
//. json_encode($l);
if (!$GLOBALS['SKIP_DB_REBUILD']) {
echo $wpdb->insert($lesson_table_name, $l) != 1 ? '<br>insert bad' : ' insert ok';
}
}
global $lesson_reg_info, $pyRenderCount, $post;
$lesson_reg_info = array('index' => $index, 'lang' => $currlang, 'fullnumber' => $l['number'], 'url' => str_replace('/dev', '', get_page_link($l['id'])), 'id' => $l['id']);
// pyboxlog($currlang . ' ' . $lesson_reg_info['url'], FALSE); // was used Apr. 7 to help transl.
// render! the following line is not just cosmetic as it registers the problems.
echo '<br>Snippet: ' . htmlspecialchars(substr(do_sweetcode(get_page($l['id'])->post_content), 0, 50));
$pyRenderCount = 0;
// to get problem links working
echo '</pre>';
}
$lesson_reg_info = 1;
}
echo '</div>';
}