I am looking for a recipe site script, BUT, and a big HUGE but, it has to have this database structure. Stupid me bought a database of recipes without checking to see what script it went to, haha, now the dude is MIA and I wanna use this thing! CREATE TABLE `categories` ( `CategoryID` int(10) NOT NULL auto_increment, `CategoryName` varchar(150) NOT NULL default '', PRIMARY KEY (`CategoryID`), UNIQUE KEY `CategoryName` (`CategoryName`) ) TYPE=MyISAM AUTO_INCREMENT=36 ; CREATE TABLE `subcategories` ( `CategoryID` int(10) NOT NULL default '0', `SubcategoryID` int(10) NOT NULL auto_increment, `SubcategoryName` varchar(150) NOT NULL default '', PRIMARY KEY (`SubcategoryID`) ) TYPE=MyISAM AUTO_INCREMENT=54; CREATE TABLE `items` ( `ItemID` int(10) NOT NULL auto_increment, `ItemTitle` varchar(255) NOT NULL default '', `ItemCategory` int(10) NOT NULL default '0', `ItemSubcategory` int(10) NOT NULL default '0', `ItemText` text, `ItemImage` varchar(255) NOT NULL default '', `Contributor` varchar(50) NOT NULL default '', `DateAdded` int(10) NOT NULL default '0', `ItemType` varchar(10) NOT NULL default '', `ItemStatus` varchar(20) NOT NULL default 'unapproved', PRIMARY KEY (`ItemID`) ) TYPE=MyISAM AUTO_INCREMENT=1015;
hey dude,you can surely get a nice recipes website script for 30$. I guess,i can get that for you.. Pm me and i will send you the link to download for 30$. Thanks..
sure, I can get a recipe script for $30, but I am looking for the specific one that has THAT database structure why not just post the link here? and sure I am tight on my budget for this project, I already bought the database and want the exact script it goes to
Not sure if this will help, but I would guess a lot of recipe scripts probably have very similar DB structures. If it's within your programming skill, is it possible to download one of them and "open the hood" so to speak? Take a look at the DB structure of an existing (free) script. If it's close enough, you can do a few name changes and it could work well. I've had to do that with other scripts and it's worked well. Net cost, $0. A little sweat equity could get you exactly what you want. Just a thought.
Out of curiosity which recipe script did you buy? I'm looking into one and I want to make sure I'm not about to have the same problem.
I can't say I recognize the structure. Your best plan of attack might be to find the script you want to use and then do a database migration to it. If you get someone smart they should be able to do it pretty cheaply and quickly for you.