Jump to content

Wheres the Shortbus?


Swimfin131

Recommended Posts

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?

Link to comment
Share on other sites

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 ;)

Link to comment
Share on other sites

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? :/

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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'];

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 .

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...