Facebook  Twitter 


+- +-


+- User Information

Welcome, Guest.
Please login or register.
Forgot your password?

+- Forum Stats

Total Members: 12370
Latest: laurieb
New This Month: 1
New This Week: 1
New Today: 0
Total Posts: 40210
Total Topics: 7081
Most Online Today: 162
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 25
Total: 25

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - vkot

Pages: [1] 2
Bugs / Undefined index
« on: September 03, 2015, 04:30:13 am »
I have the following error messages in my SMF log. I quote the relevant line in Sources/classifieds2.php
My SMF Classifieds version is 3.0.2

Undefined index: qtyinstock
Code: [Select]
  $qtyinstock = (int) $_REQUEST['qtyinstock'];
Undefined index: cat
Code: [Select]
$cat = (int) $_REQUEST['cat'];
Undefined index: t
Code: [Select]
$termsid = (int) $_REQUEST['t'];
Undefined index: catid
Code: [Select]
$catid = (int) $_REQUEST['catid'];
Are these corrected in version 4? Or am I missing something? (for example, maybe the database was not updated properly when I updated to 3.0.2)

Support / Not show closed/expired listings (code hack)
« on: March 05, 2014, 03:19:39 am »
I realize that there is no use for the viewers to see the listings that are closed/expired, so I decided to change the SQL queries to exclude these. Here is what I have done, and it's working (tested in version 3.0.2 and SMF 2.0.x). If you try it and see that I have missed something, please say so.

In classifieds2.template.php change:
for page count:
Code: [Select]
WHERE removed = 0 AND ID_CAT = $cat AND approved = 1");to:
Code: [Select]
WHERE removed = 0 AND ID_CAT = $cat AND approved = 1 AND UNIX_TIMESTAMP() < expiredate");
for view listings:
Code: [Select]
WHERE  i.removed = 0 AND i.ID_CAT = $cat AND i.approved = 1to:
Code: [Select]
WHERE  i.removed = 0 AND i.ID_CAT = $cat AND i.approved = 1 AND UNIX_TIMESTAMP() < i.expiredate
for search results:
Code: [Select]
WHERE  i.approved = 1 " . $class_where ." AND  (" . $context['class_search_query'] . ")to:
Code: [Select]
WHERE  i.approved = 1 " . $class_where ." AND  (" . $context['class_search_query'] . ") AND UNIX_TIMESTAMP() < i.expiredate

Feature Requests / Custom fields in listing index
« on: June 07, 2011, 12:16:55 pm »
Can you make Custom fields be showing in the category's listing index? ( index.php?action=classifieds;cat=... ) I have set the custom field "Location", and my members would like to be able to see it in the index, and not having to open every listing individually.

I have tried to modify classifieds template, by adding to the SQL query under "// Show the classifieds" and then adding the parameter in function ClassifiedsShowListingsRow but it didn't work. Can you modify the SQL query for me? I'll do the rest.

Feature Requests / Share classifieds on facebook etc.
« on: September 23, 2010, 06:19:24 am »
It would be nice if we could share our (or other's) classifieds listings on facebook and other sites.

For example, for facebook you just have to add the following code in function template_viewlisting(), somewhere near the button "Send to a friend" I guess:
Code: [Select]
// vkot facebook share
echo '<a name="fb_share" type="icon_link" share_url="' . $scripturl . '?action=classifieds;sa=view;id=' . $context['class_listing']['ID_LISTING']">Share on facebook</a>
<script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script>';

I have already tried it, and it forms the URL correctly, but facebook recognizes the home page of my forum, I don't know why...  :-\

Bugs / 'cannot post classifieds/comments' restriction
« on: July 14, 2010, 03:50:47 pm »
Presently. when someone gets banned -not fully, but only with the 'cannot post' restriction- he still can post classifieds!

This is a problem... For example, in my case, a member is accused of fraud and I wanted to send him a PM requesting explanations while prohibiting him from posting new classifieds. I ended up banning him fully, with no questions asked.
The 'no new classifieds' and 'no comments in classifieds' restrictions should take place automatically along with the 'cannot post', during the warning level increase also.

Bugs / Many errors...
« on: May 06, 2010, 05:02:51 am »
I have many of the following errors in my SMF's error logs:

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 'WHERE l.ID_TAG = t.ID_TAG AND l.ID_LISTING = '15302' AND t.tag = 'Korg'' at line 2
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 7989
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 '' at line 4
File: /xxxxxx/forum/httpdocs/Sources/Load.php(2087) : eval()'d code
Line: 2360
8: Undefined index: new
File: /xxxxxx/forum/httpdocs/cache/lang_classifieds_greek_default.php (main sub template - eval?)
Line: 250
8: Undefined index: id
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 3528
8: Undefined variable: orderby2
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 6241
8: Undefined variable: sortby2
File: /xxxxxx/forum/httpdocs/Sources/classifieds2.php
Line: 6241
8: Undefined index: class_listall_type
File: /xxxxxx/forum/httpdocs/Themes/default/classifieds2.template.php (member_listings sub template - eval?)
Line: 7220

Feature Requests / Report to moderator
« on: August 08, 2009, 08:45:52 am »
I would be nice if there was a link "Report to moderator" (or something like this) for each listing.
Some users send improper listings, or in wrong category, and users should be able to report them to moderators so that action will be taken.

Bugs / Errors in SMF's error log
« on: September 26, 2008, 02:32:17 am »
1) It seems that you must escape the single quotes, etc. in the listing title:
Hacking attempt...

INSERT INTO personal_messages
(ID_MEMBER_FROM, deletedBySender, fromName, msgtime, subject, body)
VALUES (0, 1, SUBSTRING('Σύστημα Αγγελιών', 1, 255), 1222408958, SUBSTRING('Η καταχώρηση έληξε i'm looking for drams and base............', 1, 255), SUBSTRING('Η καταχώρησή σας "i'm looking for drams and base............" έχει λήξει και αφαιρέθηκε.', 1, 65534))
Αρχείο: /xxx/xxx/xxx/public_html/forum/Sources/Subs-Post.php
Γραμμή: 809
The above error was when a listing expires and gets deleted and a PM is sent. But as I saw in classifieds.php, every $row[title] whenever sendpm() function is called, need to be escaped.
While you're at it, check if there are more strings elsewhere that should be escaped.

2) Problem with index noprice:
8: Undefined index: noprice
Αρχείο: /xxx/xxx/xxx/public_html/forum/Themes/default/classifieds.template.php (listall sub template - eval?)
Γραμμή: 6335 (and line 6341)
Maybe my line numbers are different than yours (I did some template modifications), so here are the relevant lines:
               if ($modSettings['class_catlist_currentprice'] && $context['noprice'] == 0)
               if ($modSettings['class_catlist_numofbids'] && $context['noprice'] == 0)

3) Problem with index class_error_no_picture:
8: Undefined index: class_error_no_picture
Αρχείο: /xxx/xxx/xxx/public_html/forum/Sources/classifieds.php
Γραμμή: 3315

4) Problem with index visual_verification:
8: Undefined index: visual_verification
Αρχείο: /xxx/xxx/xxx/public_html/forum/Themes/default/languages/Post.greek.php (addcomment sub template - eval?)
Γραμμή: 3148
   if ($context['visual_verification'] == true && $context['user']['is_guest'] == true)

5) Problem with index classifieds:
8: Undefined index: classifieds
Αρχείο: /xxx/xxx/xxx/public_html/forum/Themes/default/classifieds.template.php (search sub template - eval?)
Γραμμή: 4991
                  ', template_button_strip($context['classifieds']['buttons'], 'top'), '

6) Problem with index shipping:
8: Undefined index: shipping
Αρχείο: /xxx/xxx/xxx/public_html/forum/Sources/classifieds.php
Γραμμή: 791
   $shipping = (double) $_REQUEST['shipping'];

7) I couldn't find where exactly is the error here:
2: Invalid argument supplied for foreach()
Αρχείο: /xxx/xxx/xxx/public_html/forum/Themes/default/classifieds.template.php (search sub template - eval?)
Γραμμή: 667
         MainPageBlock($txt['class_main_recent'], 'recent');

Feature Requests / Changes in the template
« on: September 16, 2008, 03:54:00 am »
1) Can we have the member's avatar and No. of posts under the member's name on the listing page? Like it is shown for the member that makes a comment.

2) The link "View More Pictures" should be shown only when there are more pictures than the ones shown in the listing page, and not always.

3) It would be better to change the table layout in the listing page: Now the member's name etc. reserve a whole column until the end of the listing, space that could be used for the Description (to make it have the whole table width).

Feature Requests / Move listing to forum
« on: August 19, 2008, 03:48:29 am »
Can we have an option in the "admin listing" page to move a listing to the SMF forum?

It happens that some times my users write listings that would be more appropriate as a forum topic, in a board that I choose each time.

Feature Requests / Recent comments
« on: August 14, 2008, 05:24:44 am »
I'd like to have a list of recent comments on the classifieds' first page (and maybe on the SMF's 1st page too). This is because sometimes there are discussions going on under a listing, and everyone should be able to see if someone said something new.

I would prefer a list like the one in the 1st page of SMF, with only the catecory, listing title, comment sender, date

Just for a quick try, I started with an SQL statement like this:

Code: [Select]
SELECT i.ID_LISTING, i.commenttotal, i.title, i.ID_CAT,
m.approved, m.date, m.comment, m.ID_COMMENT
FROM class_listing AS i, class_comment AS m
WHERE i.commenttotal >0 AND m.ID_LISTING = i.ID_LISTING AND i.removed =0 AND i.approved =1 AND m.approved =1

but I don't know how/where I should embed it in the classifieds.template.php file

Support / Documentation
« on: August 05, 2008, 05:23:32 am »
I haven't understood some of smf classifieds' features:

1) What are the "credits" and how are they used? I give free credits to me and to others but nothing changes. And except for "free credits" what other kind of credits exist and where will I find them?
2) What are the "listing orders"? What do they do? How can someone "order a listing"?
3) What is the "Custom Price"? Is it the price someone has to pay to put a listing? And what is the "Group Join Url"?

Can someone explain? Is there a documentation somewhere?
I really need to understand everything about how smf classifieds works, because I want to finish the greek translation.

Feature Requests / Display of time left
« on: July 06, 2008, 01:49:41 am »
OK, I open a new thread for this:

I would like the display of the time left (for listing/auction) to be customizable.

I prefer a display like: ddd days, hh:mm which is shorter.
This could be in an option in the admin page, or in a costant in the template.

or maybe you could do something more complex like this:
- if time left > 1 day, show "ddd days"
- if time left < 1 day, show "hh hours, mm minutes"
- if time left < 1 hour, show "mm minutes"

Feature Requests / date format
« on: July 02, 2008, 05:19:35 am »
The date format should be customizable. In Europe we use the day before the month, so now I have to change by hand every "m/d/Y" to "d/m/y" in every date() function in classifieds.template.php. Also, I change "h:i a" to "H:i" because we don't use "am/pm" in Greece.
The type of format should be in a variable or constant, somewhere.

Also, how can I change the display of time left in the listings index? It shows something like: 107d 4h 21m. I want to change the letters d, h, m.

Feature Requests / recycle bin for completed ads
« on: April 29, 2008, 12:40:25 pm »
After seeing this http://www.smfhacks.com/index.php/topic,1467.0.html I thought that "completed" ads should be moved automatically to the recycle bin too!

You know, it's difficult to keep up with more than a thousand ads (that we have) and delete the completed ones manually! And still, they don't go to the recycle bin but are deleted permanently. The ideal would be: move the completed ones to the recycle bin automatically the moment that they are completed, and then leave them there for a few days for the members to see that it has completed and not disappeared. Then, they will be deleted permanently (automatically, manually, or with some SQL script)

Pages: [1] 2

+- Recent Topics

Download System Lite by Rock Lee
June 03, 2020, 07:34:24 pm

Font question by SMFHacks
May 27, 2020, 08:15:26 am

Error message with latest SMF 2.1 Github build by Hatshepsut
May 25, 2020, 01:43:26 am

smfblog not working on 2.0.17 by tech9
May 20, 2020, 01:44:34 pm

Copyright removal by stbc
May 18, 2020, 01:27:57 am

Mod Verified User i can't square the image by Rock Lee
May 07, 2020, 07:56:10 pm

SMF4Mobile 2.0 released for SMF 2.0.x by SMFHacks
May 06, 2020, 12:13:14 pm

SMF Social Login Pro - Discontinued? by Nicole
May 02, 2020, 05:47:04 pm

Likes by SMFHacks
April 30, 2020, 09:50:35 pm

Upgrade Issue - by SMFHacks
April 28, 2020, 12:40:13 pm

Powered by EzPortal