Yet another error

Sync Blizzards' Armory data with WoWRoster (addon depreciated no longer works see ApiSync)

Moderators: Ulminia, poetter

Yet another error

Postby jammersplace » Thu Jul 26, 2007 10:21 pm

$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
jammersplace
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Fri Jun 22, 2007 1:36 am

Yet another error

Postby zanix » Thu Jul 26, 2007 10:28 pm

$addon_conf['ArmorySync']['MemberSorting'] probably isn't set
I'd check this setting
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Yet another error

Postby jammersplace » Thu Jul 26, 2007 10:38 pm

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

is in the conf file
jammersplace
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Fri Jun 22, 2007 1:36 am

Yet another error

Postby Pugro » Thu Jul 26, 2007 11:50 pm

Doesn't look like its picking up the min level either
--------------------------------
Pugro_
Ice and Trinity Guilds, Nordrassil, EU PvE
www.iceguild.org.uk, www.trinityguild.net
Image
Pugro
WR.net Journeyman
WR.net Journeyman
 
Posts: 79
Joined: Fri Jul 07, 2006 2:14 pm
Location: London, UK

Re: Yet another error

Postby jammersplace » Fri Jul 27, 2007 12:11 am

ok i fixed it by guess what ghedofying it :P 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
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Fri Jun 22, 2007 1:36 am

Re: Yet another error

Postby mfoley » Fri Jul 27, 2007 1:21 am

jammersplace wrote:ok i fixed it by guess what ghedofying it :P 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?
User avatar
mfoley
WR.net Apprentice
WR.net Apprentice
 
Posts: 55
Joined: Tue Aug 08, 2006 11:27 am

Re: Yet another error

Postby jammersplace » Fri Jul 27, 2007 2:48 am

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
jammersplace
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Fri Jun 22, 2007 1:36 am


Return to ArmorySync - Depreciated

Who is online

Users browsing this forum: No registered users and 1 guest

cron