JellyFish72 Posted September 6, 2010 Share Posted September 6, 2010 I've been trying to install Marfisa's TCG Manager onto my website, and it's giving me a few errors - I've managed to correct some through trial and error, but I don't know enough about PHP to correct the rest... I'd greatly appreciate any help you could give!!! The errors I'm being given are: Warning: include(/home/stephi/public_html/tcg) [function.include]: failed to open stream: No such device in /home/stephi/public_html/tcg/tcg.php on line 6 Warning: include() [function.include]: Failed opening '/home/stephi/public_html/tcg' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/stephi/public_html/tcg/tcg.php on line 6 Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'stephi'@'localhost' (using password: NO) in /home/stephi/public_html/tcg/tcg.php on line 7 Unable to select database And the code I'm using is: <?php include('admin/top.php'); ?> <? $card=0; $spec=0; $other=0; ?> <? include("/home/stephi/public_html/tcg"); mysql_connect($hostname,$user,$password); @mysql_select_db($database) or die("Unable to select database"); $name=$_SERVER['QUERY_STRING']; $name=preg_replace('/%20/',' ',$name); $query="SELECT * FROM " . $tablename . " WHERE game_name='$name'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $id=mysql_result($result,$i,"id"); $game_name=mysql_result($result,$i,"game_name"); $game_comment=mysql_result($result,$i,"game_comment"); $game_badges=mysql_result($result,$i,"game_badges"); $reg_path=mysql_result($result,$i,"reg_path"); $sp_path=mysql_result($result,$i,"sp_path"); $oth_path=mysql_result($result,$i,"oth_path"); $reg_worth=mysql_result($result,$i,"reg_worth"); $sp_worth=mysql_result($result,$i,"sp_worth"); $oth_worth=mysql_result($result,$i,"oth_worth"); $img_format=mysql_result($result,$i,"img_format"); $reg_filler=mysql_result($result,$i,"reg_filler"); $sp_filler=mysql_result($result,$i,"sp_filler"); $goodies_header=mysql_result($result,$i,"goodies_header"); $goodies_comment=mysql_result($result,$i,"goodies_comment"); $goodies=mysql_result($result,$i,"goodies"); $col_header=mysql_result($result,$i,"col_header"); $col_comment=mysql_result($result,$i,"col_comment"); $col1_name=mysql_result($result,$i,"col1_name"); $col1_type=mysql_result($result,$i,"col1_type"); $col1_size=mysql_result($result,$i,"col1_size"); $col1_break=mysql_result($result,$i,"col1_break"); $col1_touch=mysql_result($result,$i,"col1_touch"); $col1_own=mysql_result($result,$i,"col1_own"); $col2_name=mysql_result($result,$i,"col2_name"); $col2_type=mysql_result($result,$i,"col2_type"); $col2_size=mysql_result($result,$i,"col2_size"); $col2_break=mysql_result($result,$i,"col2_break"); $col2_touch=mysql_result($result,$i,"col2_touch"); $col2_own=mysql_result($result,$i,"col2_own"); $col3_name=mysql_result($result,$i,"col3_name"); $col3_type=mysql_result($result,$i,"col3_type"); $col3_size=mysql_result($result,$i,"col3_size"); $col3_break=mysql_result($result,$i,"col3_break"); $col3_touch=mysql_result($result,$i,"col3_touch"); $col3_own=mysql_result($result,$i,"col3_own"); $col4_name=mysql_result($result,$i,"col4_name"); $col4_type=mysql_result($result,$i,"col4_type"); $col4_size=mysql_result($result,$i,"col4_size"); $col4_break=mysql_result($result,$i,"col4_break"); $col4_touch=mysql_result($result,$i,"col4_touch"); $col4_own=mysql_result($result,$i,"col4_own"); $col5_name=mysql_result($result,$i,"col5_name"); $col5_type=mysql_result($result,$i,"col5_type"); $col5_size=mysql_result($result,$i,"col5_size"); $col5_break=mysql_result($result,$i,"col5_break"); $col5_touch=mysql_result($result,$i,"col5_touch"); $col5_own=mysql_result($result,$i,"col5_own"); $col6_name=mysql_result($result,$i,"col6_name"); $col6_type=mysql_result($result,$i,"col6_type"); $col6_size=mysql_result($result,$i,"col6_size"); $col6_break=mysql_result($result,$i,"col6_break"); $col6_touch=mysql_result($result,$i,"col6_touch"); $col6_own=mysql_result($result,$i,"col6_own"); $col7_name=mysql_result($result,$i,"col7_name"); $col7_type=mysql_result($result,$i,"col7_type"); $col7_size=mysql_result($result,$i,"col7_size"); $col7_break=mysql_result($result,$i,"col7_break"); $col7_touch=mysql_result($result,$i,"col7_touch"); $col7_own=mysql_result($result,$i,"col7_own"); $col8_name=mysql_result($result,$i,"col8_name"); $col8_type=mysql_result($result,$i,"col8_type"); $col8_size=mysql_result($result,$i,"col8_size"); $col8_break=mysql_result($result,$i,"col8_break"); $col8_touch=mysql_result($result,$i,"col8_touch"); $col8_own=mysql_result($result,$i,"col8_own"); $col9_name=mysql_result($result,$i,"col9_name"); $col9_type=mysql_result($result,$i,"col9_type"); $col9_size=mysql_result($result,$i,"col9_size"); $col9_break=mysql_result($result,$i,"col9_break"); $col9_touch=mysql_result($result,$i,"col9_touch"); $col9_own=mysql_result($result,$i,"col9_own"); $col10_name=mysql_result($result,$i,"col10_name"); $col10_type=mysql_result($result,$i,"col10_type"); $col10_size=mysql_result($result,$i,"col10_size"); $col10_break=mysql_result($result,$i,"col10_break"); $col10_touch=mysql_result($result,$i,"col10_touch"); $col10_own=mysql_result($result,$i,"col10_own"); $fut_header=mysql_result($result,$i,"fut_header"); $fut_comment=mysql_result($result,$i,"fut_comment"); $fut_reg=mysql_result($result,$i,"fut_reg"); $fut_sp=mysql_result($result,$i,"fut_sp"); $fut_oth=mysql_result($result,$i,"fut_oth"); $trd_header=mysql_result($result,$i,"trd_header"); $trd_comment=mysql_result($result,$i,"trd_comment"); $trd_reg=mysql_result($result,$i,"trd_reg"); $trd_sp=mysql_result($result,$i,"trd_sp"); $trd_oth=mysql_result($result,$i,"trd_oth"); $mem_header=mysql_result($result,$i,"mem_header"); $mem_comment=mysql_result($result,$i,"mem_comment"); $mem1_name=mysql_result($result,$i,"mem1_name"); $mem1_recv=mysql_result($result,$i,"mem1_recv"); $mem1_reg=mysql_result($result,$i,"mem1_reg"); $mem1_sp=mysql_result($result,$i,"mem1_sp"); $mem1_oth=mysql_result($result,$i,"mem1_oth"); $mem2_name=mysql_result($result,$i,"mem2_name"); $mem2_recv=mysql_result($result,$i,"mem2_recv"); $mem2_reg=mysql_result($result,$i,"mem2_reg"); $mem2_sp=mysql_result($result,$i,"mem2_sp"); $mem2_oth=mysql_result($result,$i,"mem2_oth"); $mem3_name=mysql_result($result,$i,"mem3_name"); $mem3_recv=mysql_result($result,$i,"mem3_recv"); $mem3_reg=mysql_result($result,$i,"mem3_reg"); $mem3_sp=mysql_result($result,$i,"mem3_sp"); $mem3_oth=mysql_result($result,$i,"mem3_oth"); $mem4_name=mysql_result($result,$i,"mem4_name"); $mem4_recv=mysql_result($result,$i,"mem4_recv"); $mem4_reg=mysql_result($result,$i,"mem4_reg"); $mem4_sp=mysql_result($result,$i,"mem4_sp"); $mem4_oth=mysql_result($result,$i,"mem4_oth"); $mem5_name=mysql_result($result,$i,"mem5_name"); $mem5_recv=mysql_result($result,$i,"mem5_recv"); $mem5_reg=mysql_result($result,$i,"mem5_reg"); $mem5_sp=mysql_result($result,$i,"mem5_sp"); $mem5_oth=mysql_result($result,$i,"mem5_oth"); $mem6_name=mysql_result($result,$i,"mem6_name"); $mem6_recv=mysql_result($result,$i,"mem6_recv"); $mem6_reg=mysql_result($result,$i,"mem6_reg"); $mem6_sp=mysql_result($result,$i,"mem6_sp"); $mem6_oth=mysql_result($result,$i,"mem6_oth"); $mem7_name=mysql_result($result,$i,"mem7_name"); $mem7_recv=mysql_result($result,$i,"mem7_recv"); $mem7_reg=mysql_result($result,$i,"mem7_reg"); $mem7_sp=mysql_result($result,$i,"mem7_sp"); $mem7_oth=mysql_result($result,$i,"mem7_oth"); $mem8_name=mysql_result($result,$i,"mem8_name"); $mem8_recv=mysql_result($result,$i,"mem8_recv"); $mem8_reg=mysql_result($result,$i,"mem8_reg"); $mem8_sp=mysql_result($result,$i,"mem8_sp"); $mem8_oth=mysql_result($result,$i,"mem8_oth"); $mem9_name=mysql_result($result,$i,"mem9_name"); $mem9_recv=mysql_result($result,$i,"mem9_recv"); $mem9_reg=mysql_result($result,$i,"mem9_reg"); $mem9_sp=mysql_result($result,$i,"mem9_sp"); $mem9_oth=mysql_result($result,$i,"mem9_oth"); $mem10_name=mysql_result($result,$i,"mem10_name"); $mem10_recv=mysql_result($result,$i,"mem10_recv"); $mem10_reg=mysql_result($result,$i,"mem10_reg"); $mem10_sp=mysql_result($result,$i,"mem10_sp"); $mem10_oth=mysql_result($result,$i,"mem10_oth"); $trade_log=mysql_result($result,$i,"trade_log"); $mast_header=mysql_result($result,$i,"mast_header"); $mast_comment=mysql_result($result,$i,"mast_comment"); $mast_badges=mysql_result($result,$i,"mast_badges"); $mast_reg=mysql_result($result,$i,"mast_reg"); $mast_sp=mysql_result($result,$i,"mast_sp"); $mast_oth=mysql_result($result,$i,"mast_oth"); $i++; } ?> <h1><? echo $game_name; ?></h1> <p><? echo $game_comment; ?></p> <? echo $game_badges; ?> <h2><? echo $goodies_header; ?></h2> <p><? echo $goodies_comment; ?></p> <? echo $goodies; ?> <h2><? echo $col_header; ?></h2> <p><? echo $col_comment; ?></p> <p align="center"> <? $col1_own=ereg_replace("[\n\r/ /]", "", $col1_own); $col1_own_array=explode(",",$col1_own); $own_num=count($col1_own_array); if ($col1_type==0) { $col1_path=$reg_path; $col1_filler=$reg_filler; } if ($col1_type==1) { $col1_path=$sp_path; $col1_filler=$sp_filler; } if ($col1_type==2) { $col1_path=$oth_path; $col1_filler=$oth_filler; } $loop=1; while ($loop <= $col1_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col1_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col1_path . "/" . $col1_name . $col1_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col1_path . "/" . $col1_filler . "." . $img_format; ?>"><? } else { if ($col1_type==0) { $card=$card+$reg_worth; } if ($col1_type==1) { $spec=$spec+$sp_worth; } if ($col1_type==2) { $other=$other+$oth_worth; } } if ($loop%$col1_break==0) {echo "<br>\n";} elseif ($col1_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col2_own=ereg_replace("[\n\r/ /]", "", $col2_own); $col2_own_array=explode(",",$col2_own); $own_num=count($col2_own_array); if ($col2_type==0) { $col2_path=$reg_path; $col2_filler=$reg_filler; } if ($col2_type==1) { $col2_path=$sp_path; $col2_filler=$sp_filler; } if ($col2_type==2) { $col2_path=$oth_path; $col2_filler=$oth_filler; } $loop=1; while ($loop <= $col2_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col2_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col2_path . "/" . $col2_name . $col2_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col2_path . "/" . $col2_filler . "." . $img_format; ?>"><? } else { if ($col2_type==0) { $card=$card+$reg_worth; } if ($col2_type==1) { $spec=$spec+$sp_worth; } if ($col2_type==2) { $other=$other+$oth_worth; } } if ($loop%$col2_break==0) {echo "<br>\n";} elseif ($col2_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col3_own=ereg_replace("[\n\r/ /]", "", $col3_own); $col3_own_array=explode(",",$col3_own); $own_num=count($col3_own_array); if ($col3_type==0) { $col3_path=$reg_path; $col3_filler=$reg_filler; } if ($col3_type==1) { $col3_path=$sp_path; $col3_filler=$sp_filler; } if ($col3_type==2) { $col3_path=$oth_path; $col3_filler=$oth_filler; } $loop=1; while ($loop <= $col3_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col3_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col3_path . "/" . $col3_name . $col3_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col3_path . "/" . $col3_filler . "." . $img_format; ?>"><? } else { if ($col3_type==0) { $card=$card+$reg_worth; } if ($col3_type==1) { $spec=$spec+$sp_worth; } if ($col3_type==2) { $other=$other+$oth_worth; } } if ($loop%$col3_break==0) {echo "<br>\n";} elseif ($col3_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col4_own=ereg_replace("[\n\r/ /]", "", $col4_own); $col4_own_array=explode(",",$col4_own); $own_num=count($col4_own_array); if ($col4_type==0) { $col4_path=$reg_path; $col4_filler=$reg_filler; } if ($col4_type==1) { $col4_path=$sp_path; $col4_filler=$sp_filler; } if ($col4_type==2) { $col4_path=$oth_path; $col4_filler=$oth_filler; } $loop=1; while ($loop <= $col4_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col4_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col4_path . "/" . $col4_name . $col4_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col4_path . "/" . $col4_filler . "." . $img_format; ?>"><? } else { if ($col4_type==0) { $card=$card+$reg_worth; } if ($col4_type==1) { $spec=$spec+$sp_worth; } if ($col4_type==2) { $other=$other+$oth_worth; } } if ($loop%$col4_break==0) {echo "<br>\n";} elseif ($col4_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col5_own=ereg_replace("[\n\r/ /]", "", $col5_own); $col5_own_array=explode(",",$col5_own); $own_num=count($col5_own_array); if ($col5_type==0) { $col5_path=$reg_path; $col5_filler=$reg_filler; } if ($col5_type==1) { $col5_path=$sp_path; $col5_filler=$sp_filler; } if ($col5_type==2) { $col5_path=$oth_path; $col5_filler=$oth_filler; } $loop=1; while ($loop <= $col5_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col5_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col5_path . "/" . $col5_name . $col5_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col5_path . "/" . $col5_filler . "." . $img_format; ?>"><? } else { if ($col5_type==0) { $card=$card+$reg_worth; } if ($col5_type==1) { $spec=$spec+$sp_worth; } if ($col5_type==2) { $other=$other+$oth_worth; } } if ($loop%$col5_break==0) {echo "<br>\n";} elseif ($col5_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col6_own=ereg_replace("[\n\r/ /]", "", $col6_own); $col6_own_array=explode(",",$col6_own); $own_num=count($col6_own_array); if ($col6_type==0) { $col6_path=$reg_path; $col6_filler=$reg_filler; } if ($col6_type==1) { $col6_path=$sp_path; $col6_filler=$sp_filler; } if ($col6_type==2) { $col6_path=$oth_path; $col6_filler=$oth_filler; } $loop=1; while ($loop <= $col6_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col6_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col6_path . "/" . $col6_name . $col6_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col6_path . "/" . $col6_filler . "." . $img_format; ?>"><? } else { if ($col6_type==0) { $card=$card+$reg_worth; } if ($col6_type==1) { $spec=$spec+$sp_worth; } if ($col6_type==2) { $other=$other+$oth_worth; } } if ($loop%$col6_break==0) {echo "<br>\n";} elseif ($col6_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col7_own=ereg_replace("[\n\r/ /]", "", $col7_own); $col7_own_array=explode(",",$col7_own); $own_num=count($col7_own_array); if ($col7_type==0) { $col7_path=$reg_path; $col7_filler=$reg_filler; } if ($col7_type==1) { $col7_path=$sp_path; $col7_filler=$sp_filler; } if ($col7_type==2) { $col7_path=$oth_path; $col7_filler=$oth_filler; } $loop=1; while ($loop <= $col7_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col7_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col7_path . "/" . $col7_name . $col7_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col7_path . "/" . $col7_filler . "." . $img_format; ?>"><? } else { if ($col7_type==0) { $card=$card+$reg_worth; } if ($col7_type==1) { $spec=$spec+$sp_worth; } if ($col7_type==2) { $other=$other+$oth_worth; } } if ($loop%$col7_break==0) {echo "<br>\n";} elseif ($col7_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col8_own=ereg_replace("[\n\r/ /]", "", $col8_own); $col8_own_array=explode(",",$col8_own); $own_num=count($col8_own_array); if ($col8_type==0) { $col8_path=$reg_path; $col8_filler=$reg_filler; } if ($col8_type==1) { $col8_path=$sp_path; $col8_filler=$sp_filler; } if ($col8_type==2) { $col8_path=$oth_path; $col8_filler=$oth_filler; } $loop=1; while ($loop <= $col8_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col8_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col8_path . "/" . $col8_name . $col8_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col8_path . "/" . $col8_filler . "." . $img_format; ?>"><? } else { if ($col8_type==0) { $card=$card+$reg_worth; } if ($col8_type==1) { $spec=$spec+$sp_worth; } if ($col8_type==2) { $other=$other+$oth_worth; } } if ($loop%$col8_break==0) {echo "<br>\n";} elseif ($col8_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col9_own=ereg_replace("[\n\r/ /]", "", $col9_own); $col9_own_array=explode(",",$col9_own); $own_num=count($col9_own_array); if ($col9_type==0) { $col9_path=$reg_path; $col9_filler=$reg_filler; } if ($col9_type==1) { $col9_path=$sp_path; $col9_filler=$sp_filler; } if ($col9_type==2) { $col9_path=$oth_path; $col9_filler=$oth_filler; } $loop=1; while ($loop <= $col9_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col9_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col9_path . "/" . $col9_name . $col9_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col9_path . "/" . $col9_filler . "." . $img_format; ?>"><? } else { if ($col9_type==0) { $card=$card+$reg_worth; } if ($col9_type==1) { $spec=$spec+$sp_worth; } if ($col9_type==2) { $other=$other+$oth_worth; } } if ($loop%$col9_break==0) {echo "<br>\n";} elseif ($col9_touch!="1") {echo "\n";} $loop++; } ?> </p> <p align="center"> <? $col10_own=ereg_replace("[\n\r/ /]", "", $col10_own); $col10_own_array=explode(",",$col10_own); $own_num=count($col10_own_array); if ($col10_type==0) { $col10_path=$reg_path; $col10_filler=$reg_filler; } if ($col10_type==1) { $col10_path=$sp_path; $col10_filler=$sp_filler; } if ($col10_type==2) { $col10_path=$oth_path; $col10_filler=$oth_filler; } $loop=1; while ($loop <= $col10_size) { $own_loop=0; $show_filler=0; while ($own_loop<=$own_num) { if ($col10_own_array[$own_loop]==$loop) { $show_filler=1; ?><img src="<? echo $col10_path . "/" . $col10_name . $col10_own_array[$own_loop] . "." . $img_format; ?>"><? } $own_loop++; } if ($show_filler==0) { ?><img src="<? echo $col10_path . "/" . $col10_filler . "." . $img_format; ?>"><? } else { if ($col10_type==0) { $card=$card+$reg_worth; } if ($col10_type==1) { $spec=$spec+$sp_worth; } if ($col10_type==2) { $other=$other+$oth_worth; } } if ($loop%$col10_break==0) {echo "<br>\n";} elseif ($col10_touch!="1") {echo "\n";} $loop++; } ?> </p> <h2><? echo $fut_header; ?></h2> <p><? echo $fut_comment; ?></p> <? if ($fut_reg!= NULL) { $fut_reg=ereg_replace("[\n\r/ /]", "", $fut_reg); $fut_reg_array=explode(",",$fut_reg); sort($fut_reg_array); $fut_reg_num=count($fut_reg_array); } else { $fut_reg_num=0; } if ($fut_sp!= NULL) { $fut_sp=ereg_replace("[\n\r/ /]", "", $fut_sp); $fut_sp_array=explode(",",$fut_sp); sort($fut_sp_array); $fut_sp_num=count($fut_sp_array); } else { $fut_sp_num=0; } if ($fut_oth!= NULL) { $fut_oth=ereg_replace("[\n\r/ /]", "", $fut_oth); $fut_oth_array=explode(",",$fut_oth); sort($fut_oth_array); $fut_oth_num=count($fut_oth_array); } else { $fut_oth_num=0; } ?><p> <? $loop=0; while ($loop<$fut_reg_num && $fut_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $fut_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} ?></p> <p> <? $loop=0; while ($loop<$fut_sp_num && $fut_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $fut_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} ?></p> <p> <? $loop=0; while ($loop<$fut_oth_num && $fut_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $fut_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?></p> <h2><? echo $trd_header; ?></h2> <p><? echo $trd_comment; ?></p> <? if ($trd_reg!= NULL) { $trd_reg=ereg_replace("[\n\r/ /]", "", $trd_reg); $trd_reg_array=explode(",",$trd_reg); sort($trd_reg_array); $trd_reg_num=count($trd_reg_array); } else { $trd_reg_num=0; } if ($trd_sp!= NULL) { $trd_sp=ereg_replace("[\n\r/ /]", "", $trd_sp); $trd_sp_array=explode(",",$trd_sp); sort($trd_sp_array); $trd_sp_num=count($trd_sp_array); } else { $trd_sp_num=0; } if ($trd_oth!= NULL) { $trd_oth=ereg_replace("[\n\r/ /]", "", $trd_oth); $trd_oth_array=explode(",",$trd_oth); sort($trd_oth_array); $trd_oth_num=count($trd_oth_array); } else { $trd_oth_num=0; } ?><p> <? $loop=0; while ($loop<$trd_reg_num && $trd_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $trd_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} ?></p> <p> <? $loop=0; while ($loop<$trd_sp_num && $trd_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $trd_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} ?></p> <p> <? $loop=0; while ($loop<$trd_oth_num && $trd_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $trd_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?></p> <h2><? echo $mem_header; ?></h2> <p><? echo $mem_comment; ?></p> <p> <? if ($mem1_name!=NULL) { echo $mem1_name . " : " . $mem1_recv . "<br>\n"; } ?> <? if ($mem1_reg!= NULL) { $mem1_reg=preg_replace('/ /', '', $mem1_reg); $mem1_reg_array=explode(",",$mem1_reg); sort($mem1_reg_array); $mem1_reg_num=count($mem1_reg_array); } else { $mem1_reg_num=0; } if ($mem1_sp!= NULL) { $mem1_sp=preg_replace('/ /', '', $mem1_sp); $mem1_sp_array=explode(",",$mem1_sp); sort($mem1_sp_array); $mem1_sp_num=count($mem1_sp_array); } else { $mem1_sp_num=0; } if ($mem1_oth!= NULL) { $mem1_oth=preg_replace('/ /', '', $mem1_oth); $mem1_oth_array=explode(",",$mem1_oth); sort($mem1_oth_array); $mem1_oth_num=count($mem1_oth_array); } else { $mem1_oth_num=0; } $loop=0; while ($loop<$mem1_reg_num && $mem1_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem1_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem1_sp_num && $mem1_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem1_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem1_oth_num && $mem1_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem1_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem2_name!=NULL) { echo $mem2_name . " : " . $mem2_recv . "<br>\n"; } ?> <? if ($mem2_reg!= NULL) { $mem2_reg=preg_replace('/ /', '', $mem2_reg); $mem2_reg_array=explode(",",$mem2_reg); sort($mem2_reg_array); $mem2_reg_num=count($mem2_reg_array); } else { $mem2_reg_num=0; } if ($mem2_sp!= NULL) { $mem2_sp=preg_replace('/ /', '', $mem2_sp); $mem2_sp_array=explode(",",$mem2_sp); sort($mem2_sp_array); $mem2_sp_num=count($mem2_sp_array); } else { $mem2_sp_num=0; } if ($mem2_oth!= NULL) { $mem2_oth=preg_replace('/ /', '', $mem2_oth); $mem2_oth_array=explode(",",$mem2_oth); sort($mem2_oth_array); $mem2_oth_num=count($mem2_oth_array); } else { $mem2_oth_num=0; } $loop=0; while ($loop<$mem2_reg_num && $mem2_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem2_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem2_sp_num && $mem2_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem2_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem2_oth_num && $mem2_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem2_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem3_name!=NULL) { echo $mem3_name . " : " . $mem3_recv . "<br>\n"; } ?> <? if ($mem3_reg!= NULL) { $mem3_reg=preg_replace('/ /', '', $mem3_reg); $mem3_reg_array=explode(",",$mem3_reg); sort($mem3_reg_array); $mem3_reg_num=count($mem3_reg_array); } else { $mem3_reg_num=0; } if ($mem3_sp!= NULL) { $mem3_sp=preg_replace('/ /', '', $mem3_sp); $mem3_sp_array=explode(",",$mem3_sp); sort($mem3_sp_array); $mem3_sp_num=count($mem3_sp_array); } else { $mem3_sp_num=0; } if ($mem3_oth!= NULL) { $mem3_oth=preg_replace('/ /', '', $mem3_oth); $mem3_oth_array=explode(",",$mem3_oth); sort($mem3_oth_array); $mem3_oth_num=count($mem3_oth_array); } else { $mem3_oth_num=0; } $loop=0; while ($loop<$mem3_reg_num && $mem3_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem3_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem3_sp_num && $mem3_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem3_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem3_oth_num && $mem3_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem3_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem4_name!=NULL) { echo $mem4_name . " : " . $mem4_recv . "<br>\n"; } ?> <? if ($mem4_reg!= NULL) { $mem4_reg=preg_replace('/ /', '', $mem4_reg); $mem4_reg_array=explode(",",$mem4_reg); sort($mem4_reg_array); $mem4_reg_num=count($mem4_reg_array); } else { $mem4_reg_num=0; } if ($mem4_sp!= NULL) { $mem4_sp=preg_replace('/ /', '', $mem4_sp); $mem4_sp_array=explode(",",$mem4_sp); sort($mem4_sp_array); $mem4_sp_num=count($mem4_sp_array); } else { $mem4_sp_num=0; } if ($mem4_oth!= NULL) { $mem4_oth=preg_replace('/ /', '', $mem4_oth); $mem4_oth_array=explode(",",$mem4_oth); sort($mem4_oth_array); $mem4_oth_num=count($mem4_oth_array); } else { $mem4_oth_num=0; } $loop=0; while ($loop<$mem4_reg_num && $mem4_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem4_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem4_sp_num && $mem4_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem4_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem4_oth_num && $mem4_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem4_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem5_name!=NULL) { echo $mem5_name . " : " . $mem5_recv . "<br>\n"; } ?> <? if ($mem5_reg!= NULL) { $mem5_reg=preg_replace('/ /', '', $mem5_reg); $mem5_reg_array=explode(",",$mem5_reg); sort($mem5_reg_array); $mem5_reg_num=count($mem5_reg_array); } else { $mem5_reg_num=0; } if ($mem5_sp!= NULL) { $mem5_sp=preg_replace('/ /', '', $mem5_sp); $mem5_sp_array=explode(",",$mem5_sp); sort($mem5_sp_array); $mem5_sp_num=count($mem5_sp_array); } else { $mem5_sp_num=0; } if ($mem5_oth!= NULL) { $mem5_oth=preg_replace('/ /', '', $mem5_oth); $mem5_oth_array=explode(",",$mem5_oth); sort($mem5_oth_array); $mem5_oth_num=count($mem5_oth_array); } else { $mem5_oth_num=0; } $loop=0; while ($loop<$mem5_reg_num && $mem5_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem5_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem5_sp_num && $mem5_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem5_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem5_oth_num && $mem5_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem5_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem6_name!=NULL) { echo $mem6_name . " : " . $mem6_recv . "<br>\n"; } ?> <? if ($mem6_reg!= NULL) { $mem6_reg=preg_replace('/ /', '', $mem6_reg); $mem6_reg_array=explode(",",$mem6_reg); sort($mem6_reg_array); $mem6_reg_num=count($mem6_reg_array); } else { $mem6_reg_num=0; } if ($mem6_sp!= NULL) { $mem6_sp=preg_replace('/ /', '', $mem6_sp); $mem6_sp_array=explode(",",$mem6_sp); sort($mem6_sp_array); $mem6_sp_num=count($mem6_sp_array); } else { $mem6_sp_num=0; } if ($mem6_oth!= NULL) { $mem6_oth=preg_replace('/ /', '', $mem6_oth); $mem6_oth_array=explode(",",$mem6_oth); sort($mem6_oth_array); $mem6_oth_num=count($mem6_oth_array); } else { $mem6_oth_num=0; } $loop=0; while ($loop<$mem6_reg_num && $mem6_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem6_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem6_sp_num && $mem6_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem6_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem6_oth_num && $mem6_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem6_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem7_name!=NULL) { echo $mem7_name . " : " . $mem7_recv . "<br>\n"; } ?> <? if ($mem7_reg!= NULL) { $mem7_reg=preg_replace('/ /', '', $mem7_reg); $mem7_reg_array=explode(",",$mem7_reg); sort($mem7_reg_array); $mem7_reg_num=count($mem7_reg_array); } else { $mem7_reg_num=0; } if ($mem7_sp!= NULL) { $mem7_sp=preg_replace('/ /', '', $mem7_sp); $mem7_sp_array=explode(",",$mem7_sp); sort($mem7_sp_array); $mem7_sp_num=count($mem7_sp_array); } else { $mem7_sp_num=0; } if ($mem7_oth!= NULL) { $mem7_oth=preg_replace('/ /', '', $mem7_oth); $mem7_oth_array=explode(",",$mem7_oth); sort($mem7_oth_array); $mem7_oth_num=count($mem7_oth_array); } else { $mem7_oth_num=0; } $loop=0; while ($loop<$mem7_reg_num && $mem7_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem7_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem7_sp_num && $mem7_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem7_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem7_oth_num && $mem7_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem7_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem8_name!=NULL) { echo $mem8_name . " : " . $mem8_recv . "<br>\n"; } ?> <? if ($mem8_reg!= NULL) { $mem8_reg=preg_replace('/ /', '', $mem8_reg); $mem8_reg_array=explode(",",$mem8_reg); sort($mem8_reg_array); $mem8_reg_num=count($mem8_reg_array); } else { $mem8_reg_num=0; } if ($mem8_sp!= NULL) { $mem8_sp=preg_replace('/ /', '', $mem8_sp); $mem8_sp_array=explode(",",$mem8_sp); sort($mem8_sp_array); $mem8_sp_num=count($mem8_sp_array); } else { $mem8_sp_num=0; } if ($mem8_oth!= NULL) { $mem8_oth=preg_replace('/ /', '', $mem8_oth); $mem8_oth_array=explode(",",$mem8_oth); sort($mem8_oth_array); $mem8_oth_num=count($mem8_oth_array); } else { $mem8_oth_num=0; } $loop=0; while ($loop<$mem8_reg_num && $mem8_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem8_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem8_sp_num && $mem8_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem8_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem8_oth_num && $mem8_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem8_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem9_name!=NULL) { echo $mem9_name . " : " . $mem9_recv . "<br>\n"; } ?> <? if ($mem9_reg!= NULL) { $mem9_reg=preg_replace('/ /', '', $mem9_reg); $mem9_reg_array=explode(",",$mem9_reg); sort($mem9_reg_array); $mem9_reg_num=count($mem9_reg_array); } else { $mem9_reg_num=0; } if ($mem9_sp!= NULL) { $mem9_sp=preg_replace('/ /', '', $mem9_sp); $mem9_sp_array=explode(",",$mem9_sp); sort($mem9_sp_array); $mem9_sp_num=count($mem9_sp_array); } else { $mem9_sp_num=0; } if ($mem9_oth!= NULL) { $mem9_oth=preg_replace('/ /', '', $mem9_oth); $mem9_oth_array=explode(",",$mem9_oth); sort($mem9_oth_array); $mem9_oth_num=count($mem9_oth_array); } else { $mem9_oth_num=0; } $loop=0; while ($loop<$mem9_reg_num && $mem9_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem9_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem9_sp_num && $mem9_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem9_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem9_oth_num && $mem9_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem9_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <p> <? if ($mem10_name!=NULL) { echo $mem10_name . " : " . $mem10_recv . "<br>\n"; } ?> <? if ($mem10_reg!= NULL) { $mem10_reg=preg_replace('/ /', '', $mem10_reg); $mem10_reg_array=explode(",",$mem10_reg); sort($mem10_reg_array); $mem10_reg_num=count($mem10_reg_array); } else { $mem10_reg_num=0; } if ($mem10_sp!= NULL) { $mem10_sp=preg_replace('/ /', '', $mem10_sp); $mem10_sp_array=explode(",",$mem10_sp); sort($mem10_sp_array); $mem10_sp_num=count($mem10_sp_array); } else { $mem10_sp_num=0; } if ($mem10_oth!= NULL) { $mem10_oth=preg_replace('/ /', '', $mem10_oth); $mem10_oth_array=explode(",",$mem10_oth); sort($mem10_oth_array); $mem10_oth_num=count($mem10_oth_array); } else { $mem10_oth_num=0; } $loop=0; while ($loop<$mem10_reg_num && $mem10_reg_num!=0) { ?><img src="<? echo $reg_path . "/" . $mem10_reg_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $card=$card+$reg_worth; $loop++;} $loop=0; while ($loop<$mem10_sp_num && $mem10_sp_num!=0) { ?><img src="<? echo $sp_path . "/" . $mem10_sp_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $spec=$spec+$sp_worth; $loop++;} $loop=0; while ($loop<$mem10_oth_num && $mem10_oth_num!=0) { ?><img src="<? echo $oth_path . "/" . $mem10_oth_array[$loop] . "." . $img_format; ?>"><? echo "\n"; $other=$other+$oth_worth; $loop++;} ?> </p> <h1>logs & stats</h1> <h2>game & trade log</h2> <p><center><form><textarea name=text cols="100" rows="10" wrap=hard> <? echo $trade_log; ?> </textarea></form></center></p> <p> <a href="<? echo $game_name; ?>.txt">older logs here</a> </p> <h2><? echo $mast_header; ?></h2> <p><? echo $mast_comment; ?></p> <? echo $mast_badges; if ($card!=0) { $card=$card+($reg_worth*$mast_reg); } if ($spec!=0) { $spec=$spec+($sp_worth*$mast_sp); } if ($other!=0) { $other=$other+($oth_worth*$mast_oth); } ?> <h2>stats</h2> <p> <? $card=$card+0; ?> regular: <b><? if ($card!=0) { echo ($card/$reg_worth); } else {echo "0";} ?></b><br> special: <b><? if ($spec!=0) {echo ($spec/$sp_worth); } else {echo "0";} ?></b><br> other: <b><? if ($other!=0) {echo ($other/$oth_worth); } else {echo "0";} ?></b><br> card worth: <b><? echo ($card+$spec+$other); ?></b><br> </p> <?php include('bottom.php'); ?> I have absolutely no idea what I'm doing, so I'm completely lost... Quote Link to comment Share on other sites More sharing options...
Namtip Posted September 7, 2010 Share Posted September 7, 2010 error messages 1+2 ("Warning: include...") means the server can not find your include files. Have you put them in the right directory? when I use include I type just the name of the file at the following at the top of page e.g include 'auth.inc.php'; inside the spech marks lies the name of the file. I don't type out the whole directory I just put it in the htdocs file of apache or xampp or whatever you're using. errormessage 3 ("Warning: mysql_connect()...") This is probably a knock on effect from not including your include files. The include file will contain the variables($hostname,$user,$password) which mysql needs to connect to the database. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.