PHP generateNextWaypoint Examples

Example #1

File: newcache.php Project: kojoty/opencaching-pl

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);
}

Example #2

File: clicompatbase.inc.php Project: pawelzielak/opencaching-pl

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);
    }
}