MySQL problem
#1

I`m using ModernTopia GameMod and i have a mysql problem. If i make an player GM/Tester, i can find in DataBase at GMLevel 1, but after restart, i will find 0. So, after restart, GM level doesn't save, just Admin Level.
Reply
#2

Check your MySQL Log for errors or just post it here and as far as I know that script uses an outdated plugin too.
Reply
#3

Give us your SAVE function...
Reply
#4

Код:
101227 19:26:25 [Note] Plugin 'FEDERATED' is disabled.
101227 19:26:26  InnoDB: Started; log sequence number 0 46409
101227 19:26:26 [Note] Event Scheduler: Loaded 0 events
101227 19:26:26 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
101228 13:07:22 [Note] wampmysqld: Normal shutdown

101228 13:07:22 [Note] Event Scheduler: Purging the queue. 0 events
101228 13:07:22  InnoDB: Starting shutdown...
101228 13:07:24  InnoDB: Shutdown completed; log sequence number 0 46409
101228 13:07:24 [Warning] Forcing shutdown of 1 plugins
101228 13:07:24 [Note] wampmysqld: Shutdown complete

101228 16:20:26 [Note] Plugin 'FEDERATED' is disabled.
101228 16:20:26  InnoDB: Started; log sequence number 0 46409
101228 16:20:26 [Note] Event Scheduler: Loaded 0 events
101228 16:20:26 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
                                                                                                                                                                                                                                                                                                                                                                     101228 20:43:12 [Note] Plugin 'FEDERATED' is disabled.
101228 20:43:12  InnoDB: Started; log sequence number 0 46409
101228 20:43:12 [Note] Event Scheduler: Loaded 0 events
101228 20:43:12 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
101230 18:32:03 [Note] wampmysqld: Normal shutdown

101230 18:32:03 [Note] Event Scheduler: Purging the queue. 0 events
101230 18:32:03  InnoDB: Starting shutdown...
101230 18:32:04  InnoDB: Shutdown completed; log sequence number 0 46409
101230 18:32:04 [Warning] Forcing shutdown of 1 plugins
101230 18:32:04 [Note] wampmysqld: Shutdown complete

101230 20:02:14 [Note] Plugin 'FEDERATED' is disabled.
101230 20:02:14  InnoDB: Started; log sequence number 0 46409
101230 20:02:14 [Note] Event Scheduler: Loaded 0 events
101230 20:02:15 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110102 11:36:21 [Note] Plugin 'FEDERATED' is disabled.
110102 11:36:21  InnoDB: Started; log sequence number 0 46409
110102 11:36:21 [Note] Recovering after a crash using mysql-bin
110102 11:36:32 [Note] Starting crash recovery...
110102 11:36:32 [Note] Crash recovery finished.
110102 11:36:32 [Note] Event Scheduler: Loaded 0 events
110102 11:36:32 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110102 14:46:18 [Note] wampmysqld: Normal shutdown

110102 14:46:18 [Note] Event Scheduler: Purging the queue. 0 events
110102 14:46:18  InnoDB: Starting shutdown...
110102 14:46:19  InnoDB: Shutdown completed; log sequence number 0 46409
110102 14:46:19 [Warning] Forcing shutdown of 1 plugins
110102 14:46:19 [Note] wampmysqld: Shutdown complete

110103 12:09:56 [Note] Plugin 'FEDERATED' is disabled.
110103 12:09:56  InnoDB: Started; log sequence number 0 46409
110103 12:09:56 [Note] Event Scheduler: Loaded 0 events
110103 12:09:56 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110103 13:05:37 [Note] wampmysqld: Normal shutdown

110103 13:05:37 [Note] Event Scheduler: Purging the queue. 0 events
110103 13:05:39  InnoDB: Starting shutdown...
110103 13:05:40  InnoDB: Shutdown completed; log sequence number 0 46409
110103 13:05:40 [Warning] Forcing shutdown of 1 plugins
110103 13:05:40 [Note] wampmysqld: Shutdown complete

110103 13:06:21 [Note] Plugin 'FEDERATED' is disabled.
110103 13:06:21  InnoDB: Started; log sequence number 0 46409
110103 13:06:21 [Note] Event Scheduler: Loaded 0 events
110103 13:06:21 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110103 20:24:51 [Note] wampmysqld: Normal shutdown

110103 20:24:51 [Note] Event Scheduler: Purging the queue. 0 events
110103 20:24:51  InnoDB: Starting shutdown...
110103 20:24:52  InnoDB: Shutdown completed; log sequence number 0 46409
110103 20:24:52 [Warning] Forcing shutdown of 1 plugins
110103 20:24:52 [Note] wampmysqld: Shutdown complete

110103 22:50:59 [Note] Plugin 'FEDERATED' is disabled.
110103 22:51:00  InnoDB: Started; log sequence number 0 46409
110103 22:51:00 [Note] Event Scheduler: Loaded 0 events
110103 22:51:00 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110104 19:34:21 [Note] wampmysqld: Normal shutdown

110104 19:34:21 [Note] Event Scheduler: Purging the queue. 0 events
110104 19:34:21  InnoDB: Starting shutdown...
110104 19:34:22  InnoDB: Shutdown completed; log sequence number 0 46409
110104 19:34:22 [Warning] Forcing shutdown of 1 plugins
110104 19:34:22 [Note] wampmysqld: Shutdown complete

110104 19:56:53 [Note] Plugin 'FEDERATED' is disabled.
110104 19:56:53  InnoDB: Started; log sequence number 0 46409
110104 19:56:54 [Note] Event Scheduler: Loaded 0 events
110104 19:56:54 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110105 16:26:05 [Note] wampmysqld: Normal shutdown

110105 16:26:05 [Note] Event Scheduler: Purging the queue. 0 events
110105 16:26:05  InnoDB: Starting shutdown...
110105 16:26:05  InnoDB: Shutdown completed; log sequence number 0 46409
110105 16:26:05 [Warning] Forcing shutdown of 1 plugins
110105 16:26:05 [Note] wampmysqld: Shutdown complete

110105 19:32:00 [Note] Plugin 'FEDERATED' is disabled.
110105 19:32:00  InnoDB: Started; log sequence number 0 46409
110105 19:32:00 [Note] Event Scheduler: Loaded 0 events
110105 19:32:00 [Note] wampmysqld: ready for connections.
Version: '5.1.36-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
And the save function:
[pwn]
PlayerInfo[para1][pGM] = level;
MySQLUpdatePlayerIntSingle(para1, "GMLevel", level);
[/pwn]
Reply
#5

Help me.
Reply
#6

So... ?
Reply
#7

I resolved this thing.. I need help here: https://sampforum.blast.hk/showthread.php?tid=207996 ..

Need closed!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)