php_mssql is crashing HTTPD.exe

[foeandfear]

Hello,

as the title says it crashs it

BUT only when im in my panel and try add event item or gift event coins or try add item to donator shop?

I tryed downloading another php_mssql.dll

and i get this

(gift event coins)
Fatal error: Call to undefined function mssql_query() in C:\xampp\htdocs\Panel\darevcoins.php on line 23

(add event item)
Fatal error: Call to undefined function mssql_query() in C:\xampp\htdocs\Panel\additem2.php on line 36

(add item to donator shop)
Fatal error: Call to undefined function mssql_query() in C:\xampp\htdocs\Panel\additem.php on line 36

can someone help me please its stressing me out big time :(

[MentaL]

[Dave]

Did you enable the php_mssql.dll extension in php.ini? (Remove the ; in front of the line and restart Apache.)

[foeandfear]

yeah lol.. and i put short tags On

[Dave]

Make a new .php page and add phpinfo() in it, then open it in the browser.
Check which php.ini is being loaded.

[foeandfear]

System Windows NT WIN11535 6.0 build 6001 (Windows Server 2008 Web Server Edition Service Pack 1) i586
Build Date Nov 20 2009 17:20:57
Compiler MSVC6 (Visual C++ 6.0)
Architecture x86
Configure Command cscript /nologo configure.js "--enable-snapshot-build"
Server API Apache 2.0 Handler
Virtual Directory Support enabled
Configuration File (php.ini) Path no value
Loaded Configuration File C:\xampp\php\php.ini
Scan this dir for additional .ini files (none)
Additional .ini files parsed (none)
PHP API 20090626
PHP Extension 20090626
Zend Extension 220090626
Zend Extension Build API220090626,TS,VC6
PHP Extension Build API20090626,TS,VC6
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
Zend Multibyte Support disabled
IPv6 Support enabled
Registered PHP Streams https, ftps, php, file, glob, data, http, ftp, compress.zlib, compress.bzip2, phar, zip
Registered Stream Socket Transports tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*

i dont see the problem i edited the right php.ini

[Anju]

Don't use XXAMP or WAMP. I prefer AppServ 2.6.0

[foeandfear]

Don't use XXAMP or WAMP. I prefer AppServ 2.6.0

i installed it and i got this

Fatal error: Call to undefined function mssql_query() in C:\AppServ\www\lgownerpanelz29zb\darevcoins.php on line 23


yet ive edited nothing in it and it was working perfectly before on my old vps =/

[Anju]

This could help you, http://forum.ragezone.com/f497/tut-s...ebsite-633375/

[foeandfear]

This could help you, http://forum.ragezone.com/f497/tut-s...ebsite-633375/

Same error :( i have no idea whats causing it..

If anyone can fix this i may Evan be able to pay you! this seriously needs to be fixed!

[Anju]

Please post your darevcoins.php

[foeandfear]

Please post your darevcoins.php

<?php
    if( !ereg("index.php", $_SERVER['PHP_SELF']) )
    {
        header("Location: index.php");
        die();
    }
if (isset($_POST['submit']))
{
    if ($_POST['UserID'] == "")
    {
        msgbox ("Please enter a UserID.","index.php?do=evcoins");
    }
    
    if ($_POST['ECoins'] == "")
    {
        msgbox ("Please enter a ECoins Number.","index.php?do=evcoins");
    }
    
    $ip = ''.($_SERVER['REMOTE_ADDR']);
    $userid = ($_POST['UserID']);
    $dgcoins = ($_POST['ECoins']);

    $result1 = mssql_query("SELECT ECoins FROM Account WHERE UserID = '$useridby'");
    $result2 = mssql_query("SELECT ECoins FROM Account WHERE UserID = '$userid'");

if (mssql_num_rows($result2) == 0)
{
msgbox ("Error, UserID not found.","index.php?do=evcoins");
return;
}
    
    $row1 = mssql_fetch_assoc($result1);
    $row2 = mssql_fetch_assoc($result2);
    
    $coins1 = $row1['ECoins'];
    $coins2 = $row2['ECoins'];
    
    //if ($coins1 < $dgcoins)
    //{
    //    return;
    //}

    $coins1 -= $dgcoins;
    $coins2 += $dgcoins;
    
    mssql_query("UPDATE [Account] SET [ECoins] = $coins1 WHERE UserID = '$useridby'");
    mssql_query("UPDATE [Account] SET [ECoins] = $coins2 WHERE UserID = '$userid'");
    done();
}
else gift();

?>
<?php
function gift()
{
?>
<form name="reg" method="POST" action="index.php?do=evcoins">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
<body bgcolor="#323232">

                    <div align="center">
                        <table border="1" style="border-collapse: collapse" width="461" height="100%">
                                        <tr>
                                          <td colspan="2">Enviar Event Coins (Event Winner) </td>
                                      </tr>
                                        <tr>
                                          <td width="162">&middot;<span lang="es"> User ID<font color="#FF9933">*</font></span></td>
                                          <td width="254"><input type="text" name="UserID" id="UserID"></td>
                                      </tr>
                                        <tr>
                                          <td>&middot;<span lang="es"> ECoins <font color="#FF9933">*</font></span></td>
                                          <td><select size="1" name="ECoins" id="ECoins">
                                                      <option value="10">10 ECoins</option>
                                                      <option value="50" selected>50 ECoins</option>
                                                      <option value="100">100 ECoins</option>
                                                      <option value="150">150 ECoins</option>
                                                      <option value="200">200 ECoins</option>
                                                      <option value="250">250 ECoins</option>
                                                      <option value="300">300 ECoins</option>
                                                      <option value="350">350 ECoins</option>
                                                      <option value="400">400 ECoins</option>
                                                      <option value="450">450 ECoins</option>
                                                      <option value="500">500 ECoins</option>
                                                      <option value="400">2000 ECoins</option>
                                                      <option value="450">3000 ECoins</option>
                                                      <option value="500">5000 ECoins</option>
                                                      <option value="50000">50000 ECoins</option>
                                            </select></td>
                                      </tr>
                                        <tr>
                                          <td colspan="2"><div align="center">
                                            <form name="form1" method="post" action="">
                                              <label>
                                              <input type="submit" name="submit" id="submit" value="Enviar">
                                              </label>
                                            </form>
                                            </div></td>
                                      </tr>
                                    </table>
                    </div>
                    </form>
<?php
}
?>
<?php
function done()
{
msgbox ("Event Coins Has been sent to the user.","index.php?do=evcoins");
?>

<?php
}
?> 
<br />
<br />

[Anju]

You're using IJJI Gunz website made by X-Weaver, right?

<?php 
    if( !ereg("index.php", $_SERVER['PHP_SELF']) ) 
    { 
        header("Location: index.php"); 
        die(); 
    } 
if (isset($_POST['submit'])) 
{ 
    if ($_POST['UserID'] == "") 
    { 
        msgbox ("Please enter a UserID.","index.php?do=evcoins"); 
    } 
     
    if ($_POST['ECoins'] == "") 
    { 
        msgbox ("Please enter a ECoins Number.","index.php?do=evcoins"); 
    } 
     
    $ip = ''.($_SERVER['REMOTE_ADDR']); 
    $userid = ($_POST['UserID']); 
    $dgcoins = ($_POST['ECoins']); 

/////////////////////////////////////////////////////
// Insuficent Coins.
$res2 = mssql_query("SELECT ECoins FROM Account WHERE AID = '".$_SESSION['AID']."'");
$acc = mssql_fetch_assoc($res2);
$result = $acc['ECoins']-$item['CashPrice'];
// Insuficent Coins END.
////////////////////////////////////////////////////    

    $result1 = mssql_query("SELECT ECoins FROM Account WHERE UserID = '$useridby'"); 
    $result2 = mssql_query("SELECT ECoins FROM Account WHERE UserID = '$userid'"); 

if (mssql_num_rows($result2) == 0) 
{ 
msgbox ("Error, UserID not found.","index.php?do=evcoins"); 
return; 
} 
     
    $row1 = mssql_fetch_assoc($result1); 
    $row2 = mssql_fetch_assoc($result2); 
     
    $coins1 = $row1['ECoins']; 
    $coins2 = $row2['ECoins']; 
     
    //if ($coins1 < $dgcoins) 
    //{ 
    //    return; 
    //} 

    $coins1 -= $dgcoins; 
    $coins2 += $dgcoins; 
     
    mssql_query("UPDATE [Account] SET [ECoins] = $coins1 WHERE UserID = '$useridby'"); 
    mssql_query("UPDATE [Account] SET [ECoins] = $coins2 WHERE UserID = '$userid'"); 
    done(); 
} 
else gift(); 

?> 
<?php 
function gift() 
{ 
?> 
<form name="reg" method="POST" action="index.php?do=evcoins"> 
<style type="text/css"> 
<!-- 
.style1 {color: #FF0000} 
--> 
</style> 
<body bgcolor="#323232"> 

                    <div align="center"> 
                        <table border="1" style="border-collapse: collapse" width="461" height="100%"> 
                                        <tr> 
                                          <td colspan="2">Enviar Event Coins (Event Winner) </td> 
                                      </tr> 
                                        <tr> 
                                          <td width="162">&middot;<span lang="es"> User ID<font color="#FF9933">*</font></span></td> 
                                          <td width="254"><input type="text" name="UserID" id="UserID"></td> 
                                      </tr> 
                                        <tr> 
                                          <td>&middot;<span lang="es"> ECoins <font color="#FF9933">*</font></span></td> 
                                          <td><select size="1" name="ECoins" id="ECoins"> 
                                                      <option value="10">10 ECoins</option> 
                                                      <option value="50" selected>50 ECoins</option>
                                                      <option value="100">100 ECoins</option> 
                                                      <option value="150">150 ECoins</option> 
                                                      <option value="200">200 ECoins</option> 
                                                      <option value="250">250 ECoins</option> 
                                                      <option value="300">300 ECoins</option> 
                                                      <option value="350">350 ECoins</option> 
                                                      <option value="400">400 ECoins</option> 
                                                      <option value="450">450 ECoins</option> 
                                                      <option value="500">500 ECoins</option> 
                                                      <option value="400">2000 ECoins</option> 
                                                      <option value="450">3000 ECoins</option> 
                                                      <option value="500">5000 ECoins</option> 
                                                      <option value="50000">50000 ECoins</option> 
                                            </select></td> 
                                      </tr> 
                                        <tr> 
                                          <td colspan="2"><div align="center"> 
                                            <form name="form1" method="post" action=""> 
                                              <label> 
                                              <input type="submit" name="submit" id="submit" value="Enviar"> 
                                              </label> 
                                            </form> 
                                            </div></td> 
                                      </tr> 
                                    </table> 
                    </div> 
                    </form> 
<?php 
} 
?> 
<?php 
function done() 
{ 
msgbox ("Event Coins Has been sent to the user.","index.php?do=evcoins"); 
?> 

<?php 
} 
?>  
<br /> 
<br />