Open-Realty [OR]

[ResaleBroker]

Anyone here familiar with Open-Realty [OR]?

[Foxy]

Anyone here familiar with Open-Realty [OR]?
Yep :)

Extensive with all mods

What do you want to know? :)

[Old Welsh Guy]

Great script and it also appears in one or two other guises, including a UK speciific version modded a lot.

[HolyMan]

Yup...... Have used it a couple of times with great success.........

[T0PS3O]

No.

What is it? What is it for? How can it help busy web developers? Any links to an introduction?

Thanks!

BTW. Welcome HolyMan!

[ResaleBroker]

I built a new OR site this weekend, AZ Multiple Listing Service, installed the "PayPal" module and have run into a few hurdles.

#1
The URL that PayPal returns, after a successful payment, has the wrong syntax.

It shows:
mydomain.com/listings/listings//modules/paypal/ppbuy.php?action=success&orderid=[xxx]

When it should have been:
mydomain.com/listings/modules/paypal/ppbuy.php?action=success&orderid=[xxx]


#2
New agents can still add a listing without having to go through PayPal.


#3
Just to be sure, in the readme.txt file 2.4 it says, "Configure your menu for the agent and admin pages of the module." I'm assuming that just means to modify the "admin_top" and "user_top" files, right?

Thank You So Much!!

[ResaleBroker]

Right now, I have a work-around through my own PayPal page but I would really like to use the OR mod.

Any ideas? :confused:

[Foxy]

No.

What is it? What is it for? How can it help busy web developers? Any links to an introduction?

Thanks!

BTW. Welcome HolyMan!

Tops it is for real estate [I have two on the ski site] but it can be used for many things if you use your imagination.

Here it is: http://www.open-realty.org/

It can be altered/worked into many formats eg photo album

[Foxy]

I built a new OR site this weekend, AZ Multiple Listing Service, installed the "PayPal" module and have run into a few hurdles.

#1
The URL that PayPal returns, after a successful payment, has the wrong syntax.

It shows:
mydomain.com/listings/listings//modules/paypal/ppbuy.php?action=success&orderid=[xxx]

When it should have been:
mydomain.com/listings/modules/paypal/ppbuy.php?action=success&orderid=[xxx]


#2
New agents can still add a listing without having to go through PayPal.


#3
Just to be sure, in the readme.txt file 2.4 it says, "Configure your menu for the agent and admin pages of the module." I'm assuming that just means to modify the "admin_top" and "user_top" files, right?

Thank You So Much!!

I went and had a look and noticed that you were using a workround but unfortunately I had to do other things [as I do again today so I will be brief but will come back and fill out the holes later OK?]

First. The mod itself has some sloppy coding - typically, wrong file names. For those who want to get the mod and the discussion here it is:

http://www.open-realty.org/support/showthread.php?t=2777

The ppinstall.php has a link reference to pp_install.php on that page so that needs to be addressed/changed first [it is incorrectly mentioned in the thread].

Then he has forgotten to place a tempid field in billing table so you need to using phpMyAdmin add tempid varchar(20) field to billing_history table

1. I will have to come back to you on the syntax I can't remember what I did/didn't do with this.

2. New Agents cannot list direct withou going though Paypal so I am not sure what you are saying here.

3. Alter the admin_top as that is for your benefit to get to the ppadmin file - but it is not necessary.

Alter the menu.php so that clients come in the correct way for advertising etc.

Be back later/tomorrow :)

[Foxy]

I remembered

The problem lies on ppbuy.php in the form for email

// form for paypal
//button YES
echo "
<form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\">
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\">
<input type=\"hidden\" name=\"business\" value=\"".$fgetPPAdm[email]."\">
<input type=\"hidden\" name=\"item_name\" value=\"Listings for ".$config[site_title]."\">
<input type=\"hidden\" name=\"currency_code\" value=\"USD\">
<input type=\"hidden\" name=\"return\" value=\"http://www.domain.com/open-realty/modules/paypal/ppbuy.php?action=success&orderid=".$fgetOrder[id]."&pass=".$randompass."\">
<input type=\"hidden\" name=\"cancel_return\" value=\"http://www.domain.com/open-realty/modules/paypal/ppbuy.php?action=failure&orderid=".$fgetOrder[id]."\">
<input type=\"hidden\" name=\"undefined_quantity\" value=\"0\">
<input type=\"hidden\" name=\"receiver_email\" value=\"".$config[admin-email]."\">
<input type=\"hidden\" name=\"no_shipping\" value=\"1\">
<input type=\"hidden\" name=\"no_note\" value=\"1\">
<input type=\"hidden\" name=\"amount\" value=\"".$OrderTotal."\">
<input type=\"image\" name=\"submit\" src=\"http://images.paypal.com/images/x-click-but02.gif\" border=\"0\">
</form></td> ";


You need to take out the .config and the php_self and "hardwire" like the above - the problem is with the PHP_self command.

The only problem in the future is that you need to update this information if you use the same for other sites etc.

Some other thoughts for you

1. Rentals don't work exceptionally well as you have them lumped in with Sales because of "client requirements" - this becomes especially difficult when you do Summer and Winter rentals etc so it is perhaps best to create a new database/OR for Rentals

2. There is a listingview.php mod that shows the full/larger picture at the same time as the vertical thumbnails and by clicking on the TN you change the pic without the page changing - a mate has done a job which is quite cool Spain Rental Property (http://www.bookspain.co.uk) and has taken in our Book France (http://www.bookspain.co.uk/bookfrance/) Ski France (http://www.ski-france-ok.com/) Properties to get it up and running. He also has done a car job on the OR AWD Cars (http://www.awdcars.co.uk/).

3. He has used an availabilty Calendar which we don't use as people think that if it is available they should be able to book it but sometimes you have other people waiting so it is a bit of a pain in the butt.

Anyways thats for now

[ResaleBroker]

Thanks Foxy!

I'll change the code tonight and let you know what happens. :)

[Foxy]

Have fun........ :D

[ResaleBroker]

Thanks for the help. It seems to be running smooth as molasses. :D

[Foxy]

Thanks for the help. It seems to be running smooth as molasses. :D

Thats great :cool:

[ResaleBroker]

1. Rentals don't work exceptionally well as you have them lumped in with Sales because of "client requirements" - this becomes especially difficult when you do Summer and Winter rentals etc so it is perhaps best to create a new database/OR for Rentals

Ok, I can't figure this one out.

I am running two (2) instances of OR with two (2) seperate databases. One for "Listings" and one for "Rentals."

Each OR program is in its own directory; "Listings" and "Rentals"

The OR programs themselves run fine but... I am having trouble with the second "Paypal Module."

You can still Add a Listing without paying AND the display is off. Instead of saying, "You have the following amount of Listings..." all I get is a couple of radio buttons and a submit button that doesn't diplay the graphic.

I checked the database and all tables and entries seem to be there. Any ideas?

[ecominski]

Hi all. I've just happened across this site and love what I see. I had downloaded OR last week and am just doing some preliminary work to prepare setting it up. Hope you don't mind if I seek some advice from experienced users?. Any suggestions on a strategy for trouble free startup?. I need to expand my internet account to include the Mysql server and am just now brushing up on that servers interface. I've done plenty of Perl scripting but am somewhat new to PHP. Don't think that will get in my way though. I'll keep you posted on my success. I practice real estate sales as a realtor, but would like to explore the concept of offering FSBO listing services as a prospecting tool.

[john_loch]

Where are you ecominski ?

[Foxy]

Ok, I can't figure this one out.

I am running two (2) instances of OR with two (2) seperate databases. One for "Listings" and one for "Rentals."

Each OR program is in its own directory; "Listings" and "Rentals"

The OR programs themselves run fine but... I am having trouble with the second "Paypal Module."

You can still Add a Listing without paying AND the display is off. Instead of saying, "You have the following amount of Listings..." all I get is a couple of radio buttons and a submit button that doesn't diplay the graphic.

I checked the database and all tables and entries seem to be there. Any ideas?

Can you let me have a look?

[Foxy]

Hi all. I've just happened across this site and love what I see. I had downloaded OR last week and am just doing some preliminary work to prepare setting it up. Hope you don't mind if I seek some advice from experienced users?. Any suggestions on a strategy for trouble free startup?. I need to expand my internet account to include the Mysql server and am just now brushing up on that servers interface. I've done plenty of Perl scripting but am somewhat new to PHP. Don't think that will get in my way though. I'll keep you posted on my success. I practice real estate sales as a realtor, but would like to explore the concept of offering FSBO listing services as a prospecting tool.

1. You do not need Perl
2. You do not need to know php but if you know Perl you will know how to hack.
3. You do not need to use the OR as your index page - you can install it separate to your site and then alter the look in the templates - use the vertical option to start [if you want, as it is set up that way]
4. Upload OR1.1.5 and name the directory eg "white-house"
5. Before setting it going configure the common.php in the includes to point to your database that you have established - the usual is eg real-est_whitehouse, user: real-est_foxy with the user permissions allowed for the database. To establish your database go into your cpanel or vdeck and click on databases and add a database.
6. Alter the other info to give the path etc.
7. Run http://www.yourdomain.com/white-house/configurator.php
8. It should come up ok, click where it says click
9. No red? all is OK
10. Go to http://www.yourdomain.com/white-house/ [Remember to remove the configurator.php at some point]

You should have it up and running in 10 minutes max.

Now for the style.

These are altered in the templates - if you want to use the images for buttons then you need to make the buttons and label them the same - either way it is all in tables and you can move things as you wish starting with the user_top.html and user_bottom.html

I have attached a couple of these hacked that are on the ski site in my sig that will give you an idea

One good thing is to put the "previous - next" stuff at the bottom of listing_browse.php - to do that you need this:next_prev($num_rows, $cur_page, $guidestring_with_sort); // put in the next/previous stuff here just at the bottom:next_prev($num_rows, $cur_page, $guidestring_with_sort); // put in the next/previous stuff

?>


</table>


<?php
} // end if ($num_rows > 0)
else
{
echo "<p>$lang[search_no_results]</p>";
}


include("$config[template_path]/user_bottom.html");
?>

Hope this helps :)

[ResaleBroker]

I figured it out. I somehow skipped install step 2.2

In /include/language/english.php add following line right after $lang = array();
or in "//module language file includes" section if you have installed fullmod

include("".$config[basepath]."/include/language/english/paypal.php");

[ecominski]

Wow, blazing fast responses. I hope I can keep up. I'm up in Calgary, Alberta. You know, 2" of snow last night just north of us. I have successfully set up and have running an ecom site (industry specific) using commerce.cgi. Sounds similar and has an Mysql interface, however I have utilized the flatfile approach in my first application. Uses html templating for clientside. Now if I can just schedule a couple of evenings to do the install. 10 minutes, maybe with the excellent overview that will happen. Thanks for that.

[Foxy]

I figured it out. I somehow skipped install step 2.2

In /include/language/english.php add following line right after $lang = array();
or in "//module language file includes" section if you have installed fullmod

include("".$config[basepath]."/include/language/english/paypal.php");

Good man or Plonker - depends where your coming from hehehe :D

[ResaleBroker]

Yeah, I think I'm going to take my wife's advice and get some sleep. :D

[Foxy]

Wow, blazing fast responses. I hope I can keep up. I'm up in Calgary, Alberta. You know, 2" of snow last night just north of us. I have successfully set up and have running an ecom site (industry specific) using commerce.cgi. Sounds similar and has an Mysql interface, however I have utilized the flatfile approach in my first application. Uses html templating for clientside. Now if I can just schedule a couple of evenings to do the install. 10 minutes, maybe with the excellent overview that will happen. Thanks for that.

You may like to look at http://www.diyhosting.ca/ as an IP seeing you are in Canada [not that that matters as we use it fron here]

Has some interesting open source programs including agora ecom and unlimited dbs but also recently included "fantastico" which installs the stuff [including OR] for you - here is the list:
 
 
Blogs
 
b2
b2evolution
Nucleus
pMachine Free
WordPress

 
Content Management

Drupal
Geeklog
Mambo Open Source
PHP-Nuke
phpWCMS
phpWebSite
Post-Nuke
Siteframe
Xoops


Customer Support

Crafty Syntax Live Help
Help Center Live
osTicket
PHP Support Tickets
Support Logic Helpdesk
Support Services Manager

 
Discussion Boards

Invision Board
phpBB2
YaBBSE

 
E-Commerce

CubeCart
OS Commerce

 
F.A.Q.

FAQMasterFlex


Image Galleries

4Images Gallery
Coppermine Photo Gallery
Gallery


Mailing Lists

PHPlist

 
Polls and Surveys

Advanced Poll
phpESP
PHPSurveyor


Project Management

dotProject
PHProjekt


Wiki

PhpWiki
TikiWiki


Other Scripts

Moodle
Noahs Classifieds
Open-Realty
phpAdsNew
PHPauction
phpCOIN
phpFormGenerator
phpLinks
WebCalendar

Extras

Language
Side menu appearance
Email notifications
Installations overview


Let us know how you get on :)

[Foxy]

Yeah, I think I'm going to take my wife's advice and get some sleep. :D

Ahhh....they're always right.......hehehe :rolleyes:

[awddesign]

Hi

need to know all about OR 1.1.0 to 1.1.5b plus all the mods.
Just let me know ..

regards

Al
http://www.awddesign.co.uk

[ResaleBroker]

Awddesign,
I've read many of your posts over at the OR forum. I'm glad to know you're here.

[Foxy]

Oh.... I can bring him in kicking and screaming into the real world hehehe :D

Seriously though he's good :)

[Foxy]

And he also needs to come here a bit more....hehehe :D

[awddesign]

Awddesign,
I've read many of your posts over at the OR forum. I'm glad to know you're here.

Hi ResaleBroker

Thanks you. Lots happening with my version of OR soon.

Foxy it's just time very bussy at the moment.

I am changing mambo 4.5.1 stable to be AAA standard via bobby.
It's getting on very well with the advent of DDA october 1st.
Supprising about this as soon as people know that I was doing this
I got 3 more orders :)

regards
Al

[Foxy]

Hi ResaleBroker

Thanks you. Lots happening with my version of OR soon.

Foxy it's just time very bussy at the moment.

I am changing mambo 4.5.1 stable to be AAA standard via bobby.
It's getting on very well with the advent of DDA october 1st.
Supprising about this as soon as people know that I was doing this
I got 3 more orders :)

regards
Al

For all of you out there who need his home page it is not the one he listed in the member profile it is

awddesign (http://www.awddesign.co.uk/awd_houses/) but he also has some sites running as OR at

Spanish Property (http://www.bookspain.co.uk/)

and

Ski France (http://www.bookspain.co.uk/bookfrance/)

There is some clever stuff on one of them .....but I can't find it - it is about a site map in php and a listing with thumbnails....ask him

[ResaleBroker]

I am trying to change Dynamic URLs in Open Realty to static URLs. At least in "listingview."

Do you have any ideas on how to accomplish this?

I just added a post for this: http://forums.digitalpoint.com/showthread.php?t=3662

[awddesign]

Hi

added how to at:

forums.digitalpoint.com/showthread.php?t=3662

for you Al

[ResaleBroker]

Thanks for the help!

[ian_ok]

Just want to say thank you for informing the world (& ME) of this software, it's what I've been after for a while......

...Have been doing my own d/b on Access (Hmmmm, yes it's what I know!) but looks like I'll give this a go, of course need to spend a bit more money on the upgrade to include Mysql....

No doubt I'll be back here and on the open-realty forum for a long time before I get it working.....10 mins Foxy.....!

It will take me that long to upload it on 56k!!!!! (the dark ages)

Ian

[Foxy]

Its relatively easy - certainly not frightening or insurmountable:)

mysql - you should have a look at www.diyhosting.ca [rather than paying extra] as they are cheap [ca dollars] and have the openrealty as a fantastico instal [by coincidence] which would make it easier still.

[ian_ok]

Thanks for that.....I'll stick with my hosting company and do some testing first on another site (see below!) the charge isn't much but I'd rather test first before I shell out any more money.

On OR do the pictures have a link from the database to location on my server or reside in the mysql database?

For testing purpose I'm now looking for free web space with php and mysql available.

Anyone know of one?

Ian

[Foxy]

Thanks for that.....I'll stick with my hosting company and do some testing first on another site (see below!) the charge isn't much but I'd rather test first before I shell out any more money.

On OR do the pictures have a link from the database to location on my server or reside in the mysql database?

For testing purpose I'm now looking for free web space with php and mysql available.

Anyone know of one?

Ian

The pictures reside in "listing_photos" in the "image" folder in the root.
I have space on DIY, with OR - for how long?

[ian_ok]

The pictures reside in "listing_photos" in the "image" folder in the root.
I have space on DIY, with OR - for how long?

Hi Foxy,

Thanks for the offer, very very kind of you....less than one month or even just one week...long enough for me to set up a template and test it to see how I get on it. Will be for www.costaandsierra.com website should I get it to function 100%.

Ian

[Foxy]

Will set it up tomorrow morning :)

[ian_ok]

Thanks very much....Probably not on line that much tomorrow.....have pm'd you my email address.

Ian

[awddesign]

Hi Ian

If you need any help just email me from book spain.


Al


Hi Foxy,

Thanks for the offer, very very kind of you....less than one month or even just one week...long enough for me to set up a template and test it to see how I get on it. Will be for www.costaandsierra.com website should I get it to function 100%.

Ian