Hi i have little problem with my top adena web script. My problem is that when someone have adena in inventory and in warehouse too, he is in top adena rank two times. One with adena in inventory and one time with adena in warehouse. I need help with command that will show only total amount of adena per user. If someone can help i will be glad :)
this is what i got in script:
WHERE builder = 0 AND account_id > 0 AND user_item.item_type = 57
ORDER BY adena DESC
dunno what command should have for warehouse column to count as one...
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Hello.
1. Make sure to use in your xml:
<set name="usingServerSideName" val="true"/>
<set name="usingServerSideTitle" val="true"/>
2. And in npcname-e.dat do not use any name (not even a one space)
In my case 50011 is Agathion
Question
relic
Hi i have little problem with my top adena web script. My problem is that when someone have adena in inventory and in warehouse too, he is in top adena rank two times. One with adena in inventory and one time with adena in warehouse. I need help with command that will show only total amount of adena per user. If someone can help i will be glad :)
this is what i got in script:
WHERE builder = 0 AND account_id > 0 AND user_item.item_type = 57
ORDER BY adena DESC
dunno what command should have for warehouse column to count as one...
Thanks
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.