Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 08-23-2012, 04:05 PM
Fr4n-FX Fr4n-FX is offline
 
Join Date: Jun 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problem with vbcms_content_phpeval_page

PHP Code:
function connect() 

    
$db_user "user"
    
$db_pass "pass"
    
$db_name "namedb"
    
$db_serv "localhost"

    
$res mysql_connect $db_serv$db_user$db_pass ) or die ("Coudn't connect to [$db_serv]"); 
    
$resdb mysql_select_db "$db_name",$res ); 

    return 
$res;
}


$time = array('$row[3]/60' => "$row[4]");
$sexes = array('M''F');

$FORM "<table border='1'>  
<tr> 
<td align='center'>Pos.</td> 
<td align='center'>Char. Name</td> 
<td align='center'>Level</td>  
<td align='center'>Sex</td> 
<td align='center'>Jail Time</td> 
</tr>"

$query_chars "select char_name,level,sex,punish_timer from characters WHERE punish_level=1 order by punish_timer asc limit 10;"
connect(); 
$link mysql_query($query_chars); 
$i=1
$r=255
while ( 
$row=mysql_fetch_row($link) ) 

    
$jailer=$row[3]/1000;
    
$datetime  gmstrftime("%H:%M:%S"$jailer);
    
$link2 mysql_query($query);
    
    
$FORM .= "<tr> 
    <td align='center'>
$i</td> 
    <td align='center'>
$row[0]</td> 
    <td align='center'>
$row[1]</td>  
    <td align='center'>"
.$sexes[$row[2]]."</td>  
    <td align='center'>
$datetime</td>
    </tr>"

    
$i++; 
    
$r -= 0
}

mysql_close();

$output $FORM
Is posible to display this code in cms pages correctly?

--------------- Added [DATE]1345741765[/DATE] at [TIME]1345741765[/TIME] ---------------

Its another database in the same machine ...
Reply With Quote
  #2  
Old 08-23-2012, 04:13 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The only thing I can see offhand is I think you need one more line near the bottom (outside the loop but before the last line):

Code:
$FORM .= "</table>";
Reply With Quote
  #3  
Old 08-24-2012, 12:41 PM
Fr4n-FX Fr4n-FX is offline
 
Join Date: Jun 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Works! Thanks a lot.
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 11:49 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04373 seconds
  • Memory Usage 2,189KB
  • 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
  • (1)bbcode_code
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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