|
File patch3.txt, 0.9 kB
(added by sci2tech, 5 months ago)
|
integer atribute passed as string. patch
|
| Line | |
|---|
| 1 |
--- reseller_user_statistics.php 2008-06-30 18:09:02.000000000 +0300 |
|---|
| 2 |
+++ /var/www/ispcp/gui/reseller/reseller_user_statistics.php 2008-06-30 18:30:18.000000000 +0300 |
|---|
| 3 |
@@ -102,21 +102,21 @@ |
|---|
| 4 |
$records_count = $rs->fields['cnt']; |
|---|
| 5 |
|
|---|
| 6 |
$query = <<<SQL_QUERY |
|---|
| 7 |
- SELECT |
|---|
| 8 |
- admin_id |
|---|
| 9 |
- FROM |
|---|
| 10 |
- admin |
|---|
| 11 |
- WHERE |
|---|
| 12 |
- admin_type = 'user' |
|---|
| 13 |
- AND |
|---|
| 14 |
- created_by = ? |
|---|
| 15 |
- ORDER BY |
|---|
| 16 |
- admin_name ASC |
|---|
| 17 |
- LIMIT |
|---|
| 18 |
- ?, ? |
|---|
| 19 |
+ SELECT |
|---|
| 20 |
+ admin_id |
|---|
| 21 |
+ FROM |
|---|
| 22 |
+ admin |
|---|
| 23 |
+ WHERE |
|---|
| 24 |
+ admin_type = 'user' |
|---|
| 25 |
+ AND |
|---|
| 26 |
+ created_by = ? |
|---|
| 27 |
+ ORDER BY |
|---|
| 28 |
+ admin_name ASC |
|---|
| 29 |
+ LIMIT |
|---|
| 30 |
+ $start_index, $rows_per_page |
|---|
| 31 |
SQL_QUERY; |
|---|
| 32 |
|
|---|
| 33 |
- $rs = exec_query($sql, $query, array($reseller_id, $start_index, $rows_per_page)); |
|---|
| 34 |
+ $rs = exec_query($sql, $query, array($reseller_id)); |
|---|
| 35 |
$tpl->assign( |
|---|
| 36 |
array( |
|---|
| 37 |
'RESELLER_NAME' => $reseller_name, |
|---|
|
