Advertisement
Guest User

Untitled

a guest
Jun 19th, 2014
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.46 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. printf("Called OnPlayerConnect1 for ID");
  13. PI[id][pass] = field[2];
  14. printf("Called OnPlayerConnect2 for ID");
  15. PI[id][gender] = strval(field[3]);
  16. printf("Called OnPlayerConnect3 for ID");
  17. PI[id][age] = strval(field[4]);
  18. printf("Called OnPlayerConnect4 for ID ");
  19. PI[id][money] = strval(field[5]);
  20. printf("Called OnPlayerConnect5 for ID ");
  21. PI[id][bank] = strval(field[6]);
  22. printf("Called OnPlayerConnect6 for ID ");
  23. PI[id][warnings] = strval(field[7]);
  24. printf("Called OnPlayerConnect7 for ID ");
  25. PI[id][kicks] = strval(field[8]);
  26. printf("Called OnPlayerConnect8 for ID ");
  27. PI[id][admin] = strval(field[9]);
  28. printf("Called OnPlayerConnect9 for ID ");
  29. PI[id][banres] = field[10];
  30. printf("Called OnPlayerConnect10 for ID ");
  31. PI[id][skin] = strval(field[11]);
  32. printf("Called OnPlayerConnect11 for ID ");
  33. PI[id][banned] = strval(field[12]);
  34. printf("Called OnPlayerConnect12 for ID ");
  35. PI[id][konto] = strval(field[13]);
  36. printf("Called OnPlayerConnect13 for ID ");
  37. PI[id][perso] = strval(field[14]);
  38. printf("Called OnPlayerConnect14 for ID ");
  39. format(PI[id][regdate], 20, "%s", field[15]);
  40. printf("Called OnPlayerConnect15 for ID ");
  41. PI[id][carlic] = strval(field[16]);
  42. printf("Called OnPlayerConnect16 for ID ");
  43. PI[id][flens] = strval(field[17]);
  44. printf("Called OnPlayerConnect17 for ID ");
  45. PI[id][house] = strval(field[18]);
  46. printf("Called OnPlayerConnect18 for ID ");
  47. //LASTLOGIN strval(field[19]);
  48. PI[id][gunlic] = strval(field[20]);
  49. printf("Called OnPlayerConnect19 for ID ");
  50. PI[id][job] = strval(field[23]);
  51. printf("Called OnPlayerConnect20 for ID ");
  52. PI[id][packs] = strval(field[25]);
  53. printf("Called OnPlayerConnect21 for ID ");
  54. PI[id][jobpoints] = strval(field[26]);
  55. printf("Called OnPlayerConnect22 for ID ");
  56. PI[id][joblvl] = strval(field[27]);
  57. printf("Called OnPlayerConnect23 for ID ");
  58. PI[id][drugs] = strval(field[28]);
  59. printf("Called OnPlayerConnect24 for ID ");
  60. PI[id][bizz] = strval(field[29]);
  61. printf("Called OnPlayerConnect25 for ID ");
  62. PI[id][kanister] = strval(field[30]);
  63. printf("Called OnPlayerConnect26 for ID ");
  64. PI[id][handy] = strval(field[31]);
  65. printf("Called OnPlayerConnect27 for ID ");
  66. PI[id][pb] = strval(field[32]); //tutorial check
  67. printf("Called OnPlayerConnect28 for ID ");
  68. PI[id][clock] = strval(field[33]);
  69. printf("Called OnPlayerConnect29 for ID ");
  70. PI[id][dice] = strval(field[34]);
  71. printf("Called OnPlayerConnect30 for ID ");
  72. PI[id][fraktion] = strval(field[35]);
  73. printf("Called OnPlayerConnect31 for ID ");
  74. PI[id][rank] = strval(field[36]);
  75. printf("Called OnPlayerConnect32 for ID ");
  76. PI[id][jail] = strval(field[37]);
  77. printf("Called OnPlayerConnect33 for ID ");
  78. format(PI[id][crime], 34, "%s", field[38]);
  79. printf("Called OnPlayerConnect34 for ID ");
  80. PI[id][playtime] = strval(field[39]);
  81. printf("Called OnPlayerConnect35 for ID ");
  82. PI[id][respect] = strval(field[40]);
  83. printf("Called OnPlayerConnect36 for ID ");
  84. sscanf(field[41], "%.2f", PI[id][oldx]);
  85. printf("Called OnPlayerConnect37 for ID ");
  86. sscanf(field[42], "%.2f", PI[id][oldy]);
  87. printf("Called OnPlayerConnect38 for ID ");
  88. sscanf(field[43], "%.2f", PI[id][oldz]);
  89. printf("Called OnPlayerConnect39 for ID ");
  90. PI[id][oldint] = strval(field[44]);
  91. printf("Called OnPlayerConnect40 for ID ");
  92. PI[id][oldvi] = strval(field[45]);
  93. printf("Called OnPlayerConnect41 for ID ");
  94. PI[id][spawn] = strval(field[46]);
  95. printf("Called OnPlayerConnect42 for ID");
  96. //PI[id][lastinvi] = strval(field[47]);
  97. sscanf(field[48], "%f", PI[id][armour]);
  98. printf("Called OnPlayerConnect43 for ID ");
  99. PI[id][banto] = strval(field[49]);
  100. printf("Called OnPlayerConnect44 for ID ");
  101. PI[id][prepaid] = strval(field[50]);
  102. printf("Called OnPlayerConnect45 for ID ");
  103. PI[id][medi] = strval(field[51]);
  104. printf("Called OnPlayerConnect46 for ID ");
  105. //PI[id][onl] = strval(field[52]);
  106. PI[id][s_pb][0] = strval(field[54]);
  107. printf("Called OnPlayerConnect47 for ID ");
  108. PI[id][s_pb][1] = strval(field[55]);
  109. printf("Called OnPlayerConnect48 for ID ");
  110. PI[id][s_jail] = strval(field[56]);
  111. printf("Called OnPlayerConnect49 for ID ");
  112. PI[id][donator] = strval(field[57]);
  113. printf("Called OnPlayerConnect50 for ID ");
  114. PI[id][ajail] = strval(field[58]);
  115. printf("Called OnPlayerConnect51 for ID ");
  116. PI[id][weps] = strval(field[59]);
  117. printf("Called OnPlayerConnect52 for ID ");
  118. PI[id][akills] = strval(field[60]);
  119. printf("Called OnPlayerConnect53 for ID ");
  120. PI[id][adeaths] = strval(field[61]);
  121. printf("Called OnPlayerConnect54 for ID ");
  122. PI[id][muesli] = strval(field[62]);
  123. printf("Called OnPlayerConnect55 for ID ");
  124. PI[id][kampf] = strval(field[63]);
  125. printf("Called OnPlayerConnect56 for ID ");
  126. PI[id][radio] = strval(field[64]);
  127. printf("Called OnPlayerConnect57 for ID ");
  128. PI[id][helm] = strval(field[65]);
  129. printf("Called OnPlayerConnect58 for ID ");
  130. PI[id][backpack] = strval(field[66]);
  131. printf("Called OnPlayerConnect59 for ID ");
  132. PI[id][bp_packs] = strval(field[67]);
  133. printf("Called OnPlayerConnect60 for ID ");
  134. PI[id][bp_drugs] = strval(field[68]);
  135. printf("Called OnPlayerConnect61 for ID ");
  136. PI[id][bp_mats] = strval(field[69]);
  137. printf("Called OnPlayerConnect62 for ID ");
  138.  
  139. PI[id][car1] = strval(field[21]);
  140. printf("Called OnPlayerConnect63 for ID ");
  141. PI[id][car2] = strval(field[22]);
  142. printf("Called OnPlayerConnect64 for ID ");
  143. PI[id][car3] = strval(field[24]);
  144. printf("Called OnPlayerConnect65 for ID ");
  145. PI[id][car4] = strval(field[53]);
  146. printf("Called OnPlayerConnect66 for ID ");
  147.  
  148. mysql_free_result();
  149. printf("Called OnPlayerConnect67 for ID ");
  150. if(strlen(field[38]) > 1)
  151. {
  152. SetPlayerWantedLevel(id, strval(field[38][0]));
  153. xnrSetCrimeDelay(id);
  154. }
  155.  
  156. printf("Called OnPlayerConnect68 for ID ");
  157.  
  158.  
  159. if(PI[id][fraktion] == 6)
  160. PI[id][handyst] = 0;
  161. printf("Called OnPlayerConnect69 for ID ");
  162.  
  163. if(PI[id][donator] != 0 && !PI[id][car4])
  164. PI[id][car4] = -1;
  165. printf("Called OnPlayerConnect70 for ID ");
  166. format(q, 256, "SELECT n FROM newsteam WHERE n = '%s'", GetPname(id));
  167. mysql_query(q);
  168. mysql_store_result();
  169. if(mysql_num_rows() > 0)
  170. PI[id][news] = 1;
  171. mysql_free_result();
  172. return 1;
  173. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement