vB-DOS turning quick reply into command prompt

All right, its been a while since i released something here.
Lets hope that i dont have anymore bad experinces with releasing programs here, cause i like sharing my projects with you guys.

vB-DOS is a potentialy powerful script that integrates with the vbulletin reply system. When you make a post it checks to see if you have a command word in it. If you do it then runs the proper script for that command. You can also make commands simply post a reply with an answer, for example, if you make the command !help and you set the reply to list some other commands, and leave the command field at 0 it will simply post a reply with the answer to the command you gave.
However the powerful part of this, is you can run php scripts with commands. Included with the install file are 4 common commands, that make moderating your forums easier.

!deletethread -- when this is posted by an admin, it deletes the thread it was posted in.

!dumpthread -- when this is posted by an admin or smod, it moves the thread to the assigned dump forum

!closethread -- when this is posted by an admin or smod , it closes the thread it was posted in

!openthread -- when posted by an admin or smod, it opens a closed thread it was posted in.


This script helps me alot, and my mods appriciate it. If you use it and make custom commands, please share them here, as i have shared this program with you.

Ill post all shared commands in this post, please include a description with your command that you share.

Demo
www.tfogame.com (there is a post in the news forum about it saying tfo computer, keep to that thread for testing it please) The !help command lists some userside faq commands.

Shared Commands
Stick thread - by zajako
sticky's a thread.

PHP Code:

INSERT INTO `comp_keywords` VALUES (null, '!stickthread', 'if($bbuserinfo[usergroupid] == 6 || $bbuserinfo[usergroupid] == 5){\r\n    $DB_site->query("UPDATE thread SET sticky=\'1\' WHERE threadid=\'$threadid\'");\r\n    $goto="showthread.php?s=$session[sessionhash]&threadid=$threadid";\r\n    eval("standardredirect(\\""."Thread Stuck"."\\",\\"$goto\\");");\r\n}else{\r\n    $dosmess="You do not have permission to do said command.";\r\n}', 1); 


UnStick thread - by zajako
unsticky's a thread.

PHP Code:

INSERT INTO `comp_keywords` VALUES (null, '!unstickthread', 'if($bbuserinfo[usergroupid] == 6 || $bbuserinfo[usergroupid] == 5){\r\n    $DB_site->query("UPDATE thread SET sticky=\'0\' WHERE threadid=\'$threadid\'");\r\n    $goto="showthread.php?s=$session[sessionhash]&threadid=$threadid";\r\n    eval("standardredirect(\\""."Thread Stuck"."\\",\\"$goto\\");");\r\n}else{\r\n    $dosmess="You do not have permission to do said command.";\r\n}', 1); 


Hide thread - by zajako
Makes a post non visible

PHP Code:

INSERT INTO `comp_keywords` VALUES (null, '!hidethread', 'if($bbuserinfo[usergroupid] == 6 || $bbuserinfo[usergroupid] == 5){\r\n    $DB_site->query("UPDATE thread SET visible=\'0\' WHERE threadid=\'$threadid\'");\r\n    $goto="showthread.php?s=$session[sessionhash]&threadid=$threadid";\r\n    eval("standardredirect(\\""."Thread Stuck"."\\",\\"$goto\\");");\r\n}else{\r\n    $dosmess="You do not have permission to do said command.";\r\n}', 1); 


Show thread - by zajako
makes an invisible post visible

PHP Code:

INSERT INTO `comp_keywords` VALUES (null, '!showthread', 'if($bbuserinfo[usergroupid] == 6 || $bbuserinfo[usergroupid] == 5){\r\n    $DB_site->query("UPDATE thread SET visible=\'1\' WHERE threadid=\'$threadid\'");\r\n    $goto="showthread.php?s=$session[sessionhash]&threadid=$threadid";\r\n    eval("standardredirect(\\""."Thread Stuck"."\\",\\"$goto\\");");\r\n}else{\r\n    $dosmess="You do not have permission to do said command.";\r\n}', 1); 


[Zachery]

Originally Posted by Apoco

wow....truely amazing. Great Job!

ill take a look into porting it then zaj

[NuclioN]

Great a !help command would be nice but this has a lot of potential. Well done.

[zajako]

thanks NuclioN

[Gio Takahashi]

EDIT:
Nevermind I misread, as I look over it again, this looks VERY sweet I think Im going to try this out on my forums.

Infact..I will! ::installs::

[zajako]

you dont have to register to view the news forum. You can take a look at the thread about tfo computer.

[Gio Takahashi]

I have a friend who is very good with coding language, I think he and I will come up with additional commands for this little thing. Looks fun.

[Dean C]

This is one of the most innovative ideas I've ever seen on vBulletin.org. Along with Logician's dynamic templates this will be one of my most happiest installs. I can see a few potential flaws whilst looking at the code. Would be nice to do command permissions via usergroup or individual users. Also i'm sure there must be some better way of storing the commands in the database other than in the $DB_site->query() format. I can't think of the top of my head but it seems like an obvious security flaw. Perhaps hashing the query would a bit more secure.

Also how about a command creator. You enter your table/tables which you wish to perform commands for the particular command. Then for each table you select you have a dropdown for UPDATE,INSERT,DELETE FROM, and so on. Then you have a selection of where clauses where it detects the fields from the table and you have a dropdown for those.

Maybe i'm getting carried away but I just love the idea of this modification

All the best,
- Dean

[zajako]

cool gio, thanks.

mist thinks for your compliments, i too see great potential in this hack, however i know i dont have the time to make a command creator script. I can make a admin panel page for adding them but as for making a script that creates php, that would take more time than i have right now.

maybe in the future or if somone else wants to make it as an addon.

[Gio Takahashi]

I'd LOVE to see that command creator script going someday, this hack is just incredible, I just tested it on my forums, it worked like a charm! Great hack!

[Erwin]

Great idea - one of the most original ideas released here. Well done.