[MOD] Ticket Preview (Javascript Tooltip): Page 2

[MOD] Ticket Preview (Javascript Tooltip)

scottro

Hmm, I'm not able to replicate it still. I've tried FF (3.5 branch) and IE (7.0 Branch). Can you try another browser and see if you get the same thing? Trying to narrow down the issue, but hard to when I never run into the problem first hand ;)

scottro

Code has been updated to strip all special characters and now (for me) all tooltips are showing for all tickets as intended.

See my updated code here:

(http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview/comment-page-1)

kit.tagg

Hi Scottro,

I can see you have also modified the view screen so that instead of date you have age... could you also add custom fields?

Cheers

scottro

Hi Scottro,
I can see you have also modified the view screen so that instead of date you have age... could you also add custom fields?
Cheers

Certainly, what are you looking for?

kit.tagg

Thanks Scottro!

I have two new fields that I've created that I want to see next to 'priority' when I view all of the open tickets. I've had a quick play but I'm definitely a beginner and I don't really know where I'm going..

Cheers

scottro

Thanks Scottro!
I have two new fields that I've created that I want to see next to 'priority' when I view all of the open tickets. I've had a quick play but I'm definitely a beginner and I don't really know where I'm going..
Cheers

Are you saying you've already got the two fields working ok or are you asking for help? If you need help what are the two fields you want to see? What do you want them to do/show?

kit.tagg

The two fields are ones I created myself that reflect different statuses.

I have the two fields working everywhere else correctly (new ticket, edit ticket, etc) but I need help in getting them to show up on the screen when I view all the open tickets, next to department and priority. I dont know where I need to add the code.

I also want them to change boxcolour depending on the value (they're dropdowns when the ticket is inputed), but I'm taking it one step at a time!

Thanks again for any help.

twhayes

Help with Tooltip Mod

I've installed the Tooltip mod, both on my test server and a server at my web hosting service. It works on my test server and I love it, but I can't get it to fully function on the web hosting server. The JS seems to work fine because the gray box that contains the message is displayed. The problem is that it doesn't contain the message. I've been able to debug this down to this portion of the ticket.inc.php file:

$ticket_id=$row;

//echo "ticket_id=".$ticket_id;

$sql_message = mysql_query("SELECT UNIX_TIMESTAMP(created) FROM ost_ticket_message WHERE ticket_id=$ticket_id ORDER BY created DESC LIMIT 1");

//echo "sql_message=".$sql_message;

$message_created_row = mysql_fetch_array($sql_message);

$message_created = $message_created_row;

When I run this with the echo statements uncommented, $ticket_id is fine, but $sql_message never gets populated. I'm using the exact same files on my test server as on the web hosting server. So, it looks like there is some problem with the query to the database.

I don't really have a clue at this point and wondered if anyone has any ideas on why the sql query is failing. Is there some setting on the web hosting server that would prevent this from working? Doesn't seem likely since the rest of the app is working fine.

Any ideas/suggestions would be greatly appreciated. Thanks.

scottro

The SQL you are showing here is the portion that gets when the message was created for comparison to when the response was created (so it know which is the latest and which to show, message or response). The SQL that controls actually grabbing the message or response is:

if( $response_created < $message_created ):

$title = mysql_query("SELECT message FROM ost_ticket_message WHERE ticket_id=$ticket_id AND created=FROM_UNIXTIME($message_created) LIMIT 1");

$lookup = message;

else:

$title = mysql_query("SELECT response FROM ost_ticket_response WHERE ticket_id=$ticket_id AND created=FROM_UNIXTIME($response_created) LIMIT 1");

$lookup = response;

endif;

Do you have all of this in place on your production server?

twhayes

Yes. All of that code is in place, copied from (here).

I've tried to debug with echo statements around most of these calls and when I do, I get blanks. None of the variables are being populated. As I said in previous post, $ticket_id is fine, but after that nothing seems to be getting pulled from the data base. I checked on the production server and the db looks fine. I can browse it using phpMyAdmin and see the appropriate records, etc.

Any other thoughts and many thanks for your help. TW

scottro

Yes. All of that code is in place, copied from (here).
I've tried to debug with echo statements around most of these calls and when I do, I get blanks. None of the variables are being populated. As I said in previous post, $ticket_id is fine, but after that nothing seems to be getting pulled from the data base. I checked on the production server and the db looks fine. I can browse it using phpMyAdmin and see the appropriate records, etc.
Any other thoughts and many thanks for your help. TW

Though I'm not sure this will fix the issue, that is actually older code. The up to date code is on my currently maintained blog here:

http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview(http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview)

What happens if you run an example mysql command for the message grab through phpmyadmin? Does it return with an expected result? I would first update to the current code and if that doesn't fix it then run the command manually from phpmyadmin. From there I would check your mysql logs, if you have access to them and make sure the command is showing up in the logs.

twhayes

Though I'm not sure this will fix the issue, that is actually older code. The up to date code is on my currently maintained blog here:
http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview(http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview)
What happens if you run an example mysql command for the message grab through phpmyadmin? Does it return with an expected result? I would first update to the current code and if that doesn't fix it then run the command manually from phpmyadmin. From there I would check your mysql logs, if you have access to them and make sure the command is showing up in the logs.

Thanks for the suggestions. I was able to run the mysql command in phpmyadmin and it worked. I don't have access to the mysql logs, but I did another complete installation of osticket on the same server and everything worked fine. I think that's a pretty good indication that something was wrong in the database, which was causing the error.

If you don't mind, I've got another question. I'm trying to set up a production and test version of osticket with the intention of being able to migrate the complete test version to production. But, I don't want to migrate the databases. I've searched the forum and found a couple of references to how to migrate, which basically said all I would need to do is change the database info in ost-config.php. I tried doing that with two osticket databases (both were created during osticket installs) and it fails. I also have tried just changing the username and password in ost-config.php. The new user has full privileges on the database. That also cause a fatal error. The login screen won't display. Do you know is there some other file that also needs to be changed? Do you have any experience with migration? One post mentioned that it's just easier to do a re-install, but with several mods that seems inefficient.

Any thoughts/recommendations would be greatly appreciated and thanks for your help on tooltip. As I said, I've got it working on a second install and it's a great mod.

fidel

cool mod, thanks for that, gona save a whole load of clicking.

freddyvangeel

breakline

great mod!

question; how can i add newlines?

i want the preview made up as the original text if possible

tnx; freddy

scottro

great mod!
question; how can i add newlines?
i want the preview made up as the original text if possible
tnx; freddy

I'm not sure what yer asking here. You want additional breaks? ?

scottro

Thanks for the suggestions. I was able to run the mysql command in phpmyadmin and it worked. I don't have access to the mysql logs, but I did another complete installation of osticket on the same server and everything worked fine. I think that's a pretty good indication that something was wrong in the database, which was causing the error.
If you don't mind, I've got another question. I'm trying to set up a production and test version of osticket with the intention of being able to migrate the complete test version to production. But, I don't want to migrate the databases. I've searched the forum and found a couple of references to how to migrate, which basically said all I would need to do is change the database info in ost-config.php. I tried doing that with two osticket databases (both were created during osticket installs) and it fails. I also have tried just changing the username and password in ost-config.php. The new user has full privileges on the database. That also cause a fatal error. The login screen won't display. Do you know is there some other file that also needs to be changed? Do you have any experience with migration? One post mentioned that it's just easier to do a re-install, but with several mods that seems inefficient.
Any thoughts/recommendations would be greatly appreciated and thanks for your help on tooltip. As I said, I've got it working on a second install and it's a great mod.

Sorry twhayes, didn't see your post until today. Hopefully you got your issue sorted but if not just post back here again and I'll take a closer look.

freddyvangeel

No, i would like the message to be as in the ticket.

Now everything is replaced, except a-z and0-9

So the sentences are all messed up

scottro

No, i would like the message to be as in the ticket.
Now everything is replaced, except a-z and0-9
So the sentences are all messed up

Ah ok. The problem with that is that several of the characters that can show up in a ticket can actually break the code for this.

The code for this is:

$MESSAGE = preg_replace("/", ' ', $MESSAGE);

You can toy around with that and see if you have any luck but I eventually gave up and just removed all special characters.

freddyvangeel

sorry for the late response.

i use this;

while ($TITLE = mysql_fetch_assoc($title)) {

$MESSAGE=$TITLE;

}

$MESSAGE = preg_replace("/", ' ', $MESSAGE);

$MESSAGE = str_replace("\r\n","",$MESSAGE);

$MESSAGE = str_replace("","",$MESSAGE);

$MESSAGE = str_replace("

", "", $MESSAGE);

$MESSAGE = substr($MESSAGE,0,300);

but this still does remove newlines and breaks.

so the preview is one long sentence.

newlines are aqually replaced by nothing, so the last word is next to the first of a new sentence...

screenshot.1.png

scottro

sorry for the late response.
i use this;
while ($TITLE = mysql_fetch_assoc($title)) {
$MESSAGE=$TITLE;
}
$MESSAGE = preg_replace("/", ' ', $MESSAGE);
$MESSAGE = str_replace("\r\n","",$MESSAGE);
$MESSAGE = str_replace("","",$MESSAGE);
$MESSAGE = str_replace("
", "", $MESSAGE);
$MESSAGE = substr($MESSAGE,0,300);
but this still does remove newlines and breaks.
so the preview is one long sentence.
newlines are aqually replaced by nothing, so the last word is next to the first of a new sentence...

This is what I'm working with in production right now:

while ($TITLE = mysql_fetch_assoc($title)) {

$MESSAGE=$TITLE;

}

$MESSAGE = preg_replace("/", ' ', $MESSAGE);

$MESSAGE = str_replace("\r\n","<br />",$MESSAGE);

$MESSAGE = str_replace("<br /><br />", "<br />", $MESSAGE);

$MESSAGE = substr($MESSAGE,0,300);

« Previous Page Next Page »