http://bbpress.org/forums/ bbPress support forums User Favorites: MaryJane en Sat, 22 Nov 2008 22:57:11 +0000 http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9867 Fri, 03 Aug 2007 20:20:55 +0000 Null 9867@http://bbpress.org/forums/ <p>Hmmm got this error:<br /> Warning: Invalid argument supplied for foreach() in /home/sites/site116/web/bbpress/my-plugins/bbmenu.php on line 390</p> <p>the foreach:<br /> foreach( $r1 as $rw ) {</p> <p>Null </p> http://bbpress.org/forums/topic/theme-question#post-9814 Thu, 02 Aug 2007 21:13:12 +0000 MaryJane 9814@http://bbpress.org/forums/ <p>Thank you so10! That website was very helpful. I now have a css switcher instead of just a theme switcher. </p> http://bbpress.org/forums/topic/theme-question#post-9787 Thu, 02 Aug 2007 11:26:00 +0000 so1o 9787@http://bbpress.org/forums/ <p>you can also try css switching..<br /> create three stylesheets and let users select which one they want. </p> <p><a href="http://www.alistapart.com/stories/alternate/" rel="nofollow">http://www.alistapart.com/stories/alternate/</a> </p> http://bbpress.org/forums/topic/theme-question#post-9779 Thu, 02 Aug 2007 06:33:16 +0000 MaryJane 9779@http://bbpress.org/forums/ <p>Well i knew about the wordpress theme switcher. What i was really wondering was if someone had already made one for bbpress or was currently making one i guess. Or if there was another way to do what i wanted without having to use a theme switcher. </p> <p>Thank you for the link though. Ill look at it. </p> http://bbpress.org/forums/topic/theme-question#post-9776 Thu, 02 Aug 2007 06:18:17 +0000 HowToGeek 9776@http://bbpress.org/forums/ <p>It sounds like you really have a wordpress question since everything is running under wordpress... but here's a plugin for wordpress to switch themes (I haven't tried it myself)</p> <p><a href="http://dev.wp-plugins.org/wiki/ThemeSwitcher" rel="nofollow">http://dev.wp-plugins.org/wiki/ThemeSwitcher</a></p> <p>I don't believe there is one for bbPress at the moment, considering there aren't a lot of themes out there. </p> http://bbpress.org/forums/topic/theme-question#post-9774 Thu, 02 Aug 2007 06:13:43 +0000 MaryJane 9774@http://bbpress.org/forums/ <p>I have a theme i ported over to wp and bbpress. It has the option of being one, two and three column's layout. Im working on getting the other columns ported over i have the basic three column working now. </p> <p>Theres links under the header to click to switch to each column layout. I want to keep this feature to offer my members. My question is there a simple way for me to let users switch columns? Like using a theme switcher or some other way? Ive searched the support forum here and so far i havent found a user theme plugin switcher on here. Is there one made that im overlooking? Even if there was one just because a user switched themes in the forum doesnt mean it would switch themes in the wordpress.... </p> <p>Can someone help me figure out to accomplish this?</p> <p>website url: <a href="http://slickwhenwet.com/forum" rel="nofollow">http://slickwhenwet.com/forum</a> &lt;-- work in progress </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9747 Wed, 01 Aug 2007 21:57:25 +0000 Null 9747@http://bbpress.org/forums/ <p>I have that TortoiseSVN installed, still need to figure out how to let this update the trac aswell :) </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9745 Wed, 01 Aug 2007 21:51:47 +0000 fel64 9745@http://bbpress.org/forums/ <p>You need something like TortoiseSVN that'll let you apply patches to files. </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9741 Wed, 01 Aug 2007 21:37:41 +0000 Null 9741@http://bbpress.org/forums/ <p>Testing this tomorrow after work.... nah after diner after work :)</p> <p>Thx for the help mate!</p> <p>_Null</p> <p>ps. how to open a .diff?? (windows machine) </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9737 Wed, 01 Aug 2007 19:18:42 +0000 box87 9737@http://bbpress.org/forums/ <p>The new changes have been made:<br /> <a href="http://www.box.net/shared/cgrj1na0t7" rel="nofollow">http://www.box.net/shared/cgrj1na0t7</a></p> <p>I think that should cover the problems. I took the liberty of changing other things as well... hope you don't mind. I removed some redundancies in the CSS, and changed some little code things.<br /> There's the modified <code>bbmenu.php</code> file, as well as the diff file to make it a little easier for you to see what I changed. If you cant make sense of the diff there are diff file viewers that color the text and make it more human-readable. </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9715 Wed, 01 Aug 2007 15:05:51 +0000 box87 9715@http://bbpress.org/forums/ <p>@Null - Working on it...<br /> Don't lose hope :)</p> <p>Sorry about the "day or so"... </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9692 Wed, 01 Aug 2007 01:22:03 +0000 MaryJane 9692@http://bbpress.org/forums/ <p>I dont need to download phpmyadmin. I already have it with my hosting. Thats what i used to make the table to bein with. Since i cant get this to work without a bunch of errors ive disabled it until a better solution is figured out. </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9652 Tue, 31 Jul 2007 08:56:35 +0000 Null 9652@http://bbpress.org/forums/ <p>@ MaryJane download and use phpMyAdmin. It gives you acces to you database. You still need to know how to make/use SQL queries though :(</p> <p>@Box, dude had any time to help me out with the bbMenu plugin thingy? I want to fix this issue before I start with the next version (using jquery and fixing alot of bugs)</p> <p>Thx </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9636 Tue, 31 Jul 2007 02:35:14 +0000 MaryJane 9636@http://bbpress.org/forums/ <p>Im having the same issue with this plugin. I switched all my tags to $bbdb-&gt;get_results and it stoped the errors. But i never got this plugin to work i just got the errors gone. It never created the table. I manually created the table but i dont know how to populate it with the neccessary information needed. Also since it never created the table im assuming thats why i never saw a admin link to it in my admin control panel. Does anyone know how to manually populate a table? Or can you make a .sql file that manually creates and fill this table for me?</p> <p>Thank you. </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9251 Mon, 23 Jul 2007 17:12:22 +0000 Null 9251@http://bbpress.org/forums/ <p>Okay okay, 1 day :) (just kidding) </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9247 Mon, 23 Jul 2007 15:58:43 +0000 box87 9247@http://bbpress.org/forums/ <p>Give me a day or so and I'll work on it. I've got about three jobs going at the moment. </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9236 Mon, 23 Jul 2007 07:34:31 +0000 Null 9236@http://bbpress.org/forums/ <p>Hi,</p> <p>Wheren't you the guy that fixed (or claimed to have fixed) this particulair error I had with the bbMenu plugin?</p> <p>Thinking... yeah you where it, you said you fixed it using $bbdb-&gt;get_results. So I replaced all mysql_query() with it, but this caused an error with the mysql_fetch_array. So what more did you change? Cause I can't seem to fix it :( I can hardly program, so some help plz :)</p> <p>Thx </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9235 Mon, 23 Jul 2007 07:33:54 +0000 Null 9235@http://bbpress.org/forums/ <p>-double post- </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9228 Sun, 22 Jul 2007 22:28:24 +0000 box87 9228@http://bbpress.org/forums/ <p>Stick with the ezSQL format... it'll be much easier.<br /> Something like this (using <code>foreach</code> instead of <code>while</code>):</p> <pre><code>$query = &quot;SELECT * FROM $bbdb-&gt;menu WHERE set = &#39;inactive&#39; ORDER BY order ASC&quot;; $r = $bbdb-&gt;get_results( $query ); foreach( $r as $rw ) { // now mess with $rw echo $rw-&gt;database_row . &quot;&lt;br&gt;\n&quot;; }</code></pre> <p>Something that might be helpful would be to browse the source of the ezSQL class in <code>/wp-includes/wp-db.php</code></p> <p><em>The latest from Justin Vincent, the author</em><br /> <a href="http://www.woyano.com/jv/ezsql" rel="nofollow">http://www.woyano.com/jv/ezsql</a></p> <p><em>The version used in bbPress and WordPress</em><br /> <a href="http://trac.wordpress.org/browser/trunk/wp-includes/wp-db.php" rel="nofollow">http://trac.wordpress.org/browser/trunk/wp-includes/wp-db.php</a></p> <p>It might help you... you'd be able to see where <code>mysql_query</code> is begin used, and how to use the ezSQL format best.</p> <p>I think the reason you're running into problems with <code>mysql_fetch_array</code> is because it's already used.<br /> Not sure on that one though... I would have to check.</p> <p>Also, what might cause an error: <code>$bbdb-&gt;query</code> will not return anything at all. <code>$bbdb-&gt;get_results</code> needs to be used for multi-dimensional array data, <code>$bbdb-&gt;get_row</code> or <code>$bbdb-&gt;get_col</code> need to be used for single array data, and <code>$bbdb-&gt;get_var</code> needs to be used for non-array/string data. <code>$bbdb-&gt;query</code> is used for inserting data, the others are used for retrieving it.</p> <p>Someone correct me if I'm wrong, but I'm pretty positive that's how it goes.<br /> ezSQL is lovely. It certainly takes the pain out of MySQL data manipulation.</p> <p>So I guess that makes the answer to your question "Neither." <code>$bbdb-&gt;get_results</code> should do the trick.<br /> And sorry for the screed. :D </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9225 Sun, 22 Jul 2007 17:57:44 +0000 Null 9225@http://bbpress.org/forums/ <p>Or use:<br /> $bbdb-&gt;query ?? </p> http://bbpress.org/forums/topic/mysql_query-or-bbdb-gtget_results-#post-9222 Sun, 22 Jul 2007 15:47:48 +0000 Null 9222@http://bbpress.org/forums/ <p>Hi,</p> <p>I currently have an API problem fixing a plugin. Using mysql_query() will result in errors on some boards so I wanted to change this using $bbdb-&gt;get_results(). This works, but mysql_fetch_array will error things up now. What do I need to change to make this work correctly?</p> <p>Current code (without using $bbdb-&gt;get_results()):<br /> <pre><code>$r = mysql_query(&quot;SELECT * FROM $bbdb-&gt;menu WHERE set = &#39;inactive&#39; ORDER BY order ASC&quot;); while($rw = mysql_fetch_array($r))</code></pre>