Jump to content

f0zi

Members
  • Posts

    63
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by f0zi

  1. orgasms! FAP FAP FAP FAP!!! :happyforever: :happyforever: :happyforever: :happyforever: :rage: :rage: :rage: :rage: :rage: :rage:
  2. I was looking for this also... :rage: :rage: :rage:
  3. there is any ETA ?
  4. waiting untill december :poker face:
  5. Yeh, I want to play a server as pride... I am tired to play tibia muahaha :rage: :troll: :rage: :dat:
  6. Well, let's see how it is going again! I will be waiting :troll: :rage: :good sir:
  7. Thanks for advice!
  8. It is good! But I have a question that made me freaking out with sql query... PreparedStatement statement = con.prepareStatement("SELECT SUM(chr.points), SUM(it.count), ch.char_name, ch.pkkills, ch.pvpkills, ch.onlinetime, ch.base_class, ch.online FROM characters ch LEFT JOIN character_raid_points chr ON ch.charId=chr.charId LEFT OUTER JOIN items it ON ch.charId=it.owner_id WHERE item_id=57 GROUP BY ch.charId ORDER BY " + sort + " DESC LIMIT " + Config.TOP_PLAYER_RESULTS); Here what I supposed to do... I was thinking show only normal players with accesslevel 0 so, I decide to add that query: PreparedStatement statement = con.prepareStatement("SELECT SUM(chr.points), SUM(it.count), ch.char_name, ch.pkkills, ch.pvpkills, ch.onlinetime, ch.base_class, ch.online FROM characters ch LEFT JOIN character_raid_points chr ON ch.charId=chr.charId LEFT OUTER JOIN items it ON ch.charId=it.owner_id WHERE item_id=57 and ch.accesslevel=0 GROUP BY ch.charId ORDER BY " + sort + " DESC LIMIT " + Config.TOP_PLAYER_RESULTS); I do only put it and ch.accesslevel=0, but it doesn't make anything =(
  9. Hello everyone, I was trying to make a server Hi5, but here is the deal. I am wondering if is possible to make a custom soulshot effect on each enchant level for determinates weapons ID's. I have no idea if it was already posted here, but for sure, It is completely out of my mind to make these things HAHAHA Anyway, I appreciate for any kind of reply! Kisses, f0zi.
  10. Well, I think I am newbie... In java codes everything is perfect, but when I go IG, this 9023 is a tiny npc as a npc event... :not bad: :not bad: someone can help me ? I did it Index: /trunk/Data/dist/sql/Custom sql for server/fake_pcs/fake_pcs_Npc edit.sql =================================================================== --- /trunk/Data/dist/sql/Custom sql for server/fake_pcs/fake_pcs_Npc edit.sql (revision 340) +++ /trunk/Data/dist/sql/Custom sql for server/fake_pcs/fake_pcs_Npc edit.sql (revision 340) @@ -0,0 +1,2 @@ +INSERT INTO custom_npc VALUES ('9023', '32365', 'Finish', '1', 'Event Manager', '1', 'LineageNPC2.TP_game_staff', '5.00', '12.50', '70', 'male', 'L2Monster', '40', '2444.000000000000000', '1225.000000000000000', '0.000000000000000', '0.000000000000000', '40', '43', '30', '21', '20', '20', '0', '0', '1086.00000', '471.00000', '749.00000', '313.00000', '230', '1', '333', '0', '0', '0', '68.00000', '109.00000', '0', '0'); +INSERT INTO custom_npcaidata VALUES ('9023', '7', '15', '0', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '0', null, '0', '0', 'fighter');
  11. Hey! what's up! I am not an expert on java things, but there is a bug with that ? in switch/case, shoudn't use break on each cases ? + KILL_STEAK++; + switch (KILL_STEAK) + { + case 5: + sendMessage("You are almost on a killing spree"); break; + case 10: + Announcements.getInstance().announceToAll(getName()+" is on a killing spree!!"); + setHero(true); break; + case 20: + Announcements.getInstance().announceToAll(getName()+" is on a rampage!!"); + startAbnormalEffect(AbnormalEffect.VITALITY); break; + case 60: + Announcements.getInstance().announceToAll(getName()+" is legendary!"); + for (L2PcInstance players : L2World.getInstance().getAllPlayersArray()) + { + players.sendPacket(new ExRedSky(10)); + } break; + } It isn't right ?
×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock