//
function REGISTER_FILL_MUST_CONSTANTS()
{
- $result = SQL_QUERY("SELECT field_name, field_required FROM "._MYSQL_PREFIX."_must_register ORDER BY id", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT field_name, field_required FROM `{!MYSQL_PREFIX!}_must_register` ORDER BY id", __FILE__, __LINE__);
while(list($name, $required) = SQL_FETCHROW($result)) {
$value = "";
if ($required == "Y") $value = "<div class=\\\"guest_failed\\\"> (*)</div>";
$ret = false;
foreach ($array as $key => $value)
{
- $result = SQL_QUERY("SELECT field_required FROM "._MYSQL_PREFIX."_must_register WHERE field_name='".$key."' LIMIT 1", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT field_required FROM `{!MYSQL_PREFIX!}_must_register` WHERE field_name='".$key."' LIMIT 1", __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1)
{
// "Must-line" found
//
function REGISTER_OUTPUT_REQUIRE_CHECK(&$array)
{
- $result = SQL_QUERY("SELECT field_name, field_required FROM "._MYSQL_PREFIX."_must_register ORDER BY id", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT field_name, field_required FROM `{!MYSQL_PREFIX!}_must_register` ORDER BY id", __FILE__, __LINE__);
while(list($name, $required) = SQL_FETCHROW($result))
{
if (($array[$name] == "!") && ($required == "Y")) {
// Admins are allowed to see every category...
if (IS_ADMIN()) $AND = "";
- $result = SQL_QUERY("SELECT id, cat, visible FROM "._MYSQL_PREFIX."_cats ".$AND." ORDER BY sort", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT id, cat, visible FROM `{!MYSQL_PREFIX!}_cats` ".$AND." ORDER BY sort", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0)
{
// List alle visible modules (or all to the admin)