Attachment Mod

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
2035
71%
Very Good
444
16%
Good
175
6%
Fair
54
2%
Poor
156
5%
 
Total votes: 2864

mike9999
Registered User
Posts: 53
Joined: Mon Mar 01, 2004 8:45 pm

Post by mike9999 » Tue Dec 13, 2005 9:47 pm

I am getting this error

Code: Select all

Warning: mysql_free_result(): 39 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 41 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 42 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 43 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 44 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 45 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 46 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 47 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 48 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 49 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 50 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 51 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 52 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 53 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 54 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 55 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 56 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 57 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 58 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 59 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 60 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 61 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 62 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 63 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 64 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 65 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 66 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 67 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 68 is not a valid MySQL result resource in /home/raptortr/public_html/phpBB2/db/mysql4.php on line 318

Any ideas? Fresh install untouched, pictures are sporadically not showing up either. [/code]

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17059
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Post by DavidIQ » Tue Dec 13, 2005 9:54 pm

mike9999 wrote: I am getting this error...

Look back a few posts and you'll have the code to fix that.
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.

ChickenHawk
Registered User
Posts: 40
Joined: Sat Dec 10, 2005 4:41 pm
Contact:

Post by ChickenHawk » Tue Dec 13, 2005 9:56 pm

yes i did...i'll comfirm it
DiD I do that?

mike9999
Registered User
Posts: 53
Joined: Mon Mar 01, 2004 8:45 pm

Post by mike9999 » Tue Dec 13, 2005 10:01 pm

I dont know who is talking to who or fixing what when looking back at the posts, I dont wanna hack up something thats right, these are the only errors I see on my board.\

found it.. geez all that code for this?? what does it fix aside from the errors? is there a function it makes work again. The only problem I actually have is that images dont show inline when thumbnail is selected in the admin
Last edited by mike9999 on Tue Dec 13, 2005 10:05 pm, edited 1 time in total.

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17059
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Post by DavidIQ » Tue Dec 13, 2005 10:04 pm

mike9999 wrote: I dont know who is talking to who or fixing what when looking back at the posts, I dont wanna hack up something thats right, these are the only errors I see on my board.

This is what I'm talking about:

Code: Select all

#
#----[OPEN]----
#
attach_mod/includes/functions_selects.php

#
#----[FIND]----
#
function group_select($select_name, $default_group = 0)
{
   global $db, $lang;

   $sql = 'SELECT group_id, group_name
      FROM ' . EXTENSION_GROUPS_TABLE . '
      ORDER BY group_name';

   if (!($result = $db->sql_query($sql)))
   {
      message_die(GENERAL_ERROR, "Couldn't query Extension Groups Table", "", __LINE__, __FILE__, $sql);
   }

   $group_select = '<select name="' . $select_name . '">';
   
   $group_name = $db->sql_fetchrowset($result);
   $num_rows = $db->sql_numrows($result);
   $db->sql_freeresult($result);

   if ($num_rows > 0)
   {
      $group_name[$num_rows]['group_id'] = 0;
      $group_name[$num_rows]['group_name'] = $lang['Not_assigned'];

      for ($i = 0; $i < sizeof($group_name); $i++)
      {
         if (!$default_group)
         {
            $selected = ($i == 0) ? ' selected="selected"' : '';
         }
         else
         {
            $selected = ($group_name[$i]['group_id'] == $default_group) ? ' selected="selected"' : '';
         }

         $group_select .= '<option value="' . $group_name[$i]['group_id'] . '"' . $selected . '>' . $group_name[$i]['group_name'] . '</option>';
      }
   }
   $db->sql_freeresult($result);

   $group_select .= '</select>';

   return $group_select;
}

#
#----[REPLACE WITH ]----
#
function group_select($select_name, $default_group = 0)
{
   global $db, $lang;

   $sql = 'SELECT group_id, group_name
      FROM ' . EXTENSION_GROUPS_TABLE . '
      ORDER BY group_name';

   if (!($result = $db->sql_query($sql)))
   {
      message_die(GENERAL_ERROR, "Couldn't query Extension Groups Table", "", __LINE__, __FILE__, $sql);
   }

   $group_select = '<select name="' . $select_name . '">';
   
   $group_name = $db->sql_fetchrowset($result);
   $num_rows = $db->sql_numrows($result);
   $db->sql_freeresult($result);

   if ($num_rows > 0)
   {
      $group_name[$num_rows]['group_id'] = 0;
      $group_name[$num_rows]['group_name'] = $lang['Not_assigned'];

      for ($i = 0; $i < sizeof($group_name); $i++)
      {
         if (!$default_group)
         {
            $selected = ($i == 0) ? ' selected="selected"' : '';
         }
         else
         {
            $selected = ($group_name[$i]['group_id'] == $default_group) ? ' selected="selected"' : '';
         }

         $group_select .= '<option value="' . $group_name[$i]['group_id'] . '"' . $selected . '>' . $group_name[$i]['group_name'] . '</option>';
      }
   }

   $group_select .= '</select>';

   return $group_select;
}
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.

ChickenHawk
Registered User
Posts: 40
Joined: Sat Dec 10, 2005 4:41 pm
Contact:

Post by ChickenHawk » Tue Dec 13, 2005 10:05 pm

mike 999 find post to me...i was having same problem...what he gave me fixed it...


David...What is this
Explanation Extension Extension Group Delete

what do i put in Explanation box?
DiD I do that?

mike9999
Registered User
Posts: 53
Joined: Mon Mar 01, 2004 8:45 pm

Post by mike9999 » Tue Dec 13, 2005 10:07 pm

He said that made no change for him, I was looking for something else, then figured that had to be it.. I will try that now.

ChickenHawk
Registered User
Posts: 40
Joined: Sat Dec 10, 2005 4:41 pm
Contact:

Post by ChickenHawk » Tue Dec 13, 2005 10:08 pm

here Mike999
DavidIQ wrote:
ChickenHawk wrote:Extension Control

Warning: mysql_free_result(): 39 is not a valid MySQL result resource in /home/chickenh/public_html/bboard/db/mysql4.php on line 318


Fix that with this:

Code: Select all

#
#----[OPEN]----
#
attach_mod/includes/functions_selects.php

#
#----[FIND]----
#
function group_select($select_name, $default_group = 0)
{
   global $db, $lang;

   $sql = 'SELECT group_id, group_name
      FROM ' . EXTENSION_GROUPS_TABLE . '
      ORDER BY group_name';

   if (!($result = $db->sql_query($sql)))
   {
      message_die(GENERAL_ERROR, "Couldn't query Extension Groups Table", "", __LINE__, __FILE__, $sql);
   }

   $group_select = '<select name="' . $select_name . '">';
   
   $group_name = $db->sql_fetchrowset($result);
   $num_rows = $db->sql_numrows($result);
   $db->sql_freeresult($result);

   if ($num_rows > 0)
   {
      $group_name[$num_rows]['group_id'] = 0;
      $group_name[$num_rows]['group_name'] = $lang['Not_assigned'];

      for ($i = 0; $i < sizeof($group_name); $i++)
      {
         if (!$default_group)
         {
            $selected = ($i == 0) ? ' selected="selected"' : '';
         }
         else
         {
            $selected = ($group_name[$i]['group_id'] == $default_group) ? ' selected="selected"' : '';
         }

         $group_select .= '<option value="' . $group_name[$i]['group_id'] . '"' . $selected . '>' . $group_name[$i]['group_name'] . '</option>';
      }
   }
   $db->sql_freeresult($result);

   $group_select .= '</select>';

   return $group_select;
}

#
#----[REPLACE WITH ]----
#
function group_select($select_name, $default_group = 0)
{
   global $db, $lang;

   $sql = 'SELECT group_id, group_name
      FROM ' . EXTENSION_GROUPS_TABLE . '
      ORDER BY group_name';

   if (!($result = $db->sql_query($sql)))
   {
      message_die(GENERAL_ERROR, "Couldn't query Extension Groups Table", "", __LINE__, __FILE__, $sql);
   }

   $group_select = '<select name="' . $select_name . '">';
   
   $group_name = $db->sql_fetchrowset($result);
   $num_rows = $db->sql_numrows($result);
   $db->sql_freeresult($result);

   if ($num_rows > 0)
   {
      $group_name[$num_rows]['group_id'] = 0;
      $group_name[$num_rows]['group_name'] = $lang['Not_assigned'];

      for ($i = 0; $i < sizeof($group_name); $i++)
      {
         if (!$default_group)
         {
            $selected = ($i == 0) ? ' selected="selected"' : '';
         }
         else
         {
            $selected = ($group_name[$i]['group_id'] == $default_group) ? ' selected="selected"' : '';
         }

         $group_select .= '<option value="' . $group_name[$i]['group_id'] . '"' . $selected . '>' . $group_name[$i]['group_name'] . '</option>';
      }
   }

   $group_select .= '</select>';

   return $group_select;
}
DiD I do that?

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17059
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Post by DavidIQ » Tue Dec 13, 2005 10:09 pm

ChickenHawk wrote: mike 999 find post to me...i was having same problem...what he gave me fixed it...


David...What is this
Explanation Extension Extension Group Delete

what do i put in Explanation box?

Where are you seeing that? In the admin control panel? Explanation can be left blank if that's the case. Extension is the type of file (.jpg, .exe, .php, etc.), extension group determines how the file is handled. If you put it as streaming for example the file will play right off the board. Delete is just that...delete the extension.
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.

mike9999
Registered User
Posts: 53
Joined: Mon Mar 01, 2004 8:45 pm

Post by mike9999 » Tue Dec 13, 2005 10:12 pm

That took care of it, sorry for the confusion.

ChickenHawk
Registered User
Posts: 40
Joined: Sat Dec 10, 2005 4:41 pm
Contact:

Post by ChickenHawk » Tue Dec 13, 2005 10:12 pm

yes in the control panel...i knew what all but that explanation box was for...thanks
DiD I do that?

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17059
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Post by DavidIQ » Tue Dec 13, 2005 10:19 pm

It's like a note to yourself of what the extension is for. Glad I could help :wink:
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.

User avatar
sciguy
Registered User
Posts: 152
Joined: Thu Oct 20, 2005 4:17 pm
Contact:

Post by sciguy » Tue Dec 13, 2005 11:22 pm

Yay! :D I finally got it working the way I wanted. However, now I have another question.

When I add other extensions (ex. MP3) in the streaming group, they won't play in the post like the pre-installed .wma will. Is there some kind of way to get this to work? :?
UltimateComputers.net
^A website and forum for computer building enthusiasts and newbs!^

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17059
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Post by DavidIQ » Tue Dec 13, 2005 11:26 pm

sciguy wrote: When I add other extensions (ex. MP3) in the streaming group, they won't play in the post like the pre-installed .wma will. Is there some kind of way to get this to work? :?

What's it doing then? Got an example post for us?
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.

User avatar
sciguy
Registered User
Posts: 152
Joined: Thu Oct 20, 2005 4:17 pm
Contact:

Post by sciguy » Tue Dec 13, 2005 11:30 pm

for example-if I try to make a post with that kind of file in it, it says
file is empty


As a work around, I have it in the archive section so that you can just download it. However I would prefer if you could stream it... 8)
UltimateComputers.net
^A website and forum for computer building enthusiasts and newbs!^

Post Reply

Return to “[2.0.x] MOD Database Releases”