Can someone tell me where this block script is located?

Regular Joined: Mar 10, 2005 Posts: 90

I got a problem like image below, i did a cant remember what a modification that i did. But i need is just to know which page of file/script for this Admin block where i can fix that "?" sign

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Some versions / distributions have this in the mainfile, while others have an administration block.

Posted: Thu Oct 12, 2006 7:18 am

kguske wrote:

Some versions / distributions have this in the mainfile, while others have an administration block.

Thanxs for your reply, i already check on mainfile.php file where i think it should be around here:

On line 869

Code:




function adminblock() {


    global $admin, $prefix, $db, $admin_file;


    if (is_admin($admin)) {


   $result = $db->sql_query("SELECT title, content FROM ".$prefix."_blocks WHERE bkey='admin'");


   while ($row = $db->sql_fetchrow($result)) {


       $content = "<font class=\"content\">$row[content]</font>";


       themesidebox($row[title], $row[content]);


   }


   $title = ""._WAITINGCONT."";


   $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_queue"));


   $content = "<font class=\"content\">";


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=submissions\">"._SUBMISSIONS."</a>: $num<br>";


   $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_reviews_add"));


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=reviews\">"._WREVIEWS."</a>: $num<br>";


   $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_newlink"));


   $brokenl = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_modrequest WHERE brokenlink='1'"));


   $modreql = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_modrequest WHERE brokenlink='0'"));


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=Links\">"._WLINKS."</a>: $num<br>";


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=LinksListModRequests\">"._MODREQLINKS."</a>: $modreql<br>";


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: $brokenl<br>";


   $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_newdownload"));


   $brokend = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_modrequest WHERE brokendownload='1'"));


   $modreqd = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_modrequest WHERE brokendownload='0'"));


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=downloads\">"._UDOWNLOADS."</a>: $num<br>";


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=DownloadsListModRequests\">"._MODREQDOWN."</a>: $modreqd<br>";


   $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=DownloadsListBrokenDownloads\">"._BROKENDOWN."</a>: $brokend<br></font>";


   themesidebox($title, $content);


    }


}

From that code i can "trace" syntax for "Waiting Content" but for Administration i "cant read" that code. Is that a code for admin is this:

Code:




$result = $db->sql_query("SELECT title, content FROM ".$prefix."_blocks WHERE bkey='admin'");

But wheres is that sign "?" should be located?

registered · Posted: Thu Oct 12, 2006 8:27 am

? usually means its not reading the · correctly

Check your character set and make sure your server and your HTML code are using the same character set (UTF-8 or ISO-8859-1)

Regular Joined: Oct 01, 2006 Posts: 50 Location: UK

I had this problem on a site and gave up with the middot code and used the <li> to get same effect.

Posted: Thu Oct 12, 2006 1:39 pm

evaders99 wrote:

? usually means its not reading the · correctly

Check your character set and make sure your server and your HTML code are using the same character set (UTF-8 or ISO-8859-1)

Where i can set/config it?

Posted: Thu Oct 12, 2006 2:10 pm

It is a PHP setting on your server

Involved Joined: Jul 15, 2004 Posts: 252 Location: OKC, OK

This menu is stored is the DB in the nuke_blocks table, The problem is that it is not stored as &middot but just a '.' so it get messed up in diffrent character sets. I used phpmyadmin and went in and just edited the nuke_blocks table and changed it to &middot everywhere and it works fine now.

Posted: Fri Oct 13, 2006 12:25 am

I still get "blurry" Can somebody give a clearly/step by step/exactly what should i do? Dear evaders99 Where should i check my PHP setting on my server? is that PHP.ini file? if true on which "keywords" ?

Thanxs

Posted: Fri Oct 13, 2006 9:33 am

I think Tao_Man may have a quick solution. Use phpMyAdmin to edit your blocks table and change that block data. Perhaps it is being messed up by the WYSIWYG editor?

Posted: Fri Oct 13, 2006 9:48 am

if you are running Nuke 7.6 or Raven Nuke then you could run this in phpmyadmin, or what ever way you can work with the mysql database. I do not know if this will work with anything other then Ravennuke or a stright 7.6 nuke.

BACKUP YOUR DATABASE FIRST!!!!!!!!

Code:

INSERT INTO `nuke_blocks` VALUES (2, 'admin', 'Administration', '<strong><big>&middot</big></strong> <a href="admin.php">Administration</a><br>\r\n<strong><big>&middot</big></strong> <a href="admin.php?op=adminStory">NEW Story</a><br>\r\n<strong><big>&middot</big></strong> <a href="admin.php?op=create">Change Survey</a><br>\r\n<strong><big>&middot</big></strong> <a href="admin.php?op=content">Content</a><br>\r\n<strong><big>&middot</big></strong> <a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, '', '0', 'd', 0);

better yet is just edit the field by hand using phpmyadmin.

nut let me say this again...BACKUP YOUR DATABASE FIRST!!!!!!!!

I think I may have brought this up before, but in RN 2.10 they may want to change the sql fiiles to use &middot other then just '.'. For all I know they have in thier move to make it more complient to html 4.01.

Defcon, If this is still not clear, we will need to get some more info from you... What version of nuke are you using. In your hosting what tools do you have? Do you have cpanel? If not what tools do you have for working/changing/editing your database?

I pulled my hair out a long time over this, so I can know your frustration, so lets us know if this works for you or give us some more info. If I can fix it, it can't be that hard to get you fixed Smile

registered · Posted: Sat Oct 14, 2006 7:19 am

Tao_Man, several things are corrected about this one block within 2.10: XHTML compliance and the hardcoding of "admin.php". Wink

Posted: Sat Oct 14, 2006 10:33 am

Tao_Man wrote:

This menu is stored is the DB in the nuke_blocks table, The problem is that it is not stored as &middot but just a '.' so it get messed up in diffrent character sets. I used phpmyadmin and went in and just edited the nuke_blocks table and changed it to &middot everywhere and it works fine now.

Yes u right! Actually that's not a "technical problem" on PHP scripting that's a problem come out maybe from web server/PHP version/Mysql version :p I dont how to explain it, i already check every line on that code that's nothing wrong after i "downgrade" my web server (running on localhost) everything is fine now. Before this i'm using:

apache_2.0.59-win32-x86-no_ssl
mysql-essential-4.1.21-win32
php-5.1.6-Win32

Then right now i using:

apache_1.3.28-win32-x86-no_src
winMYSQLadmin ver 1.4
php-4.3.3-Win32

So Tao_Man "technically" i dont know how to explain it.. i just downgrade my web server now everything it's ok. I think it's true that not stored as &middot but just a '.' whatever thanxs to all of my frenz here coz help me via your feedback.

Posted: Sun Oct 15, 2006 8:54 pm

Pretty sure you didn't have to downgrade, just change that character set. You may need to look through php.ini to find it though

Posted: Sun Oct 15, 2006 9:24 pm

Dear evaders99 may i know on php.ini which area should i make changing? Is that somewhere around here?

Code:




; As of 4.0b4, PHP always outputs a character encoding by default in


; the Content-type: header.  To disable sending of the charset, simply


; set it to be empty.


;


; PHP's built-in default is text/html


default_mimetype = "text/html"


;default_charset = "iso-8859-1"

I just would like to know to gain more knowledge although my problem already solve. Thanxs dude! :p

Posted: Mon Oct 16, 2006 12:11 pm

Might just need to uncomment this line

Code:




;default_charset = "iso-8859-1"

Posted: Mon Oct 16, 2006 8:17 pm

Yes u right! Thanxs evaders99