while (list($uid) = SQL_FETCHROW($result_daily))
{
$result_points = SQL_QUERY_ESC("SELECT ref_depth, locked_points FROM "._MYSQL_PREFIX."_user_points
-WHERE userid=%d AND locked_points != 0.00000 ORDER BY ref_depth",
+WHERE userid=%s AND locked_points != 0.00000 ORDER BY ref_depth",
array(bigintval($uid)), __FILE__, __LINE__);
if (SQL_NUMROWS($result_points) > 0)
{
while (list($dep, $locked) = SQL_FETCHROW($result_points))
{
$result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s, locked_points=0.00000
-WHERE userid=%d AND ref_depth=%d LIMIT 1",
+WHERE userid=%s AND ref_depth=%s LIMIT 1",
array($locked, bigintval($uid), $dep), __FILE__, __LINE__);
// Update mediadata as well
$_CONFIG['last_update'] = time();
// Update database
-$result_daily = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_config SET last_update=UNIX_TIMESTAMP()
-WHERE config=0 AND last_update != UNIX_TIMESTAMP() LIMIT 1", __FILE__, __LINE__);
+$result_daily = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_config
+SET last_update=UNIX_TIMESTAMP()
+WHERE config=0 AND last_update != UNIX_TIMESTAMP()
+LIMIT 1", __FILE__, __LINE__);
// Destroy cache
if ((GET_EXT_VERSION("cache") >= "0.1.2") && (SQL_AFFECTEDROWS() == 1))