Anyone wanna help with this FFXIWEBSERVER Beta

[skelax]

Anyone remember the old PHPizabi framework? Well I have revamped it to work with the dspt server. During install it will auto create and alter tables as needed. i have ran it 32 times to make sure there is no data loss. The webfront has:

• Login that uses current login table for usernames and password works also

• whasf's roster is built in

• character details (beta not showing weapons, armor etc)

• Registration that will add needed data into accounts table to create workable data for the ashita darkstar client

• Desktop

• Profiles

• Mail

• Forums

• Search (Beta)

Upcoming features:

• Help desk

• Character creation

• Direct AH selling and buying through webfront

• Instant messaging that works between game and web

Open to ideas and suggestions.
P.S I fixed all the old security issues with the site so if you find some let me know.
Will attach it in a few minutes.
Any bugs you find let me know immediately.



Also forgot to mention the player list you see in the mycharacters and chars areas of the site refresh every few seconds in case of change

[skelax]

Here ya go. Let me know of any issues

FFXIWEBSERVER.7z

(2.56 MiB) Downloaded 842 times

[Pseudonym]

Here's the print error, "Fatal error: Call to undefined function session_unregister() in C:\xampp\htdocs\1\index.php on line 217"

216-222:" else {
(isset($_SESSION["id"])?session_unregister('id'):false);
(isset($_SESSION["SELF_USER_DATA"])?session_unregister('SELF_USER_DATA'):false);

header("Location: {$CONF["LOGOUT_ROUTE_TO"]}");
}
}"

Sorry to show xampp, not sure if if it should be a problem, as I portforwarded the port 80, so my IP should be airing.
Directory is "\1\", I'm terrible with my reading, lack of attention span, so let me be aware if I'm violating any rules of yours as I say the following to explain furthermore for you to diagnose if it's a problem of the files or something I'm causing.

I believe this is intended of you, but I believe both server account and web accounts are to be merged, as I could log into it with my server account, right?

[Pseudonym]

It's cool now, I cleared the 'logout' trigger.
^False alarm, redirects back to index, but still logged in, and mind to PM me? I'd like to tell you something that may be very vital to you that I can't disclose on a public post.

[skelax]

have not tried it with xampp am using wamp my self. Tried recreating your issue and have been unsuccessful.

[skelax]

Well with some requests I got am trying this with phpfox dolphin and socialengine.. MY lord how auth systems are out there O.o

[skelax]

For phpfox wondering if anyone hear could translate this to use the mysql>PASSWORD()
function if (isset($this->_aUser['password']) && isset($this->_aUser['password_salt']) && !Phpfox::getLib('hash')->getRandomHash(Phpfox::getLib('hash')->setHash($this->_aUser['password'])))

[sython]

just tried installing this, and i get this after specifying admin email account :

There has been an error trying to create your administrative account. Server replied: Table ffxiweb.accounts doesnt exist


seems it didnt create the accounts table.
tables it created :
blogs, comments, events, help, inkspots & messages..

after looking at the code, it seems there are afew issues relating to the accounts table.
missing fields, email..login etc..

just wondering if this is the current version attached?

[skelax]

Hmm make sure it is linked to same db as your server.
Here is the code

Code: Select all

mysql_query("ALTER TABLE `accounts`  
ADD COLUMN `token` varchar(64)  default '', 
ADD COLUMN `last_load` int(32)  default '0',  
ADD COLUMN `act_history` longtext , 
ADD COLUMN `last_login` int(32)  default '0', 
ADD COLUMN `email_verified` tinyint(1)  default '0', 
ADD COLUMN `city` varchar(64)  default '',
ADD COLUMN `state` varchar(64)  default '', 
ADD COLUMN `country` varchar(64)  default '',
ADD COLUMN `zipcode` varchar(32)  default '',
ADD COLUMN `latitude` float  default '0',
ADD COLUMN `longitude` float  default '0',
ADD COLUMN `timezone` varchar(32)  default '',
ADD COLUMN `birthdate` varchar(32)  default '',
ADD COLUMN `astrologic_sign` varchar(32)  default '',
ADD COLUMN `horoscope` longtext , 
ADD COLUMN `horoscope_date` int(64)  default '0', 
ADD COLUMN `age` int(3)  default '0',
ADD COLUMN `gender` varchar(32)  default '',
ADD COLUMN `language` varchar(100)  default '', 
ADD COLUMN `use_theme` varchar(250)  default '',
ADD COLUMN `description` longtext ,  
ADD COLUMN `quote` varchar(250)  default '',
ADD COLUMN `header` longtext ,
ADD COLUMN `notepad_body` longtext , 
ADD COLUMN `profile_data` longtext ,
ADD COLUMN `mailboxes` longtext ,
ADD COLUMN `pictures` longtext ,
ADD COLUMN `mainpicture` varchar(100)  default '',
ADD COLUMN `contacts` longtext , 
ADD COLUMN `relationship_requests` longtext , 
ADD COLUMN `block` longtext ,  
ADD COLUMN `profile_views` longtext , 
ADD COLUMN `profile_votes` longtext ,  
ADD COLUMN `pictures_votes` longtext ,
ADD COLUMN `favorites` longtext , 
ADD COLUMN `nudges` longtext ,
ADD COLUMN `settings` longtext ,
ADD COLUMN `spam_reports` longtext ,
ADD COLUMN `abuse_reports` longtext ,
ADD COLUMN `account_type` int(32)  default '0',
ADD COLUMN `account_expire` int(64)  default '0',
ADD COLUMN `registration_date` int(64)  default '0',
ADD COLUMN `registration_reference` varchar(250)  default '',
ADD COLUMN `active` tinyint(1)  default '1', 
ADD COLUMN `disable_until` int(64)  default '0', 
ADD COLUMN `is_moderator` tinyint(1)  default '0',
ADD COLUMN `is_administrator` tinyint(1)  default '0',
ADD COLUMN `is_superadministrator` tinyint(1)  default '0';")

[skelax]

Remember if you find any bugs let me know and I will work on them right away.