<?php
$dbuser="nja";
$dbpass="nja";
$dbname="slavija_amxx";  //the name of the database
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
    or die("Greska pri konekciji na bazu podataka, kontaktiraj nekog od admina da poprave :s");
//echo "Connected to database server<br>";
mysql_select_db($dbname, $chandle) or die ($dbname . " Baza podataka nije pronadjena, kontaktiraj nekog od admina da poprave :S" . $dbuser);
//echo "Database " .  $database . " is selected<br><br><br>";


$plname = $_POST["plname"];
$plup = $_POST["plup"];


if ($plname == "" && $plup == "")
echo "Morate da ukucate rec koju hocete da trazite  <br> <a href='plugin_search.php'>Nazad </a>";

if ($plname != "" && $plup != "")
echo "ne mozes zajedno da searchujes <br> <a href='plugin_search.php'>Nazad </a>";

if($plname != "" && $plup == "")
{
$query1= "SELECT * FROM phpbb_plugins WHERE plugin_name LIKE '%".$plname."%' OR plugin_first_post LIKE '%".$plname."%'";
$qe1 = mysql_query($query1);
//$qr1 = mysql_fetch_array($qe1);

if (mysql_num_rows($qe1)<1)
echo "Nista nije pronadjeno :( <br> <a href='plugin_search.php'>Nazad </a>";
else {
echo "
        <br><table border=1 bordercolor=#0099FF width=100%>
        <tr>
        <td width=10><b>ID</b></td>
        <td width=350><b>Plugin name</b></td>
        <td width=150><b>Author</b></td>
        </tr>";

    while($row = mysql_fetch_array($qe1))
    {
        echo "
            </tr>
            <td>".$row['pluginID']."</td>
            <td>".$row['plugin_name']."</td>
            <td>".$row['plugin_uploader']."</td>
            </tr>";
    }

    echo "</table>";


}
}

if($plname == "" && $plup != "")
{
$query2= "SELECT * FROM phpbb_plugins WHERE plugin_uploader LIKE '%".$plup."%'";
$qe2 = mysql_query($query2);
//$qr1 = mysql_fetch_array($qe1);

if (mysql_num_rows($qe2)<1)
echo "Nista nije pronadjeno :( <br> <a href='plugin_search.php'>Nazad </a>";
else {
echo "
        <br><table border=1 bordercolor=#0099FF width=100%>
        <tr>
        <td width=10><b>ID</b></td>
        <td width=350><b>Plugin name</b></td>
        <td width=150><b>Author</b></td>
        </tr>";

    while($row = mysql_fetch_array($qe2))
    {
        echo "
            </tr>
            <td>".$row['pluginID']."</td>
            <td>".$row['plugin_name']."</td>
            <td>".$row['plugin_uploader']."</td>
            </tr>";
    }

    echo "</table>";


}
}
mysql_close($chandle);
?>