adrian12's Blog

well all versions.

53 ima make 1 of 55 or 58

put localhost on your maplestory folder

Problem - I cannot enter any portals with Monster in them.

Answer - Put in the v.54 mobs.wz in the wz folder

*links will be provided later on

Problem - When I make a Guild it says, "Guild Name is already taken"

Answer - Do not register with your admin account if you only have a GM account in your db.

Problem - When I log in, It says the Id is registered, I check the query browser, AND IT IS!

Answer - Execute these commands in query.
Code:

ALTER TABLE accounts ADD tempban TIMESTAMP AFTER `banned`;
ALTER TABLE accounts ADD greason TINYINT(4) AFTER `tempban`;

Problem - I GET CONNECTION REFUSED ON HOST BLAH BLAH BLAH

Answer - Close all the other ports, Put 1 - 9999 on one line.

Problem - Port 1099 is already in use!

Answer - IE uses that port, Close out all the programs, If that doesn't work, restart your computer.

Question - It says "unknown column "masterlevel""

Answer - Execute this query command.
Code:

ALTER TABLE `skills` ADD COLUMN `masterlevel` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `skilllevel`;

Theorys

Problem - I press the login button on the game, and 20 seconds later I get a "connection to server ended."

Answer - You didn't put the Unlimited Strength Files in the right place.

Java\jdk1.6.0_10\jre\lib\security\ <--- Put it there.

Java\jre1.6.0_06\lib\security\ <--- Put it there.

Fixing Transparent item bug-Fix the transparent item bug when you use !item with the wrong ID.

Quote:
UPDATE inventoryitems
SET itemid = 2022179 WHERE (itemid=xxxxxxx);
Just change de xxxxxxx by the ID that bugged you.

Then go in-game and drop all Onyx Apples from your inventory.

Innovative's Fixes

Q:How do I fix the DC'ing issue when I select my character?
A:Make sure you have port forwarded the correct ports, and also try disabling your firewall, or allow incoming connections on ports 8484 and 7575, or in some cases 7576.

Q:I am unable to connect to my MySQL Browser
A:Upon installing MySQL Tools, you will be prompted to change the default "root" settings. In my guide, I told you to uncheck the box and do not edit it. If you have, use the password you have specified.

Q:How do I change the limit of players that are allowed to login?
A:Open up "world.properties" and find "net.sf.odinms.login.interval=500". Change the "500" to your desired number.

Q:How do I add accounts?
A:Check my guide for a registration page!

Q:Where do I put localhost.exe?
A:Put it into your MapleStory folder and just run it as usual. If you have your server online it should connect.

Q:I am unable to open my localhost.exe
A:This is because all antivirus programs scans for IP address' and since hexed clients have an IP address in them, it detects it as a Trojan Horse. The best way to bypass this is to allow the program pass the check, or to completely disable your antivirus.

Q:How do I make my other account a GM or others a GM?
A:Go to your "odinms" database and open up the "accounts" table. In the GM column, set the value to 1 relative to which account you want to be allowed GM access. Next, open up the "characters" table and in the GM column, also set a 1 relative to which character you are allowing GM commands to be used from.
The "1" in the "accounts" table allows that certain account to login, even if the max limit of logins is reached.
The "1" in the "characters" table allows that certain character to use GM commands.

Q:Im getting random blocks of errors while running my .bats!
A:As long as it doenst cause a crash or affect the running of the server, its fine. Apparently it is something to do with the "mina-core.jar"

Q:My world.bat stays blank, is this meant to happen?
A:Yes, something will pop-up in the black box after you have opened up the other two .bat's as long as you have port forwarded.

Q:I cant get past the login screen!
A:Make sure you have pasted the JCE Files correctly. You should have replaced some files. Scroll to the bottom.
Download JCE Files

Q:I heard there was a skill maxing NPC, where is he/she?
A:This is a clean version of revision 947 - I will post a guide on how to apply patches soon.

Q:AHHH! When I open my .bat's I get an error!
A:Usually, on the first few lines of the error, there is the error itself explaining. It pretty much is in plain english.
I quote from KZSH's Post:

Quote:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown database 'odinms'

This means there is not such database called "odinms"
So re-make your database and make sure it is called "odinms"

Q:Help, I get:

Quote:
MySQL Error Number 2003
Can't connect to MySQL server on 'localhost' (10061).

How do I fix it!
A: Change the port to 3306

Q:How do I portforward a modem!?
A:You dont have to - Just make sure you have the Unlimited Strength JCE Files in the jdk and jre folders. [Refer to Setting up!]

Q:I get this error when running my localhost.exe "The application has failed to start because ijil15.dll was not found..."
A:This is a very serious error, you will have to throw your computer out of the window and jump on it a few times...
Naw, just put it into your MapleStory folder.

Q:Help I am STILL stuck at the login screen!
A:Make sure you have pasted the JCE files correctly, and remember you have to port forward if you're behind a router and to turn off your firewall - Or allow incoming connections on ports 7575 and 8484

Q:Is it possible to use a Dynamic IP for the server?
A:I have yet to try this, but I think it may be possible. Make yourself a VERY short No-Ip domain, and hex that into your client.
And from time to time - Update it with the No-IP download they provide for you.

Q:Help! I get error code : -2147287038 (Unknown error 0x80030002)
A:Replace my 0.54 Mob.wz file with yours. - However, make sure the rest are 0.55.

Q:Monsters dont move! What do I do?
A:Right click the top right icon - Its hide :P

Q:I cant login to the admins account!
A:Try it with lower-case :P

Q:I keep having massive roll-backs!
A: Dont forcibly close your server .bats by clicking the "X" - Login and type !shutdown

Xcross87's fixes.

1) Error: Cipher not initialized
- The connection to the server ended.
Cause: wrong JCE files
Solution:
Download here
And then, extract it, put 2 files JAR inside pack into these folders carefully,
Code:

C:\Program Files\Java\jre6\lib\security
C:\Program Files\Java\jdk1.6.0_10\jre\lib\security

2) Error: Java is not recognized as an internal or external command
Cause: java binary environment is not set
Solution:
Control Panel -> System -> Advanced tab
Click on Environment Variables
Look at the below fieldset, System FieldSet
Find value PATH or Path, double-click on it and add the Java binary folder location at the end
Code:

;C:\Program Files\Java\jdk1.6.0_10\bin

3) Error: In character selection screen, you click and nothing happen, you cannot play game or do anything else, except go Back and Exit
Cause: Unknown column 'masterlevel'
Reason: use wrong db file of different rev pack
Solution:
1. use this script for MySQL Server:
Code:

ALTER TABLE `skills` ADD COLUMN `masterlevel` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `skilllevel`;

2.follow exactly instruction of each server setup guide, and import db correctly again. You'd better restart MySQL if something is change on its

4) Error: when you play game, cannot move, or cannot change map ....
Cause: server launch is not started correctly or bug
Solution:
1. Turn game server off.
2. Launch world.bat, login.bat, channel.bat respectively, wait for 5-7 seconds to open the next files, don't rush right here
3. In case, still error, you'd better report to the packer about the bug, it may be fixed next at next package.

5) Error: java 'main' method is not found
Cause: whether java is installed improperly, or command call is wrong
Solution:
1. Reinstall Java and run, if it still errs, step 2.
2. Open the bat file that shows error using Notepad or any Text Editor, replace all '.java' with null
If use Notepad, menu Edit->Replace:
Find: .java
Replace: (don't write anything here)
then replace all

6) Error: Unknown column 'tempban' .....blah blah
Cause: database is not updated well.
Solution:
run this script
Code:

ALTER TABLE `accounts` ADD COLUMN `tempban` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `banned`;
ALTER TABLE `accounts` ADD COLUMN `greason` INTEGER UNSIGNED NULL AFTER `tempban`;

7) Error: Unknown column 'nxCash' .... blah blah
Cause: database table 'accounts' is not updated and table 'nxCode' is not created
Solution:
run this script
Code:

-- ==================
-- ACCOUNTS NXCASH FIX
-- ==================
ALTER TABLE `accounts` ADD COLUMN `nxCash` int(11);
ALTER TABLE `accounts` ADD COLUMN `mPoints` int(11);
ALTER TABLE `accounts` ADD COLUMN `gTokens` int(11);

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for nxcode
-- ----------------------------
DROP TABLE IF EXISTS `nxcode`;
CREATE TABLE `nxcode` (
`code` varchar(15) NOT NULL,
`valid` int(11) NOT NULL default '1',
`user` varchar(13) default NULL,
`type` int(11) NOT NULL default '0',
`item` int(11) NOT NULL default '10000',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `nxcode` VALUES ('710778C56D21651', '1', '', '0', '10000');

8) Error: Unknown column 'messengerid' ..... blah blah
Cause: table 'characters' is not updated
Solution:
run this script
Code:

-- ==========================
-- CHARACTERS MESSENGERID FIXED
-- ==========================
ALTER TABLE `characters` ADD `messengerid` INTEGER UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `characters` ADD `messengerposition` INTEGER UNSIGNED NOT NULL DEFAULT 4;

9) Error: An existing connection was forcibly closed by remote host
Cause: server is not started properly.
Solution:
1. Restart your web server (apache, abyss ... whatever restart service)
2. Launch world.bat -> login.bat -> channel.bat;
Warning: NEVER RUSH WHEN LOADING SERVER, PLEASE JUST WAIT FOR ONLY 5 SECONDS BETWEEN EACH FILE (*.BAT) IF YOU WANT TO WORK ON SERVER !!!

10) Error: Connection refused ...... blah blah
Cause: client and server cannot run on same ip
Solution:
You can use my localhost file: Download LocalHost
- I put a BAT file inside
if you just want to test or run local, don't edit anything
if you want to spread server to internet, open with Notepad and replace 'localhost' with your server ip.

11) Error: localhost.exe - Unable locate component ....
Cause: Localhost is running improperly by a dummy....
Solution:
- Download MapleGlobal from Nexon website and install
- Put your localhost.exe inside MapleStory folder
- Run and see the next Error :D

12) Error: Address already in use (binding .....) ....blah blah
Cause: port service is already used.
Solution:
-- 3 ways
a) find the service that run on port confliction and stop it
b) find the number of channel which causes error, open odinms database. lookup table channel and change channel's port
c) like b but no touch to database, open channel.properties delete or comment the line of channel causes error

13) Error: you're playing....auto disconnect ...login again, you're banned ..
Cause: autoban mode is activate
Solution:
run this script:
Code:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ipbans`
--

DROP TABLE IF EXISTS `ipbans`;
CREATE TABLE `ipbans` (
`ipbanid` int(10) unsigned NOT NULL auto_increment,
`ip` varchar(40) NOT NULL default '',
PRIMARY KEY (`ipbanid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ipbans`
--

LOCK TABLES `ipbans` WRITE;
/*!40000 ALTER TABLE `ipbans` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipbans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `iplog`
--

DROP TABLE IF EXISTS `iplog`;
CREATE TABLE `iplog` (
`iplogid` int(10) unsigned NOT NULL auto_increment,
`accountid` int(11) NOT NULL default '0',
`ip` varchar(30) NOT NULL default '',
`login` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`iplogid`),
KEY `accountid` (`accountid`,`ip`),
KEY `ip` (`ip`),
CONSTRAINT `iplog_ibfk_1` FOREIGN KEY (`accountid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `iplog`
--

LOCK TABLES `iplog` WRITE;
/*!40000 ALTER TABLE `iplog` DISABLE KEYS */;
/*!40000 ALTER TABLE `iplog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macbans`
--

DROP TABLE IF EXISTS `macbans`;
CREATE TABLE `macbans` (
`macbanid` int(10) unsigned NOT NULL auto_increment,
`mac` varchar(30) NOT NULL,
PRIMARY KEY (`macbanid`),
UNIQUE KEY `mac_2` (`mac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `macbans`
--

LOCK TABLES `macbans` WRITE;
/*!40000 ALTER TABLE `macbans` DISABLE KEYS */;
/*!40000 ALTER TABLE `macbans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macfilters`
--

DROP TABLE IF EXISTS `macfilters`;
CREATE TABLE `macfilters` (
`macfilterid` int(10) unsigned NOT NULL auto_increment,
`filter` varchar(30) NOT NULL,
PRIMARY KEY (`macfilterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `macfilters`
--

LOCK TABLES `macfilters` WRITE;
/*!40000 ALTER TABLE `macfilters` DISABLE KEYS */;
INSERT INTO `macfilters` VALUES (1,'00-50-56-.{2}-.{2}-.{2}'),(2,'02-00-4C-4F-4F-50'),(3,'7A-79-00-.{2}-.{2}-.{2}'),(4,'00-03-8A-.{2}-.{2}-.{2}');
/*!40000 ALTER TABLE `macfilters` ENABLE KEYS */;
UNLOCK TABLES;

/*!50001 DROP TABLE IF EXISTS `readable_last_hour_cheatlog`*/;
/*!50001 DROP VIEW IF EXISTS `readable_last_hour_cheatlog`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `readable_last_hour_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,sum(`cl`.`count`) AS `numrepos` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`cid` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (timestampdiff(HOUR,`cl`.`lastoffensetime`,now()) < 1) and (`a`.`banned` = 0)) group by `cl`.`cid` order by sum(`cl`.`count`) desc */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

14) Error: error code:-2147287038(Unknown error 0x80030002) --> CRASHING
Cause: wrong data file for games (WZ)
Solution:
- if you use SeanPack v5, you use Mob.wz v55 (NOT v54)
- otherwise, use Mob.wz v54
- if still, use different repack, make sure you set up everything properly.

15) Error: Exception: World Registry ..... lbah blah
Cause: commonly from misconfiguration or blocking from firewall with RMI access.
Solution:
- restart computer
- check your rmi package in jdk folder, make sure it exists
- turn off firewall or open firewall and let RMI Registry port (default is 1099) allowed
- if still, download new JDK and JRE from Sun and install
- if still, send me private message !

16) Error: IndexOutOfBoundException: -2 , -3, -x , ... blah blah
Cause: Number of channel loads is over limitation
Solution: open channel.properties
Check for this:
Code:

# number of channels to host in this process
net.sf.odinms.channel.count=2
# channel keys
# (these are defined in the channels table)
net.sf.odinms.channel.0.key=release1
net.sf.odinms.channel.1.key=release2

if count = 2 then --> channel release is up to 2
...
if count = N then --> channel release is up to M
Make sure they are equal

If you receive any error, post here, I'll try to help.

on my next post it will be of titan and seanrepack