[m0skVi4a]

What error occurs when starting the server with SQL mode of the Register System?

[cybertank378]

Originally Posted by m0skVi4a What error occurs when starting the server with SQL mode of the Register System?

Here is this

PHP Code:

                                                                   20)
===============================================================================
Title   : Register System
Version : 7.0 FIX 2
Author  : m0skVi4a ;]
Site    : https://forums.alliedmods.net/showthread.php?t=171460
-------------------------------------------------------------------------------
[18:16:08] > Loading settings from registersystem.cfg
[18:16:08] [OK] > Read cvar "rs_on" "1"
[18:16:08] [OK] > Read cvar "rs_save_type" "1"
[18:16:08] [OK] > Read cvar "rs_host" "0.0.0.0"
[18:16:08] [OK] > Read cvar "rs_user" "root"
[18:16:08] [OK] > Read cvar "rs_pass" "masabodo"
[18:16:08] [OK] > Read cvar "rs_db" "registersystem"
[18:16:08] [OK] > Read cvar "rs_password_prefix" "_rspass"
[18:16:08] [OK] > Read cvar "rs_register_time" "0"
[18:16:08] [OK] > Read cvar "rs_login_time" "60.0"
[18:16:08] [OK] > Read cvar "rs_password_len" "6"
[18:16:08] [OK] > Read cvar "rs_attempts" "3"
[18:16:08] [OK] > Read cvar "rs_chngpass_times" "3"
[18:16:08] [OK] > Read cvar "rs_register_log" "1"
[18:16:08] [OK] > Read cvar "rs_chngpass_log" "1"
[18:16:08] [OK] > Read cvar "rs_autologin_log" "0"
[18:16:08] [OK] > Read cvar "rs_password_prefix" "_rspass"
[18:16:08] [OK] > Read cvar "rs_blind" "1"
[18:16:08] [OK] > Read cvar "rs_commands" "1"
[18:16:08] [OK] > Read cvar "rs_logout" "1"
[18:16:08] [OK] > Read cvar "rs_count" "1"
[18:16:08] [OK] > Read cvar "rs_advert" "1"
[18:16:08] [OK] > Read cvar "rs_advert_int" "60"
[18:16:08] [OK] > Read cvar "rs_ajc_team" "0"
[18:16:08] [OK] > Read cvar "rs_ajc_class_t" "5"
[18:16:08] [OK] > Read cvar "rs_ajc_class_ct" "5"
[18:16:08] [OK] > Read cvar "rs_ajc_admin" "1"
[18:16:08] [OK] > Read cvar "rs_ajc_change" "0"
[18:16:08] [OK] > Read cvar "rs_remember_punish_by" "0"
[18:16:08] [OK] > Read cvar "rs_cant_login_time" "300"
[18:16:08] [OK] > Read cvar "rs_cant_change_pass_time" "300"
[18:16:08] > Loading settings from registersystem_commands.ini
[18:16:08] [OK] > 2 commands loaded!
-------------------------------------------------------------------------------
[18:16:08] [OK] > All settings loaded successfully!
===============================================================================

Executing AMX Mod X Configuration File
Scrolling message displaying frequency: 10:00 minutes
[AMXX] No admins found.
Executing Aimbot Detection Configuration File
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit
Master server communication disabled.

Server logging data to file logs/L0225002.log
L 02/25/2013 - 18:16:09: Log file started (file "logs/L0225002.log") (game "cstrike") (version "48/1.1.2.6/Stdio/5787")
Menu item 17 added to Menus Front-End: "Plugin Cvars" from plugin "pluginmenu.amxx"
Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"
Connection to Steam servers successful.
   VAC secure mode is activated.
L 02/25/2013 - 18:16:16: [DPROTO]: Client 0 - Set AuthIdType 1 [dp_RevEmu]; pClient = 0xf3a0ef08
L 02/25/2013 - 18:16:16: "[NOT_logged]cybertank378<1><STEAM_1:0:1533648808><>" connected, address "192.168.88.88:27005"
L 02/25/2013 - 18:16:16: World triggered "Round_Start"
L 02/25/2013 - 18:16:16: [MySQL] Invalid info tuple handle: 0
L 02/25/2013 - 18:16:16: [AMXX] Displaying debug trace (plugin "RegisterSystem.amxx")
L 02/25/2013 - 18:16:16: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 02/25/2013 - 18:16:16: [AMXX]    [0] text8Uwqtz.sma::CheckClient (line 775)
L 02/25/2013 - 18:16:16: [AMXX]    [1] text8Uwqtz.sma::client_authorized (line 720)
L 02/25/2013 - 18:16:20: "[NOT_logged]cybertank378<1><STEAM_1:0:1533648808><>" entered the game
L 02/25/2013 - 18:16:24: "[NOT_logged]cybertank378<1><STEAM_1:0:1533648808><>" joined team "TERRORIST"
L 02/25/2013 - 18:16:25: "[NOT_logged]cybertank378<1><STEAM_1:0:1533648808><TERRORIST>" triggered "Spawned_With_The_Bomb"
[NOT_logged]cybertank378 : /reg
L 02/25/2013 - 18:16:32: "[NOT_logged]cybertank378<1><STEAM_1:0:1533648808><TERRORIST>" say "/reg"
L 02/25/2013 - 18:16:39: [MySQL] Invalid info tuple handle: 0
L 02/25/2013 - 18:16:39: [AMXX] Displaying debug trace (plugin "RegisterSystem.amxx")
L 02/25/2013 - 18:16:39: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 02/25/2013 - 18:16:39: [AMXX]    [0] text8Uwqtz.sma::HandlerConfirmPasswordMenu (line 1619) 


[m0skVi4a]

I can say two things.
First you are not using the original Register System V7.0 FIX 2 by m0skVi4a ;]
Line 775 in the original code is

PHP Code:

attempts[id] = 0 


Please make sure you are using FIX 2.

Second Are you hiding your rs_host CVAR, because 0.0.0.0 is not valid local IP.

After FIX 2 there are no problems on my servers or Alliedmodders users which are using the SQL version

[cybertank378]

Originally Posted by m0skVi4a I can say two things. First you are not using the original Register System V7.0 FIX 2 by m0skVi4a ;] Line 775 in the original code is PHP Code: attempts[id] = 0  Please make sure you are using FIX 2. Second Are you hiding your rs_host CVAR, because 0.0.0.0 is not valid local IP. After FIX 2 there are no problems on my servers or Alliedmodders users which are using the SQL version

first i use .amxx on the download but had some trouble except the i use file mode not mysql

then i try to FIX 2. compile with the amx compiler on my linux server then i put the .amxx into plugins folder

same problem come

i try on the http://www.amxmodx.org/webcompiler.cgi same problem comes

then i try to trace the problem and make it more mess so i leave couse i dont know what are ur logic on that script

then what are must i do to use ur script couse ur plugins is most the best i found for registration but some bug thats the problem

for ip 0.0.0.0 i use that couse im use port forward on my router so the server can be accessed from outside

you can try @122.144.5.218:27015
that is forwarded from 192.168.88.31

[m0skVi4a]

I don't know which version you are using, because you give me error on lines which on the original code are not the same. Please make sure you use the latest update. I don't think that there is a problem in the system.

(Are you using AMXX 1.8.2 ?)

[YamiKaitou]

Originally Posted by m0skVi4a I don't know which version you are using, because you give me error on lines which on the original code are not the same. Please make sure you use the latest update. I don't think that there is a problem in the system. (Are you using AMXX 1.8.2 ?)

FYI, user was banned for No-Steam

[12114]

moski4a, i just tested this on amxx 1.8.1, same result. when i type /reg, nothing happens.

is it my cvars or?

// Start of Register System config


//Is the plugin on(1) or off(0).
//Default: 1
rs_on "1"

//Where to seve the information: to file(0) or to MySQL(1).
//Default: 0
rs_save_type "0"


////////MySQL////////
//If you set rs_save_type to 0 IT IS NOT necessary to edit this CVAR's

//The host for the database.
//Default: 127.0.0.1
rs_host "127.0.0.1"

//The username for the database login.
//Default: root
rs_user "root"

//The password for the database login.
//Default:
rs_pass "123456"

//The database name.
//Default: registersystem
rs_db	 "registersystem"

////////MySQL////////


//The prefix of the setinfo for the Auto Login function.
//Default: _rspass
rs_password_prefix "_rspass"

//How much time has the client to register. If is set to 0 registration is not mandatory.
//Default: 0
rs_register_time "0"

//How much time has the client to login if is registered.
//Default: 60.0
rs_login_time "100.0"

//What is minimum length of the password.   
//Default: 6
rs_password_len "4"

//How much attempts has the client to login if he type wrong password.
//Default: 3
rs_attempts "4"

//How much times can the client change his password per map.
//Default: 3
rs_chngpass_times "2"

//Is it allowed the plugin to log in file when the client is registered.
//Default: 1

rs_register_log "1"

//Is it allowed the plugin to log in file when the client has change his password.
//Default: 1

rs_chngpass_log "1"

//Is it allowed the plugin to log in file when the client has change his Auto Login.
//Default: 1

rs_autologin_log "1"

//The prefix of the setinfo for the auto login.
//Default: _rspass
rs_password_prefix "_rspass"

//Whether clients who have not Logged or who must Register be blinded.
//Default: 1
rs_blind "0"

//Whether clients who have not Logged or who must Register commands' be blocked.
//Default: 1
rs_commands "0"

//What to do when client Logout - kick him from the server(0) or wait to Login during the Login time(1).
//Default: 0
rs_logout "1"

//Is the countig when you have to register or you have to login on(1) or off(0).
//Default: 1
rs_count "1"

//Is the advertisement for not registered players on(1) or off(0).
//Default: 1
rs_advert "1"

//What is the interval between two advertisements in seconds.   
//Default: 60
rs_advert_int "120"

//Is the Auto Join On Connect option on(1, 2, 5, 6) or off(0). 1 is Terrorists, 2 is Counter-Terrorsits, 6 Spectators, 5 Auto Assign.
//Default: 0
rs_ajc_team "1"	

//Which class the Terrorists will be (AJC must be on) - 1 is Terror, 2 is Leet, 3 is Artic, 4 is Guerilla, 5 is Auto Sellect, if it is set to 0 playes can choose which class they wiil be.
//Default: 5
rs_ajc_class_t "5"

//Which class the Counter-Terrorists will be (AJC must be on) - 1 is Urban, 2 is GSG-9, 3 is SAS, 4 is GIGN, 5 is Auto Sellect, if it is set to 0 playes can choose which class they wiil be.
//Default: 5
rs_ajc_class_ct "5"

//Is it allowed players with defined flag (Default: ADMIN_IMMUNITY) can choose in which team will they be (AJC must be on).
//Default: 1
rs_ajc_admin "1"

//Is it allowed players to change their team(0) or not(1).
//Default: 0
rs_ajc_change "1"

//How to remember the punished players: by Nmae(0), by IP(1) or by SteamID(2).
//Default: 0
rs_remember_punish_by "0"

//How much time in seconds players can't login after typing wrong passwrods.
//Default: 300
rs_cant_login_time "150"

//How much time in seconds players can't change their paswords after changing it before that.
//Default: 300
rs_cant_change_pass_time "300"


// End of Register System config

[m0skVi4a]

Originally Posted by 12114 moski4a, i just tested this on amxx 1.8.1, same result. when i type /reg, nothing happens. is it my cvars or? // Start of Register System config //Is the plugin on(1) or off(0). //Default: 1 rs_on "1" //Where to seve the information: to file(0) or to MySQL(1). //Default: 0 rs_save_type "0" ////////MySQL//////// //If you set rs_save_type to 0 IT IS NOT necessary to edit this CVAR's //The host for the database. //Default: 127.0.0.1 rs_host "127.0.0.1" //The username for the database login. //Default: root rs_user "root" //The password for the database login. //Default: rs_pass "123456" //The database name. //Default: registersystem rs_db "registersystem" ////////MySQL//////// //The prefix of the setinfo for the Auto Login function. //Default: _rspass rs_password_prefix "_rspass" //How much time has the client to register. If is set to 0 registration is not mandatory. //Default: 0 rs_register_time "0" //How much time has the client to login if is registered. //Default: 60.0 rs_login_time "100.0" //What is minimum length of the password. //Default: 6 rs_password_len "4" //How much attempts has the client to login if he type wrong password. //Default: 3 rs_attempts "4" //How much times can the client change his password per map. //Default: 3 rs_chngpass_times "2" //Is it allowed the plugin to log in file when the client is registered. //Default: 1 rs_register_log "1" //Is it allowed the plugin to log in file when the client has change his password. //Default: 1 rs_chngpass_log "1" //Is it allowed the plugin to log in file when the client has change his Auto Login. //Default: 1 rs_autologin_log "1" //The prefix of the setinfo for the auto login. //Default: _rspass rs_password_prefix "_rspass" //Whether clients who have not Logged or who must Register be blinded. //Default: 1 rs_blind "0" //Whether clients who have not Logged or who must Register commands' be blocked. //Default: 1 rs_commands "0" //What to do when client Logout - kick him from the server(0) or wait to Login during the Login time(1). //Default: 0 rs_logout "1" //Is the countig when you have to register or you have to login on(1) or off(0). //Default: 1 rs_count "1" //Is the advertisement for not registered players on(1) or off(0). //Default: 1 rs_advert "1" //What is the interval between two advertisements in seconds. //Default: 60 rs_advert_int "120" //Is the Auto Join On Connect option on(1, 2, 5, 6) or off(0). 1 is Terrorists, 2 is Counter-Terrorsits, 6 Spectators, 5 Auto Assign. //Default: 0 rs_ajc_team "1" //Which class the Terrorists will be (AJC must be on) - 1 is Terror, 2 is Leet, 3 is Artic, 4 is Guerilla, 5 is Auto Sellect, if it is set to 0 playes can choose which class they wiil be. //Default: 5 rs_ajc_class_t "5" //Which class the Counter-Terrorists will be (AJC must be on) - 1 is Urban, 2 is GSG-9, 3 is SAS, 4 is GIGN, 5 is Auto Sellect, if it is set to 0 playes can choose which class they wiil be. //Default: 5 rs_ajc_class_ct "5" //Is it allowed players with defined flag (Default: ADMIN_IMMUNITY) can choose in which team will they be (AJC must be on). //Default: 1 rs_ajc_admin "1" //Is it allowed players to change their team(0) or not(1). //Default: 0 rs_ajc_change "1" //How to remember the punished players: by Nmae(0), by IP(1) or by SteamID(2). //Default: 0 rs_remember_punish_by "0" //How much time in seconds players can't login after typing wrong passwrods. //Default: 300 rs_cant_login_time "150" //How much time in seconds players can't change their paswords after changing it before that. //Default: 300 rs_cant_change_pass_time "300" // End of Register System config

Thank you for Bug report. I have not noticed this bug because
//Whether clients who have not Logged or who must Register commands' be blocked.
//Default: 1
rs_commands "0"
is setted to 1 on my servers, because i am bloking commands if you are not logged.
Please set this CVAR to 1 and empty your registersystem_commands.ini file.
In V8.0 this bug will be fixed.

[12114]

yeah, it's been working fine ever since u said that, thx.

more concerns:
a) it would be nice to have a "amx_registered" command (just for admins) to see which players are actually registered.
b) valve is coming up with an update and it's going to break setinfo (i think), how is this going to affect auto login?
c) i can correct a little bit of the english in your plugin, if you want

[Rusu2009]

Sorry if this may have been said (don't have time to read 30+ pages ) but, i would like an option that let you delete your registration..