elentz
Members-
Posts
228 -
Joined
-
Last visited
Everything posted by elentz
-
I am getting the following error when running an update query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.1.address='10.1.10',account.1.sip_server.2.address='dfgga' WHERE id=1' at line 1 This is the Query: mysql_query("UPDATE global_settings SET account.1.sip_server.1.address='$sipserver1',account.1.sip_server.2.address='$sipserver2' WHERE id=$id") or die(mysql_error()); MySql is version 5.1.73 The variables are being passed from the PHP code and the id is correct. I am at a loss as to what is going on. Thanks for any help
-
It will actually be easier than you imagine. There will be a common "template" that will create all the buttons and the common features of the phone. Each phone cfg file will be identical with the exception of the extension # and a password.. The cfg file will be named with the MAC address of the phone.
-
I am in need of a method to provision VoIP phones. The cfg file I need to create has approx 430 potential entries. I plan on using a php page to enter the info and then use a query to get the info into the DB. The fields I asked about will be static. I have complete control over the server, I am using Centos6, Apache and MySql So is there a limit to the number of fields in a table? I could break up the number of fields into different tables. When all is said and done I need to put it all together and create a file to configure the phone.
-
I have a list of approx 400 new fields I need to create in a new table. They can all be varchar 40 for the most part. I have the list in a csv. I can find all sorts of ways to upload the file as data but nothing to create fields out of the list I have. I am looking for suggestions / solutions on how to get this done. Thanks
-
Thanks Fenway I will check it out
-
Here's what I eventually ended up with. I am sure it isn't pretty from some standpoint, but it works as I need it with one exception, the stime is in GMT and I need to get it to show Eastern. Thanks
-
Thanks for the help. I did get it to work as I wanted
-
Here's what I have tried: But I get this:Warning: date() expects parameter 2 to be long, string given in /home/communiq/public_html/smdr/smdrbytrunk.php on line 81 The alias is the $start isn't it? Thanks
-
I need some help here. I have a query: $sql = "Select stime,direction,Trunk,Source,destination,CallLength from export where Trunk = 'nexVortex'" I use it with BaaGrid. It shows everything I need, with one exception. stime is in Epoch time . So how do I change the query to show Human time instead of Epoch? Thanks alot for any help
-
I have a small company and we send quotes by email to our customers. Some of our products have a feature list of over 100 things that it does. Handing a brochure that shows everything sometimes produces a "Deer in Headlights" reaction. What I am looking for is a system (open source) that will let me list all of those features with an explanation (100 words or less) and from a page select which features I want and create a PDF with just those features within it. That way I can customize a brochure for a specific customer and tailor it to what I think will make them want to purchase. Does anyone have any suggestions as to what I could use? Thanks in Advance!
-
I have a select and an update query that work perfectly if I manually enter the record numbers for cf_565, and id. The fields get updated as they should. as soon as I try to use the variables $cf_565 and $id it fails. I get no error messages. Here is my code $result15 = mysql_query("SELECT vtiger_crmentity.description, vtiger_troubletickets.solution, vtiger_troubletickets.ticketid FROM vtiger_troubletickets Inner Join vtiger_crmentity ON vtiger_troubletickets.ticketid = vtiger_crmentity.crmid WHERE vtiger_troubletickets.ticketid = $cf_565"); $row = mysql_fetch_array($result15); $trouble= $row['description']; $fix =$row['solution']; $sql = "Update communiq_vtcrm1.vtiger_invoice x, communiq_vtcrm1.vtiger_crmentity z Set x.terms_conditions= '$fix' , z.description='$trouble' Where z.crmid = $id and x.invoiceid = $id"; $result = mysql_query($sql); I would also like to use an IF statement to ignore the above code and continue using another variable such as $cf_581 which is a checkbox and it would be true with a 1 Thanks for suggestions where I am going wrong
-
It probably is a real shot in the dark. I don't have any access to the actual pages other than them being available at an IP addy for us to program with. I would have to host a system on my servers that would connect to each of the individual systems. Probably not worth the effort. I put a request into the phone system manufacturer, frankly I am surprised they haven't done some kind or permissions system. Thanks for the chat.
-
I knew I probably wasn't asking it right. There is a phone system that I install that has a web based interface to program it. I cannot change the pages on that system at all. A single administrative login allows anyone to change anything. As an installer I have seen many bad things happen when some users get in there and start poking around. I guess what I am asking for is some kind of "Front End" to this programming interface that would only allow the logged in user to go to certain areas of the program. I would host the pages they use and in the background the output from my pages would connect to the system and automatically manipulate the original pages on the phone system. I guess it would be something like hacking with my own pages. I would need to be able to see what is going on in the original pages. Would it be possible to have a page show another page but to not allow certain areas of the page to be used as a link to a url or vice versa? Sorta like a transparent screen over the page with areas where the original links are not accessable?
-
I have web page that I have full access to the use of, but not anything else(meaning I cannot change the pages). This page and the links and dropdown and such I can use but I cannot change. actually on a phone system. Here is the wierd question. Could a web page be built on a different server that could manipulate pages and show the output of the phone system pages? For example I have pages a, b, c, d, e on the phone system. As an administrator of the phone system I know how and what to do on those pages. For a user I might only want him to access and manipulate pages a,d,e. and all that links within that server and its pages. Is this even possible? Thanks
-
Yeah my wife gives me that only in a look!! ) Anyway, I think I will try on a couple of the files and see what happens Thanks! This just saved me alot of time if it works )
-
That was quick!! I do have a list of the old account numbers and phone numbers that I can put into a mySql table if that is what is needed or it is already in CSV.
-
I have several hundred files that are named in a way that will not work for the way I want to use them. We saved these files with filenames and now we want to change the names. For example the files were named with a 4 digit number. It was an account number for the customer that the file was associated with. Now we use the phone number when we save the file. So now I have several hundred files in the wrong naming convention. I have a list of the customer phone numbers and the account codes. What I am looking for is some way to rename the files using the list to remove the account number and replace it with the phone number. Can someone suggest a method of accomplishing this? Thanks
-
I have a simple update query that I want to run from a php script. The query will work just fine from PHPMyadmin. But it won't update from the code I put into the script. What have I got wrong here? // connect to db $conn = mysql_connect('localhost','couniq','9AXMY') or trigger_error("SQL", E_USER_ERROR); $db = mysql_select_db('communiq_vtcrm1',$conn) or trigger_error("SQL", E_USER_ERROR); //Update Query to do the math for the extended prices of items sold $sql = "Update vtiger_inventoryproductrel SET extlistprice = quantity * listprice"; $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); mysql_close(); Thanks
-
That is exactly what I did and it works perfectly, Thanks!
-
Well, Mark had the right idea, I had BOTh of those numbers formatted. Once I removed that it woked out. But at some point I need to format the numbers. Thanks guys!
-
This is so simple but I can't get it to work. I have two variables: $total $mitax I want to subtract $mitax from $total to get $subtotal Here is what I have: $subtotal= $total - $mitax; I already am outputting $mitax and the $total and the amounts are right. For example $total= 1244.70 and $mitax = 11.70 So the answer should be 1233.00 But I get -10.7 What am I doing wrong? Thanks for looking
-
Is it possible to use a variable inside a function
elentz replied to elentz's topic in PHP Coding Help
I've been to 3 tutorial sites and all the info I can find references the exact opposite as what I want to do. All I found was being able to use what happens inside the Function in code outside said function. So, any others know how to do this? Thanks -
Is it possible to use a variable inside a function
elentz replied to elentz's topic in PHP Coding Help
I guess it's not my day. I copied and pasted your suggestion into my code and it failed to show the variable -
Is it possible to use a variable inside a function
elentz replied to elentz's topic in PHP Coding Help
I will get into functions as soon as I can. I tried your suggestion and added the $proposal where I wanted with no result. I want the field to say Proposal # 1234 But I am either getting Proposal # "$proposalid" or $proposal or nothing at all. Thanks