To all Tantra newbie developers I think you might like this

hi again TantraNewbie, the correct code was <?php phpinfo(); ?>
save it as index.php of which the screenshot you posted displays the php configuration. however, i need to see if there is a MSSQL part on the displayed. or try to search that in your display. something like this:

mssql

MSSQL Support	enabled
Active Persistent Links	0
Active Links	0
Library version	7.0

and if not. then you need to setup MSSQL. or you have to re-install it. use my link in the first page so that you would not have much to configure and it is not atrial version.

for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

.

Quote:

---

Originally Posted by TantraNewbie

PHP is on Xampp not on the MSSQL Server where I have a problem with :*: Just finish first all the things on Sir Terror's guide before asking for PHP you will confuse yourself more....

---

Bro, can you give me a screenshot on where should I locate and edit this particular php connections in XAMPP (step 6 on Sir Terror's Guide)? Thanks in advance.

Also, I can see that you message me but somehow for some reason I can't access the private message page of Ragezone. Can you just post your PM here please.

Ciao!

- - - Updated - - -

Quote:

---

Originally Posted by Terrified

for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

.

---

..but I can still use this right? During the installation it says Evaluation (default) which I think will run free for at least 180 days.

Quote:

---

Originally Posted by Terrified

hi again TantraNewbie, the correct code was <?php phpinfo(); ?>
save it as index.php of which the screenshot you posted displays the php configuration. however, i need to see if there is a MSSQL part on the displayed. or try to search that in your display. something like this:

mssql

MSSQL Support	enabled
Active Persistent Links	0
Active Links	0
Library version	7.0

and if not. then you need to setup MSSQL. or you have to re-install it. use my link in the first page so that you would not have much to configure and it is not atrial version.

for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

.

---

Thank you very much Sir for that info . Yes Sir I follow the set up which you posted in on page 1 here my SS
[IMG]http://i1273.photobucket.com/albums/...ps517c5bd6.png[/IMG]

I also set up my ODBC, User DNS and System DNS on this manner I set up it with login ID and password here some SS
[IMG]http://i1273.photobucket.com/albums/...psd87fd705.png[/IMG]
-
I didn't found the mssql support Sir but I found this
http://i1273.photobucket.com/albums/...pscde4ad39.png[/IMG]

I dont know but I think this is because of the new Xampp. Which they change the extension=php_mssql.dll to extension=php_sqlsrv and the extension=php_mssql.dll is no longer supported.

[IMG]http://i1273.photobucket.com/albums/...ps60530713.png[/IMG]

When I open to PHP/ext/ the dll the extension php_mssql.dll is not there..
[IMG]http://i1273.photobucket.com/albums/...ps207d49bf.png[/IMG]

But I found this the dll extension that I downloded from driver 3.0
[IMG]http://i1273.photobucket.com/albums/...psc75c01c7.png[/IMG]

And Sir I have this error whenever I will get the";" in the php.ini
[IMG]http://i1273.photobucket.com/albums/...psb6281d47.png[/IMG]

I dont know If im correct but I think this is because the php_mssql.dll is no longer located in "etc". and its no longer supported with new Xampp..

I do hope Sir all my SS here could solve my problem... I really appreciate if you can help me.. Thanks in advance..

Really appreciate if someone could help me in STEP 6. I have now my MSSQL working and XAMPP working now. I just need to proceed to the next steps of this tutorial.

http://i.imgur.com/XCtnBhJ.png

Tested also with this code..

<?php
$test = mssql_connect('HERO\SQL2012','MYU','MYPW')
or die('Something went wrong while connecting to MSSQL');

if ($test) echo "Connection Success!";
else echo "Connection Failed!";

?>

http://i.imgur.com/B0z8zHg.png

..but just don't know what file to use in STEP 6.

Sorry if I am whining. I am just a beginner with this stuff but for the love of the game I willing to learn.

Quote:

---

Originally Posted by Terrified

hi again TantraNewbie, the correct code was <?php phpinfo(); ?>
save it as index.php of which the screenshot you posted displays the php configuration. however, i need to see if there is a MSSQL part on the displayed. or try to search that in your display. something like this:

mssql

MSSQL Support	enabled
Active Persistent Links	0
Active Links	0
Library version	7.0

and if not. then you need to setup MSSQL. or you have to re-install it. use my link in the first page so that you would not have much to configure and it is not atrial version.

for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

.

---

Sir Thank very much for all the info I manage to solve the MSSQL Server problem but when I try to register this things happen..

[IMG]http://i1273.photobucket.com/albums/...psdeb27641.png[/IMG]
[/IMG]

I have this thought may the problem now is my DB .I use the fix data base with pher1433 post since its bak file I try to restore it by overwriting on the DB..Problem after another :*: but I will not give up with your help I know i can run my on server hopefully. I more thing when I run the client using a batch file I end with this..
[IMG]http://i1273.photobucket.com/albums/...pse451ad1a.png[/IMG]


I got of ???? I hope you can help me with this other problem that i have..Thanks in Advance.. regards

sir where i can find the php.ini file?

Quote:

---

Originally Posted by dkhauz22

sir where i can find the php.ini file?

---

You can find it @ C:/xampp/php/

congratz guys! you are doing it! GM Terror can you teach me regarding the 3 skillbar K4? I don't like the K6. It has no editor for HTSSetting

Quote:

---

Originally Posted by KyleMarvin

congratz guys! you are doing it! GM Terror can you teach me regarding the 3 skillbar K4? I don't like the K6. It has no editor for HTSSetting

---

Warning: mssql_query() [function.mssql-query]: message: Column name or number of supplied values does not match table definition. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'userId', table 'billcrux_phil.dbo.tblUser'; column does not allow nulls. INSERT fails. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 169


Sir Kyle I have seen your post and I encounter the same problem too.I've try everything but still it does not work.would you please be kind to share how you change the code in register.php "$sql "INSERT INTO " please help me Sir Kyle regards

I created this config.php

with this code:

Quote:

---

<?php

$host = 'GMKYLE\SQLEXPRESS';
$user = 'sa';
$pass = 'passwordbutyoucantedit';
$db = 'UserLogin';

?>

---

Then the login.php

Quote:

---

<?php
require '../config.php';

$user_id = $_GET['user_id'];
$user_pass = $_GET['user_pass'];

$conn = mssql_pconnect($host,$user,$pass);
mssql_select_db($db,$conn);

$sql = "SELECT * FROM Account WITH (NOLOCK) WHERE UserId = '$user_id' AND Activated = 1";
$res = mssql_query($sql,$conn);

$sql = "SELECT isUserCreated,Password,ID,UserKey,Email,BlockedEndDate FROM Account WITH (NOLOCK) WHERE UserId = '$user_id'";
$r2 = mssql_query($sql);
$userPass = mssql_result($r2,0,1);
$ID = mssql_result($r2,0,2);
$userKey = mssql_result($r2,0,3);
$email = mssql_result($r2,0,4);
$sql = "SELECT DATEDIFF(day, getdate(), BlockedEndDate) FROM Account WITH (NOLOCK) WHERE UserId = '$user_id'";
$r3 = mssql_query($sql);
if (mssql_result($r3,0,0) >= 0);
$sql = "UPDATE Account SET Blocked = 0 WHERE UserId = '$user_id'";
mssql_query($sql);
$result = 0;
$result = mssql_result($r2,0,0);
mssql_close($conn);

if (($result == -100) || ($result == -99))
{
echo '2';
die();
}

$user_pass_ok = strtolower($userPass);
//echo $user_pass_ok."<br>";
$user_pass_ok = "@".substr($user_pass_ok,0,1)."^".substr($user_pass_ok,1);
//echo $user_pass_ok."<br>";
$user_pass_ok = md5($user_pass_ok);
//echo $user_pass_ok."<br>";

if ($user_pass != $user_pass_ok)
{
echo '1';
die();
}


echo '0';

$AccDir = "V:\TServer\DBSRV\account";
$password2 = strtolower(md5(strtolower($userPass)));
$ini=substr($user_id,0,1);

if (ereg("^[a-zA-Z]$",$ini)) {
$initial=strtoupper($ini);
}
else
{
$initial="etc";
}


$f=@fopen($AccDir."\\".$initial."\\".$user_id.".TAD",r) or die("Error");
$acc = @fread($f,7124);
$demopass=substr($acc,52,32);
$acc = str_replace($demopass,$password2,$acc);
$f2=@fopen($AccDir."\\".$initial."\\".$user_id.".TAD",w);
@fwrite($f2,$acc) or die("Error");
@fclose($f);

?>

---

Hope you could understand it. it is how I made the login account.

Quote:

---

Originally Posted by TantraNewbie

Warning: mssql_query() [function.mssql-query]: message: Column name or number of supplied values does not match table definition. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'userId', table 'billcrux_phil.dbo.tblUser'; column does not allow nulls. INSERT fails. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 169


Sir I have seen your post and I encounter the same problem too.I've try everything but still it does not work.would you please be kind to share how you change the code in register.php "$sql "INSERT INTO " please help me Sir regards

---

Quote:

---

Originally Posted by KyleMarvin

I created this config.php

with this code:

Then the login.php



Hope you could understand it. it is how I made the login account.

---

Thank you very much Sir I will dig to script I have now a lead :laugh: how you made it work...

- - - Updated - - -




Sir Kyle I'm to excited to test if the script is working but I have not read it thoroughly I have no problem in login Sir its working very fine but on the register.php script I try to use your script but still may register.php wont work..I can you share your register php script Sir that solve your problem please. Regards

@Terrified

After trying things out I came up with this kind of error of which I don't have knowledge about.

http://i.imgur.com/RgnDSrA.png

Appreciate your inputs.

Ciao!

Quote:

---

Originally Posted by elitegeek

@Terrified

After trying things out I came up with this kind of error of which I don't have knowledge about.

http://i.imgur.com/RgnDSrA.png

Appreciate your inputs.

Ciao!

---

The warning is telling you that certain Tables/Fields (in this case Account) you reference in your query are either invalid or don't exist. Could be several thing:

Check if you are connected to the right server/database
Check if the data are u inserting is a correct value respect the column
Some quote is missing
other

Try to run the query with a consult on your mssql app, that will give to u a better perspective

and how can i help you with that error?

can you share some and what have you done so far?

Quote:

---

Originally Posted by elitegeek

@Terrified

After trying things out I came up with this kind of error of which I don't have knowledge about.

http://i.imgur.com/RgnDSrA.png

Appreciate your inputs.

Ciao!

---

MG]http://i1273.photobucket.com/albums/...psdeb27641.png[/IMG]
[/IMG]

I have this thought may the problem now is my DB .I use the fix data base with pher1433 post since its bak file I try to restore it by overwriting on the DB..Problem after another :*: but I will not give up with your help I know i can run my on server hopefully. I more thing when I run the client using a batch file I end with this..
[IMG]http://i1273.photobucket.com/albums/...pse451ad1a.png[/I


Im still stuck with these problems.. I hope anyone can help me with these problems..Thanks in Advance.. regards