- // 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'];