EVE Technology Lab

When you run a standard check it takes 100 at a time, and you can see the Progress.

Im constantly getting a error 500 when running the full reset check, and it stops. This Means i have a number of people not getting updated with right Corp / Alliance tags and nore get their Avatar updated.

Else great work, keeping the mod running

You might want to use the current version ... 1.2.1 doesn't support the new style keys.

Via SMF you have two options for checks. A simpel which takes 100 members at a time and update on screen so you can see Progress and a full reset, which you need if you change theme and want bigger avatars, or someone update their avatar in EVE, and you wana transfer that to the forum.

This Reset check takes all member at once which result tin a timeout and server 500 error.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
File: XXXXXXX\TEA.php
Line: 2408

Server Windows 2003 IIS 6
MySQL 5
PHP 5

TEA Your Version: 1.3.0 r179

SMF 2.0.5

I just updated the SMF Database to 2.0.5 as it was 2.0.2 but that didnt help.

Im clicking on: Reset All Names, Avatars to those Set with Main Character

function format_name($memID, $char, $type='name')
{
$chars = $this -> get_all_chars($memID);

$smfgroups = $this -> smf_groups($memID);
if(!empty($chars))
{
// $rules = $this -> smcFunc['db_query']('', "SELECT id, smf, ts, tst, nf FROM {db_prefix}tea_ts_rules");
// $rules = $this -> tea -> select($rules);
// if(!empty($rules))
// {
// foreach($rules as $r)
// {
// if(!empty($smfgroups))
// {
// foreach($smfgroups as $g)
// {
// if($r[1] == $g)
// {
// if(!isset($nf))
// $nf = $r[4];
// }
// }
// }
// }
// }
foreach($chars as $i => $ch)
{
if($ch[0] == $char)
$charinfo = $ch;
}
if(!empty($charinfo))
{
// if($nf)
// $name = $nf;
// else
if($type == 'title')
$name = $this -> modSettings["tea_tf"];
else
$name = $this -> modSettings["tea_nf"];
$name = str_replace('#at#', $charinfo[4], $name);
$name = str_replace('#ct#', $charinfo[1], $name);
$name = str_replace('#name#', $char, $name);
}
}
// if(strlen($name) > 30)
// {
// $name = substr($name, 0, 30);
// }
:2736 return $name;
}

function pref_reset()
{
$user = $this -> smcFunc['db_query']('', "SELECT id, main FROM {db_prefix}tea_user_prefs");
$user = $this -> select($user);
if(!empty($user))
{
foreach($user as $u)
{
$memberID = $u[0];
$charid = $u[1];
$char = $this -> smcFunc['db_query']('', "SELECT name, corpid, corp, corp_ticker, allianceid, alliance, alliance_ticker FROM {db_prefix}tea_characters WHERE charid = ".$charid);
$char = $this -> select($char);
if(!empty($char))
{
$char = $char[0];
$name = $char[0];
if($this -> modSettings["tea_custom_title"])
{
$title = $this -> format_name($memberID, $name, 'title');
$this -> query("UPDATE {db_prefix}members SET usertitle = '".$title."' WHERE ID_MEMBER = ".$memberID);
}
if($this -> modSettings["tea_custom_name"])
{
$name = $this -> format_name($memberID, $name);
$this -> query("UPDATE {db_prefix}members SET real_name = '".mysql_real_escape_string($name)."' WHERE ID_MEMBER = ".$memberID);
}

if($this -> modSettings['tea_avatar_enabled'])
{
// if($this -> modSettings["tea_corptag_options"] == 2)
// {
// $name = explode("] ", $name, 2);
// $name = $name[1];
// }
// if(isset($this -> chars[$name]['charid']))
// {
require_once("Subs-Graphics.php");
$tea_avatar_size = !empty($this -> modSettings['tea_avatar_size']) ? $this -> modSettings['tea_avatar_size'] : 64;
downloadAvatar('http://image.eveonline.com/Character/'.$charid.'_'.$tea_avatar_size.'.jpg', $memberID, $tea_avatar_size, $tea_avatar_size);
// }
}
}
:2799 $count++;
}
}
return $count." User Prefs reset";
}