Guest User

Untitled

a guest
Jun 19th, 2014
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1. public ReadUser(id)
  2. {
  3. new q[256], mres[64], buffer[600], field[71][45];
  4. mysql_real_escape_string(GetPname(id), mres);
  5. format(q, 256, "SELECT * FROM user WHERE name = '%s'", mres);
  6. mysql_query(q);
  7. mysql_store_result();
  8. mysql_fetch_row(buffer, "|");
  9. split(buffer, field, '|');
  10.  
  11. PI[id][level] = strval(field[1]);
  12. PI[id][pass] = field[2];
  13. PI[id][gender] = strval(field[3]);
  14. PI[id][age] = strval(field[4]);
  15. PI[id][money] = strval(field[5]);
  16. PI[id][bank] = strval(field[6]);
  17. PI[id][warnings] = strval(field[7]);
  18. PI[id][kicks] = strval(field[8]);
  19. PI[id][admin] = strval(field[9]);
  20. PI[id][banres] = field[10];
  21. PI[id][skin] = strval(field[11]);
  22. PI[id][banned] = strval(field[12]);
  23. PI[id][konto] = strval(field[13]);
  24. PI[id][perso] = strval(field[14]);
  25. format(PI[id][regdate], 20, "%s", field[15]);
  26. PI[id][carlic] = strval(field[16]);
  27. PI[id][flens] = strval(field[17]);
  28. PI[id][house] = strval(field[18]);
  29. //LASTLOGIN strval(field[19]);
  30. PI[id][gunlic] = strval(field[20]);
  31. PI[id][job] = strval(field[23]);
  32. PI[id][packs] = strval(field[25]);
  33. PI[id][jobpoints] = strval(field[26]);
  34. PI[id][joblvl] = strval(field[27]);
  35. PI[id][drugs] = strval(field[28]);
  36. PI[id][bizz] = strval(field[29]);
  37. PI[id][kanister] = strval(field[30]);
  38. PI[id][handy] = strval(field[31]);
  39. PI[id][pb] = strval(field[32]); //tutorial check
  40. PI[id][clock] = strval(field[33]);
  41. PI[id][dice] = strval(field[34]);
  42. PI[id][fraktion] = strval(field[35]);
  43. PI[id][rank] = strval(field[36]);
  44. PI[id][jail] = strval(field[37]);
  45. format(PI[id][crime], 34, "%s", field[38]);
  46. PI[id][playtime] = strval(field[39]);
  47. PI[id][respect] = strval(field[40]);
  48. sscanf(field[41], "%.2f", PI[id][oldx]);
  49. sscanf(field[42], "%.2f", PI[id][oldy]);
  50. sscanf(field[43], "%.2f", PI[id][oldz]);
  51. PI[id][oldint] = strval(field[44]);
  52. PI[id][oldvi] = strval(field[45]);
  53. PI[id][spawn] = strval(field[46]);
  54. //PI[id][lastinvi] = strval(field[47]);
  55. sscanf(field[48], "%f", PI[id][armour]);
  56. PI[id][banto] = strval(field[49]);
  57. PI[id][prepaid] = strval(field[50]);
  58. PI[id][medi] = strval(field[51]);
  59. //PI[id][onl] = strval(field[52]);
  60. PI[id][s_pb][0] = strval(field[54]);
  61. PI[id][s_pb][1] = strval(field[55]);
  62. PI[id][s_jail] = strval(field[56]);
  63. PI[id][donator] = strval(field[57]);
  64. PI[id][ajail] = strval(field[58]);
  65. PI[id][weps] = strval(field[59]);
  66. PI[id][akills] = strval(field[60]);
  67. PI[id][adeaths] = strval(field[61]);
  68. PI[id][muesli] = strval(field[62]);
  69. PI[id][kampf] = strval(field[63]);
  70. PI[id][radio] = strval(field[64]);
  71. PI[id][helm] = strval(field[65]);
  72. PI[id][backpack] = strval(field[66]);
  73. PI[id][bp_packs] = strval(field[67]);
  74. PI[id][bp_drugs] = strval(field[68]);
  75. PI[id][bp_mats] = strval(field[69]);
  76. PI[id][kaution] = strval(field[70]);
  77.  
  78. PI[id][car1] = strval(field[21]);
  79. PI[id][car2] = strval(field[22]);
  80. PI[id][car3] = strval(field[24]);
  81. PI[id][car4] = strval(field[53]);
  82.  
  83. mysql_free_result();
  84.  
  85. if(strlen(field[38]) > 1)
  86. {
  87. SetPlayerWantedLevel(id, strval(field[38][0]));
  88. xnrSetCrimeDelay(id);
  89. }
  90.  
  91.  
  92. if(PI[id][fraktion] == 6)
  93. PI[id][handyst] = 0;
  94.  
  95. PI[id][mute] = 0;
  96.  
  97.  
  98. if(PI[id][donator] != 0 && !PI[id][car4])
  99. PI[id][car4] = -1;
  100.  
  101. format(q, 256, "SELECT n FROM newsteam WHERE n = '%s'", GetPname(id));
  102. mysql_query(q);
  103. mysql_store_result();
  104. if(mysql_num_rows() > 0)
  105. PI[id][news] = 1;
  106. mysql_free_result();
Advertisement
Add Comment
Please, Sign In to add comment