Jump to content

cmh

Members
  • Posts

    71
  • Joined

  • Last visited

Everything posted by cmh

  1. sure it's more important. Will waiting.
  2. Hello. I need to update privileges for users. [hided]
  3. Hello. For the first time I try to understand this topic, but there are questions.I create a test procedure DELIMITER // DROP procedure IF EXISTS UserExist // CREATE procedure UserExist (IN UserName VARCHAR(50), out RetMsg int) BEGIN SELECT id INTO RetMsg FROM Tab WHERE user = UserName; END; // DELIMITER ; DELIMITER // DROP procedure IF EXISTS SomeAuth // CREATE PROCEDURE SomeAuth (UserName VarCHAR(50)) BEGIN DECLARE pid int DEFAULT 0; DECLARE pMSG int DEFAULT 0; DECLARE pFile Mediumblob; DECLARE IsUser VARCHAR(20); set IsUser ='DefVal'; call UserExist(UserName, @pMSG); if pMSG = 0 then set pid = 0; else set pid = 1; end iF; select @pid, @pMSG ; END // DELIMITER ; call SomeAuth('xxxxxxxxxxxxxxxxx'); In return i have: and so, I do not understand why pid =<nul>? why not 0 (as default value) or 1 (as if statement).
  4. Looks like my account was suspended? Server Tommy.
  5. I think that I have poorly explained. I do not need the update time. I need a time when the value has got into the selection of the Select query. In other words, I'm trying to find the "Most Viewed" Values of particular field. (or somehow sorting by Viewed (selected in query))
  6. That is, there is a certain select query, it is necessary to determine when the last time it was found. the value fell into the sample. Of course we can : Create a Timestamp field = on update_current_timestamp field than update any field, but the user has only the Select Privileges. Is it possible to somehow realize?
  7. Krydos, on 03 Jan 2018 - 12:33 AM, said: .... I could recompile it manually but it would probably break all of the cpanel mysql functionality. What does this mean in fact? Problems with the backup/restore, phpmyadmin etc?
  8. Is it possible? if yes, where i can find certificates? is it Crt, Private key and CaB or something else? As always, I apologize for my English
  9. 12.12.2017 at 09:40 Pm (utc+1) 09.12.2017 at 08:13 pm (utc:1) It was then, that I had a problemFortunately, it was a few minutes. It was also 04:12:2017 At ~6PM (As I was told it was., A few hours, but I did not check.)I apologize for the translation.
  10. I did not have any more ideas, I tried all the options, but now I think the problem was that as a server I used Domain, not IP. In addition, I added CF. Let's see how it will help me. My main problem is that I could not Connect to MySql when the site Was down. You can give me a little more time to understand how this affects me? Then I'll write about the results and / or delete the mirror.
  11. May CloudFlare Help with MySql? The decision that I deleted the account is the final one? Or i need to wait for KryDos (I'm sorry if the nickname is not correct)
  12. https://www.helionet.org/index/topic/29691-solved-tommy-down/?do=findComment&comment=134302 My mirror used only When Tommy is down (MySQl) From post bellow, I thought that can create mirror. Unfortunately, the tomy are often unavailable for about an hour. So I'm trying to solve this problem. When the volume is unavailable, the data is taken from Ricky. You can make sure that these are simple rare requests. I do not overload the system
  13. Hello. Can you help me with auto mirroring? Master: cmh (tomy) Slave: mcmh (ricky). After read, please mask servers.
  14. Can you Send me Backup MySqL to my mail?
  15. Hey. My site also does not work (CP and MySQL) I can not understand what is the reason? I must donate to you $ 12? or what. i have visitors from many countrys
  16. As I see, the Tommy very often falls recently. Can I create a mirror site and base on another server? is it allowed by the rules?
  17. i use only one client (firebird) and did not change the password, and now the old password works. The problem happened when the hosting was down. and my client tried to connect. ( ~UTC 04.50)
  18. I get this message, I dont use cpannel, only mysql. Also i cant connect to mysql
  19. Thanks. Unfortunately, I have never worked with PHP and there is no certainty that Decod / Encode will be identical to mine. Although I use standard algorithms
  20. Now I have an exe that loads a certain encrypted File in Blob - Field.I want to implement this through the form on the site.That is: the user on the site fills the form, presses the button and my exe Encrypts the file and then sent it to the database.Is it possible to ? exe-win32 Of course, if I need to, I can provide the source code of my EXE (PM)
  21. Thanks, all looks good. Just 1 question and then mask it all again please.
  22. oops, think that you will start process of deleting. Ok, now i do it. as i can see, account is deleted.
×
×
  • Create New...