function setCacheWaypoint($cacheid, $ocWP) { $r['maxwp'] = XDb::xSimpleQueryValue('SELECT MAX(`wp_oc`) `maxwp` FROM `caches`', null); if ($r['maxwp'] == null) { $sWP = $ocWP . "0001"; } else { $sWP = generateNextWaypoint($r['maxwp'], $ocWP); } XDb::xSql("UPDATE `caches` SET `wp_oc`= ?\n WHERE `cache_id`= ? AND ISNULL(`wp_oc`)", $sWP, $cacheid); }
function setCacheWaypoint($cacheid, $ocWP) { $bLoop = true; // falls mal was nicht so funktioniert wie es soll ... $nMaxLoop = 10; $nLoop = 0; while ($bLoop == true && $nLoop < $nMaxLoop) { $rs = sql('SELECT MAX(`wp_oc`) `maxwp` FROM `caches`'); $r = sql_fetch_assoc($rs); mysql_free_result($rs); if ($r['maxwp'] == null) { $sWP = $ocWP . "0001"; } else { $sWP = generateNextWaypoint($r['maxwp'], $ocWP); } $bLoop = false; $nLoop++; sql("UPDATE `caches` SET `wp_oc`='&1' WHERE `cache_id`='&2' AND ISNULL(`wp_oc`)", $sWP, $cacheid) || ($bLoop = true); } }