Цитата (ENDorFiN @ 2011-02-21, 14:39)

но крякозябры не только в админке, но и на странице магазина. Можно ли изменить кодировку базы данных?
Убейте таблицы что создали и измените на те что ниже.
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE el_order (
id int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
email varchar(30) NOT NULL,
telefon int(15) NOT NULL,
idpro varchar(50) NOT NULL,
product varchar(255) NOT NULL,
cena int(20) NOT NULL,
kol int(10) NOT NULL,
`date` datetime NOT NULL,
`status` tinyint(1) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE el_shop (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
url varchar(100) NOT NULL,
main_cat int(11) unsigned NOT NULL,
cats varchar(100) NOT NULL,
author varchar(25) NOT NULL,
author_id int(11) unsigned NOT NULL,
groups varchar(30) NOT NULL,
show_sokr tinyint(1) unsigned NOT NULL,
`date` datetime NOT NULL,
shop text NOT NULL,
price float NOT NULL,
total int(11) unsigned NOT NULL,
votes int(11) unsigned NOT NULL,
`status` tinyint(1) NOT NULL,
comments int(11) unsigned NOT NULL,
allow_comm tinyint(1) unsigned DEFAULT '1',
s_descr varchar(250) NOT NULL,
s_title varchar(100) NOT NULL,
pinned tinyint(1) unsigned NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY url (url),
KEY main_cat (main_cat),
KEY cats (cats),
KEY `status` (`status`,groups,pinned,`date`),
KEY `date` (`status`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE el_shop_categories (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
url varchar(100) NOT NULL,
image varchar(100) NOT NULL,
parent int(11) unsigned NOT NULL,
l int(11) NOT NULL,
r int(11) NOT NULL,
s_descr varchar(250) NOT NULL,
pos int(11) unsigned NOT NULL,
PRIMARY KEY (id),
KEY l (l)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE el_shop_categories_l (
id int(11) unsigned NOT NULL,
`language` varchar(15) NOT NULL DEFAULT '',
title varchar(50) NOT NULL,
description text,
PRIMARY KEY (id,`language`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE el_shop_l (
id int(11) unsigned NOT NULL,
`language` varchar(15) NOT NULL DEFAULT '',
title varchar(100) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (id,`language`),
FULLTEXT KEY title (title,`text`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;