Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-23-2004, 02:38 PM
Zedd's Avatar
Zedd Zedd is offline
 
Join Date: Mar 2002
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Customized Admin Control Panel

I'm trying to build an admin page for a book appendix that will give me a front-end to modify appendix content (MySQL-based). I would like to use the vB admin control panel to do this, so that I can base permissions on existing user logins, rather than write an entire app just for the appendix.

I have added the ./global.php and permissions check from the admin pages to my own, but I have one of two problems, depending on how I code (PHP) the rest of the page:
1) The PHP does not parse at all
2) The admin login runs every time I try to pass a value to MySQL

Here's the admincp code I used:
Code:
// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// ##################### DEFINE IMPORTANT CONSTANTS #######################
define('CVS_REVISION', '$RCSfile: forum.php,v $ - $Revision: 1.83 $');
define('NO_REGISTER_GLOBALS', 1);

// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array('forum', 'cpuser');
$specialtemplates = array();

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');

// ######################## CHECK ADMIN PERMISSIONS #######################
if (!can_administer('canadminforums'))
{
	print_cp_no_permission();
}
And here's a sample of PHP script from my page:
Code:
if (isset($HTTP_POST_VARS['Search'])) {
$colname_Search = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['Search'] : addslashes($HTTP_POST_VARS['Search']);
$query_Search = sprintf("SELECT * FROM tablename WHERE Field_1 LIKE '%%%s%%' OR Field_2 LIKE '%%%s%%' ORDER BY Field_0 ASC", $colname_Search, $colname_Search);
$Search = mysql_query($query_Search) or die(mysql_error());
$totalRows_Search = mysql_num_rows($Search);

echo "Your search for \"<i>$colname_Search</i>\" yielded <b>$totalRows_Search</b> results as follows:<br>
<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
	<tr style=\"font-weight: bold\">
	<td width=\"25%\" nowrap valign=\"top\">Topic</td>
	<td>Description</td>
	<td>From</td>
	</tr>
	<tr><td colspan=\"3\" height=\"3\" style=\"background: #AA0000\"></tr>
	<tr>";
while ($row_Search = mysql_fetch_assoc($Search)) {
echo "  <tr>
    <td width=\"25%\" nowrap valign=\"top\">".$row_Search['Field_1']."</td>
    <td>".$row_Search['Field_2']."</td>
	<td color=\"#AAAAAA\" nowrap valign=\"top\"><i>".$row_Search['Field_3']."</i></td>
  </tr>
  <tr><td colspan=\"3\" style=\"background: #666666\"></td></tr>
  <tr>";
  }
echo "</table>";
mysql_free_result($Search);
}
Am I doing this the hard way? How would I go about wrapping my page into the vB admin control panel? Can I use the vB admin security, and still build my own MySQL queries?

You can see the working appendix here, but it's not wrapped into vB like the admin page would be. Any ideas would be greatly appreciated.
Reply With Quote
  #2  
Old 06-25-2004, 12:42 PM
Zedd's Avatar
Zedd Zedd is offline
 
Join Date: Mar 2002
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Was it something I said?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:07 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03892 seconds
  • Memory Usage 2,173KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete