HristDead Posted August 20, 2013 Group: Members Topic Count: 66 Topics Per Day: 0.02 Content Count: 167 Reputation: 2 Joined: 08/01/12 Last Seen: October 9, 2019 Share Posted August 20, 2013 Hi rAthena, I tried searching for a script like this but couldnt find. What im requesting is when a new player signs in he gets 2 cash point., but only one time per account... to avoid they making 10 characters to get cash points. does someone have a script like that? thanks. Quote Link to comment Share on other sites More sharing options...
whitesn Posted August 20, 2013 Group: Members Topic Count: 13 Topics Per Day: 0.00 Content Count: 193 Reputation: 14 Joined: 12/02/11 Last Seen: October 30, 2018 Share Posted August 20, 2013 http://pastebin.com/0mj475ws Haven't tested it yet Quote Link to comment Share on other sites More sharing options...
HristDead Posted August 20, 2013 Group: Members Topic Count: 66 Topics Per Day: 0.02 Content Count: 167 Reputation: 2 Joined: 08/01/12 Last Seen: October 9, 2019 Author Share Posted August 20, 2013 is that not character-based? Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted August 20, 2013 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted August 20, 2013 Here's my method - script abcde -1,{ OnPCLoginEvent: if( BaseExp>0 || BaseLevel>1) end; if(!query_sql("SELECT account_id FROM `global_reg_value` WHERE str='#CASHPOINTS' AND account_id = "+getcharid(3),.@aid)) set #CASHPOINTS,#CASHPOINTS+2; set BaseExp,BaseExp+1; end; } Quote Link to comment Share on other sites More sharing options...
HristDead Posted August 20, 2013 Group: Members Topic Count: 66 Topics Per Day: 0.02 Content Count: 167 Reputation: 2 Joined: 08/01/12 Last Seen: October 9, 2019 Author Share Posted August 20, 2013 nice i'll try that thanks! Quote Link to comment Share on other sites More sharing options...
Capuche Posted August 20, 2013 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 613 Joined: 07/05/12 Last Seen: Monday at 01:55 PM Share Posted August 20, 2013 @QQfoolsorellina if the player spends all his cashpoint then log out and make a new character, he still get the cashpoints. Maybe with logincount.. - script swdghfgj -1,{ OnPCLoginEvent: if( BaseExp>0 || BaseLevel>1) end; query_sql "SELECT `logincount` FROM `login` WHERE `account_id` = '"+ getcharid(3) +"'", .@logincount; if( .@logincount > 1 ) end; ... Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted August 20, 2013 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted August 20, 2013 @QQfoolsorellina if the player spends all his cashpoint then log out and make a new character, he still get the cashpoints. Maybe with logincount.. - script swdghfgj -1,{ OnPCLoginEvent: if( BaseExp>0 || BaseLevel>1) end; query_sql "SELECT `logincount` FROM `login` WHERE `account_id` = '"+ getcharid(3) +"'", .@logincount; if( .@logincount > 1 ) end; ... nope, my sql query is to check #CASHPOINTS data exist or not , it's not to check the value of #CASHPOINTS Quote Link to comment Share on other sites More sharing options...
Capuche Posted August 20, 2013 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 613 Joined: 07/05/12 Last Seen: Monday at 01:55 PM Share Posted August 20, 2013 Yes but the lines with empty or 0 values in `value` are deleted from global_reg_value if the player spends all his cashpoint then log out then the data is deleted Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted August 20, 2013 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted August 20, 2013 Yes but the lines with empty or 0 values in `value` are deleted from global_reg_value if the player spends all his cashpoint then log out then the data is deleted It's not true ,Emulator never delete account var records Even though empty value and logout 1 Quote Link to comment Share on other sites More sharing options...
Capuche Posted August 22, 2013 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 613 Joined: 07/05/12 Last Seen: Monday at 01:55 PM Share Posted August 22, 2013 From my test: I set a new integer variable and log out A new line appear in global_reg_value I set this variable to 0 and log out I can't find the line in global_reg_value anymore don't know if it's related to the emu... maybe it's my phpmyadmin..? Quote Link to comment Share on other sites More sharing options...
Question
HristDead
Hi rAthena,
I tried searching for a script like this but couldnt find.
What im requesting is when a new player signs in he gets 2 cash point., but only one time per account... to avoid they making 10 characters to get cash points.
does someone have a script like that? thanks.
Link to comment
Share on other sites
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.