where are the stored procedures in those "create table"scripts?
ah.. and where are the table relations?
sorry pal, but this release is a big failure but thanks for trying
this will like never work ^^
[Release] 2010 Logs databases 08/30/2014 - Metin2 PServer Guides & Strategies - 30 Replies Well after 3 weeks server online in my 2010 server just request that tables for the logs
Have fun
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `bootlog`
-- ----------------------------
DROP TABLE IF EXISTS `bootlog`;
[Release]Rakion Server Files + Databases 02/18/2011 - General Gaming Discussion - 20 Replies Server download: Rakion::Server
Database download: Databases::Good
Maybe Correct Client Download: Client
[RELEASE] Query Sammlung 10/17/2010 - Metin2 PServer Guides & Strategies - 14 Replies Hoi,
Dachte mal ich Sammle mal alle Querys die ich schreibe auch sowas wie Items anhand der Log Tabelle wiederherstellen allerdings natürlich erst wenn ich sie schreibe xD Erstmal das einfache Zeug
Log mit Spielernamen auslesen:
SELECT log.*,player.name FROM log.log LEFT JOIN player.player ON player.id = log.who
von GM erstellte Items finden
SELECT log.*,player.name FROM log.log LEFT JOIN player ON player.player = log.who WHERE what ="GM"
[Release]Rakion Server Files + Databases 07/20/2008 - Private Server Advertising - 3 Replies Server download: Rakion::Server
Database download: Databases::Good
Maybe Correct Client Download: Client