[phpBB] Compteur pour flashchat et phpBB

Bonjour!

A tu trouver une solution car moi j'ai trouver un script qui normalement doit le faire..

Le probleme c'est que cela me genere un message d'erreur a cause de la table CONNECTIONS
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
############################################################## 
## MOD Title: User in FlashChat
## MOD Author: Leuchte < mail@leuchte.net > http://www.leuchte.net 
## MOD Description: Dieser Mod zeigt im Index die User die sich im (Flash)Chat befinden.
## Dieser Mod benötigt den FlashChat von http://www.easterpig.com
##
## MOD Version: 1.0.0
## 
## Installation Level: Leicht 
## Installation Time: 5 Minuten 
## Files To Edit: 3
##
##			lang_main.php
##			index.php
##			includes/constants.php
##			templates/subSilver/index_body.tpl
##
## Included Files: 0 
############################################################## 
## For Security Purposes, Please Check: http://www.leuchte.net/mods/ for the 
## latest version of this MOD.
## 
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################
## MOD History:
##
##   2004-10-03 - Initial Release
##
############################################################## 
# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_german/lang_main.php 
 
# 
#-----[ FIND ]------------------------------------------ 
# 
?>
 
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
$lang['More_Chatuser'] = 'Es sind <b>%s</b> User im Chat.';
$lang['One_Chatuser'] = 'Es ist <b>ein</b> User im Chat.';
$lang['None_Chatuser'] = 'Es ist <b>kein</b> User im Chat.';
 
# 
#-----[ OPEN ]------------------------------------------ 
# 
index.php 
 
# 
#-----[ FIND ]------------------------------------------ 
# 
//
// Generate the page
 
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
$sql = "SELECT u.username, u.user_level, u.user_id
FROM ". CONNECTIONS ." c, ". USERS_TABLE ." u
WHERE u.user_id = c.userid
ORDER BY u.username ASC";
if ( !($result = $db->sql_query($sql)) )
{
  message_die(GENERAL_ERROR, 'Could not get user data', '', __LINE__, __FILE__, $sql);
}
  $chatnums = $db->sql_numrows($result);
  $user = array();
  while ( $row = $db->sql_fetchrow($result) )
  {
    $user[] = $row;
  }
 
  for($i = 0; $i < count($user); $i++)
  {
    $style_color = '';
		if ( $user[$i]['user_level'] == ADMIN )
		{
		  $user[$i]['username'] = '<b>' . $user[$i]['username'] . '</b>';
			$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
		}
		else if ( $user[$i]['user_level'] == MOD )
		{
			$user[$i]['username'] = '<b>' . $user[$i]['username'] . '</b>';
			$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
		}
 
		$user_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $user[$i]['user_id']) . '"' . $style_color .'>' . $user[$i]['username'] . '</a>';
		$userlist .= ( $userlist != '' ) ? ', ' . $user_link : $user_link;
 
   }
 
    if ( $chatnums == 0 )
    {
      $l_chat_user_s = $lang['None_Chatuser'];
    }
    else if ( $chatnums == 1 )
    {
      $l_chat_user_s = $lang['One_Chatuser'];
    }
    else
    {
      $l_chat_user_s = $lang['More_Chatuser'];
    }
 
    $template->assign_vars(array(
      'USERNAMES' => $userlist,
      'CHATCOUNT' => sprintf($l_chat_user_s, $chatnums))
    ); 
 
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/constants.php
 
# 
#-----[ FIND ]------------------------------------------ 
#
define('CONFIG_TABLE', $table_prefix.'config');
 
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
define('CONNECTIONS', $table_prefix.'connections');
 
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/index_body.tpl
 
# 
#-----[ FIND ]------------------------------------------ 
#
/>{LOGGED_IN_USER_LIST}</span></td>
  </tr>
 
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
  <tr>
  <td class="row1" align="left" width="100%"><span class="gensmall">{CHATCOUNT}<br />{USERNAMES}</span></td>
  </tr>
 
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM