API tools faq
paste
hadar

Hadar

hadar
Nov 29th, 2009
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.98 KB | None | 0 0
raw download clone embed print report
  1. require_once('settings.php');
  2. checkLogin('1 2 3 4 5 6 7 8');
  3. mysql_connect($easyhostname,$easyusername, $easypassword) OR DIE ('Unable to connect to database! Please try again later.'. mysql_error());
  4. mysql_select_db($easydb);
  5.  
  6.  
  7. if($_GET["cmd"]=="show" || $_POST["cmd"]=="show")
  8. {
  9. if(isset($_GET['id']) && $_GET["type"]=="image/jpeg" || $_GET["type"]=="image/pjpeg" || $_GET["type"]=="image/gif" )
  10. {
  11. $id    = $_GET['id'];
  12. $query = "SELECT FileName, FileSize, FileData, ContentType, LinkID, Description, Name, Addedby, Permissions, Category, Rank, Locked, LastUpdate FROM Files WHERE ID = '$id'";
  13.  
  14. $result = mysql_query($query) or die('Error, query failed');
  15. //list($FileName, $FileSize, $FileData, $ContentType, $LinkID, $Description, $Name, $Addedby, $Permissions, $Category, $Rank, $Locked, $LastUpdate) = mysql_fetch_array($result);
  16.  
  17.     $row = mysql_fetch_array($result);
  18.       {
  19.        $data = $row['FileData'];
  20.        $type = $row['ContentType'];
  21.       }
  22.       Header( "Content-type: $type");
  23.       echo $data;
  24.  
  25. }
  26. if(isset($_GET['id']) && $_GET["type"]=="text")
  27. {
  28. $id    = $_GET['id'];
  29. $query = "SELECT FileName, FileSize, FileData, ContentType, LinkID, Description, Name, Addedby, Permissions, Category, Rank, Locked, LastUpdate FROM Files WHERE ID = '$id'";
  30.  
  31. $result = mysql_query($query) or die('Error, query failed'. mysql_error());
  32. list($FileName, $FileSize, $FileData, $ContentType, $LinkID, $Description, $Name, $Addedby, $Permissions, $Category, $Rank, $Locked, $LastUpdate) = mysql_fetch_array($result);
  33. ?>
  34. <table style="margin-left: 10px" cellspacing="0" cellpadding="0"><tr>
  35. </tr>
  36. <tr>
  37.   <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>name</b></td>
  38.   <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Description</b></td>
  39.   <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Rank to view</b></td>
  40.   <td bgcolor="#E6FFE6">&nbsp;</td>
  41. </tr>
  42. <?
  43.    $result = mysql_query("SELECT * FROM Categories ORDER BY name");
  44.    while($r=mysql_fetch_array($result))
  45.    {
  46.       $name=$r["Name"];
  47.       $id=$r["ID"];
  48.       $desc=$r["Description"];
  49. if ($r["Rank"]==7):
  50. $rank="Tao Incarnate";
  51. elseif ($r["Rank"]==1):
  52. $rank="Hopeful";
  53. elseif ($r["Rank"]==2):
  54. $rank="Believer";
  55. elseif ($r["Rank"]==3):
  56. $rank="Follower";
  57. elseif ($r["Rank"]==4):
  58. $rank="Disciple";
  59. elseif ($r["Rank"]==5):
  60. $rank="Adept";
  61. elseif ($r["Rank"]==6):
  62. $rank="Guide";
  63. endif;
  64.  
  65.       echo "<tr>";
  66.       echo "<td style=\"padding-left: 5px; padding-right: 5px\"><b>";
  67.       echo "<a href='?page=downloadtest&cmd=view&id=$id&name=$name'>$name</a>";
  68.       echo "</td>";
  69.       echo "<td class=\"downloads2\">$desc</td>";
  70.       echo "<td class=\"downloads2\"><center>$rank</center></td>";
  71.       echo "</tr>";
  72.     }
  73. echo "<br>";
  74. echo nl2br($FileData);
  75.  
  76. exit;
  77. }
  78. }
  79.  
  80. if($_GET["cmd"]=="download" || $_POST["cmd"]=="download")
  81. {
  82. if(isset($_GET['id']))
  83. {
  84. $id    = $_GET['id'];
  85. $query = "SELECT * FROM Files WHERE ID = '$id'";
  86.  
  87. $result = mysql_query($query) or die('Error, query failed');
  88. list($FileName, $FileSize, $FileData, $ContentType) = mysql_fetch_array($result);
  89.  
  90. header("Content-length: $FileSize");
  91. header("Content-type: $ContentType");
  92. header("Content-Disposition: attachment; filename=$FileName");
  93. echo $FileData;
  94.  
  95. exit;
  96. }
  97. }
  98. ?>    
  99.  
  100. <table style="margin-left: 10px" cellspacing="0" cellpadding="0"><tr><td bgcolor="#336633" background="../images/darkgreen.gif">
  101. <table cellspacing="1" cellpadding="3">
  102. <tr><td colspan="65" class="minitext">
  103. </td></tr>
  104. <tr>
  105.   <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>name</b></td>
  106.   <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Description</b></td>
  107.   <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Rank to view</b></td>
  108.   <td bgcolor="#E6FFE6">&nbsp;</td>
  109. </tr>
  110.  
  111. <?
  112. if(!isset($cmd))
  113. {
  114.    //display all the catigoried
  115.    $result = mysql_query("SELECT * FROM Categories ORDER BY name");
  116.    
  117.    //run the while loop that grabs all the catagories scripts
  118.    while($r=mysql_fetch_array($result))
  119.    {
  120.       //grab the title and the ID of the rtatoybox
  121.       $name=$r["Name"];//take out the name
  122.       $id=$r["ID"];//take out the id
  123.       $desc=$r["Description"];//take out the description
  124.       $omgitsgod=get_level_access ( $_SESSION['user_id'] );
  125. //    $type=$r[""];
  126. if ($r["Rank"]==7):
  127. $rank="Tao Incarnate";
  128. elseif ($r["Rank"]==1):
  129. $rank="Hopeful";
  130. elseif ($r["Rank"]==2):
  131. $rank="Believer";
  132. elseif ($r["Rank"]==3):
  133. $rank="Follower";
  134. elseif ($r["Rank"]==4):
  135. $rank="Disciple";
  136. elseif ($r["Rank"]==5):
  137. $rank="Adept";
  138. elseif ($r["Rank"]==6):
  139. $rank="Guide";
  140. endif;
  141. if ($r["Rank"]<=$omgitsgod || isadmin ( $_SESSION['user_id'] ))
  142. {
  143.       echo "<tr>";
  144.       echo "<td style=\"padding-left: 5px; padding-right: 5px\" class=\"mainlevel\"><b>";
  145.       echo "<a href='?page=downloadtest&cmd=view&id=$id&name=$name&ugh=$id' class=\"mainlevel\">$name</a>";
  146.       echo "</td>";
  147.       echo "<td class=\"downloads\">$desc</td>";
  148.       echo "<td class=\"downloads\"><center>$rank</center></td>";
  149.       echo "</tr>";
  150. } else {
  151.     echo "<tr>";
  152.     echo "<td style=\"padding-left: 5px; padding-right: 5px\"><b>";
  153.     echo "<div class=\"downloads\">$name</div>";
  154.     echo "</td>";
  155.     echo "<td class=\"downloads\">$desc</td>";
  156.     echo "<td class=\"downloads\"><center>$rank</center></td>";
  157.     echo "</tr>";
  158.     }
  159.     }
  160. }
  161. ?>
  162.  
  163. <tr><td colspan="65" class="minitext"></td></tr>
  164. </table></td></tr></table>
  165.  
  166.  
  167.  
  168.  
  169. <?
  170. if ($_GET["cmd"])
  171. {
  172.     $catname=$_GET["name"];
  173.     $catid=$_GET["ugh"];
  174. ?>
  175.  
  176. <p class="pageheader">\}<?=$catname?>{/</p><br>
  177. <br>
  178. <table style="margin-left: 10px" cellspacing="0" cellpadding="0"><tr><td bgcolor="#336633" background="../images/darkgreen.gif">
  179. <table cellspacing="1" cellpadding="3">
  180. <tr><td colspan="65" class="minitext">
  181. </td></tr>
  182. <tr><td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Name</b></td>
  183. <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>View</b></td>
  184. <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Download</b></td>
  185. <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Description</b></td>
  186. <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Rank to view</b></td>
  187. <td bgcolor="#E6FFE6" style="font-size: 8pt" align="center"><b>Edit</b></td>
  188. <td bgcolor="#E6FFE6">&nbsp;</td></tr>
  189.  
  190. <tr><td style="padding-left: 5px; padding-right: 5px">
  191. <?
  192.    //display all the catigoried
  193.    $result = mysql_query("SELECT * FROM Files ORDER BY name");
  194.    
  195.    //run the while loop that grabs all the catagories scripts
  196.    while($r=mysql_fetch_array($result))
  197.    {
  198.       $id=$r["ID"];
  199.       $filename=$r["FileName"];
  200.       $catee=$r["Category"];
  201.       if ($type=$r["ContentType"] == "text/plain" || $type=$r["ContentType"] == "text/html")
  202.       {
  203.       $type="text";
  204.       } else {
  205.        $type="image";
  206.       }
  207.       $desc=$r["Description"];
  208.       $name=$r["Name"];
  209.       $addby=$r["AddedBy"];
  210.       $rank=$r["Rank"];
  211.       $locked=$r["Locked"];
  212. //    $rank=$r["Rank"];grab the required rank
  213. if ($r["Rank"]==7):
  214. $rank="Tao Incarnate";
  215. elseif ($r["Rank"]==1):
  216. $rank="Hopeful";
  217. elseif ($r["Rank"]==2):
  218. $rank="Believer";
  219. elseif ($r["Rank"]==3):
  220. $rank="Follower";
  221. elseif ($r["Rank"]==4):
  222. $rank="Disciple";
  223. elseif ($r["Rank"]==5):
  224. $rank="Adept";
  225. elseif ($r["Rank"]==6):
  226. $rank="Guide";
  227. endif;
  228.  
  229. if ($catee == $catid && $r["Rank"] <= $omgitsgod && $type == "text")
  230. {
  231.       echo "<tr>";
  232.       echo "<td style=\"padding-left: 5px; padding-right: 5px\" class=\"mainlevel\"><b>";
  233.       echo "$name";
  234.       echo "</td>";
  235.       echo "<td class=\"downloads\"><a href='?page=downloadtest&cmd=show&id=$id&type=$type'class=\"mainlevel\">View</a></td>";
  236.       echo "<td class=\"downloads\"><a href='download.php?cmd=download&id=$id&type=$type'class=\"mainlevel\">Download</a></td>";
  237.       echo "<td class=\"downloads\">$desc</td>";
  238.       echo "<td class=\"downloads\"><center>$rank</center></td>";
  239.       echo "<td class=\"downloads\">Not Working</td>";
  240.       echo "</tr>";
  241.     } elseif ($catee==$catid && $r["Rank"]>$omgitsgod) {
  242.       echo "<tr>";
  243.       echo "<td style=\"padding-left: 5px; padding-right: 5px\" class=\"mainlevel\"><b>";
  244.       echo "$name";
  245.       echo "</td>";
  246.       echo "<td class=\"downloads\">Can not view</td>";
  247.       echo "<td class=\"downloads\">Can not download</td>";
  248.       echo "<td class=\"downloads\">$desc</td>";
  249.       echo "<td class=\"downloads\"><center>$rank</center></td>";
  250.       echo "<td class=\"downloads\">Not Working</td>";
  251.       echo "</tr>";
  252.     } elseif ($catee==$catid && $type=="image") {
  253.       echo "<tr>";
  254.       echo "<td style=\"padding-left: 5px; padding-right: 5px\" class=\"mainlevel\"><b>";
  255.       echo "$name";
  256.       echo "</td>";
  257.       echo "<td class=\"downloads\"><a href='' onclick=\"return popitup('download.php?cmd=show&id=$id&type=$type')\"class=\"mainlevel\">View</a></td>";
  258.       echo "<td class=\"downloads\"><a href='download.php?cmd=download&id=$id&type=$type'class=\"mainlevel\">Download</a></td>";
  259.       echo "<td class=\"downloads\">$desc</td>";
  260.       echo "<td class=\"downloads\"><center>$rank</center></td>";
  261.       echo "<td class=\"downloads\">Not Working</td>";
  262.       echo "</tr>";
  263.     }
  264.     }
  265. ?>
  266.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!