function umc_create_contest()
{
if (!umc_is_admin()) {
die("You don't have permission to do that.");
}
$voting_categories = "Looks|Realism|Fun|Usability|Innovation";
$post_vals = array($title, $desc, $max_entries, $deadline, $type, $x, $y, $z);
foreach ($post_vals as $val) {
${$val} = $val;
}
echo "Creating contest entry...<br>";
global $prefix;
$sql = "INSERT INTO " . $prefix . "contests (title, description, max_entries, voting_categories, deadline, status, type, x, y, z)\r\n\t\tVALUES ('{$title}', '{$desc}', '{$max_entries}', '{$voting_categories}', '{$deadline}', 'active', '{$type}', {$x}, {$y}, {$z})";
mysql_select_db('minecraft_srvr');
$rst = mysql_query($sql);
if (!$rst) {
echo mysql_error();
echo "<br>" . $sql;
var_dump($_POST);
} else {
echo "Contest entry inserted!";
return mysql_insert_id();
}
}
function umc_get_formatted_entries($contest_id = false, $new_entry_id = 0)
{
$id = intval($contest_id);
global $prefix, $UMC_DOMAIN;
if (isset($_GET['type'])) {
$id = intval($_GET['type']);
}
// get contest title
$sql = "SELECT * FROM " . $prefix . "contests WHERE id={$id};";
mysql_select_db('minecraft_srvr');
$rst = mysql_query($sql);
$row = mysql_fetch_array($rst, MYSQL_ASSOC);
$pre_title = 'Survival: ';
if ($row['type'] == 'creative') {
$pre_title = 'Creative: ';
}
$ret = '<div class="contest"><div class="contest_title">' . $pre_title . $row['title'] . '</div>';
$deadline_text = "";
if ($row['deadline'] != "" && $row['deadline'] != '0000-00-00' && $row['status'] == 'active') {
$deadline_text = "<strong>Deadline:</strong> {$row['deadline']}";
}
$ret .= '<hr>' . stripslashes($row['description']) . "<hr><strong>ID:</strong>" . $row['id'] . " {$deadline_text} <strong>Width:</strong>" . $row['x'] . ' <strong>Length:</strong>' . $row['z'] . ' <strong>Height:</strong>' . $row['y'] . '</div>';
// all entries
$sql = "SELECT * FROM " . $prefix . "entries WHERE contest='" . $id . "'";
$rst = mysql_query($sql);
if (mysql_num_rows($rst) > 0) {
$ret .= '<div id="entries_header" class="header">Entries:</div>';
} else {
$ret .= '<div id="entries_header" class="header">This contest has no entries.</div>';
}
while ($row = mysql_fetch_array($rst, MYSQL_ASSOC)) {
$admin_html = '<div class="opts">' . '<a href="?action=delete_entry&contest=' . $id . '&id=' . $row['id'] . '" class="delete_entry">Delete</a>' . '</div>';
if ($row['id'] == intval($new_entry_id)) {
$ret .= '<div class="contest_entry new_entry">';
} else {
$ret .= '<div class="contest_entry">';
}
$icon_url = umc_user_get_icon_url($row['user']);
$ret .= '<div class="entry_title"><a href="?action=show_entry&type=' . $row['id'] . '">' . stripslashes($row['title']) . '</a></div><div class="creator">by <img width=\\"16\\" src="' . $icon_url . '"/> <strong>' . $row['user'] . '</strong> (' . umc_get_userlevel($row['user']) . ')</div>' . umc_get_stars($row['id'], umc_get_votes_info($row['id']), "all");
if (umc_is_admin() || umc_i_am($row->user)) {
$ret .= $admin_html;
}
$ret .= '</div>';
}
//create new contest entry
// find entry by user
$user_arr = umc_is_online();
if ($user_arr['online'] == false) {
$ret .= "To enter your contest entry, please <a href=\"{$UMC_DOMAIN}/wp-admin/profile.php\">logged in</a>!";
return $ret;
}
$username = $user_arr['username'];
$lower_username = strtolower($username);
mysql_select_db('minecraft_worldguard');
// find out if the user can have additional contest entries in this contest
$sql = "SELECT * FROM world LEFT JOIN region ON world.id=region.world_id\n LEFT JOIN region_cuboid ON region.id=region_cuboid.region_id\n LEFT JOIN region_players ON region_cuboid.region_id=region_players.region_id\n LEFT JOIN user ON region_players.user_id=user.id\n WHERE region.id LIKE 'con_{$id}%' AND Owner=1 AND user.name = '{$lower_username}'\n ORDER BY max_z, max_x";
$rst = mysql_query($sql);
$count = mysql_num_rows($rst);
if ($count == 0) {
$ret .= "To create a contest entry, please type <strong>/contest</strong> in-game!";
return $ret;
}
$entries = array();
while ($row = mysql_fetch_array($rst, MYSQL_ASSOC)) {
$entries[] = $row['region_id'];
}
mysql_select_db('minecraft_srvr');
foreach ($entries as $entry) {
$sql = "SELECT * FROM contest_entries WHERE contest = {$id} AND user = '******' AND lot='{$entry}';";
// echo $sql;
$rst = mysql_query($sql);
$count = mysql_num_rows($rst);
if ($count == 1) {
// entry was already submitted
} else {
// entry has to be submitted still
$entry_html .= "<div id=\"new_entry_form\">Submit your entry from lot {$entry}: " . '<form method="post">' . '<input type="hidden" name="contest" id="contest_id" value="' . $id . '">' . '<input type="hidden" name="lot" id="lot" value="' . $entry . '">' . '<input type="text" name="title" id="new_entry_title" placeholder="Title" /><br />' . '<textarea id="new_entry_desc" name="desc" placeholder="Description"></textarea><br />' . '<input type="hidden" name="action" value="enter_contest">' . '<hr/><input type="submit" id="enter_contest" value="Enter Contest" >' . '</form>' . '</div>';
}
}
//if(umc_can_enter($id)) {
$ret .= $entry_html;
//}
return $ret;
// ."<br />can enter: ".umc_can_enter($id)." id: ".$id;
}
