SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));

^ W razie jakby mob proto pluło się o size ^

W razie pkg: PRE-INSTALL script failed przy instalacji mysql:
/usr/sbin/pwd_mkdb -p /etc/master.passwd

ALTER TABLE nazwa AUTO_INCREMENT=500;
UPDATE item_proto SET name=vnum;
UPDATE mob_proto SET name=vnum;
ALTER TABLE item_proto ORDER BY vnum;
ALTER TABLE mob_proto ORDER BY vnum;

ee /etc/fstab
linproc /compat/linux/proc linprocfs rw 0 0

ee /etc/rc.conf
linux_enable="YES"

mkdir -p /usr/compat/linux/proc 
ln -s /usr/compat /compat
mount linproc

cd /usr/ports/emulators/linux_base-f10 && make install clean

cd /usr/ports/sysutils/lsof && make install clean

cd /usr/ports/sysutils/htop && make reinstall clean

UPDATE item_proto SET specular = '30' WHERE locale_name LIKE '%+4' ;
UPDATE item_proto SET specular = '40' WHERE locale_name LIKE '%+5' ;
UPDATE item_proto SET specular = '50' WHERE locale_name LIKE '%+6' ;
UPDATE item_proto SET specular = '65' WHERE locale_name LIKE '%+7' ;
UPDATE item_proto SET specular = '80' WHERE locale_name LIKE '%+8' ;
UPDATE item_proto SET specular = '100' WHERE locale_name LIKE '%+9' ;

Bład: pw: user 'mysql' disappeared during update
/usr/sbin/pwd_mkdb -p /etc/master.passwd


Reset zapomnianego hasla do mysql
    # service mysql-server stop
    # mysqld_safe --skip-grant-tables &
    # mysql -u root
    mysql> use mysql;
    mysql> UPDATE user SET password=PASSWORD('yourpassword') WHERE user='root';
    mysql> FLUSH PRIVILEGES;
    mysql> quit
    # service mysql-server restart



gmake: *** Brak reguł do zrobienia obiektu `../../../Extern/include/boost/exception', wymaganego przez `OBJDIR/BattleArena.o'. Stop.


cd /
fetch http://php.therub.org/pub/freebsd/base-gcc-4.2.1-20140624.txz
tar xvf base-gcc-4.2.1-20140624.txz
rm base-gcc-4.2.1-20140624.txz

mysql -u root -p
SET PASSWORD = PASSWORD('twoje_haslo');

echo "mysql_enable='YES'" >> /etc/rc.conf

service mysql-server start

/usr/local/bin/mysqladmin -u root password twoje_haslo

mysql -p


CREATE USER 'root'@'%' IDENTIFIED BY 'twoje_haslo' ;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION ;
CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#' ;
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' WITH GRANT OPTION ;
flush privileges;
quit
service mysql-server restart



################### JAK DODAC NOWY EFFECT (JESTEM DEBILEM I ZAPOMINAM A NIE CHCE MI SIE PRZEZ SOURCE...)
###    chrmgr.EFFECT_REFINED+x - y - z
###    x - kolejny mumer
###    y - POZIOM PRZEDMIOTU (ost cyfra z id)
###    z - 6 (ZAWSZE! bo tak)
###    chrmgr.EFFECT_REFINED+40 - 9 - 6 = 25
###    25 = SocketPCT(item_proto i tam je wpisujemy)



## Sprawdzanie zbednych kolumn w refine_proto
SELECT rp.id
FROM refine_proto rp
LEFT JOIN item_proto ip ON rp.id = ip.refine_set
WHERE ip.refine_set IS NULL;

## Usuwanie zbednych kolumn w refine_proto
DELETE FROM refine_proto
WHERE id NOT IN (
  SELECT refine_set
  FROM item_proto
);