Jump to content

Recommended Posts

Posted

I've already noticed that a long time...
And in my previews reply I questioned that same point, and I left an example on how I think it should be  in case of an l2j mysql connection.
Should it look like this ? I couldn't connect either, so answers like your just beeing redundante don't help much, confirmation on the other hand help, like yes, or no, try it this way.
So I'll ask again, should it be like this?
 

connectionString_lin2world="Data Source=localhost;port=3306;Initial Catalog=SampleDB;User Id=mudassar;password=pass@123"

connectionString_lin2db="Data Source=localhost;port=3306;Initial Catalog=SampleDB;User Id=mudassar;password=pass@123"

 

because what is left there doesnt have login and password to connect to the database:

"ConnectionString_lin2world": "Data Source=PJASICEK-PC\\SQLEXPRESS;Initial Catalog=lin2world;Integrated Security=True",
    "ConnectionString_lin2db": "Data Source=PJASICEK-PC\\SQLEXPRESS;Initial Catalog=lin2db;Integrated Security=True",

from my breef contact with L2Off files I know there is a database lin2world and lin2db, on l2j there isn't one, so I'm a bit confused as to, am I looking at the proper place?

 

I've never worked on VIsual Studio to launch apps for webserver, so I'm learning, the same way I learned how to work with java, the difference is that on java there is a lot of documentation, or used to be, on asp.net regarding lineage 2 projects there isn't much.

 

If you could point me in the direction I need to go, I would really appreciate.

Thanks

Posted (edited)
On 22/04/2018 at 10:17 PM, .Elfocrash said:

You don't need a db connection on l2j mode because it is done on the server side with the L2ACP-api https://github.com/Elfocrash/L2ACP-api

So the connection is made to the port 8000, to the api correct?
I have my website in a differente server than my gameserver.
However I'm not beeing able to get a connection to the api on the gameserver, port 8000 is open, I've even tryed with DMZ on.
Is there anything we need to do on the API ?
and yes, before you question the obvious, I'm not using http://127.0.0.1:8000/api, im using it with my gameserver ip.  http://gameserver_ip_here:8000/api

Problem solved

Edited by abumini
problem Solved
Posted (edited)

When I run the gameserver with the API in it, and test the port 8000 to see if the application is listening, the report says it doesnt.

dumb question:
Does the website app needs to be on the same machine as the gameserver to be able to run the website application?

Problem solved, wrong number on NAS route. my bad....

Edited by abumini
Posted (edited)
On 28/05/2017 at 9:01 PM, .Elfocrash said:

The ApiKey can just be changed as long as you change it in both the web and the api projects.

 

The error you are getting is probably illegal key size because you dont jave some needed jre libraries installed.

 

http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html

 

Download JCE here and unpack in Java/Jre/lib/security

is this inside Eclipse or on the operative system java folder?

Answer:
This must go inside the cliente that's running the ASP.net
Got it working.

It now seems so simple -.-'

Sorry about beeing a pane in the ass for some.

 

Edited by abumini
Problem solved
  • 2 weeks later...
Posted

Hi again lol.
After getting it to work on windows, I embarqued on a new journey, trying to get it to work on linux!
And it hasn't been easy.

Anyone here who has this platform,  the website part, working with linux?

I could use some barinstorming or advices on what to use. 
And before you start posting links, I've already fallowed the one Elfocrash left from Microsoft on running .NET core project on apache

 

Posted

I am looking for an payment collecting service implementation (an endpoint to which paypal redirects after payment and then after security checks grants credits to balance). Unless this service is already implemented :D

My skype: tejada2000

Posted
3 hours ago, Mikel Alan said:

guys what wrong here , when i open the link in browser nothing showing

 

p_860tuzgu1.png

Your having permission errors, see if the user running the program has enought privileges.

Posted
1 hour ago, abumini said:

Your having permission errors, see if the user running the program has enought privileges.

Thanks sloved 

 

now when i open the url the control panel not open what must be the right path ? 

 

my path : %SystemDrive%\www\www.l2acpAr.com

 

Is there a specific folder that I should be specific to?
 

  • 4 weeks later...
Posted

Can anyone help me with the configuration, I'm confused as to the ip and address of mssql
 


"ApiEndpoint": "http://127.0.0.1:8000/api",
 "ApiKey": "elfocrash",
 "CryptoKey": "MnFfhZdXUn3u49c7AaejOL8FN58meFb9",
 "CryptoSalt": "4XPjl3jiEITf",

 

does it stay or chance her?


   

"ConnectionString_lin2world": "Server=.\\SQLEXPRESS;Database=Lin2World;User ID=db;Password=123",    "ConnectionString_lin2db": "Server=.\\SQLEXPRESS;Database=Lin2DB;User ID=db;Password=147852@server",
    

.\\SQLEXPRESS = does it stay or chance here?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Posts

    • Estou procurando cloacks do classic adaptadas para cliente interlude.
    • Good luck with your sales, but: Demo video. Show the siege, the olympiad, the tvt when you are selling something so complex and expensive.
    • 1.8 BILION NEW STOCK.70 E PER BILION DISCOUNT IF BUY ALL
    • ============================================================== VIKOS AUTOBOTS — live bots for Lineage 2 servers on Lucera2 Interlude and Classic ============================================================== An empty server loses players. Vikos Autobots fills the world with bots that act like real players: they farm, walk around towns, join clans, fight wars, go to raids, sieges, events and the Olympiad, trade and talk in chat. Installs on top of a Lucera2 build: one .ext.jar + the data/autobots folder + a config. Database tables are created automatically. WHAT THE BOTS DO • Farm zones by level along set routes; they do not steal mobs from players or other bots. Leave town through gatekeepers (custom ones and NPC bypasses too) and come back. • Some bots leave the farm to walk around town while others keep farming, so towns are not empty. They walk, talk to NPCs and sit down to rest (can be turned off for PvP servers). • After a server restart bots carry on where they were: same zone, same route, no mass teleport to town. • Class-based combat AI: fighters, archers, mages, healers, buffers, summoners. Auto parties, healers resurrect the dead. • Real fishing with core skills (cast, Pumping / Reeling, fish fight). Rod by grade, bait and fishing shots are handed out automatically; spots have stands, a bot limit, levels and time. • Gear by class and level, a separate Olympiad set and an "online time" set; custom skills by class and by online time (same idea as time gear). Random enchant, Life Stones, dyes, buffs. Shots, potions, arrows and scrolls restock on their own; bot items never reach the economy. • Clans and alliances with generated crests, clan wars, clan defense, PvP server mode. PvP zones (arena, Coliseum, custom): admin Send or a clock like TvT (14:00;16:00). • Raids and epics (Antharas, Valakas, Baium; more via XML), with a gathering in town or a direct teleport to the boss. Castle sieges, TvT / CTF / DM, Olympiad 1v1 and 3v3, Seven Signs. • Private stores (sell and buy), RU/EN chat, AI chat (Groq or any OpenAI-compatible API), bot replies go through your server chat filter (chatfilters.xml), player PMs forwarded to admin Telegram. • Admin panel: //autobots panel. Online schedule, own AI thread pool built for hundreds of bots online, one commented config and XML files checked at server start. INCLUDED: VIKOS AUTOBOTS CONFIGURATOR (Windows) • A single .exe with Java inside, nothing to install. • Works right on your VPS over SSH/SFTP: edit and save, the files go straight to the server; the old version goes to backup. • World map from server geodata, automatic route building by the core movement rules with checks. • Farm zones, towns, raids, sieges, TvT, PvP zones, fishing spots. • Editors with client icons: equipment (farm / online time / Olympiad), skills (regular and by online time), buffs, Life Stones, supplies, dyes. Finds config mistakes by itself. • Interlude and Classic, RU/EN interface, light and dark theme, F1 help. ============================================================== VIKOS AUTOBOTS — REAL SERVER LOAD Measured ============================================================== Interlude test server on Lucera2, a regular VPS: • 4 vCPU, 8 GB RAM, Debian 13 • Java 17 (Temurin), -Xmx5G • MariaDB -------------------------------------------------------------- RESULTS -------------------------------------------------------------- CPU is a one-minute average for the whole game server process: core, mobs and bots together. 400% = all 4 cores. Bots online Server CPU (of 400%) Share of VPS 1000 ~103% ~26% 1200 ~105% ~26% 1500 ~120-150% ~30-37% • An empty server without bots uses ~40% by itself, so 1000 bots add about one core. • The bot AI itself (all bots together) takes 10-15% of one core for 1000-1500 bots. • Memory is stable, no leaks: - after GC the heap stays at ~2.8-2.9 GB with 800, 1000 and 1200 bots — about the same as the server uses by itself, without bots; - the heap low point does not grow over time: memory does not pile up, it is freed on every garbage collection; - a full night with 1500 bots with no out-of-memory errors (OutOfMemory), the server never crashed; - with -Xmx5G there is more than 2 GB of headroom. • A full night with 1500 bots ran stable. Meanwhile the bots live a full life: farming along routes, walking around towns, fishing, clans, scheduled PvP zones, TvT/CTF, Olympiad and raids. -------------------------------------------------------------- SETTINGS USED FOR THESE NUMBERS -------------------------------------------------------------- • AutobotsIterationDelayMs = 500 A bot thinks twice per second: enough to act like a real player without wasting CPU. • AutobotsMaxBots = 1000-1500 • ai.properties: AiTaskActiveDelay = 500 AggroCheckInterval = 500 Most of the load comes not from the bot code but from the mobs around the bots: bots bring locations to life, and the mobs start checking whom to attack. With these values they check twice per second instead of four times. The load is almost halved, and you can't see the difference: a mob notices its target a fraction of a second later. • MariaDB: innodb_flush_log_at_trx_commit = 2 The database flushes its log to disk once per second instead of after every small query. With 1000+ bots there are many queries, and this removes most of the database load. A standard setting for game servers. • server.properties: AutoDestroyDroppedItemAfter = 120 Drops on the ground disappear after 2 minutes instead of 10. Bots kill a lot, and in 10 minutes tens of thousands of items piled up on the ground: extra memory, extra server work and database deletes. Two minutes is enough for players to pick up their own drops. Rule of thumb: a 4-core VPS handles 1000-1500 bots comfortably. For more, go for 6-8 cores. LICENSE • The license is bound to your VPS IP: the bots run only on the server with that IP. • Send the server IP when you buy. Price: 500$ Contact: Telegram @Vikos177 — https://t.me/Vikos177 Test the bots here: <DOWNLOAD LINK> https://drive.google.com/file/d/1xpOII2X2fsUWekDIJk7POTMWu7ICpHJo/view After purchase you are added to a private Telegram group for clients: news, updates and support. ==============================================================
    • 💻 Supercharge your workflow with Claude Pro & Cursor AI. Clean setups with full warranty included!
  • 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..