JayBachatero.com

Hex-to-Numeric Entities Converter

Author: JayBachatero

22 Sep

At work I get files sometimes with hexadecimal entities but the problem is that we use numeric entities. I decided to write a simple script that will search the file for hex entities and convert them to numeric one. This is intended to be used with Komodo Edit or via the command line.

Read the rest of this entry »

  • 0 Comments
  • Filed under: General, PHP Snippets

    • SMF 2.0 Beta 3 Public Released!

    Author: JayBachatero

    17 Mar

    The wait is finally over. The first public beta of SMF 2.0 is here!
    Simple Machines is extremely proud to announce the long awaited release of the first public beta of SMF 2.0… View the link for the full announcement.

    read more | digg story

  • 1 Comment
  • Filed under: Digg.com

    • How to use your MDA as a modem for your laptop via Bluetooth.

    Author: JayBachatero

    16 Mar

    For quite some time now, I’ve been trying to use my MDA as a modem for my laptop with Vista, for when I’m not home. Last night I was able to figure it out. It’s pretty easy to do. Your laptop needs to have bluetooth device enabled and paired with the phone. Here are the steps to get this working correctly.
    Read the rest of this entry »

  • 2 Comments
  • Filed under: General

    • How to use the SMF user system outside of SMF

    Author: JayBachatero

    22 Feb

    I wrote this article a while back for the doc site.

    Call SSI.php before anything else.
    How do I show a login/logout form?
    How do I redirect users after they login/logout?
    How do I restrict access to certain areas of my pages?
    Extras

    Hooking the SMF user system with external applications is a common issue people have. This document will help explain how to accomplish this. The first thing you will need to do is change the files that you are going to implement this on into php files. So if you have a .html or .htm extension proceding the filename of the file, rename the file with the extension at the end being .php. The reason for this is so that the php content can get parsed as php and not as html. You may ask yourself: By doing this, will it have any effects on my current page? Well the answer is no. Everything will show just the way it did before.
    Read the rest of this entry »

  • 0 Comments
  • Filed under: PHP Snippets, SMF Stuff

    • Java Snippets

    Author: JayBachatero

    31 Jan

    Since I’m back to school and taking my 3rd semester of Java, I’ll have to write lots of small programs. I decided to post them here. Who knows. Maybe they will be useful to some.

  • 0 Comments
  • Filed under: Java Snippets

    • New Laptop

    Author: JayBachatero

    31 Jan

    Recently my laptop has been acting up. It’s been getting real hot. The temperature is averaging 65C. So I went ahead and contacted Dell support. Told them the issue and they didn’t ask too much questions. They just asked for address and are going to send me another laptop in a few days. Seems like I’m going to have to install Ubuntu again and struggle getting WiFi to work on it. Last time that I tried to get it to work, it was a mission to do but I was able to get it working.

    Well That’s all for now. I’ll post an update when I get the new one. Maybe I get lucky and it comes with another OS that is not Vista Basic.

  • 0 Comments
  • Filed under: General

    • How to recount posts for members in SMF.

    Author: JayBachatero

    28 Jan

    Something that members ask from time to time is for a way to recount the total posts for their member. A while back I wrote a small script to do this. To prevent the script from overloading the server it's done in small steps. It still needs some work but here it is. Hope it comes in handy to some.

    Recount User Posts File Download

    PLAIN TEXT
    PHP:
    1. <?php
    2. // Load SSI.php
    3. require_once('SSI.php');
    4.  
    5. // Turn this on.
    7.  
    8. // Are we allowed in here?
    9. isAllowedTo('admin_forum');
    10.  
    11. $_REQUEST['start'] = !isset($_REQUEST['start']) ? '0' : (int) $_REQUEST['start'];
    12.  
    13. // Header step and footer.
    14. show_header();
    15. // Check if it exists.
    16. if (!empty($_REQUEST['start']) || (empty($_REQUEST['start']) && isset($_REQUEST['recount'])))
    17.         recount();
    18. elseif (isset($_GET['start']) && $_GET['start'] != -1)
    19.         // Give a link to start
    20.         echo '
    21.                 <h2><a href="', $_SERVER['PHP_SELF'], '?recount;start=0">Start Post Recount</a></h2>';
    22. // Footeeerr.
    23. show_footer();
    24.  
    25.  
    26. function recount()
    27. {
    28.         global $db_prefix;
    29.  
    30.         while (true)
    31.         {
    32.                 // Only run this query if we don't have the total.
    33.                 if (!isset($_SESSION['totalMembers']))
    34.                 {
    35.                         $request = db_query("
    36.                                 SELECT COUNT(DISTINCT m.ID_MEMBER)
    37.                                 FROM ({$db_prefix}messages AS m, {$db_prefix}boards AS b)
    38.                                 WHERE m.ID_MEMBER != 0
    39.                                         AND b.countPosts = 0
    40.                                         AND m.ID_BOARD = b.ID_BOARD", __FILE__, __LINE__);
    41.                         list ($_SESSION['totalMembers']) = mysql_fetch_row($request);
    42.                         mysql_free_result($request);
    43.                         $_SESSION['recountedMembers'] = 0;
    44.                 }
    45.  
    46.                 // Lets get the members and their post counts.
    47.                 // Make sure that we only get boards that have posts count enabled.
    48.                 // !!! On a big board 200 might be a bit to high to count.
    49.                 $request = db_query("
    50.                         SELECT m.ID_MEMBER, COUNT(m.ID_MEMBER) AS posts
    51.                         FROM ({$db_prefix}messages AS m, {$db_prefix}boards AS b)
    52.                         WHERE m.ID_MEMBER != 0
    53.                                 AND b.countPosts = 0
    54.                                 AND m.ID_BOARD = b.ID_BOARD
    55.                         GROUP BY m.ID_MEMBER
    56.                         LIMIT $_REQUEST[start], 200", __FILE__, __LINE__);
    57.                 $total_rows = mysql_num_rows($request);
    58.                 $_SESSION['recountedMembers'] += $total_rows * 200;
    59.  
    60.                 // Get all the results and assign the correct value.
    61.                 while ($row = mysql_fetch_assoc($request))
    62.                         db_query("
    63.                                 UPDATE {$db_prefix}members
    64.                                 SET posts = $row[posts]
    65.                                 WHERE ID_MEMBER = $row[ID_MEMBER]", __FILE__, __LINE__);
    66.  
    67.                 $_GET['start'] += 200;
    68.                 if ($total_rows <200)
    69.                         $_GET['start'] = -1;
    70.                 nextStep();
    71.         }
    72. }
    73.  
    74.  
    75. function show_header()
    76. {
    77.         global $steps, $timestart;
    78.  
    79.         if (isset($_SESSION['totalMembers']) && !empty($_GET['start']))
    80.         {
    81.                 $timestart = time();
    82.                 $total_members = isset($_SESSION['totalMembers']) ? $_SESSION['totalMembers'] : 0;
    83.                 $fake_start = $_GET['start'] + 200>= $total_members ? $total_members : $_GET['start'] + 2;
    84.                 $percent = round(100 / $total_members * $fake_start, 2);
    85.         }
    86.  
    87.         echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    88. <html>
    89.         <head>
    90.                 <title>SMF Member Posts Recount</title>
    91.                 <style type="text/css"><!--
    92.                         body
    93.                         {
    94.                                 background-color: #E5E5E5;
    95.                                 margin: 0;
    96.                                 padding: 0;
    97.                                 font-size: 10pt;
    98.                         }
    99.                         #header
    100.                         {
    101.                                 font-weight: bold;
    102.                                 font-size: 200%;
    103.                         }
    104.                         #content
    105.                         {
    106.                                 background-color: #CECED7;
    107.                                 border: 1px solid #8B9AAA;
    108.                                 padding: 2px;
    109.                         }
    110.                         #footer
    111.                         {
    112.                                 font-size: 12px;
    113.                                 text-align: right;
    114.                                 font-style: italic;
    115.                         }
    116.                         #container
    117.                         {
    118.                                 width: 50%;
    119.                                 margin: 0 auto 0 auto;
    120.                         }
    121.                         h2
    122.                         {
    123.                                 margin: 0;
    124.                                 margin-top: 0.5ex;
    125.                                 margin-bottom: 0.5ex;
    126.                                 padding-bottom: 3px;
    127.                                 border-bottom: 1px dashed black;
    128.                                 font-size: 14pt;
    129.                                 font-weight: normal;
    130.                         }
    131.                         h3
    132.                         {
    133.                                 margin: 0;
    134.                                 margin-bottom: 2ex;
    135.                                 font-size: 10pt;
    136.                                 font-weight: normal;
    137.                         }
    138.                         input
    139.                         {
    140.                                 margin: 2px;
    141.                         }
    142.                         .status_bar_border
    143.                         {
    144.                                 height: 20px;
    145.                                 width: 450px;
    146.                                 background: #ffffff;
    147.                                 border: 1px solid silver;
    148.                                 margin: 0 auto 0 auto;
    149.                                 padding-right: 4px;
    150.                                 text-align: right;
    151.                         }
    152.                         .status_bar
    153.                         {
    154.                                 height: 16px;
    155.                                 margin: 2px;
    156.                                 padding: 0px;
    157.                                 text-align: center;
    158.                                 text-align: right;
    159.                         }
    160.                         .bg1
    161.                         {
    162.                                 background: #3dc0df;
    163.                         }
    164.                         .bg2
    165.                         {
    166.                                 background: #C9DDEC;
    167.                         }
    168.                         .percent
    169.                         {
    170.                                 text-align: right;
    171.                                 color: #000;
    172.                                 font-weight: bold;
    173.                                 padding-bottom: 5px;
    174.                         }
    175.                         .codebox
    176.                         {
    177.                                 background-color: #cccccc;
    178.                                 font: normal 10px "Courier New", monospace;
    179.                                 border: solid 1px black;
    180.                                 padding: 5px;
    181.                                 white-space: nowrap;
    182.                                 overflow: auto;
    183.                                 width: 95%;
    184.                         }
    185.                 --></style>
    186.         </head>
    187.         <body>
    188.                 <div id="container">
    189.                         <div id="header">
    190.                                 SMF Member Posts Recount
    191.                         </div>
    192.                         <div id="content">';
    193.  
    194.         if (!empty($total_members))
    195.                 echo '
    196.                                 <h2>Recount Status</h2>
    197.                                 <h3 style="margin: 0 0 0 40px; font-weight: bold;">Overall Process</h3>
    198.                                 <div class="status_bar_border">
    199.                                         <div class="status_bar bg1" style="width: ', $percent, '%; white-space: nowrap;">', $percent, '% (', $fake_start, ' out of ', $total_members, ' members) </div>
    200.                                 </div>';
    201.  
    202.         if (isset($percent) && $percent == 100 || isset($_GET['start']) && $_GET['start'] == -1)
    203.                 echo '
    204.                                 <h1>Recount Complete</h1>';
    205.  
    206. }
    207.  
    208. function show_footer()
    209. {
    210.         echo '
    211.                         </div>
    212.                         <div id="footer">
    213.                                 <a href="http://jaybachatero.com">JayBachatero.com</a>
    214.                         </div>
    215.                 </div>
    216.         </body>
    217. </html>';
    218. }
    219.  
    220. function nextStep($step = null)
    221. {
    222.         global $timestart;
    223.  
    224.         @set_time_limit(300);
    225.         if (function_exists('apache_reset_timeout'))
    226.                 apache_reset_timeout();
    227.  
    228.         echo '
    229.                                 <h2 style="margin-top: 2ex;">Recount Paused!</h2>
    230.                                 <h3>This recount has paused to avoid server overload.</h3>
    232.                                 <form action="', $_SERVER['PHP_SELF'], '?start=', $_GET['start'], '" method="post" name="auto_submit">
    233.                                         <div align="right" style="margin: 1ex;"><input name="timer" type="submit" value="Continue" /></div>
    234.                                 </form>
    235.                                 <script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[
    236.                                         window.onload = autoSubmit;
    237.                                         var countdown = 3;
    239.                                         function autoSubmit()
    240.                                         {
    241.                                                 if (countdown == 0)
    242.                                                         document.auto_submit.submit();
    243.                                                 else if (countdown == -1)
    244.                                                         return;
    246.                                                 document.auto_submit.timer.value = "Continue (" + countdown + ")";
    247.                                                 countdown--;
    249.                                                 setTimeout("autoSubmit();", 1000);
    250.                                         }
    251.                                 // ]]></script>';
    252.  
    253.         show_footer();
    254.         exit;
    255. }
    256. ?>
  • 6 Comments
  • Filed under: PHP Snippets, SMF Stuff

    • Simple Machines Forum Releases SMF 2.0 Beta 2

    Author: JayBachatero

    20 Jan

    Simple Machines Forum is pleased to announce that the second beta of SMF 2.0. This release includes many new features such as
    *Added paid subscription feature
    *Added search engine tracking
    *Numerous improvements to the WYSIWYG editor
    -Click article to read more about the feature updates.

    read more | digg story

  • 1 Comment
  • Filed under: Digg.com, SMF Stuff

    • GreaseMonkey Script — Go to next field UIBO website.

    Author: JayBachatero

    30 Oct

    I got tired of having to press tab each time when I enter my SS number in the Unemployment Insurance Benefits Online website so I made this GreaseMonkey script. I'm not so good in JS but it gets the job done. I'm pretty sure it can be written better.

    PLAIN TEXT
    JavaScript:
    1.  
    2. // ==UserScript==
    3. // @name           Unemployment Insurance Benefits Online by JayBachatero
    4. // @namespace      http://www.jaybachatero.com
    5. // @description    Go to next field when entering ssn.
    6. // @include        https://ui.labor.state.ny.us/UBC/home.do
    7. // @version        1.0
    8. // ==/UserScript==
    9.  
    10. // The name of the fields we are going to look for.
    11. var ssn_fields = new Array(
    12.         ['ILoginForm.SSN1_KEY', 3],
    13.         ['ILoginForm.SSN2_KEY', 2],
    14.         ['ILoginForm.SSN3_KEY', 4]
    15. );
    16. // Current field.
    17. var current_field = 0;
    18.  
    19. function goToNextField()
    20. {
    21.         // Stop right there.
    22.         if (current_field> 2)
    23.                 return;
    24.  
    25.         // Field properties.
    26.         var id = ssn_fields[current_field][0];
    27.         var field_properties = document.getElementById(id);
    28.         // Current value.
    29.         var current_value = field_properties.value.length;
    30.         // Check the current field.
    31.         if (current_value == ssn_fields[current_field][1])
    32.         {
    33.                 // Increase the current_field