Discussion on [RELEASE] Secure PHP Web Registration Script within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.
error log:
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_mssql.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_oci8.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pdo_mssql.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pdo_oci.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pdo_oci8.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pdo_pgsql.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pdo_sqlite_external.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pgsql.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_pspell.dll' - The specified module could not be found.
in Unknown on line 0
[04-Jul-2011 01:56:23] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_sybase_ct.dll' - The specified module could not be found.
in Unknown on line 0
and they are enabled..
i use iss 7.5 windows server 2008r2 sql 2008r2
what can i do please? this is making me go insane soon..
I see you posted the error messages, but you didn't mention if those files exist at the path where it is looking for them?
i have had 3 that has working php in there server looking at it. i have tried to change PHP. PHP path from just C:/ to installing the PHP.exe on auto path.
changed 127.0.0.1 to local ip and i have added ,1433 for port.
only i now havend tried is running obdc connect instedd os mssql connect.
when i install xwamp the server will not start or go online so i can add what need to be added.
i have tried turning off all security i can find just to check.
now i don't know what to try next..
one new i tried running sreg. so i don't have to manyaly put in all the stuff in sql. but when i try to use that i get an error.
can not insert when Users_master when IDENTY_INSERT is set off. but i have used this:
SET IDENTITY_INSERT tableName ON Users_Master yes. and it said updates one row. and still i get this. could this be the error?
info about the error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Data.SqlClient.SqlException: Cannot insert explicit value for identity column in table 'Users_Master' when IDENTITY_INSERT is set to OFF.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at WindowsApplication1.Form1.button2_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
It sounds like you have the UserUID column set to identity, but you are also trying to tell it what the UserUID is. Basically you told the database you wanted it to keep track of incrementing UserUID, but then you are trying to force you own UserUID on it, which it doesn't like.
Make sure you turn the SET IDENTITY_INSERT on Users_Master back to off. Then you will want to make a modification to your registration script's insert query to no longer try to insert a UserUID, like below:
So instead of doing something like this example:
Code:
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw)
VALUES(2,'bubba','bubba1')
You want to do something like this example:
Code:
INSERT INTO PS_UserData.dbo.Users_Master
(UserID, Pw)
VALUES('bubba','bubba1')
It sounds like you have the UserUID column set to identity, but you are also trying to tell it what the UserUID is. Basically you told the database you wanted it to keep track of incrementing UserUID, but then you are trying to force you own UserUID on it, which it doesn't like.
Make sure you turn the SET IDENTITY_INSERT on Users_Master back to off. Then you will want to make a modification to your registration script's insert query to no longer try to insert a UserUID, like below:
So instead of doing something like this example:
Code:
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw)
VALUES(2,'bubba','bubba1')
You want to do something like this example:
Code:
INSERT INTO PS_UserData.dbo.Users_Master
(UserID, Pw)
VALUES('bubba','bubba1')
i am using your webregister files. have problems there too. gave this becouse it mabe help you see the problem. but yours using userid?
I don't understand what you are saying. You are getting this error yes?
Are you getting that error with my registration files? I assumed you modified them because this is the query from the registration files:
Code:
$sql = "INSERT INTO PS_UserData.dbo.Users_Master
(UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,EnPassword,UserIp)
VALUES ('{$username}','{$password}',GETDATE(),0,0,0,0,0,GETDATE(),'N',0,'','{$user_ip}')";
Which it does not try to insert UserUID.
It is not clear to me in what specific situation you are getting the error.
no he he i used a program that's called sreg. attached. this is givving me this error. but normaly i try to use yours and i get the:
You must have the php_mssql library for Apache installed and enabled to connect to an MSSQL database. Uncomment the line that says extension=php_mssql.dll in your php.ini (XAMPP/WAMP only). This requires a restart of the Apache service to take effect.
User Name
when i try to type in the username from a website.
but this is a workaround so i don't have to manualy type in all the stuff with data joined, and so on and so on. untill i get the register to work..
i asked for help with my register in a register dev selection under the place i have files from. i just gave you all of this in this so you might understand what my prob is.
if you look in any of the dev relese there is questions about how to make it work.
i just added this becouse yes i don't understand much about php. and i have tried about all i can. but if you could help with what i can try or something like that, and not just have fun that i'm not as good as you that would be great ty.
i am running stuff just to try and get errors you and me can understand or you can tell me. so we can isolate the problem.
i don't have apache installed. do i need to? like i have said alot of times now i have iss 7.5 with php manager installed. sql 2008r2
all of my ext are installed.
but the thing is. i have tried alot. and this is not what i'm going to use. i'm not letting this file go out on my website. just something i was trying for my self.
if you get 1 error and none can or will help you. i have to try even more to get errors you or my self can understand so i can isolate the real problem, and yes i did everything abrasive's said exept xampp ? becouse i asked and there was no need for 2. so i skipted that part. i del the first row in the userdata so i just have 1 UserUid is the first i have and not rowid like it was. and i have set the auto-increment to it.
if you could point me to the right dir of what i can try next that would be great. and not just trying to call me a moron and a noob. we all now i'm one. don't need to put that in every post now. we know.. or the complete pvper's know. that i even have a server is insane yes i know and all that.
what is this code?
when i go in the error loggs i get that some dll.s that can't be found..
C:\PHP\ext\php5apache.dll' - The specified module could not be found.
in Unknown on line 0
if you look in any of the dev relese there is questions about how to make it work.
Well, those questions are there, and they did help to make those guides better, yet, they still are on wrong section....
Quote:
Originally Posted by Svinseladden
what is this code?
when i go in the error loggs i get that some dll.s that can't be found..
C:\PHP\ext\php5apache.dll' - The specified module could not be found.
in Unknown on line 0
and 10 others. but i have all in that dir.
That is telling you that you don't have that specific .dll file, if you have it somewhere else just copy/paste it on that directory that it is telling you, but it seems like you are just missing that file....and the 10 other files that you mentioned there
Well, those questions are there, and they did help to make those guides better, yet, they still are on wrong section....
That is telling you that you don't have that specific .dll file, if you have it somewhere else just copy/paste it on that directory that it is telling you, but it seems like you are just missing that file....and the 10 other files that you mentioned there
i ahve all of the dll file that's what i don't get.:-( i have them in that dir but they keep saying they are not there..
i have manualy search'ed for them and they are all there..
well new installing of PHP + alot of googeling. i'm now at this:
[05-Jul-2011 15:28:12] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\config.php on line 6
[05-Jul-2011 15:28:40] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\config.php on line 6
[05-Jul-2011 15:31:24] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\pvp-rank.php on line 10
[05-Jul-2011 15:46:11] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\Whoisonline.php on line 6
line 6 is then the mssql_connect. so the connection for the sql. but i have the connections above.
like this:
<?php
//User defined variables
$host = "127.0.0.1"; //Database Host. (IP to DB)
$user = "Shaiya"; //Database Username
$pass = "shaiya123"; //Database Password
$link = mssql_connect($host,$user,$pass) or die('Connection Error.');
(yes i have changed my password he he so try connection if you want)
this is one of them. the config file : [05-Jul-2011 15:28:12] PHP Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\config.php on line 6
is there any idea to just try and input the ip user and password in after mssql_connect?
My remark regarding the choice to post in this thread or in a new one was mostly for me - I do prefer clean threads for releases, and quick & dirty but throwable thread for specific (and time limited) issue, but this is *my* preference only, I didn't say I'm right.
that said. my list of questions wasn't there to overwhelm you but really to try to understand the issue since there are several contradictory points.
you're right to explain what you tried (and readers will expect that indeed you did some tries) but please do not try all and every things, a collection of failures is not that helpful.
<<i don't have apache installed. do i need to? like i have said alot of times now i have iss 7.5 with php manager installed. sql 2008r2>>
ok, it wasn't that clear (neither) because of the previous statement: <<You must have the php_mssql library for Apache installed ...>>.
so if you're using IIS (Internet Information Services, not ISS), you shall use the PHP preprocessor compiled with VC9 - yeah who give a sheet about the used compiler, the issue comes from the runtime of the MS compilers; simply consider that this version is the right one.
* installation of PHP over IIS 7+
I won't copy all details, the full installation is
- note you will need the or the w/o install if you prefer. and optionally the
I just re-install the whole thing (IIS 5.1 & PHP 5.3.6) from scratch on my XP (I'm using Apache of course) and it requires 5 mn.
Of course, you must test the IIS svr with a dummy index.html page to be sure it works after activating the w3svc service and test the PHP ISAPI module with a dummy index.php file.
Only point that may cause error (on IIS 5.1, not sure about 7) is the "cgi.force_redirect flag in php.ini (it must be set to 0 as indicated in the install page).
* access to MSSQL server
and to MSSQL only ... your previous post listed OCixxx file (for Oracle), sqlite (for SQLite) etc, etc, let focus and what you wanna acheive instead of adding useless stuff, if errors still occur at least they will be relevant for what you are trying to do.
w/o rewriting the full story, accessing to MSSQL (and to MySQL too for some aspects) has always been paintfull because of incomplete package (due to no redistribuable libs or other details).
the good news is that M$ itself does provide an efficient native client to connect to the SQL svr, and this time it's a fully functional package (no missing libs, no boring (.net) overhead)).
and .
Execute the downloaded .exe and give the "ext" folder of your PHP install when it prompts you for the target directory.
It copies several files named: php_pdo_sqlsrv_5?_[n]ts_vc?.dll in this folder. There is also a "SQLSRV_Help.chm" file that you will want to put in the middle of your desktop.
So, summary of previous points: we have install PHP 5.*3* and we run IIS (so VC*9*), and we prefer a thread safe ('ts') module, the only module that needed to be loaded thru php.ini is so: php_sqlsrv_53_ts_vc9.dll
in the "Dynamic Extensions" section add:
extension=php_sqlsrv_53_ts_vc9.dll
let all other modules commented - you don't need them.
(php_gd2.dll & php_curl.dll can also be useful but they aren't DB-modules solet forget them right now).
you can also define the full path of your ext directory with the "extension_dir" directive, set it for better reliability, it's suppose to use "./ext" as default, but a guaranty is better.
so, full php.ini settings are:
Code:
[PHP]
;;;;;;;;;;;;;;;;;;;;
; Language Options ;
;;;;;;;;;;;;;;;;;;;;
engine = On
short_open_tag = On
asp_tags = Off
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
doc_root =
user_dir =
extension_dir ="D:\net\php\5.3.6\ext"
cgi.force_redirect = 0
cgi.fix_pathinfo=1
fastcgi.impersonate = 1;
fastcgi.logging = 0
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
extension=php_sqlsrv_53_ts_vc9.dll
(all other options / directives left with their default values)
3 additional mn spent on that install.
* connect to MSSQL
restart IIS to make sure it reloads PHP with the new settings and test dummy connection:
IIS-based php/mssql server fully functional is less than 10 mn. (functional, i didn't say useful).
Edit: M$SQL 2008 R2 was already installed on the machine - with all dev modules including the support of the native driver - may be you can miss some files at this point (depending of your SQL2k8 install), if it's the case, restart the install wizard & add those modules (mainly the "native driver support").
* checking libs
if at one point, you have a "Unable to load dynamic library 'foo.dll'" message; as indicated in my previous post, when a lib failed to load, it is *not* in 99% of cases because it isn't present in the given directory - "i have manualy search'ed for them and they are all there." is a bad response (unless you deliberately do stupid things of course)
but it's because the lib relies on other libs that can not be found in the scanned dir. (system, env. path, ...)
so , download it, unzip in your \dev\bin\tools favorite folder and drag the lib that refuses to load on it, you will know which (other) dll is missing, then u will google it or check your install to figure out a mispelled directory name or config file.
[Release] SSE php Registration page script! 06/25/2013 - SRO PServer Guides & Releases - 38 Replies Hello there, i'm not much using this forum, but as i recently helped out the owners of server G-Sro by making this automatic account registration page, decided to release for everyone. Hope you like it.
For live preview go to:
Demo Page
DOWNLOAD LINK: http://www.multiupload.com/65ZMM3N7C0
Feel free to edit it however you want, but don't re-release it on other communities.
Features:
[Release] Secure BHop Script 08/08/2010 - Counter-Strike Hacks, Bots, Cheats & Exploits - 5 Replies You can't get banned for using this Script because it's only presses the Space button = no injection into the game = No VAC Ban + it's secured.
Btw it's an Private BHop script so when you leech it please give the credits.
Info: How to use
press "^" to start and "^" to stop
Virus Scan:
[Release] Simple CoEmu V2 - Registration Script 03/07/2010 - CO2 PServer Guides & Releases - 39 Replies http://i42.tinypic.com/1qlcnd.png
Download
Simply open settings.php and edit it to your settings, and it'll run smoothly.
[RELEASE]Registration Script (ENG) 05/16/2009 - Dekaron Private Server - 12 Replies I just created this registration script so enjoy. Unlike the others that are posted around, this one is built from the ground up by me. Enjoy and dont forget to say thanks! Uses mssql();
Please post your comments and suggestions!!!! Ill have more tools on the way.
~Quick tut to get it working~
1. Download the rar
2. Extract it to a place where you can easily edit the files
3. Open up includes/db.php
4. Edit your information for your SQL server
5. Save and upload to a directory inside...
![[RELEASE] Secure PHP Web Registration Script](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-guides-releases/release-secure-php-web-registration-script_ltr.gif){kind=small}
