[2.0.15] User Gag

[Extensions Robot]

MOD Name: User Gag
Author: Swizec
MOD Description: Pick someone thus making them view all posts in binary code and think, WTF?!? Guess it could be fun at times.


MOD Version: 1.0.1

Download File: gag_1.0.1_.mod
mods overview page: View
File Size: 5970 Bytes

Security Score: 0

[TerraFrost]

MOD Validated/Released

Notes:
Allows administrators to play practical jokes on members.

[Swizec]

this is a fun mod, really

demo at: http://swizec.com/forum
username: gaged
password: joke

try it

[dESiLVer]

very very fun mod thanks swizec this mod me to work too

[ChaosBringer]

lol, kool mod. its a very funny thing :D

[pavel01]

I am not sure how to do the very first thing, to edit the phpbb_users thing, can someone please tell me how this is done ???

[Swizec]

I am not sure how to do the very first thing, to edit the phpbb_users thing, can someone please tell me how this is done ???

it's all there in the .mod file, just do what it says and you'll be fine

[pavel01]

It says this:

#
#-----[ SQL ]------------------------------------------
#

ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL ;

#


and I don't know how to do this, i am in mySQL phpmyAdmin and I don't know how to do this line, can someone please lead me through this ???

[3Di]

It says this:

#
#-----[ SQL ]------------------------------------------
#

ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL ;

#


and I don't know how to do this, i am in mySQL phpmyAdmin and I don't know how to do this line, can someone please lead me through this ???

select your database (left window), press SQL (up in the screen), insert this query in the input window:

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL ;

click GO.

[pavel01]

Ok this was in the window already:

SELECT * FROM `phpbb_users` WHERE 1

I deleted that and I added what you told me to put in, then it gave me a message:

Database masterforums_com_-_phpbb - Table phpbb_users running on localhost
Error

SQL-query :

ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL

MySQL said:


#1060 - Duplicate column name 'user_binary'

[Documentation] · [Back]

I then tried it while leaving what was in the wondow originaly and this came up after I clicked GO:

Database masterforums_com_-_phpbb - Table phpbb_users running on localhost
Error

SQL-query :

SELECT *
FROM `phpbb_users`
WHERE 1
ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT NULL LIMIT 0 ,
30

MySQL said:


#1064 - You have an error in your SQL syntax near 'ALTER TABLE `phpbb_users` ADD `user_binary` TINYINT( 1 ) DEFAULT '0' NOT ' at line 4

[Documentation] · [Back]

Is that bad or good ?

[Swizec]

#1060 - Duplicate column name 'user_binary'

means you seem to have already succesfully made the query as the column exists

[ZyreXiaix]

Before I install this MOD, can you select multiple users to see binary posts or one user only?

[Swizec]

it's a per user setting, so you can select all fo them if you wish

[Saoshyant]

For the geek
I loved it.

[James78]

thats so cool. you can play this as a joke on spammers/annoying people. plus its easy and fast to install . congragulations on the great MOD