[Mini-Release]Fraternities I know this is a very small release

[Shoot]

Well I fell in love with this idea ever since i saw it on the old B12MS.
For those of you that have played it, i'm talking about his "Legions".
I am releasing this because I quit on my server as I got thinking that ive spent
way to much time on this computer and i should go out more.

Well if you do not know how to modify this so it looks better on your server
and don't want it to be the same as those 2 player servers (Admin+1 GM) then
feel free but do not ask me how as this is very easy to do
took me about 10 minutes.

*Hint: I will not tell you where to add it as you should already know.*

Ok lets get started

Execute this sql

ALTER TABLE `characters` ADD COLUMN `fraternityid` int(10) NOT NULL DEFAULT '0';

Open NetBeans

go to

odinms.client
open MapleCharacter.java and add this int

    private int fraternityid;

then add this *also in maplechar.java*

        ret.fraternityid = rs.getInt("fraternityid");

also add this

        ret.fraternityid = 0;

Change this block looking thing to

            if (update) {
                ps = con.prepareStatement("UPDATE characters SET level = ?, fame = ?, str = ?, dex = ?, luk = ?, `int` = ?, exp = ?, hp = ?, mp = ?, maxhp = ?, maxmp = ?, sp = ?, ap = ?, gm = ?, skincolor = ?, gender = ?, job = ?, hair = ?, face = ?, map = ?, meso = ?, hpApUsed = ?, mpApUsed = ?, spawnpoint = ?, party = ?, buddyCapacity = ?, messengerid = ?, messengerposition = ?, reborns = ?, pvpkills = ?, pvpdeaths = ?, mountlevel = ?, mountexp = ?, mounttiredness= ?, blessed = ?, married = ?, engager = ?, karma = ?, fraternityid = ? WHERE id = ?");
            } else {
                ps = con.prepareStatement("INSERT INTO characters (level, fame, str, dex, luk, `int`, exp, hp, mp, maxhp, maxmp, sp, ap, gm, skincolor, gender, job, hair, face, map, meso, hpApUsed, mpApUsed, spawnpoint, party, buddyCapacity, messengerid, messengerposition, reborns, pvpkills, pvpdeaths, mountlevel, mounttiredness, mountexp, blessed, married, engager, karma, fraternityid, accountid, name, world) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
            }

this is the ThePack one since i knoow most of the people in here are leeching and using ThePack.
Because the people that are not using ThePack will see whats different from theirs and add it in its pretty obvious.

Change your block like this one to

Spoiler

            } else {
                ps.setInt(1, level);
            }
            ps.setInt(2, fame);
            ps.setInt(3, str);
            ps.setInt(4, dex);
            ps.setInt(5, luk);
            ps.setInt(6, int_);
            if (exp.get() > 2147483647 || exp.get() < 0) {
                ps.setInt(7, 0);
            } else {
                ps.setInt(7, exp.get());
            }
            ps.setInt(8, hp);
            ps.setInt(9, mp);
            ps.setInt(10, maxhp);
            ps.setInt(11, maxmp);
            ps.setInt(12, remainingSp);
            ps.setInt(13, remainingAp);
            ps.setInt(14, gmLevel);
            ps.setInt(15, skinColor.getId());
            ps.setInt(16, gender);
            ps.setInt(17, job.getId());
            ps.setInt(18, hair);
            ps.setInt(19, face);
            if (map == null) {
                ps.setInt(20, 0);
            } else if (map.getId() == 220080001) {
                ps.setInt(20, 220080000);
            } else if (map.getId() == 240060200) {
                ps.setInt(20, 240040700);
            } else if (map.getId() == 280030000) {
                ps.setInt(20, 211042300);
            } else if (map.getId() > 910000000 && map.getId() <= 910000022 || isPvPMap()) {
                ps.setInt(20, 910000000);
            } else if (map.getId() >= 809050000 && map.getId() <= 809050015) {
                ps.setInt(20, 809050016);
            } else if (map.getId() >= 103000800 && map.getId() <= 103000805) {
                ps.setInt(20, 103000890);
            } else if (map.getId() >= 990000100 && map.getId() <= 990000900) {
                ps.setInt(20, 990001100);
            } else if (map.getId() >= 280010000 && map.getId() <= 280011006) {
                ps.setInt(20, 280090000);
            } else {
                ps.setInt(20, map.getId());
            }
            ps.setInt(21, meso.get());
            ps.setInt(22, hpApUsed);
            ps.setInt(23, mpApUsed);
            if (map == null || map.getId() == 610020000 || map.getId() == 610020001) {
                ps.setInt(24, 0);
            } else {
                MaplePortal closest = map.findClosestSpawnpoint(getPosition());
                if (closest != null) {
                    ps.setInt(24, closest.getId());
                } else {
                    ps.setInt(24, 0);
                }
            }
            if (party != null) {
                ps.setInt(25, party.getId());
            } else {
                ps.setInt(25, -1);
            }
            ps.setInt(26, buddylist.getCapacity());
            if (messenger != null) {
                ps.setInt(27, messenger.getId());
                ps.setInt(28, messengerposition);
            } else {
                ps.setInt(27, 0);
                ps.setInt(28, 4);
            }
            ps.setInt(29, reborns);
            ps.setInt(30, pvpkills);
            ps.setInt(31, pvpdeaths);
            if (maplemount != null) {
                ps.setInt(32, maplemount.getLevel());
                ps.setInt(33, maplemount.getExp());
                ps.setInt(34, maplemount.getTiredness());
            } else {
                ps.setInt(32, 1);
                ps.setInt(33, 0);
                ps.setInt(34, 0);
            }
            if (blessed) {
                ps.setInt(35, 1);
            } else {
                ps.setInt(35, 0);
            }
            if (married) {
                ps.setInt(36, 1);
            } else {
                ps.setInt(36, 0);
            }
            ps.setString(37, engager);
            ps.setInt(38, karma);
            ps.setInt(39, fraternityid);
            if (update) {
                ps.setInt(40, id);
            } else {
                ps.setInt(40, accountid);
                ps.setString(41, name);
                ps.setInt(42, world);
            }

Again like before this is the common thepack block thingy
And also add this

    public int getFraternityid() {
            return fraternityid;
    }

And this

    public void setFraternityid(int fraternityid) {
        this.fraternityid = fraternityid;
    }

Open NpcConversationManager.java (so you can make an npc that lets people choose their fraternity)

Add this

    public void setFraternity (int fraternityid){
            getPlayer().setFraternityid(fraternityid);
}

[/done]

You can modify this in any way.
If you want to make it so if it checks which fraternity you are in
so when u login it gives you different buffs when you login
go ahead
dont ask me.

i felt like i needed to release something to the community for helping me when i began.​

Don't flame this is my first release
i am Leaf Story also its just that i gotz banned lol

 

[Spyker710]

Hm, so basically what this is, it gives everyone a group ID, and different groups get different things like, as you suggested, buffs when they log in, or discounts at shops, or stuff like that?

I guess you could use this any way you want, I never really thought of this...thanks for the idea!

 

[JusticeDK]

i dont get it much.... lol

 

[Shoot]

Hm, so basically what this is, it gives everyone a group ID, and different groups get different things like, as you suggested, buffs when they log in, or discounts at shops, or stuff like that?

I guess you could use this any way you want, I never really thought of this...thanks for the idea!

Yeah i fell in love with the idea when i saw it in B12Ms but then i asked B12 please tell me how you made it until i actually came to my turning point and stopped leeching and found out how to do it.

i dont get it much.... lol

what Spyker said lol

 

[`The One]

Very nice, How is it a very small release

 

[purpleNblack2]

then i guess from what Spyker said, its a nice release i guess >o<

 

[Spyker710]

Very nice, How is it a very small release

It's only small if you make it small.

It's only big if you make it big.

 

[Shoot]

Because it took me about 10 mins to finish lol T_T

yeah what spyker said

its small if you leave it as is

if you want to make it big,
then edit it :#

 

[`The One]

Alright,

 

[AzuS]

Hmmm...So this is like college? xD!!

Its like your in a group, and you get buffs due to the group your in...

Sounds cool xD!

Edit: Ima assume your "The One" is Danny?

 

[Spyker710]

ii dont get tthis ..

Basically you can do anything to someone who has a certain fraternity ID.

 

[Shoot]

yeah lol :3

also if you use this on your server link me i want to see.

 

[EspadaFung]

so what is 'fraternityid'?

>.> u just add the it into the database but no functions for it? :X

 

[Shoot]

T_T do the whole thing and as you can see in the posts that you can do what ever you want.

 

[blogworm]

fraternityid is like guildid.

It's like a guild without a name, I guess. But they get special privelages.

nice release btw.

 

[Shoot]

thx and you can name em in the NPC ;3

 

[maplepuppet]

Ewwwww. LeafStory

 

[Vakarian]

Ewwww. Maplepuppet.


Nice release, Leaf.

 

[iamSTEVE]

Ewwww. A giant faggot who thinks he's cool because he learned how to make shitty NPCs.


Nice release, Leaf.

Fixed for ya.
Shoot, might wanna add more, right now it's just a number assigned to each character..of course people who semi-know what theyre doing can build on it pretty easily..

 

[Shoot]

lol thx
and i want to thank B12 for not helping me when i asked him how he did this.
if he would of told me i would've just leeched it and not of actually understood java :#