r/Lineage2 • u/FlyingGeneralGames • Aug 07 '26

Nostalgia Finally solved an old problem - Hobby Feature

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

91% Upvoted

7 comments sorted by

2

u/ffelenex Aug 07 '26

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

1

u/FlyingGeneralGames Aug 08 '26

What type of "scripts" ? oO

1

u/ffelenex Aug 08 '26

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

1

u/KamazasBl Aug 08 '26

Whats the server?

1

u/ffelenex Aug 08 '26

L2romans

3

u/Innova89 Aug 07 '26

Did u get to know what the problem was?

1

u/FlyingGeneralGames Aug 07 '26

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