2 replies to this topic

[ZbawienieŚwiata]

Siemka. Proszę was o pomoc w napisaniu funkcji, która zapisuje do mysql łączną  ilość HS gracza.

 

Z góry dziękuję.

[Misiaczek ;c]

Zwykły zapis SQL

Spoiler

#include < amxmodx >
#include < sqlx >

new sqlConfig[ ][ ] = {
	"127.0.0.1",
	"root",
	"password",
	"database"
}

enum playerData {
	SteamID[ 33 ],
	IP[ 16 ],
	Nick[ 64 ],
	HS
};

new Handle: gSqlTuple;
new gPlayer[ 33 ][ playerData ];

public SqlInit( ) {
	gSqlTuple = SQL_MakeDbTuple( sqlConfig[ 0 ], sqlConfig[ 1 ], sqlConfig[ 2 ], sqlConfig[ 3 ] );
	
	if( gSqlTuple == Empty_Handle )
		set_fail_state( "Nie mozna utworzyc uchwytu do polaczenia" );
	
	new iErr, szError[ 32 ];
	new Handle:link = SQL_Connect( gSqlTuple, iErr, szError, 31 );
	
	if( link == Empty_Handle ) {
		log_amx( "Error (%d): %s", iErr, szError );
		set_fail_state( "Brak polaczenia z baza danych" );
	}
	
	new Handle: query;
	query = SQL_PrepareQuery( link, "CREATE TABLE IF NOT EXISTS `players_hs` (\
		`id` int(11) NOT NULL AUTO_INCREMENT,\
		`steamid` varchar(33) NOT NULL,\
		`nick` varchar(64) NOT NULL,\
		`ip` varchar(16) NOT NULL,\
		`hs` int(16) NOT NULL,\
		PRIMARY KEY (`id`),\
		UNIQUE KEY `authid` (`nick`)\
	)" );
	
	SQL_Execute( query );
	SQL_FreeHandle( query );
	SQL_FreeHandle( link );
}

public Query( failstate, Handle:query, error[ ] ) {
	if( failstate != TQUERY_SUCCESS ) {
		log_amx( "SQL query error: %s", error );
		return;
	}
}

public plugin_init() {
	register_plugin( "Zapis HS", "1.0", "AMXX.pl" );
	register_event( "DeathMsg", "eventDeathMsg", "ae" );
	
	set_task( 0.1, "SqlInit" );
}

public eventDeathMsg( ) {
	if( read_data( 3 ) ) {
		gPlayer[ read_data( 1 ) ][ HS ]++;
	}	
}

public client_connect( id ) {
	gPlayer[ id ][ HS ] = 0;	
	get_user_authid( id, gPlayer[ id ][ SteamID ], 32 );
	get_user_ip( id, gPlayer[ id ][ IP ], 15, 1 );
	get_user_name( id, gPlayer[ id ][ Nick ], 63 );	
	SQL_PrepareString( gPlayer[ id ][ Nick ], gPlayer[ id ][ Nick ], 63 );
}

public client_disconnect( id ) {
	save( id );	
	gPlayer[ id ][ HS ] = 0;
}

stock SQL_PrepareString( const szQuery[], szOutPut[], size ) {
	copy( szOutPut, size, szQuery );
	replace_all( szOutPut, size, "'", "\'" );
	replace_all( szOutPut, size, "`", "\`" );    
	replace_all( szOutPut, size, "\\", "\\\\" );
	replace_all( szOutPut, size, "^0", "\0");
	replace_all( szOutPut, size, "^n", "\n");
	replace_all( szOutPut, size, "^r", "\r");
	replace_all( szOutPut, size, "^x1a", "\Z");	
}

stock save( id ) {
	new query[ 1024 ]	
	formatex( query, charsmax( query ), "INSERT IGNORE INTO `players_hs` ( `steamid`, `nick`, `ip`, `hs`) VALUES ( '%s', '%s', '%s', %d ) ON DUPLICATE KEY UPDATE `hs` = `hs` + %d", 
	gPlayer[ id ][ SteamID ], gPlayer[ id ][ Nick ], gPlayer[ id ][ IP ], gPlayer[ id ][ HS ] );
	
	if( gSqlTuple )
		SQL_ThreadQuery (gSqlTuple, "Query", query );
}

 

Zapis przy użyciu http://amxx.pl/topic...4-database-orm/

Spoiler

#include <amxmodx>
#include <database_orm>

new Class: g_hHS

new bool: g_bReady[ 33 ]
enum playerData {
	HS
};
new gPlayer[ 33 ][ playerData ];

enum _: DatabaseColumns {
	Player_HS
}

new g_DatabaseColumns[ DatabaseColumns ][ ClassColumnStruct ] = {
	{ "player_hs", Column_Int, 11 }
}

public plugin_init( ) {
	new Array: aColumns = ArrayCreate( ClassColumnStruct, DatabaseColumns )
	for( new i; i < DatabaseColumns; i ++ ) {
		ArrayPushArray( aColumns, g_DatabaseColumns[ i ] )
	}
	
	g_hHS = CSRP_CreatePlayerClass( "orm_playerhs", aColumns, -1, "_Callback" ) 
	register_event( "DeathMsg", "eventDeathMsg", "ae" );
}

public eventDeathMsg( ) {
	if( read_data( 3 ) ) {
		gPlayer[ read_data( 1 ) ][ HS ]++;
	}	
}

public CSRP_OnPlayerLoad( id ) {
	g_bReady[ id ] = true
	
	new Array: aAccount = CSRP_FindInPlayerClassUnique( g_hHS, id )
	
	if( aAccount == Invalid_Array ) {
		aAccount = ArrayCreate( 1, DatabaseColumns )
		
		ArrayPushCell( aAccount, 0 )
		
		CSRP_PushPlayerClassItem( g_hHS, id, aAccount )
	}
}

public client_disconnect( id ) {
	new Array: aAccount = CSRP_FindInPlayerClassUnique( g_hHS, id )
	new iHS = ArrayGetCell( aAccount, Player_HS )
	
	ArraySetCell( aAccount, Player_HS, iHS + gPlayer[ id ][ HS ] )
	g_bReady[ id ] = false
	
}

public CSRP_OnSave( ) {
	if( g_hHS != Invalid_Class ) {
		CSRP_SavePlayerClass( g_hHS )
	}
}

public _Callback( ) { }  

[ZbawienieŚwiata]

Dziękuję!

 

Mógłbyś dodać do tego zapis killi i dead?