View Issue Detail

ID	Project	Category	Submitted / Last Updated
00845	UserSpice	Misc	2020-04-08 14:14:28 / 2020-07-22 20:05:52
Reported	Benjamin Groß	Assigned To	Unassigned
Priority	low	Reported	5.0.09
Status	closed fixed	Resolution Version and Commit	5.1.1
Summary	Software-as-a-Service Multi Org SAAS "number of used accounts"
Description	<p>The Script "functions.php" does not give the correct value of available users. </p> <p>I corrected like in Comment "<span style="background-color: #bfe6ff; font-family: monospace;">//Add Value of "used" to returning object"</span>:</p> <p><code>function saasPlanInfo($account_owner){</code></p> <p><code>  global $db;</code></p> <p><code>    $m = $db->query("SELECT id FROM users WHERE account_owner = ?",[$account_owner])->count();</code></p> <p><code>  if($account_owner == 1){</code></p> <p><code>    $p = $db->query("SELECT * FROM us_saas_levels ORDER BY users DESC")->first();</code></p> <p><code>    $p->used = $m;</code></p> <p><code>    return $p;</code></p> <p><code>  }</code></p> <p><code>  $q = $db->query("SELECT level FROM us_saas_orgs WHERE id = ?",[$account_owner]);</code></p> <p><code>  $c = $q->count();</code></p> <p><code>  if($c < 1){return false;}</code></p> <p><code>  $p = $q->first();</code></p> <p><code>  $planQ = $db->query("SELECT * from us_saas_levels WHERE id = ?",[$p->level]);</code></p> <p><code>  $planC = $planQ->count();</code></p> <p><code>  if($planC < 1){return false;}</code></p> <p><code>  $p->used = $m;</code></p> <p><code>  $planQ->first()->used=$p->used; //Add Value of "used" to returning object</code></p> <p><code>  return $planQ->first();</code></p> <p><code>}</code></p>

November 2021

Thanks for this! I need to do a plugin update
November 2021

Thank you for your fix.  SAAS updated to 1.0.1 and I gave you a thanks in a comment in the functions.
November 2021

Thanks! Working on "uedit.php" in view of a few bugs. Will report as soon as I finished!