[2.0.15] User Gag

The cleanup is complete. This forum is now read only.

Rating:

Excellent!
8
62%
Very Good
3
23%
Good
0
No votes
Fair
1
8%
Poor
1
8%
 
Total votes: 13

Extensions Robot
Extensions Robot
Extensions Robot
Posts: 27954
Joined: Sat Aug 16, 2003 7:36 am

[2.0.15] User Gag

Post by Extensions Robot » Mon May 30, 2005 10:41 pm

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
Last edited by Extensions Robot on Mon Apr 30, 2007 12:27 am, edited 1 time in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)

TerraFrost
Former Team Member
Posts: 5957
Joined: Sun Dec 26, 2004 3:40 am
Location: Austin, TX

Post by TerraFrost » Wed Jun 15, 2005 7:02 pm

MOD Validated/Released

Notes:
Allows administrators to play practical jokes on members.

Swizec
Former Team Member
Posts: 1701
Joined: Mon Mar 10, 2003 9:42 pm
Location: Slovenia
Contact:

Post by Swizec » Wed Jun 15, 2005 7:36 pm

this is a fun mod, really

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

try it ;)

dESiLVer
Registered User
Posts: 50
Joined: Wed May 04, 2005 9:26 pm
Location: Turkey
Contact:

Post by dESiLVer » Wed Jun 15, 2005 11:33 pm

very very fun mod :lol: thanks swizec this mod me to work too ;)

ChaosBringer
Registered User
Posts: 412
Joined: Mon Apr 19, 2004 11:30 pm
Contact:

Post by ChaosBringer » Thu Jun 16, 2005 12:06 am

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

pavel01
Registered User
Posts: 172
Joined: Sun Nov 09, 2003 10:22 pm
Contact:

Post by pavel01 » Tue Jun 28, 2005 11:47 pm

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 ???
My Website . Once you are there click on "Main Forum"

Swizec
Former Team Member
Posts: 1701
Joined: Mon Mar 10, 2003 9:42 pm
Location: Slovenia
Contact:

Post by Swizec » Wed Jun 29, 2005 12:24 am

pavel01 wrote: 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
Registered User
Posts: 172
Joined: Sun Nov 09, 2003 10:22 pm
Contact:

Post by pavel01 » Wed Jun 29, 2005 1:28 am

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 ???
My Website . Once you are there click on "Main Forum"

User avatar
3Di
Former Team Member
Posts: 14062
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Post by 3Di » Wed Jun 29, 2005 1:39 am

pavel01 wrote: 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.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

pavel01
Registered User
Posts: 172
Joined: Sun Nov 09, 2003 10:22 pm
Contact:

Post by pavel01 » Wed Jun 29, 2005 3:08 am

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 ?
My Website . Once you are there click on "Main Forum"

Swizec
Former Team Member
Posts: 1701
Joined: Mon Mar 10, 2003 9:42 pm
Location: Slovenia
Contact:

Post by Swizec » Wed Jun 29, 2005 7:28 am

#1060 - Duplicate column name 'user_binary'

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

ZyreXiaix
Registered User
Posts: 192
Joined: Tue Nov 09, 2004 4:17 pm
Location: Northeast Ohio
Contact:

Post by ZyreXiaix » Mon Jul 04, 2005 4:45 am

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

Swizec
Former Team Member
Posts: 1701
Joined: Mon Mar 10, 2003 9:42 pm
Location: Slovenia
Contact:

Post by Swizec » Mon Jul 04, 2005 4:51 am

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

Saoshyant
Registered User
Posts: 77
Joined: Thu Feb 03, 2005 3:35 pm
Location: Portugal

Post by Saoshyant » Tue Jul 05, 2005 5:39 am

For the geek :D
I loved it.

User avatar
James78
Registered User
Posts: 811
Joined: Sat Jul 30, 2005 4:54 pm
Location: Washington, USA
Contact:

Post by James78 » Thu Aug 04, 2005 4:26 pm

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

Post Reply

Return to “[2.0.x] MOD Database Cleanup”