@@ -22,23 +22,23 @@ discard block |
||
| 22 | 22 | public string $file_unique_id; |
| 23 | 23 | |
| 24 | 24 | /** Optional. Document thumbnail as defined by sender */ |
| 25 | - public null|photoSize $thumbnail = null; |
|
| 25 | + public null | photoSize $thumbnail = null; |
|
| 26 | 26 | |
| 27 | 27 | /** Optional. Original filename as defined by sender */ |
| 28 | - public null|string $file_name = null; |
|
| 28 | + public null | string $file_name = null; |
|
| 29 | 29 | |
| 30 | 30 | /** Optional. MIME type of the file as defined by sender */ |
| 31 | - public null|string $mime_type = null; |
|
| 31 | + public null | string $mime_type = null; |
|
| 32 | 32 | |
| 33 | 33 | /** |
| 34 | 34 | * Optional. File size in bytes. It can be bigger than 2^31 and some programming languages may have |
| 35 | 35 | * difficulty/silent defects in interpreting it. But it has at most 52 significant bits, so a signed 64-bit |
| 36 | 36 | * integer or double-precision float type are safe for storing this value. |
| 37 | 37 | */ |
| 38 | - public null|int $file_size = null; |
|
| 38 | + public null | int $file_size = null; |
|
| 39 | 39 | |
| 40 | 40 | |
| 41 | - public function __construct(stdClass|null $object = null) { |
|
| 41 | + public function __construct(stdClass | null $object = null) { |
|
| 42 | 42 | if ($object != null) { |
| 43 | 43 | parent::__construct($object, self::subs); |
| 44 | 44 | } |
@@ -59,8 +59,8 @@ discard block |
||
| 59 | 59 | * |
| 60 | 60 | * @return bool|string string will be returned when destination doesn't set |
| 61 | 61 | */ |
| 62 | - public function download(string|null $destination = null): bool|string { |
|
| 63 | - return telegram::downloadFile($destination ?? $this->file_name ?? 'unknown.txt',$this->file_id); |
|
| 62 | + public function download(string | null $destination = null): bool | string { |
|
| 63 | + return telegram::downloadFile($destination ?? $this->file_name ?? 'unknown.txt', $this->file_id); |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | public function link(): string { |
@@ -18,7 +18,7 @@ |
||
| 18 | 18 | public string $description; |
| 19 | 19 | |
| 20 | 20 | |
| 21 | - public function __construct(stdClass|null $object = null) { |
|
| 21 | + public function __construct(stdClass | null $object = null) { |
|
| 22 | 22 | if ($object != null) { |
| 23 | 23 | parent::__construct($object, self::subs); |
| 24 | 24 | } |
@@ -38,34 +38,34 @@ discard block |
||
| 38 | 38 | public int $height; |
| 39 | 39 | |
| 40 | 40 | /** True, if the sticker is animated */ |
| 41 | - public null|bool $is_animated = null; |
|
| 41 | + public null | bool $is_animated = null; |
|
| 42 | 42 | |
| 43 | 43 | /** True, if the sticker is a video sticker */ |
| 44 | - public null|bool $is_video = null; |
|
| 44 | + public null | bool $is_video = null; |
|
| 45 | 45 | |
| 46 | 46 | /** Optional. Sticker thumbnail in the .WEBP or .JPG format */ |
| 47 | - public null|photoSize $thumbnail = null; |
|
| 47 | + public null | photoSize $thumbnail = null; |
|
| 48 | 48 | |
| 49 | 49 | /** Optional. Emoji associated with the sticker */ |
| 50 | - public null|string $emoji = null; |
|
| 50 | + public null | string $emoji = null; |
|
| 51 | 51 | |
| 52 | 52 | /** Optional. Name of the sticker set to which the sticker belongs */ |
| 53 | - public null|string $set_name = null; |
|
| 53 | + public null | string $set_name = null; |
|
| 54 | 54 | |
| 55 | 55 | /** Optional. Premium animation for the sticker, if the sticker is premium */ |
| 56 | - public null|file $premium_animation = null; |
|
| 56 | + public null | file $premium_animation = null; |
|
| 57 | 57 | |
| 58 | 58 | /** Optional. For mask stickers, the position where the mask should be placed */ |
| 59 | - public null|maskPosition $mask_position = null; |
|
| 59 | + public null | maskPosition $mask_position = null; |
|
| 60 | 60 | |
| 61 | 61 | /** Optional. For custom emoji stickers, unique identifier of the custom emoji */ |
| 62 | - public null|string $custom_emoji_id = null; |
|
| 62 | + public null | string $custom_emoji_id = null; |
|
| 63 | 63 | |
| 64 | 64 | /** Optional. File size in bytes */ |
| 65 | - public null|int $file_size = null; |
|
| 65 | + public null | int $file_size = null; |
|
| 66 | 66 | |
| 67 | 67 | |
| 68 | - public function __construct(stdClass|null $object = null) { |
|
| 68 | + public function __construct(stdClass | null $object = null) { |
|
| 69 | 69 | if ($object != null) { |
| 70 | 70 | parent::__construct($object, self::subs); |
| 71 | 71 | } |
@@ -86,8 +86,8 @@ discard block |
||
| 86 | 86 | * |
| 87 | 87 | * @return bool|string string will be returned when destination doesn't set |
| 88 | 88 | */ |
| 89 | - public function download(string|null $destination = null): bool|string { |
|
| 90 | - return telegram::downloadFile($destination ?? 'unknown.png',$this->file_id); |
|
| 89 | + public function download(string | null $destination = null): bool | string { |
|
| 90 | + return telegram::downloadFile($destination ?? 'unknown.png', $this->file_id); |
|
| 91 | 91 | } |
| 92 | 92 | |
| 93 | 93 | public function link(): string { |
@@ -812,30 +812,30 @@ discard block |
||
| 812 | 812 | 'getGameHighScores' => ['BPT\types\gameHighScore'] |
| 813 | 813 | ]; |
| 814 | 814 | |
| 815 | - public static function __callStatic (string $name, array $arguments) { |
|
| 815 | + public static function __callStatic(string $name, array $arguments) { |
|
| 816 | 816 | if (!$action = self::methodAction($name)) { |
| 817 | - logger::write("$name method is not supported",loggerTypes::ERROR); |
|
| 817 | + logger::write("$name method is not supported", loggerTypes::ERROR); |
|
| 818 | 818 | throw new bptException('METHOD_NOT_FOUND'); |
| 819 | 819 | } |
| 820 | 820 | self::checkArguments($arguments); |
| 821 | - self::keysName($action,$arguments); |
|
| 822 | - self::readyFile($action,$arguments); |
|
| 821 | + self::keysName($action, $arguments); |
|
| 822 | + self::readyFile($action, $arguments); |
|
| 823 | 823 | self::cleanArguments($arguments); |
| 824 | - self::setDefaults($action,$arguments); |
|
| 824 | + self::setDefaults($action, $arguments); |
|
| 825 | 825 | |
| 826 | 826 | if (isset($arguments['answer']) && $arguments['answer'] === true) { |
| 827 | 827 | unset($arguments['answer']); |
| 828 | 828 | if (!answer::isAnswered()) { |
| 829 | - return answer::init($action,$arguments); |
|
| 829 | + return answer::init($action, $arguments); |
|
| 830 | 830 | } |
| 831 | - logger::write('you can use answer mode only once for each webhook update, Others will be called like normal',loggerTypes::WARNING); |
|
| 831 | + logger::write('you can use answer mode only once for each webhook update, Others will be called like normal', loggerTypes::WARNING); |
|
| 832 | 832 | } |
| 833 | - $result = curl::init($action,$arguments); |
|
| 833 | + $result = curl::init($action, $arguments); |
|
| 834 | 834 | if (!is_object($result)) { |
| 835 | - logger::write("Telegram $action method failed : " . $result, loggerTypes::WARNING); |
|
| 835 | + logger::write("Telegram $action method failed : ".$result, loggerTypes::WARNING); |
|
| 836 | 836 | return false; |
| 837 | 837 | } |
| 838 | - return self::processResponse($action,$result); |
|
| 838 | + return self::processResponse($action, $result); |
|
| 839 | 839 | } |
| 840 | 840 | |
| 841 | 841 | private static function checkArguments(array &$arguments): void { |
@@ -844,7 +844,7 @@ discard block |
||
| 844 | 844 | } |
| 845 | 845 | } |
| 846 | 846 | |
| 847 | - private static function keysName (string $name, array &$arguments): void { |
|
| 847 | + private static function keysName(string $name, array &$arguments): void { |
|
| 848 | 848 | foreach ($arguments as $key => $argument) { |
| 849 | 849 | if (is_numeric($key) && isset(self::METHODS_KEYS[$name][$key])) { |
| 850 | 850 | $arguments[self::METHODS_KEYS[$name][$key]] = $argument; |
@@ -853,7 +853,7 @@ discard block |
||
| 853 | 853 | } |
| 854 | 854 | } |
| 855 | 855 | |
| 856 | - private static function methodAction(string $name): string|false { |
|
| 856 | + private static function methodAction(string $name): string | false { |
|
| 857 | 857 | return self::METHODS_ACTION[str_replace('_', '', strtolower($name))] ?? false; |
| 858 | 858 | } |
| 859 | 859 | |
@@ -886,11 +886,11 @@ discard block |
||
| 886 | 886 | } |
| 887 | 887 | } |
| 888 | 888 | |
| 889 | - private static function methodFile(string $name): array|false { |
|
| 889 | + private static function methodFile(string $name): array | false { |
|
| 890 | 890 | return self::METHODS_WITH_FILE[$name] ?? false; |
| 891 | 891 | } |
| 892 | 892 | |
| 893 | - private static function methodReturn(string $name,stdClass $response) { |
|
| 893 | + private static function methodReturn(string $name, stdClass $response) { |
|
| 894 | 894 | if (!isset(self::METHODS_RETURN[$name])) { |
| 895 | 895 | return $response->result; |
| 896 | 896 | } |
@@ -909,13 +909,13 @@ discard block |
||
| 909 | 909 | $defaults = self::METHODS_EXTRA_DEFAULTS[$name]; |
| 910 | 910 | foreach ($defaults as $key => $default) { |
| 911 | 911 | if (is_numeric($key)) { |
| 912 | - if (!isset($arguments[$default])){ |
|
| 912 | + if (!isset($arguments[$default])) { |
|
| 913 | 913 | $arguments[$default] = self::catchFields($default); |
| 914 | 914 | } |
| 915 | 915 | } |
| 916 | 916 | elseif (isset(BPT::$update->$key) || $key === 'other') { |
| 917 | 917 | foreach ($default as $def) { |
| 918 | - if (!isset($arguments[$def])){ |
|
| 918 | + if (!isset($arguments[$def])) { |
|
| 919 | 919 | $arguments[$def] = self::catchFields($def); |
| 920 | 920 | } |
| 921 | 921 | } |
@@ -934,13 +934,13 @@ discard block |
||
| 934 | 934 | self::$status = $response->ok; |
| 935 | 935 | self::$pure_response = $response; |
| 936 | 936 | if (!$response->ok) { |
| 937 | - logger::write("Telegram $name method failed : " . json_encode($response), loggerTypes::WARNING); |
|
| 937 | + logger::write("Telegram $name method failed : ".json_encode($response), loggerTypes::WARNING); |
|
| 938 | 938 | return new responseError($response); |
| 939 | 939 | } |
| 940 | - return self::methodReturn($name,$response); |
|
| 940 | + return self::methodReturn($name, $response); |
|
| 941 | 941 | } |
| 942 | 942 | |
| 943 | - private static function cleanArguments (array &$arguments): void { |
|
| 943 | + private static function cleanArguments(array &$arguments): void { |
|
| 944 | 944 | foreach ($arguments as $key => $argument) { |
| 945 | 945 | if ($argument == [] || $argument === null) { |
| 946 | 946 | unset($arguments[$key]); |
@@ -955,7 +955,7 @@ discard block |
||
| 955 | 955 | * |
| 956 | 956 | * @return int|string|bool |
| 957 | 957 | */ |
| 958 | - public static function catchFields (string $field): int|string|bool { |
|
| 958 | + public static function catchFields(string $field): int | string | bool { |
|
| 959 | 959 | switch ($field) { |
| 960 | 960 | case fields::CHAT_ID : |
| 961 | 961 | case fields::FROM_CHAT_ID : |
@@ -1102,13 +1102,13 @@ discard block |
||
| 1102 | 1102 | default => false |
| 1103 | 1103 | }; |
| 1104 | 1104 | case fields::URL : |
| 1105 | - return 'https://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']; |
|
| 1105 | + return 'https://'.$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']; |
|
| 1106 | 1106 | default: |
| 1107 | 1107 | return false; |
| 1108 | 1108 | } |
| 1109 | 1109 | } |
| 1110 | 1110 | |
| 1111 | - public static function fileLink (string|null $file_id = null): bool|string { |
|
| 1111 | + public static function fileLink(string | null $file_id = null): bool | string { |
|
| 1112 | 1112 | $file = request::getFile($file_id); |
| 1113 | 1113 | if (!isset($file->file_path)) { |
| 1114 | 1114 | return false; |
@@ -1130,7 +1130,7 @@ discard block |
||
| 1130 | 1130 | * |
| 1131 | 1131 | * @return bool |
| 1132 | 1132 | */ |
| 1133 | - public static function downloadFile (string|null $destination = null, string|null $file_id = null): bool { |
|
| 1133 | + public static function downloadFile(string | null $destination = null, string | null $file_id = null): bool { |
|
| 1134 | 1134 | return tools::downloadFile(self::fileLink($file_id), $destination); |
| 1135 | 1135 | } |
| 1136 | 1136 | |
@@ -1148,10 +1148,10 @@ discard block |
||
| 1148 | 1148 | * |
| 1149 | 1149 | * @return message|bool|responseError |
| 1150 | 1150 | */ |
| 1151 | - public static function sendFile (string $file_id, int|string $chat_id = null, int $message_thread_id = null, string $caption = null, string $parse_mode = null, array $caption_entities = null, bool $disable_notification = null, bool $protect_content = null, int $reply_to_message_id = null, bool $allow_sending_without_reply = null, inlineKeyboardMarkup|replyKeyboardMarkup|replyKeyboardRemove|forceReply|stdClass|array $reply_markup = null, string $token = null, bool $forgot = null, bool $answer = null): message|bool|responseError { |
|
| 1151 | + public static function sendFile(string $file_id, int | string $chat_id = null, int $message_thread_id = null, string $caption = null, string $parse_mode = null, array $caption_entities = null, bool $disable_notification = null, bool $protect_content = null, int $reply_to_message_id = null, bool $allow_sending_without_reply = null, inlineKeyboardMarkup | replyKeyboardMarkup | replyKeyboardRemove | forceReply | stdClass | array $reply_markup = null, string $token = null, bool $forgot = null, bool $answer = null): message | bool | responseError { |
|
| 1152 | 1152 | $type = tools::fileType($file_id); |
| 1153 | 1153 | return match ($type) { |
| 1154 | - fileTypes::VIDEO => request::sendVideo($file_id, $chat_id, $message_thread_id, null, null, null, null, $caption, $parse_mode, $caption_entities, false,null, $disable_notification, $protect_content, $reply_to_message_id, $allow_sending_without_reply, $reply_markup, $token, $forgot, $answer), |
|
| 1154 | + fileTypes::VIDEO => request::sendVideo($file_id, $chat_id, $message_thread_id, null, null, null, null, $caption, $parse_mode, $caption_entities, false, null, $disable_notification, $protect_content, $reply_to_message_id, $allow_sending_without_reply, $reply_markup, $token, $forgot, $answer), |
|
| 1155 | 1155 | fileTypes::VIDEO_NOTE => request::sendVideoNote($file_id, $chat_id, $message_thread_id, null, null, null, $disable_notification, $protect_content, $reply_to_message_id, $allow_sending_without_reply, $reply_markup, $token, $forgot, $answer), |
| 1156 | 1156 | fileTypes::ANIMATION => request::sendAnimation($file_id, $chat_id, $message_thread_id, null, null, null, null, $caption, $parse_mode, $caption_entities, false, $disable_notification, $protect_content, $reply_to_message_id, $allow_sending_without_reply, $reply_markup, $token, $forgot, $answer), |
| 1157 | 1157 | fileTypes::AUDIO => request::sendAudio($file_id, $chat_id, $message_thread_id, $caption, $parse_mode, $caption_entities, null, null, null, null, $disable_notification, $protect_content, $reply_to_message_id, $allow_sending_without_reply, $reply_markup, $token, $forgot, $answer), |
@@ -290,13 +290,13 @@ discard block |
||
| 290 | 290 | * @method gameHighScore[]|responseError getGameHighScores (int|array|null $user_id = null, int|null $chat_id = null, int|null $message_id = null, string|null $inline_message_id = null, string|null $token = null, bool|null $forgot = null, bool|null $answer = null) Use this method to get data for high score tables. Will return the score of the specified user and several of their neighbors in a game. Returns an Array of GameHighScore objects. |
| 291 | 291 | * @method gameHighScore[]|responseError getGameHigh (int|array|null $user_id = null, int|null $chat_id = null, int|null $message_id = null, string|null $inline_message_id = null, string|null $token = null, bool|null $forgot = null, bool|null $answer = null) Use this method to get data for high score tables. Will return the score of the specified user and several of their neighbors in a game. Returns an Array of GameHighScore objects. |
| 292 | 292 | */ |
| 293 | -class BPT extends telegram{ |
|
| 293 | +class BPT extends telegram { |
|
| 294 | 294 | public static update $update; |
| 295 | 295 | |
| 296 | 296 | public static BPT $handler; |
| 297 | 297 | |
| 298 | 298 | |
| 299 | - public function __construct (array|stdClass $settings) { |
|
| 299 | + public function __construct(array | stdClass $settings) { |
|
| 300 | 300 | static::$handler = &$this; |
| 301 | 301 | settings::init($settings); |
| 302 | 302 | } |
@@ -306,7 +306,7 @@ discard block |
||
| 306 | 306 | } |
| 307 | 307 | |
| 308 | 308 | #[NoReturn] |
| 309 | - public static function exit (string|null $message = null) { |
|
| 309 | + public static function exit (string | null $message = null) { |
|
| 310 | 310 | die($message ?? "<div style='width:98vw;height:98vh;display:flex;justify-content:center;align-items:center;font-size:25vw'>BPT</div>"); |
| 311 | 311 | } |
| 312 | 312 | } |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | /** |
| 30 | 30 | * If you want to use it in standalone mode , you MUST set `auto_process` to `false` |
| 31 | 31 | */ |
| 32 | - public static function init (string $host = 'localhost', string $username = 'root', string $password = '', string $dbname = '', bool $auto_process = null, int $port = 3306): void { |
|
| 32 | + public static function init(string $host = 'localhost', string $username = 'root', string $password = '', string $dbname = '', bool $auto_process = null, int $port = 3306): void { |
|
| 33 | 33 | $host = settings::$db['host'] ?? $host; |
| 34 | 34 | $port = settings::$db['port'] ?? $port; |
| 35 | 35 | $user = settings::$db['user'] ?? settings::$db['username'] ?? $username; |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | self::$db_name = $dbname; |
| 40 | 40 | self::$connection = new mysqli($host, $user, $pass, $dbname, $port); |
| 41 | 41 | if (self::$connection->connect_errno) { |
| 42 | - logger::write('SQL connection has problem : ' . self::$connection->connect_error, loggerTypes::ERROR); |
|
| 42 | + logger::write('SQL connection has problem : '.self::$connection->connect_error, loggerTypes::ERROR); |
|
| 43 | 43 | throw new bptException('SQL_CONNECTION_PROBLEM'); |
| 44 | 44 | } |
| 45 | 45 | if (self::$auto_process && !lock::exist('BPT-MYSQL')) { |
@@ -47,7 +47,7 @@ discard block |
||
| 47 | 47 | } |
| 48 | 48 | } |
| 49 | 49 | |
| 50 | - private static function install (): void { |
|
| 50 | + private static function install(): void { |
|
| 51 | 51 | self::pureQuery(" |
| 52 | 52 | CREATE TABLE `users` |
| 53 | 53 | ( |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | /** |
| 69 | 69 | * @internal Only for BPT self usage , Don't use it in your source! |
| 70 | 70 | */ |
| 71 | - public static function process (): void { |
|
| 71 | + public static function process(): void { |
|
| 72 | 72 | if (self::$auto_process) { |
| 73 | 73 | if (isset(BPT::$update->message)) { |
| 74 | 74 | self::processMessage(BPT::$update->message); |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | } |
| 89 | 89 | } |
| 90 | 90 | |
| 91 | - private static function processMessage (message $update): void { |
|
| 91 | + private static function processMessage(message $update): void { |
|
| 92 | 92 | $type = $update->chat->type; |
| 93 | 93 | if ($type === chatType::PRIVATE) { |
| 94 | 94 | $user_id = $update->from->id; |
@@ -114,7 +114,7 @@ discard block |
||
| 114 | 114 | } |
| 115 | 115 | } |
| 116 | 116 | |
| 117 | - private static function processCallbackQuery (callbackQuery $update): void { |
|
| 117 | + private static function processCallbackQuery(callbackQuery $update): void { |
|
| 118 | 118 | $type = $update->message->chat->type; |
| 119 | 119 | if ($type === chatType::PRIVATE) { |
| 120 | 120 | $user_id = $update->from->id; |
@@ -124,7 +124,7 @@ discard block |
||
| 124 | 124 | } |
| 125 | 125 | } |
| 126 | 126 | |
| 127 | - private static function processInlineQuery (inlineQuery $update): void { |
|
| 127 | + private static function processInlineQuery(inlineQuery $update): void { |
|
| 128 | 128 | $type = $update->chat_type; |
| 129 | 129 | if ($type === chatType::PRIVATE || $type === chatType::SENDER) { |
| 130 | 130 | $user_id = $update->from->id; |
@@ -134,7 +134,7 @@ discard block |
||
| 134 | 134 | } |
| 135 | 135 | } |
| 136 | 136 | |
| 137 | - private static function processMyChatMember (chatMemberUpdated $update): void { |
|
| 137 | + private static function processMyChatMember(chatMemberUpdated $update): void { |
|
| 138 | 138 | $type = $update->chat->type; |
| 139 | 139 | if ($type === chatType::PRIVATE) { |
| 140 | 140 | if ($update->new_chat_member->status === chatMemberStatus::MEMBER) { |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | * |
| 152 | 152 | * @return mysqli |
| 153 | 153 | */ |
| 154 | - public static function getMysqli (): mysqli { |
|
| 154 | + public static function getMysqli(): mysqli { |
|
| 155 | 155 | return self::$connection; |
| 156 | 156 | } |
| 157 | 157 | |
@@ -162,7 +162,7 @@ discard block |
||
| 162 | 162 | * |
| 163 | 163 | * @return int|string |
| 164 | 164 | */ |
| 165 | - public static function affected_rows (): int|string { |
|
| 165 | + public static function affected_rows(): int | string { |
|
| 166 | 166 | return self::$connection->affected_rows; |
| 167 | 167 | } |
| 168 | 168 | |
@@ -173,7 +173,7 @@ discard block |
||
| 173 | 173 | * |
| 174 | 174 | * @return int|string |
| 175 | 175 | */ |
| 176 | - public static function affectedRows (): int|string { |
|
| 176 | + public static function affectedRows(): int | string { |
|
| 177 | 177 | return self::$connection->affected_rows; |
| 178 | 178 | } |
| 179 | 179 | |
@@ -184,7 +184,7 @@ discard block |
||
| 184 | 184 | * |
| 185 | 185 | * @return int|string |
| 186 | 186 | */ |
| 187 | - public static function insert_id (): int|string { |
|
| 187 | + public static function insert_id(): int | string { |
|
| 188 | 188 | return self::$connection->insert_id; |
| 189 | 189 | } |
| 190 | 190 | |
@@ -195,7 +195,7 @@ discard block |
||
| 195 | 195 | * |
| 196 | 196 | * @return int|string |
| 197 | 197 | */ |
| 198 | - public static function insertId (): int|string { |
|
| 198 | + public static function insertId(): int | string { |
|
| 199 | 199 | return self::$connection->insert_id; |
| 200 | 200 | } |
| 201 | 201 | |
@@ -206,7 +206,7 @@ discard block |
||
| 206 | 206 | * |
| 207 | 207 | * @return string |
| 208 | 208 | */ |
| 209 | - public static function escapeString (string $text): string { |
|
| 209 | + public static function escapeString(string $text): string { |
|
| 210 | 210 | return self::$connection->real_escape_string($text); |
| 211 | 211 | } |
| 212 | 212 | |
@@ -215,7 +215,7 @@ discard block |
||
| 215 | 215 | * |
| 216 | 216 | * @return string |
| 217 | 217 | */ |
| 218 | - public static function error (): string { |
|
| 218 | + public static function error(): string { |
|
| 219 | 219 | return self::$connection->error; |
| 220 | 220 | } |
| 221 | 221 | |
@@ -224,7 +224,7 @@ discard block |
||
| 224 | 224 | * |
| 225 | 225 | * @return int |
| 226 | 226 | */ |
| 227 | - public static function errno (): int { |
|
| 227 | + public static function errno(): int { |
|
| 228 | 228 | return self::$connection->errno; |
| 229 | 229 | } |
| 230 | 230 | |
@@ -235,7 +235,7 @@ discard block |
||
| 235 | 235 | * |
| 236 | 236 | * @return bool |
| 237 | 237 | */ |
| 238 | - public static function setCharset (string $charset): bool { |
|
| 238 | + public static function setCharset(string $charset): bool { |
|
| 239 | 239 | return self::$connection->set_charset($charset); |
| 240 | 240 | } |
| 241 | 241 | |
@@ -250,7 +250,7 @@ discard block |
||
| 250 | 250 | * |
| 251 | 251 | * @return mysqli_result|bool |
| 252 | 252 | */ |
| 253 | - public static function pureQuery (string $query): mysqli_result|bool { |
|
| 253 | + public static function pureQuery(string $query): mysqli_result | bool { |
|
| 254 | 254 | return self::$connection->query($query); |
| 255 | 255 | } |
| 256 | 256 | |
@@ -271,7 +271,7 @@ discard block |
||
| 271 | 271 | * |
| 272 | 272 | * @return mysqli_result|bool |
| 273 | 273 | */ |
| 274 | - public static function query (string $query, array $vars = [], bool $need_result = true): mysqli_result|bool { |
|
| 274 | + public static function query(string $query, array $vars = [], bool $need_result = true): mysqli_result | bool { |
|
| 275 | 275 | if (empty($vars)) { |
| 276 | 276 | return self::pureQuery($query); |
| 277 | 277 | } |
@@ -288,7 +288,7 @@ discard block |
||
| 288 | 288 | $types .= 's'; |
| 289 | 289 | } |
| 290 | 290 | } |
| 291 | - $prepare->bind_param($types,...$vars); |
|
| 291 | + $prepare->bind_param($types, ...$vars); |
|
| 292 | 292 | if (!$prepare->execute()) { |
| 293 | 293 | logger::write(loggerTypes::WARNING, $prepare->error); |
| 294 | 294 | return false; |
@@ -319,8 +319,8 @@ discard block |
||
| 319 | 319 | continue; |
| 320 | 320 | } |
| 321 | 321 | |
| 322 | - $operator = substr($value,0,2); |
|
| 323 | - $operator_value = substr($value,2); |
|
| 322 | + $operator = substr($value, 0, 2); |
|
| 323 | + $operator_value = substr($value, 2); |
|
| 324 | 324 | switch ($operator) { |
| 325 | 325 | case '>=': |
| 326 | 326 | $query .= " `$name` >= ?"; |
@@ -357,17 +357,17 @@ discard block |
||
| 357 | 357 | return $values; |
| 358 | 358 | } |
| 359 | 359 | |
| 360 | - private static function groupByBuilder(string &$query, string|array $group_by = []): void { |
|
| 360 | + private static function groupByBuilder(string &$query, string | array $group_by = []): void { |
|
| 361 | 361 | if (empty($group_by)) { |
| 362 | 362 | return; |
| 363 | 363 | } |
| 364 | 364 | if (is_string($group_by)) { |
| 365 | 365 | $group_by = [$group_by]; |
| 366 | 366 | } |
| 367 | - $query .= ' GROUP BY `' . implode('`, `',$group_by) . '`'; |
|
| 367 | + $query .= ' GROUP BY `'.implode('`, `', $group_by).'`'; |
|
| 368 | 368 | } |
| 369 | 369 | |
| 370 | - private static function orderByBuilder(string &$query, string|array $order_by = []): void { |
|
| 370 | + private static function orderByBuilder(string &$query, string | array $order_by = []): void { |
|
| 371 | 371 | if (empty($order_by)) { |
| 372 | 372 | return; |
| 373 | 373 | } |
@@ -420,8 +420,8 @@ discard block |
||
| 420 | 420 | continue; |
| 421 | 421 | } |
| 422 | 422 | |
| 423 | - $operator = substr($value,0,2); |
|
| 424 | - $operator_value = substr($value,2); |
|
| 423 | + $operator = substr($value, 0, 2); |
|
| 424 | + $operator_value = substr($value, 2); |
|
| 425 | 425 | switch ($operator) { |
| 426 | 426 | case '+=': |
| 427 | 427 | $query .= " `$name` = `$name` + ?"; |
@@ -454,19 +454,19 @@ discard block |
||
| 454 | 454 | return $values; |
| 455 | 455 | } |
| 456 | 456 | |
| 457 | - private static function insertBuilder(string &$query, string|array $columns, array|string $values): array { |
|
| 458 | - $query .= '(`' . (is_string($columns) ? $columns : implode('`,`', $columns)) . '`) VALUES ('; |
|
| 457 | + private static function insertBuilder(string &$query, string | array $columns, array | string $values): array { |
|
| 458 | + $query .= '(`'.(is_string($columns) ? $columns : implode('`,`', $columns)).'`) VALUES ('; |
|
| 459 | 459 | if (is_string($values)) $values = [$values]; |
| 460 | - $query .= '?' . str_repeat(',?', count($values) - 1) . ')'; |
|
| 460 | + $query .= '?'.str_repeat(',?', count($values) - 1).')'; |
|
| 461 | 461 | return $values; |
| 462 | 462 | } |
| 463 | 463 | |
| 464 | - private static function selectBuilder(string &$query, string|array $columns): void { |
|
| 464 | + private static function selectBuilder(string &$query, string | array $columns): void { |
|
| 465 | 465 | if ($columns == '*') { |
| 466 | 466 | $query .= " * "; |
| 467 | 467 | } |
| 468 | 468 | else { |
| 469 | - $query .= ' `' . (is_string($columns) ? $columns : implode('`,`', $columns)) . '` '; |
|
| 469 | + $query .= ' `'.(is_string($columns) ? $columns : implode('`,`', $columns)).'` '; |
|
| 470 | 470 | } |
| 471 | 471 | } |
| 472 | 472 | |
@@ -482,7 +482,7 @@ discard block |
||
| 482 | 482 | * |
| 483 | 483 | * @return bool |
| 484 | 484 | */ |
| 485 | - public static function delete (string $table, array $where = null, int $count = null, int $offset = null): bool { |
|
| 485 | + public static function delete(string $table, array $where = null, int $count = null, int $offset = null): bool { |
|
| 486 | 486 | $query = "DELETE FROM `$table`"; |
| 487 | 487 | $vars = self::whereBuilder($query, $where); |
| 488 | 488 | return self::query($query, $vars, false); |
@@ -501,7 +501,7 @@ discard block |
||
| 501 | 501 | * |
| 502 | 502 | * @return bool |
| 503 | 503 | */ |
| 504 | - public static function update (string $table, array $modify, array $where = null, int $count = null, int $offset = null): bool { |
|
| 504 | + public static function update(string $table, array $modify, array $where = null, int $count = null, int $offset = null): bool { |
|
| 505 | 505 | $query = "UPDATE `$table` SET"; |
| 506 | 506 | $modify_vars = self::updateBuilder($query, $modify); |
| 507 | 507 | $where_vars = self::whereBuilder($query, $where); |
@@ -520,7 +520,7 @@ discard block |
||
| 520 | 520 | * |
| 521 | 521 | * @return bool |
| 522 | 522 | */ |
| 523 | - public static function insert (string $table, string|array $columns, array|string $values): bool { |
|
| 523 | + public static function insert(string $table, string | array $columns, array | string $values): bool { |
|
| 524 | 524 | $query = "INSERT INTO `$table`"; |
| 525 | 525 | $values = self::insertBuilder($query, $columns, $values); |
| 526 | 526 | return self::query($query, $values, false); |
@@ -543,14 +543,14 @@ discard block |
||
| 543 | 543 | * |
| 544 | 544 | * @return mysqli_result|bool |
| 545 | 545 | */ |
| 546 | - public static function select (string $table, array|string $columns = '*', array $where = null, int $count = null, int $offset = null, array|string $group_by = [], array|string $order_by = []): mysqli_result|bool { |
|
| 546 | + public static function select(string $table, array | string $columns = '*', array $where = null, int $count = null, int $offset = null, array | string $group_by = [], array | string $order_by = []): mysqli_result | bool { |
|
| 547 | 547 | $query = "SELECT"; |
| 548 | 548 | self::selectBuilder($query, $columns); |
| 549 | 549 | $query .= "FROM `$table`"; |
| 550 | - $var = self::whereBuilder($query,$where); |
|
| 550 | + $var = self::whereBuilder($query, $where); |
|
| 551 | 551 | self::groupByBuilder($query, $group_by); |
| 552 | 552 | self::orderByBuilder($query, $order_by); |
| 553 | - self::countBuilder($query,$count,$offset); |
|
| 553 | + self::countBuilder($query, $count, $offset); |
|
| 554 | 554 | return self::query($query, $var); |
| 555 | 555 | } |
| 556 | 556 | |
@@ -567,7 +567,7 @@ discard block |
||
| 567 | 567 | * |
| 568 | 568 | * @return null|bool|array |
| 569 | 569 | */ |
| 570 | - public static function selectArray (string $table, array|string $columns = '*', array $where = null, array|string $group_by = [], array|string $order_by = []): bool|array|null { |
|
| 570 | + public static function selectArray(string $table, array | string $columns = '*', array $where = null, array | string $group_by = [], array | string $order_by = []): bool | array | null { |
|
| 571 | 571 | $res = self::select($table, $columns, $where, 1, $group_by, $order_by); |
| 572 | 572 | if ($res) { |
| 573 | 573 | return $res->fetch_assoc(); |
@@ -586,7 +586,7 @@ discard block |
||
| 586 | 586 | * @param array|string $group_by group result based on these columns |
| 587 | 587 | * @param array|string $order_by order result based on these columns |
| 588 | 588 | */ |
| 589 | - public static function selectObject (string $table, array|string $columns = '*', array $where = null, array|string $group_by = [], array|string $order_by = []) { |
|
| 589 | + public static function selectObject(string $table, array | string $columns = '*', array $where = null, array | string $group_by = [], array | string $order_by = []) { |
|
| 590 | 590 | $res = self::select($table, $columns, $where, 1, $group_by, $order_by); |
| 591 | 591 | if ($res) { |
| 592 | 592 | return $res->fetch_object(); |
@@ -610,7 +610,7 @@ discard block |
||
| 610 | 610 | * |
| 611 | 611 | * @return bool|Generator |
| 612 | 612 | */ |
| 613 | - public static function selectEach (string $table, array|string $columns = '*', array $where = null, int $count = null, int $offset = null, array|string $group_by = [], array|string $order_by = []): bool|Generator { |
|
| 613 | + public static function selectEach(string $table, array | string $columns = '*', array $where = null, int $count = null, int $offset = null, array | string $group_by = [], array | string $order_by = []): bool | Generator { |
|
| 614 | 614 | $res = self::select($table, $columns, $where, $count, $offset, $group_by, $order_by); |
| 615 | 615 | if ($res) { |
| 616 | 616 | while ($row = $res->fetch_assoc()) yield $row; |
@@ -628,10 +628,10 @@ discard block |
||
| 628 | 628 | * |
| 629 | 629 | * @return string if save is true , return file name otherwise return sql data |
| 630 | 630 | */ |
| 631 | - public static function backup (array $wanted_tables = null, bool $table_data = true, bool $save = true, string $file_name = ''): string { |
|
| 631 | + public static function backup(array $wanted_tables = null, bool $table_data = true, bool $save = true, string $file_name = ''): string { |
|
| 632 | 632 | self::setCharset('utf8mb4'); |
| 633 | 633 | |
| 634 | - $tables = array_column(self::query('SHOW TABLES')->fetch_all(),0); |
|
| 634 | + $tables = array_column(self::query('SHOW TABLES')->fetch_all(), 0); |
|
| 635 | 635 | if (!empty($wanted_tables)) { |
| 636 | 636 | $tables = array_intersect($tables, $wanted_tables); |
| 637 | 637 | } |
@@ -642,12 +642,12 @@ discard block |
||
| 642 | 642 | logger::write('No table founded for backup, if your database has table : check $wanted_tables argument', loggerTypes::WARNING); |
| 643 | 643 | } |
| 644 | 644 | foreach ($tables as $table) { |
| 645 | - $sql .= self::query("SHOW CREATE TABLE `$table`")->fetch_row()[1] . ";\n\n"; |
|
| 645 | + $sql .= self::query("SHOW CREATE TABLE `$table`")->fetch_row()[1].";\n\n"; |
|
| 646 | 646 | if ($table_data) { |
| 647 | 647 | $total_rows = self::query("SELECT COUNT(*) as `cnt` FROM `$table`")->fetch_object()->cnt; |
| 648 | 648 | for ($i = 0; $i < $total_rows; $i = $i + 1000) { |
| 649 | - $sql .= "INSERT INTO " . $table . " VALUES"; |
|
| 650 | - $result = self::select($table, '*' , null, 1000, $i); |
|
| 649 | + $sql .= "INSERT INTO ".$table." VALUES"; |
|
| 650 | + $result = self::select($table, '*', null, 1000, $i); |
|
| 651 | 651 | $field_count = $result->field_count; |
| 652 | 652 | $affected_rows = self::affected_rows(); |
| 653 | 653 | $counter = 1; |
@@ -655,12 +655,12 @@ discard block |
||
| 655 | 655 | $sql .= "\n("; |
| 656 | 656 | for ($column = 0; $column < $field_count; $column++) { |
| 657 | 657 | $row[$column] = str_replace("\n", "\\n", addslashes($row[$column])); |
| 658 | - $sql .= !empty($row[$column]) ? '"' . $row[$column] . '"' : '""'; |
|
| 658 | + $sql .= !empty($row[$column]) ? '"'.$row[$column].'"' : '""'; |
|
| 659 | 659 | if ($column < $field_count - 1) { |
| 660 | 660 | $sql .= ','; |
| 661 | 661 | } |
| 662 | 662 | } |
| 663 | - $sql .= ')' . ($counter == $affected_rows ? ';' : ','); |
|
| 663 | + $sql .= ')'.($counter == $affected_rows ? ';' : ','); |
|
| 664 | 664 | $counter++; |
| 665 | 665 | } |
| 666 | 666 | } |
@@ -676,7 +676,7 @@ discard block |
||
| 676 | 676 | } |
| 677 | 677 | |
| 678 | 678 | if (empty($file_name)) { |
| 679 | - $file_name = self::$db_name . time() . '.sql'; |
|
| 679 | + $file_name = self::$db_name.time().'.sql'; |
|
| 680 | 680 | } |
| 681 | 681 | file_put_contents($file_name, $sql); |
| 682 | 682 | return $file_name; |