Raised This Month: $ Target: $400
 0% 

amx_mode 2 and admin_sql.amxx SOLVED


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Furious-PY
Junior Member
Join Date: May 2006
Old 05-09-2006 , 15:50   amx_mode 2 and admin_sql.amxx SOLVED
Reply With Quote #1

MySql 4x
MetaMod 1.19
AMX 1.71


Problem: only admins can join to the server access: "abcefij" flag: "a"
users with access: "z" flag: "a" cant join to the server
Msg: "You have no entry to the server..."
amx_mode 2

if i choose amx_mode 1 it works but users without registering can enter into my server and i whant only users in mysql server can join

I recently find this error in the console:
L 05/09/2006 - 188:45: [AMXX] Displaying debug trace (plugin "admin_sql.amxx")
L 05/09/2006 - 188:45: [AMXX] Run time error 4: index out of bounds
L 05/09/2006 - 188:45: [AMXX] [0] admin.sma::adminSql (line 454)

maybe wrongs characters or nicks, passwords too longs ???

file sql.cfg proper configured and working

plugins.ini
Code:
;admin.amxx		; admin base (required for any admin-related)
admin_sql.amxx		; admin base - SQL version (comment admin.amxx)
amxx.cfg
Code:
// AMX Configuration File
echo Executing AMX Mod X Configuration File

// Default access for all non admin players (see users.ini for access details)
amx_default_access "z"

// Name of setinfo which should store a password on a client (you should change this)
// (Example: setinfo _pw "password")
amx_password_field "_pw-home"

// Mode of logging to a server
// 0 - disable logging, players won't be checked (and access won't be set)
// 1 - normal mode which obey flags set in accounts
// 2 - kick all players not on list
amx_mode 2

// Show admins activity
// 0 - disabled
// 1 - show without admin name
// 2 - show with name
amx_show_activity 2

// Amount of reserved slots, amx_hideslots must be 1 to use this cvar (for more details see comments in plugin source)
amx_reservation 0

// If you set this to 1, you can hide slots on your server
amx_hideslots 0

// Announce "say thetime" and "say timeleft" with voice
amx_time_voice 0

// Minimum delay in seconds between two voting sessions
amx_vote_delay 10

// How long voting session goes on
amx_vote_time 10

// Display who votes for what option
amx_vote_answers 1

// Some ratios for voting success
amx_votekick_ratio 0.40
amx_voteban_ratio 0.40
amx_votemap_ratio 0.40
amx_vote_ratio 0.02

// Max. time to which map can be extended
amx_extendmap_max 25

// Step for each extending
amx_extendmap_step 15

// Rank mode
// 0 - by nick
// 1 - by authid 
// 2 - by ip
csstats_rank 0

// Max size of the stats file
csstats_maxsize 3500

// Duration of HUD-statistics
amx_statsx_duration 12.0

// HUD-statistics display limit relative round freeze end
// Negative time will clear the HUD-statstics before the round freeze time has ended
amx_statsx_freeze -2.0

//If you set this to 0, clients cannot chose their language
amx_client_languages 1

// Plugin Debug mode
// 0 - No debugging (garbage line numbers)
// 1 - Plugins with "debug" option in plugins.ini are put into debug mode
// 2 - All plugins are put in debug mode
// Note - debug mode will affect JIT performance
amx_debug 0

// Plugin MultiLingual Debug
// To debug a language put its 2 letter code between quotes ("en", "de", etc)
// "" means disabled
amx_mldebug ""
Some help... i already search in the forum and cant found nothing usefull
Furious-PY is offline
lasof
New Member
Join Date: May 2006
Old 05-09-2006 , 16:48  
Reply With Quote #2

hi i have the same problem users with access: "z" flag: "a" cant join to the server please some one can help us?
lasof is offline
Furious-PY
Junior Member
Join Date: May 2006
Old 05-09-2006 , 17:31  
Reply With Quote #3

I already try access "bz" isnt work
Furious-PY is offline
c0rdawg
Senior Member
Join Date: Jan 2006
Old 05-09-2006 , 18:00  
Reply With Quote #4

flag z means not an admin so you can't use the other flags with it
c0rdawg is offline
Send a message via AIM to c0rdawg Send a message via MSN to c0rdawg
Furious-PY
Junior Member
Join Date: May 2006
Old 05-09-2006 , 18:39  
Reply With Quote #5

ah ok... and then what i do now ?? i understand that the "z" access must work and authorize the users to enter into the server because they "are into the list" isnt ??? then... whi isnt work ?? what im doing wrong here ???

Ohhh fuck..... (not good idea core login=0 and debug mode=0)

L 05/09/2006 - 188:45: [AMXX] Displaying debug trace (plugin "admin_sql.amxx")
L 05/09/2006 - 188:45: [AMXX] Run time error 4: index out of bounds
L 05/09/2006 - 188:45: [AMXX] [0] admin.sma::adminSql (line 454)


I think when the mysql conecction fails the amxx use the users.ini file and there i have the admins accounts maybe because that only the admins can join... then thing now is.. whats wrong in registrys in the admin table...

Line 454: dbi_result(Res, "auth", g_aName[g_aNum], 31)
Ok maybe are wrong characters or to long passwords or nicksnames ??
Some one.... help

What are the size permited in the nicks and passwords ?? and what are the valid characters ?? where i can find this info ?
Furious-PY is offline
Furious-PY
Junior Member
Join Date: May 2006
Old 05-09-2006 , 19:12  
Reply With Quote #6

Hey guys im only a .net programator but.... in the admin.sma i found this
#define MAX_ADMINS 64

and:
SELECT count( * ) FROM `admins`
count(*) = 171

Is that my problem ?
Furious-PY is offline
Furious-PY
Junior Member
Join Date: May 2006
Old 05-09-2006 , 19:28  
Reply With Quote #7

Isnt work... i changed it to: #define MAX_ADMINS 3000

I compiled it in the web compiler of the amxmodx web and changed the admin.amxx with this one and... same stupid error

The error seems to be in the admin_sql.amxx but i dont have the admin_sql.sma
Furious-PY is offline
Furious-PY
Junior Member
Join Date: May 2006
Old 05-09-2006 , 19:39  
Reply With Quote #8

PROBLEM SOLVED

From:
http://forums.alliedmods.net/showthread.php?t=25311+sma

Compiled and working:
[AMXX] Loaded 171 admins from database

If some one else have the same problem this two files are for 3000 users
Attached Files
File Type: amx admin_sql.amx (54.4 KB, 457 views)
File Type: amx admin.amx (49.4 KB, 373 views)
Furious-PY is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:28.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode