Jump to content

Vy Low

Members
  • Content Count

    178
  • Joined

  • Days Won

    1

Posts posted by Vy Low


  1.  

    Hi,

     

    I've been trying to connect my server to a SQL database located on a different host.

     

    I.e.

    My server is located on Host 1 (11.11.11.11).

    My SQL files are located on Host 2 (22.22.22.22).

     

    I thought I had set everything up properly, but I receive the following error when trying to start the server:

     

    (while starting server on host 1)

    [SQL]: Access denied for user 'remote_user'@'11.11.11.11' (using password: YES)
    
    I want to connect to 'remote_user'@'22.22.22.22'

     

    Before delving further into this, is it even possible to host SQL files elsewhere while having your server files on a different host?

     

    Thanks.

    Hello,

     

    you just need to add privilege to 11.11.11.11 to your database in 22.22.22.22 so that it will grant access to your db


  2.  

    
    

     

    prontera,150,150,4    script    rentitem#123    100,{//prontera,150,150,4<tab>script<tab>rentitem#123<tab>100mes "Rent cost: " + .rentitemamt + "x " +getitemname(.rentitemid)+ " for one day";    next;    mes "What do you want to rent?";switch ( select ( .menu$ )  ) { // items to rent menu    case 1: callsub OnDeclareDays; // call OnDeclareDays to input days.            callsub OnRentItems,2410,.days; // 2410 is sleipnir's Item ID. only change the item ID.    case 2:    callsub OnDeclareDays; // call OnDeclareDays to input days.            callsub OnRentItems,2629,.days; // 2629 is Megs's Item ID. only change the item ID.    // to add more items add more cases example    // case 3: callsub OnDeclareDays;    //            callsub OnRentItems,2220,.days; // rent hat    // and add its name on .menu$ part at the bottom.    // pretty simple huh. }OnDeclareDays:        mes "How many days do you want to rent it?";        input .days; // input days        if (.days == 0 ) { // 0 is not a valid value.            mes "0 is not a valid value.";            close;        }        return .days;OnRentItems:        if ( countitem ( .rentitemid ) < getarg(1) * .rentitemamt ) { // not enough items            mes " ","Not Enough items","You need "+getarg(1) * .rentitemamt+"x "+getitemname(.rentitemid);            close;        }        delitem .rentitemid, getarg(1) * .rentitemamt; // delete items        rentitem getarg(0), getarg(1) * 86400; // rent an items. 86400 = 1 day in seconds        close;OnInit:    set .rentitemid, 7227; // item id of TCG change to your likings.    set .rentitemamt, 10; // item amount of TCG change to your likings.    set .menu$,"Sleip:Megs"; // to add an item separate the item with ":" without the quotes eg: "Sleip:Megs:HAT"}

    try?

     

    @edit

    added some comments.

    sir how make this script like a shop?.. but still selling a rental item with a choice of how many days to be rented..

    you create a rental box and sell it in shop for tcg.


  3. Honestly even if you have a big community, your traffic wont reach even in 5tb a month :) based on my experience when i had around 2k players in my server before

     

    cdn are only good for streaming site and not in hosting a site and game server..


  4.  

     

     

    regarding port forwarding, you will only do this if you want to open the server to public. But since you will only use it as a test server.. No need for that :)

    So after downloading DUC from no-ip.com, i'll just changethe ip on my clientinfo.xml and the corresponding areas in the server side?

    actually you wont be needing that anymore since you wont be opening it as public. 127.0.0.1 will work just fine

    Well, I want some of my friends login to the server as well. D:

    so best way is to use noip and open the ports of map login and char server


  5.  

    regarding port forwarding, you will only do this if you want to open the server to public. But since you will only use it as a test server.. No need for that :)

    So after downloading DUC from no-ip.com, i'll just changethe ip on my clientinfo.xml and the corresponding areas in the server side?

    actually you wont be needing that anymore since you wont be opening it as public. 127.0.0.1 will work just fine

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.