[Development] Immortal web

[western]

This is the site i'm currently working on, it's only a preview and will keep it simple for now, also i'll work it with the framework codeigniter.

 

[kev]

This is the site i'm currently working on, it's only a preview and will keep it simple for now, also i'll work it with the framework codeigniter.

Looking nice

 

[Nexux]

can you share your account create html plz?

 

[ananbabo]

Good!:laugh:

 

[western]

can you share your account create html plz?

yeah, it will take some time, first need connect to the mssql database with php, thing i am trying now, it would be more easy without mssql.

 

[Merrcy.]

Hope you finish soon keep it up.

 

[Nexux]

well i got this far with that code igniter has for db connector


$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = '192.168.1.2';
$db['default']['username'] = 'sa';
$db['default']['password'] = '123456';
$db['default']['database'] = 'PassportBOIOLD';
$db['default']['dbdriver'] = 'mssql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

idk if you need a controler for the query to work my php skils are low...

bdw how do i make the ID change evertime a user registers becouse that ID# does not work well

 

[NanayaQ]

well i got this far with that code igniter has for db connector


$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = '192.168.1.2';
$db['default']['username'] = 'sa';
$db['default']['password'] = '123456';
$db['default']['database'] = 'PassportBOIOLD';
$db['default']['dbdriver'] = 'mssql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

idk if you need a controler for the query to work my php skils are low...

bdw how do i make the ID change evertime a user registers becouse that ID# does not work well

Check on How to make an account thread by Kev on BOI tutorial section, because OzzyGT just pose a very good one dunno if that will help but it does genarate different ID for accounts.

 

[Nexux]

heres a server status script

Server status configuration
*/
$config['STATUS']['LOGIN']['HOST'] = 'windows ip/gate save server';
$config['STATUS']['LOGIN']['PORT'] = gate save server port;
$config['STATUS']['GAME']['HOST'] = 'windows ip/server';
$config['STATUS']['GAME']['PORT'] = gamesave port;
$config['STATUS']['PANEL']['HOST'] = 'web host';
$config['STATUS']['PANEL']['PORT'] = web port /default is 80;
$config['STATUS']['FTP']['HOST'] = 'ftp ip';
$config['STATUS']['FTP']['PORT'] = ftp port/default is 21;

ok so i got to this point of the sql query.


$account = protect_this_input_variable($_POST['account']);
$password = md5($_POST['password']);

$query = "INSERT INTO account (id,creatime,name,passwd,usertype) Values('YOURID','YYYY.MM.DD','NAME',PASSWORD,'1')";

and maybe this works for password encription?

//Seeding
$config['PASSWORD']['HASH_SEED'] = 'Panelby%sNexux'; //%s will be replaced with the User's Password. Leave blank to deactivate
//Hashing
$config['PASSWORD']['HASH_METHOD'] = 'md5'; // md5 or sha1. Leave blank to deactivate

 

[western]

It will be with 2 databases conections, one in mysql for the website(for login/edit password/admin post notices/and other stuff in future) and the other for mssql(for create new user/edit password). I started working with mysql first, because the server is in my friend house, tomorrow will try to open mssql ports so i can check if connects to the db. I hope can authenticate the mssql user, i chose a framework for security against like xss, csrf, sqli, etc.
But the most important here is that can connect and authenticate the mssql user(sa or other).

 

[kev]

dunno if this any help? maby change the mysql parts to mssql

these are .php files i changed to .txt to upload

 

[Nexux]

idk if mysql strings work o mssql

 

[western]

This is from the perfect world game? maybe works...

 

[Nexux]

well to remote connect just open mysql bench and add account with your windows ip and add all privileges and your done

 

[western]

This is so funny, mssql crash on my friend pc, i can see there is no services in SQL server configuration manager, is blank and can't start up services lol.

 

[Nexux]

do you need a mssql server? you can use mine for testing stuff.

 

[western]

*PM sent

 

[Nexux]

read pm plz

 

[western]

Ho men, mssql with php is so hard, can remember now why i gave up 3 years ago lol
The site it's almost done, but can't connect to mssql

 

[OzzyGT]

It's not that hard to connect to mssql from php.

To use mssql with php on linux first you have to install the driver, as root:

yum install php-mssql

and restart apache:

/etc/init.d/httpd restart

or

service httpd restart

If you are in windows, you have to uncomment the driver in php.ini. But if you're going to use apache on windows I think it would be better to use IIS with aspx.

The hard part comes when you have to insert the binary data (password) from php. I don't know, maybe if you try a query it would work but I usually use prepared statements for inserting data in the databases (safer).

I made a quick account registration page (html and php) as demostration of how to connect to mssql from php. It's more secure than the average registration page but I don't recommend using it in a production server.

Also, I had trouble sending the password as binary data from php, so I send it as a String and use the stored procedure "adduser" to convert the password to binary. So if you want to use this registration page you'll have to modify the sp:

USE [PassportBOIOLD]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[adduser]
@name varchar(64),
@passwd varchar(32),
@prompt varchar(32),
@answer varchar(32),
@truename varchar(32),
@idnumber varchar(32),
@email varchar(64),
@mobilenumber varchar(32),
@province varchar(32),
@city varchar(32),
@phonenumber varchar(32),
@address varchar(64),
@postalcode varchar(8),
@gender integer,
@birthday varchar(32),
@qq varchar(32),
@passwd2 varchar(32)
AS
BEGIN

	BEGIN TRAN
	DECLARE @id integer
	DECLARE @now datetime
	SELECT @now = getdate()
	INSERT INTO account SELECT ISNULL(max(id), 16) + 16, @name, CONVERT(BINARY,@passwd,2), @now, 0 FROM account
	SELECT @id = id FROM account WHERE name = @name
	INSERT INTO users VALUES (@id, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, @qq, CONVERT(BINARY,@passwd2,2))
	EXEC [dbo].[adduserpoint] @id, 9, 10
	COMMIT TRAN

END

Just copy the text in a new query window (SQL Server Management Studio) and press execute.

Using this, the sp will create the rows for the account, user and point tables, also I saw someone asking about the auto-increment for the ids, using this stored procedure you'll get that, but for some reason, the original developers make the autoincrement by 16. So the ids are going to be 16,32,64,80... and I guess is for a reason so I'm not going to change that.

If you can connect from Linux to MSSQL, this registration page should work. Just need to change the IP of the mssql server in the php and the URL in the form of the HTML.

Hope it helps someone or at least you can use the connection part to learn how to use mssql from php.