Jump to content

admirolas3

Members
  • Posts

    67
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

About admirolas3

Profile Information

  • Current Mood
    Angry
  • Gender
    Not Telling
  • Country
    Lithuania

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

admirolas3's Achievements

Newbie

Newbie (1/16)

  • Dedicated Rare
  • Conversation Starter Rare
  • Week One Done Rare
  • One Month Later Rare
  • One Year In Rare

Recent Badges

1

Reputation

  1. 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
  2. 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.
  3. 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.
  4. 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?
  5. 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.
  6. Hi. Maybe someone knows the name of this font? I can't find it.. ;/
  7. 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;
  8. 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> "; }
  9. Hello, maybe someone has this template? Maybe someone has riped it when this server was alive?
  10. 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?
×
×
  • Create New...