Can I Salvage this thing?

[T Pat]

I had a custom aggregator script written, I really liked the way it looked but I wiped the MSQL data base out (not good to work on painpills |loony|).
The Communist Cocksucker I paid to code the friggin thing told me it was no biggy and he would give me a new install link (for the MYSQL tables) that was almost a month ago.
How hard is it to reverse engineer a php script to rebuild the MYSQL tables.
Any coders looking for some work?

[HowlingWulf]

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]

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

?>

[Beaver Bob]

from what i can see it needs to tables, `cats` and `links`. what we don't see is the names of the fields inside the cats table, or the constraints on the fields in the links table. It would be kinda tricky.. backups are your friend :)

TRY THIS:

CREATE TABLE `cats` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `links` (
`id` int(11) NOT NULL auto_increment,
`lrss` varchar(255) NOT NULL default '',
`site` varchar(255) NOT NULL default '',
`lback` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`cat` int(11) NOT NULL,
`name` varchar(255) NOT NULL default '',
`mail` varchar(255) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



if this doesn't work, try changing the cat field to varchar, or the date field to datetime.

[T Pat]

thanks guy's |waves|
I gave that a shot Bob
I guess my next step is an SOS to Sparky |huh

[T Pat]

I'm no queer but I LOVE Sparky |bananna|
and I don't give a fuck who knows it :D
The man is truly my hero |bow|

Blinki Bill you suck |catfight|

[this]

Just a thought: I probably would have used something like The MySQL Control Center (http://sourceforge.net/projects/mysqlcc) to build the tables.

Was that the full script? Is this issue resolved?

[T Pat]

Sparky fixed it for me:D