Files

70 lines
3.7 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
class Role
{
public static $table = 'chat_roles';
// update `chat_roles` set canCreateDynamicRoomNumber=5 where role in ('admin', 'moderator')
public static function createDefaultRoles($webmasterid) {
DB::insert(Role::$table, array('role' => 'admin', 'webmasterid' => $webmasterid, 'canKick'=>1, 'canBan'=>1, 'canBroadcast'=>1, 'canPostYouTube'=>1, 'canDeleteUserMessages'=>1, 'canBeKicked'=>0, 'canBeBanned'=>0, 'canBeMuted'=>0, 'canBeMutedPrison'=>0, 'canCreateDynamicRoomNumber'=>5,
'canMute'=>1, 'canAccessPasswordProtecedRooms'=>1, 'canPromote'=>1, 'canBePromoted'=>0, 'power'=>9, 'canEnterChatAdmin'=>1, 'canMutePrison'=>1,
'canChangeAvatar'=>1, 'conference_canUsersShowWebcamInPublic'=>1, 'canGetIP'=>1 ));
DB::insert(Role::$table, array('role' => 'moderator', 'webmasterid' => $webmasterid, 'canKick'=>1, 'canBan'=>1, 'canBroadcast'=>1, 'canPostYouTube'=>1, 'canDeleteUserMessages'=>1, 'canBeKicked'=>0,
'canBeBanned'=>0, 'canBeMuted'=>0, 'canBeMutedPrison'=>0,'canCreateDynamicRoomNumber'=>5, 'canMute'=>1, 'canAccessPasswordProtecedRooms'=>1, 'power'=>8, 'canMutePrison'=>1,
'canChangeAvatar'=>1, 'conference_canUsersShowWebcamInPublic'=>1, 'canGetIP'=>1));
DB::insert(Role::$table, array('role' => 'performer', 'webmasterid' => $webmasterid, 'canKick'=>1, 'canBan'=>1, 'canBroadcast'=>1, 'canPostYouTube'=>1, 'canDeleteUserMessages'=>1, 'canBeKicked'=>0,
'canBeBanned'=>0, 'canBeMuted'=>0, 'canBeMutedPrison'=>0,'canCreateDynamicRoomNumber'=>5, 'canMute'=>1, 'power'=>7, 'canChangeAvatar'=>1, 'conference_canUsersShowWebcamInPublic'=>1));
DB::insert(Role::$table, array('role' => 'dj', 'webmasterid' => $webmasterid, 'canKick'=>1, 'canBan'=>0, 'canBroadcast'=>1, 'canPostYouTube'=>1, 'canDeleteUserMessages'=>0, 'power'=>6,
'canChangeAvatar'=>1, 'conference_canUsersShowWebcamInPublic'=>1));
DB::insert(Role::$table, array('role' => 'user', 'webmasterid' => $webmasterid, 'power'=>5, 'canChangeAvatar'=>1));
DB::insert(Role::$table, array('role' => 'custom1', 'webmasterid' => $webmasterid, 'power'=>4));
DB::insert(Role::$table, array('role' => 'custom2', 'webmasterid' => $webmasterid, 'power'=>4));
DB::insert(Role::$table, array('role' => 'custom3', 'webmasterid' => $webmasterid, 'power'=>4));
DB::insert(Role::$table, array('role' => 'seller', 'webmasterid' => $webmasterid, 'power'=>4, 'selectUserAndShowWebcam'=>1));
DB::insert(Role::$table, array('role' => 'buyer', 'webmasterid' => $webmasterid, 'power'=>4));
DB::insert(Role::$table, array('role' => 'guest', 'webmasterid' => $webmasterid, 'canSendPrivate'=>1, 'canWhisper'=>1, 'power'=>0, 'canAddRoomToFavori'=>0));
}
/*
* insert into chat_roles (webmasterid, role,canKick, canBan, canBroadcast, canPostYouTube, canDeleteUserMessages, canBeKicked, canBeBanned, canBeMuted, canCreateDynamicRoomNumber, canMute )
select webmasterid, 'performer', 1,1,1,1,1,0,0,0,0,1 from chat_roles where role = 'admin'
update `chat_roles` set canPromote=1 where role="admin"
*/
public static function getAll($webmasterid)
{
$roles = array();
$rows = DB::getAll(Role::$table, "WHERE webmasterid=$webmasterid");
foreach($rows as $role) {
$roles[$role->role] = $role;
}
return $roles;
}
public static function get($id, $webmasterid)
{
return DB::get($id, Role::$table, "and webmasterid=$webmasterid order by id");
}
public static function update($id, $values, $webmasterid)
{
return DB::update(Role::$table, $id, "and webmasterid=$webmasterid", $values);
}
public static function insert($values, $debug = false)
{
$id = DB::insert(Role::$table, $values, $debug);
return DB::getOneById($id);
}
public static function delete($id, $webmasterid)
{
return DB::delete(Role::$table, $id, "and webmasterid=$webmasterid)");
}
}