[DEV] A3 Management System

**zaugola** · 30-04-12

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.
------------------------------------------------------------------------------------------------

**lovbudy** · 30-04-12

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..........

**zaugola** · 01-05-12

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.

Originally Posted by lovbudy

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....

**lovbudy** · 01-05-12

Originally Posted by zaugola

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......

**chrissdegrece** · 01-05-12

congrats and thanks

Any details on what the system does?

**onyourrisk** · 01-05-12

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

**zaugola** · 01-05-12

yeap, with some new features.

guest user

register new account n get activation of new account via email
server status (can see each of the server status like zone, account, battle n login server)
heroes board
mercenaries board
retrieve password via email
news and announcement
event announcement
download announcement

registered user.

change password
offline teleport
get super shue
buy skill (only epi3 skill)
equip sss (theres a different from item3)
buy lore
rebirth
reset rebirth
merc rebirth
merc reset rebirth
adding hero statistic point
adding mercenary stat point
claim salary at every month for VIP member
reply to new & announcement, event n download section (kind a simple blog actually for this system)

admin user

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

extra features

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.

develop using codeigniter framework. i just love this framework.

**ash.blackdevil** · 01-05-12

Thanks Zaugola for the share this would surely help :)

**onyourrisk** · 02-05-12

Originally Posted by zaugola

develop using codeigniter framework. i just love this framework.

have you tried Zend ?

**zaugola** · 02-05-12

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

**onyourrisk** · 02-05-12

Yeah it did...

**a3gamemaster** · 29-05-12

whr can i download this.

**onyourrisk** · 29-05-12

Read the respected topic through out, you will come to know what to do

**vLife** · 29-05-12

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.

[DEV] A3 Management System

LinkBack

Thread Tools

[DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Re: [DEV] A3 Management System

Posting Permissions