Players can't add GMs to buddylist

[flav]

Actually it's been proven to be quicker to do

SELECT * FROM table WHERE column = whatever

rather than

SELECT column FROM table WHERE column = whatever

To check if an entry exists.


@ Ehab - Your method doesn't win.

That and the buddies table isn't that big at all.

[nubspacecake]

Why don't you define a list of GM names in the world server
so you can just load the names once, in stead of everytime you buddy someone?

just my opinion, saves a lot of memory though

[PinkGatsby]

Why don't you define a list of GM names in the world server
so you can just load the names once, in stead of everytime you buddy someone?

just my opinion, saves a lot of memory though

Not really.

[flav]

Why don't you define a list of GM names in the world server
so you can just load the names once, in stead of everytime you buddy someone?

just my opinion, saves a lot of memory though

Why should this save memory?

[Ehab]

btw my way is the same as flav's .. i just changed the declaration and the text

yah it's Gamemaster in GMS

[Raymondx3]

Useful. Great for gMS-like servers.

[Ehab]

i added this in both of my v55 and v62 servers

[Quаlitys]

uNice release!

[ANBUItachi]

Would This Work? o.o
I Changed !player.isGM() to player.gmLevel() > 0

            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.gmLevel() > 0) {
                    player.dropMessage(1, "GameMaster is not Available as a Buddy.");
                    return;
                }

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

[Ehab]

well you got it in a wrong line
this line makes GMs able to buddy GMs but prevents players from adding GMs
if u remove it, no one can add a GM o_o


correct me if im wrong..

[ANBUItachi]

Then how it works with player.gmLevel() ???

[Popozow1012]

useless releases out the wazoo lately

[flav]

Then how it works with player.gmLevel() ???

player.gmLevel() < 1

useless releases out the wazoo lately

Don't use it? It's useful for the GMS like servers, if you don't need it I don't care and it's no reason for me to not release it.

[flav]

Why not just do
if (otherChar.gmLevel() > 0) {
return;
}

1. You forgot the message that they can't add Gamemaster. D:
2. I already mentioned that this is useless if "otherChar" is offline.

[flav]

Because this is made for the GMS likenes at all, and GMS has this message too.