phpBB.de

phpMyAdmin MySQL-Dump

# Note: if your table prefix is not `phpbb_` then change it before

DROP TABLE IF EXISTS phpbb_smilies_cat;

#
# Table structure for table `phpbb_smilies_cat`
#

CREATE TABLE phpbb_smilies_cat (
cat_id int(3) NOT NULL default '0',
cat_name varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default 'N/A',
KEY cat_id (cat_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Insert a Default category at table `phpbb_smilies_cat`
#

INSERT INTO `phpbb_smilies_cat` ( `cat_id` , `cat_name` , `description` )
VALUES ( '1', 'Default', 'About Default category' );

# --------------------------------------------------------

#
# Create a new field at table `phpbb_smilies`
#

ALTER TABLE `phpbb_smilies` ADD `cat_id` INT( 3 ) DEFAULT '1' NOT NULL ;

#
#-----[ FIND ]------------------------------------------------
#

$lang['Configuration'] = 'Configuration';

#
#-----[ BEFORE, ADD ]-----------------------------------------
#

$lang['Smiley_categories'] = "Smiley categories";

#
#-----[ FIND ]------------------------------------------------
#

//
// That's all Folks!
//

#
#-----[ BEFORE, ADD ]-----------------------------------------
#

// Categorized Smilies MOD

$lang['smiley_cat'] = "Category";
$lang['smiley_cat_options'] = "Options";
$lang['smiley_cat_title'] = "Category Options";
$lang['smiley_cat_first'] = "First";
$lang['smiley_cat_description'] = "Smiley categories management. If you want to add a smilie to one category, do it from the control panel of smilies.
The first smiley in a category will be the representative smiley of that category. The order of these categories will be the order in the message form.
If there are no smilies in a category, that category won't appear in the message form.";
$lang['smiley_category_description'] = "Category description";
$lang['smiley_cat_empty'] = "There are no smilies in this category.";
$lang['smiley_cat_add'] = "Add category";
$lang['smiley_cat_edit'] = "Edit category";
$lang['smiley_cat_edit_description'] = "You can modify category information here.";
$lang['smiley_cat_add_description'] = "You can add a new smilies category from this form";
$lang['smiley_cat_add_unselected'] = "ERROR: you didn't fill all fields.<br><br><a href=\"javascript:history.back()\">Back</a>";
$lang['smiley_cat_add_success'] = "Category added successfully";
$lang['smiley_cat_edit_success'] = "Category edited successfully";
$lang['smiley_cat_del_ok'] = "Category deleted successfully";
$lang['smiley_cat_first_ok'] = "The category is now at the first place";
$lang['smiley_cat_del_bad'] = "You can't delete this category. There is at least one smiley in this category. Change the category of all smilies which belong to this category before deleting it.<br><br><a href=\"javascript:history.back()\">Back</a>";

Markus67 hat geschrieben:Hi ...

Du hast in den neueren Versionen von phpMyadmin auch oberhalb der Tabellen auf der linken Seite einen kleinen Button SQL ... den klickst du einfach an und in das Eingabefenster kannst du entweder jeden Querie einzeln oder aber auch alle auf einmal ausführen.

Markus