Open-RealAutos (Plugin Release 3)

[RealtyOne]

Plugin Release 3
What Is It:
This mod allows you to run two areas useing the same database and user info. In its default form it is setup as a vehicles section thus the name Open-RealAutos however like open-realty itself it can be easily altered to suit whatever you want it to be.
While it is getting to be fully integrated it has been left as unobtrusive as possible with very few changes and no effect on the main scripts other that a few links etc.
Installation:
Easy with a few minor changes to your templates for links and one change to the common.php. All instructions are written in the module_instructions.html.
Compatibility:
Any version of Open-Realty above version 1.0.0 (with dbprefix) with no interferance to any mods allready installed (that i know of.)
Features:
All member functions, Featured Listings, Send to friend, Moderation, Expired listing, Java listing view and appointments + more to come.
Warrenty:
No Warrenty is given or implied in any way. If you backup your site and your database before installation this mod will in no way effect your current site (except in notified file overwrites) so no warrenty is required to make you feel safe.
I am a low grade programmer not a high grade insurence salesman.
Support:
Support for this module will be given in this thread only. Mostly within 12 hours of your post.
Upgrades:
All upgrades will be notified in this thread and will be made as easy and unintrusive to your site as possible.

Current version Plugin Release 3
The last release included only a change to the save search link on autobrowse.



LIVE PLUGIN DEMO : http://www.outbackweb.koalacountrytraders.com.au/realauto
LIVE FULLMOD DEV : http://www.outbackweb.koalacountrytraders.com.au/or_portal/

[marcus]

Hi realty-one

Already done with my installing and therefore send you in attachment some minor bugs to fix for other users.



Some small bugs and the solution in case using MOD autoreal so that people can upgrade if they want.

1) In the file "template/user_top.html" change the following line

<div align="center" class="small">printer friendly page -- <a href="<?php echo $PHP_SELF."?listingID=$listingID"; ?>">return to normal view</a>

to

<div align="center" class="small">printer friendly page -- <a href="javascript:history.go(-1)">return to normal view</a></div>

so that it works, both for open-realty and auto-real. (included small HTML </div> endtag missing).


Until next time

Greetings,
Marcus

Developers Note: The above changes have not been made to the package since no templates are currently provided.
These must be made by the end user.

[RealtyOne]

@ Marcus.
Thanks for the bugfix. It was actually a missed file in one of the upgrades. This page had been done at the start of development but got lost in the continual upgrades.
It was not the only one and i sincerly hope after you nudged me into checking that i have got them all.
@ All Interested
The main mod and the mods mods have been updated.
The update is also the first public release as safe to use.
As with all mods please be sure you backup your files and database before installing and definately read the included files even if they are not accurate they are a help :)

The only difference may be in the location of the language variables. The package has them in the auto_main.php but instruction may have them elsewhere. Configuration settings are also in the auto_main.php.

So there ya go Enjoy the mod which allthough not named in the files is complete due to the help of Marcus and dbflash with debugging and testing. Ryan (AKA GreenGiant) for a great starter script in Open-Realty and years of tech help to me :) . The java image mod is available thanx to Mick` for the original script. And finally you the end user for being there waiting for silly scripts like this to appear.

[marcus]

As I'm still checking the last utilitys of the mod I found another small bug and give the solution in case using MOD Open-Realautos with the Mortcage calculator


The file " auto_install.php" (MySQL tables) has on line 33 "price" as field_type and "retail" as field_name in:

$sql_insert[] = "INSERT INTO ".$config['table_prefix']."autoformelements VALUES....
(6, 'price', 'retail', 'Retail price', '', '', 6, 'Yes', 'top_left', 'No', 1, 'minmax', 'Retail Price', 5000, 'No')....
shut it be?
(6, 'price', 'price', 'Retail price', '', '', 6, 'Yes', 'top_left', 'No', 1, 'minmax', 'Retail Price', 5000, 'No')

Because of this the "price" don't shows up with the popup window.
Need to change the DBase field name.

Atention!!! Users who are working yet with the MOD and installed the tables don't change it if you have already cars listed, instead do the following:


In the file "autoview.php" just change in the line
<a href="javascript:open_window('autocalc.php?price=<? renderSingleautoItemRaw($autoID, "price"); ?>')">
the word "price" into "retail" to get the price in the mortgage calculator. (or loan calculator)

-----------------------
An other thing is that the Open-realty mortgage isn't the right one for an autoloan calculator.
So I make a adaption of the one maked by COMPWOLF member on Apr. 20/2004 (thanks)
http://www.open-realty.org/phpBB2/viewtopic.php?t=3375
(who has fine extras) so it can be used specially for autoloans calculation with the mod of Open-Realautos.

Download it in this post.
RealtyOne you can maybee insert it in the MOD package.

[RealtyOne]

Main Package updated to include the fix for the default database entries on installation by Marcus.

@Marcus.
I have not included your calculator to the package since a calculator is supplied allready. If people want to upgrade with the attachment i see no problems that could be hazardous.

Question:
Is anyone interested in the continued development of a package that is prebuilt useing Open-Realty 1.1.5b this mod as well as many other included mods some that have never been seen.
Enough intrest will get this project underway so show your intrest here please.
Note: the development for this package would be the same site as the demo site currently used for this mod. Current work can be seen there.
(Link in first post.)

[janc]

I fan off prebuild releases... so yes please, it's far more simple than adding all these mods a part.
I was following this tread and i'm interested. But if there will be a preinstalled version i'll wait for that. Thanks

[marcus]

@RealtyOne

Maybee later I jump into the boat.
Now first finish a website of a customer wiht the MOD of autoreal, when done and live I shall advice you.

You are talking about unpublished MODS...
Are they for for autoreal? If yes why don't send them to me to take a look at it and if I can use them.

[greengiant]

main_auto.php remove line 77
include&#40;"$config&#91;template_path&#93;/admin_top.html"&#41;;

Thanx Ryan MAIN PACKAGE ALTERED TO REMOVE THIS BUG - RO

[halyfax]

Files to be altered:
Your Site Menu (what file is this that I have to change?)


<a href="<?=$config&#91;'baseurl'&#93;?>/auto_browse.php">Browse Vehicles</a>
<a href="<?=$config&#91;'baseurl'&#93;?>/autosearch.php">Search Vehicles</a>
<a href="<?=$config&#91;'baseurl'&#93;?>/members/userautofavorites.php?action=list">List Favorites</a>
<a href="<?=$config&#91;'baseurl'&#93;?>/members/userautosearch.php?action=list">Saved Vehicle Searches</a>


Same with "Your Administration Menu at your admin secure area in the menu" what file would I add this to???

Thanks

Edit I found where to edit the user menu but having trouble editing the admin_top.html file I keep getting parse errors when I paste the code in

[halyfax]

I found if I changed the admin menu code to this it works.

[code]<a href=\"$config[baseurl]/admin/add_auto.php\">Add A Vehicle</a>

[RealtyOne]

@ janc
I would not advise waiting for it since it may never happen. Premods take some time to get working correctly and installing in a simple manner that is acceptable by different users the project will not even start on minimal intrest.

@ Marcus
The mods that would be included have never been released and the only reason they would be now is in a complete package and this only becouse they are of no use after the release of version 2. Since they are still paid mods i will not be releasing any of them as drop in free mods sorry.

@ halyfax
Since i have not supplied any templates for the system the information given is the same as used within my own layout and may not be suited to everyones.
The general layout of the link is all that is really required or at least just an idea on what pages to link to that is what i have given but you may need to alter the info to suit your own templates.

[marcus]

A small language bug in file "auto_browse.php"

I think need to change line 440

where is $field_caption = "Title";
with $field_caption = "$lang[admin_listings_editor_title]";

so that on the auto-browser page the text apaers in the language we are using.
Or isn't it right?

[marcus]

Realty-one

See live open-autoreal in spanish. I'ts a pre release for my customer but you can see that it works.

http://www.suauto.biz/dbase/autosearch.php

[RealtyOne]

A small language bug in file "auto_browse.php"

I think need to change line 440

where is $field_caption = "Title";
with $field_caption = "$lang[admin_listings_editor_title]";

so that on the auto-browser page the text apaers in the language we are using.
Or isn't it right?

Since i have not in any way tested this in a multi lingual enviornment i cant in all honosty say its correct or false.
But since all data used on the page is in some way derived from the database includeing captions and autoname i cant see why this would be required. Title is an unchangeable field and autoname is carried through the temp tables at least from what i am seeing in the code.

Auto name is a direction on what it must be sorted by and i honostly do not see how useing the language file enters the equation at the point you have it. If title is changeable for in a standard install then the code would need to be something like
$field_caption = $lang[admin_listings_editor_title];
$field_name = "autoname";
but autoname is used by the sort feature by my reading so i see no working benifit in altering it there.

Anyone else able to comment on this?

[marcus]

@RealtyOne

The package don't have the file "saveautosearch.php"
called by clicking on the autobrowse page if member want's to save his search.
Regards

[RealtyOne]

@Marcus;
The link is incorrect. At the original build the mod used this page the name of the page is userautosearch.php and is now used for all the save search functions for autos.
So it should be like this

echo '<a href="'.$config&#91;'baseurl'&#93;.'/members/userautosearch.php?'.$guidestring.'">'.$lang&#91;'save_this_search'&#93;.'</a><BR>';
This is another error left from the full package to the plugin since the package doesnt use this link.
Anyways still my fault so accept my appoligys. and thanx again :)

Main Mod has been upgrade to include this fix

[marcus]

@RealtyOne

My last one is the same as a lot of people...
The minmax just gives 0.00

Your demo autoreal site look to have the same problem.
Because it seems that it works by a lot of people wit open-realty.

@Realtyone
Maybee this give you a hint

When I change the type in "number" and range 2000000 i get prices in the box, but started with the minimum range set up and stops with the highest auto price.
So the max. price is given but not the minimum, of course missing the string money string.
take a look
Thanks

[RealtyOne]

i am looking into this Marcus however time is a bit short so it may take a little time.

so far i have found that the in the default database the listing is not being correctly priced. and that after doing this there is no price being shown so somewhere in the script i am losing the price field.
I can not do this any faster than i am so even if that is very slow please be patient i will work it out or keep trying.

If anyone else works it out please post. :)

[marcus]

@RealtyOne

About the minmax boxes:
Something is wrong in the file "auto-main.php" from line 1398 and line 1434

I did the following hardcode changes on those lines
if ($price == True)
{
$min = $conn->GetOne("select min(field_value +0) from ".$config['table_prefix']."autodbelements INNER JOIN ".$config['table_prefix']."autodb ON ".$config['table_prefix']."autodbelements.auto_id=".$config['table_prefix']."autodb.ID where field_name = '$browse_field_name'");
$max = $conn->GetOne("select max(field_value +0) from ".$config['table_prefix']."autodbelements INNER JOIN ".$config['table_prefix']."autodb ON ".$config['table_prefix']."autodbelements.auto_id=".$config['table_prefix']."autodb.ID where field_name = '$browse_field_name'");
}
else
{
$min = $conn->GetOne("select min(field_value +0) from ".$config['table_prefix']."autodbelements INNER JOIN ".$config['table_prefix']."autodb ON ".$config['table_prefix']."autodbelements.auto_id=".$config['table_prefix']."autodb.ID where field_name = '$browse_field_name'");
$max = $conn->GetOne("select max(field_value +0) from ".$config['table_prefix']."autodbelements INNER JOIN ".$config['table_prefix']."autodb ON ".$config['table_prefix']."autodbelements.auto_id=".$config['table_prefix']."autodb.ID where field_name = '$browse_field_name'");
}
echo ''.$lang['from'].' <select name="'.$browse_field_name.'-min">';
$options = '<option></option>';
if ($price == True)
{
for ($i = $min; $i <= $max; $i += $step)
{
if ($i + $step > $max)
{
$i = $max;
$z = number_format($i, 2, ',', '.');
$y = money_formats($z);
$options .= '<option value="'.$i.'">'.$y.'</option>';
}
else
{
$options .= '<option value="'.$i.'">$'.number_format($i, 2, ',', '.').'</option>';
}
}
}

...now it is working!

Of course this is not a final solution because i'm not a specialist in script.
You must find the solution in this part, because with my changes part of the "number_format" and the "money_format" are hardcoded.

Meanwhile people can just change this part of the script and adjust the number and money_format as if needed in the following lines:

{
$i = $max;
$z = number_format($i, 2, ',', '.');
$y = money_formats($z);
$options .= '<option value="'.$i.'">'.$y.'</option>';
}
else
{
$options .= '<option value="'.$i.'">$'.number_format($i, 2, ',', '.').'</option>';
}
What do you think about it?

[greengiant]

RO, in the upload funciton for the auto script, you forgot to chmod the uploaded file. I have a fixed file here someplace, IM me later and i will dig it up out you need it.

[AdamP]

Where can I get this mod?

[kevnotts]

Do i have to change all the forms in the admin area to allow people to list vehicles? as default is still all about homes.

[liquidgfx]

Problem: Featured dropdown not updating database when modifying the listing

Fix: IF you open these 2 files and seach for featured. you will notice that some of the code has featuredAutos and featuredListings.

Just change all featuredwhatever to featuredListings and it will work fine.

[zico]

Hi!

A little bug preventing full image display for a specified auto. In file /include/auto_main.php line 596:



echo "<a href=\"$config[baseurl]./viewautoimage.php?imageID=$imageID&amp;type=auto\"> ";


should be changed with:


echo "<a href=\"$config[baseurl]/viewautoimage.php?imageID=$imageID&amp;type=auto\"> ";

(withount the point after [baseurl]). Not doing this you will get a 404 not found error message when trying to display full image of an auto.
Regards!

[RealtyOne]

Current version of this mod can be viewed at http://www.outbackweb.net. You must be logged in to view the link to it below the page header.
Note: The version on the site is NOT this version many alterations have been made and more will be made in the near future.
Also: It is NOT available for download only for testing.

[kevnotts]

Keep getting this sql error when i view a vehicle:

62.254.0.34 -- July 28, 2004, 1:43:27 am -- SELECT active, user_ID FROM default_autodb WHERE ID = ''2''

Look at www.carsalesite.co.uk

Thanks.

[RealtyOne]

cant see why it would be making the error but i would guess at its being something to do with its status of active/inactive.
I do know of a few bugs in this version with that part of the script.
if the listing is inactive you will still see it as a featured listing and be able to open it by clicking the link by rights it should not be available as a featured listing if it is inactive.
This may be a bug in the overall script or something i missed for the mod i am working on this as time allows so i will work it out in time.

Let me know if your listing is inactive or active so i can have a look for your problem.

[kevnotts]

Yes, its active :(

[kevnotts]

Found the problem, I have modified the template "vertical-menu" and it seems to effect the listing. Just replace the orig file and it works ok.

[kevnotts]

I think i'm gonna cry :x ...I got the site to work but now I can't see any of the site admin links on the admin page ie: used to show links to edit vehicle etc...as well as the normal or links. It just shows the or links now...I've reinstalled like 3 times and the links are just not showing. Also the index used to change when I installed the plugin but now that remains the same...what the hell is going on ?!?!? :sad:

[RealtyOne]

without knowing the alterations done helping is not going to happen since i would not know where to start from your description :(

[kevnotts]

No alterations...I install OR then I install the car mod straight from zip....nothing is changed apart from the common.php for the database connect.

[kevnotts]

ok...EVERYTIME I change the damn template I get an error:

62.254.0.34 -- July 30, 2004, 11:25:03 am -- SELECT active, user_ID FROM default_autodb WHERE ID = ''1''

Whats this mean and how do I fix it??

[kevnotts]

OK I figured it out, everytime I put a feature listing code in the menu.php instead of the menu it gives me an error. Is there a way around this?

[RealtyOne]

i dont see how in any standard setup you would be calling user_ID for featured listings?
this is standard code for featured listings.
$sql = "SELECT ID, Title FROM " . $config['table_prefix'] . "autodb WHERE (featured = 'yes')";
as you can see it has nothing to do with users.

Check the function you are useing and be sure it has the red code .

function function_name()
{
global $conn, $lang, $config;
$sql = "query here";

[jaybird2024]

How can we edit the add_auto.php like the add_listing.php to work with the paypal module? or would it require more?

[jaybird2024]

How hard would it be to modify mls import feature to work with auto plugin. this auto plugin rocks! It should be added to the core of OR!

[kevnotts]

yea it should be, if the damn feature code would stop messing up all the time. I get it working and do nothing to the site I don't even look at it, a few days later, I can't make any autos featured. It just reverts back to saying "no" next to feature after I put it to "yes". Drives me mad!

[the_sandking]

yea it should be, if the damn feature code would stop messing up all the time. I get it working and do nothing to the site I don't even look at it, a few days later, I can't make any autos featured. It just reverts back to saying "no" next to feature after I put it to "yes". Drives me mad!

I don't know anything about this MOD, but that particular problem sounds like your "listing" has expired..

[kevnotts]

How come the listing is still listed then?

[kevnotts]

Oh great...now it says "passwords cannot be blank" when someone tries to register.....even though the password section isn't blank. This mod needs to much work, I suggest another developer has a go.

[Caleb]

why don't you take a bash at it then.

[kevnotts]

Am I a php developer?.....no...all i'm saying is before releasing stuff like this why can't they check it works properly?

[the_sandking]

Am I a php developer?.....no...all i'm saying is before releasing stuff like this why can't they check it works properly? Welcome to the world of open source.. If you have ever read any of the license or disclaimers that come with open source apps you will likely notice the part that says "no warranty", "no guarantees" and etc..

This is a unsupported MOD (as noted by the author) to an existing *stable* program called Open Realty, and as such, you are on your own. In fact, almost all 3rd party MODS for open source apps are not 100% cooked, and you are expected to understand this, and be in a position personally to deal with problems if you are currently lacking in knowledge/experience.

However, if you were posting questions at the "Open Autos" website I would have to agree with you 100%.

[kevnotts]

Theres an open autos website?