Jump to content

bauwbas

Members
  • Posts

    339
  • Credits

  • Joined

  • Last visited

  • Days Won

    1
  • Feedback

    0%

Everything posted by bauwbas

  1. I think it work on offlineshop, cuz then you go to offline shop, you still have online = 1 in your Database, so you need just create one if with Offlineshop to don't get points
  2. Wow, its took about 10 min to know how to work with disasm, and after it, its working, thank you Elfocrash, i need to remember your nick name :)
  3. don't work ether, if i take l2encdec its open, but i can't see quest id's
  4. Ok, i have god pack, and now i started to create quest, i used encdec to decode Queste.dat file, but half of code i see in heroglifs (dunno how to write ;p). One time I saw a post how to normaly decode all files, but i cant didint find, i event dont remember an autor. Can some1 help me? Plus i can only decode itemname, but cant item-grp.dat
  5. <item id="1"> <ingredient id="65436" count="1200"/> <production id="3926" count="1"/> </item> for multisell, you can use 65436 ID, but you must make server restart not reload multisell
  6. NO Custom Items latter Custom item
  7. Full working Fortress - Interlude dont have fortress, just fortress as house, but not attack system, so its custom, not retail.
  8. working for interlude, but IL don't have getIcon() so there is two way: 1) remove getIcon, but then you dont see icon 2) add getIcon(), its easy, but you need to add all icons to etc, armor and weapons.sql btw, interlude dont have L2NpcActionShift.java, so we add to L2NpcInstance this code.
  9. Umm. activeChar.closeNetConnection(); its turn off your Client? Its smart? Better would be boolean TryAugmentItem(L2PcInstance player, L2ItemInstance targetItem, L2ItemInstance refinerItem, L2ItemInstance gemstoneItem) { + // can't aug ROD + if (targetItem.getItem().getItemType() == L2WeaponType.ROD) + { + player.sendMessage("You can't augment rod type weapons"); + return false; + }
  10. first is by my pack, second by your pack, maybe guy named John, will have statment.setString(105, so this must combine by your l2pcinstnace
  11. Give one example what frozen had created? They event don't how to create db installer, what talk about script.. Btw tooked everything from Scoria )))
  12. Tera Online is Lineage 3. Lol, old news. There is no be L3. If you remember that incident where some creators stole l3 files, so here it is, these stolen files is Tera Online.
  13. Working on freya, hi5 too. Goddess of Destruction already had this in alt + x
  14. Yes, but interbliude don't have exshowmessage on server packetts, you need to take from gracia, hi5 or other chronicle. BTW you can write this in client
  15. No, only on interlude, but it must work too. There is nothing special what interlude have and hi5 not.
  16. Working, and tested on interlude packs. I think l2jserver have something like this in gracia, ep, hi5
  17. Gracia, Epilogue, Freya, Hi5 already have this, dunno other packs, but l2jserver 100% committed this.
  18. Good evening everybody :) Long time ago, i had my own forum with l2j script, but i closed due lack of time, so i want to share few scripts. This little script allow to use simple html color codes to set players nick's and title's in database. In short if player make rrhis name/title color will stay. This script I used to my server, i created special npc who sell color and colors remained permanently. Index: L2PcInstance.java =================================================================== --- L2PcInstance.java (revision 1116) +++ L2PcInstance.java (working copy) @@ -220,8 +220,8 @@ private static final String ADD_SKILL_SAVE = "INSERT INTO character_skills_save (char_obj_id,skill_id,skill_level,effect_count,effect_cur_time,reuse_delay,restore_type,class_index,buff_index) VALUES (?,?,?,?,?,?,?,?,?)"; private static final String RESTORE_SKILL_SAVE = "SELECT skill_id,skill_level,effect_count,effect_cur_time, reuse_delay FROM character_skills_save WHERE char_obj_id=? AND class_index=? AND restore_type=? ORDER BY buff_index ASC"; private static final String DELETE_SKILL_SAVE = "DELETE FROM character_skills_save WHERE char_obj_id=? AND class_index=?"; - private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,event_points=?,coupon=?,donator=?,death_penalty_level=?,koof=?,noob=? WHERE obj_id=?"; - private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,event_points,coupon,donator,hero,death_penalty_level,koof,noob FROM characters WHERE obj_id=?"; + private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,event_points=?,coupon=?,donator=?,death_penalty_level=?,koof=?,noob=?,name_color=?,title_color=? WHERE obj_id=?"; + private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,event_points,coupon,donator,hero,death_penalty_level,koof,noob,name_color,title_color FROM characters WHERE obj_id=?"; private static final String RESTORE_CHAR_SUBCLASSES = "SELECT class_id,exp,sp,level,class_index FROM character_subclasses WHERE char_obj_id=? ORDER BY class_index ASC"; private static final String ADD_CHAR_SUBCLASS = "INSERT INTO character_subclasses (char_obj_id,class_id,exp,sp,level,class_index) VALUES (?,?,?,?,?,?)"; private static final String UPDATE_CHAR_SUBCLASS = "UPDATE character_subclasses SET exp=?,sp=?,level=?,class_id=? WHERE char_obj_id=? AND class_index =?"; @@ -251,6 +251,7 @@ public static final int STORE_PRIVATE_BUY = 3; public static final int STORE_PRIVATE_MANUFACTURE = 5; public static final int STORE_PRIVATE_PACKAGE_SELL = 8; + public boolean OnSr = false; /** * The table containing all minimum level needed for each Expertise (None, D, C, B, A, S) */ @@ -5729,7 +5730,7 @@ con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement; statement = con.prepareStatement("INSERT INTO characters " + "(account_name,obj_Id,char_name,level,maxHp,curHp,maxCp,curCp,maxMp,curMp," + "acc,crit,evasion,mAtk,mDef,mSpd,pAtk,pDef,pSpd,runSpd,walkSpd," + "str,con,dex,_int,men,wit,face,hairStyle,hairColor,sex," + "movement_multiplier,attack_speed_multiplier,colRad,colHeight," - + "exp,sp,karma,pvpkills,pkkills,clanid,maxload,race,classid,deletetime," + "cancraft,title,accesslevel,online,isin7sdungeon,clan_privs,wantspeace," + "base_class,newbie,nobless,power_grade,last_recom_date,coupon) " + "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); + + "exp,sp,karma,pvpkills,pkkills,clanid,maxload,race,classid,deletetime," + "cancraft,title,accesslevel,online,isin7sdungeon,clan_privs,wantspeace," + "base_class,newbie,nobless,power_grade,last_recom_date,coupon,name_color,title_color) " + "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); statement.setString(1, _accountName); statement.setInt(2, getObjectId()); statement.setString(3, getName()); @@ -5788,6 +5789,8 @@ statement.setLong(56, 0); statement.setLong(57, System.currentTimeMillis()); statement.setInt(58, 0); + statement.setString(59, StringToHex(Integer.toHexString(getAppearance().getNameColor()).toUpperCase())); + statement.setString(60, StringToHex(Integer.toHexString(getAppearance().getTitleColor()).toUpperCase())); statement.executeUpdate(); statement.close(); } @@ -5936,6 +5939,10 @@ player.setJailTimer(rset.getLong("jail_timer")); else player.setJailTimer(0); + + player.getAppearance().setNameColor(Integer.decode((new StringBuilder()).append("0x").append(rset.getString("name_color")).toString()).intValue()); + player.getAppearance().setTitleColor(Integer.decode((new StringBuilder()).append("0x").append(rset.getString("title_color")).toString()).intValue()); + CursedWeaponsManager.getInstance().checkPlayer(player); player.setAllianceWithVarkaKetra(rset.getInt("varka_ketra_ally")); player.setCoupon(rset.getInt("coupon")); @@ -6299,7 +6306,9 @@ statement.setLong(59, getDeathPenaltyBuffLevel()); statement.setInt(60, isKoof() ? 1 : 0); statement.setInt(61, isNoob() ? 1 : 0); - statement.setInt(62, getObjectId()); + statement.setString(62, StringToHex(Integer.toHexString(getAppearance().getNameColor()).toUpperCase())); + statement.setString(63, StringToHex(Integer.toHexString(getAppearance().getTitleColor()).toUpperCase())); + statement.setInt(64, getObjectId()); statement.execute(); statement.close(); } @@ -11391,4 +11400,31 @@ public void updateFOSTitleFlag(){ FortressSiege.setTitleSiegeFlags(this); } -} + + private String StringToHex(String color) + { + switch(color.length()) + { + case 1: + color = (new StringBuilder()).append("00000").append(color).toString(); + break; + + case 2: + color = (new StringBuilder()).append("0000").append(color).toString(); + break; + + case 3: + color = (new StringBuilder()).append("000").append(color).toString(); + break; + + case 4: + color = (new StringBuilder()).append("00").append(color).toString(); + break; + + case 5: + color = (new StringBuilder()).append("0").append(color).toString(); + break; + } + return color; + } +} \ No newline at end of file And in your database make these two query's: ALTER TABLE characters ADD name_color varchar(8) DEFAULT ''; ALTER TABLE characters ADD title_color varchar(8) DEFAULT '';
  19. No function :) With beta you can edit only few files as you say, with latest freya you can do this too :)) BTW, what need to do with itemname.dat? Its name coded, have special numbers.. T_T
  20. No problem, soon i share retail like (most of retail like) fortress siege for IL (first need to finish fixing all errors xD )
  21. I don't know I hate these things with mastery's and grade penaltys, for me is better to ban equip heavy set for dagger/archers.. :)
  22. Its better than shop, teleport, and npc names taken from maxcheaters members, seteh, horus and etc :DDD
×
×
  • Create New...