Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 03-24-2004, 10:44 PM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Whats wrong with this?

PHP Code:
$getcat $DB_site->query("SELECT * FROM auction_item ORDER BY 'cats'");

while (
$getcats $DB_site->fetch_array($getcat)) {
    
$cat_id $getcats["cat_id"]; 
    
$cats $getcats["cats"]; 
eval(
'$auction_cat_bits = "' fetch_template('auction_cat_bits') . '";');

The template $auction_cat_bits looks like this for troubleshooting.

Quote:
<td><a href="auction.php?&action=view_by_cat&cats=$cat_id "><font color="#ffffff" size="4"><b>$cats</b></font></a>&nbspXXX</td>
The XXX displays once where I want it to but does not repeat for each catagory. Also $cats & $cat_id are not resolving???

I have this script working but can not seem to port it to VB formatt.

PHP Code:
$sql "(SELECT * FROM cats ORDER BY cat_name)"
$result mysql_query($sql);   
if (!
$result) { 
    echo 
"<tr><td>Database Error: " .mysql_error(); 
echo 
"</td></tr>";
}
while(
$myrow mysql_fetch_array($result)) {  
    
$cat_id $myrow["cat_id"]; 
    
$cats$myrow["cats"]; 

echo 
"<td><a href=\"index.php?&sub_cat=$cat_id\">$cat_name</a></td>";


Please help
Reply With Quote
  #2  
Old 03-24-2004, 11:08 PM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

use require_once('./global.php');
to activate all vb functions and instead of doing $var["blah"] use $var['blah']
Reply With Quote
  #3  
Old 03-24-2004, 11:17 PM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by AN-net
use require_once('./global.php');
to activate all vb functions and instead of doing $var["blah"] use $var['blah']
Unfortunatly that changed nothing.

Here is the whole script thus far.
PHP Code:
<?php 

// ####################### SET PHP ENVIRONMENT ########################### 
error_reporting(E_ALL & ~E_NOTICE); 

// #################### DEFINE IMPORTANT CONSTANTS ####################### 
define('NO_REGISTER_GLOBALS'1); 
define('THIS_SCRIPT''Auction'); 
// ################### PRE-CACHE TEMPLATES AND DATA ###################### 
// get special phrase groups 
$phrasegroups = array( 

); 

// get special data templates from the datastore 
$specialtemplates = array( 
     
); 

// pre-cache templates used by all actions 
$globaltemplates = array( 
    
'auction,auction_cat_bits'
); 

// pre-cache templates used by specific actions 
$actiontemplates = array( 

); 

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

// ####################################################################### 
// ######################## START MAIN SCRIPT ############################ 
// ####################################################################### 

$navbits = array(); 
$navbits[$parent] = 'Auction';

// ######################## START GET CATAGORIES ######################### 
$getcat $DB_site->query("SELECT * FROM auction_item ORDER BY 'cats'");

while (
$getcats $DB_site->fetch_array($getcat)) {
    
$cat_id $getcats['cat_id']; 
    
$cats $getcats['cats']; 
eval(
'$auction_cat_bits = "' fetch_template('auction_cat_bits') . '";');
}
// ######################## END GET CATAGORIES ###########################

$navbits construct_navbits($navbits); 
eval(
'$navbar = "' fetch_template('navbar') . '";'); 
eval(
'print_output("' fetch_template('auction_main') . '");'); 

?>
Reply With Quote
  #4  
Old 03-24-2004, 11:35 PM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

try this:
PHP Code:
eval('$auction_cat_bits .= "' fetch_template('auction_cat_bits') . '";'); 
Reply With Quote
  #5  
Old 03-25-2004, 12:07 AM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No change. I give.
Reply With Quote
Reply

Thread Tools
Display Modes

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 08:59 AM.


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.05357 seconds
  • Memory Usage 2,212KB
  • 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
  • (4)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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