Jump to content
Sign in to follow this  
Sen

Support Tickets

Recommended Posts

I like to use that hack for oscommerce but i can't download it. If i download it i get a error saying it is corupt.

 

Can someone place it @ there webspace or email it to me :?

 

Thank u in advance :)

Share this post


Link to post
Share on other sites

I tested your contribution and found no dokumentation, no working admin and not the right filedefinitions in the admin/includes/applikations_top.php

Then the boxes files for the support desk are not included.

Please check your quality before posting.

A packket should be full integrateable into oscommerce.

Please load up a full version of your package. This is not sourceforge here.


xtcommerce Templates

And this is my new coding project. A multilingual sitesearch for online stores. Have a look at the search field left in the navbar:

WWW.BE-INSHAPE.DE Proteinpulver, Aminosäure Liquids and Supplements for Bodybuilding and Fitness

It finds all the ingredients like amino acids, carnitin and proteins if you don't know how to spell. In realtime...

Share this post


Link to post
Share on other sites

Gwinger wrote:

I tested your contribution and found no dokumentation, no working admin and not the right filedefinitions in the admin/includes/applikations_top.php

Then the boxes files for the support desk are not included.

Please check your quality before posting.

A packket should be full integrateable into oscommerce.

Please load up a full version of your package. This is not sourceforge here.

 

Gwinger, what the hell are you talking about?!

FOr one that has nothing to do with what Sen said, and second, what do you think this place is??

 

This isnt a place to come shopping for OSC mods for free!

If you want something and it doesnt work, FIX IT YOURSELF!

No one here is a charity, and lets say for arguments sake the code was Sen's, if you sue it you take the risk, after all every contribution has this next to it:

 

Note: Use contributions at your own risk.

 

I cant believe the way you said what you did, and it was out of order.

Dont order ppl around like you own them or their code on here.

Everything is done by good will and in the open source spirit.

If it doesnt work for you, and you dont have the ability to fix it, dont use it!

 

Simple as...!

CC.

Share this post


Link to post
Share on other sites

For the record no i did not write it. I like to try it. Only the zip file is corupt. I thought the maker of the hack is not aware of this and thats why i ask here for the missing files/ or complete repack.

 

The missing files are:

pd_ticket_admin.php

install.txt

Share this post


Link to post
Share on other sites

Right what you said.

But A contribution should have implemented the whole code and for a programmer it should be easy to test a Zip package before posting anything.

Seems that you are able to fix everything, also when you have only the half of the data????

What do you think you are here, in a do it yourself workshop.

This is a sectin for contributed addons and no CVS development section.

Look at that german news module.

What the heck is that?

When I start to do an addon, I shouldn't post it as a contribution. There has to be a little bit of order here.


xtcommerce Templates

And this is my new coding project. A multilingual sitesearch for online stores. Have a look at the search field left in the navbar:

WWW.BE-INSHAPE.DE Proteinpulver, Aminosäure Liquids and Supplements for Bodybuilding and Fitness

It finds all the ingredients like amino acids, carnitin and proteins if you don't know how to spell. In realtime...

Share this post


Link to post
Share on other sites

Sorry Sean, I'm tired and didn't recognized you're not the author of the contributin. ;-)


xtcommerce Templates

And this is my new coding project. A multilingual sitesearch for online stores. Have a look at the search field left in the navbar:

WWW.BE-INSHAPE.DE Proteinpulver, Aminosäure Liquids and Supplements for Bodybuilding and Fitness

It finds all the ingredients like amino acids, carnitin and proteins if you don't know how to spell. In realtime...

Share this post


Link to post
Share on other sites
Sorry Sen, I'm tired and didn't recognized you're not the author of the contributin. ;-)

 

Does not matter GINGER :lol:

Share this post


Link to post
Share on other sites

Gwinger

What do you think you are here, in a do it yourself workshop.

This is a sectin for contributed addons and no CVS development section.

Look at that german news module.

What the heck is that?

When I start to do an addon, I shouldn't post it as a contribution. There has to be a little bit of order here.

 

This maybe a contribution but nobody can anybody lese what to do when it comes to updating a mod.

 

If you think it is unfinished and wont work, email Harald and tell him, let him decide what to do with it, but dont ever think you can tell someone that they should finish it. If they decide not to, what then?

 

There is order, just maybe not the way you like it.

I know for one, if you had spoken to me in that way I would never update that code.

Why should I?

Becos you tell me to?! I dont think so...

 

Just remember how you speak to people, and remember the magic word.. please.

 

CC.

 

P.S. Commendable that you apologised tho, not many do.

Share this post


Link to post
Share on other sites

but missing icon helpdesk.gif

i have reused the original icon from helpdesk from snowman

 

Mistake here in install

8.) In english.php add the following

 

include('includes/languages/pd_add_english.php;

is

include('includes/languages/pd_add_english.php');

 

I also used the catalog/boxes/helpdesk.php from snowman that is missing in support ticket

 

and last i have an error in adding a new user

Support ticket Admin in /admin/pd_ticket_config_action.php

 

 

 

 

1136 - Column count doesn't match value count at row 1

 

INSERT INTO pd_support_team values('', 'elari', 'elari test team ')

 

[TEP STOP]

Share this post


Link to post
Share on other sites

Apologies to all for the errors in the zip file, I have uploaded the program to my server, and is available at the following address

 

http://www.puddled.co.uk/download/support_..._tickets_v1.zip

 

The zip file was tested before commiting to the contributions section of the main oscommerce site, and tested to be okay. However, I have a had a few reports back saying corrupt files are included.

 

I can only apologise for this, and I will dig my hammer out later to fix my machine and software.

 

The code is complete, however, it does require some cosmetic tweeks to complete the final look.

:oops:


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

it works ok tnx

 

Only a problem.... new ticket doesn't go in Open state but remain without state so i can not search ticket in admin by state (to search new).....

Share this post


Link to post
Share on other sites

support is updated to version 2.2 in cvs in other tree

http://cvs.sourceforge.net/cgi-bin/viewcvs....2/?sortby=date

 

many work has been made by david

New icon

list of opened ticket

improved and easier ticket search for user

we have also added a login box for customer account

 

some translation are needed from the english file to spannish / german .....

please do not use the spannish or german to translate they are not up to date....

 

uploaded also to my page support_tickets_2m1121.zip

Share this post


Link to post
Share on other sites

People have reported error's with other peoples tickets, being shown in their display. This has now been rectified, however there has had to be a change to the database , to include the customers id. This is because, the email variable used before was failing when the email address had a full-stop in it.

 

The new addition to the database is as below, all amendments can be downloaded fromteh cvs directory http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/elari/

 

edit your pd_ticket_data table as below

 

ALTER PD_TICKET_DATA ADD customers_id smallint(5) NULL default '0'


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Seems working better...

 

Expcept that under the admin/index.php

 

In the left bar I get:

 

"Open Tickets 0

Reviews: 34 "

 

Why is that, althought I have round 5 Opened Tickets.... it still shows Opened Tickets "0" ( under Statistics in index.php ) :shock:

Share this post


Link to post
Share on other sites

Yes we had a change in the database structure, and now use the status_id as opposed the status name. To correct this, look thoriugh your index.php for the ticket_query and alter to read:-

 

$ticket_query = tep_db_query("select count(*) as count from " . TABLE_PD_TICKET_DATA . " where ticket_status = '1'");

 

this line should be about line 175


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Okay, there has been a new release of this package, posted on the contributions section. The zip file was tested before upload, but seems to be corrupt on trying to download, so I have placed a package on my server located at

 

http://www.puddled.co.uk/download/support_...ickets_v2_6.zip

 

If you would like a copy of this file, help yourself, any problems with it, let me know via this forum


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

The reason for the new zip, is I found a bug in the user interface, that was not allowing the ticket to be displayed, or was generating a page not found error, this has now been rectifed in the new release


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

I am getting this strange message:

 

1054 - Unknown column 'customers_id' in 'where clause'

 

select count(*) as total from pd_ticket_data where customers_id ='2'

 

[TEP STOP]

 

when clicking on Ticket Tracking "pd_ticket_tracking.php"

 

Solution ? :?

Share this post


Link to post
Share on other sites

OK,

 

it seems there was an error with the SQL tables.

 

Never the less,

when a customer wants to open an ticket,

under:

 

Departments:

 

as well as under

Priority:

 

there is NO OPTION to choose from. ( like before we had under priority: Urgent, less urgent...)

 

Why is that?

 

How can I et back the Prioritys and Departments added ?

 

Please help is fastly needed :(

Share this post


Link to post
Share on other sites

Hi arames,

 

You would need to run the following into your database again:

 

INSERT INTO pd_ticket_dept VALUES("1","Sales");

INSERT INTO pd_ticket_dept VALUES("2","Billing");

INSERT INTO pd_ticket_dept VALUES("3","Support");

INSERT INTO pd_ticket_dept VALUES("4","General");

INSERT INTO pd_ticket_priority VALUES("1","Low");

INSERT INTO pd_ticket_priority VALUES("2","Medium");

INSERT INTO pd_ticket_priority VALUES("3","High");

 

That would fix your problem. :P

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×