Find Jobs
Hire Freelancers

Convert DB To be Compatible with Shockscript

$30-100 USD

已取消
已发布大约 18 年前

$30-100 USD

货到付款
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!
项目 ID: 45283

关于此项目

远程项目
活跃18 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作

关于客户

UNITED STATES的国旗
New York, United States
0.0
0
会员自6月 29, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。