$query =
"SELECT members.name " .
"FROM `".ROSTER_MEMBERSTABLE."` members " .
"LEFT JOIN `".ROSTER_PLAYERSTABLE."` players " .
"ON members.name = players.name " .
"WHERE members.level >= " . $addon_conf['ArmorySync']['MinLevel'] . " " .
"ORDER BY " . $addon_conf['ArmorySync']['MemberSorting'];

is what i changed it to.... and now i get

1064: 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 'ORDER BY' at line 1
SQL:
SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= ORDER BY
File: index.php
Line: 35

$addon_conf['ArmorySync']['MemberSorting'] probably isn't set
I'd check this setting

$addon_conf['ArmorySync']['MemberSorting'] = "members.last_online DESC";

is in the conf file

Doesn't look like its picking up the min level either

ok i fixed it by guess what ghedofying it i basicly know something about php so i put all the info from the config file at the top of the index.php file and it worked ?? weird huh guys

jammersplace wrote:ok i fixed it by guess what ghedofying it i basicly know something about php so i put all the info from the config file at the top of the index.php file and it worked ?? weird huh guys

Would you mind posting your code snippet so that we can get an idea of what you are attempting to explain?

Code: Select all

<?php


require_once("functions.synch.php");
require_once(ROSTER_LIB.'login.php');

$addon_conf['ArmorySync']['Host'] = "armory.worldofwarcraft.com"; //European players use: armory.wow-europe.com
$addon_conf['ArmorySync']['MinLevel'] = 10; //The minimum level to be updated
$addon_conf['ArmorySync']['SynchCutoffTime'] = 24; //Time, in hours.  All players who have not updated in the last (24) hours will be updated.
$addon_conf['ArmorySync']['UseCurl'] = true; //Set this to false if you want to use the original FileSocket function.
$addon_conf['ArmorySync']['DebugLevel'] = 0; //0 = no debug messages, 1 = some debug messages, 2 = verbose debug messages
$addon_conf['ArmorySync']['UpdateRoster'] = true; //Wether or not to update Roster.  Useful if you're just debugging.
$addon_conf['ArmorySync']['Locale'] = $roster_conf['roster_lang']; //The language used, but default it is the language that roster is configured to.
$addon_conf['ArmorySync']['ArmoryLocale'] = strtolower(substr($addon_conf['ArmorySync']['Locale'], 0, 2)) . "_" . strtolower(substr($addon_conf['ArmorySync']['Locale'], 2, 2)); //The Locale that armory is expecting, in the format of lowercase_lowercase (ie en_us or de_de).
$addon_conf['ArmorySync']['MemberSorting'] = "members.last_online DESC"; //alternatives are "members.update_time DESC" to use the last time the member was updated
$addon_conf['ArmorySync']['ServerMonth'] = array("January","February","March","April","May","June","July","August","September","October","November","December"); //just a list of the month names for the server.  Change this to whatever language necessary.


if (!defined('ROSTER_INSTALLED')) {
   exit('Detected invalid access to this file!');
}


basically at the top of the index.php file