Can I Salvage this thing?

T Pat · 2007-10-19, 05:30 PM

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

).
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 · 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;
}
}

?>

Beaver Bob · 2007-10-20, 12:18 AM

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:

PHP Code:


			
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 · 2007-10-20, 12:18 PM

thanks guy's

I gave that a shot Bob
I guess my next step is an SOS to Sparky

T Pat · 2007-10-21, 12:12 PM

I'm no queer but I LOVE Sparky

and I don't give a fuck who knows it

The man is truly my hero

Blinki Bill you suck

this · 2007-11-06, 12:27 PM

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?

T Pat · 2007-11-06, 12:43 PM

Sparky fixed it for me

2007-10-19, 05:30 PM	#1
T Pat You can now put whatever you want in this space :) Join Date: Aug 2003 Location: Paridise Posts: 3,244	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 ). 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? __________________ How To Keep An Asshole In Suspense I'll Tell You Later

2007-10-19, 10:27 PM	#2
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

2007-10-20, 12:18 AM	#4
Beaver Bob Porn Blog Addict Join Date: Oct 2005 Location: Las Vegas, Nevada Posts: 715	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: PHP Code: 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. __________________ Need Custom Content? Spunky Dollars

2007-10-20, 12:18 PM	#5
T Pat You can now put whatever you want in this space :) Join Date: Aug 2003 Location: Paridise Posts: 3,244	thanks guy's I gave that a shot Bob I guess my next step is an SOS to Sparky __________________ How To Keep An Asshole In Suspense I'll Tell You Later

2007-10-21, 12:12 PM	#6
T Pat You can now put whatever you want in this space :) Join Date: Aug 2003 Location: Paridise Posts: 3,244	I'm no queer but I LOVE Sparky and I don't give a fuck who knows it The man is truly my hero Blinki Bill you suck __________________ How To Keep An Asshole In Suspense I'll Tell You Later

2007-11-06, 12:27 PM	#7
this Internet! Is that thing still around? Join Date: Nov 2007 Posts: 3	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?

2007-11-06, 12:43 PM	#8
T Pat You can now put whatever you want in this space :) Join Date: Aug 2003 Location: Paridise Posts: 3,244	Sparky fixed it for me __________________ How To Keep An Asshole In Suspense I'll Tell You Later