plainblack.com
Username Password
search
Bookmark and Share

Listings

For up to date Listing Version 1.5 (Free) and 1.6 (Fee) please see my site at www.ca-dev.co.uk

Details of the wobject/asset are listed of the site on the software page.

Thank you

Chris

http://www.ca-dev.co.uk

System RequirementsPlease be advised: this contribution was tested with something older than WebGUI 7.5. When this contribution was uploaded there was no field for the author to fill out regarding it's requirements.
Comments
2ehab: "
It would be nice if this works with profile data too.

Admin could choose fields to include from profile and users can search in them, and in the end have a contact box to send emails through WebGUI.

Ehab Heikal

www.valuecms.com

Quote: An eye for an Eye only helps make the whole world blind

Gandhi

 
"
2ehab: "
I believe if we use the dataform wobject and just add search functionality in it or in another wobject that searches in the data of a dataform we will get an excellent general purpose system.

Use dataform for front end data entry, and create a wobject that allows the admin to set the fields that users or admins can search in and get results.

Ehab Heikal

www.valuecms.com

Quote: An eye for an Eye only helps make the whole world blind

Gandhi

 
"
4ehab: "
Please we eagerly await this Wobject. :)

Ehab Heikal

www.valuecms.com

Quote: An eye for an Eye only helps make the whole world blind

Gandhi

 
"
4tpaikkan: "
I find lists to be more versatile if tree hierarchies are supported. For example, classifieds may be divided into several groups and users are allowed to collapse/expand elements in a group.

Also, if users can define a filter or sort in their profiles, it would be even better. For example, I can only choose to display cars < $2000 and sort by the price, etc.
"
4fishingfan: "
Currently the listings will work with it's own profile data to allow the Admin to select the fields and eventually allow users to search on them.

It is not as yet going to alter the users profile data, though I intend to allow the adding of a link to the users profile that posted the listing.  A way of contacting via WebGUI would be a good idea too.
"
2ehab: "
We are a development company, I could assign some one to help you with this project we are very interested in it to use it as a friend finder, classified and CV tool. IF you think that your design  can accomodate all the above then maybe we can co-operate.

Ehab Heikal

www.valuecms.com

Quote: An eye for an Eye only helps make the whole world blind

Gandhi

 
"
2fishingfan: "
Hi Ehab,

I think that the design should definetely cope with classified adverts, and as a friend finder ( though the search facility for this may not work with my first (BETA) release of the code exactly for this first off, it is one of the aims). 

Not too sure what you mean by the CV tool.  Could you elaborate a bit more ?

I hope to get out an early working example of the code within a week or two all being well.  Some help in refining the functionality would be helpful then I think. 

PS I looked at your site and the WebGUI usefulness page.  Is the limit of 1000 pages & 50,0000 users a server related issue ?  Or a problem with the code - or performance of something ? 

I'd be interested to know why you've come up with these limits, if only in general terms.
"
4ehab: "

The same enigne could be used as a jobs database, where you enter your CV and allowed companies can search in it to find candidates. I could be interested in devoting some programming resources if this wobject is properly designed with internationalization and templeting.

 

As for the page view limits these are based on typical shared hosting. With a dedicated server the maximum I heard is WebGUI being able to handle 1000,000 page views per day. That is a lot but not very big. I believe if you have a well designed multi server system and you do some tweeking you can get much more. WebGUI is very Database intensive run your database on an opteron server with SCSI and your web server on Xeon and you will really get more mileage.

 

As for co-operation you can email me at

 

Ehab Heikal

www.valuecms.com

www.elmotaheda.com

www.mashy.com

 

Quote: An eye for an Eye only helps make the whole world blind

Gandhi

"
4fishingfan: "
That may be possible, I haven't looked at that.

I'm not sure how user friendly that would be to non techy site runners though.

 
"
2fishingfan: "
Hi

Thanks for the suggestions.

I agree that hierachies are a good idea.  I intend to make use of them.  The initial design and code I am working on at the moment has built this in to the design.  The first set of code which I hope to post next week all being well, will not have this fully working as I want to give a general idea of how it is working.  In my final version this should work though.

The filter is possible.  It is just a simple search on the database & something I will be adding as I need it on my site!  Again it won't be in the first release, as I am waiting to see what Len has done in his advanced search wobject, before embarking on this.  Currently it has a simple keyword search. 

Chris
"
4fishingfan: "
Almost there,  just running through some testing now and hunting down the odd bug.  I'll then need to write the install instructions, hopefully time permitting it should be ready this week.
"
2ehab: "I downloaded it and ran it. It is great really thank you for the listing and for mentioning me in the credits.
One question is can normal users (registered ) add listings? I was not able to add listings except in admin"
4fishingfan: "
Hi Ehab,

The permissions is one thing I am still working on.  At present you can only add in admin mode.  I was going to add the following things to the listings wobject and should have mentioned these in the posting, but it was getting late when I uploaded it yesterday.

1) Add proper privilege settings - These will hopefully allow users authorised by the edit tag to add listings/images.  I also intend to allow only the user who posted to alter the listing ( with the exception of the site Admins ).

2) Add a hit counter to the listings.

3) Improve the templates.

4) Add a proper user guide explaining how to use etc.

5) Any suggestions or other ideas.

Chris
"
4fishingfan: "
Hi Ehab,

The permissions is one thing I am still working on.  At present you can only add in admin mode.  I was going to add the following things to the listings wobject and should have mentioned these in the posting, but it was getting late when I uploaded it yesterday.

1) Add proper privilege settings - These will hopefully allow users authorised by the edit tag to add listings/images.  I also intend to allow only the user who posted to alter the listing ( with the exception of the site Admins ).

2) Add a hit counter to the listings.

3) Improve the templates.

4) Add a proper user guide explaining how to use etc.

5) Any suggestions or other ideas.

Chris
"
2ehab: "
Did you test this on the latest versions of webgui?

Ehab Heikal

www.valuecms.com

Quote: An eye for an Eye only helps make the whole world blind

Gandhi

 
"
2fishingfan: "
Hi

The last version I tested this was 5.5.3

I can't see any reason why it should not work with 5.5.4.  Is there a problem ?
"
2pvanthony: "Everything seems to be working fine on 5.5.4.

Just a question. I do not seem to be able to delete the listing type that I have created. How can I do this.

The listing that comes with the Listing Wobject is "Default Listing Type". I have created one called "coy".

I am not able to rename it or even delete it.

Where have I gone wrong?

P.V.Anthony"
2fishingfan: "
You're not doing anything wrong.  You can't do either.

I think adding something to rename the listing type might be a good idea and i'll add it to my next release. 

I had deliberately made it impossible to delete the listingtype from the user interface, primarily because if you delete a listing type from the database and it was in use in a listing on the site then it would cause a lot of problems.

If you want to rename or remove the listing type then I would suggest you do it manually. 

The database tables affected are

listingstype - which holds the id and name ( so you could rename the type by altering the name in this).

Then to completely remove the type find the listingtype id from that table and delete all the fields in the following tables using the listingTypeId as the key.

listingsprofilefield

listingsprofiledata

listingsprofilecategory

Chris
"
4padmewan: "Is there an example of this working anywhere? I'd like to check out the functionality. (Been looking for a way go do volunteer opportunity listings with time / location data"
2fishingfan: "
You can see my latest version (1.3) working on my personal site.

www.fishinginwessex.com

I intend to upload the changes shortly once I've finished the Database Scripts. (they're mostly template changes), but it works in much the same way as 1.2 which is available now).

Chris
"
4fishingfan: "
I meant to add, it is being used on my Local Clubs page at present.

Also if anybody is using it, I'd love to see what you've done with it.  (Mail me or post here).
"
2padmewan: "Hmmm... perhaps I'm being obtuse but I can't seem to find the "local clubs" section. Can you link directly to it?

We are looking to use it for volunteer listings for our nonprofit"
4fishingfan: "
Opps!

My fault I forgot to turn the page privileges off.

Try this direct link, you should be able to see it now!

http://www.fishinginwessex.com/clubs

Chris
"
4Thomas_B.: "
Hello,

I am interest on the listing Wobject. But I have a question for the future. Does listing Wobject work with WebGUI 6.x.x? Does anyone have exerience?

Thanks an cu

Thomas
"
4fishingfan: "
Hi Thomas

It will do.  There's a slight change I need to make to get it to work with version 6.

I will be uploading the new version soon.

OR

Modify the existing file -> Listing.pm

Remove the line

use WebGUI::Authentication;

That I think is all that is needed as I seem to remember when I last tried.

Chris

CA-Dev.co.uk 
"
4fishingfan: "
I have now uploaded version 1.4 for 6.x.x compatabilty.

Let me know if there's any issues.

Chris

CA-Dev.co.uk 
"
2pvanthony: "Thank you for this great listing application.

I was using version 1.3 with 5.5.6 and it was fine. I just upgraded to 1.4 and restarted the apache web server but it reported errors.

I am using WebGUI 5.5.6 on RedHat 7.3 with perl 5.6.1.

The error is as follows.
[error] Can't locate WebGUI/Operation/Auth.pm in @INC

I am back to 1.3.

Please advice."
4fishingfan: "
Hi

Sorry for the delay in replying but I've been away.

The problem you have is one I should have documented. 

The 1.4 files should work fine as is with version 6.x.x

However if you are running 5.x of webgui you will need to replace the supplied Operation.pm file (in the Listings download) with the original Operation.pm file in your existing Webgui installation.

Add in the following line

use WebGUI::Operation::ListingSettings;


And all should work.

I hope to shortly replace this requirement to modify the WebGui files to make it totally release independent. 

Chris

CA-Dev.co.uk 
"
2pvanthony: "Thank you. I will let you know once I have tried it."
2PatrickB: "First of all, there seems to be a bug in the latest 1.4 version (working with WebGui 6.0.3).  After adding a listing and going into Manage Listings, when I click on edit I get the following error :

Software error:

Can't call method "header" on an undefined value at /data/WebGUI/lib/WebGUI/Session.pm line 322.


Also, I can't seem to find where someone can change the status of a Listing from "pending" to "approved".

Thank you,

Patrick


--------
This is the error in the webgui.log

/index.pl FATAL: Couldn't execute statement: SELECT featured,status,expiration,expiryDate FROM listing
                                                                  WHERE listingId = 2
                                                                  AND wobjectId = 58 : Unknown column 'expiration' in 'field"
4PatrickB: "Well, I "fixed" the problem, by changing the line 1012 to

WebGUI::SQL->quickArray("SELECT featured,status FROM listing

                                                                  WHERE listingId = $session{form}{listid}

                                                                  AND wobjectId = ".$self->get("wobjectId"));



instead of

WebGUI::SQL->quickArray("SELECT featured,status,expiration,expiryDate  FROM listing

                                                                  WHERE listingId = $session{form}{listid}

                                                                  AND wobjectId = ".$self->get("wobjectId"));


In other words, I removed the "expiration,expiryDate ".  As to why theses fields where included in the query, I don't understand, since they are not present in the table of the curent version or v1.3 (i even double checked in the SQL create scripts....there's no mention of these fields anywhere)"
4fishingfan: "
Opps!  Looks like you found a packaging problem.

You're quite right the expiration stuff should not be there.  You have correctly fixed it.  I will redo this version package and reupload later.

In the meantime - To change the status of the listing from pending(as that is you're default status is pending) to active.

1) Turn Admin On

2) On the main view screen (or browse) you should now see link to something like "manage listings"

3) Click on this an you should now see the listings with an edit button on the left.

4) Click the Edit button.

5) Change the status drop down to what you now want it to be.

Chris

CA-Dev.co.uk 
"
2PatrickB: "Hi,

When I create a new Listing Type and I add a profile category,  the new profile category id is not different from the ones already given to other categories.

For example,
I created a Listing Type "Garage Sale" and a profile category "Information" that got the ID 1000 whereas the category "Address Information" from the Default Listing Type also has the ID 1000.

This causes a problem when I EDIT a Listing because all the fields with a Category Id 1000 show up.

To fix this, it is probably only a matter of incrementing the Profile Category Id eveytime a new one is added, but I don't know how to do that

Please advise,"
4fishingfan: "
I have not seen this one before.

Could you tell me what version it is you are using please, so I can test it out and fix it.  I am currently assuming it's the 1.4 version you fixed yesterday.

Incidentally, it (theoretically ) should not matter that they listing types have the same profileCategoryId as the database should store a unique listingTypeId.  It is possible that I've missed something in the edit somewhere.

best regards

Chris

CA-Dev.co.uk 
"
2PatrickB: "
I am indeed working with the version 1.4

if you would like to see and example, you can email me at patrick.brosseau@gmail.com and I could set-up an account for you on my site

 
"
4fishingfan: "
I was not originally quite correct in what I said, the profileCategoryId should autoincrement as well.  And it works ok for me on my windows machine.  This is done via line 178 of ListingSettings.pm 

-> $session{form}{cid} = getNextId("profileCategoryId");


Can you perform this check against your database.

SELECT*
FROM`incrementer`
WHEREincrementerId='profileCategoryId' 

It should return the last number.  It is incremented whenever you add a category to the listings or user profiles.

If you don't get a value then something is wrong with your database.  This value is created with the WebGUI core database create file.

You can add a value via

INSERT INTO incrementer VALUES ('profileCategoryId',1000);


Change the last value to the next free number.  Should that fail please contact me via my email (fishinginwessex @ hotmail . com)

Chris

CA-Dev.co.uk 
"
4PatrickB: "
You are right, it does increment and work correctly.  I checked with the query you mentionned and I got the next iD available.

However, there might be something wrong with the create script.  I say this because after installing the Wobject on a new database, the value returned by

SELECT*
FROM`incrementer`
WHEREincrementerId='profileCategoryId' 

is 1000.  This shouldn't be seeing that there already are 2 cartegories included in the package from de Default Listing that have the IDs 1000 and 1001.

To correct this, you should either change the create script to increment the profileCategoryId when you add the Default Listing type or change the starting number for the incrementer to 1002.

If this is done, everything will work perfectly , since after adding 2 categories, the third one worked correctly.

 

Also, is there a way to DELETE a Listing Type other then doing it manualy in the database?

 

Thank you,

Patrick
"
4fishingfan: "
Hi Patrick,

Thanks for the info.

You're right, I've missed this out.  And thinking about it, it is probably a slight bug, in that the profileCategoryId might be changed by custom user profile setups, so maybe a more unique key should be used here.  I will have to fix this in a later version.

I have not implemented a delete listingType in the wobject (yet), on the basis that a fair amount of checking would be needed to ensure the listing types weren't in use on the site, which would cause an error if they were called and not there.  So currently you need to manually delete from the database. 

PS If you're using it on a site that I can see from the internet, I'd love to see what you're doing with it.

Chris

CA-Dev.co.uk 
"
4pvanthony: "Hi,

Currently I am using 1.3.
Have not got time to upgrade to 1.4.
Sorry will do that soon.

Now for the main question.

How to customize the default listing template?
There is a table that list the properties in the main page.
The columns are Listing Number, Title, Date Created, Last Updated and Image.
I would like to change the column names or even have more columns.

So far the whole table is just one variable -

PLease advice on how to customize the main page."
4fishingfan: "
Currently you need to modify the code in listListings part of the listings.pm file.

This may shortly be changing....

Chris

CA-Dev.co.uk 
"
2pvanthony: "Thank you for the reply.

PLease do let us know when the new version will be out.

Thanks again for great wobject.

P.V.Anthony"
2Widney: "
I ´ve installed WebGUI 6.1.1 and can´t install Listings.

I think the problem is about table International which was moved..

What should I do, to run Listings in my WebGUI?



Thank you,


"
2fishingfan: "
Either convert the wobject to 6.1.1 yourself or wait till I release a version. 

I would think you are right in that it will be the internationalisation that is the problem.

Chris

CA-Dev.co.uk 
"
2fishingfan: "
You can get my conversion on my site now for WebGUI 6.1.1

Please note this is BETA standard.  Though it seems to work fine for me, I recommend testing it out before you put into production.  If you find any bugs please let me know.

Chris

CA-Dev.co.uk 
"
4Twinkle: "
Hi,

I installed Listings V1.5.4. voor webgui 6.0.x and before on Webgui 5.5.7, added the line in Operations,
uncommented and commented the lines as stated in the notes.

I can add listings and listingtypes without problems, but they aren't returned in the overview (and they have active as default new listing status) or in the manage or browse listing admin links.
I don't use the expiry date and all browse options to "yes".

The values are inserted in the SQL ok it seems.

What is going wrong?

I noted that the dropdownboxes with adding a listing where not properly filled (i.e. first line "{" second line "Alabama =>'Alabama'," etc.)

Thanks in advance!

Stef

 

 

 

 
"
2fishingfan: "
Hi

1) For the listings not appearing on the main browse.  Are you using any other language other than English ?

2) As for the dropdown boxes, you need to edit the default so that they are entered without the =>

Just type them in as a list.

Eg

Item1

Item2

Item3

etc

 

Chris

CA-Dev.co.uk 
"
4fishingfan: "
One other thing apart from the non-English problem (which I have a fix for, that I will post soon for) that can prevent the listings from being seen is if you are not using the "Default Browse" option.

If you use the default browse it will list your items using the first profile field in your list.  If you use the "non default browse" option you will need to make some (at least one) profile field "viewable in browse" otherwise nothing will show.  I don't think my example listing fields have any of these set to "Yes". 

Chris

CA-Dev.co.uk 
"
4Twinkle: "
Thank you for replying!

It's solved now.
One thing which was (and still is) a bit strange is some sort of caching of MySQl. Values seem to disappear and appear from the International table, querying the DB gives back different results all the time on this table.

Caching of the page is set to 0 seconds, so that was not the cause.
The default browse option and dropdown were newbie mistakes on my site. I'm currently working on some sort of general code for the browse listing part, to easy adjust the lay-out the look and feel from outside the wobject.

As soon as I got good results I'll get back.

Thanks again!
Stef

 

 

 
"
4fishingfan: "
Good luck with the general code.  I will be pleased to see any results you get.

I've not come across this disappearing values from the international table myself.  If you find out what is causing this or have more info on what is occuring please let me know.

Chris

CA-Dev.co.uk 
"
3Twinkle: "
Hello there,

I made a new page in Webgui with a style to make a layout with two possible template positions.

In the first position I put the Listings Wobject, and on the second a Macro snippet.

When you have the overview of the listings it looks fine, but I would like to keep the Page Style with clicking on a listing to see it's details. At this moment the second template position (with the macro) disappears when ViewDetails is called. Is there a way to preserve the page style where the original wobject was placed?

Thanks a lot!

Stef

 

 

 

 
"
2Twinkle: "
solved it already.

The page positions were ofcourse set in the page template (not style..)

To get the same display, I just had to copy - paste the Page template code arounde the View Details Template code and it al looks fine.

luckiliy I didn't waste too many ppl's time

(I couldn't find a way to delete my thread again..)

Stef

 

 

 

 
"
4pvanthony: "Hi,

Found an error during an upgrade from 1.4 to 1.5.

The error is found in file: update-Listings1.4-1.5.sql

line 69
DELETE FROM `international` WHERE 'internationId' = '30' AND namespace = 'Listings' AND languageId = '1';

Corrected
DELETE FROM `international` WHERE internationlId = '30' AND namespace = 'Listings' AND languageId = '1';


output from diff
69c69
< DELETE FROM `international` WHERE 'internationId' = '30' AND namespace = 'Listings' AND languageId = '1';
---
> DELETE FROM `international` WHERE internationalId = '30' AND namespace = 'Listings' AND languageId = '1';


P.V.Anthony"
4fishingfan: "
Thanks for pointing that out.

Chris

CA-Dev.co.uk 
"
Download
LinksNo Support Offered
Statistics Downloads: 242
Views: 25732
Rating: 3
Updated: 8/12/2005
Keywords Assets
NavigationBack to the Bazaar
© 2018 Plain Black Corporation | All Rights Reserved