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

Nope

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

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

I guess it's not my day. I copied and pasted your suggestion into my code and it failed to show the variable

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