[release]Ascent web manager

gmaze · Nov 9, 2007

WeB.A.M. --> an ascent cms based off mangos mini-manager
(most of the code is unaltered, and all original credits remain intact)

Features:
1)Main
a)Displays realm status and characters online, including their level and map
b)A message of the day listing
c)Configs for displaying your current database and ascent revision
d)Mailer feature. PHP and SMTP
e)SSH feature to integrate with your FTP
f)Site permissions and game permissions are the same
g)Most tables sortable by clicking the header
2)Accounts system.
a)Can create, edit, or delete accounts. This includes users updating email or passwords.
b)Can be used as a sign-up page.
c)Browseable and Searchable
d)Seperate banned section to make it easy to find
3)Guilds Section
a)Browseable and Searchable.
b)Sub-display will give detailed information about each guild
4)Characters Section
a)Browseable and Searchable.
b)Sub-display (only partially functional) gives detailed character info
5)Game Management
a) Handle GM Tickets by reading them from the site. Can also post edits to them, or delete resolved ones
b)Send mail from the site to in game player.
6)Database Management
a)Back-up feature will save all your account and character tables to an included backup folder(SQL format)
b)Clean-up feature will delete all unused accounts and any data corresponding to that account
c)Run-SQL feature allows executing SQL files to your database from the site.

To view the content, you need to sign in or register

User = tester Pass = admin

To view the content, you need to sign in or register

Changelog/todo lists:

Code:

Version 1.1 changelog

changes and fixes:
1.fixed account browsing
2.fixed character browsing
3.fixed account linking to characters
4.fixed register bug where everyone was gm 0
5.updated config.php to include all necessary user inputs
6.implemented rough item table editor structure
7.ban ip link from account detail fixed. 
8.corrected ban ip to include banning of ips and accounts instead of accounts only

on my immediate todo:
1.Zone map identification fix
2.Character stats and item display
3.finish item editing/creation table
4.fix bug that isn't allowing editing of others accounts by admins

extended todo:
1.Much more database editing features
2.sending mail to ingame mailbox
3.define log-in levels with ascent defines(letters) instead of integers
4.add a ban account feature-in case you don't want to ban whole ip, just 1 account

hazzardous · Nov 9, 2007

Do you have a demo link?

gmaze · Nov 9, 2007

sure, I added a link to a demo.
keep in mind this kinda requires a server as well, so not everything will function properly. Since I host a server already, can't really give a full demo without giving everyone admin status, which would just be insane on my part

EDIT: also, as you will have admin status....be respectful of others and don't edit the account information.

matrox02 · Nov 11, 2007

SWEET! I think this is exactly what i need

Someplayer · Nov 12, 2007

Ooo.. Very nice.. I'm very interested..

brainnysmurfs · Nov 12, 2007

I can't create an account and I can't find anything in the config.php on how to have an administrator account.... I'm getting this error > Users from IP range: 121.97.197.53 cannot create accounts

gmaze · Nov 12, 2007

thnx for the bug report. there is a bug in the limit accounts by ip check, to by-pass this till i get it fixed do the following:
1.open the register.php file and find the following section(around line 29)

Code:

 //get ip
	if (getenv('HTTP_X_FORWARDED_FOR')) $last_ip = getenv('HTTP_X_FORWARDED_FOR');	
    	else $last_ip = getenv('REMOTE_ADDR');
		
	$valid_ip_mask = explode('.', $valid_ip_mask);
	if ($valid_ip_mask[0] != "xxx"){
		$user_ip_mask = explode('.', $last_ip);
		if ($valid_ip_mask[0] != $user_ip_mask[0]) { 
			header("Location: register.php?err=9&usr=$last_ip"); 
			exit();
			} else if ($valid_ip_mask[1] != "xxx"){
					if ($valid_ip_mask[1] != $user_ip_mask[1]) { 
						header("Location: register.php?err=9&usr=$last_ip"); 
						exit();
						} else if ($valid_ip_mask[2] != "xxx"){
								if ($valid_ip_mask[2] != $user_ip_mask[2]) { 
									header("Location: register.php?err=9&usr=$last_ip"); 
									exit();
									}
						}
				}
		}

2. comment it out by placing /* at the beginning, and */ at the end
below is how it should look

Code:

 //get ip
/*	if (getenv('HTTP_X_FORWARDED_FOR')) $last_ip = getenv('HTTP_X_FORWARDED_FOR');	
    	else $last_ip = getenv('REMOTE_ADDR');
		
	$valid_ip_mask = explode('.', $valid_ip_mask);
	if ($valid_ip_mask[0] != "xxx"){
		$user_ip_mask = explode('.', $last_ip);
		if ($valid_ip_mask[0] != $user_ip_mask[0]) { 
			header("Location: register.php?err=9&usr=$last_ip"); 
			exit();
			} else if ($valid_ip_mask[1] != "xxx"){
					if ($valid_ip_mask[1] != $user_ip_mask[1]) { 
						header("Location: register.php?err=9&usr=$last_ip"); 
						exit();
						} else if ($valid_ip_mask[2] != "xxx"){
								if ($valid_ip_mask[2] != $user_ip_mask[2]) { 
									header("Location: register.php?err=9&usr=$last_ip"); 
									exit();
									}
						}
				}
		}*/

This will allow unlimited accounts tho....

brainnysmurfs · Nov 13, 2007

How about the Administrator sir? How can I do that? I really do appreciate your effort in replying to my problem... Thank you sir! It really helps me a lot!

gmaze · Nov 13, 2007

thats done by if you have the status on your game account.....in your db, under accounts, your account needs set to 'az'(without '') in gm table.

Wesley313 · Nov 13, 2007

where is a www folder? ha how do i make one?

brainnysmurfs · Nov 13, 2007

@gmaze
Thank you sir! But I have a new problem now, everytime I try to login in web manager, I can't get through with it. It redirects me to login screen again

Kira90 · Nov 13, 2007

Code:

ERR!

Field \\\'sessionkey\\\' doesn\\\'t have a default value

<--- thats my error ... ? whats wrong ... VERY NICE APP bye the way ...

L1zarT · Nov 13, 2007

brainnysmurfs said:
@gmaze
Thank you sir! But I have a new problem now, everytime I try to login in web manager, I can't get through with it. It redirects me to login screen again

I have the same problem. also had the other problem. compared the script with the mango version. the reason of the problem isn't the part that's in the script, it's the part that is missing.
in config.php :

under the line "$limit_acc_per_ip = false; //true = limit to one account per IP"
add this:

/* this option will limit account creation to users from selected net range(s).
* allow all => empty array
* e.g: "120-122.55.255-0.255-0", */
$valid_ip_mask = array();

then everything will work fine and if you want to you could use the option.

but please! what is the reason that it won't login? every message works like username doesn't exist or wrong password. only when you login correctly it won't work.

btw, thanx a lot for the script! keep up the good work!

brainnysmurfs · Nov 14, 2007

still, can't get through it. But thanks for your help sir!

<?php
/*
* Project Name: WeBAM (web ascent manager)
* Date: 03.11.2007 inital version (1.0)
* Author: SixSixNine
* Copyright: SixSixNine
* Email: *****
* License: GNU General Public License (GPL)
* Updated/Edited for Ascent: gmaze
*/

$version = "1.0"; //WeBAM version
$ascent_rev = "emulator revision"; //ascent revision
$db_rev = "database revision"; //database revision

//---- MySQL configuration ----
$dbhost = "localhost"; //MySQL host name
$dbuser = "myusername"; //MySQL user name
$dbpass = "mypassword"; //MySQL password
$acct_db = "character"; //account database name
$char_db = "character"; //character database name
$world_db = "world"; //world database name

//---- game server configuration ----
$server = "aduro.servegame.com"; //server ip
$port = 8129; //server port

//---- file transfer configuration ----
$terminal_type = "SSH"; //type of terminal used (SSH,Telnet)
$terminal_port = 22; //22 - default ssh /23 - telnet

//---- Mail configuration ----
$admin_mail = "[email protected]"; //receiving email address
$mailer_type = "smtp"; //("mail", "sendmail", "smtp")
$from_mail = "[email protected]"; //all emails will be sent from this email
//---- smtp server config IF used ----
$smtp_host = "localhost"; //mailer host
$smtp_port = 25; //mailer port
$smtp_username = "[email protected]"; //mailer user name
$smtp_password = "mailpassword"; //mailer password

//---- New account creation Options ----
$disable_acc_creation = false; //false = allow new accounts to be created
$validate_mail_host = false; //false = do not use email validation for account creation
$limit_acc_per_ip = false; //true = limit to one account per IP
/* this option will limit account creation to users from selected net range(s).
* allow all => empty array
* e.g: "120-122.55.255-0.255-0", */
$valid_ip_mask = array();

//---- Layout configuration ----
$title = "BayanDSL Beta World Of Warcraft"; //page title
$itemperpage = 15; //number of items to display per page
$css_template = "default.css"; //filename of css template to use from templates directory
$item_datasite = "http://wow.allakhazam.com/item.html?witem="; //site to use for item data

//---- Backup configuration ----
$backup_dir = "./backup"; //make sure webserver have the permission to write/read it!

//list of tables in account db that will be saved on backup
$tables_backup_acct = Array(
"accounts",
"ipbans"
);

//list of tables in character db will be saved on backup
$tables_backup_char = Array(
"arenateams",
"auctions",
"characters",
"charters",
"corpses",
"gm_tickets",
"groups",
"guilds",
"guild_ranks",
"instances",
"mailbox",
"playercooldownitems",
"playercooldownsecurity",
"playeritems",
"playerpets",
"playerpetspells",
"playersummonspells",
"questlog",
"server_settings",
"social",
"tutorials"
);

// override PHP error reporting - true will set error reporting to E_ALL ^ E_NOTICE
$debug = true;

?>

gmaze · Nov 14, 2007

put localhost in under game configs/ server ip

Code:

//---- game server configuration ----
$server = "aduro.servegame.com"; //server ip<--------change to localhost
$port = 8129; //server port

brainnysmurfs · Nov 14, 2007

still can't get through with it, thank you for your reply sir! I've changed the aduro.servegame.com to localhost

//---- game server configuration ----
$server = "localhost"; //server ip
$port = 8129; //server port

gmaze · Nov 14, 2007

did you change the password and user name for the sql host?

Code:

//---- MySQL configuration ----
$dbhost = "localhost"; //MySQL host name
$dbuser = "myusername"; //MySQL user name<-------generally is root
$dbpass = "mypassword"; //MySQL password<--------pass to access database
$acct_db = "character"; //account database name
$char_db = "character"; //character database name
$world_db = "world"; //world database name

L1zarT · Nov 14, 2007

here is my config.php:

Code:

[SIZE=2]
<?php
/*
* Project Name: WeBAM (web ascent manager)
* Date: 03.11.2007 inital version (1.0)
* Author: SixSixNine
* Copyright: SixSixNine
* Email: *****
* License: GNU General Public License (GPL)
* Updated/Edited for Ascent: gmaze 
*/
$version = "1.0"; //WeBAM version
$ascent_rev = "R2303"; //ascent revision
$db_rev = "Rev643"; //database revision
//---- MySQL configuration ----
$dbhost = "localhost"; //MySQL host name
$dbuser = "root"; //MySQL user name
$dbpass = "******"; //MySQL password
$acct_db = "character"; //account database name
$char_db = "character"; //character database name
$world_db = "world"; //world database name
//---- game server configuration ----
$server = "127.0.0.1"; //server ip
$port = 8129; //server port
//---- file transfer configuration ----
$terminal_type = "SSH"; //type of terminal used (SSH,Telnet)
$terminal_port = 22; //22 - default ssh /23 - telnet
//---- Mail configuration ----
$admin_mail = "[email protected]"; //receiving email address
$mailer_type = "smtp"; //("mail", "sendmail", "smtp")
$from_mail = "[email protected]"; //all emails will be sent from this email
//---- smtp server config IF used ----
$smtp_host = "localhost"; //mailer host
$smtp_port = 25; //mailer port
$smtp_username = "[email protected]"; //mailer user name
$smtp_password = "mailpassword"; //mailer password
//---- New account creation Options ----
$disable_acc_creation = false; //false = allow new accounts to be created
$validate_mail_host = false; //false = do not use email validation for account creation
$limit_acc_per_ip = false; //true = limit to one account per IP
/* this option will limit account creation to users from selected net range(s).
* allow all => empty array
* e.g: "120-122.55.255-0.255-0", */
$valid_ip_mask = array();
//---- Layout configuration ----
$title = "L1zarT WoW PS"; //page title
$itemperpage = 15; //number of items to display per page
$css_template = "default.css"; //filename of css template to use from templates directory
$item_datasite = "http://wow.allakhazam.com/item.html?witem="; //site to use for item data
//---- Backup configuration ----
$backup_dir = "./backup"; //make sure webserver have the permission to write/read it!
//list of tables in account db that will be saved on backup
$tables_backup_acct = Array(
"accounts",
"ipbans"
);
//list of tables in character db will be saved on backup
$tables_backup_char = Array(
"arenateams",
"auctions",
"characters",
"charters",
"corpses",
"gm_tickets",
"groups",
"guilds",
"guild_ranks",
"instances",
"mailbox",
"playercooldownitems",
"playercooldownsecurity",
"playeritems",
"playerpets",
"playerpetspells",
"playersummonspells",
"questlog",
"server_settings",
"social",
"tutorials"
);
// override PHP error reporting - true will set error reporting to E_ALL ^ E_NOTICE
$debug = true;
?>
[/SIZE]

maybe a problem in the login.php file? it won't forward to the index.php page. in the original they create a cookie. this one doesn't.

gmaze · Nov 14, 2007

well, funny thing is, you 2 are the only reports of this.......maybe its an OS issue, i don't know for sure.
I just copy/pasted your config, altered the info to my specs, and replaced my config.php with yours, and everything works.
Did you change the database entries to your database??

Flexa · Nov 14, 2007

Very nice.. works ok for me..

keep it up

[release]Ascent web manager

Experienced Elementalist

Initiate Mage

Experienced Elementalist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Initiate Mage

Newbie Spellweaver

Experienced Elementalist

Initiate Mage

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Initiate Mage

Experienced Elementalist

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners