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,443 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

R
Rolf Mayer
R
Ex
  • Senior Member, joined since
  • Contributed 391 posts on the community forums.
  • Started 7 threads in the forums
answered
Senior Member

Fine. Well done. (as usual...)
0 replies
S
Structor
S
  • Member, joined since
  • Contributed 116 posts on the community forums.
  • Started 11 threads in the forums
answered
Member

It is a fine infusion, very usefull. I have some suggestions though:
1. a formular for members to submit their cars for sell.
2. equipment should be placed under the pictures too, not in the left column of the page, because if there is a long text it does not look good. (btw, I tryed to wrote there all the equipment of my car, but the script trimmed my text, so maybe should be better to let a larger text to insert there.)
3. adding some contact information on each car would be necessary, if we really want to sell the car :)
4. in the adding form, there are 5 options for inserting images, but it does not work if I want to upload all five. I had to edit five times the car ad, to insert one image at a time. Maybe you should let only one cell to insert images, like in the photoalbums images uploading
Edited by Structor on 12-02-2011 12:27,
0 replies
S
smokeman
S
  • Veteran Member, joined since
  • Contributed 920 posts on the community forums.
  • Started 79 threads in the forums
  • Started this discussions
answered
Veteran Member

Quote

structor wrote:
It is a fine infusion, very usefull. I have some suggestions though:
1. a formular for members to submit their cars for sell.
2. equipment should be placed under the pictures too, not in the left column of the page, because if there is a long text it does not look good. (btw, I tryed to wrote there all the equipment of my car, but the script trimmed my text, so maybe should be better to let a larger text to insert there.)
3. adding some contact information on each car would be necessary, if we really want to sell the car :)
4. in the adding form, there are 5 options for inserting images, but it does not work if I want to upload all five. I had to edit five times the car ad, to insert one image at a time. Maybe you should let only one cell to insert images, like in the photoalbums images uploading


1. This infusion was coded for a used-car sale dealer. It's not meant to that everyone can sumbit their own cars - this is the dealers choise + the dealers cars were talking about here.

2. Maybe I'll change that in a newer relased version - thx anyway.

3. In additionel to that it's not meant that everyone can submit their cars, there's still a link that says "Contact" - clicking this link will redirect you to /contact.php of your homepage.

4. I know that the coding-part regarding images ain't 100% optimal - but this is somethiong I am working on atm.
0 replies
S
Structor
S
  • Member, joined since
  • Contributed 116 posts on the community forums.
  • Started 11 threads in the forums
answered
Member

Hi again!
I have another suggestion :)
The .pdf file to print contains 3 pages. Is it possible to only print the second page? because first and third are not really needed

my test site is http://promo.modstruct.ro/infusions/car_list_panel/car_desc.php?action=view&car_id=1 (version v7.02)
0 replies
C
chatlaq
C
Php Fusion Turkey Admin
  • Junior Member, joined since
  • Contributed 23 posts on the community forums.
  • Started 6 threads in the forums
answered
Junior Member

translated to Turkish by chatlaq
0 replies
S
smokeman
S
  • Veteran Member, joined since
  • Contributed 920 posts on the community forums.
  • Started 79 threads in the forums
  • Started this discussions
answered
Veteran Member

Thx - there's nothing attached..

But no need to either - because @ozan allready translated this ti Turkish:
http://www.phpfusion-mods.net/infusio...mod_id=865 (look at the comments).

But thx anyway m8 - it was a nice thought. ;)
0 replies
L
lelebart
L
I don't know! I don't know why I did it, I don't know why I enjoyed it, and I don't know why I'll do it again! Bart Simpson
  • Member, joined since
  • Contributed 133 posts on the community forums.
  • Started 21 threads in the forums
answered
Member

S
smokeman
S
  • Veteran Member, joined since
  • Contributed 920 posts on the community forums.
  • Started 79 threads in the forums
  • Started this discussions
answered
Veteran Member

@lelebart: Thx - but this was in v1.0

This is fixed here in v1.1

Quote

VERSION:
--------
1.1 - Fixed SQL Injection Vulnerability
1.0 - First release


;)
0 replies
L
lelebart
L
I don't know! I don't know why I did it, I don't know why I enjoyed it, and I don't know why I'll do it again! Bart Simpson
  • Member, joined since
  • Contributed 133 posts on the community forums.
  • Started 21 threads in the forums
answered
Member

i'm sorry, i missed the new version. ignore that post
0 replies
— 6 months later —
C
ChrisH
C
ChrisH 10
--Chris
http://www.chowland.com
http://shawnalarassa.com
  • Newbie, joined since
  • Contributed 1 post on the community forums.
answered
Newbie

I noticed you have a simular infusion called classified ads on your dev site. I've been looking for something like that. can you make it available for download?? thx!!
0 replies
S
smokeman
S
  • Veteran Member, joined since
  • Contributed 920 posts on the community forums.
  • Started 79 threads in the forums
  • Started this discussions
answered
Veteran Member

Hi there.

The Classified Ads is just something I am testing - not something I have made.

You can download it from here:
http://www.phpfusion-mods.net/forum/v...post_18348
0 replies
— 1 month later —
A
andutzel
A
  • Newbie, joined since
  • Contributed 1 post on the community forums.
answered
Newbie

Can you make it please to users submit their cars please? thx....:|
0 replies
C
chatlaq
C
Php Fusion Turkey Admin
  • Junior Member, joined since
  • Contributed 23 posts on the community forums.
  • Started 6 threads in the forums
answered
Junior Member

current turkish locale

<?php
// çeviri: phptema.com | ekleme: chatlaq
// Infusion Titles [and] Description
$locale['ads100'] = "Otomobil Veritabanı Sistemi";
$locale['ads101'] = "Otomobil Satıcı Sistemi.";
$locale['ads102'] = "Otomobil Veritabanı Sistemi";
$locale['ads103'] = "Otomobil Veritabanı Sistemi";
$locale['ads104'] = "Son Otomobiller";
$locale['ads105'] = "Tüm Otomobilleri Gör";

// Side-Panel mm.
$locale['ads000'] = "Otomobil Veritabanı Sistemi";
$locale['ads001'] = "<font color='#ff0000'>Sisteme ilan eklenmemiş!</font>";
$locale['ads002'] = "Yönetim";
$locale['ads003'] = "Tüm ilanları gör";
$locale['ads004'] = "Daha fazla resim/ayrıntı için resmin üzerine tıklayın.";
$locale['ads005'] = "İletişim";
$locale['ads006'] = "Buraya tıkla";
$locale['ads007'] = "Arama sonucu";
$locale['ads008'] = "Sonuç yok";
$locale['ads009'] = "Bu arama ile eşleşen hiç bir araba marka ve modeli bulunamadı.";
$locale['ads010'] = "Marka veya modele göre ara:";
$locale['ads011'] = "İletişim:";
$locale['ads012'] = "Bilgiyi düzenle";

// Form
$locale['ads200'] = "İlan ekle";
$locale['ads201'] = "Sıralama :";
$locale['ads202'] = "Araba marka veya modeli";
$locale['ads203'] = "Yıl";
$locale['ads204'] = "<b>Marka ve Model</b>";
$locale['ads205'] = "<b>Yıl</b>";
$locale['ads208'] = "Kaydet";
$locale['ads209'] = "Geri Al";
$locale['ads210'] = "Km.";
$locale['ads211'] = "Fiyat";
$locale['ads212'] = "Resim";
$locale['ads213'] = "Tür";
$locale['ads214'] = "Kapı";
$locale['ads215'] = "Renk";
$locale['ads216'] = "Ekipman";
$locale['ads217'] = "Tür:";
$locale['ads218'] = "Yıl:";
$locale['ads219'] = "Km.:";
$locale['ads220'] = "Fiyat:";
$locale['ads221'] = "Kapı:";
$locale['ads222'] = "Renk:";
$locale['ads223'] = "Ekipman:";
$locale['ads224'] = "Resmi Sil";
$locale['ads225'] = "Resim 1 <font color='#0000ff'>*</font>";
$locale['ads226'] = "Resim 2 <font color='#0000ff'>*</font>";
$locale['ads227'] = "Resim 3 <font color='#0000ff'>*</font>";
$locale['ads228'] = "Resim 4 <font color='#0000ff'>*</font>";
$locale['ads229'] = "Resim 5 <font color='#0000ff'>*</font>";
$locale['ads230'] = "Resimler";
$locale['ads231'] = "Yakıt Türü";
$locale['ads232'] = "Yakıt Türü:";
$locale['ads233'] = "Araba hakkında ayrıntılar";

// Valg
$locale['ads299'] = "İlan Düzenle";
$locale['ads300'] = "İlanlar";
$locale['ads301'] = "Düzenle";
$locale['ads302'] = "Sil";
$locale['ads303'] = "Aşağı taşı";
$locale['ads304'] = "Yukarı taşı";
$locale['ads305'] = "Sıralamayı Yenile";
$locale['ads308'] = "<font color='#ff0000'>Veritabanında İlan Yok!</font>";
$locale['ads309'] = "Bu ilanı silmek istediğinden emin misin ?";
$locale['ads310'] = "Geri";
$locale['ads311'] = "Arama";
$locale['ads312'] = "<font color='#ff0000'>*</font> Gerekli bilgiler.";
$locale['ads313'] = "Yazdır";
$locale['ads314'] = "İlanlara git";
$locale['ads315'] = "<font color='#0000ff'>*</font> İlan kayıt edildiğinde resimleri ekle.<br />Sonra &quot;Düzenle&quot; tuşuna basarak resimleri yapıştır.";

// Fejl
$locale['ads400'] = "İlan eklenemiyor.";
$locale['ads401'] = "Marka ve model kutusunu doldurun!";

?>
0 replies
— 6 months later —
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

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