Jump to content

Recommended Posts

Posted

it doesn't sort the database pvp kills

it just sorts a map's values.

It's simple.

 

 

yes but they CAN'T REFRESH since you dont have task man. Are we speaking the same language?

 

let go that you should use SQL ORDER BY, at least understand what Im telling you

Posted (edited)

yes but they CAN'T REFRESH since you dont have task man. Are we speaking the same language?

 

let go that you should use SQL ORDER BY, at least understand what Im telling you

Please read better the code , in every sendData it sorts the maps , that's all what is needed. you can't understand this?

Edited by Lioy
Posted

dude since you read from db once you store static data on the maps. If I get a pvp it will still send the pvp amount I had once the server started so it doesnt refresh. 

 

Thats what im trying to explain you, you cant have self-refreshing data without db connection if theres no task to reschedule data read.

Posted

Please read better the code , in every sendData it sorts the maps , that's all what is needed. you can't understand this?

 whats the point of sorting the same map every time? it holds static data

Posted

dude since you read from db once you store static data on the maps. If I get a pvp it will still send the pvp amount I had once the server started so it doesnt refresh. 

 

Thats what im trying to explain you, you cant have self-refreshing data without db connection if theres no task to reschedule data read.

You are wrong again , maybe you didn't understand how it works.

playersPvpKills.put(charName, pvpKills) replaces pvpKills if key is same..

 

Realy why you insist since I tested it?

Posted

You are wrong again , maybe you didn't understand how it works.

playersPvpKills.put(charName, pvpKills) replaces pvpKills if key is same..

 

Realy why you insist since I tested it?

 

can u explain me how you refresh the data dude? What you say makes no sense

Posted (edited)

can u explain me how you refresh the data dude? What you say makes no sense

lol

 

When server starts , data is retrieving into map. So the map has all charnames,pvps . Every time a player's pvp's count changes , it's putted in the map.

If the server restart again, 1 more database connection and it's repeating. Simple enough

Edited by Lioy
Posted

How you do this?

 

 public void setPkKills(int pkKills)
    {
        _pkKills = pkKills;
+       Top.addDataPk(getName(), getPkKills());
    }
    
    /**
@@ -1917,6 +1919,7 @@
    public void setPvpKills(int pvpKills)
    {
        _pvpKills = pvpKills;
+       Top.addDataPvp(getName(),getPvpKills());
    }
    
Posted

Okay I understand now, but why you choose the shitiest way to do it? You make things too complicated for no reason at all.

 

Just put a task reading from the database every x seconds like everybody does, and use that goddamn ORDER BY. You will get rid of those retarded maps and methods and a 100 lines shorter and cleaner code all in one class..

 

 

 

Its too sad that I have to be the bad guy telling you what to do with your code but the rest few with knowledge on this forum won't even bother to support what I tell you or help you improve your code. Anyway 

Posted

Okay I understand now, but why you choose the shitiest way to do it? You make things too complicated for no reason at all.

 

Just put a task reading from the database every x seconds like everybody does, and use that goddamn ORDER BY. You will get rid of those retarded maps and methods and a 100 lines shorter and cleaner code all in one class..

 

 

 

Its too sad that I have to be the bad guy telling you what to do with your code but the rest few with knowledge on this forum won't even bother to support what I tell you or help you improve your code. Anyway 

 

That's the main question man , if this code is better or worst than continuously database connection like others , your opinion is 'NO IT SUCKS' , but I want more opinions from more ppl :P 

We are not here to fight :P

Posted

I would still use the one that makes connections every time a bypass is cought though, because the code seems more simple and i use more values like: clan name, hero, etc :D

Posted (edited)

I would still use the one that makes connections every time a bypass is cought though, because the code seems more simple and i use more values like: clan name, hero, etc :D

Simplest things are not always the best. Maybe this one yes (?) , still dont know. I won't comment about this one about clan name , heroes you said ;/

Edited by Lioy
Guest Elfocrash
Posted

Okay I understand now, but why you choose the shitiest way to do it? You make things too complicated for no reason at all.

 

Just put a task reading from the database every x seconds like everybody does, and use that goddamn ORDER BY. You will get rid of those retarded maps and methods and a 100 lines shorter and cleaner code all in one class..

 

 

 

Its too sad that I have to be the bad guy telling you what to do with your code but the rest few with knowledge on this forum won't even bother to support what I tell you or help you improve your code. Anyway 

Performance wise this way is way better. As this comparing to a sql connection is probably 10 times liter. However i would trust more a sql connection every x minutes to refresh this rather than on click or on pvp kill.

Posted

Performance wise this way is way better. As this comparing to a sql connection is probably 10 times liter. However i would trust more a sql connection every x minutes to refresh this rather than on click or on pvp kill.

Still better than continuously sql connection on every time that a player talking to npc,press o command or whatever, right? It's a question :P

Guest
This topic is now closed to further replies.



  • Posts

    • https://l2.gamedream.pl/ Update #2 — GameDream Interlude (C6)     This update focuses on Epic bosses, quest chains and overall QoL :cool Highlights: Frintezza access follows a full retail-like chain: Four Goblets → Last Imperial Prince → Journey to a Settlement Retail-like entry requirements restored (scroll + Command Channel) Four Goblets quest is now available in-game Shot visuals synced with attack/skill usage Community Board Premium Shop refreshed with classic Interlude buttons and cleaner tables Epic Raidboss access: Frintezza — 4–5 party Command Channel + scroll + Antique Brooch Antharas — Portal Stone Baium — Bloody Fabric Valakas — Floating Stone Queen Ant / Core / Orfen / Zaken — no quest gates Bug Fixes & QoL: Frintezza quest chain fully fixed TvT rewards — single reward + anti-abuse protection Shots — no double triggering Premium Shop — no blank tabs Mammon NPCs in Giran working correctly Cancel works retail-like (up to 5 buffs removed) Summon Friend fixed with anti-exploit guards YetiBuffer — Saved Buff Profiles (Save / Clear / Restore) PvE — increased aggro range + balance tweaks EXP toggle commands: expoff / expon / expblock Thanks for testing and feedback — more updates coming soon ❤️
    • Hello I would like to offer You my NEW 2026 Updater / Launcher with custom skins.   - UPDATER FEATURES -   1. Performance and Intelligent Resource Management: Smart Disk Detection (SSD/HDD): The updater automatically detects the user's drive type. For SSD/NVMe drives: Launches up to 8-12 concurrent threads, utilizing the full yet optimized connection speed. For HDD drives: Limits the thread count (to 2-3) to prevent computer slowdowns and avoid overloading the drive head. Multi-threaded Downloading: Instead of downloading file by file, the updater downloads multiple files simultaneously, drastically reducing update time. ZSTD Compression: Support for the modern Zstandard compression algorithm (.zst). Files are downloaded in compressed form and decompressed on the fly, saving bandwidth and accelerating downloads. HTTP/2 and Keep-Alive Support: Utilizing the HTTP/2 protocol and persistent connections allows for the instant download of thousands of small files without establishing a new connection for each one.   2. Modern User Interface (UI/UX): Transparency and PNG Graphics: Support for irregular window shapes, allowing for the creation of a unique, modern launcher look. Taskbar Integration: The progress bar is displayed not only in the window but also on the Windows taskbar icon. Built-in News Browser (Optional): The updater features a built-in browser module that displays news/changelogs directly within the launcher (without opening an external browser). Multi-language Support (Optional): Built-in language switching system (e.g., EN/PL/RU, etc.) with dynamic loading of button graphics and text. Animated Buttons (Optional): Dedicated, animated buttons redirecting to Discord, Facebook, YouTube, Instagram, and the website.   3. Technical Features and Application Security: Anti-Dual Run (Optional): The updater checks if the game is already running to prevent file conflicts during updates. Error Diagnostics: Built-in logging system (debug_log.txt) and hardware exception handling (SEH), facilitating the diagnosis of problems for players who cannot run the game. Internal Configuration: Updater settings are stored inside the .exe file, eliminating publicly accessible configuration files.   4. File Categorization (Normal vs. Critical vs. Once): Critical Files: Critical files are verified more thoroughly (via MD5 Hash) even in quick check mode to guarantee stability. Normal Files: Standard game files (textures, models, sounds) are checked depending on the selected mode (Quick vs. Full). Once Files (Overwrite Exclusions): Applies to user configuration files (e.g., Option.ini, User.ini).   5. Check Modes (Verification Algorithms): Self-Update: The updater can update itself before checking game files, allowing for easy deployment of launcher fixes. The updater supports two main operating modes that switch intelligently based on user action: Smart Check (Startup Quick Check): Runs automatically upon updater startup or pressing the START button (unless a full check is forced). Full Check (Full MD5 Verification): Manually triggered by the player via the "Full Check" button. Automatic Update Detection: If a newer version of a file appears on the server, it is automatically detected and downloaded without player interaction. Atomic Updates: Files are downloaded and verified first, and only then saved to the disk. This prevents game client corruption in case of internet connection loss. The entire process takes seconds, even with clients weighing 30GB+. - PATCH BUILDER FEATURES -   1. Professional File Structure Management (Tree-List Hybrid): Directory Tree Visualization: Instead of a flat file list, the Builder displays a clear structure of folders and subfolders. You can collapse and expand entire tree branches, facilitating work with thousands of files. Normal and Critical Division: A clear window division into two main zones: Normal Files and Critical Files. Ghost and Excluded Files Division: The interface visually informs about the status of unchanged files (existing in the previous patch version) and files excluded from the update. Show/Hide Ghosts: With one click, you can hide unchanged files to focus solely on what you are actually sending to players in this update.   2. Intuitive Interaction: Drag & Drop: Full Drag & Drop support. You can grab files or entire folders and drag them between the "Normal" and "Critical" lists. Transfer is intelligent – it moves the entire content of selected folders. Keyboard Shortcuts: Fast workflow thanks to keyboard support: Delete, Enter, Ctrl+A / Ctrl+C (select and copy paths).   3. Advanced Filtering and Searching: Context Search: The search bar works in real-time, filtering the file tree. Type /folder: Searches only within folder names. Type *ex: Shows only excluded files. Standard Typing: Searches files by name.   4. Automation and Security: Auto Self-Update: The Builder automatically detects the updater executable file. Real-Time Statistics: The status bar continuously shows the file count (Normal/Critical), total patch weight (in Bytes/MB/GB), and the last update date. System File Protection: Files marked as "Critical" cannot be accidentally added to the exclusion list – the program blocks such actions.   5. Performance (Backend): ZSTD Compression: The Builder uses the latest Zstandard algorithm to compress files before sending, ensuring a significantly smaller patch size than standard ZIP, saving server bandwidth and player time. Multi-threading: The packing and MD5 checksum generation process utilizes multiple CPU threads, drastically reducing patch building time.   - PRICING - NEW Updater standard price: 79 euro (if You ask for mods, price will change).   - CONTACT - Discord: ave7309   CLICK HERE TO CHECK LATEST TEMPLATES!                         * I have right to REFUSE to take an order. ** Supported games: Lineage 2 / Black Desert Online / MU Online / Tantra Online / Rohan / Aion / Cabal / Fiesta Online any many more... *** Updater virus scan | Patch Builder virus scan
    • 🔥 Upgrade Your Server's Visual Identity 🔥 Hello Community! We are proud to present the Shadowbane Collection – a premium, oriental-style visual suite designed specifically for Metin2 and Silkroad private servers. Forget about static, boring pages. Give your players a true "AAA" experience with a fully animated video header and a professional brand identity. 🎥 VIDEO PREVIEW   🐉 1. Shadowbane – Animated HTML Website Template A fully coded, responsive website template with a stunning video background. No coding skills required – just upload and configure! 🚀 Technology: HTML5 / CSS3 / JS (No PSD, ready code) 🎥 Animated Header: Loopable video background included (.mp4) 📱 Responsive: Works perfectly on Mobile & Desktop 📂 Pages Included: Home, Rankings, Register, Download, News 👉 DOWNLOAD WEBSITE TEMPLATE HERE       ⚔️ 2. Shadowbane – Game Logo & Text Effect Complete your branding with this matching Logo Template. It works as a Photoshop Text Effect – just type your server name! 🎨 Style: Oriental Gold & Brush Ink ⚡ Easy Edit: Smart Objects (One-click change) 🎁 Bonus: Social Media Kit included (Banner + Avatar) 👉 DOWNLOAD LOGO TEMPLATE HERE 🎁 SPECIAL LAUNCH DISCOUNT 🎁 For forum members, we have prepared a special code. Get 20% OFF on your entire order! CODE: LOVEM2 Elevate your server today with Pixarts.store  
    • Contact me on discord have an offer for you. l2avalon.net  
    • At this point, you’re better off buying server files that have actually been heavily tested by you or that you’ve personally played on. Working with public sources is a waste of time. These days, it’s also a waste of time to deal with files that have never powered a live server, or with people trying to sell you a story without real proof or a solid player base to back it up.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..