News:

Wondering if this will always be free?  See why free is better.

Main Menu

[WIP - Converter] Kunena 3.0

Started by margarett, September 02, 2014, 08:47:19 PM

Previous topic - Next topic

snoob

Cant log in. I'm only using xampp, maybe that's the reason why im not receiving any email :) Can you tell me how to log in as an admin? thanks I'll back read, i'm still wondering about the attachment. But looks like everything is fine.

margarett

What's your J! version?

Anyway, check this wiki article:
http://wiki.simplemachines.org/smf/I_accidentally_lost_my_admin_account!_What_can_I_do
The last topic explains how to easily restore your password ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob


snoob

I don't understand to run a query thing but looks like i can do this. Is't right?


Creating a single-purpose script

    Create a php file called createadmin.php
    Copy and paste in it the code below according to your SMF version
    Replace in the code adminusername with the login name you want to set as admin.
    Using FTP upload it to your forum directory -- the same directory that has SSI.php in it.
    Run the script, accessing it from your browser by URL as
    http://www.yourwebsite.tld/forum/createadmin.php.
    Afterwards, make sure to delete the file from your forum's directory.

SMF 1.1
Code: [Select]

<?php

// Pick a username to be the new admin user -- use the login name, not the display name
$yourusername='adminusername';

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

// You shouldn't need to change anything past this point in the script.
//Here we include SSI for globals used within the sql statement
include_once('SSI.php');
global $db_prefix;

//  Now run the query.
$querystring='UPDATE ' . $db_prefix . 'members
SET ID_GROUP = \'1\' WHERE memberName = \'' . $yourusername . '\'';
$adminsquirt = db_query($querystring, __FILE__,  __LINE__);

echo $yourusername . ' should now be an admin';
?>

SMF 2.0
Code: [Select]

<?php

// Pick a username to be the new admin user -- use the login name, not the display name
$yourusername='adminusername';

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

// You shouldn't need to change anything past this point in the script.
//Here we include SSI for globals used within the sql statement
include_once('SSI.php');

//  Now run the query to elevate the user to administrator
$querystring='UPDATE {db_prefix}members
SET id_group = \'1\' WHERE member_name = \'' . $yourusername . '\'';
$adminElevate = $smcFunc['db_query']('', $querystring, array());

//Make sure that the account is activated!
$querystringb='UPDATE {db_prefix}members SET is_activated = 1 WHERE member_name = \'' . $yourusername . '\'';
$adminActivate = $smcFunc['db_query']('', $querystringb, array());

echo $yourusername . ' should now be an admin';
?>


margarett

Yeah, as the first post says, passwords are supported with J! under 3.0. With new J! versions it is not...

You don't need to run any query or script ;) It is the *last* topic of that page.
Just go to phpmyadmin, smf database, table smf_members. Find your admin user, write your password in the "passwd" field and clear the field "password_salt". Now, when you try to login in SMF, it will hash your password as usual. Your members will need to recover the password via email, yes ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

#125
`password_salt`SELECT * FROM `cit_members`

I should clear the `password_salt` or this whole `password_salt`SELECT * FROM `cit_members` ? Sorry if too slow to pick up :)


wait... looks like i saw it now. :)

Sorry, you are out of login chances. Please come back and try again later.

Should i really wait? :)

there's nothing on on the "password_salt" field

margarett

No. You should do that ONLY for your own member.

You don't need to run any query, phpmyadmin will do it for you ;)
When you open your "members" table all the fields for each member will be shown. Just find your member in that list, then scroll to the right, delete what is on the "passwd" field and write your password, press enter, scroll to the right again, delete what is on the "password_salt" field, press enter.
Done :)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

#127
I'm ok now with the admin account. I think the only last problem now is the attached photos. thanks

Why almost all of the attached pictures are just blank like this? thanks...


[attachment=336]IMG_0130.JPG[/attachment]

[attachment=337]IMG_0131.JPG[/attachment]

[attachment=338]IMG_0136.JPG[/attachment]


I changed the theme then the pictures that didnt show up, can be seen now. What are other things that should i check?

margarett

SMF doesn't really support inline attachments... You can install this MOD by dougiefresh
http://custom.simplemachines.org/mods/index.php?mod=3770
But I'm not sure if the syntax of the BBC is the same :(
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

I'm sorry if this question is so basic.  This is about from the previous post that i saw about  the oversized avatar. Where can i found the load.css that i need to put this ?      
Quote'image' => $profile['avatar'] == '' ? ($profile['id_attach'] > 0 ? '<img class="avatar" style="max-width:100px; max-height:100px" src="' . (empty($profile['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $profile['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $profile['filename']) . '" alt="" />' : '') : (stristr($profile['avatar'], 'http://') ? '<img class="avatar" src="' . $profile['avatar'] . '"' . $avatar_width . $avatar_height . ' alt="" />' : '<img class="avatar" src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($profile['avatar']) . '" alt="" />'),


If ever i install that mod then those attachment will show up? I'm wondering why when i changed the theme then the other attachement shows up.

margarett

No idea. Which theme is it?

There is no load.css. There is a Load.php in folder Sources. It's exactly like in that post that you've seen: Edit the file with a good editor (eg: Notepad++), find the first line, replace that with the second line ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

#131
It's a success! I can't believe it! :) Please remind me if i forgot something else. :0  Thank you Margarette... Who's next now!? :)


Looks like some topics are gone. I have a locked topic where i put all the banned posts but looks like its gone now. Im still checking for other posts that some of replies are gone too. Im not really sure about it but i think  its ok than staying on kunena :D  Some of the members become moderator but its manageable

margarett

Thank you for your feedback. I glanced over the converter again, no idea how members got to moderators.
About the missing topics/posts: make sure you run the maintenance tasks in SMF after conversion (check for errors, recount totals).

PS: it's "margarett", no "e" in the end :P :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

May i know what can i do with those posts and pics that are gone now when i converted?  Some of the members gonna be mad because they spent their time posting it.

margarett

I still have no idea why these posts are missing. The converter doesn't exclude anything that might cause that, methinks.
Do you still have access to your original database?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

Cool! So there's still chance. I thought its normal to the converter. Maybe i'll try to reinstall it. What should i need to do with the original?  I switch back to kunena so members are posting again so i might use the updated original database. Please give me the things i should do and avoid so the convertion will become smooth. thanks

margarett

You can try the conversion again (it will delete the current content in SMF of course), then we can compare both topics and find the missing content ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

thank you.

Another question. I noticed that the folder/link of the old kunena forum can still be accessed. Is't safe to show them the link? Will there be no problem if they can access it? I want to show it to them too. Is't ok? Or should i upload it to another folder or link? Any suggestions?

margarett

Well no... After you are happy with the conversion (and only at that time) you should remove your old forum ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

snoob

I will remove it but i want to give them a month so they could also see if there are problems. I didnt get what you mean of no. Ist safe?

Advertisement: