Jump to content

Aap

Members
  • Posts

    555
  • Joined

  • Last visited

  • Feedback

    100%

Everything posted by Aap

  1. think you mean vps? Recommended ram depens on how many bots you want to run.. try to check https://virmach.com/
  2. Aap

    Mod Weath

    18 march.... still no weekend bans edit misread 18-may^^
  3. Thats true, got it working now with just a different query for each part. but like if you want use group now its already 3 extra lines of code(not much) but extra work. so i still want to figure out how to get it in 1 query. also a question to you why you use full outer join?
  4. thats what i said before, but it give more code. and i thought that it was possible to do with 1 query
  5. both are integer, but will check futher into it.
  6. no still give no results. no matter on what way i search. with this query i can search on proxy and category. but not only proxy or category. $query = "SELECT a.id, a.rslogin, a.rswachtwoord, a.gebruikersnaam, p.proxy, c.subcategory FROM bots a INNER JOIN proxy p ON a.proxy_id=p.id INNER JOIN subcategory c ON a.category_id=c.subcat_id WHERE a.proxy_id = $proxy AND a.category_id = $sub_category "; thats why i thought adding OR for proxy and category will made it that it work also when i only search on 1 option.
  7. Hey thx for you suggestion, i know the logic showed here is not right, but was tired of trying, cant found the problem. also your almost right on what i want. want also get the results if both are selected to get all account with proxy/category. but also only proxy or category. also why FULL OUTER JOIN? but your query, isnt showing any results yes got the right one, still no results. offcourse i can make a extra query and just check what option is selected. but it will be more code, and i am sure this can and must be done in a single query
  8. your right the default calues aren't valid proxies/categories the query you suggest is not showing anything.
  9. Yes these are php variables and hold default values. if the Where clause doesn't make sense, what make sense then. with this query, its only searching on proxy, even when i select a category.
  10. Hey all, i know its the scripting section, but it looks like the best section to post this. i am currently busy with a database. want to show al bot info on a table( this is working) but now i want, to display the table based on 1 or 2 inputs. so if i search on proxy. all account with this proxy will showed. or if i search on category all accounts of this category will be showed. and last but not least is i search on a proxy and category i want to show alle account with selected proxy and category the problem is i only get 1 of the 3 worked in 1 query. so only searching on account/proxy. i guess the problem is using AND and OR wrong, but cant find the solution. so maybe anyone here can help me with it. SELECT a.id, a.rslogin, a.rswachtwoord, a.gebruikersnaam, p.proxy, c.subcategory FROM bots a INNER JOIN proxy p ON a.proxy_id=p.id INNER JOIN subcategory c ON a.category_id=c.subcat_id WHERE proxy_id = $proxy AND category_id = $sub_category OR category_id = $sub_category OR proxy_id = $proxy thank for the time jappa
  11. will it have mule support?
  12. banned on the same wave, saw it happen. they always ban around 9:15. whas to late with farming this day. whas farming some account when they got a dc shit happens gf jagex, thx for the money
  13. Aap

    he did it

    where is the dislike button
  14. Aap

    he did it

    on these moments i am proud to be dutch
  15. Aap

    Help me?

    i am done with it now, judge have spoken, i have the right of co parenting. and see my son now 3-4 days in the week. like week 1 3 days and week 2 4 days. it was a fight for 2 years. 100 times i thought why am i fighting i never gonna win this. but i am happy that i keep standing. not sure what country you life, some country's have bad laws for dads. so even if the fight keeps going on for years, be strong never give up, your son is worth is. jappa
  16. Aap

    Help me?

    got the same problem, girlfriend left me, and also took my son. dont go use drugs, or anything. try to find a good lawyer. try to have contact with her, dont show you want her still back or still miss here, only contact here about your son. never do a phone call. just email or app, so you can proof later you did everything to see and contact your son. if she just broke the relationship and dont fight for it, its not worth your time, the only thing you get is a depression because you still try to fight and she not. and no son want a father in a depression.
  17. still someone who can help, tired of this. cant bot normal
  18. Aap

    New Sig

    looks good, think ttc wil get a lot more sig request now :P
  19. Hey all, selling 5 username login accounts. non of them are very special. account have a email, will change email to yours. all of the accounts are on tutorial island. they are around 9-11 years old. pm me if you want to know the logins. can sale them one by one. dont got a price so offer greetz jappa.
×
×
  • Create New...