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

[MentaL]

[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 =[