rendered paste body<?php
/* Here we will create all the tables and rows needed for this
// website to function. now time to declare some of our main
// settings for the installer to function properly */
function marina_initialize()
{
global $wpdb;
$marinatable = $wpdb->prefix."marinas";
$marinatable2 = $wpdb->prefix."marinas_extras";
$marinatable3 = $wpdb->prefix."marinas_users";
if($wpdb->get_var("show tables like '$marinatable'") != $marinatable) {
// Check to see if this table already exists, if it doesn't then proceed.
$sqllayout = "CREATE TABLE $marinatable (
id INT(9) NOT NULL AUTO_INCREMENT,
marina_title VARCHAR(80),
marina_location VARCHAR(80),
marina_web VARCHAR(80),
marina_email VARCHAR(80),
marina_phone VARCHAR(80),
marina_address VARCHAR(80),
marina_openingtime VARCHAR(80),
marina_minidesc text(15),
marina_seats INT(9) DEFUALT 0,
marina_description text(800),
pageid INT(9) DEFAULT 0,
lat FLOAT(9) DEFAULT 0,
lon FLOAT(9) DEFAULT 0,
UNIQUE KEY id (id)
);";
$wpdb->query($sqllayout);
}
if($wpdb->get_var("show tables like '$marinatable2'") != $marinatable2) {
$sqllayout = "CREATE TABLE $marinatable2 (
id INT(9) NOT NULL AUTO_INCREMENT,
marina_accommodation tinyint(1),
marina_dining tinyint(1),
marina_shop tinyint(1),
marina_pump tinyint(1),
marina_medical tinyint(1),
marina_police tinyint(1),
marina_shipping tinyint(1),
marina_monuments tinyint(1),
marina_customs tinyint(1),
marina_shiptransport tinyint(1),
marina_service tinyint(1),
marina_crane tinyint(1),
marina_office_openinghours VARCHAR(13),
marina_office_description text(150),
marina_shop_openinghours VARCHAR(13),
marina_shop_description text(150),
marina_restraunt_openinghours VARCHAR(13),
marina_restraunt_description text(150),
marina_doctor_openinghours VARCHAR(13),
marina_doctor_description text(150),
marina_petrol_station_openinghours VARCHAR(13),
marina_petrol_station_description text(150),
marina_yacht_service_openinghours VARCHAR(13),
marina_yacht_service_description text(150),
marina_customs_openinghours VARCHAR(13),
marina_customs_description text(150),
marina_accommodation_description text(150),
marina_Sightseeing_description text(150),
UNIQUE KEY id (id)
);";
$wpdb->query($sqllayout);
}
if($wpdb->get_var("show tables like '$marinatable3'") != $marinatable3) {
$sqllayout = "CREATE TABLE $marinatable3 (
id INT(9) NOT NULL AUTO_INCREMENT,
userid INT(9) DEFAULT 0,
marina INT(9) DEFAULT 0,
UNIQUE KEY id (id)
);";
$wpdb->query($sqllayout);
}
$wpdb->query("INSERT INTO ".$wpdb->prefix."marinas (marina_title, marina_location, marina_web, marina_email, marina_phone, marina_address, marina_openingtime, marina_minidesc, marina_description, pageid, lat, lon) VALUES ('A title', 'Location', 'hi', 'email@fake.email', '1(234)5678222', '12345 fake ave. Fakeland, USA', '8AM', 'hi', 'hey', 0, -34.397, 150.644)");
$wpdb->query("INSERT INTO ".$wpdb->prefix."marinas_users (userid, marina) VALUES (1,1)");
$wpdb->query("INSERT INTO ".$wpdb->prefix."marinas_extras (id) VALUES (1)");
}
function marina_admin_addmenu()
{
add_menu_page( "Marina Options", "Marina Options" , "manage_options", "marina_admin" , "marina_admin");
add_submenu_page( "marina_admin", "Add Marina", "Add Marina", "manage_options", "marina_admin_add", "marina_admin_add");
add_submenu_page( "marina_admin", "User Access", "User Access", "manage_options", "marina_admin_user", "marina_admin_user");
}
function marina_admin()
{
global $wpdb;
echo "<div class=\"wrap\"><h2>Marina Options</h2>";
echo "<div style=\"background:#DCDCDC;margin:10px;padding:10px;border-radius:10px;-moz-border-radius:10px;-webkit-border-radius:10px;\">Welcome to the Marina Options panel! Please select either \"Add Marina\" or \"User Access\" from the menu inside the sidebar to begin!</div>";
echo "</div>";
echo "<table class=\"wp-list-table widefat fixed\" cellspacing=\"0\"><thead><tr><th scope=\"col\" id=\"name\" class=\"manage-column column-name sortable desc\" style=\"width:200px;\"><a href=\"#\"><span>Name</span><span class=\"sorting-indicator\"></span></a></th><th scope=\"col\" id=\"url\" class=\"manage-column column-url sortable desc\" style=\"\"><a href=\"#\"><span>Description</span><span class=\"sorting-indicator\"></span></a></th><th scope=\"col\" id=\"categories\" class=\"manage-column column-categories\" style=\"width:50px;\">ID</th></tr></thead>
<tfoot><tr><th scope=\"col\" id=\"name\" class=\"manage-column column-name sortable desc\" style=\"\"><a href=\"#\"><span>Name</span><span class=\"sorting-indicator\"></span></a></th><th scope=\"col\" id=\"url\" class=\"manage-column column-url sortable desc\" style=\"\"><a href=\"#\"><span>Description</span><span class=\"sorting-indicator\"></span></a></th><th scope=\"col\" id=\"categories\" class=\"manage-column column-categories\" style=\"\">ID</th></tr></tfoot>
<tbody id=\"the-list\">";
$marinalistsql = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."marinas ORDER BY id ASC");
foreach($marinalistsql as $marinalist){
$id = $marinalist->id;
$id = $marinalist->marina_title;
echo "<tr valign=\"middle\"><th scope=\"col\" id=\"name\" class=\"manage-column column-name sortable desc\" style=\"padding-left:5px;width:200px;\"><span>".$marinalist->marina_title."</span></th><th scope=\"col\" id=\"url\" class=\"manage-column column-url sortable desc\" style=\"\"><span>".$marinalist->marina_minidesc."</span></th><th scope=\"col\" id=\"categories\" class=\"manage-column column-categories\" style=\"\">".$marinalist->id."</th></tr>";
}
echo "
</tbody>
</table>";
}
function marina_admin_add()
{
global $wpdb;
echo "<div class=\"wrap\"><h2>Add Marina</h2>";
echo "<form action=\"?page=marina_admin_add&post=1\" method=\"post\"><input type=\"submit\" value=\"Create new marina\"/></form>";
if ($_GET['post'] == 1) {
$wpdb->query("INSERT INTO ".$wpdb->prefix."marinas (marina_title) VALUES ('Marina Title')");
$wpdb->query("INSERT INTO ".$wpdb->prefix."marinas_extras (marina_dining) VALUES (0)");
echo "<h3>Created marina successfully, redirecting you to the \"User Access\" page. <meta http-equiv=\"REFRESH\" content=\"2;url=?page=marina_admin_add\">";
}
echo "</div>";
}
function marina_admin_user()
{
global $wpdb;
echo "<div class=\"wrap\"><h2>Modify User Access</h2>";
echo "<div style=\"background:#DCDCDC;margin:10px;padding:10px;border-radius:10px;-moz-border-radius:10px;-webkit-border-radius:10px;\">
<h2>Give user marina editing access</h2>
<h3 style=\"font-size:9pt;font-weight:normal;line-height:8px;\">Enter a user's ID and the marina ID and we'll give them access to the marina</h3>
<form action=\"?page=marina_admin_user&post=add\" method=\"post\">
<select name=\"userid\" style=\"border:1px solid #BBB;color:#464646;\"><option value=\"0\" SELECTED>User ID</option>";
$usersql = $wpdb->get_results("SELECT id FROM ".$wpdb->prefix."users");
foreach($usersql as $userids){
$id = $userids->id;
echo "<option value=\"$id\">$id</option>";
}
echo "
</select>
<select name=\"marinaid\" style=\"border:1px solid #BBB;color:#464646;\"><option value=\"0\" SELECTED>Marina ID</option>";
$marinasql = $wpdb->get_results("SELECT id FROM ".$wpdb->prefix."marinas");
foreach($marinasql as $marinaids){
$id = $marinaids->id;
echo "<option value=\"$id\">$id</option>";
}
echo "
</select><input type=\"submit\" value=\"Give user access\"/></form>
<hr />
<h2>Remove user's marina editing access</h2>
<h3 style=\"font-size:9pt;font-weight:normal;line-height:8px;\">Enter a user's ID and the marina ID and we'll wipe their access to the marina</h3>
<form action=\"?page=marina_admin_user&post=remove\" method=\"post\">
<select name=\"userid\" style=\"border:1px solid #BBB;color:#464646;\"><option value=\"0\" SELECTED>User ID</option>";
$usersql = $wpdb->get_results("SELECT id FROM ".$wpdb->prefix."users");
foreach($usersql as $userids){
$id = $userids->id;
echo "<option value=\"$id\">$id</option>";
}
echo "
</select>
<select name=\"marinaid\" style=\"border:1px solid #BBB;color:#464646;\"><option value=\"0\" SELECTED>Marina ID</option>";
$marinasql = $wpdb->get_results("SELECT id FROM ".$wpdb->prefix."marinas");
foreach($marinasql as $marinaids){
$id = $marinaids->id;
echo "<option value=\"$id\">$id</option>";
}
echo "
</select><input type=\"submit\" value=\"Remove user access\"/></form>
<hr />
<h2>How do they access a marina?</h2>
<h3 style=\"font-size:9pt;font-weight:normal;line-height:15px;\">All you have to do is make sure they have a pre existing Wordpress account, if not direct them to the register page. Once registered you can use their user ID on these forms to revoke and give them access.<br />Once they have access, all they'll have to do is visit the marina's page and click the \"Edit Marina\" link.</h3>
</div>";
echo "</div>";
if ($_GET['post'] == "add"){
if ($_POST['userid'] == "0"){exit();}
if ($_POST['marinaid'] == "0"){exit();}
$wpdb->query("INSERT INTO ".$wpdb->prefix."marinas_users (userid, marina) VALUES (".$_POST['userid'].",".$_POST['marinaid'].")");
echo "User Settings Added Successfully. Redirecting you.<meta http-equiv=\"REFRESH\" content=\"2;url=?page=marina_admin_user\">";
}
if ($_GET['post'] == "remove"){
if ($_POST['userid'] == "0"){exit();}
if ($_POST['marinaid'] == "0"){exit();}
$wpdb->query("DELETE FROM ".$wpdb->prefix."marinas_users WHERE userid='".$_POST['userid']."' AND marina='".$_POST['marinaid']."'");
echo "User Settings Removed Successfully. Redirecting you.<meta http-equiv=\"REFRESH\" content=\"2;url=?page=marina_admin_user\">";
}
}
function getMarinas() {
global $wpdb;
echo "<h2 class=\"subheading\">Severní Jadran</h2><ul class=\"marina\">";
$marinalistsql = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."marinas WHERE marina_location='North' ORDER BY id ASC");
foreach($marinalistsql as $marinalist){
$id = $marinalist->id;
$id = $marinalist->marina_title;
echo "<li><a href=\"editmarina.php?id=".$marinalist->id."\">".$marinalist->marina_title."</a></li>";
}
echo "</ul><h2 class=\"subheading\">Strední Jadran</h2><ul class=\"marina\">";
$marinalistsql = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."marinas WHERE marina_location='Central' ORDER BY id ASC");
foreach($marinalistsql as $marinalist){
$id = $marinalist->id;
$id = $marinalist->marina_title;
echo "<li><a href=\"editmarina.php?id=".$marinalist->id."\">".$marinalist->marina_title."</a></li>";
}
echo "</ul><h2 class=\"subheading\">Jižní Jadran</h2><ul class=\"marina\">";
$marinalistsql = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."marinas WHERE marina_location='South' ORDER BY id ASC");
foreach($marinalistsql as $marinalist){
$id = $marinalist->id;
$id = $marinalist->marina_title;
echo "<li><a href=\"editmarina.php?id=".$marinalist->id."\">".$marinalist->marina_title."</a></li>";
}
echo "</ul>";
}