MyBB Community Forums

(2014-04-16, 11:58 AM)Wildcard Wrote: [ -> ]Good for you JimR. Do you plan to make it available publicly?

I will add a link for people to download it when it's done

<error>
	<dateline>1397634915</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1064 - 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 'IN(3)' at line 1
Query: SELECT tid, name FROM mybb_themes WHERE NOT pid='0' AND NOT IN(3)</message>
</error>

advanced sidebox 2.1

help please

(2014-04-16, 02:14 PM)hkkp Wrote: [ -> ]

<error>
	<dateline>1397634915</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1064 - 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 'IN(3)' at line 1
Query: SELECT tid, name FROM mybb_themes WHERE NOT pid='0' AND NOT IN(3)</message>
</error>

advanced sidebox 2.1

help please

where did you get this error from, was it from the acp or the actual site ?

Hi Wildcard, just wanted to reiterate suggestion from http://community.mybb.com/thread-131633-...pid1069541 .

I find myself looking at my own forum, there's a list of threads from a particular FID in an ASB, but then it just .... stops. And even it's my own forum, wishing there was a 'See more...' link at the bottom so I could easily continue in that area rather than searching through forum list, or having to click Home to even get to the forum list. Would be great if we could control what that line says as well (See more... Read more... Continue...) style it with inline CSS and control what it links to. I think would make an awesome addition to the plugin.

Since you added the extra functionality with v2 (TID/PID options), it's opened up a whole new set of possibilities.

---

Wanted to add one more suggestion. I'm still having issues with the edit sidebox popup. It's random and not sure if related to cloudflare or not, but would be great to have an option to turn off the popup and have it load normally. I can 'catch' the edit box sometimes before all the code has loaded and it's forced to go to load on it's own page, but its sometimes difficult to get the timing down. It really is random, sometimes pop up works fine, other times it pops and locks.

(2014-04-16, 12:07 PM)JimR Wrote: [ -> ]I will add a link for people to download it when it's done

That's great. Please be aware that in 2.1 some changes have been made in the module system. They're not huge changes but they will require an update to modules.

https://github.com/WildcardSearch/Advanc...issues/177
https://github.com/WildcardSearch/Advanc...issues/169
https://github.com/WildcardSearch/Advanc...issues/159
https://github.com/WildcardSearch/Advanc...issues/157

(2014-04-16, 02:14 PM)hkkp Wrote: [ -> ]advanced sidebox 2.1

ASB 2.1 is NOT meant for a live forum. It is not yet released. You should wait until testing is complete and use the version on the mods site (2.0.7) until then.

But I'll echo JimR: please tell us more about the error.

(2014-04-16, 04:37 PM)DrXotick Wrote: [ -> ]Hi Wildcard, just wanted to reiterate suggestion from http://community.mybb.com/thread-131633-...pid1069541 .

I haven't forgot, I just honestly don't feel it is feasible. Where would this 'global exclude list' come from? Where would it be set?

(2014-04-16, 04:37 PM)DrXotick Wrote: [ -> ]Would be great if we could control what that line says as well (See more... Read more... Continue...)

You can. Just edit the language in asb_addon.lang.php

(2014-04-16, 04:37 PM)DrXotick Wrote: [ -> ]style it with inline CSS and control what it links to. I think would make an awesome addition to the plugin.

You can always edit the template for the plugin to style or remove/replace the link in question.

(2014-04-16, 04:37 PM)DrXotick Wrote: [ -> ]Wanted to add one more suggestion. I'm still having issues with the edit sidebox popup. It's random and not sure if related to cloudflare or not, but would be great to have an option to turn off the popup and have it load normally. I can 'catch' the edit box sometimes before all the code has loaded and it's forced to go to load on it's own page, but its sometimes difficult to get the timing down. It really is random, sometimes pop up works fine, other times it pops and locks.

I have received sporadic reports of problems with the JavaScript in ACP but no real error reports.

If you can give me a specific JS error you are getting in the web console then it would help to track it down.

If you want to use the standard, non-JS side box creation page then simply disable JS for that page in your browser.

the sidebox is above where its supposed to be on the thread list and thread pages, but its fine on the main page. i put unmodded templates of both pages in and its nothing i modified in there. i tried replacing anything i modified or looking at anything i could but i cant get the sidebox where it should be

and how can i change the latest threads from from 10 to 5

[attachment=31385]

[attachment=31386]

[attachment=31387]

(2014-04-16, 04:37 PM)DrXotick Wrote: [ -> ]Hi Wildcard, just wanted to reiterate suggestion from http://community.mybb.com/thread-131633-...pid1069541 .

I haven't forgot, I just honestly don't feel it is feasible. Where would this 'global exclude list' come from? Where would it be set?

(2014-04-16, 04:37 PM)DrXotick Wrote: [ -> ]Would be great if we could control what that line says as well (See more... Read more... Continue...)

Quote:You can. Just edit the language in asb_addon.lang.php

I was mainly referring to showing it at the bottom of the box.

*checkbox* Show link at bottom
---*textbox* Link text (if blank then will read "See more...")
---*textbox* Links to (if blank then will link to first FID in show FID box, if FID box blank and this box blank then links to default MyBB view new posts)

Has it been implemented already? This would be awesome.

In regards to the suggestion of disabling JS, sure I can do that.

What info do you need from debugging? In console I see two errors only. It's looking for site.com/inc/plugins/adv_sidebox/images/trashcan_bg.png and site.com/inc/plugins/adv_sidebox/images/column_bg.png. My site is /forum.

In debugger there's tons of info, but nothing I see off the bat that points towards an error.

I thought perhaps it was rocketloader or minification of js at cloudflare, but I've tuned both off and the problem remains. Turning off cloudflare altogether and doing a purge and the problem remains as well. Initially I'd thought it had solved the problem, but I guess it was in spite of, not because of.

(2014-04-16, 02:50 PM)JimR Wrote: [ -> ]

(2014-04-16, 02:14 PM)hkkp Wrote: [ -> ]

<error>
	<dateline>1397634915</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 1064 - 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 'IN(3)' at line 1
Query: SELECT tid, name FROM mybb_themes WHERE NOT pid='0' AND NOT IN(3)</message>
</error>

advanced sidebox 2.1

help please

where did you get this error from, was it from the acp or the actual site ?

this error ist from acp

I have a problem that I can not track down in the source code.
I have tried the following

1. Created a new database
   
2. granted the user all privs to the database
   
3. installed a new copy of mybb
   
4. copied the files for asb 2.0.7 to the correct places
   

but I still get the following error

SQL Error:
1064 - 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 '1612' at line 2
Query:
SHOW TABLES FROM 1612

I did some digging around and found this in installer.php

private function build_table_list()
	{
		global $config;

		$query = $this->db->write_query("
			SHOW TABLES
			FROM {$config['database']['database']}
		");

		$table_list = array();
		while ($row = $this->db->fetch_array($query)) {
			$table_list[array_pop($row)] = 1;
		}
		return $table_list;
	}

which appears to be the offending code however it looks correct any ideas ?

---

I found the error .... this code works

private function build_table_list()
	{
		global $config;

		$query = $this->db->write_query("
			SHOW TABLES
			FROM `{$config['database']['database']}`
		");

		$table_list = array();
		while ($row = $this->db->fetch_array($query)) {
			$table_list[array_pop($row)] = 1;
		}
		return $table_list;
	}

notice the ` 's in the code ... this may be worth trying on other sql versions the original code failed on

Apache/2.4.6 (Ubuntu)
Database client version: libmysql - 5.5.35
PHP extension: mysqli

---

I am now getting this with my acp style
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1255 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1255 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1257 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1257 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1258 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1258 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1260 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1260 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1261 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1261 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1263 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1263 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1265 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1265 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Add
Title:

the display name
Filename:

the file name of the script
Action:

the URL action value
Page

the URL page value
Left Width

width of left column in pixels
Right Width

width of right column in pixels
Output Sideboxes To Variables Rather Than Editing Templates?
use this option if the script does not use templates to output the side box columns as $asb_left and $asb_right
Template:

name of the template to edit
Hook:

plugin hook to use
Header Search Text

ASB will place the side box tables just after the contents of this setting are found
Footer Search Text

ASB will place the side box tables just before the contents of this setting are found
Replacing entire template?
set to yes in order to replace the entire template with custom content

as stated before this is the only plugin causing this error and the error seems to jump from one function to another on asb plugin updates, I guess I will have to keep patching my themes style.php

---

I get this jscript error also



where would I find this in the code ?

also notice the 2 css differences ... i.e the navigation being shaded and the selected element having a background

(2012-12-26, 09:19 PM)Wildcard Wrote: [ -> ]

Advanced Sidebox v2.0.7 for MyBB 1.6.x

by Wildcard

MyBB Download Link (validated)

Managing side boxes is much easier with this plugin!

Features:

• Now compatible with Page Manager pages!
   
  
• AJAX Update integrated into the core and six of the core modules! (listed below)
  
• Create an unlimited amount of side boxes
  
• Control which script(s) the side boxes display in
  
• Manage modules to add new side box types easily.
  
• Create and save custom side box types that can be reused
  
• Side boxes that expand/collapse just like the MyBB core windows
  
• Side boxes use cookies to remember expand/collapse state
  
• Ability to disable the plugin for specific themes
  
• Intuitive side box management page in ACP
  
• Import/Export custom side boxes to XML to backup, restore and share
  
• Option for users to individually disable side boxes
  
• Extensible from plugins and single file modules
  
• Context-sensitive help pages in ACP
  
• Control which groups can view side boxes
  
• Each individual side box has unique settings to provide many more options for each side box type
  
• CodePress now supported when editing custom side boxes (if enabled in ACP)
  
• Simplification and seamless upgrade finalized throughout project including default add-on modules
  
• New Drag and Drop Interface
  
• Now Eight Total Scripts -- create an unlimited amount of custom script definitions!
  
• Easily Activate scripts or deactivate those you don't use to avoid clutter
  
• JavaScript visibility toggle icons for columns (uses cookies to remember states)
  
• Improved template handling
  
• Even better performance!

Current side box types available:

• Recent Posts (AJAX Capable)
  
• Who's Online (AJAX Capable)
  
• Latest Threads (AJAX Capable)
  
• Welcome
  
• Statistics
  
• Private Messages (AJAX Capable)
  
• Search
  
• Random Quotes (AJAX Capable)
  
• Staff Online (AJAX Capable)
  
• You can also create your own custom box types with static content
  
• Be sure to check out Tanweth's Poll Side Box Add-on!
  
  Now Available on GitHub: https://github.com/Tanweth/Poll-Box
  MyBB Release Thread: http://community.mybb.com/thread-145875.html

My forum has used this plugin since late 2011, although it has been in various stages of development at different times and I don't always use the latest version. It is stable and has shown only small issues that I have tried to fix as I've noticed.

Resources:

Support

I make no guarantees of support but I will always try.

For help with Installation and Upgrades look here: https://github.com/WildcardSearch/Advanc...stallation

Extensibility

This plugin uses single file modules to define different box types and contains plugin hooks whereby developers can hook in and created custom box types for the Admin to use.

See: Advanced Sidebox Extensibility Wiki

Bugs/Issues

Please report any problems found at the GitHub repository for this project.

https://github.com/WildcardSearch/Advanced-Sidebox

Make Advanced Sidebox Better!

Feel free to add advice or feedback. Go to GitHub and collaborate. Help and advice is welcome.

Screen Shots:

ACP



UCP



FORUM

Hello, you are have Weather-Box on Index. Plugin? Code? ThX