Search options

Well i know that it is not implanted yet.
You have asked for improvements didn't you,
So here is my first one PUN_WEBROOT

Now for more questions

How come i get an error on that query

SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.redirect_url FROM categories AS c INNER JOIN forums AS f ON c.id=f.cat_id LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=4) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.redirect_url IS NULL ORDER BY c.disp_position, c.id, f.disp_position

defined in serach.php line 708

when running inside the script the var_dump result in bool false hence the error message.

But when running on my mysql client i get 2 rows?

mysql> use punbb;
Database changed
mysql> SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.redirect_url
FROM categories AS c INNER JOIN forums AS f ON c.id=f.cat_id LEFT JOIN forum_pe
rms AS fp ON (fp.forum_id=f.id AND fp.group_id=4) WHERE (fp.read_forum IS NULL O
R fp.read_forum=1) AND f.redirect_url IS NULL ORDER BY c.disp_position, c.id, f.
disp_position;
+-----+----------+-----+------------+--------------+
| cid | cat_name | fid | forum_name | redirect_url |
+-----+----------+-----+------------+--------------+
|   1 | test     |   1 | wibizz     | NULL         |
|   2 | assaf    |   2 | New forum  | NULL         |
+-----+----------+-----+------------+--------------+
2 rows in set (0.00 sec)

ok thanks,

last question (i hope) before diving into code
Does the css link on top of the page is relative to the PUN_ROOT or something like PUN_WEBROOT?
If it's not i think it would be a good practice to support not native punbb platforms by helping them find relevant files like css,js and images used by punbb

p.s i do have another question
How do i enable root member and moderators after installation?
Or in another way how the system recognize a user to be admin/moderator? because i'm using diffrent login system which updates punbb users tables

Assaf

here is sample code

class ForumsController extends AppController
{

    function index(){
        define('PUN_ROOT', dirname(dirname(__FILE__)).DIRECTORY_SEPARATOR.'webroot'.DIRECTORY_SEPARATOR.'forum'.DIRECTORY_SEPARATOR);
        require PUN_ROOT.'include'.DIRECTORY_SEPARATOR.'common.php';
    }

}

here is a crude debug report after manualy hacking the global $db

please note in the end how the array lose their data becuase the checked againt $pun_config which is null
becuase declared global $pun_config

smarty:you can delete this post after reading becuase its take lot of space and i don't know how clear it is for readers

pun user  -> var_dump()
array(11) { ["id"]=> string(2) "24" ["user_name"]=> string(4) "test" ["email_address"]=> string(18) "sufinoon@gmail.com" ["full_name"]=> string(3) "ass" ["password"]=> string(32) "e10adc3949ba59abbe56e057f20f883e" ["show_name"]=> string(1) "0" ["created"]=> string(19) "2007-05-15 09:45:12" ["user_profile_id"]=> string(2) "16" ["email_authenticated"]=> string(1) "1" ["email_token"]=> NULL ["email_token_expires"]=> NULL }
hihiobject(DBLayer)#13 (5) { ["prefix"]=> string(0) "" ["link_id"]=> object(mysqli)#14 (0) { } ["query_result"]=> NULL ["saved_queries"]=> array(0) { } ["num_queries"]=> int(0) }
in the middle (common.php line 116)

before check cookie (common.php line 140)

var_dump($db) ->
object(DBLayer)#13 (5) { ["prefix"]=> string(0) "" ["link_id"]=> object(mysqli)#14 (0) { } ["query_result"]=> NULL ["saved_queries"]=> array(0) { } ["num_queries"]=> int(0) }

******
* in check user *
********** (functions.php line 37)

NULL -> var_dump($db);
*****
default users
**** (functions.php line 143)

pun_config (functions.php line 157)

NULL  -> var_dump($pun_config);
in set_default_user (functions.php line 166)

array(56) { ["id"]=> string(1) "1" ["group_id"]=> string(1) "3" ["username"]=> string(5) "Guest" ["password"]=> string(5) "Guest" ["email"]=> string(0) "" ["title"]=> NULL ["realname"]=> string(0) "" ["url"]=> NULL ["jabber"]=> NULL ["icq"]=> NULL ["msn"]=> NULL ["aim"]=> NULL ["yahoo"]=> NULL ["location"]=> NULL ["use_avatar"]=> string(1) "0" ["signature"]=> NULL ["disp_topics"]=> NULL ["disp_posts"]=> NULL ["email_setting"]=> string(1) "1" ["save_pass"]=> string(1) "1" ["notify_with_post"]=> string(1) "0" ["show_smilies"]=> string(1) "1" ["show_img"]=> string(1) "1" ["show_img_sig"]=> string(1) "1" ["show_avatars"]=> string(1) "1" ["show_sig"]=> string(1) "1" ["timezone"]=> string(1) "0" ["language"]=> string(7) "English" ["style"]=> string(6) "Oxygen" ["num_posts"]=> string(1) "0" ["last_post"]=> NULL ["registered"]=> string(1) "0" ["registration_ip"]=> string(7) "0.0.0.0" ["last_visit"]=> string(1) "0" ["admin_note"]=> NULL ["activate_string"]=> NULL ["activate_key"]=> NULL ["g_id"]=> string(1) "3" ["g_title"]=> string(5) "Guest" ["g_user_title"]=> NULL ["g_read_board"]=> string(1) "1" ["g_post_replies"]=> string(1) "0" ["g_post_topics"]=> string(1) "0" ["g_post_polls"]=> string(1) "0" ["g_edit_posts"]=> string(1) "0" ["g_delete_posts"]=> string(1) "0" ["g_delete_topics"]=> string(1) "0" ["g_set_title"]=> string(1) "0" ["g_search"]=> string(1) "1" ["g_search_users"]=> string(1) "1" ["g_edit_subjects_interval"]=> string(1) "0" ["g_post_flood"]=> string(1) "0" ["g_search_flood"]=> string(1) "0" ["g_pm"]=> string(1) "1" ["g_pm_limit"]=> string(2) "20" ["logged"]=> string(10) "1179213445" }

**********
AFTER defaukt init
************

(functions.php line 197)

array(57) { ["id"]=> string(1) "1" ["group_id"]=> string(1) "3" ["username"]=> string(5) "Guest" ["password"]=> string(5) "Guest" ["email"]=> string(0) "" ["title"]=> NULL ["realname"]=> string(0) "" ["url"]=> NULL ["jabber"]=> NULL ["icq"]=> NULL ["msn"]=> NULL ["aim"]=> NULL ["yahoo"]=> NULL ["location"]=> NULL ["use_avatar"]=> string(1) "0" ["signature"]=> NULL ["disp_topics"]=> NULL ["disp_posts"]=> NULL ["email_setting"]=> string(1) "1" ["save_pass"]=> string(1) "1" ["notify_with_post"]=> string(1) "0" ["show_smilies"]=> string(1) "1" ["show_img"]=> string(1) "1" ["show_img_sig"]=> string(1) "1" ["show_avatars"]=> string(1) "1" ["show_sig"]=> string(1) "1" ["timezone"]=> NULL ["language"]=> NULL ["style"]=> NULL ["num_posts"]=> string(1) "0" ["last_post"]=> NULL ["registered"]=> string(1) "0" ["registration_ip"]=> string(7) "0.0.0.0" ["last_visit"]=> string(1) "0" ["admin_note"]=> NULL ["activate_string"]=> NULL ["activate_key"]=> NULL ["g_id"]=> string(1) "3" ["g_title"]=> string(5) "Guest" ["g_user_title"]=> NULL ["g_read_board"]=> string(1) "1" ["g_post_replies"]=> string(1) "0" ["g_post_topics"]=> string(1) "0" ["g_post_polls"]=> string(1) "0" ["g_edit_posts"]=> string(1) "0" ["g_delete_posts"]=> string(1) "0" ["g_delete_topics"]=> string(1) "0" ["g_set_title"]=> string(1) "0" ["g_search"]=> string(1) "1" ["g_search_users"]=> string(1) "1" ["g_edit_subjects_interval"]=> string(1) "0" ["g_post_flood"]=> string(1) "0" ["g_search_flood"]=> string(1) "0" ["g_pm"]=> string(1) "1" ["g_pm_limit"]=> string(2) "20" ["logged"]=> string(10) "1179213445" ["is_guest"]=> bool(true) }
after check cookie (common.php line 145)

array(57) { ["id"]=> string(1) "1" ["group_id"]=> string(1) "3" ["username"]=> string(5) "Guest" ["password"]=> string(5) "Guest" ["email"]=> string(0) "" ["title"]=> NULL ["realname"]=> string(0) "" ["url"]=> NULL ["jabber"]=> NULL ["icq"]=> NULL ["msn"]=> NULL ["aim"]=> NULL ["yahoo"]=> NULL ["location"]=> NULL ["use_avatar"]=> string(1) "0" ["signature"]=> NULL ["disp_topics"]=> NULL ["disp_posts"]=> NULL ["email_setting"]=> string(1) "1" ["save_pass"]=> string(1) "1" ["notify_with_post"]=> string(1) "0" ["show_smilies"]=> string(1) "1" ["show_img"]=> string(1) "1" ["show_img_sig"]=> string(1) "1" ["show_avatars"]=> string(1) "1" ["show_sig"]=> string(1) "1" ["timezone"]=> NULL ["language"]=> NULL ["style"]=> NULL ["num_posts"]=> string(1) "0" ["last_post"]=> NULL ["registered"]=> string(1) "0" ["registration_ip"]=> string(7) "0.0.0.0" ["last_visit"]=> string(1) "0" ["admin_note"]=> NULL ["activate_string"]=> NULL ["activate_key"]=> NULL ["g_id"]=> string(1) "3" ["g_title"]=> string(5) "Guest" ["g_user_title"]=> NULL ["g_read_board"]=> string(1) "1" ["g_post_replies"]=> string(1) "0" ["g_post_topics"]=> string(1) "0" ["g_post_polls"]=> string(1) "0" ["g_edit_posts"]=> string(1) "0" ["g_delete_posts"]=> string(1) "0" ["g_delete_topics"]=> string(1) "0" ["g_set_title"]=> string(1) "0" ["g_search"]=> string(1) "1" ["g_search_users"]=> string(1) "1" ["g_edit_subjects_interval"]=> string(1) "0" ["g_post_flood"]=> string(1) "0" ["g_search_flood"]=> string(1) "0" ["g_pm"]=> string(1) "1" ["g_pm_limit"]=> string(2) "20" ["logged"]=> string(10) "1179213445" ["is_guest"]=> bool(true) }
in !isset (common.php line 150)

array(57) { ["id"]=> string(1) "1" ["group_id"]=> string(1) "3" ["username"]=> string(5) "Guest" ["password"]=> string(5) "Guest" ["email"]=> string(0) "" ["title"]=> NULL ["realname"]=> string(0) "" ["url"]=> NULL ["jabber"]=> NULL ["icq"]=> NULL ["msn"]=> NULL ["aim"]=> NULL ["yahoo"]=> NULL ["location"]=> NULL ["use_avatar"]=> string(1) "0" ["signature"]=> NULL ["disp_topics"]=> NULL ["disp_posts"]=> NULL ["email_setting"]=> string(1) "1" ["save_pass"]=> string(1) "1" ["notify_with_post"]=> string(1) "0" ["show_smilies"]=> string(1) "1" ["show_img"]=> string(1) "1" ["show_img_sig"]=> string(1) "1" ["show_avatars"]=> string(1) "1" ["show_sig"]=> string(1) "1" ["timezone"]=> NULL ["language"]=> NULL ["style"]=> NULL ["num_posts"]=> string(1) "0" ["last_post"]=> NULL ["registered"]=> string(1) "0" ["registration_ip"]=> string(7) "0.0.0.0" ["last_visit"]=> string(1) "0" ["admin_note"]=> NULL ["activate_string"]=> NULL ["activate_key"]=> NULL ["g_id"]=> string(1) "3" ["g_title"]=> string(5) "Guest" ["g_user_title"]=> NULL ["g_read_board"]=> string(1) "1" ["g_post_replies"]=> string(1) "0" ["g_post_topics"]=> string(1) "0" ["g_post_polls"]=> string(1) "0" ["g_edit_posts"]=> string(1) "0" ["g_delete_posts"]=> string(1) "0" ["g_delete_topics"]=> string(1) "0" ["g_set_title"]=> string(1) "0" ["g_search"]=> string(1) "1" ["g_search_users"]=> string(1) "1" ["g_edit_subjects_interval"]=> string(1) "0" ["g_post_flood"]=> string(1) "0" ["g_search_flood"]=> string(1) "0" ["g_pm"]=> string(1) "1" ["g_pm_limit"]=> string(2) "20" ["logged"]=> string(10) "1179213445" ["is_guest"]=> bool(true) }
Attempt to load the common language file (common.php line 155)

There is no valid language pack '' installed. Please reinstall a language of that name.