[Gammix]

pawn Код:

INSERT INTO `adminlog` (`Ip`) SELECT `Ip` FROM `user` WHERE `Username` = 'something';

This will insert a new row into `adminlog` table and the row will contain the `Ip` address extracted from the `user` table, the filter applied for user table is `Username` = 'something' (can be anything according to your code).

This is a direct query. You may modify it according to your needs.