rebirth ranking in game.

[thegamer1907]

ok i dont take credits for this. i took the base code from somewhere else whoever is that credits go to him.

EDIT: CREDITS TO gorgon0 for base code

ok so go to commandprocessor.java and find:

else {
				mc.dropMessage("GM Command " + splitted[0] + " does not exist");
			}

and add this before the 'else' :

else if (splitted[0].equals("@reborns")) {
             ResultSet rs = reborns();
                           try { mc.dropMessage("Reborn Ranking Top 10:");
                               while(rs.next()){
                                  
                                  mc.dropMessage("Player : " + rs.getString("name") + "        |      Reborns :" + rs.getInt("reborns"));
                               }
                            } catch(Exception ex) {}
                        
	}

You can change the @reborns to anything you like for the command.

then find this:

private static String getCharInfoById(int id){
                        try {
            Connection dcon = DatabaseConnection.getConnection();
            PreparedStatement ps = dcon.prepareStatement("SELECT * FROM characters where id = ?");
            ps.setInt(1, id);
            ResultSet rs = ps.executeQuery();
            if(rs.next())
            return rs.getString("name");
            
            } catch(Exception ex) {}
            return "error while trying to get name";
            
        }

add t his below:

public static ResultSet reborns() {		
		try {
			Connection con = DatabaseConnection.getConnection(); 
			PreparedStatement ps = con.prepareStatement("SELECT name,reborns FROM characters WHERE gm = 0 ORDER BY reborns desc LIMIT 10");
                     return ps.executeQuery();
                     
		} catch (Exception ex) {}
			
		return null;
	}

then compile and you're done. works 100%. it shows the top 10 reborn ranks.

 

[iPlayHard]

Re: [Small RELEASE] rebirth ranking in game.

Thanks if this works

EDIT: w00tz it works

 

[megoesrawr]

Re: [Small RELEASE] rebirth ranking in game.

Cool. Trying it out.

 

[gorogon0]

Re: [Small RELEASE] rebirth ranking in game.

its me... credits to me

 

[ryuko]

Re: [Small RELEASE] rebirth ranking in game.

hmm kind of a noob question. the column in my database says rebirth, could we just change the result set from reborn to rebirth?

 

[thegamer1907]

Re: [RELEASE] rebirth ranking in game.

yes you can edit it to match you db. Added credits to you gorogon.

 

[RyomaEchizen]

Re: [RELEASE] rebirth ranking in game.

Nice release. Bet an ass load of private servers will be using it.

 

[DrFusion]

Re: [Small RELEASE] rebirth ranking in game.

its me... credits to me

no ****

 

[EspadaFung]

Re: [RELEASE] rebirth ranking in game.

so... where is the NPC script?

 

[iPlayHard]

Re: [RELEASE] rebirth ranking in game.

It's not a NPC script. It's a command ._.

 

[EspadaFung]

Re: [RELEASE] rebirth ranking in game.

oh yea. lol
i thought it was a npc command ~_~ nvm great release still.

 

[elizool99]

Re: [RELEASE] rebirth ranking in game.

Very nice !

 

[x3antiemo]

Re: [RELEASE] rebirth ranking in game.

i know im kinda like.. bumping.. so.. yeah, i was wondering, there isnt anything in commandproccessor.java with that, so.. how do I do it? im using ThePack repack v62, help?

 

[TheUnknown]

Re: [RELEASE] rebirth ranking in game.

then find this:

private static String getCharInfoById(int id){
                        try {
            Connection dcon = DatabaseConnection.getConnection();
            PreparedStatement ps = dcon.prepareStatement("SELECT * FROM characters where id = ?");
            ps.setInt(1, id);
            ResultSet rs = ps.executeQuery();
            if(rs.next())
            return rs.getString("name");
            
            } catch(Exception ex) {}
            return "error while trying to get name";
            
        }

add t his below:

public static ResultSet reborns() {		
		try {
			Connection con = DatabaseConnection.getConnection(); 
			PreparedStatement ps = con.prepareStatement("SELECT name,reborns FROM characters WHERE gm = 0 ORDER BY reborns desc LIMIT 10");
                     return ps.executeQuery();
                     
		} catch (Exception ex) {}
			
		return null;
	}

Where to put this?

 

[~Delta]

Re: [RELEASE] rebirth ranking in game.

where your gm commands are... look at the date god..

 

[nugyyman]

Re: [RELEASE] rebirth ranking in game.

OMG 2008?!
This is for old repacks like odinms, valhalla, the pack, etc.
(only for the command part).

 

[LovetheLord]

Re: [RELEASE] rebirth ranking in game.

ty! for this!!!!

 

[SharpAceX]

Re: [RELEASE] rebirth ranking in game.

ty! for this!!!!

You fail. This has been released so long ago hence the date?

 

[LovetheLord]

Re: [RELEASE] rebirth ranking in game.

You fail. This has been released so long ago hence the date?

I never got mine to work and this one happens to work so... yea =)