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 |