update all results in a table

any ideas? :S

[Join us @ facebook]

I don't get it.

How it was supposed to update only the members you want when you don't select them from somewhere?

i dont want it to only update certain players, remember, we are doing this to find all player results (all players in a table, no matter how many) i actually set the limit to 30 so it only updates 30 -- make more sense

so if this helps you to better understand.. it is correctly getting each player ID and player name, then updating each player .. but it is getting the wrong information for each user, its using the first users results for each person

still struggling with this, cant seem to get it to load the right data for each player in the array -- seeing as it only uses the data for the first player result ... should I take screenshots of the script in action so you all can gain a better understanding?

Code:

<?php
//capture required files for inclusion
require_once "../../maincore.php";
require_once BASEDIR."subheader.php";
require_once ADMIN."navigation.php";
require_once "core.php";
//checks admin rights
if (!checkrights("HS") || !defined("iAUTH") || $aid != iAUTH) fallback("../index.php");
opentable($module_name." v".$version." - Update All Players");
$result = dbquery("SELECT player_id, player_name FROM ".$db_prefix."hiscores LIMIT $result_limit");
function GetRank($skill)
{ $str1 = strstr($GLOBALS['contents'], '>'.$skill.'<');
if(strpos($str1, 't"')>40){return '';}
$pos1 = strpos($str1, 't"')+3; 
return substr($str1, $pos1, strpos($str1,'<',$pos1)-$pos1);} 
function GetLvl($skill)
{ $str1 = strstr($GLOBALS['contents'], '>'.$skill.'<');
if(strpos($str1, 't"')>40){return '';}
$pos1 = strpos($str1, 't"',strpos($str1, 't"')+1)+3;
return substr($str1, $pos1, strpos($str1,'<',$pos1)-$pos1);}
function GetXP($skill)
{ $str1 = strstr($GLOBALS['contents'], '>'.$skill.'<');
if(strpos($str1, 't"')>40){return '';}
$pos1 = strpos($str1, 't"',strpos($str1, 't"',strpos($str1, 't"')+1)+1)+3; 
return substr($str1, $pos1, strpos($str1,'<',$pos1)-$pos1);}
function IS_ODD($player_prayer) { return($player_prayer & 1); }
function IS_EVEN($player_prayer) { return(!($player_prayer & 1)); }
function IS_ODD2($ranged) { return($ranged & 1); }
function IS_EVEN2($ranged) { return(!($ranged & 1)); }
function IS_ODD3($magic) { return($magic & 1); }
function IS_EVEN3($magic) { return(!($magic & 1)); }
while( $data = dbarray($result) )
$id[] = $data ['player_id'];
foreach($id as $value)
{
$name = dbresult(dbquery("SELECT player_name FROM fusion_hiscores WHERE player_id = $value"),0);
$handle = fopen("http://hiscore-web.runescape.com/lang/en/aff/runescape/hiscorepersonal.ws?user1=".$name,"r"); 
if($handle){ while (!feof($handle)) { $contents .= fread($handle, 8192); } fclose($handle);}
$overall = GetLvl(Overall); $attack = GetLvl(Attack); $strength = GetLvl(Strength); $defence = GetLvl(Defence);
$hitpoints = GetLvl(Hitpoints); $ranged = GetLvl(Ranged); $player_prayer = GetLvl(Prayer); $magic = GetLvl(Magic);
$cooking = GetLvl(Cooking); $woodcutting = GetLvl(Woodcutting); $fletching = GetLvl(Fletching); $fishing = GetLvl(Fishing);
$firemaking = GetLvl(Firemaking); $crafting = GetLvl(Crafting); $smithing = GetLvl(Smithing); $mining = GetLvl(Mining);
$herblore = GetLvl(Herblore); $agility = GetLvl(Agility); $thieving = GetLvl(Thieving); $slayer = GetLvl(Slayer);
$runecraft = GetLvl(Runecraft); $farming = GetLvl(Farming); $construction = GetLvl(Construction);
//begin combat
$def = $defence*100; $hp = $hitpoints*100; $att = $attack*130; $str = $strength*130; 
//calculate base combat
if(IS_ODD($player_prayer)){ $prayer = ($player_prayer - 1)*50; } 
elseif(IS_EVEN($player_prayer)){ $prayer = $player_prayer*50; } 
$base1 = $def + $hp + $prayer; $base_combat = $base1/400; 
//find personal class combat
if(IS_ODD2($ranged)){ $range = (($ranged - 1)+($ranged*2))*65; } 
elseif(IS_EVEN2($player_prayer)){ $range = $ranged*195; } 
if(IS_ODD3($magic)){ $mage = (($magic - 1)+($magic*2))*65; } 
elseif(IS_EVEN3($magic)){ $mage = $magic*195; }
$melee_combat = ($att + $str)/400; $range_combat = $range/400; $mage_combat = $mage/400;
//calculate final class combat
if ($melee_combat > $range_combat) { $class_combat = $melee_combat; }
elseif ($melee_combat > $mage_combat) { $class_combat = $melee_combat; } 
elseif ($range_combat > $melee_combat) { $class_combat = $range_combat; } 
elseif ($range_combat > $mage_combat) { $class_combat = $range_combat; } 
elseif ($mage_combat > $melee_combat) { $class_combat = $mage_combat; } 
elseif ($mage_combat > $range_combat) { $class_combat = $mage_combat; }
//finalize combat level
$combat_level = $class_combat + $base_combat;
//end combat formula
$update_stats = ("UPDATE ".$db_prefix."hiscores set player_att = '$attack', player_str = '$strength', 
player_def = '$defence', player_hp = '$hitpoints', player_range = '$ranged', player_mage = '$magic', 
player_pray = '$player_prayer', player_mining = '$mining', player_smith = '$smithing', player_wc = '$woodcutting', 
player_fm = '$farming', player_agil = '$agility', player_herb = '$herblore', 
player_fish = '$fishing', player_thief = '$thieving', player_cook = '$cooking', 
player_craft = '$crafting', player_fletch = '$fletching', player_slay = '$slayer', 
player_farm = '$farming', player_con = '$construction', player_overall = '$overall',
player_cmb = '$combat_level' WHERE player_id = $value");
$run_query = dbquery($update_stats);
if (!$run_query){ echo "<center>Error Updating Player <B>".$name."</b> Stats.</center>"; } 
else { echo "<center><i>ID[".$value."]</i>|Player: <b>".$name."</b> successfully updated.
<br><i>ASDHRPM [$attack|$strength|$defence|$hitpoints|$ranged|$player_prayer|$magic]</center></i>"; }
}
echo "<center><br><br>Click [<a href='".BASEDIR."administration/hiscores/index.php".$aidlink."'>here</a>] to return to the ".$module_name."</center>"; 
closetable();
?>

ok am locking this, no one seems to be able to help -.-

[Guest]

[36.906]

Yahoo crawler, Googlebot, Baidu Spider