Quote:
Originally Posted by HowlingWulf
It shouldn't be too hard, especially if you have the script code which should have the db table names and cats etc.
|
looks and sounds hard to me
I could spend months learning how to do it or I could pay someone to do it for me |badidea|
I choose the second option
<?
// *******************************************************************
// Code writen by Aaron Hamburg (blinki bill)
// adm/Add.php
// *******************************************************************
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title></title>
<link rel = "stylesheet" type = "text/css" href = "style.css" />
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" align=center>
<tr>
<?
include_once('../include/connect.php');
include_once('../include/functions.php');
if(!isset($save)) {
?>
<table cellspacing="0" cellpadding="5" border="1" align="center" width="500">
<tr><form target=main method="post" action="Add.php?save=y">
<td colspan="2" class="theader" align="center">Add Rss Feed</td>
</tr>
<tr>
<td class="text">RSS URL: </td>
<td><input class="small" type="text" name="rss" size="35"></td>
</tr>
<tr>
<tr>
<td class="text">Title: </td>
<td><input class="small" type="text" name="title" size="35"></td>
</tr>
<tr>
<td class="text">Decription:</td>
<td><textarea class="small" name="description" rows="3" cols="40" wrap="virtual"></textarea></td>
</tr>
<tr>
<td class="text">Site URl: </td>
<td><input class="small" type="text" name="url" size="35"></td>
</tr>
<tr>
<td width="16%">Category:</td>
<td width="84%">
<select input name="cat">
<option value=""
selected>---</option>
<?
$sql = new sql();
$q = $sql -> query1("select * from cats order by id");
$formc = "";
for($i=0; $i<$sql -> sqlNumRows(); $i++) {
$result = $sql -> sqlResult($i);
$formc .= "<option value=".$result['0'].">".$result['1']."</option> \n";
}
print $formc;
?>
</select>
</td>
</tr>
<tr>
<td colspan="2" align="center"><input class="button" type="submit" name="Add Feed"
value="Add Feed"></td>
</form></tr>
</table>
<?
}
if (isset($save)) {
$lrss = $_POST['rss'];
$site = $_POST['url'];
$description = $_POST['description'];
$cat = $_POST['cat'];
$catn = query("select cat from cats where id=('$cat')");
$catname = mysql_fetch_row($catn);
$title = $_POST['title'];
$now = date('Ymd');
$check = mysql_query("select
*
from
links
where
lrss
like
'%$lrss%'
");
if (mysql_num_rows($check)>0)
{
print "This Feed exsists on your data base";
}
if (!mysql_num_rows($check)>0)
{
$AddFeed = query("
insert into
links (
id,
lrss,
site,
lback,
title,
description,
cat,
name,
mail,
date
)
values (
'',
'$lrss',
'$site',
'adminadded',
'$title',
'$description',
'$catname[0]',
'admin',
'admin@',
'$now'
)
");
$sql = new sql();
$q = $sql -> query1("select * from links where lrss=('$lrss')");
$p=0;
$result = $sql -> sqlResult($p);
$idi = $result[0];
$XMLFILE = $result[1];
$cat = $result[6];
GLOBAL $idi, $XMLFILE, $cat;
include('ser.php');
$html = "<table width=\"500\" align=\"center\"><tr><td>The New Feed Is Added<br><br>
<a href=\"Add.php\" target=main>Add anoter one</a></td></tr></table>";
print $html;
}
}
?>