[Release] JunMS repack V5.1-Based on TitanMS verison 0.0.8B

[pokkax]

JUNMS Repack-V5.1
For version 5.1
-Based on TitianMS Verison 0.0.8B


In MySQLM.cpp
Replace:

int MySQL::connectToMySQL(){
	if(!mysql_real_connect(&maple_db, "localhost", "root", "", "junms", 3306, NULL, 0)){
		printf(mysql_error(&maple_db));
		return 0;
	}
	return 1;
}

to

int MySQL::connectToMySQL(){
	if(!mysql_real_connect(&maple_db, "localhost", "root", "", "maplestory", 3306, NULL, 0)){
		printf(mysql_error(&maple_db));
		return 0;
	}
	return 1;
}

Place your maplestoryserver.exe

Not in JunMS folder!!!

But in Maplestoryserver folder











Used:
[Release]TitanMS Releases (ver. 0.0.8B )






Update:

Removed !horntail
Removed summon Horntail<Trying to fix(with animation)>





Added:
[Release] Improved Summoning System
[Release] Spinel warps to/from Mushroom Shrine and to Showa.
[Release] All Teleporter NPC's with GlobalMS Scripts. (Version 3 Released!)
[Release] Cosmetic NPCs [Henesys, Ludibrium, Orbis, more to come]
[RELEASE] !usersonline & Announcement of Users Logging on and off.
All job NPC working
Megaphone

Working:
Scrolls
Megaphone-Spiegelmann Selling it....
All job NPCs-1st 2nd 3rd 4th
Cosmetic NPC
Spinel
Taxi
Cody-VIP Teleporter
most 1st n 2nd job skill fixed....
others not yet......



Not working:
Fame-Not added
Mount-Haven test
Horntail Summoing code
Horntail map NPC-Crystal
White scrolls
GM Hide
Hide

Almost all Skills:
Mesos Explode
Hurricane





Commands:
!gmmap
!warpall
!mwarpto
!warpto
!warp
!xprate
!notice
!notice2
!header
!pos
!item
!map
!summon
!shopcoupons
!megaphone
!cleardrops
!addsp
!level
!mesos
!job
!ap
!sp
!killnpc
!killall
!usersonline
!kill





Download link:
JunMS V5.1




Note:Use Autorestarter after compiling...
After compiling JunMS,Go to the Release Folder and look for MapleStoryServer.exe
Replace the old MapleStoryServer.exe in JunMSv4\MapleStoryServer
*Autorester should be added*


Credits:
Koolk
iGoofy
toxicwind
chiasoft
zids
Zagete
stefkeh
Omrikun
And many more....adding soon!



Please use navicat!
Note:Please use My new Datebase

Download:
JunMS V5.1 Database Sql files

create table users(ID int auto_increment primary key, username varchar(20), password varchar(20), pin int default 0, gender int default 0, gm int default 0);
 
create table characters(ID int auto_increment primary key, name varchar(12), userid int, level tinyint unsigned default 1, job smallint default 0, str smallint, dex smallint, intt smallint, luk smallint, chp smallint default 50, mhp smallint default 50, cmp smallint default 50, mmp smallint default 50, ap smallint default 0, sp smallint default 0, exp int default 0, fame smallint default 0, map int default 0, pos smallint default 0, gender tinyint, skin tinyint, eyes int, hair int, mesos int default 0); 
 
create table equip(equipid int, type tinyint, charid int, pos smallint default 0, slots tinyint default 7, scrolls smallint default 0, istr smallint default 0, idex smallint default 0, iint smallint default 0, iluk smallint default 0, ihp smallint default 0, imp smallint default 0, iwatk smallint default 0, imatk smallint default 0, iwdef smallint default 0, imdef smallint default 0, iacc smallint default 0, iavo smallint default 0, ihand smallint default 0, ispeed smallint default 0, ijump smallint default 0);
 
create table items(itemid int, charid int, inv tinyint, pos smallint, amount smallint);
 
create table keymap(charid int, pos0 int default 0, pos1 int default 0, pos2 int default 2564, pos3 int default 3076, pos4 int default 3332, pos5 int default 4612, pos6 int default 5380, pos7 int default 0, pos8 int default 0, pos9 int default 0, pos10 int default 0, pos11 int default 0, pos12 int default 0, pos13 int default 0, pos14 int default 0, pos15 int default 0, pos16 int default 2052, pos17 int default 1284, pos18 int default 4, pos19 int default 1028, pos20 int default 0, pos21 int default 0, pos22 int default 0, pos23 int default 260, pos24 int default 0, pos25 int default 4868, pos26 int default 3588, pos27 int default 3844, pos28 int default 0, pos29 int default 13317, pos30 int default 0, pos31 int default 516, pos32 int default 0, pos33 int default 0, pos34 int default 3456, pos35 int default 2820, pos36 int default 0, pos37 int default 772, pos38 int default 0, pos39 int default 5124, pos40 int default 4100, pos41 int default 0, pos42 int default 0, pos43 int default 2308, pos44 int default 12805, pos45 int default 13061, pos46 int default 1540, pos47 int default 0, pos48 int default 0, pos49 int default 0, pos50 int default 1796, pos51 int default 0, pos52 int default 0, pos53 int default 0, pos54 int default 0, pos55 int default 0, pos56 int default 13573, pos57 int default 0, pos58 int default 0, pos59 int default 25606, pos60 int default 25862, pos61 int default 26118, pos62 int default 26374, pos63 int default 26630, pos64 int default 26886, pos65 int default 27142, pos66 int default 0, pos67 int default 0, pos68 int default 0, pos69 int default 0, pos70 int default 0, pos71 int default 0, pos72 int default 0, pos73 int default 0, pos74 int default 0, pos75 int default 0, pos76 int default 0, pos77 int default 0, pos78 int default 0, pos79 int default 0, pos80 int default 0, pos81 int default 0, pos82 int default 0, pos83 int default 0, pos84 int default 0, pos85 int default 0, pos86 int default 0, pos87 int default 0, pos88 int default 0, pos89 int default 0);
 
create table skills(charid int, skillid int, points int); 

alter table characters change exp exp int default 0 

ALTER TABLE  `characters` ADD  `online` INT( 1 ) NOT NULL DEFAULT  '0';

ALTER TABLE characters ADD origin INT DEFAULT 0 AFTER map; 

ALTER TABLE `users` ADD `ban_expire` DATETIME NOT NULL DEFAULT 0,
ADD `ban_reason` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '0'; 

alter table characters add gotpack int default 0; 

Note:Not in use yet!

ALTER TABLE characters add fameadded int default 0; 

Report any bugs here!

Known Bugs:
Mobs doesnt spwan other mobs when they die
Random Server Crash...<happen to me.Either is a GM type wrong or...>

[MentaL]

[KillShadow05]

Very nice, i guess. I bet a lot of people will use this xD

[pokkax]

Very nice, i guess. I bet a lot of people will use this xD

ya...

[zander145]

lol, Not meny ppl have seen this yet i bet so ima get ahead of them xD
Is combo added in this or do i have to add it myself?

[jpxip]

so stop makin this so some mod or adminkistrator can make a repack section

[ctZ'...]

damn, not another stupid repack, anyways some poeple will use it, good luck.

[jasonpwns]

CTZ I don't have time to script everything even though I know how to this just saves me time.

[DeathEx]

What's the commands you say your supposedly using a combined. Soo whats the commands?

[jasonpwns]

gg notice dont work.

[Exodias]

*enough with the repacks
*this isn't even a great re-pack
*the commands will get mess up
*will have bugs from different database

[sanchit]

CAN ANY1 TEACH me how to use it i just made a new database and deleted all the files and replaced them with the repacks and then when i use the restarted i get a error in side sayting eroor in getSQL returned no rows >mql error unkwon colunm ban expire in field list sql quesry selcet ban_expire now from users where id=1 accept any1 know how to fix it

[Sparks]

this takes FOREVER to recomplie >.>

[lws8]

Why when i click my character i am back to login screen? =x
Someone reply, thanks.

[FlowMotion]

another repack that has disconnecting problems now congratz its totally pointless to keep downloading repacks of modifed packs because there all using the same bugs that still have to be fixed.

exsample: Timer.cpp & possibley the Decoder.cpp

[Sparks]

ok lws8 2 things. 1. That statement was quite rude. Don't tell people what to do. 2. ASK for a reply. (i understand you can't speak good english but still)

And finally. reason why you can't do that is cause you have to change your IP in LoginPacket.cpp