Introducing ArmorySync

by **wwickens** » Fri Apr 06, 2007 10:49 am

is there an updated downlod of this addon with all the changes since this thread started

Thx

by **SimianPirate** » Fri Apr 06, 2007 4:03 pm

I installed this on my roster and got the following error when clicking the "ArmorySynch" addon:
Warning: main(functions.synch.php): failed to open stream: No such file or directory in /home/public_html/wow/roster/addons/ArmorySynch/index.php on line 2

Fatal error: main(): Failed opening required 'functions.synch.php' (include_path='') in /home/public_html/wow/roster/addons/ArmorySynch/index.php on line 2

by **Vexitor** » Fri Apr 06, 2007 11:16 pm

Doesn't look like my provider will update mysql anytime soon.

Anyone have any ideas to help, or replace the "STR_TO_DATE" function?

Was not introduced until 4.1, and I am stuck with 4.0.25 for now.

I would appreciate it.

by **tinmarok** » Sun Apr 08, 2007 6:48 pm

I think that's the following line (line 46 in index.php) would be fine

Code: Select all: "OR CONCAT( '20',MID( players.dateupdatedutc, 7, 2 ) , '-', MID( players.dateupdatedutc, 4, 2 ) , '-', MID( players.dateupdatedutc, 1, 2 ) , ' ', MID( players.dateupdatedutc, 9, 10 ) ) <= DATE_SUB(NOW(), INTERVAL " . $addon_conf['ArmorySync']['SynchCutoffTime'] . " HOUR) ) " .

by **blackice** » Wed Apr 11, 2007 12:06 am

blackice wrote:Okay this is odd, Just got the new version and here is what happening

I am getting a white page with the following info (remove the names and replace with playerx)

player1 synched: 5 seconds. Total runtime: 5 seconds.
player2 synched: 6 seconds. Total runtime: 11 seconds.
player3 synched: 5 seconds. Total runtime: 16 seconds.
player4 synched: 6 seconds. Total runtime: 22 seconds.
player5 synched: 5 seconds. Total runtime: 27 seconds.

Looks like it work but I don't see anything new in the database.

Any ideas?

Still looking for a answers for this. Any help would be great....

What version of php and or MySQL should we be running here?

by **Kristoff22** » Wed Apr 11, 2007 12:29 am

blackice wrote:
blackice wrote:Okay this is odd, Just got the new version and here is what happening

I am getting a white page with the following info (remove the names and replace with playerx)

player1 synched: 5 seconds. Total runtime: 5 seconds.
player2 synched: 6 seconds. Total runtime: 11 seconds.
player3 synched: 5 seconds. Total runtime: 16 seconds.
player4 synched: 6 seconds. Total runtime: 22 seconds.
player5 synched: 5 seconds. Total runtime: 27 seconds.

Looks like it work but I don't see anything new in the database.

Any ideas?

Still looking for a answers for this. Any help would be great....

What version of php and or MySQL should we be running here?

You should not need an updated version of php of MySQL just to run ArmorySync. Whatever the required version for Roster is should work just fine.

Do you have a link to your site? The times are definitely correct but I don't see why it wouldn't update any data.

by **Tango** » Wed Apr 11, 2007 3:42 am

I am having the same problem as SimianPirate.

I have extracted the files from the first post into the \wow\roster\addons directory. Is there anything else that I needed to do?

by **blackice** » Wed Apr 11, 2007 6:47 pm

Kristoff22 wrote:You should not need an updated version of php of MySQL just to run ArmorySync. Whatever the required version for Roster is should work just fine.

Do you have a link to your site? The times are definitely correct but I don't see why it wouldn't update any data.

Sorry the site in not on the net at this time, but here is what showing up in the Apache's error log if it helps

Code: Select all: [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 143 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 146 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 207 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 208 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 210 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 211 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 212 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 124 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 127 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 144 [Wed Apr 11 05:41:32 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 147 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 143 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 146 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 207 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 208 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 210 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 211 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 212 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 124 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 127 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 144 [Wed Apr 11 05:41:35 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 147 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 143 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 146 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 207 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 208 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 210 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 211 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.synch.php on line 212 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 124 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 127 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 144 [Wed Apr 11 05:41:39 2007] [error] PHP Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.parsing.php on line 147 [Wed Apr 11 05:42:09 2007] [error] PHP Fatal error: Maximum execution time of 30 seconds exceeded in D:\\Inetpub\\Apache Group\\Apache\\htdocs\\roster\\addons\\ArmorySynch\\functions.general.php on line 27

by **Kristoff22** » Thu Apr 12, 2007 1:37 am

blackice wrote:
Kristoff22 wrote:You should not need an updated version of php of MySQL just to run ArmorySync. Whatever the required version for Roster is should work just fine.

Do you have a link to your site? The times are definitely correct but I don't see why it wouldn't update any data.

Sorry the site in not on the net at this time, but here is what showing up in the Apache's error log if it helps

You need to modify php.INI and allow pass_by_reference, as it says in that error. Also, you should up the maximum execution time, as it takes awhile for the sync to complete.

by **zanix** » Thu Apr 12, 2007 7:29 am

There is a warning in php.ini for this setting

; Whether to enable the ability to force arguments to be passed by reference
; at function call time. This method is deprecated and is likely to be
; unsupported in future versions of PHP/Zend. The encouraged method of
; specifying which arguments should be passed by reference is in the function
; declaration. You're encouraged to try and turn this option Off and make
; sure your scripts work properly with it in order to ensure they will work
; with future versions of the language (you will receive a warning each time
; you use this feature, and the argument will be passed by value instead of by
; reference).
allow_call_time_pass_reference = On

by **RottGutt** » Thu Apr 12, 2007 9:48 am

I am getting this error:

includes/db/db.php

CMS Warning line 75: On /index.php?name=WoWRosterDF&file=addon&roster_addon_name=ArmorySynch While executing query "SELECT members.name FROM `WoW_wowrosterdf_roster_members` members LEFT JOIN `WoW_wowrosterdf_roster_players` players ON members.name = players.name WHERE members.level >= AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i:%s') <= DATE_SUB(NOW(), INTERVAL HOUR) ) ORDER BY members.last_online DESC" the following error occured: 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 'AND ( ISNULL(players.name) OR STR_TO_DATE(players.dateupdatedutc,'%m/%d/%y %H:%i' at line 1 In: /home/freak6/public_html/modules/WoWRosterDF/lib/wowdb.php on line: 96

DragonflyCMS v9.1.1
WoWRosterDF v1.7.3
MySQL v4.1.21-standard
PHP v4.4.4

Can someone decipher the error please?

RottGutt

by **zanix** » Thu Apr 12, 2007 9:57 am

Code: Select all: WHERE members.level >= AND ( ISNULL

The SQL string isn't getting the level it seems

by **RottGutt** » Thu Apr 12, 2007 10:10 am

zanix wrote:
Code: Select all
WHERE members.level >= AND ( ISNULL

The SQL string isn't getting the level it seems

Thanks for the reply. Suggestions on how to fix it?

by **zanix** » Thu Apr 12, 2007 10:52 am

I don't use this addon, so my best guess is to try to find this SQL string in one of the addon files and see if the level variable is being set

by **Anaxent** » Thu Apr 12, 2007 11:26 am

The error was caused because 2 files were not inlcuded.
open the index.php file and change the first 2 lines to this

Code: Select all: require_once($addonDir.'functions.synch.php'); require_once($addonDir.'config.php');