@@ -169,6 +169,11 @@ discard block |
||
169 | 169 | */ |
170 | 170 | // OK v4 |
171 | 171 | // TODO - вынести в отдельный класс |
172 | +/** |
|
173 | + * @param string $db_id_field_name |
|
174 | + * @param string $db_table_name |
|
175 | + * @param string $db_value_field_name |
|
176 | + */ |
|
172 | 177 | function db_get_set_unique_id_value($current_value_unsafe, $db_id_field_name, $db_table_name, $db_value_field_name) { |
173 | 178 | $current_value_safe = db_escape($current_value_unsafe); |
174 | 179 | $value_id = classSupernova::$db->doSelectFetch("SELECT `{$db_id_field_name}` FROM {{{$db_table_name}}} WHERE `{$db_value_field_name}` = '{$current_value_safe}' LIMIT 1 FOR UPDATE"); |
@@ -487,8 +492,8 @@ discard block |
||
487 | 492 | |
488 | 493 | |
489 | 494 | /** |
490 | - * @param $user_id |
|
491 | - * @param $change_type |
|
495 | + * @param integer $user_id |
|
496 | + * @param integer $change_type |
|
492 | 497 | * @param $dark_matter |
493 | 498 | * @param $comment_unsafe |
494 | 499 | * @param $rowUserNameUnsafe |
@@ -509,7 +514,7 @@ discard block |
||
509 | 514 | /** |
510 | 515 | * @param $user_id_safe |
511 | 516 | * |
512 | - * @return array|bool|mysqli_result|null |
|
517 | + * @return integer |
|
513 | 518 | */ |
514 | 519 | function db_referral_get_by_id($user_id_safe) { |
515 | 520 | $old_referral = classSupernova::$db->doSelectFetch("SELECT * FROM {{referrals}} WHERE `id` = {$user_id_safe} LIMIT 1 FOR UPDATE;"); |
@@ -540,9 +545,9 @@ discard block |
||
540 | 545 | |
541 | 546 | // Quests *********************************************************************************************************** |
542 | 547 | /** |
543 | - * @param $query_add_select |
|
548 | + * @param string $query_add_select |
|
544 | 549 | * @param $query_add_from |
545 | - * @param $query_add_where |
|
550 | + * @param string $query_add_where |
|
546 | 551 | * |
547 | 552 | * @return array|bool|mysqli_result|null |
548 | 553 | */ |
@@ -586,11 +591,11 @@ discard block |
||
586 | 591 | } |
587 | 592 | |
588 | 593 | /** |
589 | - * @param $quest_name_unsafe |
|
590 | - * @param $quest_type |
|
591 | - * @param $quest_description_unsafe |
|
594 | + * @param string $quest_name_unsafe |
|
595 | + * @param integer $quest_type |
|
596 | + * @param string $quest_description_unsafe |
|
592 | 597 | * @param $quest_conditions |
593 | - * @param $quest_rewards |
|
598 | + * @param string $quest_rewards |
|
594 | 599 | * @param $quest_id |
595 | 600 | */ |
596 | 601 | function db_quest_update($quest_name_unsafe, $quest_type, $quest_description_unsafe, $quest_conditions, $quest_rewards, $quest_id) { |
@@ -674,7 +679,7 @@ discard block |
||
674 | 679 | |
675 | 680 | /** |
676 | 681 | * @param $payment_id |
677 | - * @param $payment_status |
|
682 | + * @param integer $payment_status |
|
678 | 683 | * @param $comment_unsafe |
679 | 684 | */ |
680 | 685 | function db_payment_update($payment_id, $payment_status, $comment_unsafe) { |
@@ -162,7 +162,7 @@ discard block |
||
162 | 162 | /** |
163 | 163 | * @param string $query |
164 | 164 | * |
165 | - * @return mixed|string |
|
165 | + * @return string |
|
166 | 166 | */ |
167 | 167 | public function replaceTablePlaceholders($query) { |
168 | 168 | $sql = $query; |
@@ -176,7 +176,7 @@ discard block |
||
176 | 176 | } |
177 | 177 | |
178 | 178 | /** |
179 | - * @param $query |
|
179 | + * @param string $query |
|
180 | 180 | */ |
181 | 181 | protected function logQuery($query) { |
182 | 182 | if (!classSupernova::$config->debug) { |
@@ -306,10 +306,16 @@ discard block |
||
306 | 306 | } |
307 | 307 | |
308 | 308 | |
309 | + /** |
|
310 | + * @param string $query |
|
311 | + */ |
|
309 | 312 | public function doInsertComplex($query) { |
310 | 313 | return $this->doExecute($query); |
311 | 314 | } |
312 | 315 | |
316 | + /** |
|
317 | + * @param integer $replace |
|
318 | + */ |
|
313 | 319 | protected function doSet($table, $fieldsAndValues, $replace = DB_INSERT_PLAIN) { |
314 | 320 | $tableSafe = $this->db_escape($table); |
315 | 321 | $safeFieldsAndValues = implode(',', $this->safeFieldsEqualValues($fieldsAndValues)); |
@@ -342,6 +348,9 @@ discard block |
||
342 | 348 | return $this->doSet($table, $fieldsAndValues, $replace); |
343 | 349 | } |
344 | 350 | |
351 | + /** |
|
352 | + * @param string $table |
|
353 | + */ |
|
345 | 354 | public function doReplaceSet($table, $fieldsAndValues) { |
346 | 355 | return $this->doSet($table, $fieldsAndValues, DB_INSERT_REPLACE); |
347 | 356 | } |
@@ -376,7 +385,7 @@ discard block |
||
376 | 385 | * Values should be passed as-is |
377 | 386 | * |
378 | 387 | * @param string $table |
379 | - * @param array $fields |
|
388 | + * @param string[] $fields |
|
380 | 389 | * @param string[] $values |
381 | 390 | * |
382 | 391 | * @return array|bool|mysqli_result|null |
@@ -411,7 +420,7 @@ discard block |
||
411 | 420 | * Self-contained - means no params used |
412 | 421 | * Such queries usually used to make large amount of in-base calculations |
413 | 422 | * |
414 | - * @param $query |
|
423 | + * @param string $query |
|
415 | 424 | * |
416 | 425 | * @return array|bool|mysqli_result|null |
417 | 426 | */ |
@@ -419,6 +428,9 @@ discard block |
||
419 | 428 | return $this->doExecute($query); |
420 | 429 | } |
421 | 430 | |
431 | + /** |
|
432 | + * @param boolean $isOneRecord |
|
433 | + */ |
|
422 | 434 | protected function doUpdateWhere($table, $fieldsSet, $fieldsAdjust = array(), $where = array(), $isOneRecord = DB_RECORDS_ALL) { |
423 | 435 | $tableSafe = $this->db_escape($table); |
424 | 436 | |
@@ -442,10 +454,16 @@ discard block |
||
442 | 454 | return $this->doExecute($query); |
443 | 455 | } |
444 | 456 | |
457 | + /** |
|
458 | + * @param string $table |
|
459 | + */ |
|
445 | 460 | public function doUpdateRowSet($table, $fieldsAndValues, $where) { |
446 | 461 | return $this->doUpdateWhere($table, $fieldsAndValues, array(), $where, DB_RECORD_ONE); |
447 | 462 | } |
448 | 463 | |
464 | + /** |
|
465 | + * @param string $table |
|
466 | + */ |
|
449 | 467 | public function doUpdateTableSet($table, $fieldsAndValues, $where = array()) { |
450 | 468 | return $this->doUpdateWhere($table, $fieldsAndValues, array(), $where, DB_RECORDS_ALL); |
451 | 469 | } |
@@ -454,6 +472,9 @@ discard block |
||
454 | 472 | return $this->doUpdateWhere($table, $fieldsSet, $fieldsAdjust, $where, DB_RECORD_ONE); |
455 | 473 | } |
456 | 474 | |
475 | + /** |
|
476 | + * @param string $table |
|
477 | + */ |
|
457 | 478 | public function doUpdateTableAdjust($table, $fieldsSet, $fieldsAdjust, $where) { |
458 | 479 | return $this->doUpdateWhere($table, $fieldsSet, $fieldsAdjust, $where, DB_RECORDS_ALL); |
459 | 480 | } |
@@ -526,7 +547,7 @@ discard block |
||
526 | 547 | * |
527 | 548 | * Usually used for mallformed $where conditions |
528 | 549 | * |
529 | - * @param $table |
|
550 | + * @param string $table |
|
530 | 551 | * @param $where |
531 | 552 | * |
532 | 553 | * @return array|bool|mysqli_result|null |
@@ -693,6 +714,10 @@ discard block |
||
693 | 714 | } |
694 | 715 | |
695 | 716 | // TODO Заменить это на новый логгер |
717 | + |
|
718 | + /** |
|
719 | + * @param string $query |
|
720 | + */ |
|
696 | 721 | protected function security_watch_user_queries($query) { |
697 | 722 | global $user; |
698 | 723 | |
@@ -716,6 +741,9 @@ discard block |
||
716 | 741 | } |
717 | 742 | |
718 | 743 | |
744 | + /** |
|
745 | + * @param string $query |
|
746 | + */ |
|
719 | 747 | public function security_query_check_bad_words($query) { |
720 | 748 | if ($this->skipQueryCheck) { |
721 | 749 | return; |
@@ -118,6 +118,9 @@ |
||
118 | 118 | return classSupernova::$gc->cacheOperator->db_ins_record(LOC_UNIT, $set); |
119 | 119 | } |
120 | 120 | |
121 | + /** |
|
122 | + * @param integer $unit_location_type |
|
123 | + */ |
|
121 | 124 | public static function db_unit_list_delete($user_id = 0, $unit_location_type, $unit_location_id = 0, $unit_snid = 0) { |
122 | 125 | $where = array('unit_location_type' => $unit_location_type); |
123 | 126 | ($unit_location_id = idval($unit_location_id)) ? $where['unit_location_id'] = $unit_location_id : false; |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | |
12 | 12 | /** |
13 | 13 | * @param $adjust |
14 | - * @param $location |
|
14 | + * @param integer $location |
|
15 | 15 | * @param $object_id |
16 | 16 | */ |
17 | 17 | function db_change_units_perform($adjust, $location, $object_id) { |
@@ -32,7 +32,6 @@ discard block |
||
32 | 32 | * @param $user |
33 | 33 | * @param $planet |
34 | 34 | * @param array $unit_list |
35 | - * @param null $query |
|
36 | 35 | */ |
37 | 36 | function db_change_units(&$user, &$planet, $unit_list) { |
38 | 37 | $query = array( |
@@ -74,6 +73,9 @@ discard block |
||
74 | 73 | db_change_units_perform($query[LOC_USER], LOC_USER, $user['id']); |
75 | 74 | db_change_units_perform($query[LOC_PLANET], LOC_PLANET, $planet['id']); |
76 | 75 | } |
76 | +/** |
|
77 | + * @param string $table |
|
78 | + */ |
|
77 | 79 | function sn_db_perform($table, $values, $type = 'insert', $options = false) { |
78 | 80 | $field_set = ''; |
79 | 81 | |
@@ -163,6 +165,9 @@ discard block |
||
163 | 165 | |
164 | 166 | |
165 | 167 | |
168 | +/** |
|
169 | + * @param boolean $transaction_should_be_started |
|
170 | + */ |
|
166 | 171 | function sn_db_transaction_check($transaction_should_be_started = null) { |
167 | 172 | return classSupernova::$gc->db->getTransaction()->check($transaction_should_be_started); |
168 | 173 | } |