View Single Post
  #17  
Old 10-04-2011, 11:59 AM
Rogean Rogean is offline
¯\_(ツ)_/¯

Rogean's Avatar

Join Date: Oct 2009
Location: Massachusetts
Posts: 5,378
Default

Code:
    if (RuleB(Server, CharnameFederation)) {
        MYSQL_RES *result;
        MYSQL_ROW row;
        if (!RunQuery(query, MakeAnyLenString(&query, "SELECT a.id, a.account_id, a.timelaston, UNIX_TIMESTAMP(), b.status, b.banned, b.suspended FROM character_fed a left outer join account b on b.id = a.account_id WHERE a.name = '%s'", name), errbuf, &result)) {
            cerr << "Error in Char Federation query '" << query << "' " << errbuf << endl;
        } else {
            if ((row = mysql_fetch_row(result))) {
                if (atoi(row[0]) > 0 && atoi(row[1]) != account_id && (atoi(row[3]) - atoi(row[2]) < 7257600 || atoi(row[4]) || atoi(row[5]) || atoi(row[6]) > atoi(row[3]))) return false;
            }
            mysql_free_result(result);
        }
        safe_delete_array(query);
    }
__________________
Sean "Rogean" Norton
Project 1999 Co-Manager

Project 1999 Setup Guide
Last edited by Rogean; 10-04-2011 at 12:02 PM..