Jump to content

Q695

Members
  • Posts

    783
  • Joined

  • Last visited

Posts posted by Q695

  1. An output buffer would take a few milliseconds to process the mark-up for that number of images. It's only mark-up after all, unless you base64 encode the image data or something?

     

    The problem is that you're forcing the user to download 625 images all at once! You should lazy-load them. Define the div the correct width and height to contain them all, but only load the actual image when it's needed, or when it's say one or two images out of view. Otherwise you're going to waste a tonne of bandwidth and slow down the initial page load like crazy, if not crashing the browser.

     

    You'll need to use JS, but I suspect you'll be able to download a jQuery plug-in or something to handle it.

     

    Actually the 625 images would be image locations with 10 different images total being downloaded like an image pixel with 10 options that are about 20 px X 20 px grid.

  2. The output buffer is going to take a long time to process the content, because it's a 25X25 table with an image in each square.

     

    I am using a form submit that renders a map output behind the scenes, then displays it to the folder with other maping images.

     

    Capture an image? Of the user's screen? You can't do that. Would you like it if a website could take screenshots of what you're seeing whenever it wanted?

    It's a server side trigger for an image capture after everything being grabbed is displayed to the server.

  3. One more little tweak issue:

    The pull wasn't pulling the vote based upon unique users

     

    SELECT v.* FROM votes v LEFT JOIN user_votes uv ON v.poll_id = uv.vote_poll_id WHERE

    v.user_id != $id // the one who owns the item being voted on (working)

    AND

    uv.voter_id = $id // unique voter that is not the owner (stops all outputs)

    AND uv.vote_poll_id IS NULL ORDER BY RAND() LIMIT 1

     

    Ignore the comments, as they're just footnotes for troubleshooting help.

    I renamed the column name to "voter_id", because it appeared to be used a second time in the other table.

  4. I pull the data based upon the user_votes table, which tells me what database to query, because I have a byte operator in the user_votes table tied into a switch statement.  The data displays properly.

     

    The elimination tables I'm having trouble with are:

    user_votes //this table

    s_fulltext.png vote_poll_id user_id Vote

     

    and

     

    votes //eliminates options from this table

    s_fulltext.png poll_id user_id type item_id yes no

     

    by

    `votes`.`poll_id` = `user_votes`.`vote_poll_id` AND `user_votes`.`user_id`='$user'

     

    Problem:

    the elimination table works fine with the data when it's matched up, but not telling me the options that aren't matching up, if there are any.

  5. I'm stumped on how to get this join to work:

    Statement:

    SELECT * FROM votes WHERE NOT EXISTS (`votes`.`poll_id` = `user_votes`.`vote_poll_id` AND `user_votes`.`user_id`='1') limit 1 order by rand()

     

    Error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`votes`.`poll_id` = `user_votes`.`vote_poll_id`) limit 1 order by rand()' at line 3

     

    Possibly, but doubt it:

    the table is completely blank.

     

    Goal:

    Find all the entries that the user hasn't voted on as of yet, then submit them randomly to the user.

  6. I'm looking for a WYSIWYG text editor for a profile of whatever user that logs in can use to edit their own user profile.

     

    I have the section fully built, but I want to quickly add a new feature to the page to make the profile editor part better.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.