Need help on GMTool.sql and also the web php scripts?

Results 1 to 13 of 13
  1. #1
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Need help on GMTool.sql and also the web php scripts?

    Does anyone have this 2 files? that's the only file missing in my SRV files Y_Y... i cant DL it because the link is dead...if there's anyone can help me or send me the files i would appreciate it... thanks...

    decypher01@gmail.com thanks


  2. #2
    Member GM-GaMeX is offline
    MemberRank
    Sep 2009 Join Date
    73Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    need script TantraGM?

    Create a database with the name TantraGM
    Now right-click to tantragm and executes a new query

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo]. [GMInfo] (
    [Id] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPart] [nvarchar] (50) NULL COLLATE Latin1_General_CI_AS
    ) ON [PRIMARY]

    CREATE TABLE [dbo]. [GMLog] (
    [LogIndex] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [SaveDate] [datetime] NULL,
    [Description] [text] COLLATE NULL Latin1_General_CI_AS
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    CREATE TABLE [dbo]. [GMLogView] (
    [LogIndex] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [SaveDate] [datetime] NULL,
    [Description] [text] COLLATE NULL Latin1_General_CI_AS
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    you need this database to connect the gmtool

    or rather, see this video guide

    http://www.megaupload.com/?d=X2IY0IKD
    Last edited by GM-GaMeX; 07-10-09 at 03:03 AM.

  3. #3
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Quote Originally Posted by GM-GaMeX View Post
    need script TantraGM?

    Create a database with the name TantraGM
    Now right-click to tantragm and executes a new query



    you need this database to connect the gmtool

    or rather, see this video guide

    http://www.megaupload.com/?d=X2IY0IKD
    ty for you reply sir...

    now im starting again xD

  4. #4
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Got this nextproblem in the database GM Y_Y
    Attached Thumbnails Attached Thumbnails lol.jpg  

  5. #5
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Quote Originally Posted by GM-GaMeX View Post
    need script TantraGM?

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo]. [GMInfo] (
    [Id] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPart] [nvarchar] (50) NULL COLLATE Latin1_General_CI_AS
    ) ON [PRIMARY]


    CREATE TABLE [dbo]. [GMLog] (
    [LogIndex] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [SaveDate] [datetime] NULL,
    [Description] [text] COLLATE NULL Latin1_General_CI_AS
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    CREATE TABLE [dbo]. [GMLogView] (
    [LogIndex] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [SaveDate] [datetime] NULL,
    [Description] [text] COLLATE NULL Latin1_General_CI_AS
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    Problem Solved Just a syntax error highlighted

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo]. [GMInfo] (
    [Id] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS
    ) ON [PRIMARY]

    CREATE TABLE [dbo]. [GMLog] (
    [LogIndex] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [SaveDate] [datetime] NULL,
    [Description] [text] COLLATE Latin1_General_CI_AS
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    CREATE TABLE [dbo]. [GMLogView] (
    [LogIndex] [int] IDENTITY (1,1) NOT NULL,
    [GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
    [SaveDate] [datetime] NULL,
    [Description] [text] COLLATE Latin1_General_CI_AS
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

  6. #6
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Another Problem Occured

    Please help.. this is the error in Adding the ODBC

    here's the attachment
    Attached Thumbnails Attached Thumbnails aw.jpg  

  7. #7
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Quote Originally Posted by decypher01 View Post
    Another Problem Occured

    Please help.. this is the error in Adding the ODBC

    here's the attachment
    Problem Solved again just an ODBC error sorry for noobishness

  8. #8
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Another Serious Problem in ZoneSRV.exe

    anyone can figure this out? my DBSRV and MSGSRV Works fine
    only ZONESRV has this problem Y_Y please enlighten me..
    Attached Thumbnails Attached Thumbnails probzone.jpg  

  9. #9
    Member GM-GaMeX is offline
    MemberRank
    Sep 2009 Join Date
    73Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Quote Originally Posted by decypher01 View Post
    Another Serious Problem in ZoneSRV.exe

    anyone can figure this out? my DBSRV and MSGSRV Works fine
    only ZONESRV has this problem Y_Y please enlighten me..
    listen



    need to create a file serverlist.txt within your dbsrv and zonesrv.
    The file will contain the FOLLOWING:

    0 1
    0 0 192.168.0.100 1000 ->>> 192.168.0.100 It's where you should put your ip
    0 1 192.168.0.100 3001
    0 2 192.168.0.100 3002
    0 3 192.168.0.100 3003
    0 4 192.168.0.100 3004
    0 5 192.168.0.100 3005
    0 6 192.168.0.100 3006
    0 7 192.168.0.100 3007
    0 8 192.168.0.100 3008
    0 9 192.168.0.100 3009
    0 10 192.168.0.100 3010
    0 11 192.168.0.100 3011
    0 12 192.168.0.100 3012
    0 13 192.168.0.100 3013
    0 14 192.168.0.100 3014
    0 15 192.168.0.100 3015
    0 16 192.168.0.100 3016
    0 17 192.168.0.100 3017
    0 18 192.168.0.100 3018
    0 19 192.168.0.100 3019
    0 20 192.168.0.100 3020
    0 21 192.168.0.100 3021
    0 22 192.168.0.100 3022
    0 23 192.168.0.100 3023
    0 24 192.168.0.100 3024
    0 25 192.168.0.100 3025
    0 26 192.168.0.100 3026
    0 27 192.168.0.100 3027
    0 28 192.168.0.100 3028
    0 29 192.168.0.100 3029
    0 30 192.168.0.100 3030
    0 31 192.168.0.100 3031
    0 32 192.168.0.100 3032
    0 33 192.168.0.100 3033
    0 34 192.168.0.100 3034
    0 35 192.168.0.100 3035
    0 36 192.168.0.100 3036
    0 37 192.168.0.100 3037
    0 38 192.168.0.100 3038
    0 39 192.168.0.100 3039
    0 40 192.168.0.100 3040
    0 41 192.168.0.100 3041
    0 42 192.168.0.100 3042
    0 43 192.168.0.100 3043
    0 44 192.168.0.100 3044
    0 45 192.168.0.100 3045
    0 46 192.168.0.100 3046
    0 47 192.168.0.100 3047
    0 48 192.168.0.100 3048
    0 49 192.168.0.100 3049
    0 50 192.168.0.100 3050
    0 51 192.168.0.100 5001
    0 52 192.168.0.100 5052
    0 53 192.168.0.100 5053
    0 54 192.168.0.100 5054
    0 55 192.168.0.100 7514
    followed by a ip is the port number used by each server services
    0 1 192.168.0.100 3001
    the following sections: 0 1 192.168.0.100 3001
    where
    *is your ip
    *is your port

    Also you need based on the above have a localip.txt within each server services.
    in dbsrv will create a localip.txt containing the following: 0 0 192.168.0.100 1000
    in zone 1 (Mandara) will create a localip.txt containing the following:
    0 1 192.168.0.100 3001
    in zone 1 (Uxmal) will create a localip.txt containing the following:
    0 1 192.168.0.100 3002
    and so sices in each of the zones

  10. #10
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    This is My Localip.txt and serverlist.text from my DBSRV
    Attached Files Attached Files

  11. #11
    Apprentice decypher01 is offline
    MemberRank
    Oct 2009 Join Date
    10Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    and this one from my ZONESRV kindly check if im missing something?
    Attached Files Attached Files

  12. #12
    Novice UnderDog is offline
    MemberRank
    Jun 2011 Join Date
    4Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    Sir can i ask for a copy of the english GM tool because i have the spain version.. and how do you connect a GM tool to an online game? pls help

    thanks and here my email :) -> shi_mami@yahoo.com

  13. #13
    Member zeinzu_james21 is offline
    MemberRank
    Jan 2010 Join Date
    ManilaLocation
    63Posts

    Re: Need help on GMTool.sql and also the web php scripts?

    stop bumping..



Advertisement