Jump to content
  • 0

erotisi: pos na diagrafounte ta char..


L2KingWorld

Question

geia stous mxc

pedes i erotisi einai> otan mpeni enas new char apo kapio kero vgeni leave ap to server.

pos na kano na min ton psaxno sto navicat ke na ton (delete) apoki ?

ke na diagrafete aftommata..

Link to comment
Share on other sites

12 answers to this question

Recommended Posts

  • 0

Απ' ότι κατάλαβα θες να διαγράψεις accounts/char που έχουν να μπουν στον server πολύ καιρό.

 

DELETE FROM characters WHERE lastAccess < 466560000; 
DELETE FROM accounts WHERE lastactive < 466560000;

 

Αυτό το sql διαγράφει accounts/chars που έχουν να μπουν 3ς μήνες στον server.

Link to comment
Share on other sites

  • 0

nai an mporis pio analitika.

na ftiakso ena sql characters_set me tis xaraktires pou mou dixnis ?

i na simpliroso sto navicat (characters) (accounts) ?

Link to comment
Share on other sites

  • 0

lipon pare afta ta dio

DELETE FROM characters WHERE lastAccess < 466560000;

DELETE FROM accounts WHERE lastactive < 466560000;

kai balto mesa se ena sql.file meta apla kanis execute kai afto einai an o alos exi na mpi 3 mines tha ton kani delete apla kai grigora

Link to comment
Share on other sites

  • 0

to poio aplo einai na pas stin database tou server sou sto navicat kai ekei pou exei last active px 1 xrono kaneis delete k eisai comple... Sugkekrimena sto account table ths navicat ;)

Link to comment
Share on other sites

  • 0

lipon edo sou exo to kalitero http://www.convertworld.com/el/time/%CE%9B%CE%B5%CF%80%CF%84%CE%AC.html site file bazis tous mines kai sou bgenoun kai ta defterolepta kitato an exis kapia aporia pos to kanis kane post edo an kai einai efkolo xerome pou boithisa

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


  • Posts

    • For upcoming changes, You should consider making those 3 tabs (or whatever more You will have with new games) more visible and standing out, because right it looks like all topics hidden under those 3 tabs.
    • While not particularly active over the years, I've been around for as long as I could remember, so here are my 2 cents too. On top of what has already been said, I'd like to touch on a few thing that might be improved upon. While it is easy to notice and say "there's lack of engagement" or "community has outgrown the ganre", I've seen numerous forums get forgotten and die while others continue to thrive to this day. The main issue, in my humble opinion, is that the sector has been commercialised to an unsustainable extent. When nobody is willing to share anything, even if it is just a rework of an open-sourced or already-shared resource, the sense of "community" gets deminished. Now back on the pressing matter. From what I've seen, the lack of engagement could be circumvented with a redesign and functionality expansion that would/could/should include: - a built-in chat functionality. - incentives for engagement/interaction, ideas of which I'll list as separate pointers, as not to limit your creativity. But just as an example, from a more user/human perspective, having an easily identifiable way to get into "the club of the cool kids on the block", figuratively speaking, is an incentive on its own. - separation of the reputation into reactions and reputation. One to be used to posts, such as up-vote and what not, while the other to be awarded as means of appreciation. - automated ranks with actual benefits/perks, not like the current ones providing nothing. - the ability to hide text for user/group of users, not just premium/no premium. - increased visibility of the HOT topics and the RECENTLY ACTIVE threads/posts. Can be also expanded to most liked posts, etc. ps.: I'll update my post when I have some free time on my hands.
    • There was no way I didn't refunded or delivered files. I don't see You on my conrtact list on Discord, can You send me a message or at least tell me for what project was this updater? I always resolve if I can't deliver on time or customer bailes.
    • @rlfem123  I’m a web developer, and I work with technologies like Next.js and React. In the last 10 years, L2 Rankzone is the only one I’ve seen that actually did something different. All the others seem to have the same source code with different templates. L2 Hopzone also did an upgrade and, for the front end, is using Vue.js. Regarding web development, we have reached a point where you can easily create websites using libraries or frameworks. Simply pick one and start working. You will learn as you go. Personally, I prefer to build my back-end APIs in Laravel if it’s a big project since the ecosystem offers everything. For smaller projects, I choose Go. Then I use either React or Next.js to call my APIs, depending on the case. Next.js also supports Server-Side Rendering (SSR) if you want to hide some things from the client. Additionally, CSS libraries have almost everything you need nowadays to start building quickly with browser compatibility. You can seriously build an L2 website with ranks, a good design, and even a simple login/register system in just 3 days. Here are some CSS libraries I personally work with: https://tailwindui.com/components   https://ui.shadcn.com/   https://mui.com/material-ui/ Regarding the top websites i dont thing its worth the time and effort.  Its pretty simple to build one and the market is already bloated. In addition l2 is dying so i suggest to build top sites for many games.  THe main problem is not the build process rather the marketing one. You can build the most awesome website iin terms of functionality but if you marketing is week you wont exceed 10 concurrent users. 
  • Topics

×
×
  • Create New...