Welcome, Guest |
You have to register before you can post on our site.
|
|
|
I want to take the current database to a new MyBB |
Posted by: iGoGo - 2010-09-02, 06:11 AM - Forum: 1.6 General Support
- Replies (1)
|
|
I got so many errors at my MyBB Forum.
So I would like to take a database backup.
But I only want to restore the most important database tables.
Like threads, posts, users, and so on.
Can anyone tell me what database tables that I need then.
I would upload it to a fresh uploaded MyBB forum.
I hope that anyone can help.
- Thanks
|
|
|
sql error showing .. |
Posted by: jameel225 - 2010-09-02, 06:05 AM - Forum: 1.6 General Support
- Replies (2)
|
|
hello dear when i m going to login my id its show this error ..
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'remember' in 'field list'
Query:
SELECT uid,username,password,salt,loginkey,remember,passwordconvert,passwordconverttype FROM mybb_users WHERE username='-=jameel225=-' LIMIT 1
Please contact the MyBB Group for support.
|
|
|
Loops |
Posted by: Tyler E. - 2010-09-02, 03:22 AM - Forum: 1.6 General Support
- Replies (13)
|
|
This is the code I'm currently using to try and loop to show the prefixes and the usergroups that can use them.
The result is: http://www.jammingames.tk/forum/prefix.php
I'm trying to show the correct usergroup for the prefixes.
Also, the forum id's stretch out as far as needed on the page, I need a way to keep them within the page so you don't have to scroll.
And I can't quite get it, so I was wondering if someone could help me, thanks.
$prefix = $db->query("SELECT * from ".TABLE_PREFIX."prefix");
while ($query = $db->fetch_array($prefix)) {
$title = $query['title'];
$fid = $query['fid'];
$gid = $query['gid'];
$format = str_replace($title, "<font color='#4BB1FF'>$title</font>", $title);
$groups2 = $db->query("SELECT * FROM ".TABLE_PREFIX."usergroups WHERE gid = '$gid'");
while ($groups_result2 = $db->fetch_array($groups2)) {
$usergroup2 = $groups_result2['namestyle'];
$usergroup3 = str_replace("{username}", $groups_result2['title'], $usergroup2);
}
$prefix_output = "The available prefixes are as followed (Title - Usergroups - Forum ID): <br />
$format - $usergroup3 - $fid";
}
|
|
|
|