Jump to content

Ayaka

Bronze
  • Posts

    288
  • Joined

  • Last visited

  • Days Won

    10
  • Feedback

    0%

Everything posted by Ayaka

  1. 1º: ---- I know this problem well. Obviously read. The only problem is that not even that is the table because I've never seen, if someone has a .sql file or querys please share it. 2º: ---- This is what I literally do not know. 1: You have the query already Use one of the already existng columns in your database - copy and paste, but dont forget to rename it to applytype0 ([Hidden Content]) the structure should be the same 2: I googled for it and found one but is it the right one? i dont know ... just test it and add it in common database: CREATE TABLE `priv_settings` ( `priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' , `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' , `type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' , `value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' , `duration` datetime NOT NULL DEFAULT 0 , PRIMARY KEY (`priv_type`, `id`, `type`) ); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); source: epvpersucks lol, why? @Ayaka INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); because you have to fill it with: 1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4) like the comment in column "type" says? lol -> 4 types -> 4 inserts with the value for each type .... is it that hard to understand? oh, AND because your pissed that im not answering your pms :'D [Hidden Content]
  2. 1º: ---- I know this problem well. Obviously read. The only problem is that not even that is the table because I've never seen, if someone has a .sql file or querys please share it. 2º: ---- This is what I literally do not know. 1: You have the query already Use one of the already existng columns in your database - copy and paste, but dont forget to rename it to applytype0 ([Hidden Content]) the structure should be the same 2: I googled for it and found one but is it the right one? i dont know ... just test it and add it in common database: CREATE TABLE `priv_settings` ( `priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' , `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' , `type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' , `value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' , `duration` datetime NOT NULL DEFAULT 0 , PRIMARY KEY (`priv_type`, `id`, `type`) ); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); source: epvpersucks
  3. At first you guys should learn how to set up your database and tables befor starting an "Epic pServer". -> Table 'common.priv_settings' doesn't exist -> Unknown column 'applytype0' in 'field list' what is more to say? All you have to do is reading and adding.
  4. use search function: [Hidden Content] there are so much threads about inventory bug (example: [Hidden Content])
  5. Problem is this sql insert. INSERT INTO account.account (login,password,real_name,email,social_id,question1,answer1,create_time,status,coins,autoloot_expire,safebox_expire,web_aktiviert) VALUES ('".$_POST['account']."',PASSWORD('".$userpass."'),'".mysql_real_escape_string($_POST['uname'])."','".mysql_real_escape_string($_POST['email'])."','".$lcode."','".$sfNum."','".$hashSF."','".$sqlZeit."','".$accountStatus."','".$regCoins."','".$expireDate."','".$expireDate."','".$aktivHash."') Check in your database table "account" if these colums all exist: login,password,real_name,email,social_id,question1,answer1,create_time,status,coins,autoloot_expire,safebox_expire,web_aktiviert if they exist you have to debug $sqlQry: after <?php at the top of your file: ini_set('display_errors',1); error_reporting(E_ALL); then replace: $sqlQry = mysql_query($sqlCmd,$sqlServ); with: $sqlQry = mysql_query($sqlCmd,$sqlServ) or die(mysql_error()); and try to register an account again. Post the mysql error here.
  6. my glass sphere said: "show us your register.php"
  7. Is this really metin2dev?? I have the sense that im reading epvper threads. The level has decreased significantly.
  8. if you dont even know how to configurate your config to connect to mysql you shouldn't set up a website by yourself...
  9. nice to hear Maybe i will pull some code when i have time. love this project.
  10. is mysql running? Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cannot open direct sql connection to host: localhost user: ezio db: common cannot start server while no common sql connected check top in console
  11. lol you can just add a column in player's table for the pet level and another one for experience and load them from database to game and use it stupid.. better to use the given getter and setter than extending a database table.
  12. your CA root certificate is out of date. Updating your operating system also updates your CA
  13. [Hidden Content] ??? next time create only one topic
  14. 2,147,483,647 is the max int value. Change type int to bigint in your tablestructure. edit: This is a database solution. Dont know about the impacts in game (I do not know the source) edit2: look at this: [Hidden Content]
  15. Reviews with informations like "superfluous tools" in each software? All to know is what identification methods are used and detection rates on several malicious software in comprehensive tests. Pull the other leg if you want to show me reviews like google matches with "best anti-virus software". I dont want to discuss about the best Anti-Virus software because the is no best. If you really want to know read some stuff from Frederick B. Cohen and you will understand.
  16. And where did you get this superior knowledge? there is no algorithm that can perfectly detect all possible viruses so there cant be a "best" anti-virus system. Not even kaspersky can handle all pests. It based all on up-to-date Software to be "safe" and the use of good identification methods to identify malware. Kaspersky as well as other Software (Bitdefender and many others) are well-suited for the job.
  17. dont have the time to look in this at the moment but is this slider hardcoded in index.tpl??? I thought there will be a pluginsystem for such features? My perception was that you can upload a zip in ACP -> Addons with a file structure like this (example): - /images (pictues for addon) - /js (.js data for addon) - /css (.css for addon) - /tpl (template data for addon) - /data (models, controler.. etc) - settings.yaml (settings for implementation) edit:// or maybe plugins via composer.
  18. .... i think your script "Can't connect to local MySQL server" Maybe look in file "/home/tdlgamin/public_html/Template3/inc/configurare.php" on line 6 Check the mysql data there ..... .. maybe this... is the problem edit:// If you cant solve it you will not find a topic with exact the same problem. I searched for you and we have ONLY 6077 results with "Can't connect to local MySQL server" on metin2dev. damn it ...
  19. just run URL/tools.php and click "import lang", then you have the default translations also shown on the website Also we all were busy the last few days, but we will do some more things as soon as we have some time for it Ah, didnt look into that file (odd workflow without instructions). Cant wait to see that cms stable. I think the important part for you is to create a good plugin system for this cms. I think it should have good chances to become established.
  20. Would be cool if you finish the installer at first to insert a selected language to database. At the moment it looks like this: btw. found an epic line in index.tpl xD <!--<iframe width="1px" height="1px" src="[Hidden Content]" frameborder="0" allowfullscreen></iframe>-->
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.