Mary's Classifieds

[Christos Teriakis]

damn another error is there still on the new add i posted,just clicked on category where the add is posted

Fatal error: Call to undefined function sendmail() in /home/netwo103/public_html/microclassifieds/datagrid/class/phpmydatagrid.class.php on line 24

I'll fix it, as its my fault. When I tried to fix your previous error I added this line of code to send you email with error details. I thought that you had sendmail in the usal path. But again, this means that you've errors there. Something is wrong with your 1st post. Try to delete it.

Chris

[fwulfers]

I'll not remove the current functionallity. The extra fields as is now will be there. The 5 fields that I talked about before are for those who want to have 5 additional searchable fields in the search form.I can't seem to find these fields. Is this not available in the current 5 version or am I completely missing this feature?

[Christos Teriakis]

on the ver 5 the rss feed close X in top right doesnt close the box it bring you back to the homepage. is that a bug?

This is normal. While you're in the homepage, you'll remain in homepage if you close the popup. To be redirect to RSS page you must click Get RSS at the bottom of the form.

Chris

[Christos Teriakis]

I can't seem to find these fields. Is this not available in the current 5 version or am i completely missing this feature?

Not yet, sorry. Its the next step.

Chris

[Christos Teriakis]

Thanks for this great mod. Installed it and like it a lot!!
I just would like to change one thing for my site.
I only want to offer the "auction" option.
Could you point me where I have to change this in the .php files.

Thanks
Michael

Very difficult to do it Michael. There are so many places that need to change.

Chris

[Christos Teriakis]

also in the admin control panel the only option i can select is general options everything else comes up blank

Try the very old trick. Logout and login again. There is no other explanation as it works.

Chris

[maineGuy72]

This is normal. While you're in the homepage, you'll remain in homepage if you close the popup. To be redirect to RSS page you must click Get RSS at the bottom of the form.

Chris

i guess i didnt explain myself well

when i am on the classified page the rss box is at the top when i try to close the box i get redirecteted to home page

see screenshot

[maineGuy72]

Try the very old trick. Logout and login again. There is no other explanation as it works.

Chris

i tried it. any other suggestions?

[NTMID8]

on the ver 5 the rss feed close X in top right doesnt close the box it bring you back to the homepage. is that a bug?

This is normal. While you're in the homepage, you'll remain in homepage if you close the popup. To be redirect to RSS page you must click Get RSS at the bottom of the form.

Chris

i guess i didnt explain myself well

when i am on the classified page the rss box is at the top when i try to close the box i get redirecteted to home page

see screenshot

Same thing here. I would expect that if you click the X to close the RSS box on the homepage of the Classifieds, you would stay on the homepage of the Classifieds. Instead, you are taken to the homepage of the Forums. This can't be right?

I find the RSS box to be pretty intrusive anyway. Wouldn't it be better to have it minimized with just a Get RSS button that would then expand the RSS options window?

Otherwise, everything looks great! Two thumbs up!

[Mariner1]

ok deleted all test posts and made a new one,still get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/microclassifieds/datagrid/class/phpmydatagrid.class.php on line 24

[Christos Teriakis]

Same thing here. I would expect that if you click the X to close the RSS box on the homepage of the Classifieds, you would stay on the homepage of the Classifieds. Instead, you are taken to the homepage of the Forums. This can't be right?

I find the RSS box to be pretty intrusive anyway. Wouldn't it be better to have it minimized with just a Get RSS button that would then expand the RSS options window?

Otherwise, everything looks great! Two thumbs up!

Yes it's true. Now I seen that this is still on my Todo list. I added the code to the home page just for testing purposes, but I forgot to include it to the other templates. Actually is just a line of code which I need to repeat 4 more times.

Chris

[Christos Teriakis]

ok deleted all test posts and made a new one,still get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/microclassifieds/datagrid/class/phpmydatagrid.class.php on line 24

Later today I'll try to give a look in your site. You've messed something there.

Chris

[Mariner1]

Thanks Chris appreciate your help

[NTMID8]

Yes it's true. Now I seen that this is still on my Todo list. I added the code to the home page just for testing purposes, but I forgot to include it to the other templates. Actually is just a line of code which I need to repeat 4 more times.

Chris

Is it something quick we can fix ourselves?

[maineGuy72]

Thanks Chris appreciate your help

yes thanks for the help and love the mod. been running it for alot 8 months with no issues. really like the upgrades you have been doing

[Christos Teriakis]

Is it something quick we can fix ourselves?

Let me do it. Is easier for me, than to list the places that you need to enter it. I also want to add another line for showing details of MySQL errors in datagrid. I'll be back with the update in half hour.

Chris

[maineGuy72]

Try the very old trick. Logout and login again. There is no other explanation as it works.

Chris

does it matter than the forum is not running in a folder called forums?

[DannyITR]

Installing and playing around with it now. Looks fantastic. Is there any way to import forum posts into this system so I don't loose all of my for sale posts.

Also I think the links for "post new ad" should be much more apparent. Took me a few minutes to find them and I'm used to vbulletin. For the general public it would be hard to use.

[fwulfers]

I can't seem to find these fields. Is this not available in the current 5 version or am I completely missing this feature?

Not yet, sorry. Its the next step.That was the most important change I was waiting for.. :( Ah well, I guess I need to have a bit more patience. You can't please everybody, eh? It's great you made this latest version available. Thanks so much for that.

I installed this latest version and I noticed the extra fields are showing up in the seller details section, not with the Classifieds details. That doesn't really make sense..

[dgparent]

Thanks for fixing it I just installed this and thought I messed it up

Let me do it. Is easier for me, than to list the places that you need to enter it. I also want to add another line for showing details of MySQL errors in datagrid. I'll be back with the update in half hour.

Chris

[Christos Teriakis]

Hello,

A short update (ver.5.0.4) to correct:

1.- Missing RSS parametters in pages other than homepage.
2.- Adding log MySQL errors in the file microclassifieds/datagrid/logs/dataerror.log which you must CMOD 666

To upgrade:

1.- Upload classifieds.php to main directory
2.- Upload microclassifieds/datagrid/logs/dataerror.log to microclassifieds/datagrid/logs/dataerror.log (and CMOD it 666)
3.- Import product-microclassifieds.xml

Chris

[DannyITR]

Some things I'd like to comment on.

Is there a way for users to pay before posting premium ads? If so the random newest owner box should have the option to be disabled since this is in effect what the people would be paying for.

In the profile, the controls for your classified settings are hidden in with the other options. I think they should have their own box under My Messages and above My Subscriptions. I'm trying to think like a user who is used to a craigslist type website and would expect easier navigation.

As mentioned already the post new ad links should be big and apparent and the RSS box should be defaulted to off.

Other than that I think this hack is amazing.

[DannyITR]

Oh and I forgot..my thumbnails didn't appear when I uploaded them.

The location option puzzles me as well. It's a mandatory dropdown and I need to give all the options. Would it not be easier for the user to just input this themselves? I'd have to put in every city and town on earth now.

Currency is limited to USD?

When posting an ad I think the add photos options should be more prominent and next to the ad description text box rather than down at the bottom with the shipping options.

[voglermc]

Are there any instructions to setting this up and posting your first item?

[dgparent]

Thanks but it still redirects you to the main forum page when you close the RSS feed box now it is worse as the rss feeds thing shows up on each page instead of just the 1st one ??


Hello,

A short update (ver.5.0.4) to correct:

1.- Missing RSS parametters in pages other than homepage.
2.- Adding log MySQL errors in the file microclassifieds/datagrid/logs/dataerror.log which you must CMOD 666

To upgrade:

1.- Upload classifieds.php to main directory
2.- Upload microclassifieds/datagrid/logs/dataerror.log to microclassifieds/datagrid/logs/dataerror.log (and CMOD it 666)
3.- Import product-microclassifieds.xml

Chris

[DannyITR]

Are there any instructions to setting this up and posting your first item?

Basically you download the file, upload the contents of the upload folder to your forums root folder and then import the plugin. To post an ad click the new classified tab and just under it you'll see a new link to post to classifies.

[Christos Teriakis]

@DannyITR
@voglemc
--------------
That's why I wanted some more days to release it, but as you can see most members bomb me to do it right now. I'm writting some instructions, hope that tomorrow I'll be able to post some of them here. Till then, I'll appreciate if other members, who are more familiar with this mod, help the others. Actually this is the real meaning of the open source. Everybody does something that he/she can do.

Chris

[maineGuy72]

Chris your doing great thanks for your hard work

[fwulfers]

The location option puzzles me as well. It's a mandatory dropdown and I need to give all the options. Would it not be easier for the user to just input this themselves? I'd have to put in every city and town on earth now.This can be changed from a dropdown to a text field in the AdminCP settings

[DannyITR]

This can be changed from a dropdown to a text field in the AdminCP settings

Perfect!

And yes Chris I think you are doing simply amazing work. The product is pretty much release ready as is so I'm happy you let us play with it. I would still love to know your thoughts on my suggestions.

[Christos Teriakis]

Perfect!

And yes Chris I think you are doing simply amazing work. The product is pretty much release ready as is so I'm happy you let us play with it. I would still love to know your thoughts on my suggestions.

Please a bit later for suggestions Danny. Currently let's focus on fixing bugs. But I've read them. Just no time to reply right now.

Chris

[Christos Teriakis]

That was the most important change I was waiting for.. :( Ah well, I guess I need to have a bit more patience. You can't please everybody, eh? It's great you made this latest version available. Thanks so much for that.

I installed this latest version and I noticed the extra fields are showing up in the seller details section, not with the Classifieds details. That doesn't really make sense..

No sad faces please. You'll have them till Sunday, even if I've to work 24/24h. I gave my word and I'll keep it.

Chris

[Christos Teriakis]

Thanks Chris appreciate your help
I fixed it, but something causes problem in your installation. Most probably the Tweets as I can see it double in the iframe.

Chris

[Christos Teriakis]

Thanks but it still redirects you to the main forum page when you close the RSS feed box now it is worse as the rss feeds thing shows up on each page instead of just the 1st one ??

I can't duplicate it. Check at: http://www.christeris.net/vb4/classifieds.php
What's wrong if the link appears in all pages? It's just a link.

Chris

[DannyITR]

I can't duplicate it. Check at: http://www.christeris.net/vb4/classifieds.php
What's wrong if the link appears in all pages? It's just a link.

Chris

It still does the same for me. The RSS box is open by default and clicking X brings you to main forum page. I installed 5.0.3 and then upgraded to 5.0.4

[maineGuy72]

I can't duplicate it. Check at: http://www.christeris.net/vb4/classifieds.php
What's wrong if the link appears in all pages? It's just a link.

Chris

its not the link that is appearing it is a big rss feed box that takes up the top part of the screen

[Christos Teriakis]

Have you ALL voted it as MOTM?? :D If not do it now at:
https://vborg.vbsupport.ru/showthread.php?t=267754

[DannyITR]

Have you ALL voted it as MOTM?? :D If not do it now at:
https://vborg.vbsupport.ru/showthread.php?t=267754

Definitely voted. Anyone know if the MOTM is a hack that we can download ourselves? It's a great system.

[Christos Teriakis]

its not the link that is appearing it is a big rss feed box that takes up the top part of the screen

hmmmmmmmmmm.............. I seen it before in another installation, but most probably it comes (at that installation) from a Tweets javascript that he has there. Do you've something like this too? If yes, can you temporary turn it off?

Chris

[dgparent]

It is not just the link the whole RSS box is there if you click on the X to close it it brings you to the home page. On yours you just have the link and when you click on it a popup comes up which is cool, on mine the whole RRS box is open and when you click on the X it redirects to the home page

http://www.collegefootballforum.info/classifieds.php

I can't duplicate it. Check at: http://www.christeris.net/vb4/classifieds.php
What's wrong if the link appears in all pages? It's just a link.

Chris

[dgparent]

I disabled the only thing I have like that and still get it ? Here are my mods :

vBulletin 4.1.5
Add Mass Child Forums 1.0 beta Add multiple child forums to a parent forum

AME 3 3.0.1 Auto Media Embedder and Video Extender

Digital Point Position Ads 1.0.0a Allows you to insert ads into your forum at various positions.

dmActivityStream 1.1.1 Displays a stream of activities by users.

Gravity Insights 2.1.0 Gravity Insights Community Analytics

Hasann - Sub-Forum Manager 4.0.1 Sub-Forum Manager by Hasann

microCLASSIFIEDS 5.0.4 General Classifieds


Separate Sticky and Normal Threads 4.0.1 Separate Sticky and Normal Threads

Skimlinks Plugin 2.0.7 Official Skimlinks plugin for vBulletin

vBExperience 4.0.4 Calculate activity of your users

vBExperience Level 1.0 vBExperience Level

vBookie for vBulletin 4 4.0.9 vBulletin Betting Hack

vBSEO 3.6.0 vBulletin SEO

vBulletin Blog 4.1.5 Personal web log, integrated with vBulletin.

vBulletin CMS 4.1.5 Content Management System

[Christos Teriakis]

I disabled the only thing I have like that and still get it ? Here are my mods :


please try to import this xml file. I did a change. Maybe it will works for you.

Chris

[maineGuy72]

here is my mods for the same error

Article Forum 4.1.2 Turn a Forum into a Article Depository

BBR - Google Analytics Addon 1.0.3 Adds Google analytics code below the</head> tag.

Digital Point User Map 1.0.1 Geolocate Online Users In Realtime

Farcaster's Event Attendance 3.1 This hack will allow users to RSVP to selected events.

Force Users to Read a Thread 2.10 This hack allows you to specify a thread that you would like users to read. They would not be able to do anything else on the forum before reading it.

GeekyDesigns Default Avatar 2.0.3 A default avatar for posts, profiles, etc.

GlowHost - Spam-O-Matic 2.0.2 Ultimate solution to defend against SPAM: Check new registrations from StopForumSpam database, auto moderate posts against custom word-list and Akismet service.

Inactive User Reminder Emails 2.2.1 Sends emails out to inactive users encouraging them to re-visit the forum

MARCO1 Advanced Quick Reply And Edit With Smilies 4.5 Replace the vBulletin Default Quick Reply and Edit With Full Quick reply And Edit Box With Smilies.

MARCO1 Image Re-sizer With HIGHSLIDE! 3.0 Re-size the images with the great AJAX effects HIGHSLIDE With many more features

MGC chatbox Evo 3.0.0 Fully remade MGC Chatbox

microCLASSIFIEDS 5.0.4 General Classifieds

Navbar menu for Gallery 1.00 Adds a navbar Gallery drop-down menu

Picture and Album Gallery 1.08 Picture and Album Gallery for vB4

Rotating Banner System 2.3.1 Unlimited advertising at any place in your forums

SEOforums.org Fuzzy SEO Booster 3 1.5.0b SEOforums.org Fuzzy SEO Booster 3

Skimlinks Plugin 2.0.7 Official Skimlinks plugin for vBulletin

Spiders Display on Forumhome and Who's Online 1.0.7 This product will display the name and number of spiders on Forumhome, and number of spiders in the Who's Online.

vB4: SuperCharged 1.51 Various optimisations to make vBulletin 4 FEEL faster. Created by Darkimmortal.

vBH - Add new tabs 1.2 1.2 This plugin adds new tabs to the main navbar

vBSEO :: Sitemap Generator 3.0 Generate a Google & Bing Sitemap for your Forums

VSa - Forums Online CountUp 2.0 VSa - Forums Online CountUp

VSa - PayPal Donate 5.0 VSa - PayPal Donate

VSa - Sub-Forum Manager 3.1.2 VSa - Sub-Forum Manager

[fwulfers]

It is not just the link the whole RSS box is there if you click on the X to close it it brings you to the home page. On yours you just have the link and when you click on it a popup comes up which is cool, on mine the whole RRS box is open and when you click on the X it redirects to the home page

http://www.collegefootballforum.info/classifieds.phpI had the same on my site.

please try to import this xml file. I did a change. Maybe it will works for you.

Chris

This latest xml file fixed the RSS box problem. Thanks!

[maineGuy72]

works for me too. thanks chris

no i have to figure out why my admincp isnt working right

[dgparent]

Thanks !! That worked :)

please try to import this xml file. I did a change. Maybe it will works for you.

Chris

[DannyITR]

RSS link works great for me too! Thanks Chris.

Do you guys' thumbnails show up? I can't get mine to show up.

[Christos Teriakis]

RSS link works great for me too! Thanks Chris.

Do you guys' thumbnails show up? I can't get mine to show up.

Have you cmod 777 the uploading directories?

Chris

[Christos Teriakis]

works for me too. thanks chris

no i have to figure out why my admincp isnt working right

What exactly is your problem in your admincp? Are you looking the menu options on the left panel and clicking them you're getting nothing on the right?

Chris

[DannyITR]

Have you cmod 777 the uploading directories?

Chris

Chmoded the photos directory and they work now thank you.

Found another problem though. I tried to use the contact the seller link while logged in as another user and it said that it was an invalid recipient username. There was no option to change the username in the popup. In the end, the PM was still delivered successfully.

[addamroy]

This (Free) version yes, works with 4.0.7. Just avoid to get the PRO as that is needs at least (4.0.8). The reason is that in PRO version the Seller's profile moved to vB user profile page as sepearate tab, something that is supporting from 4.0.8 and then.

Chris

Cool thanks for the prompt reply, much appreciated. Installing the free version now.

What are the chances of making available a paid version I can use on my 4.0.7?

ISSUE - I cannot provide my fellow administrator permission to administer settings for the classifieds, any way I can allow other administrators to edit the general settings in here?

Also, a read-me or some documentation would be nice.

[Jman423]

Here are two problems I am having.

There is an unwanted space on Classifieds page above the navbar.

As others have mentioned, the last 4 options in the AdminCP navgroup are showing blank pages.

-Thank you

EDIT: A little more info... I've disabled EVERY product in my system and neither of these problems were resolved. I'm running the latest vB version, forum only.

[ndahiya]

get an error on trying to access classified categories or other menu option in admincp.

Warning: require_once([path]/includes/adminfunctions_cms.php) [function.require-once]: failed to open stream: No such file or directory in [path]/admincp/microclassifieds_admin.php on line 17

Fatal error: require_once() [function.require]: Failed opening required '/home/webhome/public_html/forums/includes/adminfunctions_cms.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/webhome/public_html/forums/admincp/microclassifieds_admin.php on line 17


i only have vb forums, no cms..

ndahiya

[sick adam]

Just so I am clear ( a little slow!), living in America I CANNOT use this plug in, correct? From what I'm reading, is there an earlier version, pre 5.0.3, that I can use? Thanks!

[Jman423]

Just so I am clear ( a little slow!), living in America I CANNOT use this plug in, correct? From what I'm reading, is there an earlier version, pre 5.0.3, that I can use? Thanks!

You can use it in the US as long as you don't have a domain with an extention of .no (Norway), .se (Sweden), .dk (Denmark) or .fi (Finland).

[sick adam]

Thank you for the info Jman :)

One more question, there are tons of index.html files in the download, and my ftp wont allow them, they are empty files... what do I do with these? Thank you in advance :)

[maineGuy72]

What exactly is your problem in your admincp? Are you looking the menu options on the left panel and clicking them you're getting nothing on the right?

Chris

correct i get the general settings and that is it. the other options give a blank screen.

also when i am in the setting screen i get a dbase error when i click on modify thumbnails.

here is error and attached is shot of the link i am talking about

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT * FROM microclassifieds_item_photos WHERE itemid IN () AND modified=0 ORDER BY itemid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND modified=0 ORDER BY itemid' at line 1
Error Number : 1064
Request Date : Friday, August 19th 2011 @ 08:29:00 PM
Error Date : Friday, August 19th 2011 @ 08:29:00 PM
Script : http://www.nhreptile.com/usercp_classifieds.php?do=modifythumbs
Referrer : http://www.nhreptile.com/usercp_classifieds.php?do=awaitingreview

[maineGuy72]

ok after i CHMOD the photos directory the error disappeared.

[lazytown]

I think the author is doing a tremendous job. I haven't installed it, but I'm waiting for the final kinks to be ironed out (as I'm sure many other silent members are). Once this goes live I absolutely will be donating. Keep up the great work and dont burn out! :) just voted for motm.

[maineGuy72]

they wont let me vote twice lol

[maineGuy72]

in reference to the admin controls not working ( shows blank screen)

i noticed in microclassifieds_admincp.php in the required backup section these entries

require_once(DIR . '/includes/adminfunctions_cms.php');
require_once(DIR . '/includes/functions_cms_layout.php');

i am not using cms and do not have these files in my folders. could this be the reason that it is not working?

**note - i reconstructed those files and uploaded them and the links work but i am getting an error when using the block generator error follows

Fatal error: Invalid block type id on line 825 in [path]/includes/class_block.php in [path]/vb/vb.php on line 287

[Christos Teriakis]

Goodmorning to all,

It's 7:45am here, and I'm start working. As I seen you took good care for me, by giving me lot of work with your posts during the night:D

I'll be back with fixes soon.

Have a nice weekend
Chris

[fwulfers]

Good evening for me. :)

I started using the new version and found a few issues:

When using Contact Seller and Email It, I got this error:
Message: Invalid recipient username. Please press the back button, enter the correct username and try again.

However, PMs and E-mails are sent fine.

Currencies: In the settings, you can only select a single currency. Different currencies are essential for global sites. Perhaps there could be a dropdown list?

[Christos Teriakis]

Good evening for me. :)

I started using the new version and found a few issues:

When using Contact Seller and Email It, I got this error:
Message: Invalid recipient username. Please press the back button, enter the correct username and try again.

However, PMs and E-mails are sent fine.

Currencies: In the settings, you can only select a single currency. Different currencies are essential for global sites. Perhaps there could be a dropdown list?

Good ...evening :-))

Currencies, needs a deeper and better approach as I'm planing to add online payments. That's why I changed it as a first step. By the way. I read your post for your extra fileds. There are some minnor changes that I need to do, one of them is the extra fields. As I wrote this version was the custom work and my client has extra fields related to seller (eg phone nbr), so they wanted them there. But sure during weekend when I'll work globally for extra fields, I'll put them back.

Chris

[Christos Teriakis]

Is anybody from those who had problem with blank pages in admincp online, to try this file?

Chris

[Christos Teriakis]

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT * FROM microclassifieds_item_photos WHERE itemid IN () AND modified=0 ORDER BY itemid;


Fixed. Should be on ver.5.0.6 today

[Christos Teriakis]

Cool thanks for the prompt reply, much appreciated. Installing the free version now.

Keep in mind that version 5.x.x here is not compatible with vB versions prior to 4.0.8

What are the chances of making available a paid version I can use on my 4.0.7?

This version 5.x.x is the one that I had in mind to sell as PRO.

ISSUE - I cannot provide my fellow administrator permission to administer settings for the classifieds, any way I can allow other administrators to edit the general settings in here?

Also, a read-me or some documentation would be nice.
Really don't know. This is a vB issue.

Chris

[Christos Teriakis]

Here are two problems I am having.

There is an unwanted space on Classifieds page above the navbar.

As others have mentioned, the last 4 options in the AdminCP navgroup are showing blank pages.

-Thank you

EDIT: A little more info... I've disabled EVERY product in my system and neither of these problems were resolved. I'm running the latest vB version, forum only.

Fixed. Should be on v.5.0.6 today

[Christos Teriakis]

get an error on trying to access classified categories or other menu option in admincp.



i only have vb forums, no cms..

ndahiya

Fixed. Should be on 5.0.6 today.

[Christos Teriakis]

Thank you for the info Jman :)

One more question, there are tons of index.html files in the download, and my ftp wont allow them, they are empty files... what do I do with these? Thank you in advance :)

They're there to protect you from directory listing by the browsers. But you can remove if you want.

Chris

[Christos Teriakis]

Well, I think that I fixed all post bugs, so I can start working on extra fields now as fwulfers is spying me :-)

[perfphysio]

I think the author is doing a tremendous job. I haven't installed it, but I'm waiting for the final kinks to be ironed out (as I'm sure many other silent members are). Once this goes live I absolutely will be donating. Keep up the great work and dont burn out! :) just voted for motm. I agree, I am also watching with keen interest.

I have one question on currency. Can the user select a currency symbol that can be different for their own listing. e.g. USA in USD, UK in Sterling (?), Europe in Euro etc. Whilst this is not useful for searching on a plain number, it is useful for global community forums whose members are all over the world.

Thoughts?

[Christos Teriakis]

I agree, I am also watching with keen interest.

I have one question on currency. Can the user select a currency symbol that can be different for their own listing. e.g. USA in USD, UK in Sterling (?), Europe in Euro etc. Whilst this is not useful for searching on a plain number, it is useful for global community forums whose members are all over the world.

Thoughts?

Well.... a brief message on how I'm planing to make currencies work. In Mary's version the user has the ability to set a price as number eg 10,000 and besides in another field to write the currency eg Kr. This was usefull for the poster but confused a lot the visitors. Imagine to see a listing of 10 only Ads each one in different currency. In your mind should be difficult to make calculations so you can see which is cheaper. That's why my mod will works with one only currency. This is the first step that I did. The second is to give again the seller the ability to post on his own currency, but should be a real time calculation to show the Ad to visitors in the default currency. Only when the user clicks on "Buy now" (when the online payments will be implement), only then he will see the sellers currency, but this is ok as it will be equaivalent to the price that he has in mind.

Chris

[perfphysio]

Well.... a brief message on how I'm planing to make currencies work. In Mary's version the user has the ability to set a price as number eg 10,000 and besides in another field to write the currency eg Kr. This was usefull for the poster but confused a lot the visitors. Imagine to see a listing of 10 only Ads each one in different currency. In your mind should be difficult to make calculations so you can see which is cheaper. That's why my mod will works with one only currency. This is the first step that I did. The second is to give again the seller the ability to post on his own currency, but should be a real time calculation to show the Ad to visitors in the default currency. Only when the user clicks on "Buy now" (when the online payments will be implement), only then he will see the sellers currency, but this is ok as it will be equaivalent to the price that he has in mind.

ChrisThanks for the reply. The realtime conversion is of course the best way, perhaps an indicator that it is a conversion for those that are and/or you can display or click on something to see the sellers original price (not just when making a payment). Connecting in real time to a retail convertor is difficult. The online DB's of these are more bank rates and not what you or I would pay a bank for a conversion into our accounts. It would be useful if anyone has found an appropriate way to deal with this. I know I am being a little picky about it all).

Keep up the great work as this mod seems that it could be used by many people.

[WEBDosser]

Mary's Classifieds is prohibited in domains (sites): In any site, having any tld extention (eg com, net etc etc)

does this mean we cannot install it on a .org

[Christos Teriakis]

Mary's Classifieds is prohibited in domains (sites): In any site, having any tld extention (eg com, net etc etc)

does this mean we cannot install it on a .org

No...no... The exception are:

Domains with tld .no (Norway), .se (Sweden), .dk (Denmark), .fi (Finland).
Domains operating in Norgerian, Swedish, Danish, Finsh (any type of tld).Some examples:

mydomain.com in Swedish language: prohibited
mydomain.com in English: Permited
mydomain.no or mydomain.se or mydomain.dk or mydomain.fi in any language: prohibited.As general rule you can think that as long as your domain has nothing to deal with Scadinavia, you can use it.

Chris

[WEBDosser]

Thanks for clearing that up so quick.. my client was in a panic.

[bosken]

No...no... The exception are:

Domains with tld .no (Norway), .se (Sweden), .dk (Denmark), .fi (Finland).
Domains operating in Norgerian, Swedish, Danish, Finsh (any type of tld).Some examples:

mydomain.com in Swedish language: prohibited
mydomain.com in English: Permited
mydomain.no or mydomain.se or mydomain.dk or mydomain.fi in any language: prohibited.As general rule you can think that as long as your domain has nothing to deal with Scadinavia, you can use it.

Chris

Any news for my site :confused: :(

[Christos Teriakis]

Any news for my site :confused: :(

Not yet, sorry. But if I'll not have a reply till tonight, I'll get the risk to give you the permission. They have a HiFi Systems portal. I agree that they have thousands of Ads, but has nothing to do with Harley Davidson. Just don't add anything about Audio there.

Chris

[bosken]

I wait for answer... no worries. No, no risk audio will enter that site, just audio from Harley exhaust systems :)

Thanx for doing a awesome job!

[Christos Teriakis]

Hello,

Here is the daily update of Mary's Classifieds. This version:

Fixes some problems in admincp. At least the file not found errors, something that I believe that caused the other problems there. Sorry, I can't test it, as I've the Suite installed.
Fixes a database error when trying to Manage Thumbs while you haven't post any Ad.
I corrected the search listing. Now it respects your settings for Seller search (droplist or text inpute) and Location search (Droplist or text input).
To upgrade:

Download the latest zip file.
Upload files:
admincp/microclassifieds_admin.php to your admincp
classifieds.php to your forum directory
Import product_microclassifieds.xmlHave a nice weekend
Chris

[sick adam]

ok, soive been trying to upload the files to my server, using godaddy, but are we supposed to upload all the index.html files? it wont let me, says they are empty and cannot be uploaded... am I supposed to be doing something with them? thank you!

[ndahiya]

Fixed. Should be on 5.0.6 today.

Thanks Chris. Admincp works now.
One small thing: changing the "Breadcrumb name" does not change the title in the navbar... not sure if it is a feature or a bug... :)

Also, would it be possible to add a on/off switch so that we can hide it from the navbar (instead of disabling the mod).

Thanks much for being so responsive !!!


Separately, i thought you were going to add a free ad option in the pro version as well? Really waiting for that.

ndahiya

[Jman423]

Is anybody from those who had problem with blank pages in admincp online, to try this file?

Chris

I can confirm this is working like it should now.

-Thank you

[maineGuy72]

thanks for the updates chris.

is there a way to rebuild the thumbnails for the listings? it appears some have gone bad and cant seem to find a way to rebuild them.

also is there a way for the random classified side box to display the nophotosmall.png when there is no photo for the classified?

i am still getting that error for the block generator.

thanks again for your hard work. how can we donate to the mod?

[Christos Teriakis]

thanks for the updates chris.

is there a way to rebuild the thumbnails for the listings? it appears some have gone bad and cant seem to find a way to rebuild them.

also is there a way for the random classified side box to display the nophotosmall.png when there is no photo for the classified?

i am still getting that error for the block generator.

thanks again for your hard work. how can we donate to the mod?

As these are not real bugs, please allow me to finish with the searchable extra fields that I'm working now. Thank you for your kind offer for donating, but the only money that I'm accepting for this mod, are from those who want to buy the Brand free version.

Edited: But if you still want to donate, you'll make me feel happier if you donate something to any organization related to unwanted children protection.

Chris

[voglermc]

In the classified section of my profile, I have 2 "My Bookmarks" both linking to http://zzzzzzzzzzzzzzz.org/usercp_classifieds.php?do=mybookmarks

[voglermc]

It would be cool if we could set a default posting picture to show if the seller doesn't

[Christos Teriakis]

It would be cool if we could set a default posting picture to show if the seller doesn't

There are already 3 of them:

nophotosmall.png for small thumbs
nophoto.gif for normal thumbs
nomainphoto.gif for Main photo

[Jman423]

I've noticed this on the past few versions, but I can't find what is causing it to happen on in the classifieds scripts.

[Christos Teriakis]

I've noticed this on the past few versions, but I can't find what is causing it to happen on in the classifieds scripts.

I've noticed it too, but is not something that I can help here. I'm using the stylevar blockhead which I believe that adds a border around.
In some cases I had also a table around, but even if I removed it, that border still exists, so I assume that it comes from vB.

Chris

[Jman423]

I've noticed it too, but is not something that I can help here. I'm using the stylevar blockhead which I believe that adds a border around.
In some cases I had also a table around, but even if I removed it, that border still exists, so I assume that it comes from vB.

Chris

I thought so too, but it only exists in the classifieds scripts. Other areas of the site where the blockhead is used don't have this problem. The border still exists, but the radius works, the radius doesn't seem to be working in the classifieds for some reason. There has to be something overriding it, but I can't find it.

[Jman423]

I don't know what this is, but "Page Not Found" is showing up in the middle of the page.

[voglermc]

I've noticed this on the past few versions, but I can't find what is causing it to happen on in the classifieds scripts.


Put this in your additional.css

.blockhead {
border: 0px;
}

[voglermc]

I'm getting this error on the main page

Warning: Division by zero in [path]/microclassifieds/includes/functions.php on line 586

[voglermc]

I'd like to hide the marque all together also

[addamroy]

Keep in mind that version 5.x.x here is not compatible with vB versions prior to 4.0.8

You just told me that it is, so long as I didn't use the pro version. This is what you said...

This (Free) version yes, works with 4.0.7. Just avoid to get the PRO as that is needs at least (4.0.8). The reason is that in PRO version the Seller's profile moved to vB user profile page as sepearate tab, something that is supporting from 4.0.8 and then.

Chris

The only version available for download is 5.x.x. Little bit of confusion there? Please explain.

This version 5.x.x is the one that I had in mind to sell as PRO.

Where can i get a link to check out the pro version, what's the difference between free and pro?

Really don't know. This is a vB issue


It is not a VB issue, i can give my administrators permission to do anything else on the board, however there is not even an option to allow them to access the general settings of your add-on. Can you explain to me how this is an issue with vbulletin?

Administrators can access the other settings areas of your add-on, such as categories and blocks, but the general settings area tells them they do not have permission to access that page.

[Jman423]

You just told me that it is, so long as I didn't use the pro version. This is what you said...



The only version available for download is 5.x.x. Little bit of confusion there? Please explain.

Where can i get a link to check out the pro version, what's the difference between free and pro?
The "free version" was version 4.x.x, which IS compatible with vB versions prior to 4.0.7, but version 5.x.x, which is also known as the Pro version, is only compatible with vB 4.0.8 or newer. There is no paid version, if you read back through the thread, you will find that he released the Pro version for free, which is attached to his main post for download.


It is not a VB issue, i can give my administrators permission to do anything else on the board, however there is not even an option to allow them to access the general settings of your add-on. Can you explain to me how this is an issue with vbulletin?

Administrators can access the other settings areas of your add-on, such as categories and blocks, but the general settings area tells them they do not have permission to access that page.

I don't have this problem, and I am an administrator in a non-standard usergroup (not usergroup 6).

[Goatpod]

Hi Chris, many thanks for taking on the Classifieds and all the work you're doing. I've recently updated to v5.0.6 from Mary's original script and have started receiving the following VB error:

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO pmtext
SET fromuserid = '1',
fromusername = 'Archery Interchange UK',
title = 'Easton A/C/E 570's x 9',
message = 'A new Ad has been post in category:\nArrows & Arrow Components\nEaston A/C/E 570's x 9 (http://www.archery-interchange.net/classifieds-162/)\n',
touserarray = '',
iconid = '0',
dateline = '1313861446',
showsignature = '0',
allowsmilie = '1',
reportthreadid = '0';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's x 9',
message = 'A new' at line 4
Error Number : 1064
Request Date : Saturday, August 20th 2011 @ 07:30:45 PM
Error Date : Saturday, August 20th 2011 @ 07:30:46 PM
Script : http://www.archery-interchange.net/cron.php?rand=1313861440
Referrer : http://www.archery-interchange.net/f37/
IP Address : 81.109.206.63
Username : Unregistered
Classname : vB_Database
MySQL Version :

I've had a poke around but I'm no expert, any ideas?
Thanks, Dave.

[addamroy]

The "free version" was version 4.x.x, which IS compatible with vB versions prior to 4.0.7, but version 5.x.x, which is also known as the Pro version, is only compatible with vB 4.0.8 or newer. There is no paid version, if you read back through the thread, you will find that he released the Pro version for free, which is attached to his main post for download.

Oh ok I see, so how do I go about downloading the 'free' version instead of the 'pro' version, do you know?

I don't have this problem, and I am an administrator in a non-standard usergroup (not usergroup 6).

I can access the settings as the main admin of the forum but my other administrator cannot, any idea how to troubleshoot this?

[Jman423]

Oh ok I see, so how do I go about downloading the 'free' version instead of the 'pro' version, do you know?

I don't know that the author will be supporting the old version now that v5 is out.

I can access the settings as the main admin of the forum but my other administrator cannot, any idea how to troubleshoot this?

What usergroup is your other administrator in?

Is anyone else able to create a premium ad, and can you see the vote portion of any ad??

[sick adam]

Hello, just need a quick question answered.... what are you supposed to do with the index.html files in the download? Replace them with your own index.html file? I cant upload them, since they are empty, if someone could answer would be a HUGE help, thank you!

[Christos Teriakis]

Hi Chris, many thanks for taking on the Classifieds and all the work you're doing. I've recently updated to v5.0.6 from Mary's original script and have started receiving the following VB error:



I've had a poke around but I'm no expert, any ideas?
Thanks, Dave.

Hello Dave,

There is 100% compatibility with Mary's original code. I just improvent it. A part that I changed is the PMs. Mary used to not "touch" vB native functions as a way to keep higher compatibility with the upcoming versions. I do agree with her, but at this point there was a missing feature (sending email to user about the new PM). That's why I changed it to use vB's datamanager.

I've checked all type of messages and work, but I'll try a check more. What seems strange to me is that "\n". Mary was using it as way to have a line break, but I removed them. So, I'm wondering if you've uploaded all the files.

Chris

[Christos Teriakis]

Hello, just need a quick question answered.... what are you supposed to do with the index.html files in the download? Replace them with your own index.html file? I cant upload them, since they are empty, if someone could answer would be a HUGE help, thank you!

I've already replied to this topic. You can easily delete them from the package and then upload the rest files. These files are there just to protect your site from directory listing. What FTP client are you using which does not upload zero size files?:confused:

Chris

[Jman423]

Hello, just need a quick question answered.... what are you supposed to do with the index.html files in the download? Replace them with your own index.html file? I cant upload them, since they are empty, if someone could answer would be a HUGE help, thank you!

You should not have to replace any index files unless you are updating the product. You should be uploading the file structure just the way it is in the zip file and the only three files that should be going in your forum root should be php files. The index files are found within the microclassifieds folder... and as far as I know, they shouldn't be touched.

As for the "Page Not Found" error that I mentioned earlier, that appears to be the voting block, and it only appears on my vB Suite installation, and not in the Forum "only" installation... much like the AdminCP menu problem that required CMS files.

[Goatpod]

Hello Dave,
So, I'm wondering if you've uploaded all the files.

Chris

Hi Chris, thanks for taking the time to respond. I've deleted all of the Classified files currently on the server and uploaded new ones just to be sure. I'll give it an hour and see if there's any improvement. Thanks again, Dave.

[voglermc]

I'm getting this error on the main page

Warning: Division by zero in [path]/microclassifieds/includes/functions.php on line 586

Any answer on this?

[Goatpod]

Any answer on this?

Edit:// Sorry I'm going blind :)

[1320Nation]

I have had issues with getting this mod to work on my domain. My webtech fixed it but, said to pass this info along to the developer.

Tell the developer to edit \microclassifieds\includes\functions.php

And change:
".TABLE_PREFIX."user.* AS thisprofile
to:
".TABLE_PREFIX."user.*

in every place he's done that.
Otherwise it'll never work right.

Btw, before fixing the issue this is the error I was getting.

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT AVG(board_microclassifieds_orders.sreviewrating) AS thisrating,
board_microclassifieds_profiles.* AS thisprofile
FROM board_microclassifieds_orders
JOIN board_microclassifieds_profiles
ON board_microclassifieds_profiles.userid=board_micro classifieds_orders.sellerid
WHERE board_microclassifieds_orders.sreviewrating>0
GROUP BY board_microclassifieds_orders.sellerid
ORDER BY board_microclassifieds_orders.sreviewrating DESC
LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS thisprofile
FROM board_microclassifieds_orders
' at line 2
Error Number : 1064

[RSNF]

Hello I am using this mod but I appear to be having an issue exactly how are we suppose to create an ad as I see no option where a user can create an ad not in the navigation menu when you click on classifieds or in the profile when you click on classifieds? I have adjusted all the usergroup permissions so that they may create an ad but still does not work. Thanks in advance for your help.

[Goatpod]

Hello I am using this mod but I appear to be having an issue exactly how are we suppose to create an ad as I see no option where a user can create an ad not in the navigation menu when you click on classifieds or in the profile when you click on classifieds? I have adjusted all the usergroup permissions so that they may create an ad but still does not work. Thanks in advance for your help.

You should have the option to create an ad. as shown on the attached image.

[RSNF]

Wow my bad lol.......Appreciate your quick reply

[MoDz]

German Translation? ;)

[Goatpod]

Hello Dave,
I've checked all type of messages and work, but I'll try a check more. What seems strange to me is that "\n". Mary was using it as way to have a line break, but I removed them. So, I'm wondering if you've uploaded all the files.

Chris

No luck, I was still receiving the VB errors after deleting and reuploading all files. I've since completely removed the classifieds system and done a completely fresh install of 5.0.6 which has removed the VB error; so it looks like there could have been some glitch left over from the original script (probably self-inflicted :)).

I've started to test the fresh install and have so far come across the following:


When creating a new advert, the Product Location is in a drop down menu and doesn't allow the user to type a location.

When trying to attach an attachment to the ad. I get a thin white box that drops down when clicking the paperclip icon. Apart from the attachment icon and two greyed out arrows the editor box is empty of any controls, is this correct?

When a user purchases an item, the PM sent to the seller contains incorrect links to either approve or disapprove the sale, the link format is: http://\"http//www.archery-interchange.net/classifieds.php?do=sellitem&itemid=1&statusid=1\&quot;=


Hope this all makes sense and is fixable or if I'm being Mr Thickie someone can put me right :)

Cheers, Dave

[Jman423]

When creating a new advert, the Product Location is in a drop down menu and doesn't allow the user to type a location.


I believe there is a setting in the "General Settings" for the product that allows you to choose whether this should be a dropdown or a text field.

[sick adam]

Hello! So I installed all the files, looks like it is up and running, but no matter WHAT I do, it wont allow me access. This is the message I get

vBulletin Message
Cape Adam, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

I have gone into the categories section and put all who post, but it still wont allow me! Any suggestions?

[Goatpod]

I have gone into the categories section and put all who post, but it still wont allow me! Any suggestions?

Have you set up your individual usergroup permissions?

[sick adam]

I dont seem to have that permission menu... where would it be? In the user group or in the microclassified page?

[sick adam]

Omg I Love You! Thank You

[Adem GEN?]

Hello,


Deprecated: Assigning the return value of new by reference is deprecated in *********/forum/classifieds.php on line 486






Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT AVG(microclassifieds_orders.sreviewrating) AS thisrating,
user.* AS thisprofile
FROM microclassifieds_orders
JOIN user
ON user.userid=microclassifieds_orders.sellerid
WHERE microclassifieds_orders.sreviewrating>0
GROUP BY microclassifieds_orders.sellerid
ORDER BY microclassifieds_orders.sreviewrating DESC
LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS thisprofile
FROM microclassifieds_orders
' at line 2
Error Number : 1064
Request Date : Sunday, August 21st 2011 @ 04:37:59 AM
Error Date : Sunday, August 21st 2011 @ 04:38:00 AM
Script : http://forum/classifieds.php
Referrer : http://forum/
IP Address : ********
Username : Adem GEN?
Classname : vB_Database
MySQL Version : 5.5.15-log



I receive this error

[ndahiya]

Separately, i thought you were going to add a free ad option in the pro version as well? Really waiting for that.

ndahiya

Basically looking to hide the "Financial details" and "Payment Options" blocks, and hide any mention of price...

Noticed 2 more small things:
Extra fields showing in Seller block, rather than in the ad block. they are extra fields for the ad, not the seller.
"Individual" is misspelled as "Idividual"

ndahiya

[Goatpod]

Hello,
Deprecated: Assigning the return value of new by reference is deprecated in *********/forum/classifieds.php on line 486
Database error in vBulletin 4.1.5:
I receive this error

If you follow psychobike's advice (page 24 of this thread) it should cure this problem.

[Christos Teriakis]

Extra fields showing in Seller block, rather than in the ad block. they are extra fields for the ad, not the seller.
"Individual" is misspelled as "Idividual"

ndahiya

I've replied it already. As I said, 80% of the new feature were custom work. As my clients have extra fields only related to seller (eg phone nbr etc), they wanted the extra fields there. I'll fix it, but I'll appreciate a lot to keep any design related problems after having a stable code version.

Chris

[Christos Teriakis]

Database error in vBulletin 4.1.5:


Are you using MySQLi ?

[Christos Teriakis]

German Translation? ;)

Why you don't do it and share it with other Deutche speaking users?:D Everybody must do something here. This is the meaning of the community;)

Chris

[nikosb]

GOOD MORNING
Something happens in the categories and characters are
?�?�?�?�?�?� ?�?�?�

the rest work perfectly
any ideas?
http://www.supa.gr/forums/classifieds.php?do=main&catid=1

my forum is Grrek Language and msql utf-8

[Adem GEN?]

Are you using MySQLi ?
I do not know

I'm trying to locale
I use EasyPHP 5.3.7.0

At first, I'm trying to locale
am install After real forum

My real forum system:
Server Type Linux
Web Server Apache (cgi-fcgi)
PHP 5.2.9
MySQL Version 5.0.83-community-log

Thanks

[Christos Teriakis]

GOOD MORNING
Something happens in the categories and characters are
?�?�?�?�?�?� ?�?�?�

the rest work perfectly
any ideas?
http://www.supa.gr/forums/classifieds.php?do=main&catid=1

my forum is Grrek Language and msql utf-8

Try setting Grid character set "iso-8859-7". As I seen the categories are ok. The problem is on titles.

Edited: Sorry Grid Language is for the interface
Chris

[Christos Teriakis]

I do not know

I'm trying to locale
I use EasyPHP 5.3.7.0

At first, I'm trying to locale
am install After real forum

My real forum system:
Server Type Linux
Web Server Apache (cgi-fcgi)
PHP 5.2.9
MySQL Version 5.0.83-community-log

Thanks

I'll check that query again...

[nikosb]

Try setting Grid character set "iso-8859-7". As I seen the categories are ok. The problem is on titles.
Chris
nothing has changed

[Christos Teriakis]

nothing has changed

Please connect with phpMyAdmin to your database. In the main page, right side you'll see a block "MySQL". Somewhere there is saying the database character set. What it's says there?

[nikosb]

Please connect with phpMyAdmin to your database. In the main page, right side you'll see a block "MySQL". Somewhere there is saying the database character set. What it's says there?

MySQL: UTF-8 Unicode (utf8)

[Christos Teriakis]

MySQL: UTF-8 Unicode (utf8)

What confuses me is that categories appear in Greek. Do you have locations as input or as droplist? If its input, then I need to check for inputs only.

[nikosb]

i have locations as input
I did check on all ads. is ok.
The problem remains

[voglermc]

I'm getting this error on the main page

Warning: Division by zero in [path]/microclassifieds/includes/functions.php on line 586

[ndahiya]

I've replied it already. As I said, 80% of the new feature were custom work. As my clients have extra fields only related to seller (eg phone nbr etc), they wanted the extra fields there. I'll fix it, but I'll appreciate a lot to keep any design related problems after having a stable code version.

Chris

thx. must have missed it.

[Jman423]

Any idea why the vote iframe shows "page not found", or why I can't post premium ads?

[maineGuy72]

for random items with no photo i came up with this fix. its not the cleanest code but it works
it will display nophotosmall.jpg image for an ad with no photo assigned to it


find


$html_random .= '<tr valign="top"><td width="90" align="left">
<a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">
<img src="'.$thumb.'" border="0" /></a></td>
<td align="left"><h4><a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">'.$title.'</a>
</h4>'.$price.' '.$vbulletin->options["microclassifieds_currency"].'</td></tr>';


and replace with

$ad_photo = $random["logo"];
if(empty($ad_photo))
{
$html_random .= '<tr valign="top"><td width="90" align="left">
<a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">
<img border="0" src="microclassifieds/images/nophotosmall.png" width="50" align="left" style="padding:3px;">
<td align="left"><h4><a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">'.$title.'</a>
</h4>'.$price.' '.$vbulletin->options["microclassifieds_currency"].'</td></tr>';
} else {
$html_random .= '<tr valign="top"><td width="90" align="left">
<a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">
<img src="'.$thumb.'" border="0" /></a></td>
<td align="left"><h4><a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">'.$title.'</a>
</h4>'.$price.' '.$vbulletin->options["microclassifieds_currency"].'</td></tr>';
}

[Christos Teriakis]

for random items with no photo.....

Try to replace the whole function getRandom($catid) in functions.php with this code:

// Get Random Items
function getRandom($catid)
{
global $db, $vbulletin, $vbphrase, $random_items, $random_items_bit, $catid;

if (empty($catid))
{
$catid = 0;
}
$maximum_random = $vbulletin->options["microclassifieds_random_items"];
$SubIds = array();
$getSub = _getChildId($SubIds, $catid);
$browsecategories = implode($SubIds, ', ');
$sql_random = $db->query_read("SELECT * FROM ".TABLE_PREFIX."microclassifieds_items WHERE categoryid IN ($browsecategories) AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT $maximum_random");
$total_random = $db->num_rows($sql_random);
if($total_random == 0)
{
$sql_random = $db->query_read("SELECT * FROM ".TABLE_PREFIX."microclassifieds_items WHERE logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT $maximum_random");
}
$i = 0;
$html_random = '';
$thumb_path = 'microclassifieds/photos/thumbs/';
while($random = $db->fetch_array($sql_random)) {
if($i%2!='0')
{
$html_random .= '<tr><td height="35">&nbsp;</td></tr>';
}
if($i >= 2)
{
$html_random .= '</table></li><li><table cellpadding="3" cellspacing="0" border="0" width="100%">';
$i = 0;
}
$i++;
$title = getTitle($random['title']);
$thumb = $thumb_path.$random['logo'];
$price = getFormatPrice($random['price']);
$html_random .= '<tr valign="top"><td width="90" align="left">
<a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">
<img src="'.$thumb.'" border="0" /></a></td>
<td align="left"><h4><a href="classifieds.php?do=viewitem&itemid='.$random["id"].'">'.$title.'</a>
</h4>'.$price.' '.$vbulletin->options["microclassifieds_currency"].'</td></tr>';
}
$templater = vB_Template::create('microclassifieds_random_items ');
$templater->register('html_random', $html_random);
$random_items .= $templater->render();
return;
}


This code:

Shows only Ads with photos
Shows Ads from subcategories too

[Christos Teriakis]

I'm getting this error on the main page

Warning: Division by zero in [path]/microclassifieds/includes/functions.php on line 586

Goto General Settings (admincp) and set Store block greater than 0.

[maineGuy72]

new bug

when browsing a category the first page shows the correct listings but when you click the button for the next page it shows all categories not just the category selected

see at
http://www.nhreptile.com/classifieds.php?do=main&catid=1

[Christos Teriakis]

i have locations as input
I did check on all ads. is ok.
The problem remains

Please try to import this file.

Chris

[Christos Teriakis]

new bug

when browsing a category the first page shows the correct listings but when you click the button for the next page it shows all categories not just the category selected

see at
http://www.nhreptile.com/classifieds.php?do=main&catid=1

I'll check it.

[Christos Teriakis]

Extra fields....

I'm a step before the end as you can see at:
http://www.christeris.net/vb4/classifieds.php?do=search
but I've to take care for those who are using screen resoloution at 1024 and can't see all fields (need to scroll). I'll place switches in the standard fields. But no courage for today. I'm totally dead.

Chris

[maineGuy72]

i also notice that if a user uploads a photo with ext .JPG instead of .jpg the thumbnail doesnt show up in the datagrid. it does show up in the random ads correctly. this might be an issue with my server and not the mod. i will check into it more
http://www.nhreptile.com/classifieds.php?do=main&catid=14


to build on the last bug
it allows you to click the the nav buttons for nex/prev pages when the "off" images are showing.

[maineGuy72]

in product-microclassifieds.xml line 5201 is the same as line 5202 resulting in double My Bookmarks in usercp

[nikosb]

Please try to import this file.

Chris

no luck.

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO `vb_microclassifieds_search_fields` VALUES (1, 'Field 1', 1, '', 0, 0);

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062

[duketxboy]

Hey my classifieds after updating says this below installed everything I believe correctly... Let me also add I'm the admin & logged in also I've changed all the usergroup settings to allow the classifieds to everybody
* Please Login or Register to be able to Post and Bid in our Classifieds.

[maineGuy72]

Hey my classifieds after updating says this below installed everything I believe correctly... Let me also add I'm the admin & logged in also I've changed all the usergroup settings to allow the classifieds to everybody
* Please Login or Register to be able to Post and Bid in our Classifieds.

you need to go into each usergroup including the administrator group to enable permissions to view and moderate

[duketxboy]

could of swore I did that I'm actually positive I did everything But yeah guess I didn't save thanks

[RSNF]

Where is the place bid option when viewing an auction?

[Jman423]

Chris,

You've missed my question a few times now. Are we supposed to be able to set a premium ad? The only way I can make this work is to go into the database and set it manually, otherwise it never takes.

Also, the tooltip for the "Autopost" feature on the add/edit page is wrong, the code points to the keyword tooltip. I've fixed it on my installation, but you may want to add that to your list.

Another thing, is the marquee only supposed to display the manually entered ads, or can it display the latest ads?

I know you are still working on bugs, but here are some suggestions:

The addition of a "Best Offer" text entry box that works the same as buying a product. If the seller allows "Best Offers", then the buyer can make the offer, and the seller can accept or reject it just like a normal sale.

The ability for a seller to set the "Quantity" of an autoposted ad so that it doesn't just keep re-posting the ad if they seller is sold out.

Also, in your original post, the features for this product still mention the map feature, which, if I am correct, you've removed from v5.

[Christos Teriakis]

For your information, I've finished with searchable extra fields and now I'm working to fix some reported bugs. A new release is scheduled for later on today.

Chris

[Christos Teriakis]

Where is the place bid option when viewing an auction?

Depends on who is viewing the Ad. If you're viewing your own Ad, you'll never see it:D. Otherwise in on the top-right side of the Ad.

Chris

[Christos Teriakis]

no luck.

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO `vb_microclassifieds_search_fields` VALUES (1, 'Field 1', 1, '', 0, 0);

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062


Seems that you messed the import procedure. Most probably the system halted during import but they have already created these fields. I'll be back with a fix for you this evening.

Chris

[Christos Teriakis]

Here is the newest release. In this release:

You can setup up to 10 extra searchable fields. There are 3 types:
Text
Numeric, which can search for:
Lower values
Higher values
Equivalent values.
Droplist
Fixes a problem in categories listing where changing the page, the category condition was lost.
I think that I corrected the bug with non English characters in grids.
Fixed the bug with images extentions in capitals.
Fixed double appearance of My Bookmarks link.Chris

[maineGuy72]

does this update include the random image sidebar code for no images?

also is the block generator only for the CMS version?

[maineGuy72]

update installed and no issues
thanks chris

[Christos Teriakis]

does this update include the random image sidebar code for no images?
Yes

also is the block generator only for the CMS version?
What do you mean? If the CMS is enabled then there are 2 checkboxes. 1-CMS Widget, 2- Forum sidebar. You can check both or one of them.
If CMS is not enabled, then only the Forum sidebar is enabled.

Chris

[nikosb]

hello Chris
the same for me
Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO `vb_microclassifieds_search_fields` VALUES (1, 'Field 1', 1, '', 0, 0);

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062

[maineGuy72]

Yes


What do you mean? If the CMS is enabled then there are 2 checkboxes. 1-CMS Widget, 2- Forum sidebar. You can check both or one of them.
If CMS is not enabled, then only the Forum sidebar is enabled.

Chris

i am running forum classic and dont have cms. i noticed that in the block generator it references cms files. also i can not enter a title and get errors when trying to generate a block

[Christos Teriakis]

hello Chris
the same for me
Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO `vb_microclassifieds_search_fields` VALUES (1, 'Field 1', 1, '', 0, 0);

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062


Are you familiar with phpMyAdmin to empty the table microclassifieds_search_fields ? If not I'll make you a php file to empty them. Sorry, but the problem with Greek, still exists. But I'll fix it.

Chris

[Christos Teriakis]

i am running forum classic and dont have cms. i noticed that in the block generator it references cms files. also i can not enter a title and get errors when trying to generate a block

If you check the code, you'll see that these files are loading only after checking that they exist:

if(@fopen(DIR . '/includes/adminfunctions_cms.php', 'r')==TRUE)
{
require_once(DIR . '/includes/adminfunctions_cms.php');
require_once(DIR . '/includes/functions_cms_layout.php');
$cms_exists = 1;
}


It's strange the problem that you're reporting. I'll wait similar reports from others as for 6 installations that I'm following, works fine.

Chris

[fwulfers]

Thank you, thank you, thank you! The searchable fields functionality is exactly what I was looking for.

The only thing I noticed is the searchable fields are not showing up in the actual Classified. I have 7 extra searchable fields for this classified but none are showing up: http://saabworld.net/classifieds.php?do=viewitem&itemid=5&urlid=2

They are showing up fine in the Advanced Search: http://saabworld.net/classifieds.php?do=search

[Christos Teriakis]

Thank you, thank you, thank you! The searchable fields functionality is exactly what I was looking for.

The only thing I noticed is the searchable fields are not showing up in the actual Classified. I have 7 extra searchable fields for this classified but none are showing up: http://saabworld.net/classifieds.php?do=viewitem&itemid=5&urlid=2

They are showing up fine in the Advanced Search: http://saabworld.net/classifieds.php?do=search

This is the problem if you're 55yo:D:D Ok... I forgot to add them in the view ad page. Now you must wait for tomorrow.

Chris

[fwulfers]

This is the problem if you're 55yo:D:D Ok... I forgot to add them in the view ad page. Now you must wait for tomorrow.Small detail and easy to overlook. :)

Well.... a brief message on how I'm planing to make currencies work. In Mary's version the user has the ability to set a price as number eg 10,000 and besides in another field to write the currency eg Kr. This was usefull for the poster but confused a lot the visitors. Imagine to see a listing of 10 only Ads each one in different currency. In your mind should be difficult to make calculations so you can see which is cheaper. That's why my mod will works with one only currency. This is the first step that I did. The second is to give again the seller the ability to post on his own currency, but should be a real time calculation to show the Ad to visitors in the default currency. Only when the user clicks on "Buy now" (when the online payments will be implement), only then he will see the sellers currency, but this is ok as it will be equaivalent to the price that he has in mind.

We talked about the currency before. Any idea if there will be other currencies in future versions? A realtime calculation to the viewer's own currency would be an awesome feature.

[Christos Teriakis]

Small detail and easy to overlook. :)



We talked about the currency before. Any idea if there will be other currencies in future versions? A realtime calculation to the viewer's own currency would be an awesome feature.

As long as I said that it's on my list, yes, this feature should be add.

Chris

[maineGuy72]

this is the error when i click generate


Invalid block type id on line 825 in xxx/forum/includes/class_block.php


anyone else having this problem?

[fwulfers]

You mentioned the only option to financially support this modification is for the credit removal. I am looking forward to send my support as you have been doing an amazing job in developing and supporting this modification.

[Christos Teriakis]

this is the error when i click generate


Invalid block type id on line 825 in xxx/forum/includes/class_block.php


anyone else having this problem?

I seen the vB code and the meaning is that, you're trying to build a block type "PHP" while this block is not available. Please try to manualy add a block. Can you see the option "Custom HTML/PHP"?

Chris

[Christos Teriakis]

You mentioned the only option to financially support this modification is for the credit removal. I am looking forward to send my support as you have been doing an amazing job in developing and supporting this modification.

In a few days I'll activate a site for it, where you can find more info. I don't like to talk commercially here.

Chris

[nikosb]

Seems that you messed the import procedure. Most probably the system halted during import but they have already created these fields. I'll be back with a fix for you this evening.

Chris


uninstalled ads
I did a new installation
I created a test ADS

and the problem of characters in the title remains

?�?�κ?�?�?�
please help

[maineGuy72]

I seen the vB code and the meaning is that, you're trying to build a block type "PHP" while this block is not available. Please try to manualy add a block. Can you see the option "Custom HTML/PHP"?

Chris

i dont see an option for custom html/php in the block generator (see attached image). there is an option for custom html/php in forum block manager. i used mary's old block generator to create a block code and i posted code in the forum block manger and works fine. i was hoping to use your block generator to have the sliding random ads like in the classified main page.

[Alp Ozdemir]

its make an error on my vbb 4.1.4 like as below

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT * FROM microclassifieds_items WHERE categoryid IN () AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT 10;Database error in vBulletin 4.1.4:

[Goatpod]

Chris, Just noticed what could be a type in the modcp_classifieds.php file:

$includecss['microclassifieds'] = 'microclassifieds/incldues/classifieds.css';

[NTMID8]

I'm getting the following when I click on Get RSS -

This XML file does not appear to have any style information associated with it. The document tree is shown below.

[Jman423]

I give up, my questions have been passed over several times now.

[maineGuy72]

Chris,

You've missed my question a few times now. Are we supposed to be able to set a premium ad? The only way I can make this work is to go into the database and set it manually, otherwise it never takes.

Also, the tooltip for the "Autopost" feature on the add/edit page is wrong, the code points to the keyword tooltip. I've fixed it on my installation, but you may want to add that to your list.

Another thing, is the marquee only supposed to display the manually entered ads, or can it display the latest ads?

I know you are still working on bugs, but here are some suggestions:

The addition of a "Best Offer" text entry box that works the same as buying a product. If the seller allows "Best Offers", then the buyer can make the offer, and the seller can accept or reject it just like a normal sale.

The ability for a seller to set the "Quantity" of an autoposted ad so that it doesn't just keep re-posting the ad if they seller is sold out.

Also, in your original post, the features for this product still mention the map feature, which, if I am correct, you've removed from v5.

the premium ads only work for new ads. the seller must be premium seller with a priority of one and you have to edit the ad after posting and select the premium ad box than save it.

the marquee works as he programed it so and thing done it is a new feature and chris is working on bugs right now so this could be addressed to him later after everything is fixed to his standards

please be patient with chris as he is busting his ass to get this mod updated and fully functional

[maineGuy72]

I'm getting the following when I click on Get RSS -

This XML file does not appear to have any style information associated with it. The document tree is shown below.

check your microclassified templates under style manager for the style you are using. there should be a rss block template there

if you can provide a link to your classifieds and tell us what style you are using it will help us to solve your problem. thanks

[maineGuy72]

its make an error on my vbb 4.1.4 like as below

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT * FROM microclassifieds_items WHERE categoryid IN () AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT 10;Database error in vBulletin 4.1.4:

where did you get the error? on the main classified.php page?
the more info you give the better we can help

[Jman423]

the premium ads only work for new ads. the seller must be premium seller with a priority of one and you have to edit the ad after posting and select the premium ad box than save it.

the marquee works as he programed it so and thing done it is a new feature and chris is working on bugs right now so this could be addressed to him later after everything is fixed to his standards

please be patient with chris as he is busting his ass to get this mod updated and fully functional

I do understand that he is work very hard to get this product right, and I have expressed appreciation and I am planning to donate for his efforts as I am sure others in this thread will also do. I have not only pitched in to help where I can in this thread, but I've also reported bugs as well. Nothing I've posted has been acknowledged, so I never know if he's read, or resolved any issues that I've mentioned.

But, thank you for you reply, you've confirmed that I am not the only seeing these results... and that is all I was looking for.

[Reef Man]

Yes you can. Goto Usergroup permissions and assign rights for each group
Goto Plugins Manager (Just below the Products Manager) and uncheck microCLASSIFIEDS Tab
In microCLASSIFIEDS General settings
From the Phrase manager, or translating the phrases at the end of product_microclassifieds.xml and then re-importing it.Chris


Thank you !!! Testing !

[NTMID8]

check your microclassified templates under style manager for the style you are using. there should be a rss block template there

if you can provide a link to your classifieds and tell us what style you are using it will help us to solve your problem. thanks

I do have that template you mentioned. Here is the link. I only have one style on my site.

http://www.nkyfba.com/forum/classifieds.php

[ChangeFive]

where did you get the error? on the main classified.php page?
the more info you give the better we can help

Fresh install of the newest version and I get the same error when trying to access the main classified.php page.


Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM microclassifieds_items WHERE categoryid IN () AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT 10' at line 1
Error Number : 1064
Request Date : Monday, August 22nd 2011 @ 10:12:11 PM
Error Date : Monday, August 22nd 2011 @ 10:12:11 PM
Script : http://******.net/classifieds.php
Referrer : http://******.net/forum.php
IP Address : ******
Username : ******
Classname : vB_Database
MySQL Version : 5.1.56-log



Also, if I wanted to add an icon next to "Classifieds" in the top navigation bar, where would I put that in the template?

[Christos Teriakis]

I do understand that he is work very hard to get this product right, and I have expressed appreciation and I am planning to donate for his efforts as I am sure others in this thread will also do. I have not only pitched in to help where I can in this thread, but I've also reported bugs as well. Nothing I've posted has been acknowledged, so I never know if he's read, or resolved any issues that I've mentioned.

But, thank you for you reply, you've confirmed that I am not the only seeing these results... and that is all I was looking for.

None question is bypassed. Believe it or not, I've a long paper writing down all them. But I've placed some priorities, otherwise we will never finish:

To add all planed new features. After the release of searchable fields, this has finished (for the moment).
To fix all known bugs, so we can have a stable working version.
To fix any design issue
To change the way that Mary's Classifieds working before.Sorry, but your isssue is on the 4th priority. Sure I'll do it, but I believe that fixing the bugs must have first priority. Don't you agree? If the time comes and see that your question is not answered while there is no other questions, then you can say that I'm ignoring it. Now, please don't say it. There are so many more important issues to fix.

Chris

[Christos Teriakis]

Fresh install of the newest version and I get the same error when trying to access the main classified.php page.


Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM microclassifieds_items WHERE categoryid IN () AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT 10;

Also, if I wanted to add an icon next to "Classifieds" in the top navigation bar, where would I put that in the template?

Please upload the attached file to microclassifieds/includes/

[Christos Teriakis]

its make an error on my vbb 4.1.4 like as below

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT * FROM microclassifieds_items WHERE categoryid IN () AND logo<>'' AND active=1 AND sold=0 AND hidden=0 ORDER BY rand() LIMIT 10;Database error in vBulletin 4.1.4:

Please upload the attached file at: microclassifieds/includes/

[Christos Teriakis]

Chris, Just noticed what could be a type in the modcp_classifieds.php file:

$includecss['microclassifieds'] = 'microclassifieds/incldues/classifieds.css';

Thank you! Corrected.

[Christos Teriakis]

uninstalled ads
I did a new installation
I created a test ADS

and the problem of characters in the title remains

?�?�κ?�?�?�
please help

I know it Niko and I'm working on it.

[Christos Teriakis]

i dont see an option for custom html/php in the block generator (see attached image). there is an option for custom html/php in forum block manager. i used mary's old block generator to create a block code and i posted code in the forum block manger and works fine. i was hoping to use your block generator to have the sliding random ads like in the classified main page.

I'm using vB's Datamanager to automatically add the block in the database and seems that vB has restricted this type of blocks to be auto generating. I'm attaching the old blockgenerator to continue using it. Just upload it anywhere in your site and point your browser there.

Chris

[Alp Ozdemir]

Please upload the attached file at: microclassifieds/includes/

Thanks, it works!

[Alp Ozdemir]

By the way, "watch this category" link not working correctly in classifieds home page and also advanced search too

[DavidExtreme]

thanks chris... very very nice... but i have some question. The Classified is runing well on my default style...but if I switch to custom style, my navbar change like this :
https://vborg.vbsupport.ru/external/2011/08/12.jpg

This is my original custom style :
https://vborg.vbsupport.ru/external/2011/08/13.jpg

Any idea to fix that?


Best Regard
David:)

[Christos Teriakis]

thanks chris... very very nice... but i have some question. The Classified is runing well on my default style...but if I switch to custom style, my navbar change like this :
Any idea to fix that?
Best Regard
David:)

Hello David,

Unfortunatelly you must contact your designer to fix it. As you can see in the code below, I'm using standard vB syntax to show it:

<vb:if condition="$vboptions['selectednavtab'] == 'microclassifieds'">
<li class="selected">
<a class="navtab" href="classifieds.php{vb:raw session.sessionurl_q}">{vb:var vbphrase.microclassifieds_classifieds}</a>
<ul class="floatcontainer">
<li class="popupmenu">
<a href="javascript://" class="popupctrl">{vb:var vbphrase.microclassifieds_whats_new}</a>
<ul class="popupbody popuphover">
<li><a href="classifieds.php{vb:raw session.sessionurl_q}?do=search&date_filter=7&top_search=1">{vb:var vbphrase.microclassifieds_1_week}</a></li>
<li><a href="classifieds.php{vb:raw session.sessionurl_q}?do=search&date_filter=14&top_search=1">{vb:var vbphrase.microclassifieds_2_weeks}</a></li>
<li><a href="classifieds.php{vb:raw session.sessionurl_q}?do=search&date_filter=21&top_search=1">{vb:var vbphrase.microclassifieds_3_weeks}</a></li>
<li><a href="classifieds.php{vb:raw session.sessionurl_q}?do=search&date_filter=30&top_search=1">{vb:var vbphrase.microclassifieds_4_weeks}</a></li>
</ul>
</li>
.................................................. ..


Sorry for not being more helpfull, but I don't know lots about custom designs.

Chris

[DavidExtreme]

ohhhh ok chris..i'll try to contact my designer. Thanks :)

[ChangeFive]

Please upload the attached file to microclassifieds/includes/

Fixed the issue. Thanks!

[maineGuy72]

By the way, "watch this category" link not working correctly in classifieds home page and also advanced search too

i am also getting this error

Redirecting...

Invalid data specified

this is the link
classifieds.php?do=followup&catid=0&action=1

[BWJ]

I have found some phrases that are not translatable within the phrase manager (marked with red):

1)
Displaying rows x to x
(while browsing a category)

2)
This ad expires in x weeks, x days, x hours, xx minutes
(missing phrase for weeks, days, hours and minutes)

3)
Photo, Type, Title, Category, User, Post at, Price, Location
(while browsing a category - each columns headline)

4)
Classifieds
(the tab in user profile)

5)
Possible minor issue:
Browse categories in: *
(* = missing categoryname)

[Christos Teriakis]

I have found some phrases that are not translatable within the phrase manager (marked with red):

1)
Displaying rows x to x
(while browsing a category)

2)
This ad expires in x weeks, x days, x hours, xx minutes
(missing phrase for weeks, days, hours and minutes)

3)
Photo, Type, Title, Category, User, Post at, Price, Location
(while browsing a category - each columns headline)

4)
Classifieds
(the tab in user profile)

5)
Possible minor issue:
Browse categories in: *
(* = missing categoryname)

I know them Brian, as I haven't finished yet with the datagrid. Thank you for reporting.

Chris

[Christos Teriakis]

i am also getting this error

Redirecting...

Invalid data specified

this is the link
classifieds.php?do=followup&catid=0&action=1

Seems that by mistake, I removed the condition check somewhere there. Is not possible to followup a category with id=0. This happens only to homepage.

Chris

[maineGuy72]

hi chris,
it appears that we are running out of errors to report. thats a good thing. keep up the good work

[fwulfers]

When logged in as a regular member, I can't seem to Edit or Delete my own ads. I checked in the Group permissions but there is no setting for something like "Can edit or delete own ads".

Regardless of the maximum image size for uploaded images, the images in the lightbox are always the same size (about 600 px wide). I have my size set to 800 px but that doesn't show when going through the images in the actual classified.

I have added 9 custom fields and the Advanced Search screen is getting very wide and you have to scroll sideways to see them all. This is not a bug though and I am not sure how this can be improved without seeing all fields. Perhaps a Search side bar with all fields, and limited number of fields in the search result pane?
http://saabworld.net/classifieds.php?do=search

I am also having some formatting issues with my site themes/skins. Most of it is formatting all right except when browsing or searching. http://saabworld.net/classifieds.php?do=main&catid=2

Even when switching to a basic vBulletin theme with a few different colors, the headers for the Browse section remains the standard light blue.

I have moved all my ads from the old to this new system and no errors or other problems.

[maineGuy72]

I am also having some formatting issues with my site themes/skins. Most of it is formatting all right except when browsing or searching. http://saabworld.net/classifieds.php?do=main&catid=2

Even when switching to a basic vBulletin theme with a few different colors, the headers for the Browse section remains the standard light blue.

I have moved all my ads from the old to this new system and no errors or other problems.

i think there is 6 different skins for the datgrid. just no option to select them. that light blue bar for browse header is defined by which skin is used. (if i am reading that code correctly) i would have to assume that in the future you will be able to change or even add your own skin to match your site. ofcourse i could be totally wrong.

[Christos Teriakis]

When logged in as a regular member, I can't seem to Edit or Delete my own ads. I checked in the Group permissions but there is no setting for something like "Can edit or delete own ads".

Settings (UserCP)-> My Classifieds. At the right side there is a droplist with the available options according to Ad's status

Regardless of the maximum image size for uploaded images, the images in the lightbox are always the same size (about 600 px wide). I have my size set to 800 px but that doesn't show when going through the images in the actual classified.
I'll check it. It's first time using lightbox but the thumbviewer which Mary's was using is very old.

I have added 9 custom fields and the Advanced Search screen is getting very wide and you have to scroll sideways to see them all. This is not a bug though and I am not sure how this can be improved without seeing all fields. Perhaps a Search side bar with all fields, and limited number of fields in the search result pane?
http://saabworld.net/classifieds.php?do=search
As I've wrote in a previous post I'll add switches to standard fields to turn them On/Off in searching. From that point I can't do something more. But there is a scrolling bar at the bottom. Also avoid to use a lot of extra searchable fields:)

I am also having some formatting issues with my site themes/skins. Most of it is formatting all right except when browsing or searching. http://saabworld.net/classifieds.php?do=main&catid=2

Even when switching to a basic vBulletin theme with a few different colors, the headers for the Browse section remains the standard light blue.

I have moved all my ads from the old to this new system and no errors or other problems.

I'll check it, even if I'm not guru in design.

Chris

[Christos Teriakis]

hi chris,
it appears that we are running out of errors to report. thats a good thing. keep up the good work

Good for you, bad for me, as I'll lost my job:D No work... no job...

[fwulfers]

Settings (UserCP)-> My Classifieds. At the right side there is a droplist with the available options according to Ad's status

Ah yes, I was looking at the bottom of the Classified like how it shows when you belong to a user group that can moderate ads.

As I've wrote in a previous post I'll add switches to standard fields to turn them On/Off in searching. From that point I can't do something more. But there is a scrolling bar at the bottom. Also avoid to use a lot of extra searchable fields:)But the extra fields is the reason for switching to this. :) The change like you described will improve it a lot. Not all fields are important in Search results.

I was also thinking of maybe the possibility of turning off the Weight and Dimensions fields? We don't really have any use for those fields. As you can tell, these are just minor things. Software works great so far.

[maineGuy72]

in datagrid it does not show the category you are browsing in

Browse Classifieds in: and all Subcategories

[maineGuy72]

in dgstyle.css in the datagrid/css folder look for .dgHeader at line 44
this controls the look for the browse in category bar. but for some reason i cant get the background to change even if i take out the background image url. i will keep messing with it

[maineGuy72]

when browsing a category and screen resolution is 1024x768 or less only part of the datagrid is seen and there is no slide bar to view more

not sure how big a deal this is but thought i would point it out

[fwulfers]

Small bug.. When you click on an image in Seller's other items, the link is missing the itemid and results in: Invalid data specified

example:
/classifieds.php?do=viewitem&itemid=&urlid=1&userid=19

When you click on the title next to the image, the itemid is OK.
/classifieds.php?do=viewitem&itemid=20&urlid=1&userid=19

By the way, why would you include the urlid and userid in these links? Just the itemid works fine as well.

[maineGuy72]

another small bug.

when you are on an item page and you click the next or previous ad links that are at the bottom. it is showing ads that are marked as hidden. simple fix with adding to the sql query string

[NTMID8]

I do have that template you mentioned. Here is the link. I only have one style on my site.

http://www.nkyfba.com/forum/classifieds.php

Mike? Chris? Anyone?

[Christos Teriakis]

By the way, why would you include the urlid and userid in these links? Just the itemid works fine as well.

URLid shows me from where someone is reaching viewitem page, so I can activate or not the "Previous-Next" feature, and userid helps me to set a condition in "Previous-Search" to show only Ads from that member. Sure as I know the itemid, I can get the userid with a query. But this adds a query without any special reason, something that I want to avoid. Less queries, faster operation.

Chris

[Christos Teriakis]

another small bug.

when you are on an item page and you click the next or previous ad links that are at the bottom. it is showing ads that are marked as hidden. simple fix with adding to the sql query string

Thank you Mike.

[Christos Teriakis]

when browsing a category and screen resolution is 1024x768 or less only part of the datagrid is seen and there is no slide bar to view more

not sure how big a deal this is but thought i would point it out

I know it Mike, but still haven't finished with datagrid.

[Christos Teriakis]

in dgstyle.css in the datagrid/css folder look for .dgHeader at line 44
this controls the look for the browse in category bar. but for some reason i cant get the background to change even if i take out the background image url. i will keep messing with it

Not there Mike. I'm using the style lightgrey so you need to work with the file:
lightgray/css/dgstyle.css. The one that you're working is when no style has been definied.
But if you're trying to remove that dammit gray padding on left and right, I fixed it even if they broke me nerves to find it. It's coming from vB's body padding, that's why is gray. Wait for the update later on today.

Chris

[Christos Teriakis]

i think there is 6 different skins for the datgrid. just no option to select them.

The option is on classifieds.php. Search for:

$objGrid -> skinimages('lightgray', 'microclassifieds/datagrid/skins/%s/icons/');

It appears 2 times. One for the browsing and one for searching.

Chris

[Christos Teriakis]

Mike? Chris? Anyone?

I'll check the design issues after finishing with the datagrid. Please have patience. I can't do all together.

Chris

[Christos Teriakis]

uninstalled ads
I did a new installation
I created a test ADS

and the problem of characters in the title remains

?�?�κ?�?�?�
please help

Hello Nikos,

If you're familiar with phpMyAdmin can you change the title of any Ad directly with phpMyAdmin and then check how it appears in the grid?

Chris

[nikosb]

changed the title in the table microclassifieds_items
But again appears ����

[ngphuc2k]

Good idea for classifieds.
Thanks

[maineGuy72]

Not there Mike. I'm using the style lightgrey so you need to work with the file:
lightgray/css/dgstyle.css. The one that you're working is when no style has been definied.
But if you're trying to remove that dammit gray padding on left and right, I fixed it even if they broke me nerves to find it. It's coming from vB's body padding, that's why is gray. Wait for the update later on today.

Chris

see the attached image. this is what i am trying to change. the left and right change with whatever style i am using but that part doesnt. when i change the font size or boldness in that dgstyle it changes on the screen so is it using 2 different css files for that one area?

[maineGuy72]

The option is on classifieds.php. Search for:

$objGrid -> skinimages('lightgray', 'microclassifieds/datagrid/skins/%s/icons/');
It appears 2 times. One for the browsing and one for searching.

Chris

i changed it to greenday and nothing changed on the datagrid.
is that becuase it is only lists the icon path and not the css path? that might be why when i change datagrid/css/dgstyle.css it works

[maineGuy72]

changed the title in the table microclassifieds_items
But again appears ?�?�κ?�?�?�

could this be related to the non-alphanumeric characters showing up wrong that i found?

what is the website

[nikosb]

could this be related to the non-alphanumeric characters showing up wrong that i found?

what is the website

http://www.supa.gr/forums/classifieds.php?do=main&catid=1

[Christos Teriakis]

see the attached image. this is what i am trying to change. the left and right change with whatever style i am using but that part doesnt. when i change the font size or boldness in that dgstyle it changes on the screen so is it using 2 different css files for that one area?

This is not something that you can change from the grid's css. There is the body of iframe and thus is the padding that you have in your vB's pages.

Import this new xml file and it will corrects it.

Chris

[Christos Teriakis]

http://www.supa.gr/forums/classifieds.php?do=main&catid=1

When you tried to edit the title with phpMyAdmin, have you wrote the it manually? Better copy a text from in.gr which is utf-8 and paste it there. Then check it.

Chris

[maineGuy72]

This is not something that you can change from the grid's css. There is the body of iframe and thus is the padding that you have in your vB's pages.

Import this new xml file and it will corrects it.

Chris

i am still getting the blue bar

[maineGuy72]

When you tried to edit the title with phpMyAdmin, have you wrote the it manually? Better copy a text from in.gr which is utf-8 and paste it there. Then check it.

Chris

it must be stored correctly in the dbase cause the random ads shows it correctly so does the individual pages.

i have seen some pages online that talk about greek characters not working correctly in jquery. what about adding a js lang pack?

[nikosb]

When you tried to edit the title with phpMyAdmin, have you wrote the it manually? Better copy a text from in.gr which is utf-8 and paste it there. Then check it.

Chris

I copied text from in.gr

no luck on title

[In Omnibus]

microclassifieds/datagrid/class/phpmydatagrid.class refuses to upload. The file continuously attempts to overwrite itself and times out on a peer connection refusal. As a result we've had to uninstall the product, however, upon so doing we are receiving the following database error:

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM vb_microclassifieds_items WHERE active=1 AND sold=0 AND hidden=0 AND categoryid IN (1) AND adtype=1 AND logo<>'' ORDER BY starts DESC LIMIT 5;

MySQL Error : Table 'rhens1.vb_microclassifieds_items' doesn't exist
Error Number : 1146
Request Date : Wednesday, August 24th 2011 @ 07:18:49 AM
Error Date : Wednesday, August 24th 2011 @ 07:18:49 AM
Script : http://www.prosportsinteractive.net/forum.php
Referrer : http://www.prosportsinteractive.net/content/
IP Address : 74.65.81.4
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.91-log

The product has been uninstalled and all uploaded files have been manually deleted. All existing tables named "microclassifieds_" have also been deleted. Any help would be greatly appreciated.

[maineGuy72]

The product has been uninstalled and all uploaded files have been manually deleted. All existing tables named "microclassifieds_" have also been deleted. Any help would be greatly appreciated.

your forum page is giving off dbase errors
http://www.prosportsinteractive.net/forum.php
you might need to correct this first. once that is fixed the classified section might work too

[Christos Teriakis]

i am still getting the blue bar

Mike I'll kill you:D The blue bar you want to change or to remove that padding from left and right? If you want to change the style you need to edit the templates:
microclassifieds_searchgrid
microclassifieds_browsegrid


<link type='text/css' rel='stylesheet' href='microclassifieds/datagrid/skins/lightgray/css/dgstyle.css' />

[maineGuy72]

i dont want to change the padding i want to change the color of the bar to match the style i am using. the templates make no reference to the color and i have changed both css sheets and nothing happens. i can change the font and font style but cant get rid of the stupid color. agghhh.

i will figure it out if it kills me. you dont need to dewl on it i will get it or die trying.

**i just changed the skin to greenday and its close enough for me to match the style. lol

[Christos Teriakis]

i dont want to change the padding i want to change the color of the bar to match the style i am using. the templates make no reference to the color and i have changed both css sheets and nothing happens. i can change the font and font style but cant get rid of the stupid color. agghhh.

i will figure it out if it kills me. you dont need to dewl on it i will get it or die trying.

I placed that "stupid" color there and is not color. If you do a right click on the header you'll see that it's a background image.
microclassifieds/datagrid/styles/lightgray/css/dgstyle.css

.dgHeader, .dg_dataTable .editTitle
{
background: #7192a8 url(../icons/headerbg.png) repeat-x;
border: 1px solid #5a7f97;
color: #FFFFFF;
}


If you change only the color, you're doing a hole in the water. Nothing. You must remove the url(......

Chris

[maineGuy72]

i removed the url reference

.dgHeader, .dg_dataTable .editTitle
{
background-color: #545E4A;
border: 1px solid #5a7f97;
color: #FFFFFF;
}


and it still didnt go away. im just gonna go with the greenday skin. not worth pulling my hair out for a background

[In Omnibus]

your forum page is giving off dbase errors
http://www.prosportsinteractive.net/forum.php
you might need to correct this first. once that is fixed the classified section might work too

Your modification is causing the error:

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM vb_microclassifieds_items WHERE active=1 AND sold=0 AND hidden=0 AND categoryid IN (1) AND adtype=1 AND logo<>'' ORDER BY starts DESC LIMIT 5;

MySQL Error : Unknown column 'hidden' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 24th 2011 @ 08:56:02 AM
Error Date : Wednesday, August 24th 2011 @ 08:56:02 AM
Script : http://www.prosportsinteractive.net/forum.php
Referrer : http://www.prosportsinteractive.net/content/
IP Address : 74.65.81.4
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.91-log

[maineGuy72]

i can get to the forum main page now but when i try the classified page it says page not found
what is the link to the classifieds?

it looks like this error is different from the last. i would try installing the xml file again with the overright option checked. maybe not all the tables we created correctly

[maineGuy72]

Mike? Chris? Anyone?

what version of PHP, VB and MySQL are you using?

this is the error i am getting


Deprecated: Assigning the return value of new by reference is deprecated in /home/cbinder/public_html/forum/classifieds.php on line 487

Warning: array_merge() [function.array-merge (http://www.nkyfba.com/forum/function.array-merge)]: Argument #1 is not an array in [path]/includes/functions_databuild.php on line 2186

[maineGuy72]

i posted a message on the jquery site asking about the greek characters if i hear anything i will let you know

[Christos Teriakis]

The product has been uninstalled and all uploaded files have been manually deleted. All existing tables named "microclassifieds_" have also been deleted. Any help would be greatly appreciated.
Are you sure that you've deleted the microclassifieds_cron.php at vb_inst/includes/cron/ ?

Most probably a cron tried to run.

Chris

[Christos Teriakis]

changed the title in the table microclassifieds_items
But again appears ?�?�κ?�?�?�

Don't worry. I've always an alternative way. But I don't like to drop so easy 1 week of full work and $250 that I paid for it. Check at:
http://www.christeris.net/vb4/classifieds.php?do=ajaxsearch
As you can see you can read even Greek there, combined with Spanish, Chinese, Cyrillic etc.

Chris

[maineGuy72]

Don't worry. I've always an alternative way. But I don't like to drop so easy 1 week of full work and $250 that I paid for it. Check at:
http://www.christeris.net/vb4/classifieds.php?do=ajaxsearch
As you can see you can read even Greek there, combined with Spanish, Chinese, Cyrillic etc.

Chris


i like a challenge :)

[Warlord]

Please upload the attached file at: microclassifieds/includes/

I was getting a SQL error so I tried the above fix and uploaded the attached functions.php in the above post to microclassifieds/includes/ but now I am getting this error.

Parse error: syntax error, unexpected '(', expecting T_VARIABLE or '$' in /home/righscom/public_html/vb/includes/class_core.php(4041) : eval()'d code on line 34

I'm running vBulletin? Version 4.0.1 Patch Level 1

Any ideas?

[maineGuy72]

I was getting a SQL error so I tried the above fix and uploaded the attached functions.php in the above post to microclassifieds/includes/ but now I am getting this error.



I'm running vBulletin? Version 4.0.1 Patch Level 1

Any ideas?

version 5.x.x, which is also known as the Pro version, is only compatible with vB 4.0.8 or newer.

i would highly recommend updating your VB

[Christos Teriakis]

I was getting a SQL error so I tried the above fix and uploaded the attached functions.php in the above post to microclassifieds/includes/ but now I am getting this error.



I'm running vBulletin? Version 4.0.1 Patch Level 1

Any ideas?

4.0.1? Needs at least 4.0.8. Sorry.

[Christos Teriakis]

i like a challenge :)

Really??? I forgot to say that this costs $465:D:D:D But ok, have lots of features.

[In Omnibus]

Found the table entry. Was able to delete it. Now to contact the host regarding why the class file won't upload. That problem is in no way your modification. Apologies for any perceived rudeness on my part. Rather frustrating to be at a complete loss.

[maineGuy72]

Really??? I forgot to say that this costs $465:D:D:D But ok, have lots of features.

if there is anything i can help with let me know i get really bored at night. what country are you in anyways?

[Christos Teriakis]

Apologies for any perceived rudeness on my part. Rather frustrating to be at a complete loss.

Come on... no worries at all... All of us have same reactions.... I'm having some problems with the grid, as you can read here, and every 10 minutes I'm standing off my desk and kicking the wall :-)