- Code: Select all
curl_setopt ($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml; charset=UTF-8","Accept-Language: fr-fr"));
in your getContentCurl() function
curl_setopt ($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml; charset=UTF-8","Accept-Language: fr-fr"));
Vexitor wrote:olgren wrote:Vexitor wrote:I am getting a SQL error, any ideas?
- Code: Select all
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 '(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(),
SQL:
SELECT members.name FROM `roster_members` members LEFT JOIN `roster_players` players ON members.name = players.name WHERE members.level >= 1 AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL 24 HOUR) ) ORDER BY members.last_online DESC
File: index.php
Line: 32
Do you know what version of MySQL you are running on?
I am running the following versions...
MySQL Version 4.0.25
PHP Version 4.3.2
Server Software Apache/2.0.46
olgren wrote:Ahhh.. the STR_TO_DATE function wasn't available till MySQL 4.1. There is another option here and that is to do the conversion in php code.
Kristoff22 wrote:It seems like there are major problems with Europe's Armory. I'll have to look into it a little more later.
In the meantime, can someone give me a realm/guild I can test from a European server? I just need one please Thanks.
Wyren wrote:Kristoff22 wrote:It seems like there are major problems with Europe's Armory. I'll have to look into it a little more later.
In the meantime, can someone give me a realm/guild I can test from a European server? I just need one please Thanks.
Feel free to test with Treehugging Hippies on Runetotem
Vexitor wrote:
I am running the following versions...
MySQL Version 4.0.25
PHP Version 4.3.2
Server Software Apache/2.0.46
edse wrote:When reading all in this toppic, some are talking about the functionality to select the players you want to update.
I cant find out how to do this.
Can anyone give me some explanation on this.
Greetings
Non-Critical Error: Incomplete Data for Busterthor. Player has probably not updated in awhile.
Busterthor synched: 1 seconds. Total runtime: 1 seconds.
Warning: fsockopen() [function.fsockopen]: unable to connect to armory.wow-europe.com:80 in /usr/share/www-data/thh/roster/addons/ArmorySynch/functions.general.php on line 37
CRITICAL ERROR - socket not connectedCRITICAL ERROR - no root XML node found: armory.wow-europe.com page
Non-Critical Error: Empty Content for Anu. Player has probably not updated in awhile.
Anu synched: 30 seconds. Total runtime: 31 seconds.
Non-Critical Error: Incomplete Data for Slim. Player has probably not updated in awhile.
Slim synched: 0 seconds. Total runtime: 31 seconds.
<?php
if (!defined('ROSTER_INSTALLED')) {
exit('Detected invalid access to this file!');
}
//Configuration
$addon_conf['ArmorySync']['Host'] = "armory.wow-europe.com"; //European players use: armory.wow-europe.com
$addon_conf['ArmorySync']['MinLevel'] = 70; //The minimum level to be updated
$addon_conf['ArmorySync']['SynchCutoffTime'] = 504; //Time, in hours. All players who have not updated in the last (24) hours will be updated.
$addon_conf['ArmorySync']['UseCurl'] = false; //Set this to false if you want to use the original FileSocket function.
?>
titan99 wrote:Wyren i have this bug me to
Return to ArmorySync - Depreciated
Users browsing this forum: No registered users and 0 guests