-
Posts
4,868 -
Joined
-
Last visited
-
Days Won
390
Everything posted by Blesta Addons
-
automated email for a custom service or for all ticket/invoice.. ?
-
yes , creat service without cheking the use module . you need to add the correct username .
-
That is because you have begin the client is from 1500 . and the ID begin from 1 . that's is the difference . in version 2.5 it was the same and it was so easy for all view the client profile from the client id .
-
Proxmox Module - Re-Install Service - Storage Variable
Blesta Addons replied to omaticon's topic in Bugs
i believe proxmox module need a full rewrite . -
i have checked the mine for imported one , is ok .
-
i have noticed that the imported clients from v2.5 , theyhave Clients id Different from thier id , for exemple Client ID 3615 , has the ID 2087 ( the profile client viewed in the url admin/clients/view/2087/ ) also the ID is not incremented ; exemple 3615 -- 2087 3614 -- 2086 3613 -- 2085 3612 -- 1980 3611 -- 2084 3610 -- 2083 the first case , what i have observed , is that blesta ad the ID from 1 and increment it , normally that should begin from the first client ID . the second issue , i have not found any result , may be this is has related to a previos fussion client ( but thos client was not fussioned !! )
-
interesting idea . what about the numbers to call , every country it own number or 1 international number for all ?
-
i have added section to search clients with the same email (duplicated) , and duplicated loginnames.
-
Thanks Fort the share .
-
how do you fix the isseu ? can you share your conf for other users and to add it to blesta wiki .
-
have you tried this config https://github.com/cloudrck/blesta-nginx
-
try to clear the cache .
-
i Got it with other way ,wirth the "str_word_count" , the full code is . public function GetDuplicates($sort_by="email", $order="asc") { $fields = array( "id", "client_id", "contact_type", "first_name","last_name", "email"); $result = $this->Record->select($fields)->from("contacts")-> where("contact_type", "=", "primary")-> order(array($sort_by=>$order))->fetchAll(); // Add emails to a long string $phrases = "" ; for ($i=0; $i<count($result); $i++) { $phrases .= $result[$i]->email ." " ; } $counts = array_count_values(str_word_count($result, 1, '0123456789àáãçéèñ.-_@:?!%')); arsort($counts); return $counts ; }
-
i get printed the query it self PDOStatement Object ( [queryString] => SELECT username FROM users WHERE username in ( SELECT username FROM users GROUP BY username HAVING count(username) > ?) ) the full code is : $sub_query = new Record(); $sql = "SELECT username FROM users WHERE username in ( SELECT username FROM users GROUP BY username HAVING count(username) > ?)"; $results = $sub_query->query($sql, array(1)); print_r($results); just a note, my code was for check duplicate 'username' in users table .
-
how i can write this in Blesta fiendly code $table='users'; $sql="SELECT email FROM $table WHERE email in ( SELECT email FROM $table GROUP BY email HAVING count(email) > 1)"; $result=mysql_query($sql); $n=1; while($row = mysql_fetch_array($result)){ echo '<br />('.$n.')'; echo $row['email']; $n++; }i have tried but not working $match = $this->Record->select("email")->from("users")->group("email"); $this->Record->select("email")->from("users")->where("email", "in", $match)->having(count(email) ,">", "1");
-
[Download Manager] Small Tweak Suggestion
Blesta Addons replied to Michael's topic in Feature Requests
Any idea who will improuve blesta we are with it -
[Merchant Gateway] Pin Payments Australia
Blesta Addons replied to Greg-Mega's topic in The Marketplace
Nice work . -
Have you reinstalled one from the scratch , and test again .
-
+1. @Paul this is added as plugin ?
-
+1
-
what is the content of the CMS plugin ?
-
the SFTP use the SSH port , so it should 22 as default .
-
Verify account registration should be in case of the order is more than xxxx$ . in this case you shoud add a setting to prohibit changing the mobile number in the clients area unless to some moderation or verification manually . also the message should use for some case the clients credit . but, normally , this should for admin use ,.
-
Package Price With Setup Fee Or Without
Blesta Addons replied to Blesta Addons's topic in Feature Requests
This Will server if we want to offer some buydown . let say we have server and we will offer two type of leasing , one with buydown , the cleint will pay the price of some hard that will be removed from the mounthly payment (that serve for long term contract ) 1 - Mounthly price 256$ with 0$ Setup 2 - Mounthly price 156$ with 700$ Setup -
Hello Again yes i know this , but i'm asking for the price overide with out creating two package .