Wheres the Shortbus?

[Swimfin131]

(See title above)

We need a place to have some flaming fun with the noobs

PS : I Like the idea of "The Flaming Pit" :)

[RobotChild]

I didn't realize it had left.

[moonlit]

Ehh we kinda figured it wasn't really doing much just sitting there... was a good idea at the time, if you see what I mean.

[RobotChild]

Ehh we kinda figured it wasn't really doing much just sitting there... was a good idea at the time, if you see what I mean.

I sorta agree with that.

The only funny thing in there was Panarchy!

The rest was just spam-bots and such.

[Kateweb]

you could open it up for other Short buss stuff from around the net , could still be fun.

[SomeoneE1se]

thats not a bad idea you could put things like the kid trying to get someones steam User/pass and gets his stolen

[Kateweb]

thats not a bad idea you could put things like the kid trying to get someones steam User/pass and gets his stolen

why oh why can i see this as a skit?

[VaKo]

I just hid it for the moment :twisted:. We needed to come up with a way of de-n00bifiying the forums and surprisingly enough, shouting threats about compact public transport at them proved highly ineffective (massive increase of locked threads, mainly due to arguments about tiny transport). So its back to the drawing boards. My main thoughts for a second attempt is once again education, ie instead of flaming n00bs, we either ignore them or try and educate them. If they don't listen, just stop replying. And thus, we come to the Short Buss replacement, Newbie Questions. All the hack tejh skool, myspace pwning hotmail craxzing you can take and more. Thoughts?

As for a funnize forum, Everything Else should do nicely?

[Sparda]

I just hid it for the moment :twisted:. We needed to come up with a way of de-n00bifiying the forums and surprisingly enough, shouting threats about compact public transport at them proved highly ineffective (massive increase of locked threads, mainly due to arguments about tiny transport). So its back to the drawing boards. My main thoughts for a second attempt is once again education, ie instead of flaming n00bs, we either ignore them or try and educate them. If they don't listen, just stop replying. And thus, we come to the Short Buss replacement, Newbie Questions. All the hack tejh skool, myspace pwning hotmail craxzing you can take and more. Thoughts?

As for a funnize forum, Everything Else should do nicely?

I vote for editing phpBB to force every new member to watch a 30 -60 second flash animation about what not to do here. It might confuse spam bots as well ;)

[VaKo]

Make it work (flawlessly, 100% of the time) as a phpBB 2 plugin and we'll talk.

[Sparda]

Well, in theory it's easy, just add a if statement to the top of every .php file. This php runs a quick MySQL quarry that checks if they have watch it or not and it's sorted :P

[VaKo]

Plugin.

Working.

Make one?

I'm mail you a Stella.

[Sparda]

While it is simple, relitvly, I don't know enough php to do it my self. I'm looking at the code now, and it looks like it's going to be a if statement that sends a viewers browser to the flash page (using the header function) if it turns out that they haven't viewed it.

Any one willing to do the actual flash animation? :/

[Sparda]

I actually have cooked up some of the php necessary for this to work :D

This is all I have added:

if ((!$userdata['viewedthing'] == 2) && ($userdata['session_logged_in']))

{

$sql = "INSERT INTO " . USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id'];

if ( !$db->sql_query($sql, END_TRANSACTION) )

{

message_die(GENERAL_ERROR, "Could not insert user_id for poll", "", __LINE__, __FILE__, $sql);

}

Header("Location: http://sparda.hopto.org/ok.xml");

}

While that is only at line 262 in index.php, it will also need to be added to a couple of other php files to make it properly effective.

A more pressing matter, however, is that disspite my (weak) attempt at inserting the value 2 in to the viewedthing field where the correct userid is, it doesn't work, any one have any cluies? :/

If you want to help just PM me on IRC (Username = Boris).

[Guest]

I actually have cooked up some of the php necessary for this to work :D

This is all I have added:

if ((!$userdata['viewedthing'] == 2) && ($userdata['session_logged_in']))

{

$sql = "INSERT INTO " . USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id'];

if ( !$db->sql_query($sql, END_TRANSACTION) )

{

message_die(GENERAL_ERROR, "Could not insert user_id for poll", "", __LINE__, __FILE__, $sql);

}

Header("Location: http://sparda.hopto.org/ok.xml");

}

While that is only at line 262 in index.php, it will also need to be added to a couple of other php files to make it properly effective.

A more pressing matter, however, is that disspite my (weak) attempt at inserting the value 2 in to the viewedthing field where the correct userid is, it doesn't work, any one have any cluies? :/

If you want to help just PM me on IRC (Username = Boris).

The problem is probly with this line

$sql = "INSERT INTO " . USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id'];

Is Users_TABLE a var? if it is it should be

$sql = "INSERT INTO " .$USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id'];

if it isnt it should be

$sql = "INSERT INTO USERS_TABLE  (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id'];

[Sparda]

I tried using this on the server mysql and it says the syntax is invalid :/

mysql> INSERT INTO phpbb_users (viwedthing) VALUES (2) WHERE 'user_id' = 2;

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 'user_id' = 2' at line 1

I'v checked the spelling of fields and table names and they are correct, any one have any idea?

[Guest]

try this

mysql>INSERT INTO `phpbb_users` (`viwedthing`) VALUES (`2`) WHERE 'user_id' = 2;

are you sure you want to insert though, i would of though you would use update

mysql> UPDATE `phpbb_users` SET `viwedthing` = '2' WHERE `ID` =2;

[Sparda]

That worked, and thank you, SWEET!

The only thing this thing needs now is the actual flash animation ;)

A a few bits here and there, but the majority of it is done.

[cooper]

Could you do me a favor and see if this one would work?

INSERT INTO phpbb_users (viwedthing) VALUES (2) WHERE user_id = 2;

I have never, ever seen quoting in SQL except for the passing in of a string value. If MySQL complains about the above statement it would mean MySQL is even more broken than I thought...

[Guest]

I have never, ever seen quoting in SQL except for the passing in of a string value. If MySQL complains about the above statement it would mean MySQL is even more broken than I thought...

You dont actually use the quote, most sql servers require you to use the ` ( ` != ' ) around table names and table colums

[Kateweb]

That worked, and thank you, SWEET!

The only thing this thing needs now is the actual flash animation ;)

A a few bits here and there, but the majority of it is done.

give me a basic scrip as to what you want in it and I'll do it, tho some one will have to do the sound because I don't have a mic .

[SomeoneE1se]

The crew needs to do the audio

use http://www.hak5.org/wiki/forum_intro_script to edit the script.. I'd start it off but I'm too tired to make sense... I'll help in the morning

[Kateweb]

ok so i wrote some of what i think should be thair , once we have the script done tho anyone who has ever done anamation know that you should do the audio first it saves some much hair pullling.

[SomeoneE1se]

I fixed it up a bit and added to it but now I'm wondering if we should use flash or video

and the script I've started would be acted by Darren and Wess... Guys if your reading this let me know if this is a problem

[Sparda]

I like my method ;), the only thing that the flash needs to do is to except options from the html (you know, like flashobject.swf?options) and it'll be brill.