[Nightbox]

gj on releasing it

[Xsinthis]

Originally Posted by snelvuur Might also be nice to have the option to not create points at all. Instead give out points as a admin, through a menu. So for instance you have a donating person, give him 5000 points or something like that and he can choose his own "rewards" that way the plugin could serve a second goal too. Besides that, good work!

This can be done with the new version now. The easiest way would be to use the sm_loyal_modify <NAME> <CHANGE> command ingame, but requires the person be ingame at the time. A better way would be to go in through the MySQL database and add bonus points there using a php script or manual queries.

[badwolf]

What happens when you set sm_loyal_time to 0? Can that factor of the equation be disabled if you do set it to 0? If not, can you add that as a feature please.

[Xsinthis]

depends on how sourcepawns handles division by zero. I'll add an option to disable certain point features in the future. For now i suggest setting it to a really hight value instead

[joeri86]

Hiya,

I like this script very much.
Is there any possibility to implement a nextmap buying feature?

Thanks in advance,
Joeri

[ratonofx]

Line 160:
Format(query, sizeof(query), "DELETE FROM sm_admins WHERE adminuntil<%i AND imunity > 0", GetTime());

Should be:

Format(query, sizeof(query), "DELETE FROM sm_admins WHERE adminuntil<%i AND immunity > 0", GetTime());

[Xsinthis]

Bug Fix Release 2.1.1
- Fixed typo in a SQL query (thanks ratonofx)

[ratonofx]

I'm experiencing a possible bug or a missmatch configuration. I'm adding admins but they are erased after restart server or change map, seems i'm being removed from admin table and get into loyal table, to back later when got required points. It seems the normal behavior, for a player. But i'm already registered as admin.

Could you help me please?

EDIT1:

I think i found the problem, i just don't know if this fix the problem definitely...


Format(query, sizeof(query), "DELETE FROM sm_admins WHERE adminuntil<%i AND immunity > 0", GetTime());

Should be:

Format(query, sizeof(query), "DELETE FROM sm_admins WHERE adminuntil<%i AND immunity < 2", GetTime());

Assuming that all admins or users that shouldn't be affected by the loyalty system have immunity greater than 1.

After change that, admins aren't being removed anymore, no side effect experienced for while.

Thanks.

[Xsinthis]

Sorry i guess i should have been more clear about that. With 2.1.1 i fixed the query that was causing a problem, its supposed to be

Format(query, sizeof(query), "DELETE FROM sm_admins WHERE adminuntil<%i AND immunity = 0", GetTime());

I before had a >

So the immunity level for loyalty members should be 0

[ratonofx]

[loyal.smx] Query failed(SQLErrorCheckCallback): Table'sourcebans.sm_admins' doesn't exist

I'm getting this error after install the sourcebans, i will paste my databases.cfg:

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "xxx.xxx.xxx.xxx"
"database" "sourcemod"
"user" "user"
"pass" "pass"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "default"
"host" "xxx.xxx.xxx.xxx"
"database" "sourcemod"
"user" "user"
"pass" "pass"
//"timeout" "0"
"port" "3306"
}
"loyal"
{
"driver" "mysql"
"host" "xxx.xxx.xxx.xxx"
"database" "sourcemod"
"user" "user"
"pass" "pass"
//"timeout" "0"
"port" "3306"
}
"sourcebans"
{
"driver" "mysql"
"host" "xxx.xxx.xxx.xxx"
"database" "sourcebans"
"user" "user"
"pass" "pass"
//"timeout" "0"
"port" "3306"
}
}

Due to the lack of info, i dont know if i need merge the databases to use this plugin? (sourcemod and sourcebans).

I appreciate your help. Thank you.