|
You last visited: Today at 01:32
Advertisement
[Sql] Check All Char Items By Charname
Discussion on [Sql] Check All Char Items By Charname within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
05/05/2013, 18:03
|
#1
|
elite*gold: 460
Join Date: Jul 2012
Posts: 394
Received Thanks: 271
|
[Sql] Check All Char Items By Charname
Hello Ebx7
Today i will release Query To check All Char Items By CharName
i hope you like it
Code:
Select INV.CharID, CH.CharName16, INV.ItemID, IT.OptLevel, IT.RefItemID, INV.Slot, REF.ReqGender, REFC.AssocFileICon128, REF.Dur_L, REF.Dur_U, REF.PD_L, REF.PD_U, REF.MD_L, REF.MD_U, REF.ER_L, REF.ER_U, REF.PDStr_L, REF.PDStr_U, REF.MDInt_L, REF.MDInt_U, REF.MaxMagicOptCount, REF.PAttackMin_L, REF.PAttackMin_U, REF.PAttackMax_L, REF.PAttackMin_U, REF.MAttackMin_L, REF.MAttackMin_U, REF.MAttackMax_L, REF.MAttackMin_U, REF.Range, REF.HR_L, REF.HR_U, REF.CHR_L, REF.CHR_U, REF.PAStrMin_L, REF.PAStrMin_U, REF.PAStrMax_L, REF.PAStrMax_U, REF.MAInt_Min_L, REF.MAInt_Min_U, REF.MAInt_Max_L, REF.MAInt_Max_U, REF.PAR_L, REF.PAR_U, REF.MAR_L, REF.MAR_U, REFC.ReqLevel1, REFC.CodeName128 From _Inventory As INV
Right Join _Items As IT On INV.ItemID = IT.ID64
Right Join _RefObjItem As REF On IT.RefItemID = REF.ID
Right Join _RefObjCommon As REFC On REFC.ID = REF.ID
Right Join _Char As CH On CH.CharID = INV.CharID
Where CH.CharName16 = 'Mr.KingDollar'
Order By Slot Asc
Credits : Select ID,CreaterName From _Credit
Result
ID=1
CreaterName=Mr.KingDollar
xD :P
|
|
|
05/08/2013, 18:55
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,310
Received Thanks: 6,470
|
#approved
|
|
|
05/08/2013, 19:01
|
#3
|
elite*gold: 0
Join Date: Feb 2009
Posts: 1,064
Received Thanks: 539
|
That's not worth a thread lol
Everyone with knowledge of SQL can do that in one minute
|
|
|
05/08/2013, 19:10
|
#4
|
elite*gold: 0
Join Date: Jun 2007
Posts: 718
Received Thanks: 378
|
Why approved? And it's not his query :
100% similary.
I don't know why I hate special-magician
Quote:
|
|
|
05/08/2013, 19:12
|
#5
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
Quote:
Originally Posted by Special-Magician
Hello Ebx7
Today i will release Query To check All Char Items By CharName
i hope you like it
Code:
Select INV.CharID, CH.CharName16, INV.ItemID, IT.OptLevel, IT.RefItemID, INV.Slot, REF.ReqGender, REFC.AssocFileICon128, REF.Dur_L, REF.Dur_U, REF.PD_L, REF.PD_U, REF.MD_L, REF.MD_U, REF.ER_L, REF.ER_U, REF.PDStr_L, REF.PDStr_U, REF.MDInt_L, REF.MDInt_U, REF.MaxMagicOptCount, REF.PAttackMin_L, REF.PAttackMin_U, REF.PAttackMax_L, REF.PAttackMin_U, REF.MAttackMin_L, REF.MAttackMin_U, REF.MAttackMax_L, REF.MAttackMin_U, REF.Range, REF.HR_L, REF.HR_U, REF.CHR_L, REF.CHR_U, REF.PAStrMin_L, REF.PAStrMin_U, REF.PAStrMax_L, REF.PAStrMax_U, REF.MAInt_Min_L, REF.MAInt_Min_U, REF.MAInt_Max_L, REF.MAInt_Max_U, REF.PAR_L, REF.PAR_U, REF.MAR_L, REF.MAR_U, REFC.ReqLevel1, REFC.CodeName128 From _Inventory As INV
Right Join _Items As IT On INV.ItemID = IT.ID64
Right Join _RefObjItem As REF On IT.RefItemID = REF.ID
Right Join _RefObjCommon As REFC On REFC.ID = REF.ID
Right Join _Char As CH On CH.CharID = INV.CharID
Where CH.CharName16 = 'Mr.KingDollar'
Order By Slot Asc
Credits : Select ID,CreaterName From _Credit
Result
ID=1
CreaterName=Mr.KingDollar
xD :P
|
Applause for the bold part..
It's wrong, your query is wrong.. _Items.RefItemID = _RefObjCommon.ID not _RefObjItem.ID..
And why wouldn't you use an inner join, but a right join? You're releasing something that is apparently not even tested, despite the fact that it's not worth a release anyway.
|
|
|
05/09/2013, 01:24
|
#6
|
elite*gold: 460
Join Date: Jul 2012
Posts: 394
Received Thanks: 271
|
Quote:
Originally Posted by gigola123
Why approved? And it's not his query :
100% similary.
I don't know why I hate special-magician
|
Thanks You My Love :$
and btw i do it and release it before know if its released before or no
Quote:
Originally Posted by Schickl
That's not worth a thread lol
Everyone with knowledge of SQL can do that in one minute
|
So What xD ?
Quote:
Originally Posted by IceAmStiel
Applause for the bold part..
It's wrong, your query is wrong.. _Items.RefItemID = _RefObjCommon.ID not _RefObjItem.ID..
And why wouldn't you use an inner join, but a right join? You're releasing something that is apparently not even tested, despite the fact that it's not worth a release anyway.
|
i tested it before release and working 100%
|
|
|
05/09/2013, 01:41
|
#7
|
elite*gold: 0
Join Date: Jun 2007
Posts: 718
Received Thanks: 378
|
Quote:
Originally Posted by Special-Magician
Thanks You My Love :$
and btw i do it and release it before know if its released before or no
|
By whyt3boi there is the link
Quote:
Code:
Use SRO_VT_SHARD_INIT
Select CH.CharName16, INV.CharID, INV.ItemID, IT.OptLevel, IT.RefItemID, INV.Slot, REF.ReqGender, REFC.ReqLevel1, REFC.CodeName128 From _Inventory As INV
Right Join _Items As IT On INV.ItemID = IT.ID64
Right Join _RefObjItem As REF On IT.RefItemID = REF.ID
Right Join _RefObjCommon As REFC On REFC.ID = REF.ID
Right Join _Char As CH On CH.CharID = INV.CharID
Where CH.CharName16 = 'Pal2aDoX' And INV.Slot <= '12'
Order By Slot Asc
|
|
|
|
05/09/2013, 01:51
|
#8
|
elite*gold: 460
Join Date: Jul 2012
Posts: 394
Received Thanks: 271
|
Quote:
Originally Posted by gigola123
By whyt3boi there is the link
|
yes i see it now
but really i never saw it before
i just do it to help some people not more
|
|
|
05/09/2013, 14:01
|
#9
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
Quote:
Originally Posted by Special-Magician
i tested it before release and working 100%
|
It might seem to be working, but only because the _RefObjItem.ID often equals to the _RefObjCommon.ID in the first segment of items. But the _RefObjItem.ID is actually the _RefObjCommon.Link value.
Add a new item and try to find it with your query in an inventory, it might output even monsters on slots..
Code:
SELECT c.CharID, c.CharName16, i.*, r.CodeName128, ri.MaxStack
FROM dbo._Inventory i
JOIN dbo._Items it on i.ItemID = it.ID64
JOIN dbo._RefObjCommon r on it.RefItemID = r.ID
LEFT JOIN dbo._RefObjItem ri on r.Link = ri.ID
JOIN dbo._Char c on i.CharID = c.CharID
WHERE c.CharName16 = 'Blablubb'
ORDER BY Slot asc
|
|
|
05/09/2013, 14:49
|
#10
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,310
Received Thanks: 6,470
|
it is true
That other thread existed before
this releases, since they are so "random", are hard to remember if other exist
#closed
|
|
|
|
Similar Threads
|
WTT CHAR ! CHECK THIS
02/12/2012 - Archlord Trading - 2 Replies
WTT Swashy lvl 91 on Sylvia for another char on all servers just need to be lvl 70+
Swash have
Bg top 4/4 (resis stone lvl6 / hp lvl6/cast lvl6 /ashtal)
Cf boots extra dodge against ranged attacks 3% 2/2 (mov speed / lucky) lvl 3
Bg gloves 0/2
Elite skirt (pretty good)
Karkaen neck 1/1 (infinity lvl3)
2x Glorious sword eater rings 0/0 (rings give 7% crit each)
|
WTS/WTT CHAR ISRO LV90FF FOR ZSZC WATER CHAR OR ITEMS/GOLD
04/04/2011 - Silkroad Online Trading - 8 Replies
Hello guys im trading my char Lv89FF Glavier on isro server GAIA for char on server water or items/gold
here info:
skills: heuksal 89FF, fire 89FF, light 80FF, 20ice
sp left: 99k
Set: +3+5 FB
email: no verified
so LEAVE OFFERS
|
CHECK IT OUT!!!!WTB CHAR ON SPARTA
07/13/2010 - Silkroad Online Trading - 2 Replies
as the topic says, wtb char on sparta!!!
The account should not be email verified
Must be lv 95++ with items, FF and at least 1 avatar!
I can pay with $ or other char lv 101(bow)!!! pm me at:
MSN: [email protected]
YM: [email protected] :pimp:
|
How to check char stats
04/10/2010 - Silkroad Online - 1 Replies
Anyone knows how to calculate to check if a char is pure int or pure str?
Many thanks
|
WTB/WTT sjsro new char check it
10/11/2009 - Silkroad Online Trading - 2 Replies
i have lvl 90 full str glavier!
set:+3:/ 85-90 not full blue but nice... 90 fire 90 lightning 90 heuksal 30 cold
weapon:+5 FB crit 11 phy 61%
money:10kk
dead monkey.much droped items in storage.
I have lvl 90 full int spear char.
set:+4+5(only helm) full blue!
|
All times are GMT +2. The time now is 01:32.
|
|