- // Load referal counts
- $result_refs = SQL_QUERY_ESC("SELECT `counter` FROM `{?_MYSQL_PREFIX?}_refsystem` WHERE `userid`=%s AND `level`='%s' LIMIT 1",
- array(
- getMemberId(),
- bigintval($content['level'])
- ), __FILE__, __LINE__);
-
- // Do we have an entry?
- if (SQL_NUMROWS($result_refs) == 1) {
- // Load data
- $content = merge_array($content, SQL_FETCHARRAY($result_refs));
-
- // Add them to total refs
- $content['total_referals'] += $content['counter'];
- } // END - if
-
- // Free result
- SQL_FREERESULT($result_refs);
-