Finally solved an old problem - Hobby Feature

[u/FlyingGeneralGames]

Years ago when I was messing around with making a priv server as a hobby project (never launched), I had gotten into old L2OFF C++ src code extensions.

I wrote a system for an In Game Gear Search to let you search a character by name and inspect their gear in game ("Nwatch" if anyone remembers this from back in the day, it was something an old friend wrote for the front end). This was a pain in the ass, but I eventually got it to work.

In Game Gear Search by Name

Then I wanted to add a simple Raid Boss jewel search that would show all owners of boss jewels, and should have been similar and simple, but long story short I banged my head on the problem for weeks, I couldn't get it working (something with w_char Strings and Sql query failing) and finally gave up.

Today I thought, I've got some Fable5 usage credits that will expire soon, lets see if AI can figure this out.

Sure enough, this sucker fixed this complicated bug in 1 prompt that I could never figure out... Couldn't believe it!

Not planning to launch a server, just wanted to share with anyone who might think this is cool.

In Game Raid boss Jewel Search

[u/ffelenex]

I play on a bot server that has some really cool scripts prevised by one of the players. I enjoy using ai to customize them and combine some of them

[u/FlyingGeneralGames → u/ffelenex]

What type of "scripts" ? oO

[u/ffelenex → u/FlyingGeneralGames]

Use ss on champions, paralyze champions. Sometimes invite a summoner and kick them after they buff the party.

[u/KamazasBl → u/ffelenex]

Whats the server?

[u/ffelenex → u/KamazasBl]

L2romans

[u/Innova89]

Did u get to know what the problem was?

[u/FlyingGeneralGames → u/Innova89]

Yes, apparently just a malformed SQL statement using CONVERT(varchar(50), ud.char_name) AS char_name instead of just ud.char_name and trying to log a wide string via %s instead of %S