Raised This Month: $51 Target: $400
 12% 

Showing results 1 to 17 of 17
Search took 0.01 seconds. Search: Posts Made By: NovaDenizen
Forum: Unapproved Plugins 11-14-2010, 21:57
Replies: 0
Views: 1,656
Posted By NovaDenizen
Autoquit

Description:
We've been having problems with memory leaks in servers, so I created this plugin that automatically forces a server quit at an appropriate time. By default, the plugin will force a...
Forum: Plugins 07-18-2010, 22:00
Replies: 153
Views: 80,033
Posted By NovaDenizen
Re: [ANY] MechaWare: Custom Achievements 2.0! (0.4)

Lots of places you have string split arrays declared like this:
new String:split[50][128];This allocates the stack space for the string array, then initializes all of the string buffers to zero...
Forum: Plugins 07-18-2010, 21:52
Replies: 153
Views: 80,033
Posted By NovaDenizen
Re: [ANY] MechaWare: Custom Achievements 2.0! (0.4)

Format(strQuery, sizeof(strQuery), "SELECT * FROM `mw_achievements_post_ach` WHERE steamid = '%s'", strSteamId);This query is in GetClientDBInfo, and runs every time a client connects. The...
Forum: Unapproved Plugins 03-27-2010, 11:45
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

L 03/26/2010 - 23:16:10: [SM] Native "GetClientAuthString" reported: Client 4 is not connected
L 03/26/2010 - 23:16:10: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L...
Forum: Unapproved Plugins 03-27-2010, 11:19
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

L 03/26/2010 - 22:53:40: [SM] Native "IsClientConnected" reported: Client index 0 is invalid
L 03/26/2010 - 22:53:40: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L...
Forum: Unapproved Plugins 03-27-2010, 11:01
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

public Action:blocks_sniper_jarate(UserMsg:msg_id, Handle:bf, const players[], playersNum, bool:reliable, bool:init)
{
- CreateTimer(0.1, DelaySniperExpire, bf);
+ new strClient =...
Forum: Unapproved Plugins 03-24-2010, 03:17
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

L 03/23/2010 - 11:12:36: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/23/2010 - 11:12:36: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L...
Forum: Unapproved Plugins 03-24-2010, 03:03
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

This error:

L 03/22/2010 - 14:00:19: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 2
L 03/22/2010 - 14:00:19: [SM] Displaying call stack trace for plugin...
Forum: Unapproved Plugins 03-24-2010, 02:45
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

For this error:

L 03/22/2010 - 15:43:40: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 15:43:40: [SM] Displaying call stack trace for plugin...
Forum: Unapproved Plugins 03-15-2010, 01:52
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

You should probably be using the FindStringInArray and FindValueInArray functions. They are almost certainly faster than your equivalent code.

For instance, in VerifyIfCompleteAch_AfterQuery:

...
Forum: Unapproved Plugins 03-15-2010, 00:25
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

You're quite welcome.

Somebody in my group asked me to review the code, and I told them I found problems. Then they asked me if I could rewrite it. I thought for about half a second and told him...
Forum: Unapproved Plugins 03-15-2010, 00:14
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

Before it awards the achievement, the plugin has to do several SQL queries, some of which are rather excessive as I described earlier (see RC_Users() and RC_Users_Ach()). This would adequately...
Forum: Unapproved Plugins 03-14-2010, 18:54
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

In AddToAchievement, two global variables are set:

g_FOCUSCLIENT = argFocusclient;
g_FOCUSACHID = argId;
.....
SQL_TQuery(g_HDATABASE, AfterAdd, strQuery, 0,...
Forum: Unapproved Plugins 03-14-2010, 18:33
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

AchievementCheckCompletion() is called, I think, just as often as UpdateBlockStatus() is called.

AchievementCheckCompletion() iterates over all defined achievements. For each of these...
Forum: Unapproved Plugins 03-14-2010, 18:15
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

UpdateBlockStatus is called pretty much any time a user does anything. It performs an INSERT/UPDATE query with SQL_TQuery, with arg 1 and callback EmptyCallback().

When control eventually reaches...
Forum: Unapproved Plugins 03-14-2010, 17:56
Replies: 673
Views: 165,143
Posted By NovaDenizen
Re: [TF2] Custom Achievement Manager With MYSQL

I found a bug in spy.inc


g_BLOCKS_SAPPED = SQL_GetRowCount(strHQuery);
ClearAndResize(g_LIST_BLOCKS_SAPPED_ID,g_BLOCKS_RAZORBACK+1);...
Forum: Plugins 02-03-2010, 22:23
Replies: 111
Views: 42,193
Posted By NovaDenizen
Re: MySQL Polls

I'm not the most experienced sourcemod programmer, so please take these criticisms with a grain of salt.

All of the queries are non-threaded. Normally a few SQL queries that take 10ms each to...
Showing results 1 to 17 of 17

 
Forum Jump

All times are GMT -4. The time now is 06:26.

DMCA - Archive - Top

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