Screenshot.
When cached complains on sql errors:
Check stored proc it complains on, does it exist?
Are params cached sending match it?
Does tables exist?
etc etc.
Verify that communication sent matches whats availeble in DB.
Does not exist, and would be useless if created by customly\ by us.
(Correction: Has not leaked from the few russkies that have it).
Use L2J datapacks as a reference point.
Even tho that's a lovely joke for data-accuracy it's the best there is.
So fix it.
Investigate.
Copy pasting crap left and right won't work in 99% of the cases.
Are you sure your doing it correctly even?
If you don't really know what your doing - why do you expect it to work out of the box?
1. Look up and create complicated join\inner\union Queries.
Google instead of ask - this is SQL, not L2Off.
2. Write 2 queries, one with warehouse = 0 and warehouse = 1.
Add together result in php\html where matched char_id.
1. Get Pack.
2. Unpack pack.
3. Install MSSQL
4. Run MSSQL scripts.
5. add wan ip in lin2db.dbo.server and port.
6. add ODBC entries for lin2world\lin2db - move cached .dsn file from native ODBC to x86 ODBC path in programfiles.
7. Run Exe's -> Auth > CacheD> L2Server > L2NPC
Done.
http://fyyre.ivory-tower.de/
Unicode chat.
Incl. source and POC.
Alternative:
Find Arabic server - check system folder for custom dlls and\or filesizes of fire\nwindow .dll
Oh look it's mac that knows nothing.
When an answer cannot be found fast - it's cause it requires hooks\code to achieve.
General tule of thumb.
I remember you can disable drops by l2server.ini under the event\rate parameters.
Atleast there we're params for it - wonder if they work tho.
EDIT:
Actually now i'm unsure - someone go check in IDA.
Google is your friend.
Now once you learn that HWID is not a standardized way of trying to define a computer - you'll hopefully also realize trying to change it is impossible - without knowing exactly what the HWID your trying to change consists of in the first place.
ai.obj per quest, unique rewards.
Adena reward controlled by l2server.ini along with xp\sp - however will mutiply ALL instances.
So negative ammounts (like sp for clan) will be modified too.