Request

[martin123456]

Vote Keywen Encyclopedia Links [Bot] for President!

I like this feature i don't think many have noticed it i can't really see any need for it or what use it is but i really do like it yes i know i'm sad

[Stoker]

I saw something similar at phpbbmodders

Add this to index.php, just before // Assign index specific vars

Code: Select all

switch ($db->sql_layer)
{
	case 'postgres':
		$order_by = 'RANDOM()';
	break;

	case 'mssql':
	case 'mssql_odbc':
		$order_by = 'NEWID()';
	break;
	
	default:
		$order_by = 'RAND()';
	break;
}

$sql = 'SELECT user_id, user_type, username, user_colour
	FROM ' . USERS_TABLE . ' WHERE user_type = 2
	ORDER BY ' . $order_by;
$result = $db->sql_query_limit($sql, 1);

while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('users', array(
'BOT_NAME'		=> $row['username'],
'BOT_COLOUR'	=> $row['user_colour'],
));
}
$db->sql_freeresult($result);

and then to index_body.html

Code: Select all

<!-- IF not S_IS_BOT -->
	<!-- BEGIN users --><div style="text-align:center;"><p>Vote <span style="font-weight:bold; color:#{users.BOT_COLOUR};">{users.BOT_NAME}</span> for President!</p></div><!-- END users -->
	<!-- ENDIF -->

[martin123456]

cheers buddy now i'm happy

[Blackwolf]

Me too Thanks!!

My bots are #999900 any reason that it's not showing as that colour?

I assumed it would inherit the code ?

Code: Select all

'BOT_COLOUR'   => $row['user_colour'],

[Stoker]

Same here. But I never noticed
You can set a colour manually in the template.

[Blackwolf]

Same here. But I never noticed
You can set a colour manually in the template.

Done

[Stoker]

Found the bug. Its in the index_body.html edit.
Find:

Code: Select all

{users.BOT_COLOUR}

Replace with:

Code: Select all

#{users.BOT_COLOUR}

First post updated.

[Blackwolf]

Thanks for the fast fix.

[Stoker]

To display random users from a specific group change this code from index.php:

Code: Select all

WHERE user_type = 2

to

Code: Select all

WHERE group_id = 7

7 is the group ID

[mikef35]

To display random users from a specific group change this code from index.php:

Code: Select all

WHERE user_type = 2

to

Code: Select all

WHERE group_id = 7

7 is the group ID

That is not working, I have it set to 2 right now like in your code and it displays the random BOT, my bot group id is 6. So when I change it to a real group number I get nothing.