Ramadi
Member
- Mar 12, 2016
- 79
- 19
- 43
2- After this code (press "I") and add this code to crontab's last empty line:
Code:*/10 * * * * sudo -u www-data php /YOUR_RANKSYSTEM_PATH/worker.php check >/dev/null 2>&1
I think u forgot one step
2- After this code (press "I") and add this code to crontab's last empty line:
Code:*/10 * * * * sudo -u www-data php /YOUR_RANKSYSTEM_PATH/worker.php check >/dev/null 2>&1
I said "I am using nano text editor." I am not using VI, so ...I think u forgot one step
Can someody help me with that error???
Code:Array ( [0] => 42000 [1] => 1064 [2] => 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 's Property★ | '),('B6DgwIytbTDnwoTUfp3g9iuE1AE=', '24', '0', '0', '0', '0', '8' at line 1 )
As i check the problem is with a Specific Server Group that is called "★ Admin's Property ★ " and i don't even include that group in the rank system.I said "I am using nano text editor." I am not using VI, so ...
Probably you have problem with your mysql recorder files, did you edit this ? You can try to change all ranksystem files. I think your problem will solved.
I mean, you can try a clean installation. Especially if you edited mysql recorder php files.As i check the problem is with a Specific Server Group that is called "★ Admin's Property ★ " and i don't even include that group in the rank system.
What i also did, is that i found the Database ID with that UniqueID and i removed it from there!
What do you mean by saying change ranksystem files? Can you be more specific please?
I mean, you can try a clean installation. Especially if you edited mysql recorder php files.
I can not understant to what you did but maybe something's wrong in mysql with "★" this or "Admin", did you try to rename this server group ?
You sql datbase is missing a table!today I got this error
Code:Array ( [0] => 42S02 [1] => 1146 [2] => Table 'ranksystem.groups' doesn't exist )
any idea what's the problem
how come this happen and i was running this script for more than week until i got this errorYou sql datbase is missing a table!
I don't know how it happened but it did, i guess you can re-install it!how come this happen and i was running this script for more than week until i got this error
! windows support is back (for the webspace); the COM extension for PHP is required (extension=php_com_dotnet.dll -> only Windows!)
! check ts3 permission "b_client_remoteaddress_view" is set for query account
* initiate log level; log entries now have a log category
+ added log rotation; ranksystem.log will be rotate on filesize of 5 MiB
+ added italian translation; many thx to ZanK
+ added filter function on list_rankup.php; filter are usable about the search field (filters are: "filter:excepted:", "filter:nonexcepted:", "filter:online:", "filter:nononline:", "filter:actualgroup:GROUPID:"); documentation on a info box will follow
+ color online users on column "last seen" on list_rankup.php
+ increase perfomance for siteload on stats/index.php, when Ranksystem already longer runs
+ added progress bar for next rankup on my_stats.php
+ the parameter "Idletime" will now be consided on calculation for the rank (i.a. on list_rankup.php?sort=rank)
- fixed wrong labeling on Top User sites for "active time" / "online time"; depending on the parameter "Idletime"
- fixed ip 127.0.0.1 were shown on stats/index.php instead of the external address
- fixed wrong subtraction of online time of already deleted users on "Online time of all user / week" and "Online time of all user / month"; in special cases it could come to minus values
- fixed wrong info in log for needed file permissions on folders (avatars, icons, logs)
- fixed wrong update notification after first run with new version
- fixed ts3 server address on stats/index.php; when ts3 address is localhost and the URL contains "www.", the "www." will be removed out of the showing ts3 address
Already done the update! Thank you for the reminding @0x0539 though.For the ones that like to stay up to date but didn't know about the new version.
Check here.
New version: 1.0.2
Code:! windows support is back (for the webspace); the COM extension for PHP is required (extension=php_com_dotnet.dll -> only Windows!) ! check ts3 permission "b_client_remoteaddress_view" is set for query account * initiate log level; log entries now have a log category + added log rotation; ranksystem.log will be rotate on filesize of 5 MiB + added italian translation; many thx to ZanK + added filter function on list_rankup.php; filter are usable about the search field (filters are: "filter:excepted:", "filter:nonexcepted:", "filter:online:", "filter:nononline:", "filter:actualgroup:GROUPID:"); documentation on a info box will follow + color online users on column "last seen" on list_rankup.php + increase perfomance for siteload on stats/index.php, when Ranksystem already longer runs + added progress bar for next rankup on my_stats.php + the parameter "Idletime" will now be consided on calculation for the rank (i.a. on list_rankup.php?sort=rank) - fixed wrong labeling on Top User sites for "active time" / "online time"; depending on the parameter "Idletime" - fixed ip 127.0.0.1 were shown on stats/index.php instead of the external address - fixed wrong subtraction of online time of already deleted users on "Online time of all user / week" and "Online time of all user / month"; in special cases it could come to minus values - fixed wrong info in log for needed file permissions on folders (avatars, icons, logs) - fixed wrong update notification after first run with new version - fixed ts3 server address on stats/index.php; when ts3 address is localhost and the URL contains "www.", the "www." will be removed out of the showing ts3 address
That means you Rank System bot is not connected to your teamspeak 3 server!What is the solution ? http://prntscr.com/bcna9m
*/10 * * * * sudo -u www-data php /path/to/your/ranksystem/worker.php check >/dev/null 2>&1
*/10 * * * * sudo -u www-data php /path/to/your/ranksystem/worker.php restart >/dev/null 2>&1
This thread is no longer supported, if you have any questions click the link above.THREAD HAS BEEN UPDATED TO NEWER VERSION
Version 1.0.2 ==> Click Here