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();
?>
<br><br><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><br><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><br>Sorry, but you do not have permission :-)<br><br></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("<br />");
print("<br />");
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>");
?>
<br><br><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><br><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'> <a href='". $_SERVER['PHP_SELF'] . "?deleteid=$id'><img src='pic/delete.jpg'></img></a></div></tr></table><br/>");
}
echo ("</table>");
stdfoot();
?>
add /pic folder:
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...
Screenshots: