Technoken

Thank you! Somehow union is what im looking for. lol

I'm having problems how to query it. I need to select all the data from multiple tables which are editlog, deletelog, loginlog, and logoutlog. now after selecting all the data, I need to merge all the results from those tables and sort them based from their time column. All of those tables have the same 'time' column. but the thing is the deletelog and editlog has 4 columns, while loginlog and logoutlog only has 2 columns. Is it still possible?

I'm about to create a page with recent activities and I couldn't make it work. I'm just starting to code php so please pardon me I'm trying to test it with this code but the results are not sorted by the time $sql = "SELECT * FROM `editlog`, `deletelog`, `loginlog`, `logoutlog` ORDER BY COALESCE(editlog.time , deletelog.time, loginlog.time, logoutlog.time) ASC"; $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo $row[0].'<br />'; echo $row[1].'<br />'; echo $row[2].'<br />'; echo $row[3].'<br />'; } What i'm trying to do is select all data from tables editlog, deletelog, loginlog, and logoutlog then merge the results. Then sort them based from the datetime in ascending order. then after collecting the information(already sorted) it will be displayed like this e.g datetime ------------------ emp id ----------- activity 2016-07-10 10:54:01 --- 100 --------------- logged in 2016-07-10 10:55:05 ----102 --------------- deleted record no 23 2016-07-10 10:57:00---- 103 --------------- logged in 2016-07-10 10:58:00---- 103 --------------- logged out 2016-07-10 10:58:30---- 103 --------------- edit record no 24 Here's a sample of the database For anybody who can help. Thank you so much!

Maybe you can do it like this? prontera,180,140,4 script Cash Shop 73,{ switch( select("Shop 1:Shop 2:Shop 3")){ case 1: callshop "shop1",1; break; case 2: callshop "shop2",1; break; case 3: callshop "shop3",1; break; } end; } - pointshop shop1 -1,#CASHPOINTS,678:5,607:5,608:1 - pointshop shop2 -1,#CASHPOINTS,678:5,607:5,608:1 - pointshop shop3 -1,#CASHPOINTS,678:5,607:5,608:1

You just have to add that as an npc and it will already function like what you've wanted.

What do you mean by the x.y?

- script mvp_cashpt -1,{ OnNPCKillEvent: if ( getmonsterinfo( killedrid, MOB_MVPEXP ) ) #CASHPOINTS += 1; end; }

What is the file location of your item_db.txt?

oh yeah lol sorry just change it to this switch ( select ( "Most Kills","Highest Streak","Longest Ownage","Own Information","Explanation",((getgmlevel()==99)?"Reset Ladder":"") ) ) {

Try add this on the script OnDay0101: OnDay0201: OnDay0301: OnDay0401: OnDay0501: OnDay0601: OnDay0701: OnDay0801: OnDay0901: OnDay1001: OnDay1101: OnDay1201: truncate table `pvpladder`; truncate table `ownladder`; end; but for me it's better to reset it manually. change switch ( select ( "Most Kills","Highest Streak","Longest Ownage","Own Information","Explanation" ) ) { to switch ( select ( "Most Kills","Highest Streak","Longest Ownage","Own Information","Explanation","Reset Ladder" ) ) { then add case 6: case 6: truncate table `pvpladder`; truncate table `ownladder`; mes "DONE!"; close;

Try change setarray .@Position[1], 1, 9, 10; to setarray .@Position[1], 6, 5, 4; change setarray .@Position[1], 13, 12, 11; to setarray .@Position[1], 10, 11, 12;

I think they need to wait atleast a minute(if i'm not mistaken) for the database to autosave new items transferred to the cart. // Database autosave time // All characters are saved on this time in seconds (example: // autosave of 60 secs with 60 characters online -> one char is saved every // second) autosave_time: 300 // Min database save intervals (in ms) // Prevent saving characters faster than at this rate (prevents char-server // save-load getting too high as character-count increases) minsave_time: 100 // Apart from the autosave_time, players will also get saved when involved // in the following (add as needed): // 1: after every successful trade // 2: after opening vending/every vending transaction // 4: after closing storage/guild storage. // 8: After hatching/returning to egg a pet. // 16: After successfully sending a mail with attachment // 32: After successfully submitting an item for auction // 64: After successfully get/delete/complete a quest // 128: After every bank transaction (deposit/withdraw) // NOTE: These settings decrease the chance of dupes/lost items when there's a // server crash at the expense of increasing the map/char server lag. If your // server rarely crashes, but experiences interserver lag, you may want to set // these off. save_settings: 255

It's related to what i've posted here LINK They told me it wasn't because of rAthena fies, rather it's because of the database. Try to access your log db while the client is frozen and see if will show an error on mapserver. As of now I still can't fix this issue. Are you also using XAMPP?

I thought duping items using rpe or wpe has been gone for years. Yeah. Please tell us how do they do it so we can also test it ourselves to our server.

LOL

It is now global_acc_reg_num and global_acc_reg_str. #Cashpoints might be located at acc_reg_num Changed after Script Engine Upgrade update

Yeah. Seems weird. I can still experience it. I posted the error here. LINK Still i don't know what could be the fix.

Up for this

Idk if I should post it here or in the rathena github issues. Somehow it is related to this issue. Im using Git Hash: bea47eac42e89217c194f3a08391796d6945ab90 Mode: Pre-renewal Client: 2013-12-23 No src modification Running my test server on windows 7 w/ xampp v.3.2.2 My client still freezes whenever I spawn a monster(I spawned a poring) and hit it. No errors shown. While frozen, I access my database(localhost/phpmyadmin) and go to log db. After clicking the log db, this error appear on my mapserver. [SQL]: DB error - Table '.\log\picklog' is marked as crashed and should be repai red [Debug]: at ..\src\map\log.c:228 - INSERT DELAYED INTO `picklog` (`time`, `char_ id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, ` map`, `unique_id`, `bound`) VALUES (NOW(), '1002', 'M', '909', '-1', '0', '0', ' 0', '0', '0', 'prontera', '0', '0') When the error appeared, the client is back to normal. This always happen whenever I restart my xammp. So what do you think? Is it because of the xammp? or rA files? Thank you! EDIT: Sorry, I thought I posted this on database support. Please just move this topic to where it belong. Thank you!

try { atcommand "@blvl 1"; atcommand "@jlvl 1"; },{},{}

Are you using the latest git hash of rathena? did you try to backslide while not using Brynhild item? Maybe you are on a gvg map. Im using the latest git revision and it's working fine with me.

Did you already install mysql?

If your mysql database is on the same host with the trunk, you can leave it 127.0.0.1.

10 milliseconds delay before triggering the next script below.

I remember that's what I heard from Bayantel ISP before when i'm asking them to unblock ports. But when I went at their office and told them that I have to host a webserver, they asked me an additional fee of 700php monthly. Then they set my ip from dhcp to static and I can already host my server online. What I did in port forwarding is just the basics. Just use the port forward feature of the router. assign a static lan ip, forward ports(both tcp and udp) 80,3306,5121,6121, 6900. Then restart my router. After that my friends can already connect online.