<?php


$servername = "localhost";
$username = "deniiynz_host";
$password = "aois9290s";
$dbname = "deniiynz_manual";
$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id, title, value, shlink, vlink FROM manualsurf_links";
$result = $conn->query($sql);

$sql5="SELECT * FROM manualsurf_links ORDER BY `credits`";
$records=mysql_query($sql5);

$res=mysql_query("SELECT * FROM manualsurf_setup");
$setupRow=mysql_fetch_array($res);

$title = $_POST['title'];
$value = $_POST['value'];
$shlink = $_POST['shlink'];
$vlink = $_POST['vlink'];
$credits = $_POST['credits'];
$show = '<h2>he</h2>';
$bow1 = '<form method="post">
<div class="info_box">Manual Surf is installed in your website, if you do not want continue using this addon, you can uninstall it by.
<input type="submit" name="ungo" value="Uninstall">
</div>
<tr><td><input type="submit" value="Add Links" name="setgo1" ></td>&nbsp;<input type="submit" value="Manage Links" name="setgo" ></td>&nbsp;<input type="submit" value="Settings" name="addgo" ></td>&nbsp;<input type="submit"

value="About" name="addgo" ></td></tr>
</form>
<center>
<br>
<h3><b>Add Links</b></h3>
<br>
</center>
<center>
<form method="post"  >
<p>Title :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="title" ></p>
<p>Value :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="value" ></p>
<p>Short link : <input type="text" name="shlink" ></p>
<p>Valid Link : <input type="text" name="vlink" ></p>
<p>Credits : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="credits" ></p>
<br>
</center>
<center>
<input type="submit" value="Add Link" name="addgo" >
</center>
</form>
<br>
</form>


';
$bow2 =  '<center>
<br>
<br>
<h3>Click on "Install" button to process the installation.</h3>
<br>
<br>
<img src="../images/IA7uX.png">
<br>
<p>Monetize your ptc site with shorten links without problems.</p>
<br>
<form method="post"  >
<input type="submit" value="Install" name="installgo" >
</form>
<br>
<br>
</center>';

while($mansurf=mysql_fetch_Assoc($records)){
$bow3 = '<form method="post">
<div class="info_box">Manual Surf is installed in your website, if you do not want continue using this addon, you can uninstall it by.
<input type="submit" name="ungo" value="Uninstall">
</div>
<tr><td><input type="submit" value="Add Links" name="setgo1" ></td>&nbsp;<input type="submit" value="Manage Links" name="setgo" ></td>&nbsp;<input type="submit" value="Settings" name="addgo" ></td>&nbsp;<input type="submit"
value="About" name="addgo" ></td></tr><p></form>
<center>
<br>
<h3><b>Manage Links</b></h3>
<br>
</center>
<tr>
<style type="text/css">
.tg  {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg .tg-lnt9{background-color:#4c4c4c;color:#ffffff;vertical-align:top}
.tg .tg-cxkv{background-color:#ffffff}
.tg .tg-fx22{background-color:#4c4c4c;color:#ffffff}
.tg .tg-yw4l{vertical-align:top}
</style>
<table class="tg" style="undefined;table-layout: fixed; width: 940px">
<colgroup>
<col style="width: 10px">
<col style="width: 20px">
<col style="width: 20px">
<col style="width: 20px">
<col style="width: 20px">
<col style="width: 20px">
<col style="width: 20px">
</colgroup>

 <tr>
    <th class="tg-fx22">ID</th>
    <th class="tg-fx22">Title</th>
    <th class="tg-fx22">Value</th>
    <th class="tg-fx22">Short Link</th>
    <th class="tg-lnt9">Valid Link</th>
    <th class="tg-lnt9">Credits</th>
    <th class="tg-lnt9">Actions</th>
    </tr>
 <tr>
    <td class="tg-z2zr">'.$mansurf[id].'</td>

     <td class="tg-z2zr">'.$mansurf['title'].'</td>

     <td class="tg-z2zr">'.$mansurf['value'].'$</td>

     <td class="tg-z2zr">'.$mansurf['shlink'].'</td>

  <td class="tg-z2zr">'.$mansurf['vlink'].'</td>

      <td class="tg-z2zr">'.$mansurf['credits'].'</td>

      <td class="tg-z2zr">'.$mansurf['remove'].'/'.$mansurf['edit'].'</td>

    </tr>
</table>
<br>
<br>
    ';
}



if(isset($_POST['ungo'])) {
$ungo = "DROP TABLE manualsurf_links;";
if($conn->query($ungo) === TRUE) {
$ungo1 = "DROP TABLE manualsurf_setup;";
if($conn->query($ungo1) === TRUE) {
                                     echo '<script>location.href="./?view=addon_modules&module=manualsurf";</script>';
                                     } else {
                                     echo "Error";

}
}
}

$dep = $_POST['usrid'];

if(isset($_POST['remove'])){
$ep = "DELETE FROM `deniiynz_manual`.`manualsurf_links` WHERE `manualsurf_links`.`id` ='$dep'";
if($conn->query($ep) === TRUE) {
echo '<div class="l2successptcform success_box"><span class="icon"></span>Link is successfully removed from the list.</div>';
}
}


if(isset($_POST['setgo'])) {
$bow1 = $bow3;
}

if(isset($_POST['setgo1'])) {
$bow3 = $bow1;
}

$be = "1";
$bossw = '<form method="post"><input type="hidden" name="usrid" value="18"><input type="submit" name="remove" value="Remove"></form>';
$bossw = mysql_real_escape_string($bossw);
if(isset($_POST['addgo'])){
if($title == "" || $value == "" || $shlink == "" || $vlink == "") {
echo '<div class="info_box">Please make sure to fill all textboxs.</div>';
} else {
$ago = "INSERT INTO `deniiynz_manual`.`manualsurf_links` (`id`, `title`, `value`, `shlink`, `vlink`, `credits`, `remove`) VALUES (NULL, '$title', '$value', '$shlink', '$vlink', '$credits, '$bossw');";
if($conn->query($ago) === TRUE) {
echo '<div class="l2successptcform success_box"><span class="icon"></span>New link was successfully added.</div>';
} else {
echo '<div class="error_box">Error something went wrong.</div>';
}
}
}

if($setupRow['status'] == "Installed") {
echo $bow1;
} else {
echo $bow2;

}

if(isset($_POST['installgo'])) {

$updo1 = "CREATE TABLE IF NOT EXISTS `manualsurf_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(10) NOT NULL,
  `value` double NOT NULL DEFAULT '0.0001',
  `shlink` varchar(255) NOT NULL,
  `vlink` varchar(255) NOT NULL,
  `credits` int(200) NOT NULL,
  `remove` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;";
if($conn->query($updo1) === TRUE) {
$upto2 = "CREATE TABLE IF NOT EXISTS `manualsurf_setup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(255) NOT NULL DEFAULT 'uninstalled',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
if($conn->query($upto2) === TRUE) {
$upto4 = "INSERT INTO `manualsurf_setup` (`id`, `status`) VALUES
(1, 'Installed');";
if($conn->query($upto4) === TRUE) {
echo '<script>location.href="./?view=addon_modules&module=manualsurf";</script>';
                                     } else {
                                     echo "Error";

}
}
}
}

?>