Topic: Error in the code database

[lazo50]

Hello everyone .... I have encountered this problem:
SP is installed without pointing out errors but does not accept any block in PHP error reporting this:
Error in the code database

All other bloks work...I already tried to uninstall and then install SP but the error remains

TNX

[Burke Knight]

Are you sure the coding is done right?

Enable this option for now: Admin > SimplePortal > General Settings > Disable PHP Validation. That would make it skip the validation.

Please post one of the PHP blocks you are having issues with within code tags here & someone will verify the code. This way can see if you are attempting to save something that possibly has incorrect structure which is resulting in an error whilst attempting to save the block.

  When attempting to display HTML within PHP one must use the echo command with the HTML encased in quotes/single-quotes and then followed by a semi-colon. The easiest way is to encase in single-quotes and when actual single-quotes are required for display and/or javascript you use a backslash prior to that character.

ie. PHP to display HTML

Code: [Select]

echo 'This is an example of displaying HTML within SimplePortal\'s PHP block structure.';
echo 'A quote: "This is a quote!" ... quotes can be used within single quotes.';

$a = 'This is a variable being assigned using PHP.';

echo $a;


Hope those above help out.

[lazo50]

Disabling the control PHP is working.
This is the code

Code: [Select]

function display_tags_block()
{
// For TaggingSystem2.4.3
// System created by vbgamer45

global $txt, $smcFunc, $modSettings, $scripturl, $context, $user_info;

if (!isset($modSettings['smftags_set_cloud_tags_to_show']))
echo 'There are no tags to show...';

echo '
<div align="center">';

$result = $smcFunc['db_query']('', '
SELECT
t.tag AS tag, l.ID_TAG, COUNT(l.ID_TAG) AS quantity
FROM {db_prefix}tags as t, {db_prefix}tags_log as l WHERE t.ID_TAG = l.ID_TAG
GROUP BY l.ID_TAG
ORDER BY l.ID DESC
LIMIT {int:limit}',
array(
'limit' => $modSettings['smftags_set_cloud_tags_to_show'],
)
);

$tags = array();
$tags2 = array();

while ($row = $smcFunc['db_fetch_assoc']($result))
{
$tags[$row['tag']] = $row['quantity'];
$tags2[$row['tag']] = $row['ID_TAG'];
}

if (count($tags2) > 0)
{
$max_size = $modSettings['smftags_set_cloud_max_font_size_precent'];
$min_size = $modSettings['smftags_set_cloud_min_font_size_precent'];

$max_qty = max(array_values($tags));
$min_qty = min(array_values($tags));

$spread = $max_qty - $min_qty;
if (0 == $spread)
    $spread = 1;

$step = ($max_size - $min_size)/($spread);

$context['poptags'] = '';
$row_count = 0;

foreach ($tags as $key => $value)
{
$row_count++;
$size = $min_size + (($value - $min_qty) * $step);

// uncomment if you want sizes in whole %:
// $size = ceil($size);

$context['poptags'] .= '<a href="' . $scripturl . '?action=tags;tagid=' . $tags2[$key] . '" style="font-size: '.$size.'%"';

$context['poptags'] .= ' title="' . $value . ' things tagged with ' . $key . '"';
$context['poptags'] .= '>' . $key . '</a> ';

if ($row_count > ($modSettings['smftags_set_cloud_tags_per_row']-1))
{
$context['poptags'] .= '<br />';
$row_count = 0;
}
}
}

if (isset($context['poptags']))
  echo $context['poptags'];


echo '
</div>';
}

display_tags_block();

Many TNX

[Chen Zhen]

lazo50,

  Do not forget the logic for else .. if $modSettings['smftags_set_cloud_tags_to_show'] is empty then you will get an error with what you just posted.