Find Jobs
Hire Freelancers

Convert DB To be Compatible with Shockscript

$30-100 USD

Cancelled
Posted about 18 years ago

$30-100 USD

Paid on delivery
Hello, I have a SQL DB w/ thumbnail images + .swf files of 500 games. I need you to convert the DB to work with shockscript. The DB is made for gamesitescript.com. You need to install all 500 games. It doesn't really matter how you do it, as long as it's completely working and it's not hacked and chopped up. You can modify the PHP code if needed. Here is the DB structure for both: ShockScript Format ------------------- mysql_query("DROP TABLE IF EXISTS `games`;"); mysql_query("CREATE TABLE `games` ( `id` int(4) NOT NULL auto_increment, `title` varchar(150) NOT NULL default '', `url` varchar(150) NOT NULL default '', `category` int(3) NOT NULL default '0', `description` varchar(250) NOT NULL default '', `plays` bigint(20) NOT NULL default '0', `date` int(10) NOT NULL default '0', `today_plays` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `url` (`url`), FULLTEXT KEY `title` (`title`,`description`) ) TYPE=MyISAM;"); mysql_query("INSERT INTO `games` VALUES (1, '3 Foot Ninja', '3-foot-ninja', 1, 'Cool online fighting game, great fun is to be had by all', 48, 1115486906, 0);"); mysql_query("INSERT INTO `games` VALUES (10, 'Mars Mission', 'mars-mission', 1, 'Cool alien invaders game, great fun!', 43, 1115486908, 0);"); mysql_query("INSERT INTO `games` VALUES (100, 'Golden Arrow', 'golden-arrow', 2, 'Score as many points as you can.', 73, 1115486910, 0);"); Gamesitescript DB ( This is the DB that I will give you ) ---------------------------- INSERT INTO `games` ( `id` , `nameid` , `name` , `desc` , `time` , `width` , `height` , `cat` , `type` , `authorsite` , `authorname` , `gameurl` , `code` , `playcount` , `flags` , `instructions` , `keywords` , `disphtml` , `disphtmlcode` ) VALUES ( '', 'game_adventures-of-a-space-cowboy', 'Space Cowboy', 'Take on the role of Space Cowboy as you navigate a distant planet.', '%time%', '550', '400', 'Shooting', 'SWF', '[login to view URL]', 'Online Games', '', '', '0', '', '', '', 'Config', '' ); Please note, you may have to rename .swf/.png thumbnails to work, I don't know. You could edit the PHP to work if needed. You tell me. Thanks!
Project ID: 45283

About the project

Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
New York, United States
0.0
0
Member since Jun 29, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.