[RELEASE] Biesmen's re-pack v.01 BETA [TitanMS v55] * REBIRTH ADDED + GM LIST

[Justinxvengance]

take off the exp capp,
you know the thing so you can get more than 1 lvl at a time

[Biesmen]

Oh well.. :/

I'll make a clean database, without any accounts, maybe it will be fixed...

Use this database :

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);

Anyways, thanks guys. If it still won't work tell me..

P.S. change in World.ccp the ID to 0

Fixed world.ccp ( Download the attachement )
Or the link : Fixed Worlds.ccp

Biesman I get this error

What did you do? Did you get in a portal, used a command? What?

[OmerNoto]

Dude ummm u got KPQ but not KPQ in SQL File can u give like the code (I am a Noob so dont mind my language)

[Biesmen]

KPQ is coming later, I don't see the point of KPQ o.O, It isn't with a party..

[OmerNoto]

I Just wanted to check it and then I got MySQL Error with Missing kerningpq stuff can u post it so i can check it?

[Biesmen]

I think so..

CREATE TABLE `pqkerning` (
  `id` int(1) NOT NULL,
  `aplayers` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Is the database for Kering PQ

[AtlasRune]

http://img162.imageshack.us/img162/2...tifactsqu5.jpg

I originally got an error saying that it couldn't connect with the sql server because of bad "root" password, but I was able to fix that, and now it just wont connect...

Any ideas on why?

[Biesmen]

Did you changed MySQLM.ccp ?

And is the host
localhost?
ID : root?
PW : ?
( Without the "?" )

[AtlasRune]

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

The root password is mangos.

[Biesmen]

I never had or saw this error before.. Maybe you could post this in support thread..

Try this one, and see if it works, I don't think so :

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

[Biesmen]

Sorry for double post, guys checkout the support thread

http://forum.ragezone.com/showthread.php?t=416487

If there is something wrong, you can post it there too.

[nhed57]

can somebody post a compiled one?

[Biesmen]

Compiled one for what?

[AtlasRune]

I am guessing a compiled exe of the stuff....

[Biesmen]

Lol ?? :S BTW did it worked at you, AtlasRune?