[SQL] Partially working USP_ITEM_RECYCLE

does 581.02 report errors in log? what SP is it using? what does that SP return?

its nice to have a working function but it doesnt tell me much unless you tell me those things or even better, post the working SP.

great thanks for that one chreadie :)

Quote:

---

Originally Posted by chreadie

does 581.02 report errors in log? what SP is it using? what does that SP return?

its nice to have a working function but it doesnt tell me much unless you tell me those things or even better, post the working SP.

---

no errors in any log ive seen im thinking with the right hex editing on the exe it might work instantly instead of login then logoff

Just a question couldnt we just comment out the need for the USP_ITEM_RECYCLE in any sql files and have recycle works cause that one exe doesnt show logs of errors or anything just relog and bam you have your items

@chreadie when you mean partially working do you mean everything works upon loutout and back in ? like all color changes etc

ive only tested strength boosters and other simple items

i thought so.. LoL

Since this is still an issue, I'd like to mention something.

Code:

---

<RECYCLE><MINUS SEQ='1' TYPEID='402653192' ITEM_ID='375' C0='2' ISPARTS='0' /><MINUS SEQ='2' TYPEID='402653185' ITEM_ID='8' C0='1' ISPARTS='0' /><MINUS SEQ='3' TYPEID='402653189' ITEM_ID='5' C0='1' ISPARTS='0' /><PLUS SEQ='1' ITEM_ID='4' TYPEID='402653188' C0='1' ISPARTS='0' /></RECYCLE>

---

This is the simple production of 1 Power Potion. The Only Problem which is still persisting, is that there is the wrong return code. No I correct myself: There is no Return Code at all. Below is the reason shown why.

Code:

---

[N_RECYCLE] XML : <RECYCLE><MINUS SEQ='1' TYPEID='402653192' ITEM_ID='375' C0='2' ISPARTS='0' /><MINUS SEQ='2' TYPEID='402653185' ITEM_ID='8' C0='1' ISPARTS='0' /><MINUS SEQ='3' TYPEID='402653189' ITEM_ID='5' C0='1' ISPARTS='0' /><PLUS SEQ='1' ITEM_ID='4' TYPEID='402653188' C0='1' ISPARTS='0' /></RECYCLE>
[E_RECYCLE] RETURN : ERROR((null))
[E_RECYCLE] DB Commmand Return Failed

---

I cannot fix it, since I do not know the name/names of the columns which will lead to completion and the Error is pointing to null, means no error message. It's like the old UnrealED times, a window containing:

Titlebar: Error [X]
Content: (Red X-Icon) Unexpected Error
[OK-Button]

Quote:

---

Originally Posted by hvdaedalus

It's like the old UnrealED times, a window containing:

Titlebar: Error [X]
Content: (Red X-Icon) Unexpected Error
[OK-Button]

---

Off-topic just real quick: Another UnrealEd developer, eh? For as popular as it was I don't see many other people who even know what that is! Awesome.

The absolute worst incarnation was the Deus Ex engine. It was absolutely painful having so much work disappear because the engine itself is/was just so unstable. I was saving every map project every 2 minutes or 10 actions, haha... :/

Okay, sorry for the off-topic. :)

Yeah, I know what you mean. Deus Ex was such a great game, but the engine itself was a crippled thing. Now B2T:

I have been debugging the gameserver, but it is a pain in the ass. I have been doing it for 2-3 hours now, but I couldn't solve it. Maybe I am not so good at asm after all. If anyone is better than me:

For Olly: Search in Memory for "dbo.USP_ITEM_RECYCLE" and mark the whole Hex-Stuff (Hex or ascii section, doesn't matter). Set a BP there (for Olly 1.x: Memory - On Access, for Olly 2.x: Break on everything (Read, Write, Execute)) and go through the jumps until you get to the sql returning section (have no address on that, you need to find out yourself) and find out why the gameserver is saying: ERROR ((null))