Can I Salvage this thing?

HowlingWulf · 2007-10-19, 10:27 PM

It shouldn't be too hard, especially if you have the script code which should have the db table names and cats etc.

You can create a table right from the mysql> prompt or write a simple script for it. Do a web search for basic mysql commands that's how I learned to do it.

Example php code:

if ($db= mysql_connect($YOURHOST, $MYSQLUSER, $MYSQLPWD)){
mysql_select_db($DATABASENAME, $db);
}
else echo 'database connection failure!';
$sql="CREATE TABLE items(
id int(11) DEFAULT '0' NOT NULL auto_increment,
name varchar(255) NOT NULL,
ip varchar(15) NOT NULL default '',
cat int(11) DEFAULT '0' NOT NULL,
pwd varchar(24) NOT NULL,
approved tinyint(4) NOT NULL default '0',
date int(11) NOT NULL default '0',
PRIMARY KEY (id))";

if (mysql_query($sql, $db)) echo "'items' table successfully installed<br>";
else $err.= "<b>items table: </b>".mysql_error()."<br>";

T Pat · 2007-10-19, 10:52 PM

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;
}
}

?>

2007-10-19, 10:27 PM	#1
HowlingWulf Me fail English? That's unpossible! Join Date: Dec 2003 Location: FL Posts: 1,381	It shouldn't be too hard, especially if you have the script code which should have the db table names and cats etc. You can create a table right from the mysql> prompt or write a simple script for it. Do a web search for basic mysql commands that's how I learned to do it. Example php code: if ($db= mysql_connect($YOURHOST, $MYSQLUSER, $MYSQLPWD)){ mysql_select_db($DATABASENAME, $db); } else echo 'database connection failure!'; $sql="CREATE TABLE items( id int(11) DEFAULT '0' NOT NULL auto_increment, name varchar(255) NOT NULL, ip varchar(15) NOT NULL default '', cat int(11) DEFAULT '0' NOT NULL, pwd varchar(24) NOT NULL, approved tinyint(4) NOT NULL default '0', date int(11) NOT NULL default '0', PRIMARY KEY (id))"; if (mysql_query($sql, $db)) echo "'items' table successfully installed<br>"; else $err.= "<b>items table: </b>".mysql_error()."<br>"; __________________ WordPress Porn directory theme => Maddos Create a Porn Tube => Video Pornster