Advertisement
Guest User

Untitled

a guest
Dec 27th, 2010
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.52 KB | None | 0 0
  1. ----------------------------------------------20 last lines in DB
  2. [14:05:48] >> mysql_query( Connection handle: 1 )
  3. [14:05:48] CMySQLHandler::Query(UPDATE WeaponsAmmo SET Weapon1=0,Weapon2=0,Weapon3=0,Weapon4=0,Weapon5=0,Weapon6=0,Weapon7=0,Weapon8=0,Weapon9=0,Weapon10=0,Weapon11=0,Weapon12=0, Weapon13=0 WHERE Name = 'Bryan Sikro') - An error has occured. (Error ID: 1146, Table 'loyd_db.WeaponsAmmo' doesn't exist)
  4. [14:05:48] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
  5. [14:05:48] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
  6. [14:06:28] >> mysql_query( Connection handle: 1 )
  7. [14:06:28] CMySQLHandler::Query(SELECT * FROM Accounts WHERE Name = 'Chris Loyd') - Successfully executed.
  8. [14:06:28] >> mysql_store_result( Connection handle: 1 )
  9. [14:06:28] CMySQLHandler::StoreResult() - Result was stored.
  10. [14:06:28] >> mysql_num_rows( Connection handle: 1 )
  11. [14:06:28] CMySQLHandler::NumRows() - Returned 0 row(s)
  12. [14:06:28] >> mysql_num_rows( Connection handle: 1 )
  13. [14:06:28] CMySQLHandler::NumRows() - Returned 0 row(s)
  14. [14:06:28] >> mysql_free_result( Connection handle: 1 )
  15. [14:06:28] CMySQLHandler::FreeResult() - Result was successfully free'd.
  16. [14:06:32] >> mysql_ping( Connection handle: 1 )
  17. [14:06:32] CMySQLHandler::Ping() - Connection is still alive.
  18. [14:07:38] >> mysql_ping( Connection handle: 1 )
  19. [14:07:38] CMySQLHandler::Ping() - Connection is still alive.
  20.  
  21. -- SCRIPT
  22.  
  23. function AddAccount(name[],password[]) {
  24. mysql_real_escape_string(password, SQLEscape[Escape][0]);
  25. format(string,sizeof(string), "INSERT INTO Accounts (Name, Password, AdminLevel, Money, Bank, Faction, Rank, HouseKey, BizKey, Skin, Spawn1, Spawn2, Spawn3, Spawn4, Spawn5, Reg, Sex, Wallet, Renting, PhoneNumber, Minutes, Cell) VALUES('%s',md5('%s'), 0,0,0,999,999,999,999,101, 1981.7389,-1962.9572,16.6941, 359.3499, 0,0, 300, 0,-1,0, 0, 1)",
  26. name, SQLEscape[Escape][0]);
  27. mysql_query(string);
  28. format(string,sizeof(string), "INSERT INTO Weapons (Name) VALUES('%s')", name);
  29. mysql_query(string);
  30.  
  31. format(string,sizeof(string), "INSERT INTO WeaponsAmmo (Name) VALUES('%s')", name);
  32. mysql_query(string);
  33.  
  34. format(string,sizeof(string), "INSERT INTO Drugs (Name) VALUES('%s')", name);
  35. mysql_query(string);
  36.  
  37. for(new i = 0; i < 10; i ++ ) {
  38. format(string,sizeof(string), "INSERT INTO phone_contacts (Name) VALUES('%s')", name);
  39. mysql_query(string);
  40. }
  41.  
  42. format(string,sizeof(string), "INSERT INTO scholarships (Name) VALUES('%s')", name);
  43. mysql_query(string);
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement