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

 

[-Tenshi-]

Re: [Release]!donor Changing donor status in game!

Hawt <3

 

[pyrrhic]

Re: [Release]!donor Changing donor status in game!

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

 

[candyman1111]

Re: [Release]!donor Changing donor status in game!

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

 

[Xerixe]

Re: [Release]!donor Changing donor status in game!

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]

Re: [Release]!donor Changing donor status in game!

        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]

Re: [Release]!donor Changing donor status in game!

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

 

[Moogra]

Re: [Release]!donor Changing donor status in game!

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

 

[Xerixe]

Re: [Release]!donor Changing donor status in game!

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

 

[Moogra]

Re: [Release]!donor Changing donor status in game!

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

 

[Xerixe]

Re: [Release]!donor Changing donor status in game!

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]

Re: [Release]!donor Changing donor status in game!

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]

Re: [Release]!donor Changing donor status in game!

==..

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]

Re: [Release]!donor Changing donor status in game!

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]

Re: [Release]!donor Changing donor status in game!

Great release lol!

 

[thisisakevin]

Re: [Release]!donor Changing donor status in game!

It will update the column "donator" right? Not donor?

 

[Supiangel]

Re: [Release]!donor Changing donor status in game!

Nice release dude , But theres any way to make Somebody Donor or Donator exactly when he donates via paypal? Like Nexon and NXCash XP

 

[thisisakevin]

Re: [Release]!donor Changing donor status in game!

You can make it so when they press the donation button they can change their donator stuats to 1

 

[mikethemak]

Re: [Release]!donor Changing donor status in game!

You can make it so when they press the donation button they can change their donator stuats to 1

-presses donation button, then presses back button without donating- <-- see the problem?

 

[Xerixe]

Re: [Release]!donor Changing donor status in game!

If you do that when they press
Your server would fail =)