SA-MP Forums Archive
MYSQL admin logs - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL admin logs (/showthread.php?tid=583028)


MYSQL admin logs - Eestlane123 - 25.07.2015

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)


AW: MYSQL admin logs - Mencent - 25.07.2015

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

Re: MYSQL admin logs - Eestlane123 - 25.07.2015

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

PHP код:
AdminLog("Slap",RPN(playerb), P6hjus); 


AW: MYSQL admin logs - Mencent - 25.07.2015

PHP код:
AdminLog(playerid,playerb,"Slap",P6hjus); 
Try this


- Mencent

Re: MYSQL admin logs - Belengher - 25.07.2015

Try this

Quote:

new Query[512];
Quote:

mysql_query(SQL ,Query);


AW: Re: MYSQL admin logs - Mencent - 25.07.2015

Quote:
Originally Posted by Belengher
Посмотреть сообщение
Try this
Bullshit.

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


- Mencent

Re: MYSQL admin logs - Eestlane123 - 25.07.2015

Thanks for responding, but it dont work, now it give me
Код:
error 035: argument type mismatch (argument 3)


AW: MYSQL admin logs - Mencent - 25.07.2015

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

Re: MYSQL admin logs - Eestlane123 - 25.07.2015

Код:
error 035: argument type mismatch (argument 1)
error line:
PHP код:
 mysql_query(Query); 


AW: MYSQL admin logs - Mencent - 25.07.2015

PHP код:
mysql_query(conHandle,Query); 
conHandle is the connection handle, I don't know how you named this.


- Mencent