Search Results
Quote: Originally Posted by VincentDunn Why would you select everything? A waste of memory. pawn Код: format(query, sizeof(query), "SELECT COUNT(*) FROM `%s`", TABLE_NAME);    mysql...
254
exactly is this, correct ? PHP код:     format(query, sizeof(query), "SELECT * FROM `%s`", TABLE_NAME);    mysql_query(query);        mysql_store_result();       Â...
254
how to calculate the total users registred, into the database ? i use BlueG MySQL Plugin
254
Quote: Originally Posted by [HLF]Southclaw Yes exactly! Although I'm not sure if this is faster than the other code posted by kikito. And I'm sure the bump time is 48 hours, not 24 (I got...
235
Quote: Originally Posted by [HLF]Southclaw The 'true' is not needed there, neither is the '!'. If you look at the strcmp documentation on the wiki, that param you have set true is the 'ign...
235
Quote: Originally Posted by [HLF]Southclaw Wow, I only learnt SQL like a few days ago and I understand him! You need to query the database IP, check it against the player IP using "strcmp...
235
Quote: Originally Posted by Syntax What do you mean an example..? Код: how to: if the ip is different, upload into the database, if it is not different not upload to the database. ...
235
no, you do not understand, I already did, I asked for an example of a script
235
how to: if the ip is different, upload into the database, if it is not different not upload to the database. i use mysql plugin BlueG R6.
235
thanks, i have solved: i have put PHP код:         format(query, sizeof(query), "UPDATE `%s` SET `Last_IP` = '%s' WHERE `Name` = '%s'",         TABLE_NAME,    Â...
159
Quote: Originally Posted by MadeMan Yes. https://sampforum.blast.hk/showthread.php?tid=331420 and no way to fix?...
159
Pawn code: PHP код: format(query, sizeof(query), "INSERT INTO `%s` (`IP_Registration`, `Last_IP`) VALUES('%s', '%s')", TABLE_NAME, ip(playerid), ip(playerid)); //-----------------...
159
Quote: Originally Posted by Vince Instead of your variables, insert one of these MySQL functions (literal): NOW() or UNIX_TIMESTAMP(). Not sure if any of these work, as I always use plain ...
140
I use mysql plugin BlueG - version R6 I have the problem: Pawn code: PHP код: new year, month, day, hour, minute, second; getdate(year, month, day), gettime(hour, minute, second);...
140
Quote: Originally Posted by Ronaldo_raulâ„¢ Tutorial Try the above tutorial. This is all you want. no ... this not save... the date of registration and date last login, in year, month...
162
Quote: Originally Posted by TheArcher Yes, you should. Thanks
155