|
You last visited: Today at 20:15
Advertisement
Help!!
Discussion on Help!! within the SRO Private Server forum part of the Silkroad Online category.
01/16/2018, 13:40
|
#1
|
elite*gold: 0
Join Date: May 2017
Posts: 5
Received Thanks: 0
|
Help!!
i cant put any blue in this database i have problem how i can fix it
|
|
|
01/16/2018, 15:56
|
#2
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,440
|
Can you show us the avatar? Check _RefObjItem.MaxMagicOptCount (Table.Column), that column controls how many "blues" you can add to the item.
|
|
|
01/16/2018, 18:14
|
#3
|
elite*gold: 0
Join Date: May 2017
Posts: 5
Received Thanks: 0
|
Quote:
Originally Posted by Snow*
Can you show us the avatar? Check _RefObjItem.MaxMagicOptCount (Table.Column), that column controls how many "blues" you can add to the item.
|
i found some link's code at RefObjectCommon of some avatars it's 0
|
|
|
01/16/2018, 18:24
|
#4
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 49
|
Quote:
Originally Posted by 7modii1
i found some link's code at RefObjectCommon of some avatars it's 0
|
there is the problem, have 0, change it attach 1, hat 2, dress 4
|
|
|
01/16/2018, 18:51
|
#5
|
elite*gold: 0
Join Date: May 2017
Posts: 5
Received Thanks: 0
|
Quote:
Originally Posted by loader8
there is the problem, have 0, change it attach 1, hat 2, dress 4
|
Thx I've done the most of the avatars im searching <3
|
|
|
01/16/2018, 20:26
|
#6
|
elite*gold: 0
Join Date: Jul 2009
Posts: 285
Received Thanks: 49
|
Quote:
Originally Posted by 7modii1
Thx I've done the most of the avatars im searching <3
|
make a query is more easy to change all the stats from the avatars!
|
|
|
01/17/2018, 08:04
|
#7
|
elite*gold: 0
Join Date: May 2017
Posts: 5
Received Thanks: 0
|
Quote:
Originally Posted by loader8
make a query is more easy to change all the stats from the avatars! 
|
Can you give me a query, i don't know how to make it
|
|
|
02/06/2018, 01:50
|
#8
|
elite*gold: 0
Join Date: Feb 2018
Posts: 7
Received Thanks: 6
|
DECLARE @Charid int
DECLARE @ItemID int
Declare @Charname VarChar(50)
Declare @PLUS int
DECLARE @Head int
Declare @CHEST int
DECLARE @LEGS int
DECLARE @  int
DECLARE @HAND int
DECLARE @FOOT int
DECLARE @  1 int DECLARE @  int
DECLARE @NECK int
DECLARE @ERRING int
DECLARE @  int DECLARE @  int
SET @Charname = 'Pur3viL'
SET @PLUS = '7'
SET @Charid = (select CharID from _Char where CharName16=@Charname)
SET @Head = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=0 and CharID=@Charid)
SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=1 and CharID=@Charid)
SET @LEGS = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid)
SET @  = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=2 and CharID=@Charid)
SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=3 and CharID=@Charid)
SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=5 and CharID=@Charid)
SET @  1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid) SET @  = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid)
SET @NECK = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID=@Charid)
SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=9 and CharID=@Charid)
SET @  =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid) SET @  =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid)
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where ID64 =@Head
---------------
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where ID64 =@CHEST
----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=865920825
where ID64 @
----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=865920825
where ID64 =@HAND
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where ID64 =@LEGS
-----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=865920825
where ID64 =@FOOT
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 @  1
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 @
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 =@NECK
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 =@ERRING
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4 =257698037862,
Variance=28817845082
where ID64 @
update _Items
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=900557658
where ID64 @
select * from _Inventory where CharID=@Charid and Slot between 0 and 12
its for char items .. may help
|
|
|
Similar Threads
|
[HELP]HELP HELP HELP[HELP]
09/23/2013 - Facebook - 3 Replies
GUYS ^^ THIS IS A HELP THREAD NOT REQUEST THREAD BUT YOU CAN CONSIDER IT AS REQUEST THREAD
DOES ANYONE OF YOU KNOW THE AUTO SUBMIT PHP CODE? THANKS!
|
[HELP][HELP][HELP][HELP]!!
09/11/2009 - Soldier Front - 3 Replies
Microsoft Visual C++ Run time error! :(:(
**HELP ME PLEASE!!***
|
help help help help help help
06/28/2009 - Say Hello - 0 Replies
how i can dowmload Mangos 6385 ???????????????????????????????????
please give me the limk i can't see that
i know it is in www.elitepvpers.com/.../153716-release-mangos-relea ses-blackscorpian-win32-2-4-3-a.html -
but give me link sent it to my email plz
|
All times are GMT +1. The time now is 20:16.
|
|