[v iFlyff] Bin release and database!(v6 Pk system!)

Page 6 of 8 FirstFirst 12345678 LastLast
Results 76 to 90 of 113
  1. 16-09-12 #76
    zPro
    Apprentice zPro is offline
    MemberRank
    Mar 2011 Join Date
    22Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Fix for "HOTFIX NEW PKsql" and the channel problem


    Just delete your "CHARACTER_TBL" and execute this query

    PHP Code:
    USE [CHARACTER_01_DBF]
    GO
    /****** Object:  Table [dbo].[CHARACTER_TBL]    Script Date: 09/16/2012 17:23:33 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE     [dbo].[CHARACTER_TBL](
        [    m_idPlayer] [char](7) NULL,
        [    serverindex] [char](2) NOT NULL,
        [    account] [varchar](32) NULL,
        [    m_szName] [varchar](32) NULL,
        [    playerslot] [int] NULL,
        [    dwWorldID] [int] NULL,
        [    m_dwIndex] [int] NULL,
        [    m_vScale_x] [real] NULL,
        [    m_dwMotion] [int] NULL,
        [    m_vPos_x] [real] NULL,
        [    m_vPos_y] [real] NULL,
        [    m_vPos_z] [real] NULL,
        [    m_fAngle] [real] NULL,
        [    m_szCharacterKey] [varchar](32) NULL,
        [    m_nHitPoint] [int] NULL,
        [    m_nManaPoint] [int] NULL,
        [    m_nFatiguePoint] [int] NULL,
        [    m_nFuel] [int] NULL CONSTRAINT [DF_CHARACTER_TBL_m_nFuel]  DEFAULT ((-1)),
        [    m_dwSkinSet] [int] NULL,
        [    m_dwHairMesh] [int] NULL,
        [    m_dwHairColor] [int] NULL,
        [    m_dwHeadMesh] [int] NULL,
        [    m_dwSex] [int] NULL,
        [    m_dwRideItemIdx] [int] NULL,
        [    m_dwGold] [int] NULL,
        [    m_nJob] [int] NULL,
        [    m_pActMover] [varchar](50) NULL,
        [    m_nStr] [int] NULL,
        [    m_nSta] [int] NULL,
        [    m_nDex] [int] NULL,
        [    m_nInt] [int] NULL,
        [    m_nLevel] [int] NULL,
        [    m_nMaximumLevel] [int] NULL,
        [    m_nExp1] [bigint] NULL,
        [    m_nExp2] [bigint] NULL,
        [    m_aJobSkill] [varchar](500) NULL,
        [    m_aLicenseSkill] [varchar](500) NULL,
        [    m_aJobLv] [varchar](500) NULL,
        [    m_dwExpertLv] [int] NULL,
        [    m_idMarkingWorld] [int] NULL,
        [    m_vMarkingPos_x] [real] NULL,
        [    m_vMarkingPos_y] [real] NULL,
        [    m_vMarkingPos_z] [real] NULL,
        [    m_nRemainGP] [int] NULL,
        [    m_nRemainLP] [int] NULL,
        [    m_nFlightLv] [int] NULL,
        [    m_nFxp] [int] NULL,
        [    m_nTxp] [int] NULL,
        [    m_lpQuestCntArray] [varchar](3072) NULL,
        [    m_chAuthority] [char](1) NULL,
        [    m_dwMode] [int] NULL,
        [    m_idparty] [int] NULL,
        [    m_idCompany] [char](6) NULL,
        [    m_idMuerderer] [int] NULL,
        [    m_nSlaughter] [int] NULL,
        [    m_nNumKill] [int] NULL,
        [    m_nFame] [int] NULL,
        [    m_nDeathExp] [bigint] NULL,
        [    m_nDeathLevel] [int] NULL,
        [    m_dwFlyTime] [int] NULL,
        [    m_nMessengerState] [int] NULL,
        [    blockby] [varchar](32) NULL,
        [    TotalPlayTime] [int] NULL,
        [    isblock] [char](1) NULL,
        [    End_Time] [char](12) NULL,
        [    BlockTime] [char](8) NULL,
        [    CreateTime] [datetime] NULL,
        [    m_tmAccFuel] [int] NULL,
        [    m_tGuildMember] [char](14) NULL,
        [    m_dwSkillPoint] [int] NULL,
        [    m_aCompleteQuest] [varchar](3072) NULL,
        [    m_dwReturnWorldID] [int] NULL,
        [    m_vReturnPos_x] [real] NULL,
        [    m_vReturnPos_y] [real] NULL,
        [    m_vReturnPos_z] [real] NULL,
        [    MultiServer] [int] NOT NULL CONSTRAINT [DF_CHARACTER_MultiServer]  DEFAULT ((0)),
        [    m_SkillPoint] [int] NULL,
        [    m_SkillLv] [int] NULL,
        [    m_SkillExp] [bigint] NULL,
        [    dwEventFlag] [bigint] NULL CONSTRAINT [DF_CHARACTER_dwEventFlag]  DEFAULT ((0)),
        [    dwEventTime] [int] NOT NULL CONSTRAINT [DF_CHARACTER_dwEventTime]  DEFAULT ((0)),
        [    dwEventElapsed] [int] NOT NULL CONSTRAINT [DF_CHARACTER_dwEventElapsed]  DEFAULT ((0)),
        [    PKValue] [int] NOT NULL CONSTRAINT [DF_CHARACTER_PKValue]  DEFAULT ((0)),
        [    PKPropensity] [int] NOT NULL CONSTRAINT [DF_CHARACTER_PKPropensity]  DEFAULT ((0)),
        [    PKExp] [int] NOT NULL CONSTRAINT [DF_CHARACTER_PKExp]  DEFAULT ((0)),
        [    AngelExp] [bigint] NULL CONSTRAINT [DF_CHARACTER_AngelExp]  DEFAULT ((0)),
        [    AngelLevel] [int] NOT NULL CONSTRAINT [DF_CHARACTER_AngelLevel]  DEFAULT ((0)),
        [    FinalLevelDt] [smalldatetime] NOT NULL CONSTRAINT [DF_CHARACTER_FinalLevelDt]  DEFAULT ('2000-01-01'),
        [    m_dwPetId] [int] NULL CONSTRAINT [DF__CHARACTER__m_dwP__6B0FDBE9]  DEFAULT ((-1)),
        [    m_nExpLog] [int] NULL CONSTRAINT [DF__CHARACTER__m_nEx__7E22B05D]  DEFAULT ((0)),
        [    m_nAngelExpLog] [int] NULL CONSTRAINT [DF__CHARACTER__m_nAn__7F16D496]  DEFAULT ((0)),
        [    m_nCoupon] [int] NOT NULL CONSTRAINT [DF__CHARACTER__m_nCo__0C70CFB4]  DEFAULT ((0)),
        [    m_nLayer] [int] NULL CONSTRAINT [DF_CHARACTER_TBL_m_nLayer]  DEFAULT ((0)),
        [    m_nHonor] [int] NULL CONSTRAINT [DF_CHARACTER_TBL_m_nHonor]  DEFAULT ((-1)),
        [    m_nCampusPoint] [int] NOT NULL CONSTRAINT [DF_CHARACTER_TBL_m_nCampusPoint]  DEFAULT ((0)),
        [    idCampus] [int] NOT NULL CONSTRAINT [DF_CHARACTER_TBL_idCampus]  DEFAULT ((0)),
        [    m_aCheckedQuest] [varchar](100) NOT NULL CONSTRAINT [DF_CHARACTER_TBL_m_aCheckedQuest]  DEFAULT ('$')
    )     ON [PRIMARY]

    GO
    SET ANSI_PADDING OFF
    GO
    EXEC sys    .sp_addextendedproperty @name=N'MS_Description', @value=N'??? ?? ???' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHARACTER_TBL', @level2type=N'COLUMN',@level2name=N'm_nCampusPoint'
    GO
    EXEC sys    .sp_addextendedproperty @name=N'MS_Description', @value=N'?? Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHARACTER_TBL', @level2type=N'COLUMN',@level2name=N'idCampus'
    GO
    EXEC sys    .sp_addextendedproperty @name=N'MS_Description', @value=N'??? ??? ???? ??? ??? ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHARACTER_TBL', @level2type=N'COLUMN',@level2name=N'm_aCheckedQuest' 
    Last edited by zPro; 16-09-12 at 10:32 PM.
    Reply With Quote Reply With Quote
  2. 24-09-12 #77
    MisterKid
    Game Developer MisterKid is offline
    MemberRank
    Jun 2009 Join Date
    1,585Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    arnootie you got it running already?

    Sorry if I'm not updating much. I'm busy with school and so
    Reply With Quote Reply With Quote
  3. 25-09-12 #78
    zham
    Apprentice zham is offline
    MemberRank
    Sep 2012 Join Date
    6Posts

    ! Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    .hello..

    this would be my first post.

    I was able to run iflyff but I cannot get past the server/channel list..
    It only says connecting, nothing happens.
    it seems im having error like them.

    Code:
    2012/09/25	15:55:52
query:TRUNCATE TABLE AUCTION_TBL
SQLSTATE:42S02 error:[Microsoft][SQL Native Client][SQL Server]Cannot find the object "AUCTION_TBL" because it does not exist or you do not have permissions.
2012/09/25	16:03:08
query:uspRankGuildCombatPlayer '01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/25	16:03:17
query:GUILD_STR 'S1', '0000000', '01', '000000', ''
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/25	16:03:17
query:GUILD_STR 'S1', '0000000', '01', '000000', ''
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_BIN" and "Latin1_General_CI_AS" in the equal to operation.
2012/09/25	16:03:17
query:{call WANTED_STR('S1', '0000000', '01', '0', ?)}
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/25	16:06:45
query:CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='******',@im_szName='********************************',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_nNumKill=0,@im_idMuerderer=0,@im_nSlaughter=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]@im_nNumKill is not a parameter for procedure CHARACTER_STR.

    btw I having trouble updating the database. NEW PK PROC & HOTFIX NEW PKsql are having errors while new pk table was completed successfully.. and also I also tried using the fix zPro posted but to no avail, icant still get past the channel list..
    Reply With Quote Reply With Quote
  4. 25-09-12 #79
    MisterKid
    Game Developer MisterKid is offline
    MemberRank
    Jun 2009 Join Date
    1,585Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by zham View Post
    .hello..

    this would be my first post.

    I was able to run iflyff but I cannot get past the server/channel list..
    It only says connecting, nothing happens.
    it seems im having error like them.

    Code:
    2012/09/25	15:55:52
query:TRUNCATE TABLE AUCTION_TBL
SQLSTATE:42S02 error:[Microsoft][SQL Native Client][SQL Server]Cannot find the object "AUCTION_TBL" because it does not exist or you do not have permissions.
2012/09/25	16:03:08
query:uspRankGuildCombatPlayer '01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/25	16:03:17
query:GUILD_STR 'S1', '0000000', '01', '000000', ''
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/25	16:03:17
query:GUILD_STR 'S1', '0000000', '01', '000000', ''
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_BIN" and "Latin1_General_CI_AS" in the equal to operation.
2012/09/25	16:03:17
query:{call WANTED_STR('S1', '0000000', '01', '0', ?)}
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/25	16:06:45
query:CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='******',@im_szName='********************************',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_nNumKill=0,@im_idMuerderer=0,@im_nSlaughter=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]@im_nNumKill is not a parameter for procedure CHARACTER_STR.

    btw I having trouble updating the database. NEW PK PROC & HOTFIX NEW PKsql are having errors while new pk table was completed successfully.. and also I also tried using the fix zPro posted but to no avail, icant still get past the channel list..
    error:[Microsoft][SQL Native Client][SQL Server]@im_nNumKill is not a parameter for procedure CHARACTER_STR.

    Try running the "HOTFIX NEW PKsql" But before you do that delete character_str procedure. :S
    Reply With Quote Reply With Quote
  5. 25-09-12 #80
    arnootie
    Account Upgraded | Title Enabled! arnootie is offline
    MemberRank
    Jun 2011 Join Date
    internetLocation
    343Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by MisterKid View Post
    error:[Microsoft][SQL Native Client][SQL Server]@im_nNumKill is not a parameter for procedure CHARACTER_STR.

    Try running the "HOTFIX NEW PKsql" But before you do that delete character_str procedure. :S
    wen i do wath you say, i got this error:

    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 192
    Invalid column name 'm_nSlaughter'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 426
    Invalid column name 'm_nNumKill'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 428
    Invalid column name 'm_nSlaughter'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 462
    Invalid column name 'm_SkillPoint'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 463
    Invalid column name 'm_SkillLv'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 464
    Invalid column name 'm_SkillExp'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 0
    Invalid column name 'm_nNumKill'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 0
    Invalid column name 'm_nSlaughter'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 0
    Invalid column name 'm_SkillPoint'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 0
    Invalid column name 'm_SkillLv'.
    Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 0
    Invalid column name 'm_SkillExp'.
    how could we fix it?
    Reply With Quote Reply With Quote
  6. 25-09-12 #81
    MisterKid
    Game Developer MisterKid is offline
    MemberRank
    Jun 2009 Join Date
    1,585Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by arnootie View Post
    wen i do wath you say, i got this error:



    how could we fix it?
    Delete character_tbl and run New_PK_TBL :P
    Reply With Quote Reply With Quote
  7. 26-09-12 #82
    zham
    Apprentice zham is offline
    MemberRank
    Sep 2012 Join Date
    6Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Still no luck..here's my error logs:


    CQuery-LogFile_20120926:

    Code:
    2012/09/26	11:25:22
query:uspRankGuildCombatPlayer '01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/26	11:25:26
query:GUILD_STR 'S1', '0000000', '01', '000000', ''
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/26	11:25:26
query:GUILD_STR 'S1', '0000000', '01', '000000', ''
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_BIN" and "Latin1_General_CI_AS" in the equal to operation.
2012/09/26	11:25:27
query:{call WANTED_STR('S1', '0000000', '01', '0', ?)}
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_BIN" in the equal to operation.
2012/09/26	11:25:50
query:SELECT * FROM AUCTION_TBL
SQLSTATE:42S02 error:[Microsoft][SQL Native Client][SQL Server]Invalid object name 'AUCTION_TBL'.
2012/09/26	11:27:49
query:CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='******',@im_szName='********************************',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_nNumKill=0,@im_idMuerderer=0,@im_nSlaughter=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'CHARACTER_STR'.

    eh_20120926:

    Code:
    2012/ 9/26 11:25:50
CWorld::AddObj world id:202 x:1343.000000 y:94.000000 z:1215.000000
2012/ 9/26 11:25:51
CWorld::AddObj world id:202 x:1288.000000 y:98.000000 z:1356.000000
2012/ 9/26 11:25:51
CWorld::AddObj world id:1 x:4496.000000 y:60.000000 z:3846.000000
2012/ 9/26 11:25:51
CWorld::AddObj world id:1 x:4080.000000 y:30.000000 z:3711.000000
2012/ 9/26 11:25:51
CWorld::AddObj world id:1 x:2805.000000 y:109.000000 z:2336.000000
2012/ 9/26 11:25:51
CWorld::AddObj world id:126 x:1260.000000 y:101.000000 z:1509.000000

    error_20120926:

    Code:
    2012/ 9/26 11:25:22
\iFlyff SVN\trunk\_Database\DbManager.cpp, 853	uspRankGuildCombatPlayer '01'
2012/ 9/26 11:27:49
\iFlyff SVN\trunk\_Database\DbManager.cpp, 417	CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='nizzam',@im_szName='e26863f933748fbb501cd5bdd085b0fb',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_nNumKill=0,@im_idMuerderer=0,@im_nSlaughter=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'

	******, ********************************

    error_20120926:

    Code:
    2012/ 9/26   11:25:27   sql error: GUILD_STR 'S1', '0000000', '01', '000000', ''

2012/ 9/26   11:25:50   Awakening: nDst = 8, dwTotalProb = 0

2012/ 9/26   11:25:50   Awakening: nDst = 14, dwTotalProb = 0

2012/ 9/26   11:25:50   Awakening: nDst = 72, dwTotalProb = 0

2012/ 9/26   11:25:50   OP: 4458000, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2012/ 9/26   11:25:50   mvr_NpcAchaben.chr : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:50   LoadObject : mvr_NpcAchaben.o3d Àб⠽ÇÆÐ

2012/ 9/26   11:25:50   Model\mvr_NpcAchaben.o3d : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:50   mvr_NpcAchaben_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:50   mvr_NpcAchaben_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_NpcAchaben.chr : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   LoadObject : mvr_NpcAchaben.o3d Àб⠽ÇÆÐ

2012/ 9/26   11:25:51   Model\mvr_NpcAchaben.o3d : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   mvr_NpcAchaben_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_NpcAchaben_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA.chr : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   LoadObject : mvr_RANGDA.o3d Àб⠽ÇÆÐ

2012/ 9/26   11:25:51   Model\mvr_RANGDA.o3d : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA.chr : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   LoadObject : mvr_RANGDA.o3d Àб⠽ÇÆÐ

2012/ 9/26   11:25:51   Model\mvr_RANGDA.o3d : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA.chr : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   LoadObject : mvr_RANGDA.o3d Àб⠽ÇÆÐ

2012/ 9/26   11:25:51   Model\mvr_RANGDA.o3d : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA.chr : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   LoadObject : mvr_RANGDA.o3d Àб⠽ÇÆÐ

2012/ 9/26   11:25:51   Model\mvr_RANGDA.o3d : ãÀ» ¼ö ¾øÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½

2012/ 9/26   11:25:51   mvr_RANGDA_stand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½
    Last edited by zham; 26-09-12 at 05:38 AM.
    Reply With Quote Reply With Quote
  8. 26-09-12 #83
    arnootie
    Account Upgraded | Title Enabled! arnootie is offline
    MemberRank
    Jun 2011 Join Date
    internetLocation
    343Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    i deleted character_tbl and CHARACTER_STR

    than i dit:

    NEW PK TBL
    NO errors!

    than
    NEW PK PROC
    Msg 208, Level 16, State 6, Procedure CHARACTER_STR, Line 1521
    Invalid object name 'dbo.CHARACTER_STR'.

    than:
    HOTFIX NEW PKsql
    Msg 208, Level 16, State 6, Procedure CHARACTER_STR, Line 1952
    Invalid object name 'dbo.CHARACTER_STR'.
    i gues charachter_str is missing, you told use to delete it tho... how can i have it back?

    i deleted character_tbl and CHARACTER_STR

    than i dit:

    NEW PK TBL
    NO errors!

    than
    NEW PK PROC
    Msg 208, Level 16, State 6, Procedure CHARACTER_STR, Line 1521
    Invalid object name 'dbo.CHARACTER_STR'.

    than:
    HOTFIX NEW PKsql
    Msg 208, Level 16, State 6, Procedure CHARACTER_STR, Line 1952
    Invalid object name 'dbo.CHARACTER_STR'.
    than:
    sql
    Msg 2714, Level 16, State 6, Line 2
    There is already an object named 'AUCTION_TBL' in the database.
    Msg 208, Level 16, State 6, Procedure SAVE_AUCTION, Line 25
    Invalid object name 'dbo.SAVE_AUCTION'.
    afther it i open my server, first accountserver than databaseserver... the database wont open and i got this 2 errors:


    CQuery-LogFile_20120926
    2012/09/26 17:50:15
    query:uspLoadPlayerData '01'
    SQLSTATE:42S02 error:[Microsoft][SQL Native Client][SQL Server]Invalid object name 'CHARACTER_TBL'.

    error_20120926
    2012/ 9/26 17:50:15 LoadPlayerData - query: uspLoadPlayerData '01'


    how could we fix


    its also seems like i am not the only one who got those problems.... so its somthing with your filles i gues :s
    Reply With Quote Reply With Quote
  9. 27-09-12 #84
    audisbroder
    ツ audisbroder is offline
    MemberRank
    Aug 2011 Join Date
    Not foundLocation
    1,180Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by arnootie View Post
    i deleted character_tbl and CHARACTER_STR

    than i dit:

    NEW PK TBL
    NO errors!

    than
    NEW PK PROC



    than:
    HOTFIX NEW PKsql


    i gues charachter_str is missing, you told use to delete it tho... how can i have it back?

    i deleted character_tbl and CHARACTER_STR

    than i dit:

    NEW PK TBL
    NO errors!

    than
    NEW PK PROC



    than:
    HOTFIX NEW PKsql


    than:
    sql


    afther it i open my server, first accountserver than databaseserver... the database wont open and i got this 2 errors:


    CQuery-LogFile_20120926



    error_20120926




    how could we fix


    its also seems like i am not the only one who got those problems.... so its somthing with your filles i gues :s
    Nah.. He's files works perfect =)
    Reply With Quote Reply With Quote
  10. 27-09-12 #85
    MisterKid
    Game Developer MisterKid is offline
    MemberRank
    Jun 2009 Join Date
    1,585Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    I will take a look at it or make the sql quarries useable by everyone i guess.
    Reply With Quote Reply With Quote
  11. 27-09-12 #86
    zham
    Apprentice zham is offline
    MemberRank
    Sep 2012 Join Date
    6Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by MisterKid View Post
    I will take a look at it or make the sql quarries useable by everyone i guess.
    yeah..i think the files are ok.. only the sql queries which gives the error..
    what database are you using.?
    Reply With Quote Reply With Quote
  12. 27-09-12 #87
    MisterKid
    Game Developer MisterKid is offline
    MemberRank
    Jun 2009 Join Date
    1,585Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by zham View Post
    yeah..i think the files are ok.. only the sql queries which gives the error..
    what database are you using.?
    Donno I think i used the v15 database then edited it. :S Then I made those querry for the server xD
    Reply With Quote Reply With Quote
  13. 27-09-12 #88
    zham
    Apprentice zham is offline
    MemberRank
    Sep 2012 Join Date
    6Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by MisterKid View Post
    Donno I think i used the v15 database then edited it. :S Then I made those querry for the server xD
    the AIOv15 v3 by Sedrika.? ok.. I'll try again.
    Reply With Quote Reply With Quote
  14. 27-09-12 #89
    MisterKid
    Game Developer MisterKid is offline
    MemberRank
    Jun 2009 Join Date
    1,585Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    Quote Originally Posted by zham View Post
    the AIOv15 v3 by Sedrika.? ok.. I'll try again.
    Hell no. Uhm My sql services are broken :/ Well Got to wait for my new laptop guys xD
    It just wont run and I'm at this moment too lazy too fix it. :S
    Last edited by MisterKid; 27-09-12 at 04:36 PM.
    Reply With Quote Reply With Quote
  15. 27-09-12 #90
    zham
    Apprentice zham is offline
    MemberRank
    Sep 2012 Join Date
    6Posts

    Re: [v iFlyff] Bin release and database!(v6 Pk system!)

    can anyone upload a database in which I can use.?
    Reply With Quote Reply With Quote


Page 6 of 8 FirstFirst 12345678 LastLast
« Previous Thread | Next Thread »

Advertisement