Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Auto Database System

Asked Modified Viewed 24,445 times
S
smokeman
S
  • Veteran Member, joined since
  • Contributed 920 posts on the community forums.
  • Started 79 threads in the forums
  • Started this discussions
asked
Veteran Member

[mp]172[/mp]
0 replies

34 posts

V
Vyper69
V
Unprecedented Times call for Unprecedented Measures
  • Senior Member, joined since
  • Contributed 551 posts on the community forums.
  • Started 146 threads in the forums
answered
Senior Member

Nice. I could really use this on my site, if it had some extra features. Since my site is a business directory, and not the sale of cars, I was wondering if you could add a company information section. I don't want ppl contacting me for a car. Maybe if you could add Dealer Name, Location, Phone, and E-mail to it. Then it would be perfect for my site. If I knew how to make the changes I would do it myself, but I don't. Other than these items for me, it is great. Maybe even integrate Google Maps into it would also be a plus. The ability for the sites members to submit their information, would make this feature extreme. I mean it is already on my site, but with what I am doing, I do not have the time to add vehicles each and every time it is needed. Also the ability to edit their submission would be great. So if they sold the vehicle, they could remove it.
Edited by Vyper69 on 28-05-2012 21:38,
0 replies
V
Vyper69
V
Unprecedented Times call for Unprecedented Measures
  • Senior Member, joined since
  • Contributed 551 posts on the community forums.
  • Started 146 threads in the forums
answered
Senior Member

english.php Line 8 reads: $locale['ads104'] = "Letest Incoming Cars"; It needs to read $locale['ads104'] = "Latest Incoming Cars"; I have already made the change to mine.

Also how do I add more fields to the form. and how do i make it, so that the user can upload their items.
Edited by Vyper69 on 30-05-2012 20:28,
0 replies
V
Vyper69
V
Unprecedented Times call for Unprecedented Measures
  • Senior Member, joined since
  • Contributed 551 posts on the community forums.
  • Started 146 threads in the forums
answered
Senior Member

Ok Here is my issue. i have figured out with help how to change text fields over the last few days. But now I am struggling with where those fields belong. I am at a loss with this. I need all the dealer info at the top, and the vehicle info under that, but i need the main view page to stay the way it is now. where it shows make and model, year, miles and price. I am stuck on this. Administration wise i know how to allow the dealers to input their own info.

here is the code i am trying to fix.

<?php

// Infusion Titles & Description
$locale['ads100'] = "Auto Database System";
$locale['ads101'] = "Add system for Car Dealers.";
$locale['ads102'] = "Auto Database System";
$locale['ads103'] = "Auto Database System";
$locale['ads104'] = "Latest Incoming Cars";
$locale['ads105'] = "See all our cars";

// Side-Panel mm.
$locale['ads000'] = "Auto Database System";
$locale['ads001'] = "<font color='#ff0000'>No ads in the system!</font>";
$locale['ads002'] = "Administration";
$locale['ads003'] = "See all Ads";
$locale['ads004'] = "Click on the images below to see a larger picture/details about the car.";
$locale['ads005'] = "Contact";
$locale['ads006'] = "Click here";
$locale['ads007'] = "Search result";
$locale['ads008'] = "No results";
$locale['ads009'] = "No car brand and model match your search.";
$locale['ads010'] = "Search by brand and model:";
$locale['ads011'] = "Contact:";
$locale['ads012'] = "Edit information";

// Form
$locale['ads200'] = "Create Ad";
$locale['ads201'] = "Order :";
$locale['ads202'] = "Car make and model";
$locale['ads203'] = "Year";
$locale['ads204'] = "<b>Make and model</b>";
$locale['ads205'] = "<b>Year</b>";
$locale['ads208'] = "Save";
$locale['ads209'] = "Undo";
$locale['ads210'] = "Miles";
$locale['ads211'] = "Price";
$locale['ads212'] = "Picture";
$locale['ads213'] = "Dealer Name";
$locale['ads214'] = "Telephone";
$locale['ads215'] = "Email";
$locale['ads216'] = "Equipment";
$locale['ads217'] = "Dealer Name:";
$locale['ads218'] = "Year:";
$locale['ads219'] = "Miles:";
$locale['ads220'] = "Price:";
$locale['ads221'] = "Telephone:";
$locale['ads222'] = "Email:";
$locale['ads223'] = "Equipment:";
$locale['ads224'] = "Delete Picture";
$locale['ads225'] = "Picture 1 <font color='#0000ff'>*</font>";
$locale['ads226'] = "Picture 2 <font color='#0000ff'>*</font>";
$locale['ads227'] = "Picture 3 <font color='#0000ff'>*</font>";
$locale['ads228'] = "Picture 4 <font color='#0000ff'>*</font>";
$locale['ads229'] = "Picture 5 <font color='#0000ff'>*</font>";
$locale['ads230'] = "Pictures";
$locale['ads231'] = "Location";
$locale['ads232'] = "Location:";
$locale['ads233'] = "Details about the car";

// Valg
$locale['ads299'] = "Edit Ad";
$locale['ads300'] = "Ads";
$locale['ads301'] = "Edit";
$locale['ads302'] = "Delete";
$locale['ads303'] = "Move down";
$locale['ads304'] = "Move up";
$locale['ads305'] = "Refresh Order";
$locale['ads308'] = "<font color='#ff0000'>No Ads in the Database!</font>";
$locale['ads309'] = "Delete this Ad ?";
$locale['ads310'] = "Back";
$locale['ads311'] = "Search";
$locale['ads312'] = "<font color='#ff0000'>*</font> Required information.";
$locale['ads313'] = "Print";
$locale['ads314'] = "Go to Ads";
$locale['ads315'] = "<font color='#0000ff'>*</font> Attach images when the Ad is written and saved.<br /> - Then press &quot;Edit&quot; and paste pictures.";

// Fejl
$locale['ads400'] = "Unable to add Ad.";
$locale['ads401'] = "Fill in the box Car brand and model!";

?>
0 replies
— 1 month later —
H
henrikbrobeck
H
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 2 threads in the forums
answered
Newbie

Why do i get this error when i infuse?

Quote

Table 'hbt.fusion82245_ads' doesn't exist
0 replies
— 1 year later —
M
Michael Scholtz
M
For a change it's nice being on a PHP-fusion site where I don't have to worry about the admin side of things.
  • Junior Member, joined since
  • Contributed 29 posts on the community forums.
  • Started 9 threads in the forums
answered
Junior Member

Also agreed and requesting the ability for users to add their own cars would be nice.

I run a car club seat-sport.co.za and members would love adding their cars to show off, and possibly to sell, but mainly just to brag about cars.
0 replies
F
faga
F
faga 10
I choose a lazy person to do a hard job. Because a lazy person will find an easy way to do it.” - Bill Gates
  • Member, joined since
  • Contributed 158 posts on the community forums.
  • Started 14 threads in the forums
answered
Member

Replace infusion.php content with this
<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Name: infusion.php
| Author : Smokeman
| Email: smokeman@esenet.dk
| Web: http://www.phpfusion-tips.dk/
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }

include INFUSIONS."car_list_panel/infusion_db.php";

if (file_exists(INFUSIONS."car_list_panel/locale/".$settings['locale'].".php")) {
   include INFUSIONS."car_list_panel/locale/".$settings['locale'].".php";
} else {
   include INFUSIONS."car_list_panel/locale/English.php";
}

$inf_title = $locale['ads100'];
$inf_description = $locale['ads101'];
$inf_version = "1.1";
$inf_developer = "Smokeman";
$inf_email = "smokeman@esenet.dk";
$inf_weburl = "http://www.phpfusion-tips.dk/";

$inf_folder = "car_list_panel";

$inf_newtable[1] = DB_ADS." (
car_id SMALLINT(3) NOT NULL,
car_order SMALLINT(2) NOT NULL,
car_model VARCHAR(50) NOT NULL DEFAULT '0',
car_year VARCHAR(50) NOT NULL,
car_km VARCHAR(100) NOT NULL,
car_pris VARCHAR(50) NOT NULL,
car_pic1 VARCHAR(50) DEFAULT '',
car_pic2 VARCHAR(50) DEFAULT '',
car_pic3 VARCHAR(50) DEFAULT '',
car_pic4 VARCHAR(50) DEFAULT '',
car_pic5 VARCHAR(50) DEFAULT '',
car_type VARCHAR(50) NOT NULL,
car_fuel VARCHAR(50) NOT NULL,
car_doors VARCHAR(10) NOT NULL,
car_color VARCHAR(50) NOT NULL,
car_udstyr VARCHAR(250) NOT NULL,

PRIMARY KEY (car_id)
) ENGINE=MyISAM;";
   
$inf_droptable[1] = DB_ADS;

$inf_adminpanel[1] = array(
   "title" => $locale['ads100'],
   "image" => "ads.jpg",
   "panel" => "car_list_panel_admin.php",
   "rights" => "ADS"
);

$inf_sitelink[1] = array(
   "title" => $locale['ads102'],
   "url" => "car_list.php",
   "visibility" => "0"
);

?>


Change log:

TYPE=MyISAM [b]to[/b] ENGINE=MyISAM

car_model VARCHAR(50) NOT NULL DEFAULT '', to car_model VARCHAR(50) NOT NULL DEFAULT '0',
0 replies
— 2 months later —
K
Kaav
K
Kaav 10
  • Junior Member, joined since
  • Contributed 28 posts on the community forums.
  • Started 5 threads in the forums
answered
Junior Member

Hello,

I have installed the addon called Auto Database System from this page.
http://www.php-fusion.co.uk/infusions...don_id=172
The problem is that on my webpage no picture is shown in the admin>Infusions. And thereby making it impossible to get into the addon without writing the link.
Is there somehow I can get a picture there or atleast make the text linking to "car_list_panel_admin.php"? I have tried myself but failed at it sadly. So now I'm requesting help :)

Added: I now also have the problem saying: "Table 'web668582.fusion7i21S_ads' doesn't exist" whenever i open the "/infusions/car_list_panel/car_list.php". It's green in where you install the infusions, but I can't install it nor delete it again. A little help, please? :)
Edited by Kaav on 31-03-2014 17:35,
Kaav attached the following file:
picauto.png [No information available / 51 Downloads]
0 replies
D
douwe_yntema
D
  • Senior Member, joined since
  • Contributed 667 posts on the community forums.
  • Started 57 threads in the forums
  • Answered 1 question
answered
Senior Member

infusion.php change...

TYPE=MyISAM; to ENGINE = MyISAM;
0 replies
K
Kaav
K
Kaav 10
  • Junior Member, joined since
  • Contributed 28 posts on the community forums.
  • Started 5 threads in the forums
answered
Junior Member

In the Auto Database System right? And if I understand right, then I've to change "TYPE=MyISAM;" to "ENGINE = MyISAM;" Right?
But not that good at this, so please spell it out for me thank you! :D
0 replies
K
KasteR
K
KasteR 10
  • Senior Member, joined since
  • Contributed 290 posts on the community forums.
  • Started 1 thread in the forums
answered
Senior Member

Change in infusion.php, you'll need to defuse and infuse.
0 replies
K
Kaav
K
Kaav 10
  • Junior Member, joined since
  • Contributed 28 posts on the community forums.
  • Started 5 threads in the forums
answered
Junior Member

FIXED. Found it in phpmyadmin, it hadn't delete all of it's tables so it's working now.

But back to the other issue. Why doesn't any images show above it? I can't get into the infusion?
Edited by Kaav on 31-03-2014 20:12,
0 replies
K
KasteR
K
KasteR 10
  • Senior Member, joined since
  • Contributed 290 posts on the community forums.
  • Started 1 thread in the forums
answered
Senior Member

There may not be an icon specified, that shouldn't prevent you from accessing the infusion. Perhaps there's an issue with the aid link not being included. I'd have to take a look later.
0 replies
K
Kaav
K
Kaav 10
  • Junior Member, joined since
  • Contributed 28 posts on the community forums.
  • Started 5 threads in the forums
answered
Junior Member

Quote

KasteR wrote:

There may not be an icon specified, that shouldn't prevent you from accessing the infusion. Perhaps there's an issue with the aid link not being included. I'd have to take a look later.


There's no link, maybe if the text were linking to the admin panel that would be great. But I've tried everything no way to enter it sadly.
0 replies
K
KasteR
K
KasteR 10
  • Senior Member, joined since
  • Contributed 290 posts on the community forums.
  • Started 1 thread in the forums
answered
Senior Member

Something must have gone wrong with the infusion. I've downloaded, infused, and have an image along with link.

Make sure you've deleted all the entries in your database and try to infuse again. It should work as is.

Also make sure you've copied the 'images' and 'administration' directories to your server.
Edited by KasteR on 01-04-2014 03:54,
0 replies
G
Gillette
G
Gillette 10
  • Senior Member, joined since
  • Contributed 335 posts on the community forums.
  • Started 4 threads in the forums
answered
Senior Member

worked ok for me:
try the readme file and assure you have uploaded everything without corruptions .
re-upload and overwrite.then un-infuse/--re-infuse.

attached readme file from author:

DESCRIPTION:
------------
Auto Database System - for sales of cars.

Make new ads for cars - upload up to 5 pictures in each ad.

Info about:

 - Car model/brand
 - Type
 - Fuel type
 - Year
 - Miles
 - Price
 - Doors
 - Color
 - Equipment

Print function on all pages.

Go-back-function on all pages.

Search-function for searching after brand/model.

Mouse-over the small pictures will change the big picture of the cars.

Side-panel incl. that showing the 10 Latest Incoming Cars.


VERSION:
--------
1.1


INSTALLATION:
-------------
1. Upload the maps "administration", "images" and "infusions" to the root of the server.

2. CHMOD the map /images/cars to 777.

3. Log on to the site and go to: Admin Panel -->System Admin -->Infusions - and install "Car List Panel".

4. Now go to: Admin Panel -->System Admin -->Panels - and make a new side-panel, where you choose "car_list_panel" from the list. Remember to enable the panel.

5. Creating/editing/deleting ads via: Admin Panel -->Infusions -->Auto Database System.


AUTHOR:
-------
Auto Database System is written/coded by Robert Holm AKA Smokeman.

PHPFusion-Tips.dk
0 replies
D
douwe_yntema
D
  • Senior Member, joined since
  • Contributed 667 posts on the community forums.
  • Started 57 threads in the forums
  • Answered 1 question
answered
Senior Member

It can happen, if you have a long domain name, that the path to the icon is truncated.

This is the case if the icon is placed in a folder under the infusion.

Normally icons are placed in the folder /adminstration/images/ under the root of your fusion installation.
The databasefield for the path to the icon has a limitide length of 50 char's

In that case, remove the line to the icon in the infusion.php.
You get a standard infusion icon for the infusion.

Make the code like:

$inf_adminpanel[1] = array(
   "title" => $locale['xxxx'],
   "image" => "image.gif",
0 replies
G
Grimloch
G
Energy can neither be created nor destroyed; only transformed !
  • Senior Member, joined since
  • Contributed 722 posts on the community forums.
  • Started 141 threads in the forums
  • Answered 2 questions
answered
Senior Member

Or: why not just change the DB field to 255 characters or whatever is needed??
0 replies
D
douwe_yntema
D
  • Senior Member, joined since
  • Contributed 667 posts on the community forums.
  • Started 57 threads in the forums
  • Answered 1 question
answered
Senior Member

That would require an modificatiion of the fusion core and installation script
0 replies
K
Kaav
K
Kaav 10
  • Junior Member, joined since
  • Contributed 28 posts on the community forums.
  • Started 5 threads in the forums
answered
Junior Member

Quote

douwe_yntema wrote:

It can happen, if you have a long domain name, that the path to the icon is truncated.

This is the case if the icon is placed in a folder under the infusion.

Normally icons are placed in the folder /adminstration/images/ under the root of your fusion installation.
The databasefield for the path to the icon has a limitide length of 50 char's

In that case, remove the line to the icon in the infusion.php.
You get a standard infusion icon for the infusion.

Make the code like:

$inf_adminpanel[1] = array(
   "title" => $locale['xxxx'],
   "image" => "image.gif",


This worked. Thank you very much! :)
0 replies
D
douwe_yntema
D
  • Senior Member, joined since
  • Contributed 667 posts on the community forums.
  • Started 57 threads in the forums
  • Answered 1 question
answered
Senior Member

You're welcome
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 34 posts
  • Votes 0 votes
  • Topic users 17 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet