Pawn is a very good scripting language intended for embedded type applications due to its size and speed (and simplicity).
In some embedded applications, it is important to take script values and write them to and read them from a C-style structure for generic use in a system.
The functionality is similar in concept to the python struct module.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001391s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.090653s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000951s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001261s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001004s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003575s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000909s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003700s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014769s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001273s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 87781 [ RunTime:0.013576s ]
