Bravo List - Banner Management System

Hi,

this mod is lists the partner sites
I hope all things are here...

Add the sql:

PHP Code:


		
			
CREATE TABLE IF NOT EXISTS `partner` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `titel` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `banner` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `link` varchar(255) character set latin1 collate latin1_german1_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

after create the partner.php

PHP Code:


		
			
<?
require_once('global.php');
gzip();
dbconn();
stdhead();
?>
<table cellpadding="0" cellspacing="0" border="0" style="width:100%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="5" width="100%"><span  class="normalfont"><center><b>..::Partners::..</b></center></span></td>
</tr>
<?
$query = "SELECT * FROM partner ORDER BY id DESC";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$titel = $row['titel'];
$banner = $row['banner'];
$url = $row['link'];

echo ("<tr><td width=100%  class=tablea><center><font  size=4>..::".$titel."::..</font></center>
<table width=100% border=0 cellspacing=0 cellpadding=5><tr><td class=text>
<center><a href=".$url." target=_blank><IMG  SRC=".$banner." WIDTH=468 HEIGHT=60  border=0></a></center>
</td></tr></table><br/>");
}
echo ("</table>");
stdfoot();
?>

create it addpartner.php
Important: in line 7
(if ($CURUSER["username"] != "admin") //admin username instead of your username)

PHP Code:


		
			
<?
require_once('global.php');
gzip();
dbconn();
stdhead();

if ($CURUSER["username"] != "admin")  //admin username instead of your username

{
    print("<div class=error align=center>Sorry, but you  do not have permission :-)</div>");
    stdfoot();
    exit;
}




///////////////////// New functions add \\\\\\\\\\\\\\\\\\\\\\\\\\\\

if($_GET['pa_name']) {
$pa_name = $_GET['pa_name'];
$pa_banurl = $_GET['pa_banurl'];
$pa_url = $_GET['pa_url'];
$editid = $_GET['editid'];
if ($editid) {
$query = "UPDATE partner SET
titel = '$pa_name',
banner = '$pa_banurl',
link = '$pa_url' where id = $editid";
}
else
{
$query = "INSERT INTO partner SET
titel = '$pa_name',
banner = '$pa_banurl',
link = '$pa_url'";
}
$sql = sql_query($query);
if($sql) {
$success = TRUE;
} else {
$success = FALSE;
}
}
if($success == TRUE) {
header("Location: " . $_SERVER['PHP_SELF'] . "");

}

//Delete partner //////////////////////////////////////////////////////

$deleteid = $_GET['deleteid'];
$query = "DELETE FROM partner WHERE id=" .sqlesc($deleteid) . " LIMIT 1";
$sql = sql_query($query);

///////////////////// New options add \\\\\\\\\\\\\\\\\\\\\\\\\\\\

print("<strong><font color='white'>New Partner:</font></strong>");
print("");
print("");

if ($_GET['editid']) {

$editid = $_GET['editid'];
$query = "SELECT * FROM partner where id = '".$editid."'";
$sql = sql_query($query);
$row = sql_fetch_array($sql);
$id = $row['id'];
$titel = $row['titel'];
$banner = $row['banner'];
$url = $row['link'];
}
echo("<form name='form1' method='get' action='" . $_SERVER['PHP_SELF'] . "'>");
echo("<table class=\"tablea\" cellspacing=\"0\" cellpadding=\"5\" width=\"100%\">");
echo("<tr><td><font color='black'>Site name:  </font></td><td align='left'><input type='text'  size='50' value='".$titel."'  name='pa_name'/></td></tr>");
echo("<tr><td><font color='black'>Banner-Url:  </font></td><td align='left'><input type='text'  size='50' value='$banner' name='pa_banurl'/></td></tr>");
echo("<tr><td><font color='black'>The site URL  address: </font></td><td align='left'><input  type='text' size='50' value='$url'  name='pa_url'/></td></tr>");
echo("<div align='center'><input type='hidden' name='editid' value='$id'/></div>");
echo("<tr><td></td><td><div  align='left'><input value='Create'  type='submit'/></div></td></tr>");
echo("</table>");
echo("</form>");

?>
<table cellpadding="0" cellspacing="0" border="0" style="width:100%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="5" width="100%"><span  class="normalfont"><center><b><font  color="black">..::Partner's::..</font></b></center></span></td>
</tr>
<?
$query = "SELECT * FROM partner ORDER BY id";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$titel = $row['titel'];
$banner = $row['banner'];
$url = $row['link'];

echo ("<tr><td width=100%  class=tablea><center><font color='black'  size=4>..::".$titel."::..</font></center>
<table width=100% border=0 cellspacing=0 cellpadding=5><tr><td class=text>
<center><a href=".$url." target=_blank><IMG  SRC=".$banner." WIDTH=468 HEIGHT=60  border=0></a></center>
</td><td width=100% class=tableb><div  align='center'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a  href='". $_SERVER['PHP_SELF'] . "?deleteid=$id'><img  src='pic/delete.jpg'></img></a></div></tr></table><br/>");
}
echo ("</table>");
stdfoot();
?>

add /pic folder:
http://hellgate.ws/pic/pic/delete.jpg

open the following file for editing: ../scripts/dropdown.js

find it:

PHP Code:


		
			
var menu1=new Array();
menu1[0]='<a href="' + baseurl + '/admin/index.php">' + l_staffpanel + '</a>'

add after:

PHP Code:


		
			
menu1[1]='<a href="' + baseurl + '/addpartner.php">" Banners "</a>'

find it:

PHP Code:


		
			
var menu2=new Array();
menu2[0]='<a href="' + baseurl + '/admin/index.php">' + l_staffpanel + '</a>'
menu2[1]='<a href="' + baseurl + '/admin/index.php?act=statistics">' + l_trackerstats + '</a>'

add after:

PHP Code:


		
			
menu2[2]='<a href="' + baseurl + '/addpartner.php">" Banners "</a>'

find it:

PHP Code:


		
			
menu3[0]='<a href="' + baseurl + '/admin/index.php">' + l_staffpanel + '</a>'
menu3[1]='<a href="' + baseurl + '/admin/settings.php">' + l_trackersettings + '</a>'
menu3[2]='<a href="' + baseurl + '/admin/index.php?act=statistics">' + l_trackerstats + '</a>'

add after:

PHP Code:


		
			
menu3[3]='<a href="' + baseurl +  '/addpartner.php">Banners</a>'

your template folder. open the header.php (../include/templates/your_template/header.php)

find it:

PHP Code:


		
			
<li class="page_item"><a href="#top" onclick="return  clickreturnvalue()" onmouseover="dropdownmenu(this, event,menu11,  '150px')" onmouseout="delayhidemenu()"><?php echo  $lang->global['extra']; ?></a></li>

add adter:

PHP Code:


		
			
<li class="page_item"><a href="<?php echo $BASEURL;  ?>/partner.php"><font color="white"><?php echo  "Partners"; ?></font></a></li>

and enjoy...:sun:

Screenshots:
http://hellgate.ws/pic/partner1.jpg
http://hellgate.ws/pic/partner2.jpg