ROZWIĄZANY: Zmiana grupy uzytkownika po upływie okreslonego czasu.

[marrom]

Witam.

Czy kojarzy ktoś modyfikację przenoszącą użytkowników z jednej grupy do innej po określonym czasie. Dokładnie jak opcja Group Promotion ale sprawdzająca czas upływający od rejestracji (np. po miesiącu od rejestracji dany użytkownik wskakuje na nową grupę).

Chodzi o IPB 2.3.6

Edytowane 1 Września 2010 przez marrom

[DawPi]

Uh, w wersji 3.x widzę, że to wbudowana opcja jest, no, ale to nie Twoja wersja.

Do wersji 2.x nie widzę nic, ale znalazłem tutorial na dysku - wklejam go tylko dlatego, że ten użytkownik już daawno przestał się udzielać w życiu IP.Board. Jeśli kiedykolwiek się zgłosi z prośbą o usunięcie jego pracy, to usunę ten wpis.

/*

+-------------------------------------------------------

| Promote Member For A Certain Time Limit 1.0.0

| ======================================================

| by Dzung Nguyen (ntd1712)

| © 2006 Vietnamese - Invision Resources

| http://www.invisionviet.net/

| ======================================================

| Date Started: Tue, 22 Aug 2006 23:45 (GMT+7)

| Last Updated: Mon, 18 Dec 2006 12:45 (GMT+7)

| License Info: http://www.invisionviet.net/license.php

+-------------------------------------------------------

*/

Compatibility: IPB v2.2.x

Description :

- Promote member temporarily, then auto demote.

File to edit:

./sources/action_admin/groups.php

./sources/classes/class_session.php

./sources/classes/post/class_post.php

---------------------------------------------------------------------------------------------

First, run the queries below in ACP - SQL Toolbox (step-by-step):

ALTER TABLE `ibf_groups` MODIFY `g_promotion` varchar(22) default '-1&-1&-1';

ALTER TABLE `ibf_members` ADD `pgroup` varchar(15) default '-1&-1';

---------------------------------------------------------------------------------------------

Open: ./sources/action_admin/groups.php

Find: [ function do_delete() ]

//-----------------------------------------

// Look for promotions in case we have members to be promoted to this group...

//-----------------------------------------

$this->ipsclass->DB->simple_construct( array( 'select' => 'g_id', 'from' => 'groups', 'where' => "g_promotion LIKE '{$this->ipsclass->input['id']}&%'" ) );

$prq = $this->ipsclass->DB->simple_exec();

while ( $row = $this->ipsclass->DB->fetch_row($prq) )

{

$this->ipsclass->DB->do_update( 'groups', array( 'g_promotion' => '-1&-1' ), 'g_id='.$row['g_id'] );

}

Replace with:

//-----------------------------------------

// Look for promotions in case we have members to be promoted to this group...

//-----------------------------------------

$this->ipsclass->DB->simple_construct( array( 'select' => 'g_id', 'from' => 'groups', 'where' => "g_promotion LIKE '{$this->ipsclass->input['id']}&%'" ) );

$prq = $this->ipsclass->DB->simple_exec();

while ( $row = $this->ipsclass->DB->fetch_row($prq) )

{

$this->ipsclass->DB->do_update( 'groups', array( 'g_promotion' => '-1&-1&-1' ), 'g_id='.$row['g_id'] );

}

===============================================

Find: [ function save_group($type='edit') ]

$promotion_a = '-1'; //id

$promotion_b = '-1'; // posts

if (isset($this->ipsclass->input['g_promotion_id']) AND $this->ipsclass->input['g_promotion_id'] > 0)

{

$promotion_a = $this->ipsclass->input['g_promotion_id'];

$promotion_b = $this->ipsclass->input['g_promotion_posts'];

}

Replace with:

$promotion_a = '-1'; //id

$promotion_b = '-1'; // posts

$promotion_c = '-1'; // hours

if (isset($this->ipsclass->input['g_promotion_id']) && $this->ipsclass->input['g_promotion_id'] > 0)

{

$promotion_a = $this->ipsclass->input['g_promotion_id'];

$promotion_b = $this->ipsclass->input['g_promotion_posts'];

if ($this->ipsclass->input['g_promotion_time'] > 0)

{

$promotion_c = $this->ipsclass->input['g_promotion_time'];

}

}

===============================================

Find: [ function save_group($type='edit') ]

'g_promotion' => $promotion_a.'&'.$promotion_b,

Replace with:

'g_promotion' => $promotion_a.'&'.$promotion_b.'&'.$promotion_c,

===============================================

Find: [ function save_group($type='edit') ]

$this->ipsclass->DB->do_update( 'groups', $db_string, 'g_id='.$this->ipsclass->input['id'] );

Add below:

$pgroup = ($promotion_c > 0) ? (time() + $promotion_c * 3600) : '-1&-1';

$this->ipsclass->DB->do_update( 'members', array( 'pgroup' => $pgroup ), 'mgroup='.$this->ipsclass->input['id'] );

===============================================

Find: [ function group_form($type='edit') ]

//-----------------------------------------

// sort out the promotion stuff

//-----------------------------------------

list($group['g_promotion_id'], $group['g_promotion_posts']) = explode( '&', $group['g_promotion'] );

if ($group['g_promotion_posts'] < 1)

{

$group['g_promotion_posts'] = '';

}

Replace with:

//-----------------------------------------

// sort out the promotion stuff

//-----------------------------------------

list($group['g_promotion_id'], $group['g_promotion_posts'], $group['g_promotion_time']) = explode( '&', $group['g_promotion'] );

if ($group['g_promotion_posts'] < 1)

{

$group['g_promotion_posts'] = '';

}

if ($group['g_promotion_time'] < 1)

{

$group['g_promotion_time'] = '';

}

===========================================

Find: [ function group_form($type='edit') ]

$this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "<b>Choose 'Don't Promote' to disable promotions</b>$guest_legend<br>".$this->ipsclass->adskin->js_help_link('mg_promote') ,

'Promote members of this group to: '.$this->ipsclass->adskin->form_dropdown("g_promotion_id", $all_groups, $group['g_promotion_id'] )

.'<br>when they reach '.$this->ipsclass->adskin->form_simple_input('g_promotion_posts', $group['g_promotion_posts'] ).' posts'

) );

Replace with:

$this->ipsclass->html .= $this->ipsclass->adskin->add_td_row( array( "<b>Choose 'Don\'t Promote' to disable promotions</b>$guest_legend<br />".$this->ipsclass->adskin->js_help_link('mg_promote') ,

'Promote members of this group to: '.$this->ipsclass->adskin->form_dropdown("g_promotion_id", $all_groups, $group['g_promotion_id'] )

.'<br />when they reach '.$this->ipsclass->adskin->form_simple_input('g_promotion_posts', $group['g_promotion_posts'] ).' posts'

.' for '.$this->ipsclass->adskin->form_simple_input('g_promotion_time', $group['g_promotion_time'] ).' hours'

) );

---------------------------------------------------------------------------------------------

Open: ./sources/classes/class_session.php

Find: [ function authorise() ]

//-----------------------------------------

// Check ban status

//-----------------------------------------

Add above:

//-----------------------------------------

// Are we checking for auto demotion?

//-----------------------------------------

if ($this->member['pgroup'] != '-1&-1')

{

list($gid, $gtime) = explode( '&', $this->member['pgroup'] );

if ($gid > 0 && $gtime > 0)

{

if (time() >= $gtime && $this->member['mgroup'] != $gid)

{

# Update this member's profile

$this->ipsclass->DB->simple_construct(array('update' => 'members',

'set' => 'mgroup='.$gid,

'where' => 'id='.$this->member['id']

) );

$this->ipsclass->DB->simple_shutdown_exec();

if (USE_MODULES == 1)

{

require_once ROOT_PATH."modules/ipb_member_sync.php";

$modules = new ipb_member_sync;

$modules->ipsclass = &$this->ipsclass;

$modules->register_class($this);

$modules->on_group_change($this->member['id'], $gid);

}

}

}

}

===========================================

Find: [ function load_member($member_id=0) ]

mgroup_others, temp_ban, sub_end,

Add after:

pgroup,

---------------------------------------------------------------------------------------------

Open: ./sources/classes/post/class_post.php

Find: [ function pf_increment_user_post_count() ]

// Are we checking for auto promotion?

if ($this->ipsclass->member['g_promotion'] != '-1&-1')

{

list($gid, $gposts) = explode( '&', $this->ipsclass->member['g_promotion'] );

if ( $gid > 0 and $gposts > 0 )

{

if ( $this->ipsclass->member['posts'] + 1 >= $gposts )

{

$mgroup = "mgroup='$gid', ";

if ( USE_MODULES == 1 )

{

$this->modules->register_class($this);

$this->modules->on_group_change($this->ipsclass->member['id'], $gid);

}

}

}

}

Replace with:

// Are we checking for auto promotion?

if ($this->ipsclass->member['g_promotion'] != '-1&-1' || $this->ipsclass->member['g_promotion'] != '-1&-1&-1')

{

list($gid, $gposts, $gtime) = explode( '&', $this->ipsclass->member['g_promotion'] );

if ( $gid > 0 and $gposts > 0 and ( $gtime < 0 or $gtime > time() ) )

{

if ( $this->ipsclass->member['posts'] + 1 >= $gposts )

{

$mgroup = "mgroup='$gid', ";

if ( USE_MODULES == 1 )

{

$this->modules->register_class($this);

$this->modules->on_group_change($this->ipsclass->member['id'], $gid);

}

}

}

}

---------------------------------------------------------------------------------------------

That's all!

©2006 ntd1712

[marrom]

Dzięki za starania. Niestety ten tutek poszerza tylko promocję do innej grupy po przez dodanie czasu w jakim ma być napisane te X postów.

Ja potrzebuję co by promocja była np. po 30 dniach nie zależnie od ilości wysłanych postów. W sumie to myślę że taska musiał bym zrobić odpowiedniego. Jak uda mi się znaleźć wolnego czasu trochę to może uda mi się samemu rozwiązać problem.

Mimo wszystko dzięki

[DawPi]

Daj znać, jak poszło! Koniecznie!

[marrom]

W sumie wyszło kilka minut roboty...

Część odpowiedzialna w tasku za aktualizację bazy u mnie wygląda następująco:

//-------------------------------------------------------
// Dane początkowe - dostosować do własnych potrzeb
//-------------------------------------------------------

$day_to_move=30;              //Liczba dni po których nastąpi przesunięcie do innej grupy
$from_group=27;              //ID grupy z której ma być przesunięcie
$to_group=3;                 //ID grupy do której ma nastąpić przesunięcie po x dniach od rejestracji


//-------------------------------------------------------
// Zapytanie aktualizujące grupę
//-------------------------------------------------------

$time_to_move=mktime()-($day_to_move*24*60*60);


$this->ipsclass->DB->build_query( array('update' => 'members', 'set' => 'mgroup='.$to_group, 'where' => 'joined <='.$time_to_move.' AND mgroup='.$from_group ) );   

$this->ipsclass->DB->exec_query();

W załączeniu kod całego taska. Wystarczy tylko zmienić dane początkowe, rozszerzenie na php, wrzucić do katalogu sources/tasks ,a następnie zarejestrować taska w ACP/TOOLS & SETTINGS/Task Manager.

Profesjonalistą nie jestem więc jak da się inaczej/lepiej proszę o sugestie i poprawki.

group_promotion.txt

[DawPi]

Jest OK.

[DawPi]

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.