Jyoti Rani

https://www.marketingcheckpoint.com/admin/ - in the admin section only font files are getting pointed to beta.marketingcheckpoint.com . All the other files are working fine Please suggest some solution.

Can you please share the file location where i should add this link?

URL issue has been resolved after clearing Cache. Can any one please suggest solution for the Missing icons? You can view on the live site also. I have shared the link too

I have created some sub menu with custom code, But they are still pointing to old URL. for e.g. https://beta.marketingcheckpoint.com/mail/send/ this should be moved to https://www.marketingcheckpoint.com/mail/send/. Can you please suggest from where can I change this?

Hi Randy, I have done the same process. But i am not able to see the icons on the site. https://www.marketingcheckpoint.com/ Please have a look.

I have upgraded site on subdomain, Now i want to move those files on root of the site. and there will be change in the URL of the site. Will this work or i have to perform the upgrade again? Please guide

It has been resolved Dawpi. Thanks for the reply!

Yes.

Hello Marc, After the successful upgrade on the below URL. I am redirected to main url of the site rather than the url on which i have performed the upgrade. Can you please suggest something? For .e.g When i click on Go to the Suite - I m redirected to https://www.marketingcheckpoint.com/ this url rather than https://beta.marketingcheckpoint.com/ and When i click on "Go to the AdminCP" i am redirected to https://www.marketingcheckpoint.com/admin this url rather than https://beta.marketingcheckpoint.com/admin .

Hi all, In the process of upgrade I am getting below error. Can any one please suggest something or should I continue anyway?

php class: \IPS\forums\Topic\Post - Its fine. Should i add my functionality in below protected function processAfterCreate($comment, $values) function or any other function/Method should be used?

I want to create a plugin. So, i just want to know Which IPS class and event is fired, when i add reply to new topic in forum?

One more query is, when some one replied to this Topic, which event is fired internally.

Its working on the betaversion of the site also. Thanks a Ton!

Hello terabyte, A very big thanks to your help and prompt reply. I was able to do the changes as per your suggestions. Here is my final code and its working when user is adding Topic at my local machine. protected function processAfterCreate($comment, $values) { # Remove prefix $previousPrefix = \IPS\Db::i()->prefix; \IPS\Db::i()->prefix = ''; $user_group_id = \IPS\Member::loggedIn()->member_group_id; if ($user_group_id == 3 || $user_group_id == 4 || $user_group_id == 7 || $user_group_id == 😎 //bronze // || $user_group_id == 4) { # no need to check for double points $assign_point = 1; } if ($assign_point == 1) { $reward_mailing_points = 250; } $result = \IPS\Db::i()->select('*', 'plug_mailing_master', array('user_id=?', \IPS\Member::loggedIn()->member_id)); foreach ($result as $row) { $credit_balance = $reward_mailing_points + intval($row['credit_balance']); } # Update database with new $cc value \IPS\Db::i()->update('plug_mailing_master', array('credit_balance' => $credit_balance), array('user_id=?', \IPS\Member::loggedIn()->member_id)); # Reset prefix \IPS\Db::i()->prefix = $previousPrefix; return parent::processAfterCreate($comment, $values); }

point 2 in the try block i m using below statement also $result = \IPS\Db::i()->query("UPDATE xxx SET credit_balance = " . $credit_balance . " WHERE user_id = '" . $user_id . "'"); point 1 User id i m getting using below code if (\IPS\Member::loggedIn()->member_id) { // // Get the current user's member object $currentUser = \IPS\Member::loggedIn(); // // Access user data # Fetch member details $user_id = $currentUser->member_id; $username = $currentUser->name; $email = $currentUser->email; $user_group_id = $currentUser->member_group_id; } else { $user_id = 0; } point 3 - my table name does not start with tbl_prefix. that is why i have to use mix IPS and non-IPS 4. Is the table you're trying to update in the same database as Invision Community? - YES. If it's in an external database, you're using the wrong code to connect to it. Using simply \IPS\Db::i() will try to load the table from the forum's database, not your external one. - My table is in the same db not the external db.

public function processAfterCreate($comment, $values) { $result = \IPS\Db::i()->query("SELECT * FROM xxxx WHERE user_id = " . $user_id); // SET field_a='value' WHERE id_field=1"); if ($result->num_rows > 0) { while ($row = mysqli_fetch_assoc($result)) { // $row is now an associative array containing column names as keys $cc = $reward_mailing_points + intval($row['cc']); } } return parent::processAfterCreate($comment, $values); } public function save() { $result = \IPS\Db::i()->query("SELECT * FROM xxxx WHERE user_id = " . $user_id); // SET field_a='value' WHERE id_field=1"); if ($result->num_rows > 0) { while ($row = mysqli_fetch_assoc($result)) { // $row is now an associative array containing column names as keys $cc = $reward_mailing_points + intval($row['cc']); } } return parent::save(); }

Can you please tell me which event is called when New topic is created. in the processForm function - It is called during both time while editing and creating. But i need only when its created. I used save() , processAfterCreate(), createFromForm() and some mor but they are not being called while creating new topic.

Yes. Thanks again for your prompt reply!

But i m not getting this dropdown in my screen. Please see below

Now another query is, there is xml file which gets generated in the end. But how to create it? How to upload it to sever from developer's mode at local?

Found the solution as you mentioned at the same place Adriano. Thanks for the reply!

By default its taking ip in the table name. Earlier in the version 3.6 we have used the table name without the tbl_prefix. So, Can you help me how to use the how to fetch the data directly from the table without using tbl_prefix?

Actually i got this while working at my local machine. As per the comments on the forum, I restarted my system and i am getting below issue. Can you please suggest something? My all the efforts for the hook and local setup gets wasted.

Hello Marc, Did you able to find the solution for this issue?