Bug/Probs und ihr Fixes

Luoo · 25. Dezember 2009, 22:50

Hallo ich hab nirgendwo ein Thread gesehen der aktuell war.
Mach ich mal einen ;) ich werde ich Täglich versuchen aktuell zu halten.

Bug: Penya Hack
Fix:1 Zitat von Synaptic

Quellcode

Geht in euren Resource ordner und sucht nach der Datei defineNeuz.h !
Drückt Strg + F und gebt die beiden Zeilen ein:
#define MMI_BEAUTYSHOP 13
#define MMI_BEAUTYSHOP_SKIN
Was sollt ihr damit machen ? EINFACH RAUSLÖSCHEN !
Dann müsst ihr noch in der Character.inc den Shop MaFl_FaceOff komplett rauslöschen !
Danach World Server Restarten und es sollte gefixxt sein da die Funktion durch löschen des MMI eintrags eigentlich gelöscht sein sollte.

Alles anzeigen

Fix2:Zitat von Synaptic

Quellcode

Ihr geht in euren Resource ordner und sucht nach der Datei Exchange_Script
Ihr öffnet dies und sucht per Strg + F nach "Face" gleich das erste suchergebniss ist das was ihr benötigt !
Ihr löscht den inhalt :
[CODE]
{
//¾ÆÀÌÅÛ ID °¹¼ö È®·ü(n/1000000)
II_SYS_SYS_SCR_FACEOFFFREE 1 1000000
}

Alles anzeigen

heraus und speichert die Datei ab und restartet euren World Server.

Was passiert nun wen man diese funktion ingame benutzt ? ganz einfach der Spieler bekommt einen DC :D [/code]

Credits to Synaptic

Bug: Mail STR Error
Fix : entweder ODBC auf english stellen oder die Abfrage machen

Quellcode

--
-- Definition for stored procedure MAIL_STR_REALTIME :
--
GO
/****** Object: Stored Procedure dbo.MAIL_STR_REALTIME Script Date: 7/29/2008 3:34:04 AM ******/
create proc [dbo].MAIL_STR_REALTIME
@iGu CHAR(2),
@serverindex CHAR(2),
@nMail_Before INT = 0,
@nMail_After INT = 0,
@idPlayer CHAR(7) = '0000000',
@nLevel INT = 0,
@iaccount VARCHAR(32) = '',
@tmCreate INT = 0,
@dwSerialNumber INT = 0,
@nHitPoint INT = 0
as
set nocount on
declare @sdate datetime
declare @edate datetime
declare @iserverindex char(2)
set @sdate = '18-07-2007 00:00:00'
set @edate = '31-08-2007 23:59:00'
set @iserverindex = cast((cast(@serverindex as int) + 50) as char(2))
IF @iGu = 'S1'
BEGIN
SELECT * FROM MAIL_TBL
WHERE serverindex = @iserverindex AND byRead<90
ORDER BY nMail
RETURN
END
ELSE
IF @iGu = 'U1'
BEGIN
UPDATE MAIL_TBL SET nMail = @nMail_After, serverindex = @serverindex, dwSerialNumber = @dwSerialNumber, nHitPoint = @nHitPoint
WHERE serverindex = @iserverindex and nMail = @nMail_Before
RETURN
END
ELSE
IF @iGu = 'I1'
BEGIN
-- 추천 이벤트 기간인지 확인
IF(getdate() < @sdate or getdate() > @edate) BEGIN
RETURN
END
-- 추천인 인지 확인 -- select top 10 * from ACCOUNT_DBF.dbo.tblEventRecommend
-- IF( NOT EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.tblEventRecommend where byaccount = @iaccount ) ) BEGIN
-- RETURN
-- END
-- 받을수 있는 아이템이 있는지 확인
DECLARE @ItemID int
DECLARE @ItemNum int
DECLARE @bBinds int
SET @ItemID = 0
SET @ItemNum = 1
SET @bBinds = 2
IF( @nLevel = 20 ) BEGIN
SET @ItemID = 26112
END
ELSE IF( @nLevel = 40 ) BEGIN
SET @ItemID = 26211
END
ELSE IF( @nLevel = 60 ) BEGIN
SET @ItemID = 26103
END
ELSE IF( @nLevel = 80 ) BEGIN
SET @ItemID = 30135
END
ELSE IF( @nLevel = 100 ) BEGIN
SET @ItemID = 5800
SET @bBinds = 0
END
ELSE IF( @nLevel = 120 ) BEGIN
SET @ItemID = 4703
SET @bBinds = 0
END
IF( @ItemID = 0 ) BEGIN
RETURN
END
-- 메일 아이디 할당 하기
DECLARE @nMaxMailID int
SELECT @nMaxMailID = MAX(nMail)+1 from MAIL_TBL where serverindex = @iserverindex
SET @nMaxMailID = ISNULL( @nMaxMailID, 0 )
-- 아이템 주기
DECLARE @szTitle VARCHAR(128)
DECLARE @szText VARCHAR(1024)
SET @szTitle = '레벨 업을 축하 드립니다!'
SET @szText = '캐릭터 레벨 업 기념 상품을 보내드립니다 ^ㅁ^* 프리프와 함께 즐거운 하루 보내시기 바랍니다. 감사합니다.'
EXEC dbo.MAIL_STR 'A1', @nMaxMailID, @iserverindex, @idPlayer, '0000000', 0, @tmCreate, 0, @szTitle, @szText,@ItemID, @ItemNum, 0, 0, 0, 0, @bBinds
RETURN
END
GO

Alles anzeigen

Bug: Character STR error
Fix:

Quellcode

USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[CHARACTER_STR] Script Date: 01/29/2010 13:04:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.CHARACTER_STR Script Date: 7/29/2008 3:34:04 AM ******/
CREATE proc [dbo].[CHARACTER_STR]
@iGu CHAR(2) = 'S1',
@im_idPlayer CHAR(7) = '0000001',
@iserverindex CHAR(2) = '01',
/**********************************************
INSERT 용
**********************************************/
-- CHARACTER_TBL
@iaccount VARCHAR(32) = '',
@im_szName VARCHAR(32) = '',
@iplayerslot INT = 0,
@idwWorldID INT = 0,
@im_dwIndex INT = 0,
@im_vPos_x REAL = 0,
@im_vPos_y REAL = 0,
@im_vPos_z REAL = 0,
@im_szCharacterKey VARCHAR(32) = '',
@im_dwSkinSet INT = 0,
@im_dwHairMesh INT = 0,
@im_dwHairColor INT = 0,
@im_dwHeadMesh INT = 0,
@im_dwSex INT = 0,
/**********************************************
UPDATE 용
**********************************************/
-- CHARACTER_TBL
@im_vScale_x REAL = 0,
@im_dwMotion INT = 0,
@im_fAngle REAL = 0,
@im_nHitPoint INT = 0,
@im_nManaPoint INT = 0,
@im_nFatiguePoint INT = 0,
@im_dwRideItemIdx INT = 0,
@im_dwGold INT = 0,
@im_nJob INT = 0,
@im_pActMover VARCHAR(50) = '',
@im_nStr INT = 0,
@im_nSta INT = 0,
@im_nDex INT = 0,
@im_nInt INT = 0,
@im_nLevel INT = 0,
@im_nExp1 BIGINT = 0,
@im_nExp2 BIGINT = 0,
@im_aJobSkill VARCHAR(500) ='',
@im_aLicenseSkill VARCHAR(500) ='',
@im_aJobLv VARCHAR(500) ='',
@im_dwExpertLv INT = 0,
@im_idMarkingWorld INT = 0,
@im_vMarkingPos_x REAL = 0,
@im_vMarkingPos_y REAL = 0,
@im_vMarkingPos_z REAL = 0,
@im_nRemainGP INT = 0,
@im_nRemainLP INT = 0,
@im_nFlightLv INT = 0,
@im_nFxp INT = 0,
@im_nTxp INT = 0,
@im_lpQuestCntArray VARCHAR(3072)= '',
@im_chAuthority CHAR(1) = '',
@im_dwMode INT = 0,
@im_idparty INT = 0,
--@im_nNumKill INT = 0,
@im_idMuerderer INT = 0,
--@im_nSlaughter INT = 0,
@im_nFame INT = 0,
@im_nDeathExp BIGINT = 0,
@im_nDeathLevel INT = 0,
@im_dwFlyTime INT = 0,
@im_nMessengerState INT = 0,
@iTotalPlayTime INT = 0,
---------- Additional end ----------
-- PK Variable
@im_nPKValue int=0,
@im_dwPKPropensity int=0,
@im_dwPKExp int=0,
---------- Additional end ----------
-- CARD_CUBE_TBL
@im_Card VARCHAR(1980)= '',
@im_Index_Card VARCHAR(215) = '',
@im_ObjIndex_Card VARCHAR(215) = '',
@im_Cube VARCHAR(1980)= '',
@im_Index_Cube VARCHAR(215) = '',
@im_ObjIndex_Cube VARCHAR(215) = '',
-- INVENTORY_TBL
@im_Inventory VARCHAR(6940)= '',
@im_apIndex VARCHAR(345) = '',
@im_adwEquipment VARCHAR(135) = '',
@im_dwObjIndex VARCHAR(345) = '',
-- TASKBAR_TBL
@im_aSlotApplet VARCHAR(3100)= '',
-- TASKBAR_ITEM_TBL
@im_aSlotItem VARCHAR(6885)= '',
-- TASKBAR_TBL
@im_aSlotQueue VARCHAR(225)= '',
@im_SkillBar SMALLINT = 0,
-- BANK_TBL
@im_Bank VARCHAR(4290)= '',
@im_apIndex_Bank VARCHAR(215)= '',
@im_dwObjIndex_Bank VARCHAR(215)= '',
@im_dwGoldBank INT = 0,
@im_nFuel INT = -1,
@im_tmAccFuel INT = 0,
@im_dwSMTime VARCHAR(2560)='',
@iSkillInfluence varchar(2048) ='',
@im_dwSkillPoint INT = 0,
@im_aCompleteQuest varchar(1024) = '',
@im_extInventory varchar(2000) = '',
@im_extBank varchar(2000) = '',
@im_InventoryPiercing varchar(2000) = '',
@im_BankPiercing varchar(2000) = '',
@im_dwReturnWorldID INT = 1,
@im_vReturnPos_x REAL = 0,
@im_vReturnPos_y REAL = 0,
@im_vReturnPos_z REAL= 0
-------------- ( Version 7 : Skill Update)
, @im_SkillPoint int=0
, @im_SkillLv int=0
, @im_SkillExp bigint=0
-------------- (Additional end)
, @idwEventFlag bigint=0,
@idwEventTime int=0,
@idwEventElapsed int=0
-------------- (Additional end)
----------Additional end----------
-- PVP (Additional end)
,@im_nAngelExp bigint=0
,@im_nAngelLevel int=0
----------Additional end ----------
--------------- Version 9 Relation of additional partial Pet
,@iszInventoryPet varchar(2688) = '$'
,@iszBankPet varchar(2688) = '$'
,@im_dwPetId int = -1
,@im_nExpLog int = 0
,@im_nAngelExpLog int = 0
--------- Ver 11 Coupon
,@im_nCoupon int = 0
--------- Ver 14 Shit
,@im_nHonor int = -1
,@im_nLayer int = 0
/*******************************************************
Gu Dividing
S : SELECT
I : INSERT
U : UPDATE
D : DELETE
2005.04.11 updated
ALTER TABLE CHARACTER_TBL ADD m_aCompleteQuest varchar(1024) NULL
ALTER TABLE CHARACTER_TBL ALTER COLUMN m_lpQuestCntArray VARCHAR(3072) NULL
*******************************************************/
AS
set nocount on
declare @last_connect tinyint
set @last_connect = 1
IF @iGu = 'S2' -- Is a player list which follows in the slot cuts coil information bringing,
BEGIN
IF @iaccount = '' OR @im_szName = ''
BEGIN
SELECT m_chAuthority = '',fError = '1', fText = 'Wrong password'
RETURN
END
SELECT A.dwWorldID,
A.m_szName,
A.playerslot,
A.End_Time,
A.BlockTime,
A.m_dwIndex,
A.m_idPlayer,
A.m_idparty,
A.m_dwSkinSet,
A.m_dwHairMesh,
A.m_dwHeadMesh,
A.m_dwHairColor,
A.m_dwSex,
A.m_nJob,
A.m_nLevel,
A.m_vPos_x,
A.m_vPos_y,
A.m_vPos_z,
A.m_nStr,
A.m_nSta,
A.m_nDex,
A.m_nInt,
--A.m_nSlaughter, -- raidersAddition 2005.5.11
A.m_aJobLv,
A.m_chAuthority,
A.m_idCompany,
A.m_nMessengerState,
B.m_Inventory,
B.m_apIndex,
B.m_adwEquipment,
B.m_dwObjIndex,
m_idGuild = CASE WHEN C.m_idGuild IS NULL THEN '0' ELSE C.m_idGuild END ,
m_idWar = CASE WHEN C.m_idWar IS NULL THEN '0' ELSE C.m_idWar END,
D.m_extInventory,
D.m_InventoryPiercing,
A.m_idCompany,
last_connect = @last_connect
FROM CHARACTER_TBL A, INVENTORY_TBL B,GUILD_MEMBER_TBL C, INVENTORY_EXT_TBL D
WHERE A.m_idPlayer = B.m_idPlayer
AND A.serverindex= B.serverindex
AND B.m_idPlayer = D.m_idPlayer
AND B.serverindex = D.serverindex
AND D.m_idPlayer *= C.m_idPlayer
AND D.serverindex *= C.serverindex
AND A.isblock = 'F'
AND A.account = @iaccount
AND A.serverindex= @iserverindex
ORDER BY A.playerslot
RETURN
END
/*
Is a player list which follows in the slot cuts coil information bringing,
ex )
CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
CHARACTER_STR 'S2','0','02','seghope','1234'
*/
ELSE
IF @iGu = 'S3' -- The server initially idPlayer of characters which will execute all the branch, coming,
BEGIN
SELECT m_szName, m_idPlayer,m_idCompany
FROM CHARACTER_TBL
WHERE serverindex = @iserverindex
-- AND isblock = 'F'
ORDER BY m_idPlayer
RETURN
END
/*
The server initially idPlayer of characters which will execute all the branch, coming,
ex )
CHARACTER_STR 'S3','',@iserverindex
CHARACTER_STR 'S3','','02'
*/
ELSE
IF @iGu = 'S4' -- The item confirmation which will add
BEGIN
/* if (getdate() >= '2007-10-29 00:00:00' and getdate() <= '2007-10-31 23:59:59')
begin
if not exists (select * from EOCRM.MANAGE_DBF.dbo.tblEvent_Halloween_2007 where serverindex = @iserverindex and m_idPlayer = @im_idPlayer)
begin
declare @q1 nvarchar(4000)
declare @ktime bigint
select @ktime = cast(replace(replace(replace(convert(char(16), dateadd(hh, 72, getdate()), 21), '-', ''), ' ', ''), ':', '') as bigint)
set @q1 = '
insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, m_bItemResist, m_nResistAbilityOption, m_bCharged, m_dwKeepTime)
select @im_idPlayer, @iserverindex, ''26425'', 1, 0, 0, 0, 0, @ktime'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2), @ktime bigint', @im_idPlayer, @iserverindex, @ktime
set @q1 = '
insert into EOCRM.MANAGE_DBF.dbo.tblEvent_Halloween_2007 (serverindex, m_idPlayer)
select @iserverindex, @im_idPlayer'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
set @q1 = '
SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
else
begin
SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0
end
end
else
begin
SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0
end*/
declare @q1 nvarchar(4000)
/* if ((getdate() >= '2007-12-23 00:00:00') and (getdate() <= '2007-12-25 23:59:59'))
begin
if not exists (select * from tblevent_2007_xmas where m_idPlayer = @im_idPlayer)
begin
declare @m_dwSex int
declare @xmas_Item varchar(32)
select @m_dwSex = m_dwSex from CHARACTER_TBL where m_idPlayer = @im_idPlayer
if @m_dwSex = 0
begin
set @xmas_Item = '26339'
end
else
begin
set @xmas_Item = '26340'
end
set @q1 = 'insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
select @im_idPlayer, ''01'', @xmas_Item, 1, 0, ''0000000'''
exec sp_executesql @q1, N'@im_idPlayer char(7), @xmas_Item varchar(32)', @im_idPlayer, @xmas_Item
insert into tblevent_2007_xmas (m_idPlayer)
select @im_idPlayer
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
else
begin
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
end*/
if ((getdate() >= '2007-12-31 00:00:00') and (getdate() <= '2007-12-31 23:59:59'))
begin
if not exists (select * from tblevent_2007_newyear where m_idPlayer = @im_idPlayer)
begin
declare @newyear_Item varchar(32)
set @newyear_Item = '2904'
set @q1 = 'insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
select @im_idPlayer, ''01'', @newyear_Item, 5, 0, ''0000000'''
exec sp_executesql @q1, N'@im_idPlayer char(7), @newyear_Item varchar(32)', @im_idPlayer, @newyear_Item
insert into tblevent_2007_newyear (m_idPlayer)
select @im_idPlayer
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
else
begin
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
end
else
begin
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
RETURN
END
/*
Item confirmation
ex )
CHARACTER_STR 'S4',@im_idPlayer,@iserverindex
CHARACTER_STR 'S4','000001','01'
*/
ELSE
IF @iGu = 'S5' -- From table after item utmost urgency item elimination
BEGIN
-- DELETE ITEM_SEND_TBL
UPDATE ITEM_SEND_TBL SET ProvideDt=getdate(), ItemFlag=1
WHERE m_nNo = @iplayerslot
IF @@ROWCOUNT = 0
SELECT fError = '0'
ELSE
SELECT fError = '1'
RETURN
END
/*
From table after item utmost urgency item elimination
ex )
CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount
CHARACTER_STR 'S5','000001','01','Broom',1,1
*/
ELSE
IF @iGu = 'S6' -- The item confirmation which will eliminate
BEGIN
SELECT Item_Name,
Item_count,
m_nAbilityOption,
m_nNo,
State,
m_bItemResist,
m_nResistAbilityOption
FROM ITEM_REMOVE_TBL
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
AND ItemFlag = 0
RETURN
END
/*
Item confirmation
ex )
CHARACTER_STR 'S6',@im_idPlayer,@iserverindex
CHARACTER_STR 'S6','000001','01'
*/
ELSE
IF @iGu = 'S7' -- After item eliminating from table item elimination
BEGIN
-- DELETE ITEM_REMOVE_TBL
UPDATE ITEM_REMOVE_TBL SET DeleteDt=getdate(), ItemFlag=1
WHERE m_nNo = @iplayerslot
IF @@ROWCOUNT = 0
SELECT fError = '0'
ELSE
SELECT fError = '1'
RETURN
END
/*
From table after item utmost urgency item elimination
ex )
CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount
CHARACTER_STR 'S7','000001','01','Broom',1,1
*/
IF @iGu = 'S8' -- The data whole bringing,
BEGIN
PRINT @iaccount
DECLARE @om_chLoginAuthority CHAR(1)
-- Bank information character stars bringing
SET @om_chLoginAuthority = 'F'
--SELECT @om_chLoginAuthority = m_chLoginAuthority
-- FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL
--WHERE lower(account) = lower(@iaccount)
--INSERT INTO [ONLINE_TBL] ([account] ,[name]) VALUES(@iaccount,@im_idPlayer)
SELECT m_chLoginAuthority = @om_chLoginAuthority,
A.account,
A.m_idPlayer,
A.playerslot,
A.serverindex,
A.dwWorldID,
A.m_szName,
A.m_dwIndex,
A.m_vScale_x,
A.m_dwMotion,
A.m_vPos_x,
A.m_vPos_y,
A.m_vPos_z,
A.m_fAngle,
A.m_szCharacterKey,
A.m_idPlayer,
A.m_nHitPoint,
A.m_nManaPoint,
A.m_nFatiguePoint,
A.m_nFuel,
A.m_dwSkinSet,
A.m_dwHairMesh,
A.m_dwHairColor,
A.m_dwHeadMesh,
A.m_dwSex,
A.m_dwRideItemIdx,
A.m_dwGold,
A.m_nJob,
A.m_pActMover,
A.m_nStr,
A.m_nSta,
A.m_nDex,
A.m_nInt,
A.m_nLevel,
A.m_nMaximumLevel,
A.m_nExp1,
A.m_nExp2,
A.m_aJobSkill,
A.m_aLicenseSkill,
A.m_aJobLv,
A.m_dwExpertLv,
A.m_idMarkingWorld,
A.m_vMarkingPos_x,
A.m_vMarkingPos_y,
A.m_vMarkingPos_z,
A.m_nRemainGP,
A.m_nRemainLP,
A.m_nFlightLv,
A.m_nFxp,
A.m_nTxp,
A.m_lpQuestCntArray,
m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'),
A.m_chAuthority,
A.m_dwMode,
A.m_idparty,
A.m_idCompany,
--A.m_nNumKill,
A.m_idMuerderer,
--A.m_nSlaughter,
A.m_nFame,
A.m_nDeathExp,
A.m_nDeathLevel,
A.m_dwFlyTime,
A.m_nMessengerState,
A.End_Time,
A.BlockTime,
A.blockby,
A.isblock,
A.TotalPlayTime,
A.CreateTime,
A.m_dwSkillPoint,
B.m_aSlotApplet,
B.m_aSlotQueue,
B.m_SkillBar,
C.m_aSlotItem,
D.m_Inventory,
D.m_apIndex,
D.m_adwEquipment,
D.m_dwObjIndex,
m_idGuild = ISNULL(G.m_idGuild,'0'),
m_idWar = ISNULL(G.m_idWar,'0'),
A.m_tmAccFuel,
A.m_tGuildMember,
m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL') ,
SkillInfluence = ISNULL(E.SkillInfluence,'$'),
F.m_extInventory,
F.m_InventoryPiercing,
A.m_dwReturnWorldID,
A.m_idCompany,
A.m_vReturnPos_x,
A.m_vReturnPos_y,
A.m_vReturnPos_z
------------------ ( ADD : Version7-Skill System)
, m_SkillPoint = SkillPoint
, m_SkillLv = SkillLv
, m_SkillExp = SkillExp
-------------- (Additional start)
, A.dwEventFlag,
A.dwEventTime,
A.dwEventElapsed
-------------- (Additional start)
----------Additional start ----------
, A.PKValue as m_nPKValue,
A.PKPropensity as m_dwPKPropensity,
A.PKExp as m_dwPKExp
----------Additional end ----------
----------Additional end ----------
,AngelExp as m_nAngelExp
,AngelLevel as m_nAngelLevel
----------Additional end ----------
------------------- Version9 Pet
, F.szInventoryPet as szInventoryPet
, A.m_dwPetId
, A.m_nExpLog, A.m_nAngelExpLog
------------- Ver 11 Coupon
, m_nCoupon
------------- Ver 14 shit
, m_nHonor
, m_nLayer
, last_connect = @last_connect
FROM CHARACTER_TBL A,
TASKBAR_TBL B,
TASKBAR_ITEM_TBL C,
INVENTORY_TBL D,
SKILLINFLUENCE_TBL E,
INVENTORY_EXT_TBL F,
GUILD_MEMBER_TBL G,
BILING_ITEM_TBL H
WHERE A.m_idPlayer = @im_idPlayer
AND A.serverindex = @iserverindex
AND A.m_idPlayer = B.m_idPlayer
AND A.serverindex = B.serverindex
AND B.m_idPlayer = C.m_idPlayer
AND B.serverindex = C.serverindex
AND C.m_idPlayer = D.m_idPlayer
AND C.serverindex = D.serverindex
AND D.m_idPlayer = E.m_idPlayer
AND D.serverindex = E.serverindex
AND E.m_idPlayer = F.m_idPlayer
AND E.serverindex = F.serverindex
AND F.serverindex *= G.serverindex
AND F.m_idPlayer *= G.m_idPlayer
AND F.serverindex *= H.serverindex
AND F.m_idPlayer *= H.m_idPlayer
AND A.account = lower(@iaccount)
-- Bank information account stars bringing
-- DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT)
--
-- INSERT @bank
-- (m_idPlayer,serverindex,playerslot)
-- SELECT m_idPlayer,serverindex,playerslot
-- FROM CHARACTER_TBL
-- WHERE account = @iaccount
-- AND isblock = 'F'
-- ORDER BY playerslot
SELECT a.m_idPlayer,
c.playerslot,
a.m_Bank,
a.m_apIndex_Bank,
a.m_dwObjIndex_Bank,
a.m_dwGoldBank,
a.m_BankPw,
b.m_extBank,
b.m_BankPiercing, b.szBankPet
FROM dbo.BANK_TBL a,
dbo.BANK_EXT_TBL b,
dbo.CHARACTER_TBL c
WHERE a.m_idPlayer = b.m_idPlayer
AND a.serverindex = b.serverindex
AND b.m_idPlayer = c.m_idPlayer
AND b.serverindex = c.serverindex
AND c.account = lower(@iaccount)
AND c.isblock = 'F'
ORDER BY c.playerslot
------------- Ver11 Pocket
SELECT a.nPocket,
a.szItem,
a.szIndex,
a.szObjIndex,
a.bExpired,
a.tExpirationDate,
b.szExt,
b.szPiercing,
b.szPet
FROM tblPocket as a inner join tblPocketExt as b
on a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket
WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer
ORDER BY a.nPocket
RETURN
END
/*
The data whole bringing, New
ex )
CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount
CHARACTER_STR 'S8','425120','01','ata3k'
*/
ELSE
IF @iGu = 'U1' -- Character store
BEGIN
--DELETE FROM ONLINE_TBL WHERE name = @im_idPlayer
UPDATE CHARACTER_TBL
SET dwWorldID = @idwWorldID,
m_dwIndex = @im_dwIndex,
m_dwSex = @im_dwSex,
m_vScale_x = @im_vScale_x,
m_dwMotion = @im_dwMotion,
m_vPos_x = @im_vPos_x,
m_vPos_y = @im_vPos_y,
m_vPos_z = @im_vPos_z,
m_dwHairMesh = @im_dwHairMesh,
m_dwHairColor = @im_dwHairColor,
m_dwHeadMesh = @im_dwHeadMesh, -- 2004/11/08 Addition
m_fAngle = 0, --@im_fAngle,
m_szCharacterKey = @im_szCharacterKey,
m_nHitPoint = @im_nHitPoint,
m_nManaPoint = @im_nManaPoint,
m_nFatiguePoint = @im_nFatiguePoint,
m_nFuel = @im_nFuel,
m_dwRideItemIdx = @im_dwRideItemIdx,
m_dwGold = @im_dwGold,
m_nJob = @im_nJob,
m_pActMover = @im_pActMover,
m_nStr = @im_nStr,
m_nSta = @im_nSta,
m_nDex = @im_nDex,
m_nInt = @im_nInt,
m_nLevel = @im_nLevel,
m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
m_nExp1 = @im_nExp1,
m_nExp2 = @im_nExp2,
m_aJobSkill = @im_aJobSkill,
m_aLicenseSkill = @im_aLicenseSkill,
m_aJobLv = @im_aJobLv,
m_dwExpertLv = @im_dwExpertLv,
m_idMarkingWorld = @im_idMarkingWorld,
m_vMarkingPos_x = @im_vMarkingPos_x,
m_vMarkingPos_y = @im_vMarkingPos_y,
m_vMarkingPos_z = @im_vMarkingPos_z,
m_nRemainGP = @im_nRemainGP,
m_nRemainLP = @im_nRemainLP,
m_nFlightLv = @im_nFlightLv,
m_nFxp = @im_nFxp,
m_nTxp = @im_nTxp,
m_lpQuestCntArray = @im_lpQuestCntArray,
m_aCompleteQuest = @im_aCompleteQuest,
m_dwMode = @im_dwMode,
m_idparty = @im_idparty,
--m_nNumKill = @im_nNumKill,
m_idMuerderer = @im_idMuerderer,
--m_nSlaughter = @im_nSlaughter ,
m_nFame = @im_nFame,
m_nDeathExp = @im_nDeathExp,
m_nDeathLevel = @im_nDeathLevel,
-- m_dwFlyTime = m_dwFlyTime + @im_dwFlyTime,
m_dwFlyTime = @im_dwFlyTime,
m_nMessengerState = @im_nMessengerState,
TotalPlayTime = TotalPlayTime + @iTotalPlayTime,
m_tmAccFuel = @im_tmAccFuel,
m_dwSkillPoint = @im_dwSkillPoint,
m_dwReturnWorldID= @im_dwReturnWorldID,
m_idCompany = 0,
m_vReturnPos_x = @im_vReturnPos_x,
m_vReturnPos_y = @im_vReturnPos_y,
m_vReturnPos_z = @im_vReturnPos_z
-------------- (ADD: Version7-SkillSystem)
, SkillPoint = @im_SkillPoint
, SkillLv = @im_SkillLv
, SkillExp = @im_SkillExp
-------------- (Additional part)
, dwEventFlag =@idwEventFlag,
dwEventTime =@idwEventTime,
dwEventElapsed =@idwEventElapsed
-------------- (Additional part)
----------Additional start ----------
, PKValue = @im_nPKValue,
PKPropensity = @im_dwPKPropensity,
PKExp = @im_dwPKExp
----------Additional end ----------
----------Additional start ----------
, AngelExp= @im_nAngelExp
, AngelLevel= @im_nAngelLevel
----------Additional end ----------
--------------------- Version9 Pet
, m_dwPetId = @im_dwPetId
, m_nExpLog = @im_nExpLog
, m_nAngelExpLog = @im_nAngelExpLog
------------ Ver 11
, m_nCoupon = @im_nCoupon
, m_nLayer = @im_nLayer
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
-- if object_id('QUEST_TBL') is not null
-- EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray
--Relation of [song] present three request fact Bill rings
IF @im_dwSMTime > ''
BEGIN
IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer AND serverindex = @iserverindex)
UPDATE BILING_ITEM_TBL
SET m_dwSMTime = @im_dwSMTime
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
ELSE
INSERT BILING_ITEM_TBL
(m_idPlayer,serverindex,m_dwSMTime)
VALUES
(@im_idPlayer,@iserverindex,@im_dwSMTime)
END
ELSE
DELETE BILING_ITEM_TBL
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
-- UPDATE CARD_CUBE_TBL
-- SET m_Card = @im_Card,
-- m_apIndex_Card = @im_Index_Card,
-- m_dwObjIndex_Card= @im_ObjIndex_Card,
-- m_Cube = @im_Cube,
-- m_apIndex_Cube = @im_Index_Cube,
-- m_dwObjIndex_Cube=@im_ObjIndex_Cube
-- WHERE m_idPlayer = @im_idPlayer
-- AND serverindex = @iserverindex
UPDATE INVENTORY_TBL
SET m_Inventory = @im_Inventory,
m_apIndex = @im_apIndex,
m_adwEquipment = @im_adwEquipment,
m_dwObjIndex = @im_dwObjIndex
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE TASKBAR_TBL
SET m_aSlotApplet = @im_aSlotApplet,
m_aSlotQueue = @im_aSlotQueue,
m_SkillBar = @im_SkillBar
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE TASKBAR_ITEM_TBL
SET m_aSlotItem = @im_aSlotItem
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE BANK_TBL
SET m_Bank = @im_Bank,
m_apIndex_Bank = @im_apIndex_Bank,
m_dwObjIndex_Bank = @im_dwObjIndex_Bank,
m_dwGoldBank = @im_dwGoldBank
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE SKILLINFLUENCE_TBL
SET SkillInfluence = @iSkillInfluence
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE INVENTORY_EXT_TBL
SET m_extInventory = @im_extInventory,
m_InventoryPiercing = @im_InventoryPiercing
, szInventoryPet = @iszInventoryPet
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
UPDATE BANK_EXT_TBL
SET m_extBank = @im_extBank,
m_BankPiercing = @im_BankPiercing
, szBankPet = @iszBankPet
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
SELECT fError = '1', fText = 'OK'
RETURN
END
/*
Information update
ex )
CHARACTER_STR 'U1', ALL ...
CHARACTER_STR 'U1','000001','01' ...
*/
ELSE
IF @iGu = 'U2' -- Total use time correction
BEGIN
UPDATE CHARACTER_TBL
SET TotalPlayTime = TotalPlayTime + @iplayerslot
WHERE m_szName = @im_szName
AND serverindex = @iserverindex
RETURN
END
/*
Total use time correction
ex )
CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime)
CHARACTER_STR 'U2','','01','','beat',10234
*/
ELSE
IF @iGu = 'U3' --Total use time correction new
BEGIN
UPDATE CHARACTER_TBL
SET TotalPlayTime = TotalPlayTime + @iplayerslot
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
RETURN
END
/*
Total use time correction (new)
ex )
CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime)
CHARACTER_STR 'U3','000001','01','','',10234
*/
ELSE
IF @iGu = 'U4' --Character life fringe land
BEGIN
IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE lower(m_szName) = lower(@im_szName) AND serverindex = @iserverindex)
BEGIN
SELECT fError = '0'
END
ELSE
BEGIN
UPDATE CHARACTER_TBL
SET m_szName = @im_szName
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
SELECT fError = '1'
END
RETURN
END
/*
Character life fringe land
ex)
CHARACTER_STR ' U4' @im_idPlayer, @iserverindex, @iaccount and @im_szName
CHARACTER_STR ' U4' ' 000001' ' 01' ' ' ' The morning star princess'
*/
ELSE
IF @iGu = 'D1' -- Character elimination
BEGIN
-- The part which the box tries to close once in the class arctic regions #1 2007-03-21
IF @im_szName = ''
BEGIN
SELECT fError = '1', fText = 'Resident number error'
RETURN
END
if not exists (select * from CHARACTER_TBL where m_idPlayer = @im_idPlayer and account = @iaccount and serverindex = @iserverindex)
begin
select fError = '1'
return
end
DECLARE @Exists int
-- IF EXISTS(SELECT name from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN')
-- BEGIN
-- IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (password = @im_szName OR member = 'B' ))
SET @Exists = 1
-- ELSE
-- SET @Exists = 0
-- END
-- ELSE
-- BEGIN
-- IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (id_no2 = @im_szName OR member = 'B' ))
-- SET @Exists = 1
-- ELSE
-- SET @Exists = 0
-- END
IF @Exists > 0
BEGIN
DECLARE @currDate char(12)
SET @currDate = CONVERT(CHAR(8),GETDATE(),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND m_idWar > 0)
BEGIN
SELECT fError = '3', fText = 'In before guild'
RETURN
END
ELSE
BEGIN
UPDATE CHARACTER_TBL
SET isblock = 'D',
End_Time = @currDate ,
BlockTime = LEFT(@currDate,8)
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE MESSENGER_TBL
SET State = 'D'
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE MESSENGER_TBL
SET State = 'D'
WHERE f_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
/****************************************************************************************/
/** 200506 event **/
/****************************************************************************************/
-- if (not exists(select account from RANKING_DBF.dbo.last_1_month_tbl where account = @iaccount)
-- and convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-12')
--
-- begin --: Of 1 or more month the account objective type writing which is not connection experience
-- declare @cash int,@get_cach int
-- select @cash = case when m_nLevel between 10 and 19 then 500
-- when m_nLevel between 20 and 39 then 1000
-- when m_nLevel between 40 and 49 then 1500
-- when m_nLevel between 50 and 59 then 2000
-- when m_nLevel between 60 and 69 then 2500
-- when m_nLevel >= 70 then 3000
-- else 0 end
-- from CHARACTER_TBL
-- where m_idPlayer = @im_idPlayer and serverindex = @iserverindex
--
-- select @get_cach = isnull(sum(amount),0)
-- from RANKING_DBF.dbo.event_member_tbl
-- where account = @iaccount
-- group by account
--
-- if @cash + @get_cach > 5000
-- set @cash = 5000 - @get_cach
--
-- if @cash > 0
--
-- begin
-- declare @retcode int
--
-- if not exists(select * from BILLING.QLORD_MASTER.dbo.BX_TG_USERINFO where USER_ID = @iaccount)
-- exec BILLING.QLORD_MASTER.dbo.BX_SP_PROCESS_USERINFO @iaccount,@iaccount,'FLYF',' ','1111111111118',' ',' ',''
--
-- exec @retcode = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004',@cash,'Character compensation event',0,''
--
-- if @retcode <> 1
-- set @cash = 0
--
-- insert RANKING_DBF.dbo.event_member_tbl
-- (account,amount,m_idPlayer,serverindex,retcode,date)
-- values
-- (@iaccount,@cash,@im_idPlayer,@iserverindex,@retcode,getdate())
--
-- end
-- end
/****************************************************************************************/
/****************************************************************************************/
/****************************************************************************************/
-- The part which the box tries to close once in the class arctic regions #2 2007-03-21
IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
BEGIN
SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
RETURN
END
ELSE
BEGIN
SELECT fError = '0', fText = 'DELETE OK'
RETURN
END
END
END
ELSE
BEGIN
SELECT fError = '1', fText = 'Resident number error'
RETURN
END
-- At the price which is not eliminated unconditionally return
select fError = '1', fText = 'Resident number error'
END
/*
Character elimination
ex )
CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock)
CHARACTER_STR 'D1','001068','01','ata3k','1019311'
*/
ELSE
IF @iGu = 'I1' -- Initially information input
BEGIN
IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
WHERE m_szName = @im_szName AND serverindex = @iserverindex)
BEGIN
SELECT fError = '0', fText = 'Character duplication!'
RETURN
END
ELSE
BEGIN
DECLARE
@om_idPlayer CHAR (7) ,
@om_vScale_x REAL ,
@om_dwMotion INT ,
@om_fAngle REAL ,
@om_nHitPoint INT ,
@om_nManaPoint INT ,
@om_nFatiguePoint INT ,
@om_dwRideItemIdx INT ,
@om_dwGold INT ,
@om_nJob INT ,
@om_pActMover VARCHAR(50) ,
@om_nStr INT ,
@om_nSta INT ,
@om_nDex INT ,
@om_nInt INT ,
@om_nLevel INT ,
@om_nExp1 BIGINT ,
@om_nExp2 BIGINT ,
@om_aJobSkill VARCHAR (500),
@om_aLicenseSkill VARCHAR (500),
@om_aJobLv VARCHAR (500),
@om_dwExpertLv INT ,
@om_idMarkingWorld INT ,
@om_vMarkingPos_x REAL ,
@om_vMarkingPos_y REAL ,
@om_vMarkingPos_z REAL ,
@om_nRemainGP INT ,
@om_nRemainLP INT ,
@om_nFlightLv INT ,
@om_nFxp INT ,
@om_nTxp INT ,
@om_lpQuestCntArray VARCHAR(1024),
@om_chAuthority CHAR(1) ,
@om_dwMode INT ,
@oblockby VARCHAR(32) ,
@oTotalPlayTime INT ,
@oisblock CHAR(1) ,
@oEnd_Time CHAR(12) ,
@om_Inventory VARCHAR(6940),
@om_apIndex VARCHAR(345) ,
@om_adwEquipment VARCHAR(135) ,
@om_aSlotApplet VARCHAR(3100),
@om_aSlotItem VARCHAR(6885),
@om_aSlotQueue VARCHAR(225),
@om_SkillBar SMALLINT,
@om_dwObjIndex VARCHAR(345) ,
@om_Card VARCHAR(1980),
@om_Cube VARCHAR(1980),
@om_apIndex_Card VARCHAR(215) ,
@om_dwObjIndex_Card VARCHAR(215) ,
@om_apIndex_Cube VARCHAR(215) ,
@om_dwObjIndex_Cube VARCHAR(215) ,
@om_idparty INT ,
--@om_nNumKill INT ,
@om_idMuerderer INT ,
--@om_nSlaughter INT ,
@om_nFame INT ,
@om_nDeathExp BIGINT ,
@om_nDeathLevel INT ,
@om_dwFlyTime INT ,
@om_nMessengerState INT ,
@om_Bank VARCHAR(4290),
@om_apIndex_Bank VARCHAR(215) ,
@om_dwObjIndex_Bank VARCHAR(215) ,
@om_dwGoldBank INT
IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE serverindex = @iserverindex)
SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7)
FROM CHARACTER_TBL
WHERE serverindex = @iserverindex
ELSE
SELECT @om_idPlayer = '0000001'
SELECT @om_vScale_x = m_vScale_x,
@om_dwMotion = m_dwMotion,
@om_fAngle = m_fAngle,
@om_nHitPoint = m_nHitPoint,
@om_nManaPoint = m_nManaPoint,
@om_nFatiguePoint = m_nFatiguePoint,
@om_dwRideItemIdx = m_dwRideItemIdx,
@om_dwGold = m_dwGold,
@om_nJob = m_nJob,
@om_pActMover = m_pActMover,
@om_nStr = m_nStr,
@om_nSta = m_nSta,
@om_nDex = m_nDex,
@om_nInt = m_nInt,
@om_nLevel = m_nLevel,
@om_nExp1 = m_nExp1,
@om_nExp2 = m_nExp2,
@om_aJobSkill = m_aJobSkill,
@om_aLicenseSkill = m_aLicenseSkill,
@om_aJobLv = m_aJobLv,
@om_dwExpertLv = m_dwExpertLv,
@om_idMarkingWorld = m_idMarkingWorld,
@om_vMarkingPos_x = m_vMarkingPos_x,
@om_vMarkingPos_y = m_vMarkingPos_y,
@om_vMarkingPos_z = m_vMarkingPos_z,
@om_nRemainGP = m_nRemainGP,
@om_nRemainLP = m_nRemainLP,
@om_nFlightLv = m_nFlightLv,
@om_nFxp = m_nFxp,
@om_nTxp = m_nTxp,
@om_lpQuestCntArray = m_lpQuestCntArray,
@om_chAuthority = m_chAuthority,
@om_dwMode = m_dwMode,
@oblockby = blockby,
@oTotalPlayTime = TotalPlayTime,
@oisblock = isblock,
@oEnd_Time = CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000',
@om_Inventory = m_Inventory,
@om_apIndex = m_apIndex,
@om_adwEquipment = m_adwEquipment,
@om_aSlotApplet = m_aSlotApplet,
@om_aSlotItem = m_aSlotItem,
@om_aSlotQueue = m_aSlotQueue,
@om_SkillBar = m_SkillBar,
@om_dwObjIndex = m_dwObjIndex,
@om_Card = m_Card,
@om_Cube = m_Cube,
@om_apIndex_Card = m_apIndex_Card,
@om_dwObjIndex_Card = m_dwObjIndex_Card,
@om_apIndex_Cube = m_apIndex_Cube,
@om_dwObjIndex_Cube = m_dwObjIndex_Cube,
@om_idparty = m_idparty,
--@om_nNumKill = m_nNumKill,
@om_idMuerderer = m_idMuerderer,
--@om_nSlaughter = m_nSlaughter ,
@om_nFame = m_nFame,
@om_nDeathExp = m_nDeathExp,
@om_nDeathLevel = m_nDeathLevel,
@om_dwFlyTime = m_dwFlyTime,
@om_nMessengerState = m_nMessengerState,
@om_Bank = m_Bank,
@om_apIndex_Bank = m_apIndex_Bank,
@om_dwObjIndex_Bank = m_dwObjIndex_Bank,
@om_dwGoldBank = m_dwGoldBank
FROM BASE_VALUE_TBL
WHERE g_nSex = @im_dwSex
INSERT CHARACTER_TBL
(
m_idPlayer,
serverindex,
account,
m_szName,
playerslot,
dwWorldID,
m_dwIndex,
m_vScale_x,
m_dwMotion,
m_vPos_x,
m_vPos_y,
m_vPos_z,
m_fAngle,
m_szCharacterKey,
m_nHitPoint,
m_nManaPoint,
m_nFatiguePoint,
m_nFuel,
m_dwSkinSet,
m_dwHairMesh,
m_dwHairColor,
m_dwHeadMesh,
m_dwSex,
m_dwRideItemIdx,
m_dwGold,
m_nJob,
m_pActMover,
m_nStr,
m_nSta,
m_nDex,
m_nInt,
m_nLevel,
m_nMaximumLevel,
m_nExp1,
m_nExp2,
m_aJobSkill,
m_aLicenseSkill,
m_aJobLv,
m_dwExpertLv,
m_idMarkingWorld,
m_vMarkingPos_x,
m_vMarkingPos_y,
m_vMarkingPos_z,
m_nRemainGP,
m_nRemainLP,
m_nFlightLv,
m_nFxp,
m_nTxp,
m_lpQuestCntArray,
m_aCompleteQuest,
m_chAuthority,
m_dwMode,
m_idparty,
m_idCompany,
--m_nNumKill,
m_idMuerderer,
--m_nSlaughter,
m_nFame,
m_nDeathExp,
m_nDeathLevel,
m_dwFlyTime,
m_nMessengerState,
blockby,
TotalPlayTime,
isblock,
End_Time,
BlockTime,
CreateTime,
m_tmAccFuel,
m_tGuildMember,
m_dwSkillPoint,
m_dwReturnWorldID,
m_vReturnPos_x,
m_vReturnPos_y,
m_vReturnPos_z
)
VALUES
(
@om_idPlayer,
@iserverindex,
@iaccount,
@im_szName,
@iplayerslot,
@idwWorldID,
@im_dwIndex,
'1',
'0',
@im_vPos_x,
@im_vPos_y,
@im_vPos_z,
'0',
@im_szCharacterKey,
'230',
'63',
'32',
-1, --m_nFuel
@im_dwSkinSet,
@im_dwHairMesh,
@im_dwHairColor,
@im_dwHeadMesh,
@im_dwSex,
'0',
'0',
'0',
'1,0',
'15',
'15',
'15',
'15',
'1',
'1', --m_nMaximumLevel
'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',
'$',
'$', -- m_aCompleteQuest
'F',
'131072',
'0',
'0', -- m_idCompany
--@om_nNumKill,
'0',
--@om_nSlaughter,
'0',
'0',
'0',
'0' ,
'0',
@oblockby,
'0',
'F',
'200811030000',
CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
GETDATE(),
0,
CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
0, --m_dwSkillPoint
1,
0,
0,
0
)
declare @invi1 VARCHAR(8000)
declare @invi2 VARCHAR(8000)
declare @invi3 VARCHAR(8000)
declare @invi4 VARCHAR(8000)
IF @im_dwSex = '1'
BEGIN
SET @invi1 = '0,512,0,0,,1,0,4500000,0,0,0,-1118993182,0,0,0,0,0/1,504,0,0,,1,0,9000000,0,0,0,946307614,0,0,0,0,0/42,508,0,0,,1,0,5850000,0,0,0,750110947,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/$'
SET @invi2 = '45/43/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/42/0/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
SET @invi3 = '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/$'
SET @invi4 = '47/44/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/46/1/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
END
ELSE
BEGIN
SET @invi1 = '0,506,0,0,,1,0,5850000,0,0,0,-2005860201,0,0,0,0,0/1,502,0,0,,1,0,9000000,0,0,0,688242964,0,0,0,0,0/2,510,0,0,,1,0,4500000,0,0,0,583094601,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/$'
SET @invi2 = '45/42/43/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/0/2/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
SET @invi3 = '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/$'
SET @invi4 = '46/44/47/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/1/2/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
END
INSERT INVENTORY_TBL
(
m_idPlayer,
serverindex,
m_Inventory,
m_apIndex,
m_adwEquipment,
m_dwObjIndex
)
VALUES
(
@om_idPlayer,
@iserverindex,
@invi1,
@invi2,
@invi3,
@invi4
)
IF @@SERVERNAME = 'WEB' OR @@SERVERNAME = 'SERVER4'
SET @om_aSlotApplet = '0,2,400,0,0,0,0/1,2,398,0,1,0,0/2,2,2010,0,2,0,0/3,2,1005,0,3,0,0/4,3,25,0,4,0,0/$'
INSERT TASKBAR_TBL
(
m_idPlayer,
serverindex,
m_aSlotApplet,
m_aSlotQueue,
m_SkillBar
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$',
'$',
'100'
)
INSERT TASKBAR_ITEM_TBL
(
m_idPlayer,
serverindex,
m_aSlotItem
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$'
)
INSERT BANK_TBL
(
m_idPlayer,
serverindex,
m_Bank,
m_BankPw,
m_apIndex_Bank,
m_dwObjIndex_Bank ,
m_dwGoldBank
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$',
'0000', -- m_BankPw
'$',
'$',
'0'
)
INSERT SKILLINFLUENCE_TBL
(
m_idPlayer,
serverindex,
SkillInfluence
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$'
)
INSERT INVENTORY_EXT_TBL
(
m_idPlayer,
serverindex,
m_extInventory,
m_InventoryPiercing,
szInventoryPet
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$','$','$'
)
INSERT BANK_EXT_TBL
(
m_idPlayer,
serverindex,
m_extBank,
m_BankPiercing,
szBankPet
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$','$','$'
)
INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
VALUES (@iserverindex, @om_idPlayer, 1, 0, 0)
INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
VALUES (@iserverindex, @om_idPlayer, 2, 0, 1)
INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
VALUES (@iserverindex, @om_idPlayer, 3, 0, 2)
------------ Ver11 Pocket
INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 )
INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' )
INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 )
INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' )
INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 )
INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' )
-------------- Ver13 Honor
INSERT HONOR_MASTER_TBL ( serverindex, m_idPlayer, sec,c01,c02,c03,c04,c05,c06,c07,c08,c09,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50)
VALUES ( @iserverindex, @om_idPlayer, 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)
/*
2007-06-21 ~ 2007-07-18 New character item urgent event
*/
declare @ntime datetime
select @ntime = getdate()
if(@ntime >= '2007-06-21 00:00:00.000' and @ntime <= '2007-07-18 23:59:59.999')
begin
declare @etime bigint
select @etime = cast(replace(replace(replace(convert(char(16), dateadd(d, 7, getdate()), 21), '-', ''), ' ', ''), ':', '') as bigint)
if(@im_dwSex = 0)
begin
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, idSender)
select @om_idPlayer, @iserverindex, '26314', 1, '0000000'
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_dwKeepTime, idSender)
select @om_idPlayer, @iserverindex, '15200', 1, @etime, '0000000'
end
if(@im_dwSex = 1)
begin
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, idSender)
select @om_idPlayer, @iserverindex, '26314', 1, '0000000'
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_dwKeepTime, idSender)
select @om_idPlayer, @iserverindex, '15202', 1, @etime, '0000000'
end
end
SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer
RETURN
END
END
set nocount off
RETURN
GO

Alles anzeigen

Bug: 'ongate' ist kein gültiger Anmeldename, oder Sie haben nicht die erforderliche Berechtigung.
Fix: Abfrage

Quellcode

CREATE LOGIN [ongate] WITH PASSWORD=N'1234', DEFAULT_DATABASE=[ACCOUNT_DBF], DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [ongate] DISABLE
GO

Danke an Twilight

Bug : 'character01' ist kein gültiger Anmeldename, oder Sie haben nicht die erforderliche Berechtigung.
Fix: Abfrage

Quellcode

CREATE LOGIN [character01] WITH PASSWORD=N'1234', DEFAULT_DATABASE=[CHARACTER_01_DBF], DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [character01] DISABLE
GO

Bug: 'acc_on9@te' ist kein gültiger Anmeldename, oder Sie haben nicht die erforderliche Berechtigung.
Fix: Abfrage

Quellcode

CREATE LOGIN [acc_on9@te] WITH PASSWORD=N'1234', DEFAULT_DATABASE=[ACCOUNT_DBF], DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [acc_on9@te] DISABLE
GO

Bug: 'billing' ist kein gültiger Anmeldename, oder Sie haben nicht die erforderliche Berechtigung.
Fix: Abfrage

Quellcode

CREATE LOGIN [billing] WITH PASSWORD=N'1234', DEFAULT_DATABASE=[ACCOUNT_DBF], DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [billing] DISABLE
GO

Bug: 'account' ist kein gültiger Anmeldename, oder Sie haben nicht die erforderliche Berechtigung.
Fix: Abfrage

Quellcode

CREATE LOGIN [account] WITH PASSWORD=N'1234', DEFAULT_DATABASE=[ACCOUNT_DBF], DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [account] DISABLE
GO

Bug : Der Server 'ACCOUNT' wurde in sys.servers nicht gefunden. Prüfen Sie, ob der richtige Servername angegeben wurde. Führen Sie bei Bedarf die gespeicherte Prozedur sp_addlinkedserver aus, um den Server zu sys.servers hinzuzufügen.
Fix: Abfrage

Quellcode

exec sys.sp_addlinkedserver 'ACCOUNT', '', 'SQLNCLI', 'SQL [COLOR=Red]SERVER INSTANZNAME[/COLOR]', null, null, 'ACCOUNT_DBF'
exec sys.sp_serveroption @server='ACCOUNT', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='ACCOUNT', @optname='rpc out', @optvalue='true'

Bug: Der Server 'RANKING' wurde in sys.servers nicht gefunden. Prüfen Sie, ob der richtige Servername angegeben wurde. Führen Sie bei Bedarf die gespeicherte Prozedur sp_addlinkedserver aus, um den Server zu sys.servers hinzuzufügen.
Fix: Abfrage

Quellcode

exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL [COLOR=Red]SERVER INSTANZNAME'[/COLOR], null, null, 'RANKING_DBF'
exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'

Bug: Der Server 'CHR01' wurde in sys.servers nicht gefunden. Prüfen Sie, ob der richtige Servername angegeben wurde. Führen Sie bei Bedarf die gespeicherte Prozedur sp_addlinkedserver aus, um den Server zu sys.servers hinzuzufügen.
Fix: Abfrage

Quellcode

exec sys.sp_addlinkedserver 'CHR01', '', 'SQLNCLI', '[COLOR=Red]SQL SERVER INSTANZNAME'[/COLOR], null, null, 'CHARACTER_01_DBF'
exec sys.sp_serveroption @server='CHR01', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='CHR01', @optname='rpc out', @optvalue='true'

Bug: query:LOG_USER_CNT_STR '01', 0
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Die gespeicherte Prozedur 'LOG_USER_CNT_STR' wurde nicht gefunden.
Fix:

Quellcode

USE [LOG_01_DBF]
GO
/****** Objekt: StoredProcedure [dbo].[LOG_USER_CNT_STR] Skriptdatum: 12/25/2009 22:49:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.LOG_USER_CNT_STR Script Date: 7/29/2008 4:41:34 AM ******/
CREATE PROC [dbo].[LOG_USER_CNT_STR]
@iserverindex CHAR(2),
@im_01 INT = 0,
@im_02 INT = 0,
@im_03 INT = 0,
@im_04 INT = 0,
@im_05 INT = 0,
@im_06 INT = 0,
@im_07 INT = 0,
@im_08 INT = 0,
@im_09 INT = 0,
@im_10 INT = 0,
@im_11 INT = 0,
@im_12 INT = 0,
@im_13 INT = 0,
@im_14 INT = 0,
@im_15 INT = 0,
@im_16 INT = 0,
@im_17 INT = 0,
@im_18 INT = 0,
@im_19 INT = 0,
@im_20 INT = 0,
@im_21 INT = 0,
@im_22 INT = 0,
@im_23 INT = 0,
@im_24 INT = 0,
@im_25 INT = 0,
@im_26 INT = 0,
@im_27 INT = 0,
@im_28 INT = 0,
@im_29 INT = 0,
@im_30 INT = 0,
@im_31 INT = 0,
@im_32 INT = 0,
@im_33 INT = 0,
@im_34 INT = 0,
@im_35 INT = 0,
@im_36 INT = 0,
@im_37 INT = 0,
@im_38 INT = 0,
@im_39 INT = 0,
@im_40 INT = 0,
@im_41 INT = 0,
@im_42 INT = 0,
@im_43 INT = 0,
@im_44 INT = 0,
@im_45 INT = 0,
@im_46 INT = 0,
@im_47 INT = 0,
@im_48 INT = 0,
@im_49 INT = 0,
@im_50 INT = 0,
@im_51 INT = 0,
@im_52 INT = 0,
@im_53 INT = 0,
@im_54 INT = 0,
@im_55 INT = 0,
@im_56 INT = 0,
@im_57 INT = 0,
@im_58 INT = 0,
@im_59 INT = 0,
@im_60 INT = 0,
@im_61 INT = 0,
@im_62 INT = 0,
@im_63 INT = 0,
@im_64 INT = 0,
@im_65 INT = 0,
@im_66 INT = 0,
@im_67 INT = 0,
@im_68 INT = 0,
@im_69 INT = 0,
@im_70 INT = 0,
@im_71 INT = 0,
@im_72 INT = 0,
@im_73 INT = 0,
@im_74 INT = 0,
@im_75 INT = 0,
@im_76 INT = 0,
@im_77 INT = 0,
@im_78 INT = 0,
@im_79 INT = 0,
@im_80 INT = 0,
@im_81 INT = 0,
@im_82 INT = 0,
@im_83 INT = 0,
@im_84 INT = 0,
@im_85 INT = 0,
@im_86 INT = 0,
@im_87 INT = 0,
@im_88 INT = 0,
@im_89 INT = 0,
@im_90 INT = 0,
@im_91 INT = 0,
@im_92 INT = 0,
@im_93 INT = 0,
@im_94 INT = 0,
@im_95 INT = 0,
@im_96 INT = 0,
@im_97 INT = 0,
@im_98 INT = 0,
@im_99 INT = 0,
@im_100 INT = 0,
@im_101 INT = 0
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************
LOG_USER_CNT_STR 스토어드
작성자 : 최석준
작성일 : 2003.12.19
***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
AS
set nocount on
DECLARE @os_date CHAR(14),@onumber INT
SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)
SELECT @onumber = @im_01 + @im_02 + @im_03 + @im_04 + @im_05
+ @im_06 + @im_07 + @im_08 + @im_09 + @im_10
+ @im_11 + @im_12 + @im_13 + @im_14 + @im_15
+ @im_16 + @im_17 + @im_18 + @im_19 + @im_20
+ @im_21 + @im_22 + @im_23 + @im_24 + @im_25
+ @im_26 + @im_27 + @im_28 + @im_29 + @im_30
+ @im_31 + @im_32 + @im_33 + @im_34 + @im_35
+ @im_36 + @im_37 + @im_38 + @im_39 + @im_40
+ @im_41 + @im_42 + @im_43 + @im_44 + @im_45
+ @im_46 + @im_47 + @im_48 + @im_49 + @im_50
+ @im_51 + @im_52 + @im_53 + @im_54 + @im_55
+ @im_56 + @im_57 + @im_58 + @im_59 + @im_60
+ @im_61 + @im_62 + @im_63 + @im_64 + @im_65
+ @im_66 + @im_67 + @im_68 + @im_69 + @im_70
+ @im_71 + @im_72 + @im_73 + @im_74 + @im_75 + @im_56 + @im_57 + @im_58 + @im_59 + @im_60
+ @im_76 + @im_77 + @im_78 + @im_79 + @im_80
+ @im_81 + @im_82 + @im_83 + @im_84 + @im_85
+ @im_86 + @im_87 + @im_88 + @im_89 + @im_90
+ @im_91 + @im_92 + @im_93 + @im_94 + @im_95
+ @im_96 + @im_97 + @im_98 + @im_99 + @im_100
+ @im_101
INSERT LOG_USER_CNT_TBL
(
serverindex,
s_date,
number,
m_01,
m_02,
m_03,
m_04,
m_05,
m_06,
m_07,
m_08,
m_09,
m_10,
m_11,
m_12,
m_13,
m_14,
m_15,
m_16,
m_17,
m_18,
m_19,
m_20,
m_21,
m_22,
m_23,
m_24,
m_25,
m_26,
m_27,
m_28,
m_29,
m_30,
m_31,
m_32,
m_33,
m_34,
m_35,
m_36,
m_37,
m_38,
m_39,
m_40,
m_41,
m_42,
m_43,
m_44,
m_45,
m_46,
m_47,
m_48,
m_49,
m_50,
m_51,
m_52,
m_53,
m_54,
m_55,
m_56,
m_57,
m_58,
m_59,
m_60,
m_61,
m_62,
m_63,
m_64,
m_65,
m_66,
m_67,
m_68,
m_69,
m_70,
m_71,
m_72,
m_73,
m_74,
m_75,
m_76,
m_77,
m_78,
m_79,
m_80,
m_81,
m_82,
m_83,
m_84,
m_85,
m_86,
m_87,
m_88,
m_89,
m_90,
m_91,
m_92,
m_93,
m_94,
m_95,
m_96,
m_97,
m_98,
m_99
)
VALUES
(
@iserverindex,
@os_date,
@onumber,
@im_01,
@im_02,
@im_03,
@im_04,
@im_05,
@im_06,
@im_07,
@im_08,
@im_09,
@im_10,
@im_11,
@im_12,
@im_13,
@im_14,
@im_15,
@im_16,
@im_17,
@im_18,
@im_19,
@im_20,
@im_21,
@im_22,
@im_23,
@im_24,
@im_25,
@im_26,
@im_27,
@im_28,
@im_29,
@im_30,
@im_31,
@im_32,
@im_33,
@im_34,
@im_35,
@im_36,
@im_37,
@im_38,
@im_39,
@im_40,
@im_41,
@im_42,
@im_43,
@im_44,
@im_45,
@im_46,
@im_47,
@im_48,
@im_49,
@im_50,
@im_51,
@im_52,
@im_53,
@im_54,
@im_55,
@im_56,
@im_57,
@im_58,
@im_59,
@im_60,
@im_61,
@im_62,
@im_63,
@im_64,
@im_65,
@im_66,
@im_67,
@im_68,
@im_69,
@im_70,
@im_71,
@im_72,
@im_73,
@im_74,
@im_75,
@im_76,
@im_77,
@im_78,
@im_79,
@im_80,
@im_81,
@im_82,
@im_83,
@im_84,
@im_85,
@im_86,
@im_87,
@im_88,
@im_89,
@im_90,
@im_91,
@im_92,
@im_93,
@im_94,
@im_95,
@im_96,
@im_97,
@im_98,
@im_99
)
RETURN
set nocount off

Alles anzeigen

Großes Thanks an Twilight für die Abfragen
Und ein Thanks an Synaptic für dei 2 Fixs
Ich werde noch weiter Sachen hinnzufügen ;)

Dane · 25. Dezember 2009, 22:52

[FONT="Comic Sans MS"][COLOR="Sienna"][SIZE="2"]joa keine schlechte Idee für die mühe bekommst n thanX[/SIZE][/COLOR][/FONT]

Invitation · 25. Dezember 2009, 23:01

Hmm Spoiler scheinen nicht zu funktionieren.....

mfg

Luoo · 25. Dezember 2009, 23:03

[FONT="Century Gothic"][COLOR="DarkGreen"][SIZE="2"]Mhh haben aber gard noch funktoniert
Edit: jetzt ;)
Edit2: jetzt weider net oO[/SIZE][/COLOR][/FONT]

Invitation · 25. Dezember 2009, 23:18

Bekommst du das alleine in den Griff oder soll ich mir das mal anschaun?

mfg

Luoo · 25. Dezember 2009, 23:22

[FONT="Century Gothic"][COLOR="DarkGreen"][SIZE="2"]Ich hab das eigentlich richtig wenn ich bei mir auf ändern gehe dann speichern kann ich die spoiler ganz normal öffnen aber wenn ich f5 drücke geht es nicht[/SIZE][/COLOR][/FONT]

Russak · 25. Dezember 2009, 23:25

wenn die spoiler funktionieren würden würde ich dir n thy geben ;)
MFG
Russak

Luoo · 26. Dezember 2009, 00:00

[FONT="Century Gothic"][COLOR="DarkGreen"][SIZE="2"]So es geht wieder alles ;)
Ichw erde morgen früh ein UPDATE machen ;)[/SIZE][/COLOR][/FONT]

Russak · 26. Dezember 2009, 00:06

also bei mir geht es immer noch nicht ;)
MFG
Russak

Drenda · 26. Dezember 2009, 00:07

danke für deine mühe

cui

Dane · 26. Dezember 2009, 00:12

[FONT="Comic Sans MS"][COLOR="Sienna"][SIZE="2"]Russak probiers mal mit internet explorer :P der shi* geht iwie^^[/SIZE][/COLOR][/FONT]

electriZer · 26. Dezember 2009, 10:05

[FONT="Century Gothic"][COLOR="DeepSkyBlue"][SIZE="2"]IE FTW =3

Das sind zu viele Spoiler, FireFox hat da ausgefuchst.
Wie wäre es wenn du mal nicht so viele Spoiler nutzt?
Du kannst auch einfach Code Boxen benutzen ;D
oder die Spoiler ma ab und zu, aber do net so oft D=[/SIZE][/COLOR][/FONT]

Luoo · 26. Dezember 2009, 10:38

[FONT="Century Gothic"][COLOR="DarkGreen"][SIZE="2"]OK werde ich mal bearbeiten ;)[/SIZE][/COLOR][/FONT]

Kiya · 26. Dezember 2009, 11:08

kannste mir auch sagen
wie man den fehler weg bekommt
das da nich mehr steht
wenn man sich nen chara erstellen will
character name already in use?
kriegst schonmal für die mühe nen thanks^^

electriZer · 26. Dezember 2009, 11:12

[FONT="Century Gothic"][COLOR="DeepSkyBlue"][SIZE="2"]Wenn der Char name bereits benutzt wird, dann kannst du ihn auch nicht benutzen.
Ich kann ja hier im Forum auch keinen neuen Account mit dem Namen "Kiya" erstellen, weil er schon besetzt ist -> von dir =3
Das könnte Verwirrung unter den anderen Usern hervorbringen, denjenigen "ärgern", dass jemand anderes auch so heißt und auch Datenbank Fehler erzeugen, falls bei einer Abfrage der Name gebraucht ist ;D[/SIZE][/COLOR][/FONT]

Luoo · 26. Dezember 2009, 11:36

[FONT="Century Gothic"][COLOR="DarkGreen"][SIZE="2"]Er meint des du erstellst ein char und dann steht das da. geh zurück zu server auswahld ann zur char auswahld ann istd er da.

ch weiß es gard nciht genau muss ich nachher noch mal schauen irgendetwas muss in Varhcar umgeändert werden gdate oder so meld mich später bei dir in icq[/SIZE][/COLOR][/FONT]

Kiya · 26. Dezember 2009, 13:21

jau
wäre super
danke dir :D
frohe weihnachten xDD

juplehn · 27. Dezember 2009, 11:18

Was heißt Instanzname?
exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL SERVER [COLOR="Red"]INSTANZNAME[/COLOR]', null, null, 'RANKING_DBF'

exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'

Ich hoffe ihr könnt mir schnell helfen :D

despiteous · 27. Dezember 2009, 11:30

Das ist der Name mit dem du dich in SQL Management einloggst.

Ghostfire · 27. Dezember 2009, 11:44

juplehn;64718 schrieb:

Was heißt Instanzname?
exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL SERVER [COLOR="Red"]INSTANZNAME[/COLOR]', null, null, 'RANKING_DBF'

exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'

Ich hoffe ihr könnt mir schnell helfen :D

z.b Test-PC\SQLExpress

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Quellcode

Teilen