vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Classifieds (https://vborg.vbsupport.ru/showthread.php?t=205236)

Spoolin 03-11-2009 05:01 AM

For some strange odd reason I installed this hack and cant find where under the usergroup permissions you can allow permission to see the classifieds?? Am I missing something?

Spoolin 03-11-2009 02:59 PM

Okay I fixed that issue. Seems I did not upload a couple of directory files.
I have a new issue now when clicking the "Add Classified" link. I get an error message.....

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT id, name FROM classifieds_subcategories

WHERE categoryid= ORDER BY displayorder;

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 'ORDER BY displayorder' at line 3
Error Number : 1064
Request Date : Wednesday, March 11th 2009 @ 08:58:38 AM
Error Date : Wednesday, March 11th 2009 @ 08:58:38 AM
Script : http://bsdsmforums.org/classifieds.p...d=0&subcatid=0
Referrer : http://bsdsmforums.org/classifieds.php
IP Address : 72.87.68.19
Username : Spoolin
Classname : vB_Database
MySQL Version : 5.0.67-log

MaryTheG(r)eek 03-11-2009 03:08 PM

Quote:

Originally Posted by Spoolin (Post 1765773)
Invalid SQL:
SELECT id, name FROM classifieds_subcategories

WHERE categoryid= ORDER BY displayorder;

As you supposed, the error comes as there are no categories (categoryid=). You can add categories/subcategories from the admincp.


Mary

Spoolin 03-11-2009 03:17 PM

Nevermind figured it out! It would help if I added categories!

freewilley 03-11-2009 09:02 PM

its nice to see mary back with this.. good work..

Ozidoggy 03-12-2009 12:39 AM

Is there a way of showing random/latest classifieds on the forumhome page? Or will this be a future feature?

GREAT mod - I am currently using photopost classifieds.. But will be changing to yours!

Thanks

Ozidoggy 03-12-2009 01:53 AM

For some reason photos are not uploading or showing.

I have CHMOD 777 photos, thumbs, tmp. I have in usergroups allowed user to post 5 photos.

Also when I select number of photos to say '3' it only allows one photo to be up loaded.

Not sure why photos are not up loading

Anonymous ? 03-12-2009 03:36 PM

Mary, there is a typo in your code (1.2.0):
Quote:


<a href="classifieds.php?do=do=deletead&adid=$ad[id]&title=$title"><b>$vbphrase[classifieds_reject]</b></a>
Thanks!

Michigan Morels 03-19-2009 04:55 PM

*SOLVED*

Some questions.

[s]1. Why do all new ads automatically show up as sponsored and premium ads? What is the sponsored and premium ad status for, if all ads are tagged this way unless I manually remove the status one by one?[/s] edit: I found answer to this in 3.8 mod thread.

[s]2. Some members (sellers) do not use Paypal.
If no email address is entered for Paypal payments, buyer is still directed to fill out the form, and then is taken to pay-pal site just to see error about no valid email address. I believe this would irritate the potential buyer.
Is there a way to automatically remove (or hide), the "buy it link and image" from displaying, when seller does not accept pay-pal? Maybe redirect them to PM the seller for info.[/s] edit: I found solution to this.

[s]3. Is there anyway for seller to "close an ad", or "mark it Sold" after they have sold the items listed in an ad? Some way so that people could not be send payments after the seller has sold out.[/s] edit: after reading in 3.8 mods thread, I don't believe this is possible dur to the fact that you have sellers using paypal and some not using it. Those not using paypal would not have any basis to mark sold off of.


I've clicked "installed" but only have it on my test site right now until I understand it better. So far :up: I like it.

Thanks for your help.

MaryTheG(r)eek 03-19-2009 05:26 PM

Quote:

Originally Posted by freewilley (Post 1766018)
its nice to see mary back with this.. good work..

Thank you:)


All times are GMT. The time now is 07:40 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01342 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete