[DEV] A3 Management System

Results 1 to 14 of 14
  1. #1
    Account Inactive zaugola is offline
    InactiveRank
    Dec 2006 Join Date
    250Posts

    [DEV] A3 Management System


    RaGEZONE Recommends

    RaGEZONE Recommends

    i purposely put this a3 web here so that we could develop together n share it among the community

    anyway, here goes the thingy....

    requirement
    1. apache web server
    2. php5.3 n higher

    php5.2 n below with a little bit tweak......

    get the source
    u can get it the system from here...

    download the source from subversion.

    Code:
    svn checkout http://a3-web-management-system.googlecode.com/svn/trunk/ a3-web-management-system-read-only
    then move the contents of the trunk folder into the root of ur webserver, example :
    Code:
    c:\xampp\htdocs
    configurations n setting
    database
    please setup the database as usual using custom database as i provide.there are ASD n HSDB database for the system, please use that database which comes with the system source. otherwise it wont work at all.

    there is some new table which i cant remember which 1 it is n table account n charac0 have been modified for this purpose.

    configuration files
    check 2 files for the configuration
    1. application\config\database.php
    2. application\config\a3.php

    edit those 2 files accordingly (probably ull have some problems for file a3.php. see post #2 below)

    testing n commissioning
    open up ur favorite browser n run this
    Code:
    http://localhost
    ------------------------------------------------------------------------------------------------
    how to retrieve the source from subversion?

    go here

    Code:
    http://tortoisesvn.net/downloads.html
    download n install.

    once u r done, create new folder on ur desktop. right click on it n choose checkout.

    View image: 04

    insert this code inside explorer browser

    Code:
    http://a3-web-management-system.googlecode.com/svn/trunk/

    View image: 05

    congratulations !! u get the code....
    ------------------------------------------------------------------------------------------------
    configurations using gmail
    u have to do this cos i have setup this AMS using gmail. for the registration of the new account and retrieve password via this ams, ur player need to activate their account and retrieve forgotten password via email. this is how u r going to do it.

    create new gmail account or use existing 1 that u have. go to

    setting > Forwarding and POP/IMAP

    enable POP for the mail that arrives from now on

    save changes

    done here at gmail account

    go to a3.php

    edit line 41, 42, 45 to 48.
    ------------------------------------------------------------------------------------------------
    troubleshoot
    so if there is any reason that u get something like this...

    then edit this file :

    Code:
    c:\xampp\htdocs\driver_sqlsrv.php
    insert all the credentials in that file, run it.

    Code:
    http://localhost/driver_sqlsrv.php
    however if u still get an error like this

    http://forum.ragezone.com/6860202-post12.html

    pls take a look at the link

    System Requirements (Microsoft Drivers for PHP for SQL Server)

    download n install sqlncli.exe from that site n ull be ok with it.
    ------------------------------------------------------------------------------------------------
    Last edited by zaugola; 01-05-12 at 03:09 AM.
    no signature required as this is computer printed matter


  2. #2
    Shortcut to Hell lovbudy is offline
    True MemberRank
    Feb 2010 Join Date
    Navi Mumbai (NeLocation
    299Posts

    Re: [DEV] A3 Management System

    Can you please mention the database changes required It would be appreciated as Dont want to Remove the current Database :|

    Nice AMS Anyway config file Gave Demo..........
    Ragezone and A3 562 Server Guide.Please Read this Before Posting
    I would Like to change world but they wont give me source Code
    "Ragezone is a place to come to learn and share your knowledge.
    If you are not here for those reasons,
    Then you are here for the wrong ones" -Lovbudy

  3. #3
    Account Inactive zaugola is offline
    InactiveRank
    Dec 2006 Join Date
    250Posts

    Re: [DEV] A3 Management System

    ASD database

    Code:
    USE [ASD]
    GO
    /****** Object:  Table [dbo].[charac0]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[charac0]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[charac0](
        [c_id] [varchar](50) NOT NULL,
        [c_sheadera] [varchar](255) NOT NULL,
        [c_sheaderb] [varchar](255) NOT NULL,
        [c_sheaderc] [int] NOT NULL,
        [c_headera] [varchar](255) NOT NULL,
        [c_headerb] [varchar](255) NOT NULL,
        [c_headerc] [varchar](255) NOT NULL,
        [d_cdate] [smalldatetime] NULL,
        [d_udate] [smalldatetime] NULL,
        [c_status] [varchar](50) NOT NULL,
        [m_body] [varchar](4000) NOT NULL,
        [rb] [int] NOT NULL CONSTRAINT [DF_charac0_rb]  DEFAULT (0),
        [times_rb] [int] NOT NULL CONSTRAINT [DF_charac0_times_rb]  DEFAULT (0)
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[temp_account]    Script Date: 04/29/2012 23:03:17 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[temp_account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[temp_account](
        [username] [varchar](50) NULL,
        [password] [varchar](50) NULL,
        [email] [varchar](50) NULL,
        [passkey] [varchar](50) NULL,
        [date] [smalldatetime] NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[Account]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[Account](
        [c_id] [varchar](50) NOT NULL,
        [c_sheadera] [varchar](255) NOT NULL,
        [c_sheaderb] [varchar](255) NOT NULL,
        [c_sheaderc] [varchar](255) NOT NULL,
        [c_headera] [varchar](255) NOT NULL,
        [c_headerb] [varchar](255) NOT NULL,
        [c_headerc] [varchar](255) NOT NULL,
        [d_cdate] [smalldatetime] NULL,
        [d_udate] [smalldatetime] NULL,
        [c_status] [char](10) NOT NULL,
        [m_body] [varchar](4000) NULL,
        [acc_status] [varchar](50) NULL,
        [salary] [smalldatetime] NULL,
        [last_salary] [smalldatetime] NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[A3Web_HTML]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[A3Web_HTML]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[A3Web_HTML](
        [Bil] [int] IDENTITY(1,1) NOT NULL,
        [Author] [varchar](50) NULL,
        [Category] [varchar](50) NULL,
        [Subject] [varchar](50) NULL,
        [HTML] [varchar](4000) NULL,
        [Date] [smalldatetime] NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[captcha]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[captcha]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[captcha](
        [captcha_id] [bigint] IDENTITY(1,1) NOT NULL,
        [captcha_time] [int] NOT NULL,
        [ip_address] [varchar](50) NOT NULL,
        [word] [varchar](50) NOT NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[A3Web_Comment]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[A3Web_Comment]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[A3Web_Comment](
        [bil] [int] IDENTITY(1,1) NOT NULL,
        [bil_post] [int] NOT NULL,
        [author] [varchar](50) NOT NULL,
        [html] [varchar](max) NOT NULL,
        [date] [smalldatetime] NOT NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    those r the changes. look closely at the account n charac0 table. ive modified both of the table as u can see it up there. account : 3 new columns n for the charac0 : 2 new columns.


    HSDB db

    Code:
    USE [HSDB]
    GO
    /****** Object:  Table [dbo].[MERC]    Script Date: 04/29/2012 23:10:07 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MERC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[MERC](
        [HSID] [int] NOT NULL,
        [HSName] [varchar](255) NOT NULL,
        [MasterName] [varchar](255) NOT NULL,
        [Type] [int] NOT NULL,
        [HSLevel] [smallint] NOT NULL,
        [rb] [int] NOT NULL,
        [reset_rb] [int] NOT NULL CONSTRAINT [DF_MERC_reset_rb]  DEFAULT ((0))
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    just insert this new table inside ur HSDB table n ull be fine.

    Quote Originally Posted by lovbudy View Post
    Can you please mention the database changes required It would be appreciated as Dont want to Remove the current Database :|

    Nice AMS Anyway config file Gave Demo..........
    errrr demo.......

    sorry, no demo, i only have a production 1 n u know where is it....
    Last edited by zaugola; 01-05-12 at 03:11 AM.
    no signature required as this is computer printed matter

  4. #4
    Shortcut to Hell lovbudy is offline
    True MemberRank
    Feb 2010 Join Date
    Navi Mumbai (NeLocation
    299Posts

    Re: [DEV] A3 Management System

    Quote Originally Posted by zaugola View Post
    ASD database

    Code:
    USE [ASD]
    GO
    /****** Object:  Table [dbo].[charac0]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[charac0]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[charac0](
        [c_id] [varchar](50) NOT NULL,
        [c_sheadera] [varchar](255) NOT NULL,
        [c_sheaderb] [varchar](255) NOT NULL,
        [c_sheaderc] [int] NOT NULL,
        [c_headera] [varchar](255) NOT NULL,
        [c_headerb] [varchar](255) NOT NULL,
        [c_headerc] [varchar](255) NOT NULL,
        [d_cdate] [smalldatetime] NULL,
        [d_udate] [smalldatetime] NULL,
        [c_status] [varchar](50) NOT NULL,
        [m_body] [varchar](4000) NOT NULL,
        [rb] [int] NOT NULL CONSTRAINT [DF_charac0_rb]  DEFAULT (0),
        [times_rb] [int] NOT NULL CONSTRAINT [DF_charac0_times_rb]  DEFAULT (0)
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[temp_account]    Script Date: 04/29/2012 23:03:17 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[temp_account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[temp_account](
        [username] [varchar](50) NULL,
        [password] [varchar](50) NULL,
        [email] [varchar](50) NULL,
        [passkey] [varchar](50) NULL,
        [date] [smalldatetime] NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[Account]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[Account](
        [c_id] [varchar](50) NOT NULL,
        [c_sheadera] [varchar](255) NOT NULL,
        [c_sheaderb] [varchar](255) NOT NULL,
        [c_sheaderc] [varchar](255) NOT NULL,
        [c_headera] [varchar](255) NOT NULL,
        [c_headerb] [varchar](255) NOT NULL,
        [c_headerc] [varchar](255) NOT NULL,
        [d_cdate] [smalldatetime] NULL,
        [d_udate] [smalldatetime] NULL,
        [c_status] [char](10) NOT NULL,
        [m_body] [varchar](4000) NULL,
        [acc_status] [varchar](50) NULL,
        [salary] [smalldatetime] NULL,
        [last_salary] [smalldatetime] NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[A3Web_HTML]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[A3Web_HTML]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[A3Web_HTML](
        [Bil] [int] IDENTITY(1,1) NOT NULL,
        [Author] [varchar](50) NULL,
        [Category] [varchar](50) NULL,
        [Subject] [varchar](50) NULL,
        [HTML] [varchar](4000) NULL,
        [Date] [smalldatetime] NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[captcha]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[captcha]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[captcha](
        [captcha_id] [bigint] IDENTITY(1,1) NOT NULL,
        [captcha_time] [int] NOT NULL,
        [ip_address] [varchar](50) NOT NULL,
        [word] [varchar](50) NOT NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    /****** Object:  Table [dbo].[A3Web_Comment]    Script Date: 04/29/2012 23:03:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[A3Web_Comment]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[A3Web_Comment](
        [bil] [int] IDENTITY(1,1) NOT NULL,
        [bil_post] [int] NOT NULL,
        [author] [varchar](50) NOT NULL,
        [html] [varchar](max) NOT NULL,
        [date] [smalldatetime] NOT NULL
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    those r the changes. look closely at the account n charac0 table. ive modified both of the table as u can see it up there. account : 3 new columns n for the charac0 : 2 new columns.


    HSDB db

    Code:
    USE [HSDB]
    GO
    /****** Object:  Table [dbo].[MERC]    Script Date: 04/29/2012 23:10:07 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MERC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    BEGIN
    CREATE TABLE [dbo].[MERC](
        [HSID] [int] NOT NULL,
        [HSName] [varchar](255) NOT NULL,
        [MasterName] [varchar](255) NOT NULL,
        [Type] [int] NOT NULL,
        [HSLevel] [smallint] NOT NULL,
        [rb] [int] NOT NULL,
        [reset_rb] [int] NOT NULL CONSTRAINT [DF_MERC_reset_rb]  DEFAULT ((0))
    ) ON [PRIMARY]
    END
    GO
    SET ANSI_PADDING OFF
    GO
    just insert this new table inside ur HSDB table n ull be fine.


    errrr demo.......

    sorry, no demo, i only have a production 1 n u know where is it....
    Thanks for the Query......
    Ragezone and A3 562 Server Guide.Please Read this Before Posting
    I would Like to change world but they wont give me source Code
    "Ragezone is a place to come to learn and share your knowledge.
    If you are not here for those reasons,
    Then you are here for the wrong ones" -Lovbudy

  5. #5
    Goodbye chrissdegrece is offline
    True MemberRank
    Oct 2009 Join Date
    GreeceLocation
    1,017Posts

    Re: [DEV] A3 Management System

    congrats and thanks

    Any details on what the system does?

  6. #6
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: [DEV] A3 Management System

    Its account control panel and it helps players to take RB, Offline teleport and some other important orations, he has already done this before but now he is kind of redeveloping it, correct me if I'm wrong
    [SIGPIC][/SIGPIC]

  7. #7
    Account Inactive zaugola is offline
    InactiveRank
    Dec 2006 Join Date
    250Posts

    Re: [DEV] A3 Management System

    yeap, with some new features.

    guest user

    1. register new account n get activation of new account via email
    2. server status (can see each of the server status like zone, account, battle n login server)
    3. heroes board
    4. mercenaries board
    5. retrieve password via email
    6. news and announcement
    7. event announcement
    8. download announcement

    registered user.

    1. change password
    2. offline teleport
    3. get super shue
    4. buy skill (only epi3 skill)
    5. equip sss (theres a different from item3)
    6. buy lore
    7. rebirth
    8. reset rebirth
    9. merc rebirth
    10. merc reset rebirth
    11. adding hero statistic point
    12. adding mercenary stat point
    13. claim salary at every month for VIP member
    14. reply to new & announcement, event n download section (kind a simple blog actually for this system)

    admin user

    1. edit news, event and download section n not to mention editing or deleting reply from the normal/registered user.
    2. account information via character name
    3. changing account type from normal user to admin and vice versa
    4. paid membership. upgrading normal user to VIP for x month
    5. ban and unban account through character name
    6. alter any character statistic points i.e str, int, dex, vit n mana
    7. equip G9, g10, uni set to the character n full features of passive skill that character can have...
    8. insert sss
    9. learn epi5 skill
    10. insert lore
    11. insert GOS
    12. insert a box of items
    13. insert 1 item into the char
    14. character cloning
    15. kh/guild removal
    16. info pk
    17. alter pk timer for a character
    18. insert item manually

    extra features

    1. security


    • i might say its ALMOST invulnerable to sql inject n cross scripting. however, even the most secured/impregnable prison is also can be break. same goes with this software.


    1. develop using codeigniter framework. i just love this framework.
    Last edited by zaugola; 01-05-12 at 08:11 PM.
    no signature required as this is computer printed matter

  8. #8
    Account Inactive ash.blackdevil is offline
    InactiveRank
    Apr 2010 Join Date
    75Posts

    Re: [DEV] A3 Management System

    Thanks Zaugola for the share this would surely help :)

  9. #9
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: [DEV] A3 Management System

    Quote Originally Posted by zaugola View Post
    develop using codeigniter framework. i just love this framework.
    have you tried Zend ?
    [SIGPIC][/SIGPIC]

  10. #10
    Account Inactive zaugola is offline
    InactiveRank
    Dec 2006 Join Date
    250Posts
    Yea... Have tried zend. Simply dont like it cos of integration 3rd party software like jquery, phpmailer n ckeditor is hard to be done n additional a lot of codes.

    N most important thing is database driver. Zend use mssql while codeigniter used sqlsrv which means this ams cant be run on php5.3 if i develop it using zend. This ams can run on php 5.2 by simply changing sqlsrv to mssql by editing

    /application/config/database.php

    Hope that answer ur doubts....

    Sent from my GT-N7000 using Tapatalk 2
    no signature required as this is computer printed matter

  11. #11
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: [DEV] A3 Management System

    Yeah it did...
    [SIGPIC][/SIGPIC]

  12. #12
    Ultimate Member a3gamemaster is offline
    MemberRank
    Jul 2011 Join Date
    Gujrat [India]Location
    182Posts

    Re: [DEV] A3 Management System

    whr can i download this.

  13. #13
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: [DEV] A3 Management System

    Read the respected topic through out, you will come to know what to do
    [SIGPIC][/SIGPIC]

  14. #14
    Iron like a Lion in Zion! vLife is offline
    Super ModRank
    Apr 2009 Join Date
    The BahamasLocation
    3,692Posts

    Re: [DEV] A3 Management System

    Seeing how the OP has not posted an update for a while, I will deem this closed.

    If you want this re-opened, PM me or any other moderator/visior of this section.

    "The privilege they never get to know"




Advertisement