2009 database

Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    2009 database

    Need some little clarification :

    dbo.LocatorStatus

    - ElapseUpdateTime : What to put there, it's needed to save up.


  2. #2
    Animu Addicted Number12 is offline
    MemberRank
    Apr 2008 Join Date
    Old Sunny CALocation
    1,264Posts

    Re: 2009 database

    put 30000

  3. #3
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    Re: 2009 database

    Thank you but is it normal I don't see a shit in the Locator window?

  4. #4
    Animu Addicted Number12 is offline
    MemberRank
    Apr 2008 Join Date
    Old Sunny CALocation
    1,264Posts

    Re: 2009 database

    Quote Originally Posted by fred94 View Post
    Thank you but is it normal I don't see a shit in the Locator window?
    takes a little while.

  5. #5
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    Re: 2009 database

    It seems it stops here

    Code:
    start init locator.
    MLocator create.

  6. #6
    Account Upgraded | Title Enabled! maxteam is offline
    MemberRank
    Aug 2007 Join Date
    IndiaLocation
    428Posts

    Re: 2009 database

    put this code in killers locator.ini
    Code:
    [DB]
    DNS="GunzDB"
    USERNAME="sa"
    PASSWORD="qwefvbnmjuyhgtfrswedfr"
    
    [NETWORK]
    IP="127.0.0.1"
    PORT="8900"
    
    [NETWORK]
    IP="127.0.0.1"
    PORT="8900"
    
    [ENV]
    ID="1"
    LOCATOR_UID_HIGH="5"
    LOCATOR_UID_LOW="0"
    MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME="1000"
    UDP_LIVE_TIME="10000000"
    MAX_FREE_RECV_COUNT_PER_LIVE_TIME="9"
    BLOCK_TIME="0"
    UPDATE_UDP_MANAGER_ELAPSED_TIME="3"
    MARGIN_OF_ERROR_MIN="500000"
    USE_COUNTRY_CODE_FILTER="no" 
    GMT_DIFF="-3"
    ELAPSED_TIME_UPDATE_LOCATOR_LOG="3600000"
    ELAPSED_TIME_UPDATE_LOCATOR_LOG="10000"
    ELAPSED_TIME_UPDATE_COUNTRYCODEFILTER_LOG="10000"
    UPDATE_COUNTRY_CODE="66 89 69 77 73 83 65 78 68"
    TEST_SERVER="0"

  7. #7
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    Re: 2009 database

    Still no meesages appearing...

  8. #8
    Account Upgraded | Title Enabled! maxteam is offline
    MemberRank
    Aug 2007 Join Date
    IndiaLocation
    428Posts

    Re: 2009 database

    it takes 2 mins to appear
    also post locator log

  9. #9
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    Re: 2009 database

    Didn't wait that long but let me wait...

    ---------- Post added at 08:29 AM ---------- Previous post was at 08:19 AM ----------

    Here's a log

    Code:
    start init locator.
    MLocator create.
    
    ===========================Loator self dump(2009-12-26 3:22)=========================
     - Server dead count list- 
    LiveServerCount(0) : DeadServerCount(0)
    
    Country code3 cache hit miss count : 0
    Invalid IP count : 0
    Block Count : 0
    Country code check count : 0
    Block country code hit count : 0
    ========================================================================================
    
    
    ======================================================
    Locator Status Info.
    Recv UDP Manager Status Info
    Size:0
    Send UDP Manager Status Info
    Size:0
    Block UDP Manager Status Info
    Size:0
    ======================================================

  10. #10
    Account Upgraded | Title Enabled! maxteam is offline
    MemberRank
    Aug 2007 Join Date
    IndiaLocation
    428Posts

    Re: 2009 database

    Quote Originally Posted by fred94 View Post
    Didn't wait that long but let me wait...

    ---------- Post added at 08:29 AM ---------- Previous post was at 08:19 AM ----------

    Here's a log

    Code:
    start init locator.
    MLocator create.
    
    ===========================Loator self dump(2009-12-26 3:22)=========================
     - Server dead count list- 
    LiveServerCount(0) : DeadServerCount(0)
    
    Country code3 cache hit miss count : 0
    Invalid IP count : 0
    Block Count : 0
    Country code check count : 0
    Block country code hit count : 0
    ========================================================================================
    
    
    ======================================================
    Locator Status Info.
    Recv UDP Manager Status Info
    Size:0
    Send UDP Manager Status Info
    Size:0
    Block UDP Manager Status Info
    Size:0
    ======================================================
    uhm delete locatorstatus table and execute this
    PHP Code:
    USE [GunzDB]
    GO
    /****** Object:  Table [dbo].[ServerStatus]    Script Date: 12/26/2009 11:19:22 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE 
    [dbo].[LocatorStatus](
        [
    LocatorID] [intNOT NULL,
        [
    IP] [varchar](15NOT NULL,
        [
    Port] [intNOT NULL,
        [
    RecvCount] [intNULL,
        [
    SendCount] [intNULL,
        [
    BlockCount] [intNULL,
        [
    DuplicatedCount] [intNULL,
        [
    UpdateElapsedTime] [intNOT NULL,
        [
    LastUpdatedTime] [datetimeNULL,
    PRIMARY KEY CLUSTERED 
    (
        [
    LocatorIDASC
    )WITH (IGNORE_DUP_KEY OFFON [PRIMARY]
    ON [PRIMARY]

    GO
    SET ANSI_PADDING OFF 

  11. #11
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    Re: 2009 database

    After doing what you said...

    Code:
    start init locator.
    MLocator create.
    
    ======================================================
    Locator Status Info.
    Recv UDP Manager Status Info
    Size:0
    Send UDP Manager Status Info
    Size:0
    Block UDP Manager Status Info
    Size:0
    ======================================================

  12. #12
    Account Upgraded | Title Enabled! maxteam is offline
    MemberRank
    Aug 2007 Join Date
    IndiaLocation
    428Posts

    Re: 2009 database

    did u actually do the serverstatus thingy, it shld work

  13. #13
    Account Upgraded | Title Enabled! fred94 is offline
    MemberRank
    Jun 2008 Join Date
    250Posts

    Re: 2009 database

    Mind making up a .bak file please?

    ---------- Post added at 08:50 AM ---------- Previous post was at 08:48 AM ----------

    Ok, found it, server opened I had it to NULL.

  14. #14
    The beer?? Its here !!! Rotana is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    1,733Posts

    Re: 2009 database

    Quote Originally Posted by maxteam View Post
    it takes 2 mins to appear
    also post locator log
    Hmm, mine does an complete startup in about 5 secs. With server info and all.

  15. #15

    Re: 2009 database

    Mine takes less than a second.

    Also, avoid editing the table dbo.LocatorStatus.

    Edit dbo.ServerStatus and you're done.
    Last edited by Linear88; 28-12-09 at 04:12 AM.



Page 1 of 2 12 LastLast

Advertisement