Raised This Month: $ Target: $400
 0% 

[v2.5.2, March 19] Trouble in Terrorist Town mod


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
erkike93
Member
Join Date: Aug 2013
Old 03-10-2015 , 14:21   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #1

This is the whole code of public MySQL_TOP10Load (this is all the lines around 259)

PHP Code:
public MySQL_TOP10Load(failstateHandle:queryerror[], errcodedata[], datasize)
{
    if(
failstate == TQUERY_CONNECT_FAILED)
        
log_amx("[TTT] Load - Could not connect to SQL database.  [%d] %s"errcodeerror);
    else if(
failstate == TQUERY_QUERY_FAILED)
        
log_amx("[TTT] Load query failed. [%d] %s"errcodeerror);

    if(
SQL_NumResults(query) > 0
    {
        for(new 
num[3], j010i++)
        {
            static 
name[32];
            
SQL_ReadResult(query1namecharsmax(name));
            
#if AMXX_VERSION_NUM >= 183
            
TrieSetString(g_tTop10Players[i], "1"nametrue);
            
#else
            
TrieSetString(g_tTop10Players[i], "1"name);
            
#endif
            
            
for(214j++)
            {
                
num_to_str(jnumcharsmax(num));
                
#if AMXX_VERSION_NUM >= 183
                
TrieSetCell(g_tTop10Players[i], numSQL_ReadResult(queryj), true);
                
#else
                
TrieSetCell(g_tTop10Players[i], numSQL_ReadResult(queryj));
                
#endif
            
}
            
SQL_NextRow(query);
        }
    }
    
SQL_FreeHandle(query);

    return 
PLUGIN_HANDLED;

And the line 259 in my .sma is exactly this:

PHP Code:
SQL_ReadResult(query1namecharsmax(name)); 
Let me know if that is enough info or if u need anymore to be posted, to check that log, this happen when i startup my server or when come the change map.

P.S: Btw i'm using sqlite (ttt_stats 2) i haven't SQL Data Base or something like that, so i dont know if that is the reason because of that appears.

Last edited by erkike93; 03-10-2015 at 14:24.
erkike93 is offline
GuskiS
Veteran Member
Join Date: Aug 2007
Location: Latvia
Old 03-10-2015 , 14:48   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #2

Hehe thanks That error showed up because your DB file was empty or less than 10 entries long I had it already fixed for myself few days back. Thanks for report anyways Wait for next update.
Also, Sqlite means that server will create local database file to store all stats, so you can use plugin fully. MySQL type requires you to have web-based database, that would help you if you wish to show stats in your website
__________________
Finished mods:
Trouble in Terrorist Town
MurderMod
The Hidden
Cowboys vs Indians
JailBreak Supreme
Survival Madness
GuskiS is offline
erkike93
Member
Join Date: Aug 2013
Old 03-10-2015 , 16:33   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #3

Oks bro, thanks for explain it, and sure i'll be waiting for next release and the fake detective of course

Btw, i was thinking about to add a countdown for the start of each round, i mean something like the countdown from zp, It's just an idea, but I think would be more personalized the mod with some little stuffs like that...

Last edited by erkike93; 03-10-2015 at 16:43.
erkike93 is offline
GuskiS
Veteran Member
Join Date: Aug 2007
Location: Latvia
Old 03-10-2015 , 16:44   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #4

You mean countdown till game actually starts? If so, then that little clock on bottom of screen counts time
__________________
Finished mods:
Trouble in Terrorist Town
MurderMod
The Hidden
Cowboys vs Indians
JailBreak Supreme
Survival Madness
GuskiS is offline
erkike93
Member
Join Date: Aug 2013
Old 03-11-2015 , 05:28   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #5

Yup i mean a countdown in a hud at the top with some voice sound counting the seconds since 10 till the round start
erkike93 is offline
GuskiS
Veteran Member
Join Date: Aug 2007
Location: Latvia
Old 03-11-2015 , 12:28   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #6

I don't think that it is needed, sorry. That little countdown in mid-bottom of screen is just fine.
__________________
Finished mods:
Trouble in Terrorist Town
MurderMod
The Hidden
Cowboys vs Indians
JailBreak Supreme
Survival Madness
GuskiS is offline
asur
Member
Join Date: Dec 2014
Old 03-11-2015 , 13:52   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #7

please bro make ur next update fully compatible for amxmodx 1.8.2 as i already mentioned the colorchat prob
asur is offline
GuskiS
Veteran Member
Join Date: Aug 2007
Location: Latvia
Old 03-11-2015 , 14:03   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #8

Quote:
Originally Posted by asur View Post
please bro make ur next update fully compatible for amxmodx 1.8.2 as i already mentioned the colorchat prob
I already answered that ColorChat will be back I have already got it working.
As for fully 1.8.2 compatible version - not gonna happen. I am using 1.8.3 and I'm testing on it. It works way better for me than 1.8.2. But the difference between 1.8.2 and 1.8.3 version TTT is only in some functions(I'm talking in code basis), if something isn't working in 1.8.2 then it is 1.8.2 versions problems because I don't want to support version that is going to be outdated in few months
__________________
Finished mods:
Trouble in Terrorist Town
MurderMod
The Hidden
Cowboys vs Indians
JailBreak Supreme
Survival Madness
GuskiS is offline
erkike93
Member
Join Date: Aug 2013
Old 03-11-2015 , 17:15   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #9

Guskis how can i add a chat message for all players when a detective identified a body? for example:

Player 1 kill to Player 2, then the Detective identified the Player 2 body as Innocent, then show a message informing to all other players that the body was identified as "Innocent". You answered this same question before to another user here:

https://forums.alliedmods.net/showpo...&postcount=296

I already try that but nothing happen, so hope u can help to add that.

P.S: Also want to ask what is the most stable build version for 1.8.3? I'm using right now 1.8.3 +Dev4627 but sometimes the hlds.exe crash without reason, and i want try with another build version to check if its most stable for my server, thx in advanced.

Last edited by erkike93; 03-13-2015 at 12:46.
erkike93 is offline
erkike93
Member
Join Date: Aug 2013
Old 03-16-2015 , 15:09   Re: [v2.5.1, February 15] Trouble in Terrorist Town mod
Reply With Quote #10

Hi bro i want to ask you if u can make some checks to the ttt_dna_system because there are some events from the ADN Scanner that make the server crash and i'm almost sure that its for the DNA Scanner, some examples of this events are:

1.- When a player kill himself with a he grenade bomb, suicide, etc, sometimes when a detective come to check body, and after that use the Scanner to get ADN and trace the "killer", the server just get freeze and crash.

2.- Also when a detective got ADN from a body, and a few minutes late come another detective to take ADN from the same body, and the same happens, server freeze and crash.

3.- When a detective take the ADN from a body, and then try again to take again a ADN from the same body, sometimes the server get freeze and crash.

So i hope u can check this kind of events and if it is posible can u help/explain me how can i add some restrictions for example, if im detective and i take ADN from a body, and another detective come the server inform to him that "this ADN was already taken for another detective" or if the body was killed by himself it said "This player was killed by himself, you cant take ADN from this body" or something like that will be helpfull to test if this kind of events dont happen again and my server dont crash more because the ADN Scanner is the item most used from the players on my server when they are Detective. I haven't log because it didn't log anything when this happen :S

Last edited by erkike93; 03-16-2015 at 15:09.
erkike93 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 23:22.


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