Dear visitor, welcome to sourceserver.info. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.
This post has been edited 2 times, last edit by "Alchemisten" (Oct 31st 2014, 9:37am)
Source code |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
"Databases" { "driver_default" "mysql" // When specifying "host", you may use an IP address, a hostname, or a socket file path "sourcebans" { "driver" "mysql" "host" "deine Server IP" "database" "Datenbank Name" "user" "Datenbank Username" "pass" "Datenbank Passwort" //"timeout" "0" "port" "3306" } "storage-local" { "driver" "sqlite" "database" "sourcemod-local" } "clientprefs" { "driver" "sqlite" "host" "localhost" "database" "clientprefs-sqlite" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } } |
This post has been edited 1 times, last edit by "Apollo" (Nov 3rd 2014, 10:47pm)
PHP Source code |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
go into sourcebans.sp and find:
Format(sQuery, sizeof(sQuery), "SELECT id \
FROM {{servers}} \
WHERE ip = '%s' \
AND port = %i",
g_sServerIp, g_iServerPort);
SB_Query(Query_ServerSelect, sQuery);
and change ip to host so it looks like this:
Format(sQuery, sizeof(sQuery), "SELECT id \
FROM {{servers}} \
WHERE host = '%s' \
AND port = %i",
g_sServerIp, g_iServerPort);
SB_Query(Query_ServerSelect, sQuery);
|
Und der Grund ist: [sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'where clause')Quoted
plugin.sp(14) : fatal error 160: cannot read from file: "sourcebans" Compilation aborted. 1 Error.
Hallo dieser befehl geht leider nicht?Hallo,
Führe das mal in putty aus danach sollten die banns auch auf deiner sourcebans seite angezeigt werden!
Source code
1 load ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
LG Neoxx
Super Moderator
Location: Lutherstadt Wittenberg
Occupation: Anlagenmechaniker
wcf.user.option.userOption53: Ja
Super Moderator
Location: Lutherstadt Wittenberg
Occupation: Anlagenmechaniker
wcf.user.option.userOption53: Ja
Source code |
|
1 |
sm plugins list |