Veritabanı Gereksinimleri
Zeo Panel'in doğru çalışması için veritabanı sıfırlaması yaptığınızda aşağıdaki tablolara gerekli verileri işlemeniz gerekiyor. Aksi taktirde siteniz 500 hatası alabilir.
SRO_VT_ACCOUNT TB_User
Sütunlar:
credit (decimal(8, 2), null)
reg_ip (varchar(max), null)
game_credit (int, null)
logintoken (varchar(255), null)
Aşağıdaki kodu TB_User tablosuna işleyerek eksik sütunları otomatik olarak veritabanınıza ekleyebilirsiniz.
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'TB_User' AND COLUMN_NAME = 'credit')
BEGIN
ALTER TABLE SRO_VT_ACCOUNT.dbo.TB_User ADD credit decimal(8, 2) NULL;
END
GO
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'TB_User' AND COLUMN_NAME = 'reg_ip')
BEGIN
ALTER TABLE SRO_VT_ACCOUNT.dbo.TB_User ADD reg_ip VARCHAR(max) NULL;
END
GO
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'TB_User' AND COLUMN_NAME = 'game_credit')
BEGIN
ALTER TABLE SRO_VT_ACCOUNT.dbo.TB_User ADD [game_credit] INT NULL;
END
GO
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'TB_User' AND COLUMN_NAME = 'logintoken')
BEGIN
ALTER TABLE SRO_VT_ACCOUNT.dbo.TB_User ADD logintoken VARCHAR(255) NULL
END
SRO_VT_SHARD _RefObjItem
Envanter sistemi için _RefObjItem tablosunda 0 ID'li aşağıdaki gibi veri olması gerekiyor. Eğer yok ise aşağıdaki kodu kullanarak ekleyebilirsiniz. Identity_Insert hatası alırsanız sadece insert komutunu kullanın.
use SRO_VT_SHARD
Set Identity_Insert _RefObjItem on
insert into _RefObjItem ([ID],[MaxStack],[ReqGender] ,[ReqStr],[ReqInt],[ItemClass],[SetID],[Dur_L],[Dur_U],[PD_L],[PD_U],[PDInc],[ER_L],[ER_U],[ERInc],[PAR_L],[PAR_U],[PARInc],[BR_L],[BR_U],[MD_L],[MD_U],[MDInc],[MAR_L],[MAR_U],[MARInc],[PDStr_L],[PDStr_U],[MDInt_L],[MDInt_U],[Quivered],[Ammo1_TID4],[Ammo2_TID4],[Ammo3_TID4],[Ammo4_TID4],[Ammo5_TID4],[SpeedClass],[TwoHanded],[Range],[PAttackMin_L],[PAttackMin_U],[PAttackMax_L],[PAttackMax_U],[PAttackInc],[MAttackMin_L],[MAttackMin_U],[MAttackMax_L],[MAttackMax_U],[MAttackInc],[PAStrMin_L],[PAStrMin_U],[PAStrMax_L],[PAStrMax_U],[MAInt_Min_L],[MAInt_Min_U],[MAInt_Max_L],[MAInt_Max_U],[HR_L],[HR_U],[HRInc],[CHR_L],[CHR_U],[Param1],[Desc1_128],[Param2],[Desc2_128],[Param3],[Desc3_128],[Param4],[Desc4_128],[Param5],[Desc5_128],[Param6],[Desc6_128],[Param7],[Desc7_128],[Param8],[Desc8_128],[Param9],[Desc9_128],[Param10],[Desc10_128],[Param11],[Desc11_128],[Param12],[Desc12_128],[Param13],[Desc13_128],[Param14],[Desc14_128],[Param15],[Desc15_128],[Param16],[Desc16_128],[Param17],[Desc17_128],[Param18],[Desc18_128],[Param19],[Desc19_128],[Param20],[Desc20_128],[MaxMagicOptCount],[ChildItemCount],[Link]) values
(0,0,2,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0)
Set Identity_Insert _RefObjItem off
update _Items set OptLevel=0 where ID64=0
Sadece Insert Komutu:
insert into _RefObjItem ([ID],[MaxStack],[ReqGender] ,[ReqStr],[ReqInt],[ItemClass],[SetID],[Dur_L],[Dur_U],[PD_L],[PD_U],[PDInc],[ER_L],[ER_U],[ERInc],[PAR_L],[PAR_U],[PARInc],[BR_L],[BR_U],[MD_L],[MD_U],[MDInc],[MAR_L],[MAR_U],[MARInc],[PDStr_L],[PDStr_U],[MDInt_L],[MDInt_U],[Quivered],[Ammo1_TID4],[Ammo2_TID4],[Ammo3_TID4],[Ammo4_TID4],[Ammo5_TID4],[SpeedClass],[TwoHanded],[Range],[PAttackMin_L],[PAttackMin_U],[PAttackMax_L],[PAttackMax_U],[PAttackInc],[MAttackMin_L],[MAttackMin_U],[MAttackMax_L],[MAttackMax_U],[MAttackInc],[PAStrMin_L],[PAStrMin_U],[PAStrMax_L],[PAStrMax_U],[MAInt_Min_L],[MAInt_Min_U],[MAInt_Max_L],[MAInt_Max_U],[HR_L],[HR_U],[HRInc],[CHR_L],[CHR_U],[Param1],[Desc1_128],[Param2],[Desc2_128],[Param3],[Desc3_128],[Param4],[Desc4_128],[Param5],[Desc5_128],[Param6],[Desc6_128],[Param7],[Desc7_128],[Param8],[Desc8_128],[Param9],[Desc9_128],[Param10],[Desc10_128],[Param11],[Desc11_128],[Param12],[Desc12_128],[Param13],[Desc13_128],[Param14],[Desc14_128],[Param15],[Desc15_128],[Param16],[Desc16_128],[Param17],[Desc17_128],[Param18],[Desc18_128],[Param19],[Desc19_128],[Param20],[Desc20_128],[MaxMagicOptCount],[ChildItemCount],[Link]) values
(0,0,2,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx',0,0,0)
SRO_VT_LOG AddLogChar
Rank sistemi ve Online Offline Kontrol sistemi için bu komut gereklidir.
--======================================================================Zeo Panel============================================================================--
IF (@EventID = 4) or (@EventID = 6) or (@EventID = 9) -- Online List
BEGIN
EXEC ZeoPanel.dbo.Set_OnlineUsers @CharID,@EventID
END
IF (@EventID = 20) and (@Desc like '%no job, Neutral, % no job, Neutral, %') and (@Desc not like '%no job, Neutral, Murderer% no job, Neutral, Murderer%') --PvP Rank
BEGIN
EXEC ZeoPanel.._RankPvP @CharID,@Desc
END
IF (@EventID = 20) and (@desc LIKE '%Trader, Neutral, no freebattle team%' OR @desc LIKE '%Hunter, Neutral, no freebattle team%'OR @desc LIKE '%Robber, Neutral, no freebattle team%') --Job Rank
BEGIN
EXEC ZeoPanel.._RankJob @CharID,@Desc
END
--======================================================================Zeo Panel============================================================================--
