[Creative] Bored Release!

I

iPreSkooler

Newbie Spellweaver
Joined
Aug 14, 2017
Messages
19
Reaction score
1
Hello Ragezone!

 Recently I have had some free time on my hands to release some cool little things that new comers have a hard time finding or placing it in there server itself. Take note that some of these are already released and this is just a updated version or a easier version for people just starting. Nothing in here is spectacular so don't expect anything insane. I just thought why not release this useless stuff!

- Daily Rewards with Script

PLACE THIS IN YOUR SQL
Code: 
DROP TABLE IF EXISTS `dailyreward`;
CREATE TABLE `dailyreward` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `accountid` int(10) unsigned NOT NULL,
  `characterid` int(10) unsigned NOT NULL,
  `rewardid` varchar(20) NOT NULL,
  `lastattempt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

PLACE THESE IN YOUR MapleCharacter.java
Code: 
public int getDailyReward(String rewardid) {
        Connection con1 = DatabaseConnection.getConnection();
        try {
            int ret_count = 0;
            PreparedStatement ps;
            ps = con1.prepareStatement("select count(*) from dailyreward where characterid = ? and rewardid = ? and lastattempt >= subtime(current_timestamp, '1 0:0:0.0')");
            ps.setInt(1, id);
            ps.setString(2, rewardid);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) 
                ret_count = rs.getInt(1);
            else
                ret_count = -1;
            rs.close();
            ps.close();
            return ret_count;
        } catch (Exception Ex) {
            return -1;
        }
    }

Code: 
public int getRewardLog(String rewardid) {
        Connection con1 = DatabaseConnection.getConnection();
        try {
            int ret_count = 0;
            PreparedStatement ps;
            ps = con1.prepareStatement("select count(*) from dailyreward where accountid = ? and rewardid = ? and lastattempt >= subtime(current_timestamp, '1 0:0:0.0')");
            ps.setInt(1, accountid);
            ps.setString(2, rewardid);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) 
                ret_count = rs.getInt(1);
            else
                ret_count = -1;
            rs.close();
            ps.close();
            return ret_count;
        } catch (Exception Ex) {
            return -1;
        }
    }

Code: 
public void setDailyReward(String rewardid) {
        Connection con1 = DatabaseConnection.getConnection();
        try {
            PreparedStatement ps;
            ps = con1.prepareStatement("insert into dailyreward (accountid, characterid, rewardid) values (?,?,?)");
            ps.setInt(1, accountid);
            ps.setInt(2, id);
            ps.setString(3, rewardid);
            ps.executeUpdate();
            ps.close();
        } catch (Exception Ex) {
        }
    }

- Daily Reward Script Images

You must be registered to see links

You must be registered to see links

You must be registered to see links


You must be registered to see links
(Download <-)

*You'll DC unless you have updated Equips*

- Auto Job Warp / Auto Job Advancer

PLACE THIS IN YOUR MapleCharacter.java

Code: 
private void levelUpMessages() {
         if (level % 5 != 0) {
            return;
        }
         if (level == 10) {
            yellowMessage("First Job is now available for you! Head over to your Job Instructer, and try out a Job!");
        } else if (level == 15) {
            yellowMessage("Half-way to your 2nd job advancement, keep grinding!");
        } else if (level == 25) {
            yellowMessage("You seem to be improving, but you are still not ready to move on to the next step.");
        } else if (level == 30) {
            if (getJob() != MapleJob.WARRIOR) {
                } else {
            client.getPlayer().changeMap(client.getChannelServer().getMapFactory().getMap(102000003));
            }
            if (getJob() != MapleJob.MAGICIAN) {
                } else {
            client.getPlayer().changeMap(client.getChannelServer().getMapFactory().getMap(101000003));
            }
            if (getJob() != MapleJob.BOWMAN) {
                } else {
            client.getPlayer().changeMap(client.getChannelServer().getMapFactory().getMap(100000201));
            }
            if (getJob() != MapleJob.THIEF) {
                } else {
            client.getPlayer().changeMap(client.getChannelServer().getMapFactory().getMap(103000003));
            }
            if (getJob() != MapleJob.PIRATE) {
                } else {
            client.getPlayer().changeMap(client.getChannelServer().getMapFactory().getMap(120000101));
            }
            if (getJob() != MapleJob.ARAN1) {
            } else {
            MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 10);
            }
            yellowMessage("You have finally reached level 30! Congratulations you can now Job advance!");
        
        } else if (level == 70) {
            if (getJob() != MapleJob.FIGHTER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.PAGE) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.SPEARMAN) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.FP_WIZARD) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.IL_WIZARD) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.CLERIC) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.HUNTER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.CROSSBOWMAN) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.ASSASSIN) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.BANDIT) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
        
            if (getJob() != MapleJob.BRAWLER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.GUNSLINGER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.DAWNWARRIOR2) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.BLAZEWIZARD2) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.WINDARCHER2) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.NIGHTWALKER2) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.THUNDERBREAKER2) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.ARAN2) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            yellowMessage("You have finally reached level 70! Congratulations! Enjoy your 3rd Job!");
            
        } else if (level == 120) {
                        if (getJob() != MapleJob.HERO) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.WHITEKNIGHT) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.DRAGONKNIGHT) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.FP_WIZARD) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.IL_WIZARD) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.PRIEST) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.RANGER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.SNIPER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.HERMIT) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.CHIEFBANDIT) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
        
            if (getJob() != MapleJob.MARAUDER) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.OUTLAW) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.DAWNWARRIOR3) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.BLAZEWIZARD3) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.WINDARCHER3) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.NIGHTWALKER3) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.THUNDERBREAKER3) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            if (getJob() != MapleJob.ARAN3) {   
            } else {
                  MapleMap oldMap = client.getPlayer().getMap();
   MapleMap newMap = client.getChannelServer().getMapFactory().getMap(client.getPlayer().getMapId());
   for (MapleCharacter ch : oldMap.getCharacters()) {
    ch.changeMap(newMap);
   }
   oldMap = null;
   newMap.respawn();
                 client.changeJobById(client.getJobId() + 1);
          
            }
            
            yellowMessage("You have finally reached level 120! Congratulations! Enjoy your 4th Job!");
}

You must be registered to see links
(Download <-)

You must be registered to see links

You must be registered to see links


You must be registered to see links

You must be registered to see links

You must be registered to see links


Again this was a fun post and I'll add Occupations with Kishin and MobPoints later. For now I hope you enjoy these cool little things and hopefully it benefits you. After I finish touching up my website I will be releasing that in the near future as well. Enjoy xD
 
Last edited:
F

Fraysa

I'm overrated.
Loyal Member
1000 Posts Got A Reaction 10 Happy Years
Joined
Apr 10, 2008
Messages
4,087
Reaction score
1,264
iPreSkooler said:
Wow ... I have actually never seen that post so the odds of it being kind of similar is crazy. But at the end of the day it doesn't even matter this isn't nothing special.
Click to expand...
I think the fact that you forgot to rename bossid to rewardid kinda turns it in, lol.

PHP: 
            ps = con1.prepareStatement("insert into dailyreward (accountid, characterid, bossid) values (?,?,?)")

But it's only the code, but the overall idea is very similar to the Pandora Box. Whatever, enjoy. Nice release I guess.
 
You must log in or register to reply here.