Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[DEV] A3 Management System

Status
Not open for further replies.
Experienced Elementalist
Joined
Dec 15, 2006
Messages
246
Reaction score
32
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.
zaugola - [DEV] A3 Management System - RaGEZONE Forums
zaugola - [DEV] A3 Management System - RaGEZONE Forums
zaugola - [DEV] A3 Management System - RaGEZONE Forums



insert this code inside explorer browser

Code:
http://a3-web-management-system.googlecode.com/svn/trunk/
zaugola - [DEV] A3 Management System - RaGEZONE Forums



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
zaugola - [DEV] A3 Management System - RaGEZONE Forums

setting > Forwarding and POP/IMAP
zaugola - [DEV] A3 Management System - RaGEZONE Forums

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...
zaugola - [DEV] A3 Management System - RaGEZONE Forums

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



download n install sqlncli.exe from that site n ull be ok with it.
------------------------------------------------------------------------------------------------
 
Last edited:
Experienced Elementalist
Joined
Feb 27, 2010
Messages
283
Reaction score
32
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..........
 
Experienced Elementalist
Joined
Dec 15, 2006
Messages
246
Reaction score
32
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,
[COLOR=Red]    [rb] [int] NOT NULL CONSTRAINT [DF_charac0_rb]  DEFAULT (0),
    [times_rb] [int] NOT NULL CONSTRAINT [DF_charac0_times_rb] [/COLOR] 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,
[COLOR=Red]    [acc_status] [varchar](50) NULL,
    [salary] [smalldatetime] NULL,
    [last_salary] [smalldatetime] NULL[/COLOR]
) 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.

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:
Experienced Elementalist
Joined
Feb 27, 2010
Messages
283
Reaction score
32
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,
[COLOR=Red]    [rb] [int] NOT NULL CONSTRAINT [DF_charac0_rb]  DEFAULT (0),
    [times_rb] [int] NOT NULL CONSTRAINT [DF_charac0_times_rb] [/COLOR] 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,
[COLOR=Red]    [acc_status] [varchar](50) NULL,
    [salary] [smalldatetime] NULL,
    [last_salary] [smalldatetime] NULL[/COLOR]
) 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......
 
Goodbye
Loyal Member
Joined
Oct 6, 2009
Messages
965
Reaction score
134
congrats and thanks

Any details on what the system does?
 
@work
Joined
Jan 26, 2008
Messages
617
Reaction score
39
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
 
Experienced Elementalist
Joined
Dec 15, 2006
Messages
246
Reaction score
32
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.:D:

  1. develop using codeigniter framework. i just love this framework.
 
Last edited:
Experienced Elementalist
Joined
Dec 15, 2006
Messages
246
Reaction score
32
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....

2
 
@work
Joined
Jan 26, 2008
Messages
617
Reaction score
39
Read the respected topic through out, you will come to know what to do
 
Status
Not open for further replies.
Back
Top