REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
EZsql v2
#1
License is attached inside extras folder by using this software you agree to the terms of that license.

Plugin Name: EZsql
Plugin Author: Jesse Labrocca
Plugin Website: http://www.MybbCentral.com
Plugin Version: 2.0
Plugin Mybb Compatibility: 1.4x
Plugin File Edits: None
Plugin File Uploads: 1
Plugin Description: This allows the Super Admin to run sql queries from the admincp. This is a VERY dangerous and powerful tool. Please use it responsibly.

Installation

1. Upload the file from the zip
ROOT/inc/plugins/ezsql.php

2. Login to your admincp and ACTIVATE the plugin (EZsql) in the plugin manager.

You will now have an EZsql option under "Tools & Maintenance" in admincp. This will only work for

That's it.

This version has no language support nor any demos available. Screenshots available inside the extras folder.

NOTE: This is also only tested on mysql but please report back to me if you have errors or if this is not compatible with another sql. I don't expect all commands to work but the basics are tested and this can be very helpful to those that know their way around sql queries.


Attached Files Thumbnail(s)
               

.zip   EZsql_v2.zip (Size: 74.44 KB / Downloads: 256)
#2
WOW. Brilliant, thanks for updating it so quick, this is great.
#3
oh lala again wonderful thank you so much
#4
thanks, this is great
#5
hi labrocca
can u say me how can force all user to classicpostbit
exp
Code:
UPDATE `mybb_users` SET `classicpostbit` = '1' WHERE `classicpostbit` = '0'
i relay dangerous can you make a screen shot for this
thank you so much
br
#6
Yes, just run that.... make a database backup first if you're worried about anything.
#7
Does this only allow the root admin to use it? If so, might be cool. :]
#8
(Jan 07, 2009, 07:45 PM)labrocca Wrote: This allows the Super Admin to run sql queries from the admincp.

Yep Big Grin
#9
Awesome!

Thats what im looking for Smile

Thanks for this labrocca it works fine.
-Rafael
vBulletin Developer
My Forum
My Blog
#10
Question 
Had to remove the
Code:
&& $mybb->user['uid'] == $config['super_admins']

from the plug in file in the if statement to get this to work .
My set up
MyBB ver 1.4.13
config.php :- $config['super_admins'] = '1,2,13135';

I am User 13135 at http://forum.punktorrents.com
as i said , the only way i could get a result to show
eg. Select * From mybb_posts;
Was to remove the verification line above
Any ideas?
Still works with that removed so FANTASTIC mod
Just curious as to why its not reading the permissions correctly from the config.php
EDIT:- Also is their a way to get this mod to say limit the results per page?
eg ..We have almost a million posts
if i ran :- Select * From mybb_posts;
it would just time out and return to the ezysql page with no results
I know I could add
select * from mybb_posts limit 0 , 500
to return the first 500
select * from mybb_posts limit 501 , 1000
for the next etc etc
(Btw i have only tried up to 500 results and they returned fine although the wild without the limit returned nothing)
So my question is , can this be modified ( like phpmyadmin ) to only return say 200 results but then let you goto the next 200
either by a page list or next button ?
Not a biggy , just wondering if it could happen inside mybb and this plugin Big Grin
PunkTorrents.com


Forum Jump:


Users browsing this thread: 1 Guest(s)