View Single Post
  #1  
Old 02-26-2010, 06:00 PM
Amit86 Amit86 is offline
 
Join Date: Feb 2008
Location: Israel
Posts: 108
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default PHP Help with widgets

Hey all,
im trying to code something that will echo text and vars into a widgts, while using echo it works but it outputs at the begining of the page instead of inside th wigit it self,
could you try and assit me in altering the code so it would work?

PHP Code:
$Hostname "SERVER";
$Username "USER";
$Password "PASS";
$CharacterDatabase 'characters';
$RealmDatabase 'realmd';
$WorldDatabase 'world';
$CharacterDatabaseEncoding 'utf8'
$toutput=''
$conn mysql_connect($Hostname$Username$Password);

mysql_select_db($CharacterDatabase$conn);

$sql "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`";
$result mysql_query($sql$conn);

$count 0;



$realm_db mysql_connect($Hostname$Username$Password);
mysql_select_db($RealmDatabase$realm_db);
$db_result mysql_query("SET NAMES $CharacterDatabaseEncoding"$realm_db);

$world_db mysql_connect($Hostname$Username$PasswordTRUE);
mysql_select_db($CharacterDatabase$world_db);
$db_result mysql_query("SET NAMES $CharacterDatabaseEncoding"$world_db);
 
$uptime_query mysql_query("SELECT * FROM $RealmDatabase.`uptime` ORDER BY `starttime` DESC LIMIT 1"$realm_db); 
$uptime_results mysql_fetch_array($uptime_query); 
$maxplayers =  $uptime_results['maxplayers'];
if (
$uptime_results['uptime'] > 86400) { //days
    
$uptime =  round(($uptime_results['uptime'] / 24 60 60),2)." ימים";
}
elseif(
$uptime_results['uptime'] > 3600) { //hours
    
$uptime =  round(($uptime_results['uptime'] / 60 60),2)." שעות";
}
else { 
//minutes
    
$uptime =  round(($uptime_results['uptime'] / 60),2)." דקות";
}

$player_query mysql_query("SELECT (SELECT COUNT(guid) FROM $CharacterDatabase.`characters` WHERE race IN(2,5,6,8,10) AND `online`='1') as horde, (SELECT COUNT(guid) FROM $CharacterDatabase.`characters` WHERE race IN(1,3,4,7,11) AND `online`='1') as alliance FROM $CharacterDatabase.`characters`"$world_db); 
$player_results mysql_fetch_array($player_query); 
$horde =  $player_results['horde'];
$alliance =  $player_results['alliance'];
$total $horde $alliance;

echo 
"<table width=\"100%\" border=0 cellspacing=0 cellpadding=3 class=\"alt2\">
  <tr>
    <td class=\"alt2\">פעילות:</td>
    <td class=\"alt2\">
$uptime</td>
  <tr>
    <td class=\"alt2\">מחוברים:</td>
    <td class=\"alt2\">
$total</td>
  </tr>
  </tr>
  <tr>
    <td class=\"alt2\">אלליאנס:</td>
    <td class=\"alt2\">
$alliance</td>
  </tr>
  <tr>
    <td class=\"alt2\">הורד:</td>
    <td class=\"alt2\">
$horde</td>
  </tr>
</table>"

Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01174 seconds
  • Memory Usage 1,810KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete