AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Suggestions / Requests (https://forums.alliedmods.net/forumdisplay.php?f=12)
-   -   plugin request (https://forums.alliedmods.net/showthread.php?t=336568)

Alahmoh 02-28-2022 11:20
plugin request
 
can someone help me by changing my plugin from sql to nvault system if yes i will send you plugin in pm.

OciXCrom 02-28-2022 14:06
Re: plugin request
 
If you want help, attach the plugin. This is a public forum.

Alahmoh 02-28-2022 14:39
Re: plugin request
 
Quote:
Originally Posted by OciXCrom (Post 2772742)
If you want help, attach the plugin. This is a public forum.
Code:
#include < amxmodx >
#include < amxmisc >
#include < colorchat >
#include < unixtime >
#include < engine >
#include < nvault >

#define IsUserAuthorized(%1)        ( g_PlayerInfo[ %1 ][ g_iConnected ] & FULL_STATUS == FULL_STATUS )

#define TASK_REWARD                9747

#define TOP_MOTD                "http://professional-cs.mojkgb.com/Mod/Timer/TopMotd.php"
#define MYTIME_MOTD                "http://professional-cs.mojkgb.com/Mod/Timer/MyTimeMotd.php?Id=%d"

enum ( <<= 1 ) {
        CONNECTED = 1,
        AUTHORIZED
};

const FULL_STATUS = CONNECTED | AUTHORIZED;
new Handle: g_hSqlConnection;

enum _:StructPlayerInfo {
        g_szSteamId[ 32 ],
        g_szNick[ 32 ],
        g_szIp[ 20 ],
       
        g_iConnected,
        g_iTime,
        g_iId
}

new g_PlayerInfo[ 33 ][ StructPlayerInfo ];

new g_szFiles[ ] = {
        "addons/amxmodx/configs/Timer/"
};

new bool: g_bDone = false;

public plugin_init( ) {
        register_plugin( "Timer", "1.0", "unknown" );
       
        register_clcmd( "say /toptime", "TopTime" );
        register_clcmd( "say_team /toptime", "TopTime" );
        register_clcmd( "say /online", "MyTime" );
        register_clcmd( "say_team /online", "MyTime" );
        register_clcmd( "say /mytime", "MyTime" );
        register_clcmd( "say_team /mytime", "MyTime" );
        register_clcmd( "say /time", "MyTime" );
        register_clcmd( "say_team /time", "MyTime" );
       
       
        if( !dir_exists( g_szFiles ) )
                mkdir( g_szFiles );       
               
        new szFile[ 256 ];
        get_localinfo( "amxx_configsdir", szFile, charsmax( szFile ) );
        add( szFile, charsmax( szFile ), "/Timer/Timer.cfg" );
       
        if( !file_exists( szFile ) )
                write_file( szFile, "; Here you can configure ByW Timer^nSQL_HOST = 46.105.105.77^nSQL_USER = professi_timer^nSQL_PASS = timer12345^nSQL_DB = professi_timer" );
       
        new iFile = fopen( szFile, "rt" );
       
        if( !iFile )
                set_fail_state( "Failed to open config file." );
       
        new iPos, szHost[ 64 ], szUser[ 64 ], szPass[ 64 ], szDb[ 64 ];
        while( iFile && !feof( iFile ) ) {
                fgets( iFile, szFile, 255 );
                trim( szFile );
               
                if( !szFile[ 0 ] || szFile[ 0 ] == ';' )
                        continue;
               
                if( ( iPos = contain( szFile, "=" ) ) < 0 )
                        continue;
               
                else if( equal( szFile, "SQL_HOST", 7 ) )
                        copy( szHost, charsmax( szHost ), szFile[ iPos + 2 ] );
                else if( equal( szFile, "SQL_USER", 7 ) )
                        copy( szUser, charsmax( szUser ), szFile[ iPos + 2 ] );
                else if( equal( szFile, "SQL_PASS", 7 ) )
                        copy( szPass, charsmax( szPass ), szFile[ iPos + 2 ] );
                else if( equal( szFile, "SQL_DB", 5 ) )
                        copy( szDb, charsmax( szDb ), szFile[ iPos + 2 ] );
        }
       
        fclose( iFile );
       
        g_hSqlConnection = SQL_MakeDbTuple( szHost, szUser, szPass, szDb );
        //SQL_QueryMe( "CREATE TABLE IF NOT EXISTS `bywtimer` (`Id` INT NOT NULL AUTO_INCREMENT, `SteamID` VARCHAR(64) NOT NULL, `Nick` VARCHAR(32) NOT NULL, `PlayedTime` INT NOT NULL DEFAULT 0, `LastSeen` INT NOT NULL DEFAULT 0, PRIMARY KEY (`Id`), UNIQUE INDEX `Id_UNIQUE` (`Id` ASC), UNIQUE INDEX `SteamID_UNIQUE` (`SteamID` ASC));" );

        InitialiseRewardSystem( );
}

InitialiseRewardSystem( ) {
        new iEntity = create_entity( "info_target" );
       
        entity_set_string( iEntity, EV_SZ_classname, "RewardSystem" );
        entity_set_float( iEntity, EV_FL_nextthink, get_gametime( ) + 5.0 );
       
        register_think( "RewardSystem", "fw_EntityThinks" );
}

public fw_EntityThinks( iEntity ) {
        if( !is_valid_ent( iEntity ) || g_bDone )
                return;
               
        entity_set_float( iEntity, EV_FL_nextthink, get_gametime( ) + 30.0 );
       
        if( !CheckTime( ) )
                return;
       
        g_bDone = true;
       
        new iErrorCode;
        new szError[ 512 ];
       
        new szDate[ 32 ], szErrorForFile[ 256 ];
        get_time( "%d.%m.%y %H:%M:%S", szDate, charsmax( szDate ) );
       
        new Handle: hSqlConnection2 = SQL_Connect( g_hSqlConnection, iErrorCode, szError, charsmax( szError ) );
        if( hSqlConnection2 == Empty_Handle ) {
                formatex(  szErrorForFile, charsmax(  szErrorForFile ), "[%s] ERROR WITH TIMER REWARD SYSTEM: %s", szDate, szError );
                write_file( "TIMER_ERRORS.TXT", szErrorForFile  );
                set_fail_state( szError );
        }
       
        new Handle: hQuery = SQL_PrepareQuery( hSqlConnection2, "SELECT `SteamID`, `Nick`, `PlayedTime`, `LastSeen` FROM `bywtimer` ORDER BY `PlayedTime` DESC LIMIT 15;" );
 
        if( !SQL_Execute( hQuery ) ) {
                SQL_QueryError( hQuery, szError, charsmax( szError ) );
                formatex(  szErrorForFile, charsmax(  szErrorForFile ), "[%s] ERROR WITH TIMER REWARD SYSTEM: %s", szDate, szError );
                write_file( "TIMER_ERRORS.TXT", szErrorForFile  );
                SQL_FreeHandle( hQuery );
                SQL_FreeHandle( hSqlConnection2 );
                return;
        }
       
        new szData[ 4 ][ 64 ];
        while( SQL_MoreResults( hQuery ) ) {
                SQL_ReadResult( hQuery, 0, szData[ 0 ], charsmax( szData[ ] ) );
                SQL_ReadResult( hQuery, 1, szData[ 1 ], charsmax( szData[ ] ) );
                SQL_ReadResult( hQuery, 2, szData[ 2 ], charsmax( szData[ ] ) );
                SQL_ReadResult( hQuery, 3, szData[ 3 ], charsmax( szData[ ] ) );
               
                if( ( get_systime( ) - str_to_num( szData[ 3 ] ) ) >= ( ( ( 24 * 60 ) * 60 ) * 25 ) )
                        continue;
               
                new szText[ 256 ], szDate[ 32 ];
                new iExpiration = get_systime( ) + ( ( ( 24 * 60 ) * 60 ) * 15 );
                new iDay, iMonth, iYear, iHour, iMinute, iSecond;
       
                UnixToTime( iExpiration, iYear, iMonth, iDay, iHour, iMinute, iSecond );
                formatex( szDate, charsmax( szDate ), "%02d/%02d/%d", iDay, iMonth, iYear );
       
                formatex( szText, charsmax( szText ), "^"%s^" ^"%s^" ^"%s^" ; %s", szData[ 0 ], szData[ 2 ], szDate, szData[ 1 ] );
                write_file( "PlayersToReward.txt", szText );
               
                SQL_NextRow( hQuery );
        }
 
        SQL_QueryMe( "DELETE * FROM `bywtimer`;" );
        SQL_FreeHandle( hQuery );
        SQL_FreeHandle( hSqlConnection2 );
}

public plugin_end( )
        if( g_hSqlConnection )
                SQL_FreeHandle( g_hSqlConnection );

public TopTime( iPlayer )
        show_motd( iPlayer, TOP_MOTD );

public MyTime( iPlayer ) {
        new szLink[ 256 ];
        formatex( szLink, charsmax( szLink ), MYTIME_MOTD, g_PlayerInfo[ iPlayer ][ g_iId ] );
        show_motd( iPlayer, szLink );
}
       
public client_authorized( iPlayer )
        if( ( g_PlayerInfo[ iPlayer ][ g_iConnected ] |= AUTHORIZED ) & CONNECTED )
                UserHasBeenAuthorized( iPlayer );

public client_putinserver( iPlayer ) {
        if( !is_user_bot( iPlayer ) && ( g_PlayerInfo[ iPlayer ][ g_iConnected ] |= CONNECTED ) & AUTHORIZED )
                UserHasBeenAuthorized( iPlayer );
       
        if( task_exists( iPlayer + TASK_REWARD ) )
                remove_task( iPlayer + TASK_REWARD );
               
        if( !is_user_bot( iPlayer ) )
                set_task( 15.0, "RewardPlayer", iPlayer + TASK_REWARD );
}

public client_disconnect( iPlayer ) {
        if( task_exists( iPlayer + TASK_REWARD ) )
                remove_task( iPlayer + TASK_REWARD );
               
        SQL_QueryMe( "UPDATE `bywtimer` SET `PlayedTime` = '%i' WHERE `Id` = '%i';", g_PlayerInfo[ iPlayer ][ g_iTime ] + get_user_time( iPlayer ), g_PlayerInfo[ iPlayer ][ g_iId ] );
       
        g_PlayerInfo[ iPlayer ][ g_iTime ] = 0;
        g_PlayerInfo[ iPlayer ][ g_iId ] = 0;
        g_PlayerInfo[ iPlayer ][ g_iConnected ] = 0;
}

public RewardPlayer( iPlayer ) {
        if( is_user_connected( iPlayer ) ) {
                new iHours = 0;
               
                if( CheckConditions( iPlayer, iHours ) ) {
                                               
                        //add rewards here               
                               
                       
                }
        }
}
               
UserHasBeenAuthorized( const iPlayer ) {
        g_PlayerInfo[ iPlayer ][ g_iTime ] = 0;
        g_PlayerInfo[ iPlayer ][ g_iId ] = 0;
       
        get_user_authid( iPlayer, g_PlayerInfo[ iPlayer ][ g_szSteamId ], charsmax( g_PlayerInfo[ ][ g_szSteamId ] ) );
        get_user_name( iPlayer, g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ) );
        get_user_ip( iPlayer, g_PlayerInfo[ iPlayer ][ g_szIp ], charsmax( g_PlayerInfo[ ][ g_szIp ] ), 1 );
       
        replace_all( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), "`", "" );
        replace_all( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), "^"", "" );
        replace_all( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), "'", "" );

        new szQuery[ 128 ], szPlayerId[ 1 ]; szPlayerId[ 0 ] = iPlayer;
        formatex( szQuery, charsmax( szQuery ), "SELECT `Id`, `PlayedTime` FROM `bywtimer` WHERE `SteamID` = '%s'", g_PlayerInfo[ iPlayer ][ g_szSteamId ] );
       
        SQL_ThreadQuery( g_hSqlConnection, "HandlePlayerConnect", szQuery, szPlayerId, 1 );
}

public HandlePlayerConnect( iFailState, Handle: hQuery, szError[ ], iError, szData[ ], iSize, Float: flQueueTime ) {
        if( SQL_IsFail( iFailState, iError, szError ) )
                return;
       
        new iPlayer = szData[ 0 ];
       
        if( !IsUserAuthorized( iPlayer ) )
                return;
               
        if( !SQL_NumResults( hQuery ) ) {
                new szQuery[ 256 ];
                formatex( szQuery, 255, "INSERT INTO `bywtimer` (`SteamID`, `Nick`, `PlayedTime`) VALUES (^"%s^", ^"%s^", '0')", g_PlayerInfo[ iPlayer ][ g_szSteamId ],  g_PlayerInfo[ iPlayer ][ g_szNick ] );
               
                SQL_ThreadQuery( g_hSqlConnection, "HandlePlayerInsert", szQuery, szData, 1 );
               
                return;
        }
       
        g_PlayerInfo[ iPlayer ][ g_iId ] = SQL_ReadResult( hQuery, 0 );
        g_PlayerInfo[ iPlayer ][ g_iTime ] = SQL_ReadResult( hQuery, 1 );
       
        replace_all( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), "`", "" );
        replace_all( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), "^"", "" );
        replace_all( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), "'", "" );
       
        SQL_QueryMe( "UPDATE `bywtimer` SET `LastSeen` = '%i', `Nick` = '%s' WHERE `Id` = '%i';", get_systime( ), g_PlayerInfo[ iPlayer ][ g_szNick ], g_PlayerInfo[ iPlayer ][ g_iId ] );
}

public HandlePlayerInsert( iFailState, Handle: hQuery, szError[ ], iError, szData[ ], iSize, Float: flQueueTime ) {
        if( SQL_IsFail( iFailState, iError, szError ) )
                return;
       
        new iPlayer = szData[ 0 ];
       
        if( !IsUserAuthorized( iPlayer ) )
                return;
       
        new szQuery[ 128 ], szPlayerId[ 1 ]; szPlayerId[ 0 ] = iPlayer;
        formatex( szQuery, charsmax( szQuery ), "SELECT `Id` FROM `bywtimer` WHERE `SteamID` = '%s'", g_PlayerInfo[ iPlayer ][ g_szSteamId ] );
        SQL_ThreadQuery( g_hSqlConnection, "HandlePlayerInsert2", szQuery, szPlayerId, 1 );
}

public HandlePlayerInsert2( iFailState, Handle: hQuery, szError[ ], iError, szData[ ], iSize, Float: flQueueTime ) {
        if( SQL_IsFail( iFailState, iError, szError ) )
                return;
       
        new iPlayer = szData[ 0 ];
       
        if( !IsUserAuthorized( iPlayer ) )
                return;
       
        g_PlayerInfo[ iPlayer ][ g_iId ] = SQL_ReadResult( hQuery, 0 );
        g_PlayerInfo[ iPlayer ][ g_iTime ] = 0;
       
        SQL_QueryMe( "UPDATE `bywtimer` SET `LastSeen` = '%i' WHERE `Id` = '%i';", get_systime( ), g_PlayerInfo[ iPlayer ][ g_iId ] );
}

public client_infochanged( iPlayer ) {
        new szName[ 32 ];
        get_user_info( iPlayer, "name", szName, charsmax( szName ) );
       
        if( !equal( g_PlayerInfo[ iPlayer ][ g_szNick ], szName ) )
                copy( g_PlayerInfo[ iPlayer ][ g_szNick ], charsmax( g_PlayerInfo[ ][ g_szNick ] ), szName );
}

SQL_QueryMe( const szQuery[ ], any:... ) {
        new szMessage[ 256 ];
        vformat( szMessage, charsmax( szMessage ), szQuery, 2 );
       
        SQL_ThreadQuery( g_hSqlConnection, "HandleQuery", szMessage );
}

SQL_IsFail( const iFailState, const iError, const szError[ ] ) {
        if( iFailState == TQUERY_CONNECT_FAILED ) {
                log_to_file( "SQL_Error.txt", "[Error] Could not connect to SQL database: %s", szError );
                return true;
        }
        else if( iFailState == TQUERY_QUERY_FAILED ) {
                log_to_file( "SQL_Error.txt", "[Error] Query failed: %s", szError );
                return true;
        }
        else if( iError ) {
                log_to_file( "SQL_Error.txt", "[Error] Error on query: %s", szError );
                return true;
        }
       
        return false;
}

public HandleQuery( iFailState, Handle: hQuery, szError[ ], iError, szData[ ], iSize, Float: flQueueTime )
        SQL_IsFail( iFailState, iError, szError );

stock bool: CheckConditions( iPlayer, &iHours ) {
        if( !file_exists( "PlayersToReward.txt" ) )
                return false;
       
        new iFile = fopen( "PlayersToReward.txt", "rt" );
       
        if( !iFile )
                return false;
       
        new szSteam[ 64 ];
        get_user_authid( iPlayer, szSteam, charsmax( szSteam ) );
               
        new szData[ 512 ], szPiece[ 3 ][ 64 ], iGiven, iLine = 0;
        while( iFile && !feof( iFile ) ) {
                iLine ++;
               
                fgets( iFile, szData, charsmax( szData ) );
               
                if( szData[ 0 ] == EOS )
                        continue;
               
                if( szData[ 0 ] == '*' )
                        iGiven ++;
                       
                if( iGiven >= 15 ) {
                        if( iFile ) fclose( iFile );
                        unlink( "PlayersToReward.txt" );
                        return false;
                }
                       
                parse( szData, szPiece[ 0 ], charsmax( szPiece[ ] ), szPiece[ 1 ], charsmax( szPiece[ ] ), szPiece[ 2 ], charsmax( szPiece[ ] ) );
               
                if( CheckExpration( szPiece[ 2 ] ) == true ) {
                        write_file( "PlayersToReward.txt", "*", iLine - 1 );
                        iGiven ++;
                       
                        if( iGiven >= 15 ) {
                                if( iFile ) fclose( iFile );
                                unlink( "PlayersToReward.txt" );
                                return false;
                        }
                       
                        continue;
                }
                       
                if( equal( szPiece[ 0 ], szSteam ) ) {
                        write_file( "PlayersToReward.txt", "*", iLine - 1 );
                        iGiven ++;
                       
                        iHours = str_to_num( szPiece[ 1 ] ) / 3600;
                       
                        if( iGiven >= 15 )
                                unlink( "PlayersToReward.txt" );
                               
                        if( iFile ) fclose( iFile );
                       
                        return true;
                }
        }
       
        if( iFile )
                fclose( iFile );
               
        return false;
}

stock bool: CheckExpration( const szExpiration[ ] ) {
        if( get_systime( ) >= GetExpiration( szExpiration ) )
                return true;
               
        return false;
}

stock GetExpiration( const szExpiration[ ] ) {
        new szExp[ 32 ];
        copy( szExp, charsmax( szExp ), szExpiration );
       
        replace_all( szExp, charsmax( szExp ), "/", " " );
        replace_all( szExp, charsmax( szExp ), ".", " " );
       
        new szTime[ 3 ][ 5 ];
        new iExpiration;
       
        if( parse( szExp, szTime[ 0 ], charsmax( szTime[ ] ), szTime[ 1 ], charsmax( szTime[ ] ), szTime[ 2 ], charsmax( szTime[ ] ) ) < 3 )
                return true;
       
        new iYear = str_to_num( szTime[ 2 ] );
        new iMonth  = str_to_num( szTime[ 1 ] );
        new iDay = str_to_num( szTime[ 0 ] );
       
        new iHour, iMinute, iSecond = 0;
        iExpiration = TimeToUnix( iYear, iMonth, iDay, iHour, iMinute, iSecond );
       
        return iExpiration;
}

stock bool: CheckTime( ) {
        new iCurrentTime = get_systime( );
        new iYear, iMonth, iDay, iHour, iMinute, iSecond = 0;
        UnixToTime( iCurrentTime , iYear , iMonth , iDay , iHour , iMinute , iSecond );
       
        // First day in month and 1 'o clock at night and first minute
        return ( iDay == 1 ) && ( iHour == 1 ) && ( iMinute == 1 ) ? true : false;
}

fysiks 02-28-2022 21:35
Re: plugin request
 
If the purpose of this is because you don't want or have an external MySQL database, I'd recommend simply switching to SQLite. You should also post the database structure regardless of which method is chosen.


Also, when posting a plugin that you want modified, please post the original unmodified version (you can edit your last post to post the correct code).

Alahmoh 03-01-2022 08:41
Re: plugin request
 
Quote:
Originally Posted by fysiks (Post 2772776)
If the purpose of this is because you don't want or have an external MySQL database, I'd recommend simply switching to SQLite. You should also post the database structure regardless of which method is chosen.


Also, when posting a plugin that you want modified, please post the original unmodified version (you can edit your last post to post the correct code).
well i didnt modify that much i only removed my rewards system along with my own include which are private and have nothing to do with this plugin,
also i asked someone to help me not because im lazy its just i know nothing about sql,nvault,sqlite.

fysiks 03-01-2022 21:26
Re: plugin request
 
I've never used SQLite before but from the searches I did here make it seem like it may be as simple as changing the affinity and making sure the sqlite module loads (using a pragma).


All times are GMT -4. The time now is 05:24.

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