WHM remote accounting. Troubles with 'createacct' function . . .

[Samuell]

Hey Coders!
I have a really strange trouble with this function, and I'm all crazy now to try make it work.

here is the code:

<? 

//import_request_variables("gP"); 

require '/usr/local/cpanel/Cpanel/Accounting.php.inc'; 

$host = "localhost"; 
$dbname = "*****"; 
$table = "******"; 
$link = mysql_connect ($host, "******", "******"); 

$queryext = "SELECT * from $table where (login='$login')"; 
$result = mysql_db_query ($dbname, $queryext, $link); 
while ($row = mysql_fetch_array ($result))  {  $login=$row[login]; $pass=$row[pass]; $dom=$row[domain]; $plan=$row[tarif]  } 

$usessl = 0; 
$whmuser = "*******"; 
$accesshash = '***********'; 

print("Vars: $dom, $login, $pass, $plan"); 

createacct ($host,$whmuser,$accesshash,$usessl,$dom,$login,$pass,$plan); 

?>

when I send from some form all 4 vars - $dom, $login, $pass, $plan, and disable dbquery - all work ok,
but when I send only $login and extract other 3 vars from db whm account don't creates
in both ways 'print' show all 4 vars

Can anybody say what the prob with my code?

Tnks!

[cgraz]

I'm a bit confused on where you're getting $login to run your SQL query? It seem as if login is being pulled from the database after running that query, but $login needs to be set ahead of time or your query wouldn't return anything. I don't see it set in your script above that--is it being passed through the url?

Either way, try this code. It will print out exactly what is happening and you should be able to determine where your error is occuring.

<?php

require '/usr/local/cpanel/Cpanel/Accounting.php.inc';

$host = "localhost";
$dbname = "*****";
$table = "******";
$link = mysql_connect ($host, "******", "******");

// Create Query
$queryext = "SELECT * from $table where login='".$login."'";

// Print Query String to ensure what is being sent to MySQL is what you want
print $queryext . "<br />\n";

// Add mysql_error() to see what the error is, if any, for now.
$result = mysql_db_query ($dbname, $queryext, $link) or die(mysql_error());

// Used mysql_fetch_assoc() rather than mysql_fetch_array() 
// since you are not accessing them numerically
while ($row = mysql_fetch_assoc($result) )  

{  

	$login = $row["login"]; 
	$pass = $row["pass"]; 
	$dom = $row["domain"]; 
	$plan = $row["tarif"]  

}

$usessl = 0;
$whmuser = "*******";
$accesshash = '***********';

// Label each variable before printing so you can see
// Exactly what variables are set and which are not
print "Login " . $login . "<br />\n";
print "Pass " . $pass . "<br />\n";
print "Dom " . $dom . "<br />\n";
print "Plan " . $plan . "<br />\n";


createacct ($host,$whmuser,$accesshash,$usessl,$dom,$login,$pass,$plan);

?>

[Samuell]

nothing help!
'print' show good vars, but whm don't create account

the trouble, I think, with format of extracted from db variables. When I set the same vars inside the code or when I send same vars from html form everything is ok, but when I extract it from db - 'createacct' not work.

But I simply can understand what may be wrong with extracted vars 😕

[cgraz]

Can you copy + paste the outputted query string along with the mysql_error() (if there is one)

[Samuell]

here is a full output -

SELECT * from jhtable where login='murcielago'
Login murcielago
Pass megapas
Dom murcielago.com
Plan jolieh_superhot

[cgraz]

The output seems to be fine. My guess would be there is something odd going on with your function createacct() that is keeping the accounts from being created. Have you error checked that?