[Eestlane123]

Hey, i have problem with making admin logs

PHP код:

stock AdminLog(playerid[], playerb[], tegevus[], p6hjus[])
{
    new Query[100];
    new hour, minute, second, year, month, day;
    getdate(year, month, day);
    gettime(hour, minute, second);
(line 232) ->    format(Query, sizeof(Query), "INSERT INTO `admin_logs` (`Admin`, `Player`, `Tegevus`, `Pхhjus`, `Kuu`, `Kell`) VALUES('%s', '%s', '%s', '%s', '%d/%d/%d', '%d:%d:%d')", RPN(playerid), RPN(playerb), tegevus, p6hjus, month, day, year, hour, minute, second);
 (line 233) -> mysql_query(Query);
} 


and here is error

Код:

(232) : error 035: argument type mismatch (argument 1)
(233) : error 035: argument type mismatch (argument 1)

[Mencent]

Hello!

Try this:

PHP код:

stock AdminLog(playerid,playerb,tegevus,p6hjus[])
{
    new Query[250],hour,minute,second,year,month,day;
    getdate(year,month,day);
    gettime(hour,minute,second);
    format(Query,sizeof Query,"INSERT INTO `admin_logs` (`Admin`,`Player`,`Tegevus`,`Pхhjus`,`Kuu`,`Kell`) VALUES ('%s','%s','%s','%s','%d/%d/%d','%d:%d:%d')",
    RPN(playerid),RPN(playerb),tegevus,p6hjus,month,day,year,hour,minute,second);
    mysql_query(Query);
    return 1;
} 


You have create playerid and playerb as a string but it should be an integer.


- Mencent

[Eestlane123]

Thanks, but if i type this under commands then it give me again this error

PHP код:

AdminLog("Slap",RPN(playerb), P6hjus); 


[Mencent]

PHP код:

AdminLog(playerid,playerb,"Slap",P6hjus); 


Try this


- Mencent

[Belengher]

Try this

Quote:

new Query[512];

Quote:

mysql_query(SQL ,Query);

[Mencent]

Quote:

Originally Posted by Belengher Try this

Bullshit.

He put a string into a integer-parameter, and this was the mistake.


- Mencent

[Eestlane123]

Thanks for responding, but it dont work, now it give me

Код:

error 035: argument type mismatch (argument 3)

[Mencent]

PHP код:

stock AdminLog(playerid,playerb,tegevus[],p6hjus[]) 
{ 
    new Query[250],hour,minute,second,year,month,day; 
    getdate(year,month,day); 
    gettime(hour,minute,second); 
    format(Query,sizeof Query,"INSERT INTO `admin_logs` (`Admin`,`Player`,`Tegevus`,`Pхhjus`,`Kuu`,`Kell`) VALUES ('%s','%s','%s','%s','%d/%d/%d','%d:%d:%d')", 
    RPN(playerid),RPN(playerb),tegevus,p6hjus,month,day,year,hour,minute,second); 
    mysql_query(Query); 
    return 1; 
} 


So.


- Mencent

[Eestlane123]

Код:

error 035: argument type mismatch (argument 1)

error line:

PHP код:

 mysql_query(Query); 


[Mencent]

PHP код:

mysql_query(conHandle,Query); 


conHandle is the connection handle, I don't know how you named this.


- Mencent