Players can't add GMs to buddylist

[flav]

BuddylistModifyHandler.java
Add

Connection con = DatabaseConnection.getConnection();
            try {
                PreparedStatement ps = con.prepareStatement("SELECT * FROM characters WHERE gm > 0 AND name = ?");
                ps.setString(1, addName);
                ResultSet rs = ps.executeQuery();

                if (rs.next() && !player.isGM()) {
                    player.dropMessage(1, "Gamemaster is not available as a buddy.");
                    return;
                }

                rs.close();
                ps.close();
            } catch (SQLException sqlE) {}

Under

String addName = slea.readMapleAsciiString();

 

[Shogi]

Thanks, that very useful and gms-like added!

C:\Users\אור לייזר\Documents\NetBeansProjects\MapleDev\src\net\sf\odinms\net\channel\handler\BuddylistModifyHandler.java:75: cannot find symbol
symbol : method isGM()
location: class net.sf.odinms.client.MapleCharacter
if (rs.next() && !player.isGM()) {
C:\Users\אור לייזר\Documents\NetBeansProjects\MapleDev\src\net\sf\odinms\net\channel\handler\BuddylistModifyHandler.java:107: con is already defined in handlePacket(net.sf.odinms.tools.data.input.SeekableLittleEndianAccessor,net.sf.odinms.client.MapleClient)
Connection con = DatabaseConnection.getConnection();
C:\Users\אור לייזר\Documents\NetBeansProjects\MapleDev\src\net\sf\odinms\net\channel\handler\BuddylistModifyHandler.java:140: con is already defined in handlePacket(net.sf.odinms.tools.data.input.SeekableLittleEndianAccessor,net.sf.odinms.client.MapleClient)
Connection con = DatabaseConnection.getConnection();

3 errors.

 

[ItzMe]

Thanks, that very useful and gms-like added!

how the fuck can u know its gms-like
u event dont know a NAME of a GM in global
nice release btw

 

[Shogi]

IN THE BETA VERSION WE KNEW IT, AND EVEN WE U TRY TO ADD GM U CANT, flammer.

 

[flav]

how the fuck can u know its gms-like
u event dont know a NAME of a GM in global
nice release btw

Go in Bera and try to add "Bera" to your buddylist and there is also a GM list on the Nexon forums anywhere. If you play EMS try to add "GMMango".

C:\Users\אור לייזר\Documents\NetBeansProjects\MapleDev\src\net\sf\odinms\net\channel\handler\BuddylistModifyHandler.java:75: cannot find symbol
symbol : method isGM()
location: class net.sf.odinms.client.MapleCharacter
if (rs.next() && !player.isGM()) {
C:\Users\אור לייזר\Documents\NetBeansProjects\MapleDev\src\net\sf\odinms\net\channel\handler\BuddylistModifyHandler.java:107: con is already defined in handlePacket(net.sf.odinms.tools.data.input.SeekableLittleEndianAccessor,net.sf.odinms.client.MapleClient)
Connection con = DatabaseConnection.getConnection();
C:\Users\אור לייזר\Documents\NetBeansProjects\MapleDev\src\net\sf\odinms\net\channel\handler\BuddylistModifyHandler.java:140: con is already defined in handlePacket(net.sf.odinms.tools.data.input.SeekableLittleEndianAccessor,net.sf.odinms.client.MapleClient)
Connection con = DatabaseConnection.getConnection();

3 errors.

For the first one add this in your MapleCharacter.java :

public boolean isGM() {
        return gmLevel >= 1;
    }

For the other ones just comment the lines out, it is already defined at top now.

 

[Shogi]

                PreparedStatement ps = con.prepareStatement("SELECT * FROM characters WHERE gm > 0 AND name = ?");

not should be gm > 1 ?

 

[flav]

                PreparedStatement ps = con.prepareStatement("SELECT * FROM characters WHERE gm > 0 AND name = ?");

not should be gm > 1 ?

gm > 1 would mean level 2+ but level 1 is also GM, at least in my source.

 

[seryi]

I prefer to make name with symbols.. so they can't PM me either

 

[Shogi]

gm > 1 would mean level 2+ but level 1 is also GM, at least in my source.

oh, i get it..
what to do with the 2 other errors?
didnt get it..

 

[CharlieBoy]

how the fuck can u know its gms-like
u event dont know a NAME of a GM in global
nice release btw

Some one got a bad day or period blood 0.0?
Or just wanna flame to incresse ur post counte?

 

[Xerixe]

Why not just do it this way?
Its shorter and saves time
Below
MapleCharacter otherChar = c.getChannelServer().getPlayerStorage().getCharacterByName(addName);

Add

if (otherChar.isGM()) {
                        return;
                    }

 

[flav]

Why not just do it this way?
Its shorter and saves time
Below
MapleCharacter otherChar = c.getChannelServer().getPlayerStorage().getCharacterByName(addName);

Add

if (otherChar.isGM()) {
                        return;
                    }

It has a good reason that I didn't do it like that, what if "otherChar" is offline?

 

[ItzMe]

Some one got a bad day or period blood 0.0?
Or just wanna flame to incresse ur post counte?

both lawl
xDD

EDIT: i was accepted as a gm for TropixStory
and than they say im declined -.-

 

[Ehab]

good release
gonna test now.

 

[ProGamerForLife]

Meh
i know some gms in bera
and well those niggas wont accept me =[
so this is gms alike =[

 

[Ehab]

AverixBer, VectorBe, Bera, MintPowder, gmscody... those are the GMs THAT I KNOW in bera

TiaraYellond in yellonde too


oh and Next in Scania and KhainiHammer in Khaini

 

[Ehab]

btw here's my way to do that

Connection gmcheck = DatabaseConnection.getConnection(); // used gmcheck instead of con because it gets error
            try {
                PreparedStatement ps = gmcheck.prepareStatement("SELECT * FROM characters WHERE gm > 0 AND name = ?");
                ps.setString(1, addName);
                ResultSet rs = ps.executeQuery();
				
                if (rs.next() && !player.isGM()) {
                    c.getSession().write(MaplePacketCreator.serverNotice(1, "GameMaster is not available as a buddy."));
                    return;
                }
                rs.close();
                ps.close();
            } catch (SQLException sqlE) {}

im off to sleep.. cya tomorrow guys :

 

[Nycrich67]

Most Private server's just make there GM's Name's(& staff member's)
With a "[" & "]".
Ex:
[GM]Maplestory.

 

[Ehab]

but ALL of my GMs' Names are regular :

My method wins

 

[KidFlow]

Wont this kinda bog up the server? MYSQL usuage, I didnt look quite into it.. Gotta go.. nice!