Reply to thread

Message

<blockquote data-quote="Sly" data-source="post: 388942" data-attributes="member: 72035">Sorry for my late reply, I just woke-up. Heres my complete submit.php doc, I dont understand what am I doing wrong here with the reCaptcha?[PHP]&lt;?phpUser::check_permission(0);include 'core/functions/recaptchalib.php';include 'core/classes/Query.php';$address =&nbsp; $name = $country_code = $youtube_link = $website = $description = null;$connection_port = $query_port = 25565;if(!empty($_POST)) {&nbsp; &nbsp; /* Define some variables */&nbsp; &nbsp; $address = filter_var($_POST['address'], FILTER_SANITIZE_STRING);&nbsp; &nbsp; $connection_port = (int) $_POST['connection_port'];&nbsp; &nbsp; $query_port = (int) $_POST['query_port'];&nbsp; &nbsp; $date = new DateTime();&nbsp; &nbsp; $date = $date-&gt;format('Y-m-d H:i:s');&nbsp; &nbsp; $active = $status = '1';&nbsp; &nbsp; $private = ($settings-&gt;new_servers_visibility) ? '0' : '1';&nbsp; &nbsp; $name = filter_var($_POST['name'], FILTER_SANITIZE_STRING);&nbsp; &nbsp; $image = (empty($_FILES['image']['name']) == false) ? true : false;&nbsp; &nbsp; $country_code = (country_check(0, $_POST['country_code'])) ? $_POST['country_code'] : 'US';&nbsp; &nbsp; $youtube_link = filter_var($_POST['youtube_id'], FILTER_SANITIZE_STRING);&nbsp; &nbsp; $youtube_id = youtube_url_to_id($youtube_link);&nbsp; &nbsp; $website = filter_var($_POST['website'], FILTER_VALIDATE_URL);&nbsp; &nbsp; $description = filter_var($_POST['description'], FILTER_SANITIZE_STRING);&nbsp; &nbsp; &nbsp; &nbsp; $captcha = recaptcha_check_answer ($settings-&gt;private_key, $_SERVER[&quot;REMOTE_ADDR&quot;], $_POST[&quot;recaptcha_challenge_field&quot;], $_POST[&quot;recaptcha_response_field&quot;]);&nbsp; &nbsp; $allowed_extensions = array('jpg', 'jpeg', 'gif');&nbsp; &nbsp; $required_fields = array('address', 'connection_port', 'query_port', 'category_id');&nbsp; &nbsp; /* Get category data */&nbsp; &nbsp; $category = new StdClass;&nbsp; &nbsp; $stmt = $database-&gt;prepare(&quot;SELECT `category_id`, `name`, `url` FROM `categories` WHERE `category_id` = ?&quot;);&nbsp; &nbsp; $stmt-&gt;bind_param('s', $_POST['category_id']);&nbsp; &nbsp; $stmt-&gt;execute();&nbsp; &nbsp; bind_object($stmt, $category);&nbsp; &nbsp; $stmt-&gt;fetch();&nbsp; &nbsp; $stmt-&gt;close();&nbsp; &nbsp; &nbsp; &nbsp; /* Determine if category exists */&nbsp; &nbsp; if($category !== NULL) {&nbsp; &nbsp; &nbsp; &nbsp; $category-&gt;exists = true;&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; $category = new StdClass;&nbsp; &nbsp; &nbsp; &nbsp; $category-&gt;exists = false;&nbsp; &nbsp; }&nbsp; &nbsp; /* If the category doesn't exist, set an error message.If it exists, continue with the checks */&nbsp; &nbsp; if(!$category-&gt;exists) {&nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['category_not_found'];&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; /* Query the server with a specific protocol */&nbsp; &nbsp; &nbsp; &nbsp; $query = new Query($address, $query_port);&nbsp; &nbsp; &nbsp; &nbsp; $info&nbsp; = $query-&gt;query();&nbsp; &nbsp; &nbsp; &nbsp; if(!$info &amp;&amp; $query-&gt;status) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['server_no_data'];&nbsp; &nbsp; &nbsp; &nbsp; } else&nbsp; &nbsp; &nbsp; &nbsp; if(!$info &amp;&amp; !$query-&gt;status) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['server_offline'];&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; /* Check for the required fields */&nbsp; &nbsp; foreach($_POST as $key=&gt;$value) {&nbsp; &nbsp; &nbsp; &nbsp; if(empty($value) &amp;&amp; in_array($key, $required_fields) == true) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['marked_fields_empty'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break 1;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; /* Check for banner image errors */&nbsp; &nbsp; if($image == true) {&nbsp; &nbsp; &nbsp; &nbsp; $image_file_name&nbsp; &nbsp; &nbsp; &nbsp; = $_FILES['image']['name'];&nbsp; &nbsp; &nbsp; &nbsp; $image_file_extension&nbsp; &nbsp; = explode('.', $image_file_name);&nbsp; &nbsp; &nbsp; &nbsp; $image_file_extension&nbsp; &nbsp; = strtolower(end($image_file_extension));&nbsp; &nbsp; &nbsp; &nbsp; $image_file_temp&nbsp; &nbsp; &nbsp; &nbsp; = $_FILES['image']['tmp_name'];&nbsp; &nbsp; &nbsp; &nbsp; $image_file_size&nbsp; &nbsp; &nbsp; &nbsp; = $_FILES['image']['size'];&nbsp; &nbsp; &nbsp; &nbsp; list($image_width, $image_height)&nbsp; &nbsp; = getimagesize($image_file_temp);&nbsp; &nbsp; &nbsp; &nbsp; if(in_array($image_file_extension, $allowed_extensions) !== true) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['incorrect_file_type'];&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; if($image_file_size &gt; $settings-&gt;cover_max_size) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = sprintf($language['errors']['image_size'], formatBytes($settings-&gt;cover_max_size));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; /* More checks */&nbsp; &nbsp; if(!$captcha-&gt;is_valid) {&nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['captcha_not_valid'];&nbsp; &nbsp; }&nbsp; &nbsp; if(strlen($name) &gt; 64 || strlen($name) &lt; 3) {&nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['server_name_length'];&nbsp; &nbsp; }&nbsp; &nbsp; if(strlen($description) &gt; 2560) {&nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['description_too_long'];&nbsp; &nbsp; }&nbsp; &nbsp; $server = new Server($address, $connection_port);&nbsp; &nbsp; if($server-&gt;exists) {&nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['error'][] = $language['errors']['server_already_exists'];&nbsp; &nbsp; }&nbsp; &nbsp; /* If there are no errors, add the server to the database */&nbsp; &nbsp; if(empty($_SESSION['error'])) {&nbsp; &nbsp; &nbsp; &nbsp; /* Banner process */&nbsp; &nbsp; &nbsp; &nbsp; if($image == true) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /* Generate new name for image */&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $image_new_name = md5(time().rand()) . '.' . $image_file_extension;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /* Resize if needed &amp; upload the image */&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($image_width != '468' || $image_height != '60') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; resize($image_file_temp, 'user_data/server_banners/' . $image_new_name, '468', '60');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; move_uploaded_file($image_file_temp, 'user_data/server_banners/' . $image_new_name);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; $image_name = ($image == true) ? $image_new_name : '';&nbsp; &nbsp; &nbsp; &nbsp; /* Add the server to the database as private */&nbsp; &nbsp; &nbsp; &nbsp; $stmt = $database-&gt;prepare(&quot;INSERT INTO `servers` (`user_id`, `category_id`, `address`, `connection_port`, `query_port`, `private`, `active`, `status`, `date_added`, `image`, `name`, `country_code`, `youtube_id`, `website`, `description`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $stmt-&gt;bind_param('sssssssssssssss',&nbsp; $account_user_id, $category-&gt;category_id, $address, $connection_port, $query_port, $private, $active, $status, $date, $image_name, $name, $country_code, $youtube_id, $website, $description);&nbsp; &nbsp; &nbsp; &nbsp; $test = $stmt-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; $stmt-&gt;close();&nbsp; &nbsp; &nbsp; &nbsp; /* Set the success message and redirect */&nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['success'][] = $language['messages']['server_added'];&nbsp; &nbsp; &nbsp; &nbsp; redirect('my-servers');&nbsp; &nbsp; }display_notifications();}initiate_html_columns();?&gt;&lt;h3&gt;&lt;?php echo $language['headers']['submit']; ?&gt;&lt;/h3&gt;&lt;form action=&quot;&quot; method=&quot;post&quot; role=&quot;form&quot; enctype=&quot;multipart/form-data&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_address']; ?&gt; *&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;address&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $address; ?&gt;&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_connection_port']; ?&gt; *&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;help-block&quot;&gt;&lt;?php echo $language['forms']['server_connection_port_help']; ?&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;connection_port&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $connection_port; ?&gt;&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_query_port']; ?&gt; *&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;help-block&quot;&gt;&lt;?php echo $language['forms']['server_query_port_help']; ?&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;query_port&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $query_port; ?&gt;&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_category']; ?&gt; *&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;select name=&quot;category_id&quot; class=&quot;form-control&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result = $database-&gt;query(&quot;SELECT `category_id`, `name` FROM `categories` WHERE `parent_id` = '0'&nbsp; ORDER BY `name` ASC&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($category = $result-&gt;fetch_object()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;option value=&quot;' . $category-&gt;category_id . '&quot;&gt;' . $category-&gt;name . '&lt;/option&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $subcategory_result = $database-&gt;query(&quot;SELECT `category_id`, `name` FROM `categories` WHERE `parent_id` = {$category-&gt;category_id} ORDER BY `name` ASC&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($subcategory = $subcategory_result-&gt;fetch_object()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;option value=&quot;' . $subcategory-&gt;category_id . '&quot;&gt;--' . $subcategory-&gt;name . '&lt;/option&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;hr /&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_banner']; ?&gt;&lt;/label&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;help-block&quot;&gt;&lt;?php echo $language['forms']['server_banner_help']; ?&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;file&quot; name=&quot;image&quot; class=&quot;form-control&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_name']; ?&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;name&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $name; ?&gt;&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_country']; ?&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;select name=&quot;country_code&quot; class=&quot;form-control&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php country_check(1, $country_code); ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_youtube_id']; ?&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;help-block&quot;&gt;&lt;?php echo $language['forms']['server_youtube_id_help']; ?&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;youtube_id&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $youtube_link; ?&gt;&quot; /&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_website']; ?&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;website&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $website; ?&gt;&quot;/&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;&lt;?php echo $language['forms']['server_description']; ?&gt;&lt;/label&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;help-block&quot;&gt;&lt;?php echo $language['forms']['server_description_help']; ?&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;textarea name=&quot;description&quot; class=&quot;form-control&quot; rows=&quot;6&quot;&gt;&lt;?php echo $description; ?&gt;&lt;/textarea&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php echo recaptcha_get_html($settings-&gt;public_key); ?&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;form-group&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;button type=&quot;submit&quot; name=&quot;submit&quot; class=&quot;btn btn-default col-lg-4&quot;&gt;&lt;?php echo $language['forms']['submit']; ?&gt;&lt;/button&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/form&gt;[/PHP]</blockquote>

[QUOTE="Sly, post: 388942, member: 72035"] Sorry for my late reply, I just woke-up. Heres my complete submit.php doc, I dont understand what am I doing wrong here with the reCaptcha? [PHP]<?php User::check_permission(0); include 'core/functions/recaptchalib.php'; include 'core/classes/Query.php'; $address = $name = $country_code = $youtube_link = $website = $description = null; $connection_port = $query_port = 25565; if(!empty($_POST)) { /* Define some variables */ $address = filter_var($_POST['address'], FILTER_SANITIZE_STRING); $connection_port = (int) $_POST['connection_port']; $query_port = (int) $_POST['query_port']; $date = new DateTime(); $date = $date->format('Y-m-d H:i:s'); $active = $status = '1'; $private = ($settings->new_servers_visibility) ? '0' : '1'; $name = filter_var($_POST['name'], FILTER_SANITIZE_STRING); $image = (empty($_FILES['image']['name']) == false) ? true : false; $country_code = (country_check(0, $_POST['country_code'])) ? $_POST['country_code'] : 'US'; $youtube_link = filter_var($_POST['youtube_id'], FILTER_SANITIZE_STRING); $youtube_id = youtube_url_to_id($youtube_link); $website = filter_var($_POST['website'], FILTER_VALIDATE_URL); $description = filter_var($_POST['description'], FILTER_SANITIZE_STRING); $captcha = recaptcha_check_answer ($settings->private_key, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); $allowed_extensions = array('jpg', 'jpeg', 'gif'); $required_fields = array('address', 'connection_port', 'query_port', 'category_id'); /* Get category data */ $category = new StdClass; $stmt = $database->prepare("SELECT `category_id`, `name`, `url` FROM `categories` WHERE `category_id` = ?"); $stmt->bind_param('s', $_POST['category_id']); $stmt->execute(); bind_object($stmt, $category); $stmt->fetch(); $stmt->close(); /* Determine if category exists */ if($category !== NULL) { $category->exists = true; } else { $category = new StdClass; $category->exists = false; } /* If the category doesn't exist, set an error message.If it exists, continue with the checks */ if(!$category->exists) { $_SESSION['error'][] = $language['errors']['category_not_found']; } else { /* Query the server with a specific protocol */ $query = new Query($address, $query_port); $info = $query->query(); if(!$info && $query->status) { $_SESSION['error'][] = $language['errors']['server_no_data']; } else if(!$info && !$query->status) { $_SESSION['error'][] = $language['errors']['server_offline']; } } /* Check for the required fields */ foreach($_POST as $key=>$value) { if(empty($value) && in_array($key, $required_fields) == true) { $_SESSION['error'][] = $language['errors']['marked_fields_empty']; break 1; } } /* Check for banner image errors */ if($image == true) { $image_file_name = $_FILES['image']['name']; $image_file_extension = explode('.', $image_file_name); $image_file_extension = strtolower(end($image_file_extension)); $image_file_temp = $_FILES['image']['tmp_name']; $image_file_size = $_FILES['image']['size']; list($image_width, $image_height) = getimagesize($image_file_temp); if(in_array($image_file_extension, $allowed_extensions) !== true) { $_SESSION['error'][] = $language['errors']['incorrect_file_type']; } if($image_file_size > $settings->cover_max_size) { $_SESSION['error'][] = sprintf($language['errors']['image_size'], formatBytes($settings->cover_max_size)); } } /* More checks */ if(!$captcha->is_valid) { $_SESSION['error'][] = $language['errors']['captcha_not_valid']; } if(strlen($name) > 64 || strlen($name) < 3) { $_SESSION['error'][] = $language['errors']['server_name_length']; } if(strlen($description) > 2560) { $_SESSION['error'][] = $language['errors']['description_too_long']; } $server = new Server($address, $connection_port); if($server->exists) { $_SESSION['error'][] = $language['errors']['server_already_exists']; } /* If there are no errors, add the server to the database */ if(empty($_SESSION['error'])) { /* Banner process */ if($image == true) { /* Generate new name for image */ $image_new_name = md5(time().rand()) . '.' . $image_file_extension; /* Resize if needed & upload the image */ if($image_width != '468' || $image_height != '60') { resize($image_file_temp, 'user_data/server_banners/' . $image_new_name, '468', '60'); } else { move_uploaded_file($image_file_temp, 'user_data/server_banners/' . $image_new_name); } } $image_name = ($image == true) ? $image_new_name : ''; /* Add the server to the database as private */ $stmt = $database->prepare("INSERT INTO `servers` (`user_id`, `category_id`, `address`, `connection_port`, `query_port`, `private`, `active`, `status`, `date_added`, `image`, `name`, `country_code`, `youtube_id`, `website`, `description`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param('sssssssssssssss', $account_user_id, $category->category_id, $address, $connection_port, $query_port, $private, $active, $status, $date, $image_name, $name, $country_code, $youtube_id, $website, $description); $test = $stmt->execute(); $stmt->close(); /* Set the success message and redirect */ $_SESSION['success'][] = $language['messages']['server_added']; redirect('my-servers'); } display_notifications(); } initiate_html_columns(); ?> <h3><?php echo $language['headers']['submit']; ?></h3> <form action="" method="post" role="form" enctype="multipart/form-data"> <div class="form-group"> <label><?php echo $language['forms']['server_address']; ?> *</label> <input type="text" name="address" class="form-control" value="<?php echo $address; ?>" /> </div> <div class="form-group"> <label><?php echo $language['forms']['server_connection_port']; ?> *</label> <?php echo $language['forms']['server_connection_port_help']; ?> <input type="text" name="connection_port" class="form-control" value="<?php echo $connection_port; ?>" /> </div> <div class="form-group"> <label><?php echo $language['forms']['server_query_port']; ?> *</label> <?php echo $language['forms']['server_query_port_help']; ?> <input type="text" name="query_port" class="form-control" value="<?php echo $query_port; ?>" /> </div> <div class="form-group"> <label><?php echo $language['forms']['server_category']; ?> *</label> <select name="category_id" class="form-control"> <?php $result = $database->query("SELECT `category_id`, `name` FROM `categories` WHERE `parent_id` = '0' ORDER BY `name` ASC"); while($category = $result->fetch_object()) { echo '<option value="' . $category->category_id . '">' . $category->name . '</option>'; $subcategory_result = $database->query("SELECT `category_id`, `name` FROM `categories` WHERE `parent_id` = {$category->category_id} ORDER BY `name` ASC"); while($subcategory = $subcategory_result->fetch_object()) { echo '<option value="' . $subcategory->category_id . '">--' . $subcategory->name . '</option>'; } } ?> </select> </div> <hr /> <div class="form-group"> <label><?php echo $language['forms']['server_banner']; ?></label> <?php echo $language['forms']['server_banner_help']; ?> <input type="file" name="image" class="form-control" /> </div> <div class="form-group"> <label><?php echo $language['forms']['server_name']; ?></label> <input type="text" name="name" class="form-control" value="<?php echo $name; ?>" /> </div> <div class="form-group"> <label><?php echo $language['forms']['server_country']; ?></label> <select name="country_code" class="form-control"> <?php country_check(1, $country_code); ?> </select> </div> <div class="form-group"> <label><?php echo $language['forms']['server_youtube_id']; ?></label> <?php echo $language['forms']['server_youtube_id_help']; ?> <input type="text" name="youtube_id" class="form-control" value="<?php echo $youtube_link; ?>" /> </div> <div class="form-group"> <label><?php echo $language['forms']['server_website']; ?></label> <input type="text" name="website" class="form-control" value="<?php echo $website; ?>"/> </div> <div class="form-group"> <label><?php echo $language['forms']['server_description']; ?></label> <?php echo $language['forms']['server_description_help']; ?> <textarea name="description" class="form-control" rows="6"><?php echo $description; ?></textarea> </div> <div class="form-group"> <?php echo recaptcha_get_html($settings->public_key); ?> </div> <div class="form-group"> <button type="submit" name="submit" class="btn btn-default col-lg-4"><?php echo $language['forms']['submit']; ?></button> </div> </form>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members