donor Changing donor status in game!

[Xerixe]

Here's a release that lets you make someone a donor using a command in game.
Tested and working =)
If you're going to use this.
Give me credits please. Thank you

Credits goes to :
Me ( For making this )
nejevoli ( For giving me the idea and testing )



Add this to MapleCharacter.java

        public void makeDonor() {
            	client.getSession().close();
		try {
			Connection con = DatabaseConnection.getConnection();
			PreparedStatement ps = con.prepareStatement("UPDATE characters SET donator = ? WHERE accountid = ?");
			ps.setInt(1, 1);
			ps.setInt(2, accountid);
			ps.executeUpdate();
			ps.close();
		} catch (SQLException ex) {
			log.error("Error while changing status", ex);
		}
	}
        
        public void unDonor() {
            	client.getSession().close();
		try {
			Connection con = DatabaseConnection.getConnection();
			PreparedStatement ps = con.prepareStatement("UPDATE characters SET donator = ? WHERE accountid = ?");
			ps.setInt(1, 0);
			ps.setInt(2, accountid);
			ps.executeUpdate();
			ps.close();
		} catch (SQLException ex) {
			log.error("Error while changing status", ex);
		}
	}

Btw, check the donator column in your MySQL and change donator to yours. Example = donor. In both statements

Add this to CommandProcessor.java

                        } else if (splitted[0].equals("!donor")) {
				MapleCharacter target = cserv.getPlayerStorage().getCharacterByName(splitted[1]);
				target.makeDonor();
				mc.dropMessage("Changed donor status for " + target) ;
                        } else if (splitted[0].equals("!undonor")) {
				MapleCharacter target = cserv.getPlayerStorage().getCharacterByName(splitted[1]);
				target.unDonor();
				mc.dropMessage("Changed donor status for " + target) ;

Use !undonor to make someone a normal player
!donor to make someone a donor

[MentaL]

[-Tenshi-]

Hawt <3

[pyrrhic]

this is kool can it be reservered or restricted to admin only and not all GMs ?

[candyman1111]

its easier threw the mysql but w/e bro i wont complain

[Xerixe]

If your using the new command system yes you can
Just figure out how. It's harder if your running on a dedicated host
Which takes quite a long time to respond =)

[Moogra]

        public void makeDonor() {
            	client.getSession().close();
		try {
			Connection con = DatabaseConnection.getConnection();
			PreparedStatement ps = con.prepareStatement("UPDATE characters SET donator = ? WHERE accountid = ?");
			ps.setInt(1, 1);
			ps.setInt(2, accountid);
			ps.executeUpdate();
			ps.close();
		} catch (SQLException ex) {
			log.error("Error while changing status", ex);
		}
	}

I'm not getting how the MySQL works right now. It's not working for me.
Shouldn't

("UPDATE characters SET donator = ? WHERE accountid = ?");

be

("UPDATE characters SET donator = ? WHERE name = ?");

When I do !donor, it drops the correct message but there are no results.

[Xerixe]

You can try name but i dont think it would work
My friend tested it for me and it worked fine

[Moogra]

You mean it cahnged in the database? Hmmm... maybe you have to !saveall after using it

[Xerixe]

Nah, whats the column name in your database?
I made it to dc people before it makes them donor

[Moogra]

it's donator (in lowercase)
so yeah it matches your script. I checked that

[Xerixe]

Wait what was your question again?
You're saying how it works?
If u use name
You'll need something to get the person's name

[Moogra]

cserv.getPlayerStorage().getCharacterByName(splitted[1]);
OH YEAH THIS TRANSLATE TO THE CHARACTER ID RIGHT?
then wouldn't you need the id, not account id?

[Xerixe]

==..

MapleCharacter target = cserv.getPlayerStorage().getCharacterByName(splitted[1]);

Is to get the target when you use the command
So it can apply the effect ==..
The accountid is in MapleCharacter.

[Moogra]

THat's what I was talking about...
It gets the character. Isn't that what I said? Well it still doesn't work for me. It drops the message that it is changed but there is no effect.

And for every other script, it's always UPDATE characters SET <thing> =? WHERE id = ?

[thisisakevin]

Great release lol!