Junior Spellweaver
- Joined
- Oct 30, 2010
- Messages
- 148
- Reaction score
- 8
Where's the US_export_policy and local_policy files that I should move? Because I don't find them in C:\Program Files\Java
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Where's the US_export_policy and local_policy files that I should move? Because I don't find them in C:\Program Files\Java
Create a new file called 'subnet.properties' in your source folder.
In step 12,
How do I create a new file? Using net bean or SQL?
[Err] 1005 - Can't create table 'odin_sea.csequipment' (errno: 1478)
[Err] CREATE TABLE `characters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountid` int(11) NOT NULL DEFAULT '0',
`world` tinyint(1) NOT NULL DEFAULT '0',
`name` varchar(13) NOT NULL DEFAULT '',
`level` int(3) unsigned NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`str` int(5) NOT NULL DEFAULT '0',
`dex` int(5) NOT NULL DEFAULT '0',
`luk` int(5) NOT NULL DEFAULT '0',
`int` int(5) NOT NULL DEFAULT '0',
`hp` int(5) NOT NULL DEFAULT '0',
`mp` int(5) NOT NULL DEFAULT '0',
`maxhp` int(5) NOT NULL DEFAULT '0',
`maxmp` int(5) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
`hpApUsed` int(5) NOT NULL DEFAULT '0',
`job` int(5) NOT NULL DEFAULT '0',
`skincolor` tinyint(1) NOT NULL DEFAULT '0',
`gender` tinyint(1) NOT NULL DEFAULT '0',
`fame` int(5) NOT NULL DEFAULT '0',
`hair` int(11) NOT NULL DEFAULT '0',
`face` int(11) NOT NULL DEFAULT '0',
`ap` int(5) NOT NULL DEFAULT '0',
`map` int(11) NOT NULL DEFAULT '0',
`spawnpoint` int(3) NOT NULL DEFAULT '0',
`gm` int(3) NOT NULL DEFAULT '0',
`party` int(11) NOT NULL DEFAULT '0',
`buddyCapacity` int(3) NOT NULL DEFAULT '25',
`createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`guildid` int(10) unsigned NOT NULL DEFAULT '0',
`guildrank` tinyint(1) unsigned NOT NULL DEFAULT '5',
`allianceRank` tinyint(1) unsigned NOT NULL DEFAULT '5',
`guildContribution` int(11) NOT NULL DEFAULT '0',
`pets` varchar(13) NOT NULL DEFAULT '-1,-1,-1',
`sp` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0',
`subcategory` int(11) NOT NULL DEFAULT '0',
`rank` int(11) NOT NULL DEFAULT '1',
`rankMove` int(11) NOT NULL DEFAULT '0',
`jobRank` int(11) NOT NULL DEFAULT '1',
`jobRankMove` int(11) NOT NULL DEFAULT '0',
`marriageId` int(11) NOT NULL DEFAULT '0',
`familyid` int(11) NOT NULL DEFAULT '0',
`seniorid` int(11) NOT NULL DEFAULT '0',
`junior1` int(11) NOT NULL DEFAULT '0',
`junior2` int(11) NOT NULL DEFAULT '0',
`currentrep` int(11) NOT NULL DEFAULT '0',
`totalrep` int(11) NOT NULL DEFAULT '0',
`gachexp` int(11) NOT NULL DEFAULT '0',
`fatigue` tinyint(4) NOT NULL DEFAULT '0',
`charm` mediumint(7) NOT NULL DEFAULT '0',
`craft` mediumint(7) NOT NULL DEFAULT '0',
`charisma` mediumint(7) NOT NULL DEFAULT '0',
`will` mediumint(7) NOT NULL DEFAULT '0',
`sense` mediumint(7) NOT NULL DEFAULT '0',
`insight` mediumint(7) NOT NULL DEFAULT '0',
`totalWins` int(11) NOT NULL DEFAULT '0',
`totalLosses` int(11) NOT NULL DEFAULT '0',
`pvpExp` int(11) NOT NULL DEFAULT '0',
`pvpPoints` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `accountid` (`accountid`),
KEY `id` (`id`),
KEY `guildid` (`guildid`),
KEY `familyid` (`familyid`),
KEY `marriageId` (`marriageId`),
KEY `seniorid` (`seniorid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*Table structure for table `cheatlog` */
DROP TABLE IF EXISTS `cheatlog`;
CREATE TABLE `cheatlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`offense` tinytext NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
`lastoffensetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`param` tinytext NOT NULL,
PRIMARY KEY (`id`),
KEY `cid` (`characterid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
/*Table structure for table `compensationlog_confirmed` */
DROP TABLE IF EXISTS `compensationlog_confirmed`;
CREATE TABLE `compensationlog_confirmed` (
`chrname` varchar(25) NOT NULL DEFAULT '',
`donor` tinyint(1) NOT NULL DEFAULT '0',
`value` int(11) NOT NULL DEFAULT '0',
`taken` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`chrname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*Table structure for table `csequipment` */
DROP TABLE IF EXISTS `csequipment`;
CREATE TABLE `csequipment` (
`inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`inve
[Err] 1005 - Can't create table 'odin_sea.questinfo' (errno: 1478)
[Err] CREATE TABLE `questinfo` (
`questinfoid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`quest` int(6) NOT NULL DEFAULT '0',
`customData` varchar(555) DEFAULT NULL,
PRIMARY KEY (`questinfoid`),
KEY `characterid` (`characterid`),
CONSTRAINT `questsinfo_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
/*Table structure for table `queststatus` */
DROP TABLE IF EXISTS `queststatus`;
CREATE TABLE `queststatus` (
`queststatusid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`quest` int(6) NOT NULL DEFAULT '0',
`status` tinyint(4) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`forfeited` int(11) NOT NULL DEFAULT '0',
`customData` varchar(255) DEFAULT NULL,
PRIMARY KEY (`queststatusid`),
KEY `characterid` (`characterid`),
KEY `queststatusid` (`queststatusid`),
CONSTRAINT `queststatus_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
/*Table structure for table `queststatusmobs` */
DROP TABLE IF EXISTS `queststatusmobs`;
CREATE TABLE `queststatusmobs` (
`queststatusmobid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`queststatusid` int(10) unsigned NOT NULL DEFAULT '0',
`mob` int(11) NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`queststatusmobid`),
KEY `queststatusid` (`queststatusid`),
CONSTRAINT `queststatusmobs_ibfk_1` FOREIGN KEY (`queststatusid`) REFERENCES `queststatus` (`queststatusid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*Table structure for table `reactordrops` */
DROP TABLE IF EXISTS `reactordrops`;
CREATE TABLE `reactordrops` (
`reactordropid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reactorid` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`chance` int(11) NOT NULL,
`questid` int(5) NOT NULL DEFAULT '-1',
PRIMARY KEY (`reactordropid`),
KEY `reactorid` (`reactorid`)
) ENGINE=MyISAM AUTO_INCREMENT=838 DEFAULT CHARSET=latin1 PACK_KEYS=1;
/*Table structure for table `regrocklocations` */
DROP TABLE IF EXISTS `regrocklocations`;
CREATE TABLE `regrocklocations` (
`trockid` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`mapid` int(11) DEFAULT NULL,
PRIMARY KEY (`trockid`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
/*Table structure for table `reports` */
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
`reportid` int(9) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`type` tinyint(2) NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`reportid`,`characterid`),
KEY `characterid` (`characterid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
/*Table structure for table `rings` */
DROP TABLE IF EXISTS `rings`;
CREATE TABLE `rings` (
`ringid` int(11) NOT NULL AUTO_INCREMENT,
`partnerRingId` int(11) NOT NULL DEFAULT '0',
`partnerChrId` int(11) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`partnername` varchar(255) NOT NULL,
PRIMARY KEY (`ringid`),
KEY `ringid` (`ringid`),
KEY `partnerChrId` (`partnerChrId`),
KEY `partnerRingId` (`partnerRingId`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
/*Table structure for table `savedlocations` */
DROP TABLE IF EXISTS `savedlocations`;
CREATE TABLE `savedlocations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL,
`locationtype` int(11) NOT NULL DEFAULT '0',
`map` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `savedlocations_ibfk_1` (`characterid`),
CONSTRAINT `savedlocations_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
)
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Exception in thread "main" java.lang.NoSuchFieldError: FAMILIAR
at constants.GameConstants.<clinit>(GameConstants.java:47)
at database.DatabaseConnection$ThreadLocalConnection.initialValue(Databa
seConnection.java:110)
at database.DatabaseConnection$ThreadLocalConnection.initialValue(Databa
seConnection.java:98)
at java.lang.ThreadLocal.setInitialValue(Unknown Source)
at java.lang.ThreadLocal.get(Unknown Source)
at database.DatabaseConnection.getConnection(DatabaseConnection.java:87)
at server.ServerProperties.<clinit>(ServerProperties.java:30)
at server.Start.run(Start.java:37)
at server.Start.main(Start.java:181)
Press any key to continue . . .
Preparing...
Importing SQL.sql...
Finished executing script
ERROR 1031 (HY000) at line 4330: Table storage engine for 'alliances' doesn't have this option
Operation failed with exitcode 1