beeonline Posted June 24, 2003 Posted June 24, 2003 Hi Ok I have played around with the layout and some PHP code... Now I am trying to add the contribution " Purchase Without Account v.0.56" and I am trying to figure out how to implement the follow DB mod... Database changes new as of v0.57 INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON', 'true', 'Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array('true', 'false'),'); So how do I do this, with what software and where in the DB When answering this question...please assume that I have no knowledge of MYSQL.... yet :oops: So a bit of hand holding would be appropete oops appropriate here for this newby Cheers Malc :lol:
Guest Posted June 24, 2003 Posted June 24, 2003 Are you aware of phpmyadmin? it basicly is a web based interface for handling mysql querries, im sure someone will correct me if im wrong here, but install phpmyadmin, or check with your webhots if it is installed and run the following as a querry: INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON', 'true', 'Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array('true', 'false'),'); what you nbeed to do is log into phpmyadmin, select the database you are using for oscommerce, and select run querry (or something like that!) Good luck! Tjobbe
beeonline Posted June 24, 2003 Author Posted June 24, 2003 Hi Thanks....can i use phpmyadminon my local machine... The reason being I am trying to learn php/mysql/oscommerce and it is a steap learning curve for me :shock: so I am to do all this locally I am running Windows ME on my desk top so I have php/mysql installed using Foxserv... and it works well On my Laptop I am running XP Pro which is more and have just installed php/mysql without having to use a package like Foxserv... Cheers Malc
beeonline Posted June 25, 2003 Author Posted June 25, 2003 Hi Can I use phpmyadmin on my local computer :?: Cheers Once again Malc
stevel Posted June 25, 2003 Posted June 25, 2003 I think phpmyadmin has to be on the server. However MySQLFront will work locally. Steve Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description
brianstorm Posted July 2, 2003 Posted July 2, 2003 Hi, you can use phpmyadmin locally, I reckon it'll work anywhere where you have a server (eg apache, +php +mysql running). I can wholly recomend phptriad for a particularly easy setup of apache, php & mysql on a windows machine as it looks fairly compliacted to setup all that stuff manually. Phptriad is available at download.com and some other places....search on google (as always) with ten thousand dollars we'll all be millionaires
beeonline Posted July 2, 2003 Author Posted July 2, 2003 Hi Thanks for you reply..very helpful I am using Foxsev on my desktop running Windows ME Cherers Malc
Recommended Posts
Archived
This topic is now archived and is closed to further replies.