10.05.2013, 06:47
(
Последний раз редактировалось Dan..; 10.05.2013 в 11:09.
)
Quote:
Are you aware that the binaries in the first post don't match the include?
Edit: If anyone wants an updated example script using the newest plugin version (the one with "sql" not "mysql" function names, that currently you have to compile yourself): https://github.com/Y-Less/YSI-Includ...sers/Dan10.inc Edit 2: I keep getting a syntax error when I run this query through the plugin: Код:
SELECT @Y:=MAX(yid) FROM y_users_preload;INSERT INTO y_users_preload VALUES(DEFAULT, @Y + 1, 'Alex', '9BD7575A156544838F2BD3A3DC2FAAADED4D88250B65EF82D6CFC5BE9179BBD8EF13000685376268DF705F6FC2F4FFC5254AF8D1ED3FD99B49B89FB9AF651D91', 'EN', 0, 1368148884);SELECT (@Y + 1); |
That query is not working fine because there are multiple queries and just the first one is executed. I will enable execution of multipe queries in the next version (I hope).
I suggest you make the `yid` primary key and use auto-increment attribute. http://dev.mysql.com/doc/refman/5.0/...increment.html
You can recieve the insert ID using mysql_insert_id.