Can I Salvage this thing?
 

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?

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
";
else $err.= "items table: ".mysql_error()."
";

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
// *******************************************************************

?>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">









include_once('../include/connect.php');
include_once('../include/functions.php');


if(!isset($save)) {

?>

Add Rss Feed
RSS URL:
Title:
Decription:
Site URl:
Category:	selected>--- $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 .= "".$result['1']." \n"; } print $formc; ?>
value="Add Feed">

}

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 = "

The New Feed Is Added Add anoter one

";

print $html;
}
}

?>

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:
if this doesn't work, try changing the cat field to varchar, or the date field to datetime.

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

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|

Just a thought: I probably would have used something like The MySQL Control Center to build the tables.

Was that the full script? Is this issue resolved?

Sparky fixed it for me:D