eressea

Hi, eressea! No updates at rebaff skills

Hi, what?

Seems like it's made just in AI - just search for something like this:

	push_event	//  talker
	push_const 40			//talker
	add
	fetch_i			//race
	push_const 152			//race
	add
	fetch_i4
	push_const 2			//unary->INTEGER_CONST
	equal
	branch_false L3894

in AI classes derived from guild_master_lv3 - the example above is for (light) elf so there's compare against value '2' (dark elf), for dark elves there will be push_const 1 (to compare if talker isn't light elf)

Do you mean something like this?

count1 = st.getQuestItemsCount(Item1)
count2 = st.getQuestItemsCount(Item2)

if count1 > 0 and count2 > 0:
    # some code
 

 

I don't really expect this event to work flawlessly as my researches showed that it's quite bugged on the Dr. Turkey Stage and I doubt anyone cared about it enough to fix it (at least publicly), and so you can't have santa delivering gifts at random.

I know this is really OLD topic but I found it and was wondering if anyone fixed this bug... It seems like not so here is the fix:

https://bitbucket.org/l2shrine/extender-public/commits/7d50800c41430bbee136b1751062e6eb02f7cb9f

The whole problem is in l2server side support for NPC function CreateOnePrivateNearUser. It sends CreatePacket but Koreans made some changes in it (added instance ID) so it got broken. As Santa event is the only AI that uses this function, they probably don't know about it :)

You have two possible choices:

1. Wait until the closed socket expires

2. Fix l2j code to reuse the closed socket - find all occurrences of "new ServerSocket();" and then (right on the next line) add call "socket.setReuseAddress(true);" on that socket

Ohhhhhhhh dear god, help us... 

Wut? oO

First, you've probably set some password when installing MySQL.

Second, you shouldn't use root (administrator) MySQL account for running l2j - you should create another user, eg. run this under root:

GRANT ALL PRIVILEGES ON gameserver.* TO gameserver@localhost IDENTIFIED BY 's0m3n3wp455w0rdf0rg4m353rv3r'; -- create gameserver user

GRANT ALL PRIVILEGES ON loginserver.* TO loginserver@localhost IDENTIFIED BY 's0m3n3wp455w0rdf0rl0g1n53rv3r'; -- create loginserver user

FLUSH PRIVILEGES; -- just for sure

and then use username "gameserver" in gameserver and "loginserver" in loginserver... (look in gameserver.properties and loginserver.properties)

Elementary, my dear Watson

EDIT: sorry, I had 'l2j' in the grant query instead of 'loginserver' / 'gameserver' - now it should be ok

Why C4? If you want C4, you don't need any big extender (just few security bugfixes), if you want Interlude, it would be better to base it on GF and just remove few features (most of them already can be disabled in MyExt64 config, the only two big features left are putting buffs+s/d together and to change reuse time calculation) and change packets to be compatible with older client (not so difficult)

Seems like you have some protection against SQL injections and you have apostrophe (') in string coming to the database.

If it automatically escapes it to \', everything should be OK. If not, get some better protection :)

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... :)

 

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

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.

You can safely ignore there "errors"

If you're ever bored for something to do eressea, L2NPC from GF contains the fully functioning lexer/parser for NASC compilation, just doesn't have the init procedures/constructors

I'm still not that far... Give me some more time, I've started with l2off hacking 2016/03 :D That was the first time I've installed IDA Pro and tried to start learning x64 asm...

Then sell Compiller.

As far as I know it also doesn't decompile everything (not speaking about compiler, that works)

It's not packing and unpacking, but decompilation from npcd ai.obj code to ncsoft's nasc language and compilation back. Afaik there's no tool publicly available that can do it with whole ai.obj properly. If I'm wrong, please send me link where I can buy it :)

You are not a man? Are we talking to an alien? :D

Lol, sometimes I really feel like an alien in this world

Thanks for the help. The man knows his stuff! Did, for which I am very grateful to him!

I'm not a man, but no problem :)

So it seems that problems are caused by the loader - better use patched binaries that load the extender.

http://download.l2shrine.com/L2ServerMyExt64.exe

http://download.l2shrine.com/CachedMyExt64.exe

http://download.l2shrine.com/L2NPCMyExt64.exe

I don't know this web panel, what language is it written in? Where can I find it?

Do you use procotol 83 or procotol 152 (in MyExt64.ini)?

L2Npc log

Are you using Gracia Final rev 83 npcd?

i cant oppen engine.dll what program i shoud use to open it?

You need IDA pro or ollydbg (and some other tools to unpack it if engine.dll is packed) but as Versus said, it would be easier to do on server side.

Hm send me also npcd logs

What's in l2server logs (system, err)?