eressea

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

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

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

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"

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

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

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

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

Are you using Gracia Final rev 83 npcd?

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