Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 13:57

  • Please register to post and access all features, it's quick, easy and FREE!

 

How to send items to all accounts.Rohan

Reply
 
Old   #16
 
elite*gold: 0
Join Date: Jan 2014
Posts: 184
Received Thanks: 30
1. select your users from RohanUser.TUser
2. Send to the user's item mall inventory - lets user apply the item to any of his chars.
3. to automate add a where clause to apply restrictions

It helps to understand the Rohan database and table relationships.
It also helps to understand SQL to avoid inefficient code like unnecessary loops.



PenguinJoe is offline  
Old   #17
 
elite*gold: 0
Join Date: Mar 2013
Posts: 30
Received Thanks: 5
Quote:
Originally Posted by PenguinJoe View Post
1. select your users from RohanUser.TUser
2. Send to the user's item mall inventory - lets user apply the item to any of his chars.
3. to automate add a where clause to apply restrictions

It helps to understand the Rohan database and table relationships.
It also helps to understand SQL to avoid inefficient code like unnecessary loops.
I've tried it, but I did not succeed in making the script


dedeernet is offline  
Old   #18
 
elite*gold: 0
Join Date: Feb 2011
Posts: 333
Received Thanks: 109
Well, it's simple.
Add
Code:
WHERE name = 'character name' -- for adding items to a specific character

WHERE user_id = 456789 -- for adding items to all characters a specific user has
to the end of the query

Further reading



Adding Rows by Using INSERT and SELECT
zzerachiel is offline  
Old   #19
 
elite*gold: 0
Join Date: Mar 2013
Posts: 30
Received Thanks: 5
Smile

Quote:
Originally Posted by zzerachiel View Post
Well, it's simple.
Add
Code:
WHERE name = 'character name' -- for adding items to a specific character

WHERE user_id = 456789 -- for adding items to all characters a specific user has
to the end of the query

Further reading



Adding Rows by Using INSERT and SELECT
I'll try it, I hope will be successful


dedeernet is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
any one can send me English Vm Ware rohan
any one can send me English Vm Ware rohan up!
0 Replies - Rohan
anyone please send me a link for xor rohan bot
hi there i need a link for bot in xor rohan, please if anyone know about bots that properly works for windows xp kindly just post a link here or you...
6 Replies - Rohan
Selling Xor Rohan accounts, characters, money and items
Right now I have A LOT of Xor Rohan accounts. So if you are interesting having a Pro account or simply buy crones or even items you can pm me. ...
17 Replies - Rohan
how to send items that can not be transferred?
how to send items that can not be transferred.For example how to pass for level 50 pet to another account
3 Replies - Shaiya



All times are GMT +2. The time now is 13:57.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.