[release]Ascent web manager

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.



Demo------------->
User = tester Pass = admin

UPDATED 11/14/2007

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

---

Do you have a demo link?

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 :p

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

SWEET! I think this is exactly what i need

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

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

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

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!

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.

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

@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

Code:

---


ERR!

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

---

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

Quote:

---

Originally Posted by brainnysmurfs

@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!

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

Quote:

---

<?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 = "brainnysmurfs@hotmail.com"; //receiving email address
$mailer_type = "smtp"; //("mail", "sendmail", "smtp")
$from_mail = "email@localhost.com"; //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 = "mail@domain.com"; //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;

?>

---

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

---

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

Quote:

---

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

---

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

---

here is my config.php:

Code:

---


<?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@domain.com"; //receiving email address
$mailer_type = "smtp"; //("mail", "sendmail", "smtp")
$from_mail = "email@localhost.com"; //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 = "mail@domain.com"; //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;
?>


---

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.

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

Very nice.. works ok for me.. :) keep it up :)

Yes gmaze I use my database, I'm using Windows XP SP2

I don't know, for certain....do you have the files in proper folder?
open the webam folder, select all, copy...then paste in the folder your www is hosted from.


UPDATED: added a changelog...many fixes

If I may add

If you do this

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();
                                    }
                        }
                }
        }*/

---

You'll still get the IP of the account/person registering,

Great Work, Hope to see the next release soon!

Amazing, thanks for the great app.

LOL looks like you updated it before I got to it.

Could you please conntact me
summersjonathonATgmailDOTcom
Thank you