pawn Код:
gsString[ 0 ] = EOS;
new
Buf[ 129 ]
;
WP_Hash( Buf, 129, rPassword );
new
liYear,
liMonth,
liDay
;
getdate( liYear, liMonth, liDay );
new year, month, day;
getdate( year, month, day );
format( gsString, sizeof( gsString ), "INSERT INTO `accounts` \
VALUES(0, '%s', '%s', '%s', '%d-%d-%d','%d/%d/%d', '0', '0', '0', '0', '0', '0', \
'0', '0', '0', '00:00:00', '0', '0', '0' '0', \
'0', '0', '0', 'None.', '0', '0', 'None', '0', '0', '0', 0", PlayerName( playerid ), GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay,year,month,day);
format( gsString, sizeof( gsString ), "%s, '0', '0', '0', '0', '0', \
'0', '0', '0', '00:00', '0', '00:00', '0', '0xFFFFFFFF', \
' 0', '0', '00:00:00', '0',0, 0, '0', '0','0', 0, '0', '0', '0','5','22', 33, '1', '0', '0','0','0','0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", gsString );
mysql_query( gsString );
PlayerInfo[ playerid ][ AccID ] = mysql_insert_id( );
pawn Код:
/**
* MySQL plugin R7
* Copyright © 2008-2011, BlueG
*/#if defined mysql_included #endinput#endif#define mysql_included/**
* Common error codes
*
* Client: http://dev.mysql.com/doc/refman/5.0/en/e...lient.html
* Server: http://dev.mysql.com/doc/refman/5.0/en/e...erver.html
*
*/#define ER_DBACCESS_DENIED_ERROR 1044#define ER_ACCESS_DENIED_ERROR 1045#define ER_UNKNOWN_TABLE 1109#define ER_SYNTAX_ERROR 1149#define CR_SERVER_GONE_ERROR 2006#define CR_SERVER_LOST 2013#define CR_COMMAND_OUT_OF_SYNC 2014#define CR_SERVER_LOST_EXTENDED 2055// Native functions#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")#define mysql_next_row() mysql_retrieve_row()#define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)#define mysql_query_callback(%1,%2,%3,%4,%5) \ mysql_function_query
(%5,
%2,false,
%3,
"siii",
%2,
%1,
%4,
%5
)