Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
  • 0

Connection Mysql / Sql

gzen

Asked by gzen,

 Share

Question

gzen Newbie

gzen

Posted
Posted
Hello friends, good night.
Today I desperately ask for help from you.
For a long time I've been trying to solve these problems, I've gained the site of a friend L2OFF but it does not connect to mysql and does not accept this sql, the server I use and the L2OFF Vanganth 1.2.3.6 Interlude
 
If anyone can solve these problems for me via skype I will be very grateful.
I know someone here knows how to solve it, so I want people who do not know. "Remember the humility that counts"
 
Here are the images:
 
First image: ERROR connect to mysql
 
9sDzdWU.jpg
 
Second image: sql error
 
uwKqIJH.png
 

I know it's simple things for a person who knows, please help me, I can not take it anymore!
 
thank you all !
 

12 answers to this question

Recommended Posts

  • 0
eressea Newbie

eressea

Posted
Posted

Those are two different SQL databases - https://en.wikipedia.org/wiki/Microsoft_SQL_Server and https://en.wikipedia.org/wiki/MySQL

If the web is written for MySQL, you'll need to install it, you can get it here (don't worry it's called MariaDB, think of it as of better MySQL): https://downloads.mariadb.org/

Also you can't run MySQL queries in Microsoft SQL Server - you need to create all the stuff in MySQL (MariaDB) database.

  • 0
Elfo Contributor

Elfo

Posted
Posted

Those are two different SQL databases - https://en.wikipedia.org/wiki/Microsoft_SQL_Server and https://en.wikipedia.org/wiki/MySQL

If the web is written for MySQL, you'll need to install it, you can get it here (don't worry it's called MariaDB, think of it as of better MySQL): https://downloads.mariadb.org/

Also you can't run MySQL queries in Microsoft SQL Server - you need to create all the stuff in MySQL (MariaDB) database.

  • There actually way more sql databases
  • MySQL queries are almost identical to SQL Server and the only major differences would be the limit keyword in MySQL which is TOP in SQL Server, some update with joins queries and stored procedures that no one in this forum ever used.
  • 0
eressea Newbie

eressea

Posted
Posted

 

  • There actually way more sql databases
  • MySQL queries are almost identical to SQL Server and the only major differences would be the limit keyword in MySQL which is TOP in SQL Server, some update with joins queries and stored procedures that no one in this forum ever used.

 

 

MySQL/MariaDB nowadays is far more advanced than the old SQL Server we use for l2off...

 

There is bunch of differences, not just stored procedures, but also lot of different built-in functions (much more advanced work with datetime/unix timestamps), triggers, named locks, master-slave replication, galera (wsrep) clustering, ...

 

SQL Server 2005 is really old stuff I'd not recommend for anything except l2off (and for l2off just because it requires this particular version)

  • 0
xxdem Newbie

xxdem

Posted
Posted

MySQL/MariaDB nowadays is far more advanced than the old SQL Server we use for l2off...

 

There is bunch of differences, not just stored procedures, but also lot of different built-in functions (much more advanced work with datetime/unix timestamps), triggers, named locks, master-slave replication, galera (wsrep) clustering, ...

 

SQL Server 2005 is really old stuff I'd not recommend for anything except l2off (and for l2off just because it requires this particular version)

 

Codecrash is ignorant enough to deny that MariaDB is the best rdbms, don't waste your time

  • 0
xxdem Newbie

xxdem

Posted
Posted (edited)

at the moment he is googling for the proper benchmark images that MariaDB gets outperformed by that MS crap  :gtfo:

Edited by xxdem
  • 0
eressea Newbie

eressea

Posted
Posted

Codecrash is ignorant enough to deny that MariaDB is the best rdbms, don't waste your time

 

You can't simply say it's best - it's best for some purposes, but some databases are better for other purposes.

 

For example if I wanted to work with map coordinates, I would use PostgreSQL because there's PostGIS geographical extension for this database.

For "normal" stuff I'd use MySQL but when it comes to some big amounts of data (billions of rows etc), MySQL can have problem with it.

If I valued stability most of all, I'd maybe use Oracle database and if I wanted to have something to smoothly cooperate with other parts of Microsoft ecosystem, I'd use Microsoft SQL Server.

There are even more SQL databases, notably sqlite which is great if you need to have SQL engine embedded in your application. And more and more... :)

  • 0
xxdem Newbie

xxdem

Posted
Posted

You can't simply say it's best - it's best for some purposes, but some databases are better for other purposes.

 

For example if I wanted to work with map coordinates, I would use PostgreSQL because there's PostGIS geographical extension for this database.

For "normal" stuff I'd use MySQL but when it comes to some big amounts of data (billions of rows etc), MySQL can have problem with it.

If I valued stability most of all, I'd maybe use Oracle database and if I wanted to have something to smoothly cooperate with other parts of Microsoft ecosystem, I'd use Microsoft SQL Server.

There are even more SQL databases, notably sqlite which is great if you need to have SQL engine embedded in your application. And more and more... :)

 

afaik postgre is not pure rdbms

  • 0
Elfo Contributor

Elfo

Posted
Posted

at the moment he is googling for the proper benchmark images that MariaDB gets outperformed by that MS crap  :gtfo:

Im actually using MariaDB, and im not using SQL Server so i don't get your points. I just said that MariaDB queries that l2 uses wouldn't be hard to adapt from sql server if that's what you want to do.

 

I do agree that MariaDB is by far the best option and it trashes SQL Server in both performance and expenses.

  • 0
Smith Newbie

Smith

Posted
Posted

OMG - this config php for l2j. / you try connect db L2OFF.

Change for mssql_connect

 

- Sua configuração está pra L2J, desta forma não funcionará pra L2OFF.

- mude a forma de config do site e libere a o mssql no xamp, caso contrário não funcionará.

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
 Share
Go to question listing


  • Posts

    • l2viserion
      L2VISERION CHAPTER IV - 16.05.2026

      By l2viserion · Posted

      And Discord: https://discord.gg/3aYqWNqb
    • l2viserion
      [L2] VISERION

      By l2viserion · Posted

      Ofc: https://discord.gg/3aYqWNqb
    • NoJobRob
      Skins for H5

      By NoJobRob · Posted

      You can find some H5 skins shared in old L2 modding Discords, but most of the higher‑quality ones are either paid or come bundled with full client edits. I usually mix in commissioned work and whatever I can patch myself. On a side note, I fund a lot of these commissions by selling off game items through instant sell cs2 skins, which has been a quick way for me to get some cash for projects.
    • Elfo
      Outerlude - A Modern Interlude aCis fork

      By Elfo · Posted

      There is no need for gRPC in this case, even tho originally it was gRPC based but since we don't need it to be bi-directional, we switched to simple http requests for the web calls and SSEs for the data streamed from the server. There are distributed locks in place to precent race conditions between actions that can happen between multiple web instances and the server.   Local models can also be slow depending on the model, and most external models can actually be faster than local ones if you use Flash 2.5 or something along those lines. I am running on 512GB of Unified Memory on my Mac Studio M3 Ultra so the speed of the local model for a small model is pretty good but I tested it with Gemini too and it works equally as fast and in some cases faster. The way it works is that I'm using pgvector (one of the benefits of moving to Postgres) to search the data and see what the player can see etc and there is some batching of the next few actions for 2-4 seconds for the user until the next LLM request fires. The batching also includes branching on logic so if they for example fall under some HP they will move to kiting instead of attacking or maybe they heal etc.   Everything is authed and permission-based. The server and the backend of the frontend have secure communication between them, either with a symmetric key (not recommended for production) or a certificate (the recommended way), so there is no worry. It's all tied to the account's access level, etc., so nobody can make an action that they normally wouldn't be allowed to do. Even the MCP is token-based, and there are prompt injection protections in place. The MCP is audited, and every mutation needs confirmation. The admin area is only accessible to the admin account anyway so normal users can't access it.  
    • Frank
      Outerlude - A Modern Interlude aCis fork

      By Frank · Posted

      Amazing job! Gratz!

  • 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..