Jump to content

afterburn25

Members
  • Content count

    54
  • Joined

  • Last visited

Everything posted by afterburn25

  1. afterburn25

    support ticket system

    i recently installed the support ticket system contribution and had a problem with my sql syntax the error message said this is what i have in my sql # MySQL-Front Dump 1.19 beta # # Host: localhost Database: osc_bb #-------------------------------------------------------- # Server version 4.0.0-alpha-nt # # Table structure for table '002_news' # DROP TABLE /*!32200 IF EXISTS*/ 002_news; CREATE TABLE /*!32300 IF NOT EXISTS*/ 002_news ( id_news bigint(13) NOT NULL auto_increment, ueberschrift varchar(250) , kurztext longtext , autor varchar(100) , von date , bis date , langtext longtext , bild varchar(30) , weiter enum('Y','N') NOT NULL DEFAULT 'N' , PRIMARY KEY (id_news) ); # # dumping data fortable configuration # INSERT INTO configuration VALUES("","Default Support ticket Status","DEFAULT_SUPPORT_TICKET_STATUS","1","This is the default status assigned to all new support tickets","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL); INSERT INTO configuration VALUES("","Default Support Ticket Priority","DEFAULT_SUPPORT_TICKET_PRIORITY","5","This is the default priority assigned to new supporttickets","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL); INSERT INTO configuration VALUES("","Default support deparmtnet","DEFAULT_SUPPORT_TICKET_DEPARTMENT","2","Default department support tickets are assigned to","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL); INSERT INTO configuration VALUES("","Default Support Administraor","DEFAULT_SUPPORT_ADMIN_ID","4","This is the default supporter assigned to new tickets","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL); INSERT INTO configuration VALUES("","NewsDesk","MAX_DISPLAY_NEWSDESK_NEWS","3","maximum number of items to display in the NewsDesk box","3",NULL,NULL,"2003-02-05 15:16:49",NULL,NULL); # # Table structure for table 'faq' # DROP TABLE /*!32200 IF EXISTS*/ faq; CREATE TABLE /*!32300 IF NOT EXISTS*/ faq ( faq_id tinyint(3) unsigned NOT NULL auto_increment, visible enum('1','0') NOT NULL DEFAULT '1' , v_order tinyint(3) unsigned NOT NULL DEFAULT '0' , question varchar(128) NOT NULL DEFAULT '' , answer text NOT NULL DEFAULT '' , date date NOT NULL DEFAULT '0000-00-00' , PRIMARY KEY (faq_id) ); # # Dumping data for table 'faq' # # # Table structure for table 'support_assign' # DROP TABLE /*!32200 IF EXISTS*/ support_assign; CREATE TABLE /*!32300 IF NOT EXISTS*/ support_assign ( support_assign_id tinyint(3) unsigned NOT NULL auto_increment, language_id tinyint(3) NOT NULL DEFAULT '0' , support_assign_name varchar(64) , support_assign_email varchar(90) , PRIMARY KEY (support_assign_id,language_id), INDEX assign_id (support_assign_id) ); # # Dumping data for table 'support_assign' # INSERT INTO support_assign VALUES("1","1","Administrator","admin@localhost"); INSERT INTO support_assign VALUES("1","3","Admin","admin@localhost"); INSERT INTO support_assign VALUES("1","2","Admin","admin@localhost"); # # Table structure for table 'support_department' # DROP TABLE /*!32200 IF EXISTS*/ support_department; CREATE TABLE /*!32300 IF NOT EXISTS*/ support_department ( support_department_id tinyint(3) unsigned NOT NULL DEFAULT '0' , language_id tinyint(3) unsigned NOT NULL DEFAULT '1' , support_department_name varchar(40) , PRIMARY KEY (support_department_id,language_id), INDEX department_id (support_department_id) ); # # Dumping data for table 'support_department' # INSERT INTO support_department VALUES("2","3","Hosting"); INSERT INTO support_department VALUES("2","2","Hosting"); INSERT INTO support_department VALUES("1","2","billing"); INSERT INTO support_department VALUES("1","3","billing"); INSERT INTO support_department VALUES("2","1","Hosting"); INSERT INTO support_department VALUES("1","1","Billing"); INSERT INTO support_department VALUES("3","1","General"); INSERT INTO support_department VALUES("3","2","General"); INSERT INTO support_department VALUES("3","3","General"); # # Table structure for table 'support_priority' # DROP TABLE /*!32200 IF EXISTS*/ support_priority; CREATE TABLE /*!32300 IF NOT EXISTS*/ support_priority ( support_priority_id smallint(11) unsigned NOT NULL DEFAULT '0' , language_id tinyint(3) unsigned NOT NULL DEFAULT '1' , support_priority_name varchar(40) , PRIMARY KEY (support_priority_id,language_id), INDEX priority_id (support_priority_id) ); # # Dumping data for table 'support_priority' # INSERT INTO support_priority VALUES("1","1","Urgent"); INSERT INTO support_priority VALUES("5","2","Low"); INSERT INTO support_priority VALUES("3","1","Medium"); INSERT INTO support_priority VALUES("4","1","High"); INSERT INTO support_priority VALUES("1","2","Dringend"); INSERT INTO support_priority VALUES("5","1","Low"); INSERT INTO support_priority VALUES("3","2","Mittel"); INSERT INTO support_priority VALUES("4","2","Hoch"); INSERT INTO support_priority VALUES("5","3","Low"); # # Table structure for table 'support_status' # DROP TABLE /*!32200 IF EXISTS*/ support_status; CREATE TABLE /*!32300 IF NOT EXISTS*/ support_status ( support_status_id tinyint(3) unsigned NOT NULL DEFAULT '0' , language_id tinyint(3) unsigned NOT NULL DEFAULT '1' , support_status_name varchar(25) , PRIMARY KEY (support_status_id,language_id), INDEX status_id (support_status_id) ); # # Dumping data for table 'support_status' # INSERT INTO support_status VALUES("2","3","Re-opened"); INSERT INTO support_status VALUES("2","2","Re-opened"); INSERT INTO support_status VALUES("2","1","Re-opened"); INSERT INTO support_status VALUES("1","3","Open"); INSERT INTO support_status VALUES("1","1","Open"); INSERT INTO support_status VALUES("1","2","Open"); # # Table structure for table 'support_ticket_history' # DROP TABLE /*!32200 IF EXISTS*/ support_ticket_history; CREATE TABLE /*!32300 IF NOT EXISTS*/ support_ticket_history ( support_history_id int(11) NOT NULL auto_increment, ticket_id int(11) unsigned DEFAULT '0' , new_value tinyint(3) unsigned DEFAULT '0' , old_value tinyint(3) unsigned DEFAULT '0' , date_modified datetime , customer_notified tinyint(3) unsigned DEFAULT '0' , old_department tinyint(3) unsigned , new_department tinyint(3) unsigned , old_support tinyint(3) unsigned , new_support tinyint(3) unsigned , PRIMARY KEY (support_history_id), INDEX support_history_id (support_history_id) ); # # Dumping data for table 'support_ticket_history' # # # Table structure for table 'support_tickets' # DROP TABLE /*!32200 IF EXISTS*/ support_tickets; CREATE TABLE /*!32300 IF NOT EXISTS*/ support_tickets ( ticket_id int(11) NOT NULL auto_increment, ticket_status tinyint(1) unsigned NOT NULL DEFAULT '1' , customers_id int(11) unsigned DEFAULT '0' , customers_name varchar(70) DEFAULT '0' , customers_email_address varchar(90) DEFAULT '0' , customers_company varchar(90) DEFAULT '0' , customers_domain varchar(90) DEFAULT '0' , ticket_date datetime , ticket_comments text , department_id tinyint(3) unsigned DEFAULT '0' , status_id tinyint(3) unsigned DEFAULT '0' , priority_id tinyint(3) unsigned DEFAULT '0' , admin_id tinyint(3) unsigned DEFAULT '0' , admin_comments text , last_modified datetime , PRIMARY KEY (ticket_id), INDEX ticket_id (ticket_id) ); # # Dumping data for table 'support_tickets' # can someone tell me what is wrong that is the my sql file that came with it i noticed other people have had this problem as well but no one has ever answered them please someone help
  2. Its finally here!! with this new mod you will be able to use Invision Power Board in conjunction with OSCommerce. This is only my first release so may have a few bugs please let me know. Keep checking back for updates. I have an admin area in development. For questions and comments please [*EDIT* - post to this thread! - Johnson]
  3. afterburn25

    Invision Power Board Intergration Into OSC

    I appoligize, I have not given up. I had gotten real busy with my job and just didnt have the time to devote to this project. that is why i had given my source to someone else cause they promised to finish the contribution. why it is not available to download I dont know. they must have taken my source and ran with it. just cant trust anyone these days with open source projects. And yes I did get rid of the iframe. I will try to find it and see what i can do with it.
  4. afterburn25

    Invision Power Board Intergration Into OSC

    Just an update i am curently working on the testing part of the project hopfully it wont be long still dont have a release date
  5. afterburn25

    Autologon 1.05

    hi i was using autologon 1.03 and it worked ok but had alot of bugs in it so i upgraded to 1.05 and now it doesnt work at all i turned autologin on in admin but when i go to log in i get the little remember me box in the login box and i check it log in everthing works fine but when i close internet exploror and go back i have to login again i get no errors though any ideas
  6. funny thing happened i was searching through the threads looking for a way to implament a sid killer and be successful until i ran accross Ian's idea sounded good anyway so i stopped right there and did it only problem is when i went to my site i got caught up in an infanant loop of logging off so i cam back to the forum to let everyone know that there is something wrong with that code and realized i only read page one and were 17 other pages i should have read through lol anyway yes i have auto login installed so any way arround this
  7. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    I am also keeping a close eye on this contribution as for we specialize in custom built systems one of the things i would like to see in this contribution is to have predefined systems where people can make minor alterations and the other is maybe a way to make it impossible to put together a system that would be considered incompatible that would very well make this the best mod out there but i know that is a long way off but that isa what most of us need out of this mod
  8. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    hey like i said i wasnt complaining or anything you were asking for suggestions i was just giving you a suggestion
  9. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    but what im saying is not everyone wants a 800 FSB or 400FSB motherboard and processor i just want to have where people can build a cheap paper weight or a high end system all the other computer creators have that im not complaining or anything just pointing out how nessesarry it is so maybe it could be something to add to a future version of computer creator
  10. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    and as far as the pictures i dont have the checkmark.gif pics anywhere
  11. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    asim0s you wrote but what i am talking about is if you have an 800 FSB intel motherboard selected and it is showing a 400 FSB intel processor it isnt going to work that is the incompatibility problem i am talking about
  12. afterburn25

    support ticket system

    whats the problem here everyone gets there questions answered but me i started this thread and my post was totally ignored
  13. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    i am also intrested in this project. will there ever be a way to hide incompatible components from showing up cause that is what i need normally people that use the custom build option dont know anything about computers otherwise they would just do it themselves . also is there a place i can get the pics for the admin area thanks
  14. which file are you refering too
  15. afterburn25

    Invision Power Board Intergration Into OSC

    yes invision is gpl although they have a commercial release
  16. well at first i was going to make an update for it but now i will have to do a complete rewrite and rewrite of some of the core osc files so it will be a whole new contribution
  17. afterburn25

    Invision Power Board Intergration Into OSC

    as i said in an earlier thread the i am working on the full intergration as we speak it will take a little more time since i have to rewrite some of the core files to make it work i am working as fast as i can
  18. not yet but will have one up very soon
  19. not yet that is just a sample of the main intergration im working on now this new one will it will also have an admin
  20. i appoligize for that i just uploaded that today but i uploaded the one still in development i just uploaded the correct zip a few minutes ago so you can now download that one sorry about that
  21. afterburn25

    Invision Power Board Intergration Into OSC

    it can be downloaded at http://www.oscommerce.com/community/contributions,1552
  22. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    yes i agree with the predefined computer also it would be nice to have only certain components show up ion certain computers
  23. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    no but i like it for the features not for the looks if they can implament those features into custom computer creator they wouldnt need to make another one again
  24. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    it appears someone has built a really nice one called Custom Combo Creator check it out http://www.motherboards.com/catalog/ccc.php i havent seen anything like itfully intergrated into oscommerce
  25. afterburn25

    CUSTOM COMPUTER CREATOR 7 RELEASED

    but the only problem with that is i need to offer a verity of systems in order to be competitive and besides 800 FSB isnt a very popular item that was just an example of the many miss compatible systems you could build
×