Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11795
Latest: LaurieluvsGH
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 41468
Total Topics: 7262
Most Online Today: 79
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 33
Total: 33

Author Topic: Custom Fields (Select Field) error [{$db_prefix}]  (Read 2763 times)

0 Members and 1 Guest are viewing this topic.

Offline Darkshadow

  • Jr. Member
  • **
  • Posts: 65
    • View Profile
    • Dark Mysterious Worlds
Custom Fields (Select Field) error [{$db_prefix}]
« on: May 15, 2009, 03:14:14 am »
ok, i have an item and want add a custom listfield, after i added them i want to enter the list entrys.

Now the problem occur,: error message: field item_custom_field not found
after i fix it in the store.php (look in added code)

next error occur: field store_item not found
after i fix it in the store.php (look in added code)

everything worked fine...


My working fix:

Code: [Select]
function ManageSelectBox()
{
global $context, $txt, $mbname;

isAllowedTo('smfstore_manage');

$id = (int) $_REQUEST['id'];

$context['store_selectid'] = $id;

$context['page_title'] =  $mbname . ' - ' . $txt['store_txt_maange_select_fields'];

$context['sub_template']  = 'manage_select';

// Get item id
$dbresult = db_query("
SELECT
title, ID_ITEM
FROM smf_store_item_custom_field
WHERE ID_FIELD = $id  LIMIT 1", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult);
mysql_free_result($dbresult);



// Get Product Name
$dbresult = db_query("
SELECT
productname
FROM smf_store_item
WHERE ID_ITEM = " . $row['ID_ITEM'] . " LIMIT 1", __FILE__, __LINE__);
$productRow = mysql_fetch_assoc($dbresult);
mysql_free_result($dbresult);



But this should not a permanent solution, plese fix the {$db_prefix} in this area, so it contained the "smf_" prefix

I have no idea why to hell the string "smf_" are lost in this area... The "AddSelect()" function after the "ManageSelectBox()" function work with the {$db_prefix} without problems...

Please respond to my other errors i postet yesterday in classifieds system...

Darkshadow
« Last Edit: May 15, 2009, 03:43:28 am by Darkshadow »

 

Related Topics

  Subject / Started by Replies Last post
10 Replies
6965 Views
Last post June 21, 2009, 08:35:51 pm
by SMFHacks
1 Replies
3370 Views
Last post February 26, 2009, 11:26:31 pm
by SMFHacks
15 Replies
11632 Views
Last post August 16, 2009, 12:53:38 am
by Vincent Volmer
1 Replies
3311 Views
Last post September 17, 2010, 09:09:31 am
by Vincent Volmer
0 Replies
2530 Views
Last post July 22, 2011, 05:02:43 am
by Xtreme4U2NV

+- Recent Topics

Question (Gallery Pro) by mickjav
Today at 11:59:10 am

Image View by SMFHacks
October 14, 2021, 11:55:21 am

From SMF Gallery Lite to SMF Gallery Pro by SMFHacks
October 11, 2021, 08:00:29 am

Picture Orientation by mickjav
October 09, 2021, 01:25:54 pm

4. Global Headers and Footers by mickjav
October 07, 2021, 12:22:09 am

S3 System For SMF Attachments by shuban
October 06, 2021, 07:58:50 am

Download Page images by mickjav
October 04, 2021, 01:28:07 pm

Agree To Licence by mickjav
October 03, 2021, 10:00:27 am

Install Problems by mickjav
October 01, 2021, 01:33:14 pm

Can SMF2WPBridge bridge SMF membergroups into WP? by SMFHacks
September 30, 2021, 02:07:34 pm

Powered by EzPortal