Jump to content

ItsMTC

Member
  • Posts

    32
  • Joined

  • Last visited

Reputation Activity

  1. Informative
    ItsMTC got a reaction from Hip in VBA Datatype Declaration of Function   
    The actual way that VBA determines the return value of a function that doesn't explicitly declare it is somewhat ambiguous in their documentation. In general, you should always declare a function's return type in its signature (and you can force yourself to do this by setting "Option Explicit" at the top of the VBA doc.
     
    There are different ways you could get Excel worksheet data into this function, but in my opinion yes you should probably create function arguments (the variables within the ()s ) and pass any data that your function will use into those.
  2. Agree
    ItsMTC got a reaction from Dabombinable in Sony announces new 4K network security camera   
    Jesus the storage solution just to handle 4k 30fps continuous will be expensive; seems like an overkill solution personally.
  3. Agree
    ItsMTC got a reaction from ChineseChef in Sony announces new 4K network security camera   
    Jesus the storage solution just to handle 4k 30fps continuous will be expensive; seems like an overkill solution personally.
  4. Agree
    ItsMTC got a reaction from thunderdog512 in Sony announces new 4K network security camera   
    Jesus the storage solution just to handle 4k 30fps continuous will be expensive; seems like an overkill solution personally.
  5. Like
    ItsMTC got a reaction from ekv in php sending emails....   
    Php is compiled serverside and executed, so no the client never sees the source code. So theoretically you are fine having passwords and such like that, just make sure its not uploded as something that wont be compiled by the server like a text file or something, oh and don't put it up on github.
  6. Like
    ItsMTC got a reaction from //FTP in php sending emails....   
    Php is compiled serverside and executed, so no the client never sees the source code. So theoretically you are fine having passwords and such like that, just make sure its not uploded as something that wont be compiled by the server like a text file or something, oh and don't put it up on github.
  7. Like
    ItsMTC got a reaction from Blade of Grass in php sending emails....   
    Php is compiled serverside and executed, so no the client never sees the source code. So theoretically you are fine having passwords and such like that, just make sure its not uploded as something that wont be compiled by the server like a text file or something, oh and don't put it up on github.
  8. Like
    ItsMTC got a reaction from lubblig in php sending emails....   
    Php is compiled serverside and executed, so no the client never sees the source code. So theoretically you are fine having passwords and such like that, just make sure its not uploded as something that wont be compiled by the server like a text file or something, oh and don't put it up on github.
  9. Like
    ItsMTC got a reaction from burnttoastnice in Retreiving data from a website (HTML) in C#   
    I actually have a decent amount of practice with this! Alright, so to start off you need to get the raw html from the website that you want. The simplest implementation I have for that is as follows:
    public static string retrieveData(string url) { WebClient connection = new WebClient(); return connection.DownloadString(url); } This is used in a static environment, such as static class, not an object (although you could use it in that way by removing static).
     
    Now to find and extract the stuff you want is a bit tricky to explain without knowing the page and the format, but usually how I go about this is find a string that occurs before what you want and after what you want. So for example if your data is 
    <div class="specialclass">THIS IS WHAT YOU WANT</div> Then the two strings you will use is <div class="specialclass"> and </div>
     
    Once you have the raw html from the function above, you need to split it up using built in string functions and arrays. Keeping with the implementation above, the code will look something like this.
    //pretend we are in a function somewherestring res = retrieveData("http://websitething.com/");//res is the full html, so now we do the div split.string[] firstarray = res.Split(new string[] { "<div class=\"specialclass\">" }, StringSplitOptions.None);//this first array is split in two, the first part is the html you don't want, the second part starts with the data you do want. So now we split it again!string[] secondarray = firstarray[1].Split(new string[] { "</div>" }, StringSplitOptions.None);//See how we took the second part of the first array, then we split it again, but now the first part is what we want and the second part is just rubbish.string datayouwant = secondarray[0];//Now you have your data! Now this is a simple way of looking at it where you can follow easily, however if I was programming this with space in mind I would implement as follows:
    string data = retrieveData("http://somewebsite.com").Split(new string[] { "<div class=\"specialclass\">" }, StringSplitOptions.None)[1].Split(new string[] { "</div>" }, StringSplitOptions.None)[0]; This should yield the same result without a bunch of variables taking up memory.
     
    Also understand that you should put this in a try and catch or at least check each array to see if it split, because as soon as you call [1] on the array you would get an out of bounds error.
     
    Hope this helps!
  10. Like
    ItsMTC got a reaction from lubblig in Retreiving data from a website (HTML) in C#   
    I actually have a decent amount of practice with this! Alright, so to start off you need to get the raw html from the website that you want. The simplest implementation I have for that is as follows:
    public static string retrieveData(string url) { WebClient connection = new WebClient(); return connection.DownloadString(url); } This is used in a static environment, such as static class, not an object (although you could use it in that way by removing static).
     
    Now to find and extract the stuff you want is a bit tricky to explain without knowing the page and the format, but usually how I go about this is find a string that occurs before what you want and after what you want. So for example if your data is 
    <div class="specialclass">THIS IS WHAT YOU WANT</div> Then the two strings you will use is <div class="specialclass"> and </div>
     
    Once you have the raw html from the function above, you need to split it up using built in string functions and arrays. Keeping with the implementation above, the code will look something like this.
    //pretend we are in a function somewherestring res = retrieveData("http://websitething.com/");//res is the full html, so now we do the div split.string[] firstarray = res.Split(new string[] { "<div class=\"specialclass\">" }, StringSplitOptions.None);//this first array is split in two, the first part is the html you don't want, the second part starts with the data you do want. So now we split it again!string[] secondarray = firstarray[1].Split(new string[] { "</div>" }, StringSplitOptions.None);//See how we took the second part of the first array, then we split it again, but now the first part is what we want and the second part is just rubbish.string datayouwant = secondarray[0];//Now you have your data! Now this is a simple way of looking at it where you can follow easily, however if I was programming this with space in mind I would implement as follows:
    string data = retrieveData("http://somewebsite.com").Split(new string[] { "<div class=\"specialclass\">" }, StringSplitOptions.None)[1].Split(new string[] { "</div>" }, StringSplitOptions.None)[0]; This should yield the same result without a bunch of variables taking up memory.
     
    Also understand that you should put this in a try and catch or at least check each array to see if it split, because as soon as you call [1] on the array you would get an out of bounds error.
     
    Hope this helps!
  11. Like
    ItsMTC reacted to Senzelian in More OnePlus Two information - battery size, LTE bands, and more revealed   
    Finally LTE in Europe for me   
    Couldn't get that damn band 20.
  12. Like
    ItsMTC reacted to Norman_the_Owl in iPhone 6s Photo Leaks. USB Type-C and design changes.   
    Apple will not use Type C on it's devices, USB allows root access. That is the reason apple made lightning at all, so you couldn't root your phone
  13. Like
    ItsMTC reacted to Albatross in H1Z1 Devs SOE offering "No questions asked" refunds.   
    @ItsMTC
    @Clarkey
    @Mattk50
     
    Thank you for the answers. Now I understand. In that case, I can fully understand the refund request.
     
     
     
    Firstly, I wasn't defending the game. If anything, I was defending the right to Sony to not have to give refunds. Secondly, this was based on the fact that I thought the bugs and issues of Early Access were the cause of the customers' requests for refunds (which would have been a fault of their own). I had no knowledge whatsoever of micro-transactions existing as I thought it was F2P as well. Thirdly and lastly, does that clear it up for you?
  14. Like
    ItsMTC got a reaction from Albatross in H1Z1 Devs SOE offering "No questions asked" refunds.   
    Most people who want a refund what it because they were lied to. On multiple occasions a developer said that drops would not include guns, water, food, etc because such features would ruin the point of the game. Surprise surprise, the game is out and the drops contain all of those things; thus the game is practically pay2win and it is ruined for most players. The company lied and broke their game with micro transactions, that's why people want a refund; not bugs.
  15. Like
    ItsMTC reacted to Misanthrope in Leaked Windows 10 Screenshots Show New Xbox Integration   
    Or platform abandonment: I wouldn't be surprised if Satya Nadella would be one of the first to move all xbox business to the PC and just sell the xbone as an optional steam-box type device
  16. Like
    ItsMTC got a reaction from Victorious Secret in Leaked Windows 10 Screenshots Show New Xbox Integration   
    Are you implying anyone who owns a Windows computer that understands how to open a program could create their own pc going rig? That seems silly.Consoles are still extremely popular with many different people, those of whom range in age and skill level. Microsoft isn't targeting this app and it's features to you, someone who owns a Windows gaming rig; they are targeting those who already own the console and wish to continue using their console for gaming and pc for everything else.
  17. Like
    ItsMTC got a reaction from themodernagenb in Leaked Windows 10 Screenshots Show New Xbox Integration   
    I do not own an Xbone, but this is great news for anyone who does. What it looks like (to me at least) is the first steps towards a Microsoft gaming ecosystem.
  18. Like
    ItsMTC got a reaction from Beskamir in "Google is too dominant to simply leave"   
    Speaks volumes to the dependency on Google literally everyone has.
  19. Like
    ItsMTC got a reaction from neonfusion in "Google is too dominant to simply leave"   
    Speaks volumes to the dependency on Google literally everyone has.
  20. Like
    ItsMTC got a reaction from zacRupnow in "Google is too dominant to simply leave"   
    Speaks volumes to the dependency on Google literally everyone has.
  21. Like
    ItsMTC got a reaction from Akolyte in Leaked Windows 10 Screenshots Show New Xbox Integration   
    WildTangent is more bloatware than crapware; it works but in reality I would have never used nor downloaded it. It just takes up space.
  22. Like
    ItsMTC got a reaction from Kingofpants in "Google is too dominant to simply leave"   
    Speaks volumes to the dependency on Google literally everyone has.
×