TeamSpeak 3 - Rank/Level up system - v1.0.0

Ramadi · May 6, 2016

qwelethe said:
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

Wrath X · May 6, 2016

Ramadi said:
I think u forgot one step

I said "I am using nano text editor." I am not using VI, so ...

Alligatoras said:

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
)

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.

Alligatoras · May 6, 2016

qwelethe said:
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.

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?

Wrath X · May 6, 2016

Alligatoras said:
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 ?

Alligatoras · May 6, 2016

qwelethe said:
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 ?

Well, probably something was wrong in the whole thing. I did a clean install and the program works correctly now.
Thank you for your help my friend!

Ramadi · May 8, 2016

today I got this error

Code:

Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'ranksystem.groups' doesn't exist
)

any idea what's the problem

Alligatoras · May 8, 2016

Ramadi said:
today I got this error

Code:

Array ( [0] => 42S02 [1] => 1146 [2] => Table 'ranksystem.groups' doesn't exist )

any idea what's the problem

You sql datbase is missing a table!

Ramadi · May 8, 2016

Alligatoras said:
You sql datbase is missing a table!

how come this happen and i was running this script for more than week until i got this error

Alligatoras · May 9, 2016

Ramadi said:
how come this happen and i was running this script for more than week until i got this error

I don't know how it happened but it did, i guess you can re-install it!

0x0539 · Jun 5, 2016

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

Alligatoras · Jun 5, 2016

0x0539 said:

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

Already done the update! Thank you for the reminding @0x0539 though.
Also they are about to update it to version: 1.1.0 ....but still under creation!

Changelog:

1.1.0 (2016-XX-XX)

! PHP with version >= 5.5.0 required; If PHP version is to old, the Ranksystem will stops directly after startup and log this into ranksystem.log!
+ reworked webinterface; its now in bootstrap look like the stats site. To open the webinterface use subfolder "webinterface/" instead of "webinterface.php"
+ added brute force protection to the webinterface
+ encrypt the password for the webinterface inside the database
+ added function ingore idletime; idle time of an user will be ignored (counted as active time), if it is under a predefined value
+ added possibility to except channel

TS3BOT · Jun 5, 2016

What is the solution ? http://prntscr.com/bcna9m

Alligatoras · Jun 5, 2016

TS3BOT said:
What is the solution ? http://prntscr.com/bcna9m

That means you Rank System bot is not connected to your teamspeak 3 server!
Simmply go on your SSH Client and login as root on your VPS
Go to you path file that you have installed the rank system and type this command: php worker.php check <= it will check if bot is running or not. if not it will start!
else you can type this: php worker.php start <= this will start it anyways!

Also i would suggest you to add it on the cronjob by doing that:
1) on your SSH Client open the crontab: sudo crontab -e <= this will open and give you edit access
2) at the end put this line: */10 * * * * sudo -u www-data php /path/to/your/file/worker.php check$ <= it will check every 10 minutes if it works. if not will start it again!

By the way, you are not connected to teamspeak either!
If you are but your current internet connection is public or school / univeristy network it won't find you! as it is restricted from these providers

Wrath X · Jun 9, 2016

I guess I found a problem in Ranksystem. My CPU percentage was %99 after 1 week started the Ranksystem. PHP was using %98 of my server CPU.

My crontab rule was:

Code:

*/10 * * * * sudo -u www-data php /path/to/your/ranksystem/worker.php check >/dev/null 2>&1

I changed the crontab rule to:

Code:

*/10 * * * * sudo -u www-data php /path/to/your/ranksystem/worker.php restart >/dev/null 2>&1

Now, it works like a charm.

Alligatoras · Jun 13, 2016

THREAD HAS BEEN UPDATED TO NEWER VERSION
Version 1.0.2 ==> Click Here

0x0539 · Jun 13, 2016

Alligatoras said:
THREAD HAS BEEN UPDATED TO NEWER VERSION
Version 1.0.2 ==> Click Here

This thread is no longer supported, if you have any questions click the link above.

/Closed

TeamSpeak 3 - Rank/Level up system - v1.0.0

Do you think this script should continuously be updated?

Yes!

No.

Ramadi

Member

Wrath X

Member

Alligatoras

Wrath X

Member

Alligatoras

Ramadi

Member

Alligatoras

Ramadi

Member

Alligatoras

0x0539

Alligatoras

TS3BOT

Member

Alligatoras

Wrath X

Member

Alligatoras

0x0539