[Request]Web Registry

Hello,

I am setting up a PServer, now I succesfully installed the server and got it up (in "closed beta", just for me and other staff).

Now what I actually want to ask, is help or explanation with/for making a web registry page.

What I'd like to know is, what program I should use, and what I need to do to make it work. So actually just the "installation" of the file(s), I can set it on the website/edit the layout and such by my self, I just need to know how to make it work. :D

PS: It's an EP5.4 server that's using MSSQL 2012, and I'm using the "kinda" new files from Abrasive, the one he released with better security and without chance of SQL injection. (Thanks Abrasive for releasing this files btw :D)

1. Download Xampp V1.7.3 from Apachefriends.org
2. Open php.ini and uncomment the line ;php_mssql...
3. start it and put your register pages in it.

Done. Good luck.

I've downloaded/installed XAMPP 1.7.3 from CNET, 'cause Apachefriends.org didn't had a download link, or at least I couldn't find it (yet it's still the Apache Friends edition). But when I installed it, it only gives me the Control Panel to use, the others are the set-up and uninstallation and the Shell. Do I need to use the Control Panel and start one of the modules listed? Also, the php.ini should that be on the registration files or in XAMPP itselves (I have abrasive's files in the folder are only PHP files).

PS: Do I have to do this on the server host PC or can I just do this from any PC? Just to be sure haha.

Thanks for your already given help! And also a Happy New Year everyone, that it may be a year with fun, love, healthiness and welfare :D

Quote:

Originally Posted by Prideness I've downloaded/installed XAMPP 1.7.3 from CNET, 'cause Apachefriends.org didn't had a download link, or at least I couldn't find it (yet it's still the Apache Friends edition). But when I installed it, it only gives me the Control Panel to use, the others are the set-up and uninstallation and the Shell. Do I need to use the Control Panel and start one of the modules listed? Also, the php.ini should that be on the registration files or in XAMPP itselves (I have abrasive's files in the folder are only PHP files). PS: Do I have to do this on the server host PC or can I just do this from any PC? Just to be sure haha. Thanks for your already given help! And also a Happy New Year everyone, that it may be a year with fun, love, healthiness and welfare :D

Install on the host which hosting your server and installing apache service, mysql service then go to the security.hptd file and edit to make public and security settings. Remember needs port 80 to be open.

Quote:

Originally Posted by Prideness I've downloaded/installed XAMPP 1.7.3 from CNET, 'cause Apachefriends.org didn't had a download link, or at least I couldn't find it (yet it's still the Apache Friends edition). But when I installed it, it only gives me the Control Panel to use, the others are the set-up and uninstallation and the Shell. Do I need to use the Control Panel and start one of the modules listed? Also, the php.ini should that be on the registration files or in XAMPP itselves (I have abrasive's files in the folder are only PHP files). PS: Do I have to do this on the server host PC or can I just do this from any PC? Just to be sure haha. Thanks for your already given help! And also a Happy New Year everyone, that it may be a year with fun, love, healthiness and welfare :D

Okay so you have downloaded it.
Just go to the folder c:/xampp and find php.ini in the folder apache. There uncomment the line ;php_mssql...
After that open port 80 in your firewall and run the module apache from the control panel.
This should all be done on the host.
If you need further help with this you can pm me your skypename.
-[ADM]Hyperion

Hello,

First of all thanks for your replies! Now I'm quite happy, 'cause I got the last thing(s) working by myself. Just not with the RECAPTCHA 'cause everytime the box wouldn't show up, now I have copied the line of "Confirm Password" and deleted the variables in it to my "Security Question" in register.view.php and deleted the recaptchalib.php and recaptchalib.config.php from the folder, further I've edited the register.php and deleted the referrs to RECAPTCHA aswell. I don't know if this is still secure enough though. Later on, I would like to change it to a variable again, not with the RECAPTCHA but with something like "What is the current server time" or something like that. Does anyone of you know how that should be done, and if that even could be done?

Thanks!

PS: Are there some serious security problems that could happen now I don't use a variable in the security questions?

well, current time is kind've hard, as it usually takes seconds as well.
You could ofcourse create a different question, like
What job does Obama have?

then you can do like
if ($answer == 'president') {
//something here

}else{
die('text here to die');
}

I've done the thing you say with "What job does obama have" but then with "What is 2+3?" and set the answer, that justs works fine now.

If I want to have more then 1 question like, 2+3/10-5/7+3 (just like 4 or 5 of them) so it shuffles, one time it's 2+3 other time its 3+2 but not directly in the same order, so they can't bot it(if they can). Would this be hard, or can it easily be done in just the register.view.php?

In my eyes only 1 security question with only 1 answer can be easily botted, couldn't it?

Thanks :D

You could create a database with the questions in it.
Just make a table with the rows ID,Question,Answer
Then use MySQL to take them from the database with a certain ID.
then place something like
<?php
$RandomID = rand(1, 20); //Chooses random number between 1 and 20
?>
Then inside the query to take them from database, put something like
$query = mysql_query("SELECT Question, Answer FROM questions WHERE ID = '\'$RandomID\''")
and then display the question and check the answer for it :)
something like that,
hope you can use this ;)

Hello again,

Well, we got another problem. I am now trying to set the registry files on my website, and it works if I'm trying to create an account on the host PC, it creates a nice account in the database and everything works like a charm on the host PC...
The registry page works on the host PC if I do $dbHost = '127.0.0.1' and if I use the IPv4 it works on the Host PC aswell.
But when I go to my own PC (the not-hosting PC) and go to the registry page, it still gives the layout and such, but when I press "Create Account" it referrs me to the Webs.com site that's saying "Sorry this page was not found"

Is it that I have XAMPP on the localhost, or that the database is on the localhost?
Or might it be a problem in one of the .php files?
When I use the IP address from whatsmyip.org in the dbconfig.php it doesn't even work at all.

BTW:
The DB is connected to 127.0.0.1, might that be the problem why it only succeeds if I'm on the host PC? If yes, what do I have to do to get this fixed?

Thanks in Advance!

Look,
If your database is on the same PC as the register script, 127.0.0.1 is fine.
You'll just have to change the script itsself. It probably uses a file using [Only registered and activated users can see links. Click Here To Register...].
Change that to you public IP and it should work.