Solved Reset/modify Karma

Hello,

Is there a way to reset/modify the Karma for a specific user? I have a user who was "trolled" by some other forum users and now has a Karma of -39, and has asked me to reset it to 0 if possible.

Is there any way I could do that through a file in the database?

Kind regards

Database collation check: The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 8M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
234	Forum	kunenamenu	view=home&defaultmenu=236	forum	No
235	Index	kunenamenu	view=category&layout=list&catid=0	forum/index1	No
236	Recent Topics	kunenamenu	view=topics&layout=default&mode=replies	forum/recent	No
237	New Topic	kunenamenu	view=topic&layout=create&catid=	forum/newtopic	No
238	No Replies	kunenamenu	view=topics&layout=default&mode=noreplies	forum/noreplies	No
239	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
240	Profile	kunenamenu	view=user	forum/profile	No
241	Rules	kunenamenu	view=misc	forum/rules	No
242	Help	kunenamenu	view=misc	forum/help	No
243	Search	kunenamenu	view=search	forum/search	No

Joomla default template details : shape5_vertex | author: Shape5.com | version: 2.0 | creationdate: January 2012

Kunena default template details : Blue Eagle | author: Kunena Team | version: 4.0.11 | creationdate: 2016-06-05

Kunena version detailed: Kunena 4.0.11 | 2016-06-05 [ Barcelona ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	10
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	0
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	75
maxsig	200
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	0
avatarquality	85
avatarsize	75
imageheight	495
imagewidth	720
imagesize	1000
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	50
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	0
pollnboptions	12
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	0
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	75
ordering_system	mesid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	75
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	admin
file_upload	admin
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
legacy_urls	1
attachment_protection	0
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	365
teaser	0
ebay_language	0
twitter_consumer_key
twitter_consumer_secret
allow_change_subject	1
max_links	6
userlist_name	1
usernamechange	0
version_check	1
userlist_usertype	0
sefutf8	0
changename	0
enablepdf	0
jmambot	0
annmodid	43
userlist_username	1
rules_infb	1
help_infb	1
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=0
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)
ro-RO	Romanian (RO)

Third-party components: UddeIM 3.5

Third-party SEF components: None

Plugins: None

Modules: None

You can do it on the database: `#__kunena_users` there is a column karma, you can set it to 0 again.

Hello,

I managed to alter the database after installing phpMyAdmin on my VPS.

Thanks for your help!

Ticket can be closed.

now has a Karma of -39, and has asked me to reset it to 0 if possible.

Is there any other way I can make changes to this database without using cPanel (phpMyAdmin)?

You can do it without database. Login to the frontend as admin and click on the Karma plus-symbol 39 times (a admin has no click limit).