Jump to content

Recommended Posts

Posted (edited)

My friend hosted L2Off Server and asked me to do php on his website for 1) total online players, 2) account manager etc. can you help me with a guide how to do this or send me some youtube video that best describes the process. thank you! thank you! thank you! in advance!!!

 

P.S  I have the codes I don't know how to make them work along with the web page

Edited by gioshalik
Posted (edited)

Basiclly its the same thing with l2j, you collect information from a database. but L2OFF servers uses a microsoft sql server the codes is a litile bit different.

for example
 

$link=@mssql_connect($ip, $user, $pass);
@mssql_select_db($database, $link) or die(mysql_error());

TL;DR use mssql instand of mysql

Edited by Snoopi
Posted

You'd be a lot better off putting this topic in the l2off dev section, and you'll even find plenty of exactly what you're looking for already shared there.

 

Basiclly its the same thing with l2j, you collect information from a database. but L2OFF servers uses a microsoft sql server the codes is a litile bit different.

for example
 

$link=@mssql_connect($ip, $user, $pass);
@mssql_select_db($database, $link) or die(mysql_error());

TL;DR use mssql instand of mysql

god help anyone who still uses these 15+ year old functions

 

please please please please PLEASE use pdo (with dblib for linux or sqlsrv for windows)

Posted

You'd be a lot better off putting this topic in the l2off dev section, and you'll even find plenty of exactly what you're looking for already shared there.

 

god help anyone who still uses these 15+ year old functions

 

please please please please PLEASE use pdo (with dblib for linux or sqlsrv for windows)

I assumed that its gonna be easier for him to understund the basic old functions plus he wants to adapt already coded scripts and i am like 99% sure they are coded with simple mysql querys, This will do his job, now if he wants something better he should study.

Posted

You'd be a lot better off putting this topic in the l2off dev section, and you'll even find plenty of exactly what you're looking for already shared there.

 

 

thank you, i will post it in l2off dev

Guest
This topic is now closed to further replies.
  • Posts

    • Hi everyone, Since I’m no longer interested in L2 servers, if anyone is willing to continue the project, let me know. I’m currently selling the entire project. DM me for more information if you’re genuinely interested. I can offer limited free support for the first couple of months. It is not cheap. The sale includes the domain, the recently fully redesigned website, the updater, the interface, server files with Lucera ext source, and the database (excluding account passwords, emails, and other private information; character data can remain).   Server for test: https://lineage2.gold/download Server Info: https://lineage2.gold/info Over 110 videos YouTube playlist: https://www.youtube.com/watch?v=HO7BZaxUv2U&list=PLD9WZ0Nj-zstZaYeWxAxTKbX7ia2M_DUu&index=113  
    • You invent yourself a life - bad for you, one of the inner core dev, fernandopm, which worked hard over aCis quests from 2011 to 2016 is argentinian. I teached him back in time to work and make proper quests. My dev team comes from 10+ countries and I'm myself french. "Racist/nationalist" card ? Not working bro.   Not sure why I should thank you to send me questions, and regarding bug reports, so far, I got none of yours in either discord, gitlab, or forums. I'm sorry if you feel "ignored", but that's more a psychanalyst you need to speak with if you put emotions towards someones' appreciation over a forum. I never ignore a bug report, and if so (like skills reports), it's because I got a bigger plan (skills refactor, in that case). In any case, I delivered cookies for the bug report/fix, even if it dated of months, with proper credits over changesets. "Victim card" ? Not really working, but ok, maybe you're "emotional".   I barely make money out of aCis, for the spent time - simply selling my services, or even coding/administrating a minecraft/L2J server would make far more money. Breaking intentionally things would be stupid. If you don't understand I'm not the only one working on that pack, I can't help you. Also, the scale of edits is sometimes extreme - AI L2OFF ? 1800 files added. How do you want everything works in a single shot ? "Exploiting noobz for money" card ? Still not working, or I'm a terrible businessman.   Meanwhile - you shadow advertise your project, L2JOne (since 2017 btw) - you should maybe start by the beginning saying you're a competitor and aCis is actually a spike in your foot. That also explains why you act like that. RusAcis got the exact same strategy, speaking bad of me, saying they got unique fixes (you speak about I break things, they break and recode things 4 times sometimes, btw), but successfully reselling latest revision with poorly executed stuff. "aCis is good, Tryskell is ok, but I solve all issues in extreme low time so I can piss over him" card ? Mmmmhhhh.   Our conversation ends here if you want, I don't force ppl to speak with me if they don't want - hopefully, people would understand I'm not the arrogant one and the one who doesn't want to talk, or even collaborate. :). I understand you got your own project and got no will to improve aCis.   NOTE : I'm extremely happy for your call of ExShowServerPrimitive with getValidGeoLocation, extremely impressive. Arrogant, no. Sarcastic ? Maybe.   Good night everyone.
    • Hi. @GX-Ext, svn does not work. is there anywhere else where we can get source code? Thank you so much.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and 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..

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock