-
Memory for login and game server
Hello, any advices how to properly set memory for .sh login and game files? I have dedicated server with 32GB ram memory. java -XX:+UseConcMarkSweepGC -Xmx30G -cp ./libs/*; net.sf.l2j.gameserver.GameServer java -Xmx1g -cp ./libs/*; net.sf.l2j.loginserver.LoginServer
-
Looking donation panel for website
Hello, i am looking for a donation panel. Interested in such like used in this server. https://euro-pvp.com/index.php?id=l2&do=payment Pm me with offers, thanks.
-
l2jAcis seven signs mobs spawnlist
Thanks a lot :)
-
l2jAcis seven signs mobs spawnlist
Hi, do anyone has seven signs mobs spawnlist for Acis? Those mobs that drop seal stones are not adapted :( I have tried to use search, but havent find anything.
-
Only active/passive augments
Yes, that helped. Looks like its working great. I don't want to create new topic, so i will ask here. Is it some kind of bug or this is made by a reason, that when you are buying soulshots or some kind of comsumable you can manually enter the amount that you wish to buy. If item is enchant scroll, weapon or an armor, that is not possible, you can buy only 1. There is some code in source that does not let to do that?
-
Only active/passive augments
Can someone help with this idea? I want to dissable all chance skills, only active and passive augment skills. Pack that i am working with is ACIS. If i delete the chance skills from augmentation/skills.xml it gets an error on augment process. Looks like it cant find correct id or something like so. Maybe i should change chance skill with active, i mean do not delete it.
-
.repair Character Voice Command
nice
-
HTML FONT
-
Error during php select
Hi. I am getting this kind of an error. Maybe someone knows what i am doing wrong? Notice: Trying to get property 'total_posts' of non-object in C:\xampp\htdocs\pages\forum\forum.php on line 42 Here is the code: $update = 'SELECT forum_id FROM forum'; $update = $db -> prepare($update); $update->execute(); while($row = $update -> fetch(PDO::FETCH_OBJ)){ $post = 'SELECT post_thread, post_datestamp, post_user, (SELECT COUNT(post_entry) FROM forum_post WHERE post_forum='.$row->forum_id.') AS total_posts FROM forum_post WHERE post_forum='.$row->forum_id.' AND post_datestamp =(SELECT MAX(post_datestamp) FROM forum_post WHERE post_forum='.$row->forum_id.')'; $post = $db -> prepare($post); $post->execute(); $p_row = $post -> fetch(PDO::FETCH_OBJ); $num_of_p = $p_row->total_posts; if($num_of_p==null){ $last_post_date = null; $last_post_thread = null; $post_user = null; } else{ $last_post_date = $p_row->post_datestamp; $last_post_thread = $p_row->post_thread; $post_user = $p_row->post_user; } $post=null; $threads = 'SELECT count(thread_name) as total_threads FROM forum_thread WHERE thread_forum_id='.$row->forum_id.''; $threads = $db -> prepare($threads); $threads->execute(); $t_row = $threads -> fetch(PDO::FETCH_OBJ); $num_of_t = $t_row->total_threads; $threads=null; $up_forum = 'UPDATE forum SET forum_threads=?, forum_replies=?, forum_lastpost_user =?, forum_lastpost_date =?, forum_lastpost_thread =? WHERE forum_id ='.$row->forum_id.''; $up_forum = $db->prepare($up_forum); $up_forum->execute([$num_of_t, $num_of_p, $post_user, $last_post_date, $last_post_thread]); $up_forum=null; } $update=null;
-
TOP RITCHEST STATS PROBLEM
Hi. I dont want to create a new topic, so im writing in this one, with the same problem. Im adapting forum into a website and I have a problem with latest date row. I want to add latest post, and i thought i could search for it in database table by MAX command. Is it proper way to whrite sql statement like i am doing?I get that kind of an error: Uncaught PDOException: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s) Here is my code: $topic = 'SELECT f.*, u.selected_character, (SELECT COUNT(post_entry) number FROM forum_post WHERE post_thread = f.thread_id), (SELECT post_user, post_datestamp FROM forum_post WHERE post_thread = f.thread_id AND post_datestamp=(SELECT MAX(post_datestamp) FROM forum_post)) FROM forum_thread f LEFT JOIN accounts u on f.thread_author = u.id WHERE f.thread_id = :topicid ORDER BY f.thread_lastpost_date'; $topic = $db -> prepare($topic); $topic -> bindValue(':topicid', $topic_id, PDO::PARAM_INT); $topic ->execute(); while($row = $topic -> fetch(PDO::FETCH_OBJ)) { echo" <tr> <td style='width:5%; text-align:center' class='forumheader2'><img src='../images/forum/nonew.png' alt='' title='' style='border:0' /></td> <td style='width:55%' class='forumheader2'><a href='index.php?pages=forum/view_topic&id=".$row->thread_id."'>".$row->thread_name."</a><br />by <a href='forum_viewforum6512.html?11'>".$row->selected_character."</a> » ".ucwords(strftime('%a %b %d %Y, %I:%M%p ', $row->thread_author_date))."</td> <td style='width:10%; text-align:center' class='forumheader3'>".$row->number."</td> <td style='width:10%; text-align:center' class='forumheader3'>".$row->thread_views."</td> <td style='width:20%; text-align:center' class='forumheader3'> <span class='smallblacktext'>".$row->post_datestamp."<br />".$row->post_user." <a href='forum_viewtopic4232.html?64400.last'><img src='../images/forum/post2.png' alt='' title='' style='border:0; vertical-align:bottom' /></a></span> </td> </tr> "; }
-
L2Newday (dawnstar) website template request
Lock the topic please :)
-
L2Newday (dawnstar) website template request
Thanks, thats cool :)
-
L2Newday (dawnstar) website template request
- Lineage 2 Website
-
Website vote system
Yup, i don't understand how code works. How it knows that player has voted and disapears from list? It saves ip address and 24h countdown? Maybe someone has a simulare code?