Finally!!! (updated)

ADMIN,
YOU ROCK! I appreciate all of the hard work on the software. Keep up the good work and Happy New Year!!!!

Sergy,

Great news! You list many new features I have been looking for, or creating workarounds to accomplish. Thank you so much for your hard work on an excellent product.

Roy

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7256&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

Hapy new year.
This is good news. I bought PHPRunner in Nov. I hope we will be elegible for an upgade. If we install this new beta version will it run in demo mode ?
Rgds,
Simon

Beta version requires new registration key.

New registration keys will be sent to all customers who purchased less than 12 months ago. We'll send keys in couple of days.

This looks Really really good i am busy working with PHPRunner at the moment and this update has come at just the right time keep up the excellent work PHPRunner is the best software i have ever purchased online
Regards

for 2006

David

thank you and a happy new year everbody
Nir Pengas

Thanks just what we have been waiting for!

Serg,
I've just downladed version 3.0 (Build65) and have been trying to add a new table to my database with no success, I get an XML error box
Title" Error creating table"

<?xml version="1.0" standalone="yes"?>

The table was not created
If I create an additional table directly in mysql - PHRunner does see the new table.

Hi,
thank you for pointing me to this issue.
Please try out the current PHPRunner 3.0 (build 80).

The previous version didn't create tables when in "connect using PHP" mode.

Hi,

I uploaded build 80 and it looks great now, I've added tables and deleted them successfully. This is a grat addition, now a natural evolution would be a capability to populate the table from a csv file from the phprunner interface.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7520&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> Nice additions, I continue testing

Hi is it possible to get an upgrade key please?

Sure, drop a note to support@xlinesoft.com showing your order number so I can locate your info in the database.

Hello,
We are now ready to upgrade to PHPRunner 3.x, we do not want to lose our current settings for version 2.x, do we install over the old settings or what do we do?
We had made changes to our source files and want the changes to move to 3.x.
Please advise us.
Rgds,
Simon

I am using 3.0 (build 86) and seems to have problem with setting different Security mapping for diffrent tables using "users can see and edit their own data only".
First I set one table to one value example "username" then and go to another table and set that to another value example "RepID". When I go back to first table it now show "repId" when i want to keep "username".
Is this the way by design ??

Hi,
Field Users Table: OwnerID Field in Advanced Security Settings is the same for all tables. Therefore when you set one table to one value, then the same fields in other tables take on this value.
If these settings aren't approach, please describe your task so that we solve this problem.

Hello,
Source files version 2.x aren't compatible with Source files version 3.x. Therefore all changes will be lost.

Which current settings are you talking about?

Hi,

Kind of confusing.. The advanced security setting screen includes a "current Table" combo-box and kind of applies that setting is only for that table.
This is my task:
I have one user table that include fields such as username, group name , custnum (customer) and Repid (sales Rep).
Based on the users login:

1. The group shows only certain "tables".. Customer tables , rep tables , user tables work great
   
2. Certain tables shows certain data based on login.. So when a "customer" user login and filter only a their data. when "repid" logs in their data should show.
   I could certainly do a workaorund to first build the app with a certain setting, then change to new setting and only upload code that change. "but not pretty"
   Need more info..
   Pontus
   Pontus

Hi,
I recommend you to create two PHPRunner projects: one for customers and one for salesRep and set Advanced Security Settings in compliance with your requirements. Then build projects and put them in separate directories on your server.

Will post here for now but if no reply will create a fresh one as I'm not sure this is best place to ask.
I've been using PHPrunner 2.x for a while and I tried something that didn't work then that I'm hoping will work now!
Basically, I have say 3 tables - order_header, order_details and product_details. As product code only is stored on order_details table I wanted to manually change the SQL for the order_details table to join to the product_details table to get product_description and maybe a couple of other things.
In v2.x this displayed info correctly but then fell over when updating details.
My question is, was this sorted in v 3.0 as I don't want to go to the trouble of trying it all out to then find it doesn't!
Finally, I also used to use your excellent DBtoHTMLExpress product. In that product you could put database column name tags into the comment lines of an html template and then the program linked to a database like Access and created a load of html pages - real cool for my affiliate sites I used to run! Anyway, I was wondering what the chances are of doing something similar for PHPRunner? It would be great to be able to create a html template with databbase col tags in html comments and then for PHP Runner to use these templates for determining how to display the user front end?
What's the chances of that being done as this would really put PHPRunner well above the crowd!
Thanks

You didn't tell anything about your problem. The following doesn't make any sense to me.

In v2.x this displayed info correctly but then fell over when updating details.

You can similar things with PHPRunner you did with DBtoHTML Express. Version 3.0 comes with Template Editor which you can use to insert code snippets any place you want. Some PHP knowledge is required though.

Hi, the problem I had in v2.0 was that if I amended the SQL manually on the master record so that it linked to a different table to display information from that table it worked well in list, view.
However, searching threw up "amibgious column in WHERE clause" and when I drilled down into child details I got "Column: xyz in where clause is ambiguous". It seems it remembers the the table in the SELECT but forgot to reference it in the WHERE bit.
You then gave me a manual mod which used aliasing for the list.php as you said it would be fixed in next version (this is back in Sept). I did the mod and it worked great in list mode but then failed in edit mode due to it not recognising the aliases used. You then said that "We'll add as full as possible support for joined fields in the next PHPRunner release"
Just wondering if you have managed to put in full (as possible) support for joined fields in this new version of PHPRunner. If you have, great, I will go and amend the 15 projects I have that manage my back office wonderfully. If not, then not to worry - still a great product!
Lastly, is there any documentation on this Template Editor? Could I make it so that there was 1 record per page and each field was laid out as I wanted it to be or would it still need to be in a list with either horizontal or vertical layout?
Thanks

Hi,
PHPRunner 3.0 has almost full support for joined and calculated tables, but you need to apply some modifications to generated pages to get them working. please find GetFullFieldName function in include/dbcommon.php file.
For example, there is query:
select

table1.id,

table1.name,

table2.name as name2,

table1.quantity * table2.price as totalcost

from table1 inner join table2 on table2.id=table1.id
Locate this line there:

if("table1"==$table && $field=="name2") return "table1.name2";

and replace it with:

if("table1"==$table && $field=="name2") return "table2.name";

Then repeat this for the rest of joined fields.
We'll add description of those action to HELP for PHPRUnner 3.0.

Thanks!

Hello,
We just created a view of a table on our DB and realised that the search does not work.
We get the following when we try to search:
Technical information

Error type 256

Error description 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 'like upper('%open%'))' at line 1

URL 192.168.0.10/temp/supportlogclosure_list.php?a=search&value=1&SearchField=15&SearchOption=Contains&SearchFor=open

Error file /opt/lampp/htdocs/temp/include/dbconnection.php

Error line 26

SQL query select `supportlog_id`, `supportlog`.`customer_id`, `customer`.`name`, `staff_id`, `calldate`, `browsertype_id`, `emailtype_id`, `ostype_id`, `supportcategory_id`, `calldescription`, `callstatus`, `callsolution`, `callclosedate`, CASE WHEN `callclosedate` IS NULL THEN datediff(CURDATE(),`calldate`) ELSE datediff(`callclosedate`,`calldate`) END `callage`, `callpriority`, `supportlog_status` From `supportlog`, `customer` Where (`supportlog`.`customer_id` = `customer`.`customer_id` AND `supportlog_status` = 'Open') and ( like upper('%open%')) ORDER BY `calldate` ASC
Thanks in advance for your help.

Defcon2000,
if you are a registered PHPRunner customer send to support@xlinesoft.com your PHP files, along with database dump and project file for investigation.