Mysql for zw - Developers - Facepunch Forum

can anyone who knows how to make mysql's make one for the zombified world script i dont know anything about it or lua sadly here is the link to the gamemode [url]http://winsaucestudios.com/forum/ind...sa=item;id=240[/url]

The sql file for ZW is in the root of the LuaDump.zip.

he removed that so people had to make their own

Just redownloaded it. It's there. [code] /* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50140 Source Host : localhost:3306 Source Database : server_zw Target Server Type : MYSQL Target Server Version : 50140 File Encoding : 65001 Date: 2009-11-24 00:31:54 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `player_inventories` -- ---------------------------- DROP TABLE IF EXISTS `player_inventories`; CREATE TABLE `player_inventories` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `steamid` varchar(255) DEFAULT NULL, `inventoryweapons` text, `inventoryitems` text, PRIMARY KEY (`id`), UNIQUE KEY `steamid` (`steamid`) ) ENGINE=MyISAM AUTO_INCREMENT=178220 DEFAULT CHARSET=latin1; -- ---------------------------- -- Table structure for `player_stats` -- ---------------------------- DROP TABLE IF EXISTS `player_stats`; CREATE TABLE `player_stats` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `steamid` varchar(255) DEFAULT NULL, `level` tinyint(4) DEFAULT NULL, `points` tinyint(4) DEFAULT NULL, `xp` bigint(20) DEFAULT NULL, `money` bigint(20) DEFAULT NULL, `hunger` tinyint(4) DEFAULT NULL, `sleep` tinyint(4) DEFAULT NULL, `infection` tinyint(4) DEFAULT NULL, `armor` varchar(255) DEFAULT NULL, `armorstatus` tinyint(4) DEFAULT NULL, `statknowledge` tinyint(4) DEFAULT NULL, `statrepair` tinyint(4) DEFAULT NULL, `stathealth` tinyint(4) DEFAULT NULL, `statsalvage` tinyint(4) DEFAULT NULL, `statendurance` tinyint(4) DEFAULT NULL, `statspeed` tinyint(4) DEFAULT NULL, `statmedskill` tinyint(4) DEFAULT NULL, `statdamage` tinyint(4) DEFAULT NULL, `statdefense` tinyint(4) DEFAULT NULL, `statstrength` tinyint(4) DEFAULT NULL, `statbarter` tinyint(4) DEFAULT NULL, `playermodel` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `steamid` (`steamid`) ) ENGINE=MyISAM AUTO_INCREMENT=172635 DEFAULT CHARSET=latin1; -- ---------------------------- -- Table structure for `trader_spawns` -- ---------------------------- DROP TABLE IF EXISTS `trader_spawns`; CREATE TABLE `trader_spawns` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `angle_y` bigint(20) NOT NULL, `vector_x` bigint(20) NOT NULL, `vector_y` bigint(20) NOT NULL, `vector_z` bigint(20) NOT NULL, `map` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=98 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of trader_spawns -- ---------------------------- INSERT INTO `trader_spawns` VALUES ('9', '-90', '2210', '3392', '40', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('10', '108', '893', '-838', '-144', 'gm_construct'); INSERT INTO `trader_spawns` VALUES ('11', '-179', '-506', '69', '-149', 'gm_construct'); INSERT INTO `trader_spawns` VALUES ('12', '31', '-910', '544', '1808', 'zs_shaft'); INSERT INTO `trader_spawns` VALUES ('13', '133', '3087', '85', '64', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('14', '117', '3523', '105', '40', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('15', '149', '4477', '-1289', '40', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('16', '153', '6082', '-689', '40', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('17', '176', '6198', '2270', '40', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('18', '-178', '5660', '4553', '40', 'zm_cleanup_b2'); INSERT INTO `trader_spawns` VALUES ('19', '-180', '826', '-595', '-144', 'gm_construct'); INSERT INTO `trader_spawns` VALUES ('20', '-179', '-316', '441', '0', 'rd_zombocity_f2'); INSERT INTO `trader_spawns` VALUES ('21', '-43', '1526', '3266', '0', 'rd_zombocity_f2'); INSERT INTO `trader_spawns` VALUES ('22', '-180', '436', '3214', '0', 'rd_zombocity_f2'); INSERT INTO `trader_spawns` VALUES ('23', '179', '-2361', '2142', '144', 'rd_zombocity_f2'); INSERT INTO `trader_spawns` VALUES ('24', '91', '-4247', '-6524', '-1731', 'zw_woodcut'); INSERT INTO `trader_spawns` VALUES ('25', '-151', '3128', '304', '-1668', 'zw_woodcut'); INSERT INTO `trader_spawns` VALUES ('26', '108', '-2096', '1613', '-416', 'rp_destroyedcity_final'); INSERT INTO `trader_spawns` VALUES ('27', '-45', '-1789', '-1873', '-384', 'rp_destroyedcity_final'); INSERT INTO `trader_spawns` VALUES ('28', '5', '-3992', '-6616', '-256', 'rp_destroyedcity_final'); INSERT INTO `trader_spawns` VALUES ('29', '-50', '-1792', '-6234', '-384', 'rp_destroyedcity_final'); INSERT INTO `trader_spawns` VALUES ('30', '0', '-134', '367', '143', 'zs_subversive_v2'); INSERT INTO `trader_spawns` VALUES ('31', '-38', '-1607', '-548', '428', 'zs_subversive_v2'); INSERT INTO `trader_spawns` VALUES ('32', '177', '2994', '-153', '104', 'zm_bluevelvet_rc1'); INSERT INTO `trader_spawns` VALUES ('33', '-44', '-442', '737', '0', 'zm_bluevelvet_rc1'); INSERT INTO `trader_spawns` VALUES ('34', '-42', '-935', '-11636', '64', 'rp_salvation'); INSERT INTO `trader_spawns` VALUES ('35', '-89', '173', '-3099', '-64', 'rp_salvation'); INSERT INTO `trader_spawns` VALUES ('36', '-3', '-1679', '-1286', '33', 'rp_salvation'); INSERT INTO `trader_spawns` VALUES ('37', '92', '1860', '-1825', '32', 'rp_salvation'); INSERT INTO `trader_spawns` VALUES ('38', '-170', '2536', '-3343', '96', 'rp_salvation'); INSERT INTO `trader_spawns` VALUES ('39', '178', '-13821', '12787', '512', 'rp_coast_09'); INSERT INTO `trader_spawns` VALUES ('40', '99', '864', '-9578', '-1137', 'rp_coast_09'); INSERT INTO `trader_spawns` VALUES ('41', '-90', '-806', '6286', '-764', 'rp_coast_09'); INSERT INTO `trader_spawns` VALUES ('42', '-175', '11105', '8618', '-188', 'rp_coast_09'); INSERT INTO `trader_spawns` VALUES ('43', '-90', '-7491', '-6334', '588', 'coast_03_outlands_v1'); INSERT INTO `trader_spawns` VALUES ('44', '12', '-11056', '-13427', '1122', 'coast_03_outlands_v1'); INSERT INTO `trader_spawns` VALUES ('45', '-5', '-9506', '-1381', '322', 'coast_03_outlands_v1'); INSERT INTO `trader_spawns` VALUES ('46', '92', '-8186', '3661', '492', 'coast_03_outlands_v1'); INSERT INTO `trader_spawns` VALUES ('47', '89', '4025', '3498', '393', 'coast_03_outlands_v1'); INSERT INTO `trader_spawns` VALUES ('48', '-3', '-64', '-114', '172', 'zs_subversive_part3'); INSERT INTO `trader_spawns` VALUES ('49', '50', '1879', '38', '183', 'zs_subversive_part3'); INSERT INTO `trader_spawns` VALUES ('50', '180', '1479', '-986', '92', 'zs_subversive_part3'); INSERT INTO `trader_spawns` VALUES ('51', '90', '5757', '11476', '256', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('52', '-2', '-6278', '3083', '48', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('53', '-173', '-11055', '3732', '-16', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('54', '-136', '-3523', '8623', '240', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('55', '-43', '398', '1309', '24', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('56', '179', '-9390', '13347', '-152', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('57', '90', '448', '-435', '-1024', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('58', '-1', '-185', '-253', '-252', 'zm_backwoods_b4'); INSERT INTO `trader_spawns` VALUES ('59', '177', '194', '6', '-124', 'zm_backwoods_b4'); INSERT INTO `trader_spawns` VALUES ('60', '-1', '-4777', '4954', '-260', 'zm_backwoods_b4'); INSERT INTO `trader_spawns` VALUES ('61', '93', '-8881', '7492', '-260', 'zm_backwoods_b4'); INSERT INTO `trader_spawns` VALUES ('62', '-21', '-1234', '-1879', '3', 'rd_zombocity_f2'); INSERT INTO `trader_spawns` VALUES ('63', '4', '468', '-1666', '152', 'rd_zombocity_f2'); INSERT INTO `trader_spawns` VALUES ('64', '103', '891', '-448', '-1024', 'gm_aftermath_rc1a'); INSERT INTO `trader_spawns` VALUES ('65', '-91', '1154', '-300', '72', 'noamzwf'); INSERT INTO `trader_spawns` VALUES ('66', '90', '-814', '366', '344', 'noamzwf'); INSERT INTO `trader_spawns` VALUES ('67', '-90', '-1214', '1883', '352', 'noamzwf'); INSERT INTO `trader_spawns` VALUES ('68', '0', '2509', '-1846', '-288', 'NoamzTunnels'); INSERT INTO `trader_spawns` VALUES ('69', '23', '4878', '-3452', '-695', 'NoamzTunnels'); INSERT INTO `trader_spawns` VALUES ('70', '90',

where do i put the mysql file i have it now

You import it to a mysql database on a mysql server.

what if im gonna host it off my comp for a bit for testing?

Run a MySQL server on your machine? It may be overkill but you could use [url=http://www.wampserver.com/]WAMP[/url] to run a full webserver which will also install phpMyAdmin by default for you to administrate your databases.