Jump to content

Recommended Posts

Posted (edited)

My friend hosted L2Off Server and asked me to do php on his website for 1) total online players, 2) account manager etc. can you help me with a guide how to do this or send me some youtube video that best describes the process. thank you! thank you! thank you! in advance!!!

 

P.S  I have the codes I don't know how to make them work along with the web page

Edited by gioshalik
Posted (edited)

Basiclly its the same thing with l2j, you collect information from a database. but L2OFF servers uses a microsoft sql server the codes is a litile bit different.

for example
 

$link=@mssql_connect($ip, $user, $pass);
@mssql_select_db($database, $link) or die(mysql_error());

TL;DR use mssql instand of mysql

Edited by Snoopi
Posted

You'd be a lot better off putting this topic in the l2off dev section, and you'll even find plenty of exactly what you're looking for already shared there.

 

Basiclly its the same thing with l2j, you collect information from a database. but L2OFF servers uses a microsoft sql server the codes is a litile bit different.

for example
 

$link=@mssql_connect($ip, $user, $pass);
@mssql_select_db($database, $link) or die(mysql_error());

TL;DR use mssql instand of mysql

god help anyone who still uses these 15+ year old functions

 

please please please please PLEASE use pdo (with dblib for linux or sqlsrv for windows)

Posted

You'd be a lot better off putting this topic in the l2off dev section, and you'll even find plenty of exactly what you're looking for already shared there.

 

god help anyone who still uses these 15+ year old functions

 

please please please please PLEASE use pdo (with dblib for linux or sqlsrv for windows)

I assumed that its gonna be easier for him to understund the basic old functions plus he wants to adapt already coded scripts and i am like 99% sure they are coded with simple mysql querys, This will do his job, now if he wants something better he should study.

Posted

You'd be a lot better off putting this topic in the l2off dev section, and you'll even find plenty of exactly what you're looking for already shared there.

 

 

thank you, i will post it in l2off dev

Guest
This topic is now closed to further replies.


  • Posts

    • So dont plat that waste time&money server.   GM promises pie in the sky, but does nothing. It's all about money, money, money. And wipe.   SCAM server!
    • I'm looking for someone to remove GameGuard from a game that uses XTRAP. The game no longer uses XTRAP. I have a game server. But the client is kicked from the game after a few minutes of logging in. If I try to remove XTRAP (just by deleting it), the game opens and closes quickly.   Send me a PM. The game is Audition, a dance game.
    • 🎉 L2Dead StuckSub - GRAND OPENING 14 February 2026🎉 After beta, testing, mistakes, laughs and a lot of PvP, the moment has finally come. L2Dead StuckSub is officially opening its gates on 14 February 2026.   ⚔️What to expect: ✦Main Class +6 Stuck Sub system ✦Balanced PvP & custom party farm areas ✦Custom events, bosses and strong rewards ✦Competitive clan scene with castle rewards   📌Until the opening: ✦Create your clans and register them in the Clan-Register channel ✦Invite your friends / old parties / CPs ✦Stay tuned for more information (rates, events, siege times, etc.)   Get your setups ready, prepare your macros and your Discord/voice. On 14 February 2026 20:00 GMT+2, we write the first chapter of L2Dead together. 🔥 https://www.l2dead.com/ https://discord.gg/TGnATuZmdt
    • Here’s the **clean, L2jAcis-style way** to make **Auto Loot work ONLY for Premium players** on **Interlude**.   I’ll give you **two options** — pick what fits your server philosophy.   ---   ## ✅ OPTION 1 (BEST PRACTICE): Premium-Only Auto Loot (Code-based)   ### 🔹 Step 1: Add config option   **`config/Premium.properties`**   ```properties # Enable auto loot only for premium players PremiumAutoLoot = True ```   ---   ### 🔹 Step 2: Read config   **`Config.java`**   ```java public static boolean PREMIUM_AUTO_LOOT; ```   Load it:   ```java PREMIUM_AUTO_LOOT = Premium.getProperty("PremiumAutoLoot", false); ```   ---   ### 🔹 Step 3: Modify drop handling   **File:**   ``` net.sf.l2j.gameserver.model.actor.instance.L2MonsterInstance ```   Find **dropItems()** or **doItemDrop()** Replace / modify logic like this:   ```java if (player != null && player.isPremium() && Config.PREMIUM_AUTO_LOOT) {     for (ItemInstance item : items)         player.getInventory().addItem("AutoLoot", item, player, this); } else {     for (ItemInstance item : items)         dropItem(player, item); } ```   ✅ Result:   * **Premium players** → instant loot * **Normal players** → loot on ground   ---   ## ✅ OPTION 2: Auto Loot via Character Variable (More Flexible)   Useful if you want **GM control** per character.   ### 🔹 Premium activation   When premium is added:   ```java player.setVar("AUTO_LOOT", "1"); ```   ### 🔹 Drop check   ```java if (player != null && player.getVarB("AUTO_LOOT")) {     player.addItem("AutoLoot", item, player, true); } else {     dropItem(player, item); } ```   ---   ## 🎯 BONUS (Recommended Add-Ons)   ### 🔸 Adena always auto-loot (even non-premium)   ```java if (item.getItemId() == 57) {     player.addAdena("Loot", item.getCount(), this, true);     continue; } ```   ### 🔸 Party check (premium leader only)   ```java player.isInParty() && player.getParty().getLeader().isPremium() ```   ---   ## ⚠️ Notes (Interlude Safe)   ✔ Compatible with **L2jAcis Interlude** ✔ No client-side changes ✔ No exploit risk ✔ Retail-like behavior   ---      
  • 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..