eathena.kpaste.net RSS
Difference between
modified post 66c1328c by Anonymous on Wed 26th Oct 2011 08:27
original post 1dbe92e by Anonymous on Wed 26th Oct 2011 07:33
Download diff
Show
old version |
new version |
both versions
| 1 | 1 | prontera,155,88,0 script VIP Stats Checker 910,{ | |
| 2 | 2 | query_sql "SELECT `char`.account_id,`name`,SUM(online) AS online, " + | |
| 3 | 3 | "`value`-UNIX_TIMESTAMP() AS secs_left " + | |
| 4 | 4 | "FROM global_reg_value LEFT JOIN `char` ON global_reg_value.account_id=`char`.account_id " + | |
| 5 | 5 | "WHERE global_reg_value.str='#VIP_expire' AND CAST(`value` AS UNSIGNED) > UNIX_TIMESTAMP() " + | |
| 6 | 6 | "GROUP BY `char`.account_id " + | |
| 7 | 7 | "ORDER BY CAST(`value` AS SIGNED) ASC LIMIT 128", | |
| 8 | 8 | .@account_id, .@name$, .@online, .@secs_left; | |
| 9 | 9 | ||
| 10 | + | mes "[ VIP Stats Checker]"; |
Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.