Jump to content

Krydos

Chief Executive Officer
 View Profile  See their activity

  • Posts

    24,618

  • Joined

  • Last visited

  • Days Won

    871

 Content Type 

Everything posted by Krydos

  1. Krydos
    Are you still blocked? It can take a few minutes to start working again and you posted really quickly after wolstech unblocked you.
  2. Krydos
    I'm not sure why bdistler's code isn't working, but here's an alternative that works: RewriteCond %{REMOTE_HOST} !^123\.123\.123\.123 RewriteRule ^(.*)$ - [L,R=403] Change that 123.123.123.123 to your IP and it will show forbidden to everyone except for you. http://olsenalways.win/
  3. Krydos
    Only one .war can be deployed per account at a time.
  4. Krydos
    The code here https://www.helionet.org/index/topic/28805-dropdown-with-mysql-tables-names-of-a-database-as-options/?p=131382 is tested and works fine on Tommy.
  5. Krydos
    The php I posted above was the expansion of the psuedocode that you didn't understand What is your sql query?
  6. Krydos
    It's just psuedocode. <?php // however you get your username variable $username = "maicol07"; // load database values require 'config.php'; // connect to database $con = new mysqli($db_host, $db_user, $db_pass, $db_data); if ($conn->connect_error) die("Connection failed: ".$conn->connect_error); // perform query $sql = "show tables like $username_"; $result_tables = $con->query($sql); // start dropdown select echo "<select>"; // for each table in database while ($row_tables = $result_tables->fetch_assoc()) { // store the name of the table we're working with $table = $row_tables["Tables_in_$db_data"]; // perform query $sql = "select data from $table"; $result_data = $con->query($sql); // for each value in the column data while ($row_data = $result_data->fetch_assoc()) { // store the value of this row of data $data = $row_data['data']; // create a dropdown entry echo "<option value='$data'>$data</option>"; } } echo "</select>"; This code is untested.
  7. Krydos
    You could do queries in a while loop. show tables while (another table) { select * from table }
  8. Krydos
    Well, the show command only loads the tables that start with the username, and then the select tags display the names of the tables which start with the username_ bit. Maybe I'm not understanding what you're trying to do?
  9. Krydos
    Closing due to inactivity.
  10. Krydos
    Yes, the invite for that transaction ID was sent.
  11. Krydos
    There you go http://olsenalways.win/test.aspx
  12. Krydos
    It's working again.
  13. Krydos
    Please post the following information: Your cPanel usernameYour main domain
  14. Krydos
    The config.php is a common way to separate the $db_host, $db_user, $db_pass, and $db_data variables from the code. If you have 15 different php files they can all include config.php to load those database variables, and if you change the password for example you only have to change it in one place. It's good programming practice to do stuff like this. In this case the config.php would look like: <?php $db_host = "localhost"; $db_user = "maicol07_user"; $db_pass = "bestpaswordever"; $db_data = "maicol07_db"; Change line 11 to $sql = "show tables like '$username_%";
  15. Krydos
    @bdistler, oh cool, I didn't even know there was an option for that in cpanel. Thanks for pointing that out.
  16. Krydos
    Installed.
  17. Krydos
    We already have mod_deflate installed which does the same thing, but works for all file types not just php files. Put something like this in your .htaccess to enable it <IfModule mod_deflate.c> AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript </IfModule> You can test your pages to see if it's enabled properly by using a tool like this http://www.whatsmyip.org/http-compression-test/
  18. Krydos
    It's already in there http://krydos.heliohost.org/71/phpinfo.php
  19. Krydos
    It takes a few hours for the email address change to go through sometimes.
  20. Krydos
    PHP files need to be permissions 644. You phpinfo.php file was 664. There you go http://wardracs.heliohost.org/phpinfo.php
  21. Krydos
    Yeah, we can install python modules for you. Just let us know: Module name (webob)Python version you're usingServer that you're on
  22. Krydos
    Not really. You can install ruby gems yourself through cpanel. If you need a particular version of python or some module installed let us know. The idea behind requesting java and requesting mono is it takes a lot of server resources for each account that those are enabled on so we want only the people who actually need it to have it active.
  23. Krydos
    It should work on 5.6. Are you sure you aren't using 5.5 or something else? Ah, figured it out. The error isn't our server at all: Source: https://stackoverflow.com/questions/11680709/file-get-contents-give-me-403-forbidden That particular website has some protection against people using file_get_contents on it. If you use curl with good headers you can get the data from them without them knowing it's not a real browser. That wouldn't stop them from figuring out that the requests are coming from a server not a real persons IP address and if they're really zealous about not having their data scraped they could always block our IP...
  24. Krydos
    Yes, mysqli is functional on Tommy.
  25. Krydos
    This might help. https://stackoverflow.com/questions/1390607/how-could-i-change-this-mysql-to-mysqli
×
×
  • Create New...